eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_PENDING_DATA_API dependencies on HR_UTILITY

Line 91: hr_utility.set_location('Entering:'|| l_proc, 10);

87: from fnd_user
88: where user_name = upper(p_email_address);
89: --
90: begin
91: hr_utility.set_location('Entering:'|| l_proc, 10);
92: --
93: -- Issue a savepoint
94: --
95: savepoint CREATE_PENDING_DATA;

Line 174: hr_utility.set_location(l_proc,20);

170: -- Process Logic
171: --
172: if p_user_password is not null then
173: l_num := irc_party_api.testusername(p_user_name=>p_email_address);
174: hr_utility.set_location(l_proc,20);
175: if l_num = 0 then
176: --
177: --Create new fnd_user
178: --

Line 186: hr_utility.set_location(l_proc,30);

182: ,x_unencrypted_password => p_user_password
183: ,x_email_address => p_email_address
184: ,x_password_date => sysdate
185: );
186: hr_utility.set_location(l_proc,30);
187: else
188: fnd_message.set_name('PER','IRC_EMAIL_ALREADY_REGISTERED');
189: fnd_message.set_token('USER_NAME',p_email_address);
190: fnd_message.raise_error;

Line 333: hr_utility.set_location(' Leaving:'||l_proc, 70);

329: -- Set all OUT parameters with out values
330: --
331: p_pending_data_id := l_pending_data_id;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 70);
334: exception
335: when hr_api.validate_enabled then
336: --
337: -- As the Validate_Enabled exception has been raised

Line 347: hr_utility.set_location(' Leaving:'||l_proc, 80);

343: -- (Any key or derived arguments must be set to null
344: -- when validation only mode is being used.)
345: --
346: p_pending_data_id := null;
347: hr_utility.set_location(' Leaving:'||l_proc, 80);
348: when others then
349: --
350: -- A validation or unexpected error has occured
351: --

Line 358: hr_utility.set_location(' Leaving:'||l_proc, 90);

354: -- Reset IN OUT parameters and set all
355: -- OUT parameters, including warnings, to null
356: --
357: p_pending_data_id := null;
358: hr_utility.set_location(' Leaving:'||l_proc, 90);
359: raise;
360: end CREATE_PENDING_DATA;
361: --
362: -- ----------------------------------------------------------------------------

Line 432: hr_utility.set_location('Entering:'|| l_proc, 10);

428: l_creation_date date;
429: l_last_update_date date;
430: l_proc varchar2(72) := g_package||'UPDATE_PENDING_DATA';
431: begin
432: hr_utility.set_location('Entering:'|| l_proc, 10);
433: --
434: -- Issue a savepoint
435: --
436: savepoint UPDATE_PENDING_DATA;

Line 646: hr_utility.set_location(' Leaving:'||l_proc, 70);

642: if p_validate then
643: raise hr_api.validate_enabled;
644: end if;
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 70);
647: exception
648: when hr_api.validate_enabled then
649: --
650: -- As the Validate_Enabled exception has been raised

Line 655: hr_utility.set_location(' Leaving:'||l_proc, 80);

651: -- we must rollback to the savepoint
652: --
653: rollback to UPDATE_PENDING_DATA;
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 80);
656: when others then
657: --
658: -- A validation or unexpected error has occured
659: --

Line 665: hr_utility.set_location(' Leaving:'||l_proc, 90);

661: --
662: -- Reset IN OUT parameters and set all
663: -- OUT parameters, including warnings, to null
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 90);
666: raise;
667: end UPDATE_PENDING_DATA;
668: --
669: -- ----------------------------------------------------------------------------

Line 682: hr_utility.set_location('Entering:'|| l_proc, 10);

678: -- Declare cursors and local variables
679: --
680: l_proc varchar2(72) := g_package||'DELETE_PENDING_DATA';
681: begin
682: hr_utility.set_location('Entering:'|| l_proc, 10);
683: --
684: -- Issue a savepoint
685: --
686: savepoint DELETE_PENDING_DATA;

Line 728: hr_utility.set_location(' Leaving:'||l_proc, 70);

724: if p_validate then
725: raise hr_api.validate_enabled;
726: end if;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 70);
729: exception
730: when hr_api.validate_enabled then
731: --
732: -- As the Validate_Enabled exception has been raised

Line 737: hr_utility.set_location(' Leaving:'||l_proc, 80);

733: -- we must rollback to the savepoint
734: --
735: rollback to DELETE_PENDING_DATA;
736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 80);
738: when others then
739: --
740: -- A validation or unexpected error has occured
741: --

Line 744: hr_utility.set_location(' Leaving:'||l_proc, 90);

740: -- A validation or unexpected error has occured
741: --
742: rollback to DELETE_PENDING_DATA;
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 90);
745: raise;
746: end DELETE_PENDING_DATA;
747: --
748: -- ----------------------------------------------------------------------------

Line 967: hr_utility.set_location('Entering:'|| l_proc, 10);

963: AND pra.recruiting_site_id = ias.recruiting_site_id and ias.internal='Y'
964: and pav.vacancy_id = p_vacancy_id;
965: --
966: begin
967: hr_utility.set_location('Entering:'|| l_proc, 10);
968: --
969: for l_data in csr_get_data loop
970: --
971: if l_data.user_id is null then

Line 993: hr_utility.set_location('Call to apps initialise'|| l_proc, 15);

989: open csr_get_server_id;
990: fetch csr_get_server_id into l_server_id;
991: close csr_get_server_id;
992: --
993: hr_utility.set_location('Call to apps initialise'|| l_proc, 15);
994: if l_server_id is null then
995: fnd_global.apps_initialize
996: (user_id => l_user_id
997: ,resp_id => l_resp_id

Line 1024: hr_utility.set_location(l_proc, 20);

1020: open csr_get_resp_id(l_resp_key);
1021: fetch csr_get_resp_id into l_irc_resp_id,l_irc_resp_appl_id;
1022: close csr_get_resp_id;
1023: --
1024: hr_utility.set_location(l_proc, 20);
1025: --
1026: -- Fetch the registration business group
1027: --
1028: l_reg_bg_id := fnd_profile.value('IRC_REGISTRATION_BG_ID');

Line 1098: hr_utility.set_location(l_proc,40);

1094: where user_name = upper(l_data.email_address);
1095: --
1096: -- update pending data row to have the person_id
1097: --
1098: hr_utility.set_location(l_proc,40);
1099: update irc_pending_data
1100: set person_id = l_person_id
1101: ,last_update_date = trunc(sysdate)
1102: where pending_data_id = l_data.pending_data_id;

Line 1108: hr_utility.set_location(l_proc, 45);

1104: Fnd_file.put_line(FND_FILE.LOG,'Updated irc_pending_data with person_id:'||l_person_id);
1105: --
1106: -- create/update documents for users who have uploaded their resumes
1107: --
1108: hr_utility.set_location(l_proc, 45);
1109: open csr_get_resume(l_data.pending_data_id);
1110: fetch csr_get_resume into
1111: l_resume_file_name
1112: ,l_resume_description

Line 1134: hr_utility.set_location(l_proc,50);

1130: l_doc_party_id := null;
1131: end if;
1132: close csr_get_resume;
1133: --
1134: hr_utility.set_location(l_proc,50);
1135: --
1136: if l_resume_file_name is not null then
1137: if l_document_id is not null then
1138: hr_utility.set_location(l_proc, 55);

Line 1138: hr_utility.set_location(l_proc, 55);

1134: hr_utility.set_location(l_proc,50);
1135: --
1136: if l_resume_file_name is not null then
1137: if l_document_id is not null then
1138: hr_utility.set_location(l_proc, 55);
1139: Fnd_file.put_line(FND_FILE.LOG,'Updating resume document for the Candidate: '||l_resume_file_name||': document_id='||l_document_id);
1140: irc_document_api.update_document_track
1141: (p_effective_date => l_data.creation_date
1142: ,p_document_id => l_document_id

Line 1159: hr_utility.set_location(l_proc, 60);

1155: If l_document_id <> l_new_doc_id then
1156: Fnd_file.put_line(FND_FILE.LOG,'Created Resume document for the Candidate:'||l_new_doc_id);
1157: end if;
1158: else
1159: hr_utility.set_location(l_proc, 60);
1160: Fnd_file.put_line(FND_FILE.LOG,'Creating resume document for the Candidate: '||l_resume_file_name);
1161: irc_document_api.create_document
1162: (p_effective_date => l_data.creation_date
1163: ,p_type => 'RESUME'

Line 1174: hr_utility.set_location(l_proc, 65);

1170: );
1171: Fnd_file.put_line(FND_FILE.LOG,'Created new Resume document for the Candidate:'||l_resume_file_name);
1172: end if;
1173: end if;
1174: hr_utility.set_location(l_proc, 65);
1175: if l_new_doc_id is not null then
1176: update irc_documents set binary_doc=l_resume
1177: where document_id = l_new_doc_id;
1178: irc_document_api.process_document(l_new_doc_id);

Line 1181: hr_utility.set_location(l_proc, 70);

1177: where document_id = l_new_doc_id;
1178: irc_document_api.process_document(l_new_doc_id);
1179: end if;
1180: --
1181: hr_utility.set_location(l_proc, 70);
1182: if l_data.vacancy_id is not null then
1183: -- fix for bug 4046889
1184: -- check if this Person is an Employee and if he is applying for an
1185: -- External vacancy

Line 1192: hr_utility.set_location(l_proc, 72);

1188: if (l_person_type = 'EMP') then
1189: open csr_is_internal_vacancy(l_data.vacancy_id, trunc(l_data.creation_date));
1190: fetch csr_is_internal_vacancy into l_num;
1191: if csr_is_internal_vacancy%notfound then
1192: hr_utility.set_location(l_proc, 72);
1193: close csr_is_internal_vacancy;
1194: Fnd_file.put_line(FND_FILE.LOG,'Employee cannot apply for External Vacancy:'||l_data.vacancy_id);
1195: hr_utility.set_message(800,'IRC_412140_JOB_NOT_AVAILABLE');
1196: hr_utility.raise_error;

Line 1195: hr_utility.set_message(800,'IRC_412140_JOB_NOT_AVAILABLE');

1191: if csr_is_internal_vacancy%notfound then
1192: hr_utility.set_location(l_proc, 72);
1193: close csr_is_internal_vacancy;
1194: Fnd_file.put_line(FND_FILE.LOG,'Employee cannot apply for External Vacancy:'||l_data.vacancy_id);
1195: hr_utility.set_message(800,'IRC_412140_JOB_NOT_AVAILABLE');
1196: hr_utility.raise_error;
1197: else
1198: close csr_is_internal_vacancy;
1199: end if;

Line 1196: hr_utility.raise_error;

1192: hr_utility.set_location(l_proc, 72);
1193: close csr_is_internal_vacancy;
1194: Fnd_file.put_line(FND_FILE.LOG,'Employee cannot apply for External Vacancy:'||l_data.vacancy_id);
1195: hr_utility.set_message(800,'IRC_412140_JOB_NOT_AVAILABLE');
1196: hr_utility.raise_error;
1197: else
1198: close csr_is_internal_vacancy;
1199: end if;
1200: end if;

Line 1215: hr_utility.set_location(l_proc,75);

1211: -- make this value as NULL because we are in a loop and if in the
1212: -- first loop we have a valid value and in second loop we have to
1213: -- clear it otherwise we send the value in first loop
1214: l_emp_number:=null;
1215: hr_utility.set_location(l_proc,75);
1216: end if;
1217:
1218: /* process the vacancy application. We create a new user if needed in
1219: Vacancy BG and then update person record with EEO information

Line 1226: hr_utility.set_location(l_proc, 80);

1222: these API calls are present in PerAllPeopleFEOImpl.java */
1223:
1224: select per_assignments_s.nextval into l_applicant_assg_id from dual;
1225:
1226: hr_utility.set_location(l_proc, 80);
1227:
1228: l_per_ovn := null;
1229: l_asg_ovn := null;
1230: l_applicant_number := null;

Line 1239: hr_utility.set_location(l_proc, 82);

1235: --
1236: open csr_job_applied_for(l_person_id, l_data.vacancy_id);
1237: fetch csr_job_applied_for into l_num;
1238: if csr_job_applied_for%found then
1239: hr_utility.set_location(l_proc, 82);
1240: close csr_job_applied_for;
1241: Fnd_file.put_line(FND_FILE.LOG,'Already applied for job:'||l_data.vacancy_id);
1242: hr_utility.set_message(800,'IRC_APL_ALREADY_APPLIED');
1243: hr_utility.raise_error;

Line 1242: hr_utility.set_message(800,'IRC_APL_ALREADY_APPLIED');

1238: if csr_job_applied_for%found then
1239: hr_utility.set_location(l_proc, 82);
1240: close csr_job_applied_for;
1241: Fnd_file.put_line(FND_FILE.LOG,'Already applied for job:'||l_data.vacancy_id);
1242: hr_utility.set_message(800,'IRC_APL_ALREADY_APPLIED');
1243: hr_utility.raise_error;
1244: else
1245: close csr_job_applied_for;
1246: end if;

Line 1243: hr_utility.raise_error;

1239: hr_utility.set_location(l_proc, 82);
1240: close csr_job_applied_for;
1241: Fnd_file.put_line(FND_FILE.LOG,'Already applied for job:'||l_data.vacancy_id);
1242: hr_utility.set_message(800,'IRC_APL_ALREADY_APPLIED');
1243: hr_utility.raise_error;
1244: else
1245: close csr_job_applied_for;
1246: end if;
1247: end if;

Line 1264: hr_utility.set_location(l_proc, 83);

1260: ,p_applicant_number => l_applicant_number
1261: );
1262: Fnd_file.put_line(FND_FILE.LOG,'Applied successfully for vacancy:'||l_data.vacancy_id);
1263: --
1264: hr_utility.set_location(l_proc, 83);
1265: hr_person_api.update_person
1266: (p_effective_date => l_data.creation_date
1267: ,p_person_id => l_applicant_person_id
1268: ,p_datetrack_update_mode => 'CORRECTION'

Line 1318: hr_utility.set_location(l_proc, 90);

1314: );
1315: Fnd_file.put_line(FND_FILE.LOG,'Updated person record with EEO information');
1316: close csr_get_person_id_in_vac_bg;
1317: end if;
1318: hr_utility.set_location(l_proc, 90);
1319: --
1320: -- Update the processed status to 'A'
1321: --
1322: update irc_pending_data

Line 1343: hr_utility.set_location('Leaving '||l_proc, 100);

1339: ,ipd.error_message=l_msg
1340: ,ipd.last_update_date=trunc(sysdate)
1341: where ipd.pending_data_id=l_data.pending_data_id;
1342: Fnd_file.put_line(FND_FILE.LOG,'An error occurred--'||l_err_msg);
1343: hr_utility.set_location('Leaving '||l_proc, 100);
1344: commit;
1345: end;
1346: end loop;
1347: end PROCESS_APPLICATIONS;

Line 1419: hr_utility.set_location('Entering '||l_proc, 10);

1415: com_rows := 1;
1416: vac_rows1 := 1;
1417: com_rows1 := 1;
1418: --
1419: hr_utility.set_location('Entering '||l_proc, 10);
1420: Fnd_file.put_line(FND_FILE.LOG,'Sending Notifications');
1421: --
1422: /* Process the pending data records having statuses 'A','R','E' or 'F'
1423: and having vacancy_id populated. For each of the records build the HTML

Line 1429: hr_utility.set_location(l_proc, 20);

1425: Successful completion would set the processed status to 'S' */
1426: for l_applied_data in csr_get_applied_vacancies loop
1427: --
1428: Fnd_file.put_line(FND_FILE.LOG,'Checking the row with email_address: '||l_applied_data.email_address||' and pending_data_id '||l_applied_data.pending_data_id);
1429: hr_utility.set_location(l_proc, 20);
1430: --
1431: if l_applied_data.email_address <> l_curr_email
1432: and (l_success_vacancies_list.exists(1)
1433: or l_failed_vacancies_list.exists(1) ) then

Line 1435: hr_utility.set_location(l_proc, 25);

1431: if l_applied_data.email_address <> l_curr_email
1432: and (l_success_vacancies_list.exists(1)
1433: or l_failed_vacancies_list.exists(1) ) then
1434: --
1435: hr_utility.set_location(l_proc, 25);
1436: Fnd_file.put_line(FND_FILE.LOG,'Building the notification text for '||l_curr_email);
1437: --
1438: -- Registration confirmation message to be shown to new users only
1439: --

Line 1557: hr_utility.set_location(l_proc, 30);

1553: || '
';
1554: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1555: || '\n';
1556: --
1557: hr_utility.set_location(l_proc, 30);
1558: --
1559: -- Notify with different subjects for a new user and existing user
1560: --
1561: if csr_is_new_user%found then

Line 1760: hr_utility.set_location(l_proc, 70);

1756: || '\n';
1757: --
1758: if l_success_vacancies_list.exists(1) or
1759: l_failed_vacancies_list.exists(1) then
1760: hr_utility.set_location(l_proc, 70);
1761: --
1762: -- Notify with different subjects for a new user and existing user
1763: --
1764: if csr_is_new_user%found then

Line 1788: hr_utility.set_location('Leaving '||l_proc, 80);

1784: end if;
1785: commit;
1786: end if;
1787: end if;
1788: hr_utility.set_location('Leaving '||l_proc, 80);
1789: end send_notifications;
1790: --
1791: end IRC_PENDING_DATA_API;