Who's Online Now
0 registered members (), 3 guests, and 14 spiders.
Key: Admin, Global Mod, Mod
Newest Members
mahesh kumar, Arundevaa B, NickyMcQ, dartdeena, jebaneesa
1240 Registered Users
Recent Posts
Setting up RTI for XML
by delboy. 15/06/17 05:31 AM
Top Posters(30 Days)
delboy 1
Popular Topics(Views)
396,202 PAYE RTI
47,672 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
Page 1 of 4 1 2 3 4
#3406 - 27/07/08 12:55 PM CREATE_GRADE api returns:PLS-00306: wrong number o  
Joined: May 2008
Posts: 82
tovia123 Offline
hacker
tovia123  Offline
hacker

Joined: May 2008
Posts: 82
UK
Hi

I have created a package to load grades information as per code:
http://pastebin.com/m57c2146f

Data in my temporary table(currently loading 1st record only for testing!):
http://pastebin.com/m681542e3

The data in my table in sql :
Name Null? Type
----------------------------------------- -------- -----
SEQUENCE NUMBER
NAME VARCHAR2(70)
HEALTHCARE_SERVICE VARCHAR2(80)
DEATH_SERVICE VARCHAR2(70)
LONG_DISABILITY VARCHAR2(70)
MOBILE_PHONE VARCHAR2(5)
HOLIDAY_ENTITLEMENT NUMBER(5)
STD_PROBATION NUMBER(5)
STD_NOTICE NUMBER(5)
REPORTED_AS VARCHAR2(30)
PAYCODE VARCHAR2(5)
INCENTIVE_SCHEME VARCHAR2(20)
FLEX_BENEFIT VARCHAR2(20)

Also: I have removed all the value sets for the descriptive flexfield under:
Application > flexfield > Descriptive > segments

and i have successfully inserted the record manually by cutting and pasting field values from my data file!

So in SQL*PLUS: Why does it still complain of this:

Problem:
I am getting error:
LINE/COL ERROR
-----------------------------------------------------------------
71/1 PLS-00306: wrong number or types of arguments in call to
'CREATE_GRADE'

I went to line 71 within the file in notepad and i didnt find anything i am confused.

Thanks in advance

Tovia singer


#3407 - 27/07/08 07:59 PM Re: CREATE_GRADE api returns:PLS-00306: wrong number o [Re: tovia123]  
Joined: Mar 2005
Posts: 2,063
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,063
Tovia

I would reckon it's objecting to your omission of the p_grade_id output parameter from the parameter list.



CT
#3408 - 28/07/08 08:14 AM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: CT]  
Joined: May 2008
Posts: 82
tovia123 Offline
hacker
tovia123  Offline
hacker

Joined: May 2008
Posts: 82
UK
HI CT

Thanks so much

I added p_grade_id:=v_grade_id;
and it compiled successfull but didnt create any records, so i checked the commit, and it was in the place same place as in my jobs api call.
Also checked the application and there where no grades so it shouldnt have any problem loading them.

My data file is:
http://pastebin.com/m2bce6d4a

There should be an error if it doesnt load the data i dont understand!

Thanks in advance

Tovia Singer

#3409 - 28/07/08 11:22 AM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: tovia123]  
Joined: Mar 2005
Posts: 2,063
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,063
So what gets reported when you run it? Presumably you get a load of lines in your 'dbms_output' destination that show

'Ex:<grade_id>,<object_version_number>'

What are the actual numbers being returned, if any?


CT
#3410 - 28/07/08 12:21 PM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: CT]  
Joined: May 2008
Posts: 82
tovia123 Offline
hacker
tovia123  Offline
hacker

Joined: May 2008
Posts: 82
UK
Hi CT

Basically i set serverouput on:
set serveroutput on size 20000;

But i still get the following output:

SQL> @XXcompany_INT_GRADES_LOAD

Package created.

No errors.

Package body created.

No errors.

The revised code with p_grade_id:
http://pastebin.com/m5fc0c461

Thanks in advance

Tovia

#3411 - 28/07/08 12:53 PM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: tovia123]  
Joined: Mar 2005
Posts: 2,063
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,063
OK so it compiles, but what happens when you run it?


CT
#3412 - 28/07/08 01:17 PM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: CT]  
Joined: May 2008
Posts: 82
tovia123 Offline
hacker
tovia123  Offline
hacker

Joined: May 2008
Posts: 82
UK
HI CT

Sorry:

SQL> execute XXcompany_PKG_GRADES.XXcompany_LOAD_GRADES;
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,

PL/SQL procedure successfully completed.

And it doesnt actually load any data,

Thanks in advance

Tovia S

#3413 - 28/07/08 01:44 PM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: tovia123]  
Joined: Mar 2005
Posts: 2,063
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,063
Could it be that the only reason you're not seeing exceptions is because you are trying to report them via the FND_FILE package, which really only works if you're running this from the conc. manager. As a temporary measure, can you change the FND_FILE references to DBMS_OUTPUT.put_line and re-run it? Also, I would say in the latest version of your script, you might benefit from moving the line of code currently at line 128:

DBMS_OUTPUT.PUT_LINE('Ex:'||v_grade_id||','||v_object_version_number);

to immediately *after* the api call, e.g. at line 119 (to quote the numbers from your Pastebin listing)



CT
#3414 - 28/07/08 06:04 PM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: CT]  
Joined: May 2008
Posts: 82
tovia123 Offline
hacker
tovia123  Offline
hacker

Joined: May 2008
Posts: 82
UK
Hi CT

Sorry for the delay in feedback,

I did as you said above:

Latest code:
http://pastebin.com/m2c1dff1d

The feedback from/ error in sql:

SQL> execute XXcompany_PKG_GRADES.XXcompany_LOAD_GRA
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
PL/SQL procedure successfully completed.
SQL>

Thanks in advance

Tovia Singer

#3416 - 28/07/08 06:58 PM Re: CREATE_GRADE api returns:PLS-00306: wrong numb [Re: tovia123]  
Joined: Mar 2005
Posts: 2,063
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,063
Ah, this is of course a problem you will have seen before, in your 'job loading' process (see separate thread)

Recall that the text associated with this message code is "ID &ID for the flexfield segment &SEGMENT does not exist in the value set &VALUESET." In other words, you still have a valueset in place somewhere that is not liking the data you're trying to send to a desc flex segment.


CT
Page 1 of 4 1 2 3 4

Moderated by  Administrator, Geoff Dixon 

Forum Statistics
Forums48
Topics2,172
Posts11,744
Members1,241
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,063
bcooper 1,279
delboy 1,226
paulgos 423
SBi 412
Gus 252
pat 246
vkumar 223
June
S M T W T F S
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.032s Queries: 16 (0.011s) Memory: 2.8073 MB (Peak: 3.0064 MB) Zlib disabled. Server Time: 2017-06-26 06:58:07 UTC