HR_APPLICANT_API.CREAE_APPLICANT

[Yasser_Afifi]

am trying to Create Applicant Using HR_APPLICANT_API.CREAE_APPLICANT, I am getting an Error:

ORA-06512: at "APPS.HR_UTILITY", line 903ORA-06512: at "APPS.PER_ALL_PEOPLE_F_ARIU", line 219ORA-04088: error during execution of trigger 'APPS.PER_ALL_PEOPLE_F_ARIU'


Anyone has an Idea.

The Code is:


Declare

V_PERSON_ID NUMBER;
V_ASSIGNMENT_ID NUMBER;
V_APPLICATION_ID NUMBER;
V_PER_OBJECT_VERSION_NUMBER NUMBER;
V_ASG_OBJECT_VERSION_NUMBER NUMBER;
V_APL_OBJECT_VERSION_NUMBER NUMBER;
V_PER_EFFECTIVE_START_DATE DATE;
V_PER_EFFECTIVE_END_DATE DATE;
V_FULL_NAME VARCHAR2(500);
V_PER_COMMENT_ID NUMBER;
V_ASSIGNMENT_SEQUENCE NUMBER;
V_NAME_COMBINATION_WARNING BOOLEAN;
V_ORIG_HIRE_WARNING BOOLEAN;

L_APPLICANT_NUMBER VARCHAR2(30) := NULL;

l_dummy_line_id varchar2(1000);

Begin

Begin
SELECT next_value - 1
INTO l_applicant_number
FROM per_number_generation_controls
WHERE business_group_id = 1
AND type = 'APL';
End;

BEGIN
HR_APPLICANT_API.CREATE_APPLICANT(
P_VALIDATE => FALSE,
P_DATE_RECEIVED => to_date('01-DEC-2011'),
P_BUSINESS_GROUP_ID => 1,
P_LAST_NAME => 'AFIFII',
P_PERSON_TYPE_ID => 22,
P_APPLICANT_NUMBER => L_APPLICANT_NUMBER, --IN OUT VARCHAR2,
P_DATE_OF_BIRTH => to_date('01-JAN-1990'),
P_FIRST_NAME => 'YASSERR',
P_MARITAL_STATUS => 'M',
P_MIDDLE_NAMES => 'SAYEDD',
P_NATIONALITY => 'BAHR',
P_NATIONAL_IDENTIFIER => '323323323',
P_*** => 'M',
P_TITLE => 'MR.',
/*P_ATTRIBUTE_CATEGORY => NULL,
P_ATTRIBUTE1 => NULL,
P_ATTRIBUTE2 => NULL,
P_ATTRIBUTE3 => NULL,
P_ATTRIBUTE4 => NULL,
P_ATTRIBUTE5 => NULL,
P_ATTRIBUTE6 => NULL,
P_ATTRIBUTE7 => NULL,
P_ATTRIBUTE8 => NULL,
P_ATTRIBUTE9 => NULL,
P_ATTRIBUTE10 => NULL,
P_ATTRIBUTE11 => NULL,
P_ATTRIBUTE12 => NULL,
P_ATTRIBUTE13 => NULL,
P_ATTRIBUTE14 => NULL,
P_ATTRIBUTE15 => NULL,
P_ATTRIBUTE16 => NULL,
P_ATTRIBUTE17 => NULL,
P_ATTRIBUTE18 => NULL,
P_ATTRIBUTE19 => NULL,
P_ATTRIBUTE20 => NULL,
P_ATTRIBUTE21 => NULL,
P_ATTRIBUTE22 => NULL,
P_ATTRIBUTE23 => NULL,
P_ATTRIBUTE24 => NULL,
P_ATTRIBUTE25 => NULL,
P_ATTRIBUTE26 => NULL,
P_ATTRIBUTE27 => NULL,
P_ATTRIBUTE28 => NULL,
P_ATTRIBUTE29 => NULL,
P_ATTRIBUTE30 => NULL,
P_PER_INFORMATION_CATEGORY => NULL,
P_PER_INFORMATION1 => NULL,
P_PER_INFORMATION2 => NULL,
P_PER_INFORMATION3 => NULL,
P_PER_INFORMATION4 => NULL,
P_PER_INFORMATION5 => NULL,
P_PER_INFORMATION6 => NULL,
P_PER_INFORMATION7 => NULL,
P_PER_INFORMATION8 => NULL,
P_PER_INFORMATION9 => NULL,
P_PER_INFORMATION10 => NULL,
P_PER_INFORMATION11 => NULL,
P_PER_INFORMATION12 => NULL,
P_PER_INFORMATION13 => NULL,
P_PER_INFORMATION14 => NULL,
P_PER_INFORMATION15 => NULL,
P_PER_INFORMATION16 => NULL,
P_PER_INFORMATION17 => NULL,
P_PER_INFORMATION18 => NULL,
P_PER_INFORMATION19 => NULL,
P_PER_INFORMATION20 => NULL,
P_PER_INFORMATION21 => NULL,
P_PER_INFORMATION22 => NULL,
P_PER_INFORMATION23 => NULL,
P_PER_INFORMATION24 => NULL,
P_PER_INFORMATION25 => NULL,
P_PER_INFORMATION26 => NULL,
P_PER_INFORMATION27 => NULL,
P_PER_INFORMATION28 => NULL,
P_PER_INFORMATION29 => NULL,
P_PER_INFORMATION30 => NULL, */
P_PERSON_ID => V_PERSON_ID,
P_ASSIGNMENT_ID => V_ASSIGNMENT_ID,
P_APPLICATION_ID => V_APPLICATION_ID,
P_PER_OBJECT_VERSION_NUMBER => V_PER_OBJECT_VERSION_NUMBER,
P_ASG_OBJECT_VERSION_NUMBER => V_ASG_OBJECT_VERSION_NUMBER,
P_APL_OBJECT_VERSION_NUMBER => V_APL_OBJECT_VERSION_NUMBER,
P_PER_EFFECTIVE_START_DATE => V_PER_EFFECTIVE_START_DATE,
P_PER_EFFECTIVE_END_DATE => V_PER_EFFECTIVE_END_DATE,
P_FULL_NAME => V_FULL_NAME,
P_PER_COMMENT_ID => V_PER_COMMENT_ID,
P_ASSIGNMENT_SEQUENCE => V_ASSIGNMENT_SEQUENCE,
P_NAME_COMBINATION_WARNING => V_NAME_COMBINATION_WARNING,
P_ORIG_HIRE_WARNING => V_ORIG_HIRE_WARNING
);
DBMS_OUTPUT.PUT_LINE('SUCCEED');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('EXCEPTION - PERSON_ID = '||V_PERSON_ID ||' APPLICATION_ID ='||V_APPLICATION_ID ||' APPLICANT_NUMBER ='||L_APPLICANT_NUMBER);

hr_batch_message_line_api.create_message_line(p_ba tch_run_number => 111111,
p_api_name => 'hr_applicant_api.create_applicant',
p_status => 'F',
p_error_number => sqlcode,
p_error_message => sqlerrm,
p_extended_error_message => fnd_message.get,
p_source_row_information => '323323323 - PERSON_ID = '||V_PERSON_ID ||' APPLICATION_ID ='||V_APPLICATION_ID ||' APPLICANT_NUMBER ='||L_APPLICANT_NUMBER,
p_line_id => l_dummy_line_id);
END;
COMMIT;
End;

[eng_ahmad_2007]

Try compiling invalid database objects, else, disable the trigger and try running your code again,....

Regards,

Ahmad Ghanem