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_VACANCY_COMMIT dependencies on HR_UTILITY

Line 36: hr_utility.trace('Entering is_error_message');

32: l_error_found boolean := false;
33: --
34: BEGIN
35: --
36: hr_utility.trace('Entering is_error_message');
37: --
38: l_no_of_messages := fnd_msg_pub.count_msg();
39: --
40: hr_utility.trace('Number of messages found :' || to_char(l_no_of_messages) || ':');

Line 40: hr_utility.trace('Number of messages found :' || to_char(l_no_of_messages) || ':');

36: hr_utility.trace('Entering is_error_message');
37: --
38: l_no_of_messages := fnd_msg_pub.count_msg();
39: --
40: hr_utility.trace('Number of messages found :' || to_char(l_no_of_messages) || ':');
41: --
42: while(l_current_no < l_no_of_messages)
43: loop
44: if l_current_no = 0

Line 57: hr_utility.trace('Error message found');

53: --
54: if l_message_type = 'E'
55: then
56: --
57: hr_utility.trace('Error message found');
58: --
59: l_error_found := true;
60: exit;
61: end if;

Line 66: hr_utility.trace('Exiting is_error_message');

62: --
63: l_current_no := l_current_no + 1;
64: end loop;
65: --
66: hr_utility.trace('Exiting is_error_message');
67: --
68: return l_error_found;
69: --
70: end is_error_message;

Line 94: hr_utility.trace('Entering reject_transaction');

90: resultout out nocopy varchar2) is
91: --
92: BEGIN
93: --
94: hr_utility.trace('Entering reject_transaction');
95: --
96: -- Mark Approval as Rejected
97: --
98: -- mmillmor commented out the following to make this compile

Line 109: hr_utility.trace('Exiting reject_transaction');

105: hr_wip_txns.delete_transaction(
106: p_item_type => itemtype
107: ,p_item_key => itemkey);
108: --
109: hr_utility.trace('Exiting reject_transaction');
110: --
111: ----------------------------------------------------------
112: END reject_transaction;
113: ----------------------------------------------------------

Line 155: hr_utility.trace('Entering commit_insert for :' || itemtype || '-' || itemkey || ':');

151: PRAGMA EXCEPTION_INIT(XMLParseError, -20100);
152: --
153: BEGIN
154: --
155: hr_utility.trace('Entering commit_insert for :' || itemtype || '-' || itemkey || ':');
156: --
157: savepoint vacancy_commit;
158: --
159: errorFlag := false;

Line 163: hr_utility.trace('Exiting - Self Approve');

159: errorFlag := false;
160: --
161: if (isSelfApprove(itemtype, itemkey)) then
162: --
163: hr_utility.trace('Exiting - Self Approve');
164: --
165: resultout := 'SELF';
166: return;
167: end if;

Line 175: hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');

171: (itemtype => itemtype,
172: itemkey => itemkey,
173: aname => 'IRC_EFFECTIVE_DATE'), 'YYYY-MM-DD');
174: --
175: hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');
176: --
177: select transaction_id
178: into transaction_number
179: from hr_wip_transactions

Line 185: hr_utility.trace('Transaction Id is :' || transaction_id || ':');

181: and item_type = itemtype;
182: --
183: transaction_id := to_char(transaction_number);
184: --
185: hr_utility.trace('Transaction Id is :' || transaction_id || ':');
186: --
187: select vo_cache
188: into xmlClob
189: from hr_wip_transactions

Line 199: hr_utility.trace('Inserting PER_REQUISITIONS records');

195: xmldoc := xmlparser.getDocument(parser);
196: --
197: l_return_status := 'S';
198: --
199: hr_utility.trace('Inserting PER_REQUISITIONS records');
200: --
201: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRequisitionsVORow');
202: --
203: for j in 1..xmldom.getLength(commitNodes) loop

Line 207: hr_utility.trace('ERROR Inserting PER_REQUISITIONS records');

203: for j in 1..xmldom.getLength(commitNodes) loop
204: commitNode:=xmldom.item(commitNodes,j-1);
205: commit_i_requisition(commitNode, l_return_status);
206: if (l_return_status <> 'S' and is_error_message) then
207: hr_utility.trace('ERROR Inserting PER_REQUISITIONS records');
208: errorFlag := true;
209: end if;
210: end loop;
211: --

Line 212: hr_utility.trace('Inserting IRC_POSTING_CONTENTS records');

208: errorFlag := true;
209: end if;
210: end loop;
211: --
212: hr_utility.trace('Inserting IRC_POSTING_CONTENTS records');
213: --
214: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcPostingContentsVlVORow');
215: --
216: for j in 1..xmldom.getLength(commitNodes) loop

Line 220: hr_utility.trace('ERROR Inserting IRC_POSTING_CONTENTS records');

216: for j in 1..xmldom.getLength(commitNodes) loop
217: commitNode:=xmldom.item(commitNodes,j-1);
218: commit_i_posting_content(commitNode, l_effective_date, l_return_status);
219: if (l_return_status <> 'S' and is_error_message) then
220: hr_utility.trace('ERROR Inserting IRC_POSTING_CONTENTS records');
221: errorFlag := true;
222: end if;
223: end loop;
224: --

Line 225: hr_utility.trace('Inserting PER_ALL_VACANCIES records');

221: errorFlag := true;
222: end if;
223: end loop;
224: --
225: hr_utility.trace('Inserting PER_ALL_VACANCIES records');
226: --
227: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditVacancyVORow');
228: --
229: for j in 1..xmldom.getLength(commitNodes) loop

Line 233: hr_utility.trace('ERROR Inserting PER_ALL_VACANCIES records');

229: for j in 1..xmldom.getLength(commitNodes) loop
230: commitNode:=xmldom.item(commitNodes,j-1);
231: commit_i_vacancy(commitNode, l_effective_date, l_return_status);
232: if (l_return_status <> 'S' and is_error_message) then
233: hr_utility.trace('ERROR Inserting PER_ALL_VACANCIES records');
234: errorFlag := true;
235: end if;
236: end loop;
237: --

Line 238: hr_utility.trace('Inserting IRC_SEARCH_CRITERIA records');

234: errorFlag := true;
235: end if;
236: end loop;
237: --
238: hr_utility.trace('Inserting IRC_SEARCH_CRITERIA records');
239: --
240: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');
241: --
242: for j in 1..xmldom.getLength(commitNodes) loop

Line 246: hr_utility.trace('ERROR Inserting IRC_SEARCH_CRITERIA records');

242: for j in 1..xmldom.getLength(commitNodes) loop
243: commitNode:=xmldom.item(commitNodes,j-1);
244: commit_i_search_criteria(commitNode, l_effective_date, l_return_status);
245: if (l_return_status <> 'S' and is_error_message) then
246: hr_utility.trace('ERROR Inserting IRC_SEARCH_CRITERIA records');
247: errorFlag := true;
248: end if;
249: end loop;
250: --

Line 251: hr_utility.trace('Inserting IRC_VARIABLE_COMP_ELEMENTS records');

247: errorFlag := true;
248: end if;
249: end loop;
250: --
251: hr_utility.trace('Inserting IRC_VARIABLE_COMP_ELEMENTS records');
252: --
253: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVariableCompElementsVORow');
254: --
255: for j in 1..xmldom.getLength(commitNodes) loop

Line 259: hr_utility.trace('ERROR Inserting IRC_VARIABLE_COMP_ELEMENTS records');

255: for j in 1..xmldom.getLength(commitNodes) loop
256: commitNode:=xmldom.item(commitNodes,j-1);
257: commit_i_variable_comp_element(commitNode, l_effective_date, l_return_status);
258: if (l_return_status <> 'S' and is_error_message) then
259: hr_utility.trace('ERROR Inserting IRC_VARIABLE_COMP_ELEMENTS records');
260: errorFlag := true;
261: end if;
262: end loop;
263: --

Line 264: hr_utility.trace('Inserting PER_COMPETENCE_ELEMENTS records');

260: errorFlag := true;
261: end if;
262: end loop;
263: --
264: hr_utility.trace('Inserting PER_COMPETENCE_ELEMENTS records');
265: --
266: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancyCompetenceVORow');
267: --
268: for j in 1..xmldom.getLength(commitNodes) loop

Line 272: hr_utility.trace('ERROR Inserting PER_COMPETENCE_ELEMENTS records');

268: for j in 1..xmldom.getLength(commitNodes) loop
269: commitNode:=xmldom.item(commitNodes,j-1);
270: commit_i_competence_element(commitNode, l_effective_date, l_return_status);
271: if (l_return_status <> 'S' and is_error_message) then
272: hr_utility.trace('ERROR Inserting PER_COMPETENCE_ELEMENTS records');
273: errorFlag := true;
274: end if;
275: end loop;
276: --

Line 277: hr_utility.trace('Inserting IRC_REC_TEAM_MEMBERS records');

273: errorFlag := true;
274: end if;
275: end loop;
276: --
277: hr_utility.trace('Inserting IRC_REC_TEAM_MEMBERS records');
278: --
279: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');
280: --
281: for j in 1..xmldom.getLength(commitNodes) loop

Line 285: hr_utility.trace('ERROR Inserting IRC_REC_TEAM_MEMBERS records');

281: for j in 1..xmldom.getLength(commitNodes) loop
282: commitNode:=xmldom.item(commitNodes,j-1);
283: commit_i_rec_team_member(commitNode, l_return_status);
284: if (l_return_status <> 'S' and is_error_message) then
285: hr_utility.trace('ERROR Inserting IRC_REC_TEAM_MEMBERS records');
286: errorFlag := true;
287: end if;
288: end loop;
289: --

Line 290: hr_utility.trace('Inserting IRC_AGENCY_VACANCY records');

286: errorFlag := true;
287: end if;
288: end loop;
289: --
290: hr_utility.trace('Inserting IRC_AGENCY_VACANCY records');
291: --
292: commitNodes := xmldom.getElementsByTagName(xmldoc, 'AgencyVacanciesVORow');
293: --
294: for j in 1..xmldom.getLength(commitNodes) loop

Line 298: hr_utility.trace('ERROR Inserting IRC_AGENCY_VACANCY records');

294: for j in 1..xmldom.getLength(commitNodes) loop
295: commitNode:=xmldom.item(commitNodes,j-1);
296: commit_i_agency_vacancy(commitNode, l_return_status);
297: if (l_return_status <> 'S' and is_error_message) then
298: hr_utility.trace('ERROR Inserting IRC_AGENCY_VACANCY records');
299: errorFlag := true;
300: end if;
301: end loop;
302: --

Line 303: hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITIES records');

299: errorFlag := true;
300: end if;
301: end loop;
302: --
303: hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITIES records');
304: --
305: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivitiesVORow');
306: --
307: get_date_changes (commitNodes, external_date_change, internal_date_change);

Line 312: hr_utility.trace('Committing internal site');

308: --
309: for j in 1..xmldom.getLength(commitNodes) loop
310: commitNode:=xmldom.item(commitNodes,j-1);
311: if (is_site_internal(valueOf(commitNode,'RecruitingSiteId')) = 'I') then
312: hr_utility.trace('Committing internal site');
313: commit_i_recruitment_activity(commitNode, internal_date_change, l_return_status);
314: else
315: hr_utility.trace('Committing external site');
316: commit_i_recruitment_activity(commitNode, external_date_change, l_return_status);

Line 315: hr_utility.trace('Committing external site');

311: if (is_site_internal(valueOf(commitNode,'RecruitingSiteId')) = 'I') then
312: hr_utility.trace('Committing internal site');
313: commit_i_recruitment_activity(commitNode, internal_date_change, l_return_status);
314: else
315: hr_utility.trace('Committing external site');
316: commit_i_recruitment_activity(commitNode, external_date_change, l_return_status);
317: end if;
318: if (l_return_status <> 'S' and is_error_message) then
319: hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITIES records');

Line 319: hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITIES records');

315: hr_utility.trace('Committing external site');
316: commit_i_recruitment_activity(commitNode, external_date_change, l_return_status);
317: end if;
318: if (l_return_status <> 'S' and is_error_message) then
319: hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITIES records');
320: errorFlag := true;
321: end if;
322: end loop;
323: --

Line 324: hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITY_FOR records');

320: errorFlag := true;
321: end if;
322: end loop;
323: --
324: hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITY_FOR records');
325: --
326: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');
327: --
328: for j in 1..xmldom.getLength(commitNodes) loop

Line 332: hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITY_FOR records');

328: for j in 1..xmldom.getLength(commitNodes) loop
329: commitNode:=xmldom.item(commitNodes,j-1);
330: commit_i_rec_activity_for(commitNode, l_return_status);
331: if (l_return_status <> 'S' and is_error_message) then
332: hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITY_FOR records');
333: errorFlag := true;
334: end if;
335: end loop;
336: --

Line 342: hr_utility.trace('Error found');

338: wellFormed := TRUE;
339: --
340: if(errorFlag) then
341: --
342: hr_utility.trace('Error found');
343: --
344: error := get_error(itemtype, itemkey);
345: rollback to vacancy_commit;
346: set_up_error_message(itemtype, itemkey, error);

Line 351: hr_utility.trace('No error found');

347: resultout := 'COMMITERROR';
348: --
349: else
350: --
351: hr_utility.trace('No error found');
352: --
353: -- Remove hr_wip_transaction record
354: --
355: hr_wip_txns.delete_transaction(

Line 362: hr_utility.trace('Exiting commit_insert');

358: --
359: resultout := 'OK';
360: end if;
361: --
362: hr_utility.trace('Exiting commit_insert');
363: --
364: EXCEPTION
365: --
366: WHEN XMLParseError THEN

Line 368: hr_utility.trace('XMLParseError found');

364: EXCEPTION
365: --
366: WHEN XMLParseError THEN
367: --
368: hr_utility.trace('XMLParseError found');
369: --
370: xmlparser.freeParser(parser);
371: wellFormed := FALSE;
372: error := SQLERRM;

Line 380: hr_utility.trace('other error found');

376: resultout := 'COMMITERROR';
377: --
378: WHEN others THEN
379: --
380: hr_utility.trace('other error found');
381: --
382: error := SQLERRM;
383: rollback to vacancy_commit;
384: set_up_error_message(itemtype, itemkey, error);

Line 427: hr_utility.trace('Entering commit_update');

423: PRAGMA EXCEPTION_INIT(XMLParseError, -20100);
424: --
425: BEGIN
426: --
427: hr_utility.trace('Entering commit_update');
428: --
429: savepoint vacancy_commit;
430: errorFlag := false;
431: --

Line 434: hr_utility.trace('Exiting - Self Approve');

430: errorFlag := false;
431: --
432: if (isSelfApprove(itemtype, itemkey)) then
433: --
434: hr_utility.trace('Exiting - Self Approve');
435: --
436: resultout := 'SELF';
437: return;
438: end if;

Line 446: hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');

442: (itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'IRC_EFFECTIVE_DATE'), 'YYYY-MM-DD');
445: --
446: hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');
447: --
448: select transaction_id
449: into transaction_number
450: from hr_wip_transactions

Line 456: hr_utility.trace('Transaction Id is :' || transaction_id || ':');

452: and item_type = itemtype;
453: --
454: transaction_id := to_char(transaction_number);
455: --
456: hr_utility.trace('Transaction Id is :' || transaction_id || ':');
457: --
458: select vo_cache
459: into xmlClob
460: from hr_wip_transactions

Line 470: hr_utility.trace('Updating PER_REQUISITIONS records');

466: xmldoc := xmlparser.getDocument(parser);
467: --
468: l_return_status := 'S';
469: --
470: hr_utility.trace('Updating PER_REQUISITIONS records');
471: --
472: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRequisitionsVORow');
473: --
474: for j in 1..xmldom.getLength(commitNodes) loop

Line 478: hr_utility.trace('ERROR Updating PER_REQUISITIONS records');

474: for j in 1..xmldom.getLength(commitNodes) loop
475: commitNode:=xmldom.item(commitNodes,j-1);
476: commit_u_requisition(commitNode, l_return_status);
477: if (l_return_status <> 'S' and is_error_message) then
478: hr_utility.trace('ERROR Updating PER_REQUISITIONS records');
479: errorFlag := true;
480: end if;
481: end loop;
482: --

Line 483: hr_utility.trace('Updating IRC_POSTING_CONTENTS records');

479: errorFlag := true;
480: end if;
481: end loop;
482: --
483: hr_utility.trace('Updating IRC_POSTING_CONTENTS records');
484: --
485: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcPostingContentsVlVORow');
486: --
487: for j in 1..xmldom.getLength(commitNodes) loop

Line 495: hr_utility.trace('ERROR Updating IRC_POSTING_CONTENTS records');

491: else
492: commit_i_posting_content(commitNode, l_effective_date, l_return_status);
493: end if;
494: if (l_return_status <> 'S' and is_error_message) then
495: hr_utility.trace('ERROR Updating IRC_POSTING_CONTENTS records');
496: errorFlag := true;
497: end if;
498: end loop;
499: --

Line 500: hr_utility.trace('Updating PER_ALL_VACANCIES records');

496: errorFlag := true;
497: end if;
498: end loop;
499: --
500: hr_utility.trace('Updating PER_ALL_VACANCIES records');
501: --
502: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditVacancyVORow');
503: --
504: for j in 1..xmldom.getLength(commitNodes) loop

Line 508: hr_utility.trace('ERROR Updating PER_ALL_VACANCIES records');

504: for j in 1..xmldom.getLength(commitNodes) loop
505: commitNode:=xmldom.item(commitNodes,j-1);
506: commit_u_vacancy(commitNode, l_effective_date, l_return_status);
507: if (l_return_status <> 'S' and is_error_message) then
508: hr_utility.trace('ERROR Updating PER_ALL_VACANCIES records');
509: errorFlag := true;
510: end if;
511: end loop;
512: --

Line 513: hr_utility.trace('Updating IRC_SEARCH_CRITERIA records');

509: errorFlag := true;
510: end if;
511: end loop;
512: --
513: hr_utility.trace('Updating IRC_SEARCH_CRITERIA records');
514: --
515: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');
516: --
517: for j in 1..xmldom.getLength(commitNodes) loop

Line 525: hr_utility.trace('ERROR Updating IRC_SEARCH_CRITERIA records');

521: else
522: commit_i_search_criteria(commitNode, l_effective_date, l_return_status);
523: end if;
524: if (l_return_status <> 'S' and is_error_message) then
525: hr_utility.trace('ERROR Updating IRC_SEARCH_CRITERIA records');
526: errorFlag := true;
527: end if;
528: end loop;
529: --

Line 530: hr_utility.trace('Updating IRC_VARIABLE_COMP_ELEMENTS records');

526: errorFlag := true;
527: end if;
528: end loop;
529: --
530: hr_utility.trace('Updating IRC_VARIABLE_COMP_ELEMENTS records');
531: --
532: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVariableCompElementsVORow');
533: --
534: for j in 1..xmldom.getLength(commitNodes) loop

Line 544: hr_utility.trace('ERROR Updating IRC_VARIABLE_COMP_ELEMENTS records');

540: commit_i_variable_comp_element(commitNode, l_effective_date, l_return_status);
541: end if;
542: end if;
543: if (l_return_status <> 'S' and is_error_message) then
544: hr_utility.trace('ERROR Updating IRC_VARIABLE_COMP_ELEMENTS records');
545: errorFlag := true;
546: end if;
547: end loop;
548: --

Line 549: hr_utility.trace('Updating PER_COMPETENCE_ELEMENTS records');

545: errorFlag := true;
546: end if;
547: end loop;
548: --
549: hr_utility.trace('Updating PER_COMPETENCE_ELEMENTS records');
550: --
551: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancyCompetenceVORow');
552: --
553: for j in 1..xmldom.getLength(commitNodes) loop

Line 565: hr_utility.trace('ERROR Updating PER_COMPETENCE_ELEMENTS records');

561: commit_i_competence_element(commitNode, l_effective_date, l_return_status);
562: end if;
563: end if;
564: if (l_return_status <> 'S' and is_error_message) then
565: hr_utility.trace('ERROR Updating PER_COMPETENCE_ELEMENTS records');
566: errorFlag := true;
567: end if;
568: end loop;
569: --

Line 570: hr_utility.trace('Updating IRC_REC_TEAM_MEMBERS records');

566: errorFlag := true;
567: end if;
568: end loop;
569: --
570: hr_utility.trace('Updating IRC_REC_TEAM_MEMBERS records');
571: --
572: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');
573: --
574: for j in 1..xmldom.getLength(commitNodes) loop

Line 586: hr_utility.trace('ERROR Updating IRC_REC_TEAM_MEMBERS records');

582: commit_i_rec_team_member(commitNode, l_return_status);
583: end if;
584: end if;
585: if (l_return_status <> 'S' and is_error_message) then
586: hr_utility.trace('ERROR Updating IRC_REC_TEAM_MEMBERS records');
587: errorFlag := true;
588: end if;
589: end loop;
590: --

Line 591: hr_utility.trace('Updating IRC_AGENCY_VACANCY records');

587: errorFlag := true;
588: end if;
589: end loop;
590: --
591: hr_utility.trace('Updating IRC_AGENCY_VACANCY records');
592: --
593: commitNodes := xmldom.getElementsByTagName(xmldoc, 'AgencyVacanciesVORow');
594: --
595: for j in 1..xmldom.getLength(commitNodes) loop

Line 607: hr_utility.trace('ERROR Updating IRC_AGENCY_VACANCY records');

603: commit_i_agency_vacancy(commitNode, l_return_status);
604: end if;
605: end if;
606: if (l_return_status <> 'S' and is_error_message) then
607: hr_utility.trace('ERROR Updating IRC_AGENCY_VACANCY records');
608: errorFlag := true;
609: end if;
610: end loop;
611: --

Line 612: hr_utility.trace('Deleting PER_RECRUITMENT_ACTIVITY_FOR records');

608: errorFlag := true;
609: end if;
610: end loop;
611: --
612: hr_utility.trace('Deleting PER_RECRUITMENT_ACTIVITY_FOR records');
613: --
614: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');
615: --
616: for j in 1..xmldom.getLength(commitNodes) loop

Line 623: hr_utility.trace('ERROR Deleting PER_RECRUITMENT_ACTIVITY_FOR records');

619: --
620: if (valueOf(commitNode,'@bc4j-action') = 'remove') then
621: commit_d_rec_activity_for(commitNode, l_return_status);
622: if (l_return_status <> 'S' and is_error_message) then
623: hr_utility.trace('ERROR Deleting PER_RECRUITMENT_ACTIVITY_FOR records');
624: errorFlag := true;
625: end if;
626: end if;
627: --

Line 630: hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITIES records');

626: end if;
627: --
628: end loop;
629: --
630: hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITIES records');
631: --
632: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivitiesVORow');
633: --
634: for j in 1..xmldom.getLength(commitNodes) loop

Line 649: hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITIES records');

645: end if;
646: end if;
647: --
648: if (l_return_status <> 'S' and is_error_message) then
649: hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITIES records');
650: errorFlag := true;
651: end if;
652: --
653: end loop;

Line 655: hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITY_FOR records');

651: end if;
652: --
653: end loop;
654: --
655: hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITY_FOR records');
656: --
657: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');
658: --
659: for j in 1..xmldom.getLength(commitNodes) loop

Line 670: hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITY_FOR records');

666: end if;
667: end if;
668: --
669: if (l_return_status <> 'S' and is_error_message) then
670: hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITY_FOR records');
671: errorFlag := true;
672: end if;
673: end loop;
674: --

Line 681: hr_utility.trace('Error found');

677: wellFormed := TRUE;
678: --
679: if(errorFlag) then
680: --
681: hr_utility.trace('Error found');
682: --
683: error := get_error(itemtype, itemkey);
684: rollback to vacancy_commit;
685: set_up_error_message(itemtype, itemkey, error);

Line 690: hr_utility.trace('No error found');

686: resultout := 'COMMITERROR';
687: --
688: else
689: --
690: hr_utility.trace('No error found');
691: --
692: -- Remove hr_wip_transaction record
693: --
694: hr_wip_txns.delete_transaction(

Line 701: hr_utility.trace('Exiting commit_update');

697: resultout := 'OK';
698: --
699: end if;
700: --
701: hr_utility.trace('Exiting commit_update');
702: --
703: EXCEPTION
704: --
705: WHEN XMLParseError THEN

Line 707: hr_utility.trace('XMLParseError found');

703: EXCEPTION
704: --
705: WHEN XMLParseError THEN
706: --
707: hr_utility.trace('XMLParseError found');
708: --
709: xmlparser.freeParser(parser);
710: wellFormed := FALSE;
711: error := SQLERRM;

Line 718: hr_utility.trace('other error found');

714: resultout := 'COMMITERROR';
715: --
716: WHEN others then
717: --
718: hr_utility.trace('other error found');
719: --
720: error := SQLERRM;
721: rollback to vacancy_commit;
722: set_up_error_message(itemtype, itemkey, error);

Line 743: hr_utility.trace('Entering commit_i_requisition');

739: l_object_version_number number;
740: --
741: BEGIN
742: --
743: hr_utility.trace('Entering commit_i_requisition');
744: --
745: l_object_version_number := to_number(valueOf(commitNode,'ObjectVersionNumber'));
746: --
747: per_requisitions_swi.create_requisition (

Line 783: hr_utility.trace('Exiting commit_i_requisition');

779: ,P_VALIDATE => g_validate);
780: --
781: p_return_status := l_return_status;
782: --
783: hr_utility.trace('Exiting commit_i_requisition');
784: --
785: ----------------------------------------------------------
786: END commit_i_requisition;
787: ----------------------------------------------------------

Line 803: hr_utility.trace('Entering commit_d_requisition');

799: l_object_version_number number;
800: --
801: BEGIN
802: --
803: hr_utility.trace('Entering commit_d_requisition');
804: --
805: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
806: --
807: per_requisitions_swi.delete_requisition (

Line 815: hr_utility.trace('Exiting commit_d_requisition');

811: ,P_VALIDATE => valueOf(commitNode,''));
812: --
813: p_return_status := l_return_status;
814: --
815: hr_utility.trace('Exiting commit_d_requisition');
816: --
817: ----------------------------------------------------------
818: END commit_d_requisition;
819: ----------------------------------------------------------

Line 837: hr_utility.trace('Entering commit_u_requisition');

833: l_object_version_number number;
834: --
835: BEGIN
836: --
837: hr_utility.trace('Entering commit_u_requisition');
838: --
839: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
840: --
841: per_requisitions_swi.update_requisition (

Line 875: hr_utility.trace('Exiting commit_u_requisition');

871: ,P_VALIDATE => g_validate);
872: --
873: p_return_status := l_return_status;
874: --
875: hr_utility.trace('Exiting commit_u_requisition');
876: --
877: ----------------------------------------------------------
878: END commit_u_requisition;
879: ----------------------------------------------------------

Line 898: hr_utility.trace('Entering commit_i_vacancy');

894: l_object_version_number number;
895: --
896: BEGIN
897: --
898: hr_utility.trace('Entering commit_i_vacancy');
899: --
900: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
901: --
902: per_vacancy_swi.CREATE_VACANCY (

Line 954: hr_utility.trace('Exiting commit_i_vacancy');

950: ,P_EFFECTIVE_DATE => l_effective_date);
951: --
952: p_return_status := l_return_status;
953: --
954: hr_utility.trace('Exiting commit_i_vacancy');
955: --
956: ----------------------------------------------------------
957: END commit_i_vacancy;
958: ----------------------------------------------------------

Line 979: hr_utility.trace('Entering commit_u_vacancy');

975: status varchar2(20);
976: --
977: BEGIN
978: --
979: hr_utility.trace('Entering commit_u_vacancy');
980: --
981: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
982: --
983: status := valueOf(commitNode,'StatusCode');

Line 1038: hr_utility.trace('Exiting commit_u_vacancy');

1034: ,P_EFFECTIVE_DATE => l_effective_date);
1035: --
1036: p_return_status := l_return_status;
1037: --
1038: hr_utility.trace('Exiting commit_u_vacancy');
1039: --
1040: ----------------------------------------------------------
1041: END commit_u_vacancy;
1042: ----------------------------------------------------------

Line 1061: hr_utility.trace('Entering commit_i_search_criteria');

1057: l_object_version_number number;
1058: --
1059: BEGIN
1060: --
1061: hr_utility.trace('Entering commit_i_search_criteria');
1062: --
1063: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1064: --
1065: irc_search_criteria_swi.create_vacancy_criteria (

Line 1152: hr_utility.trace('Exiting commit_i_search_criteria');

1148: ,P_DESCRIPTION => valueOf(commitNode,'Description'));
1149: --
1150: p_return_status := l_return_status;
1151: --
1152: hr_utility.trace('Exiting commit_i_search_criteria');
1153: --
1154: ----------------------------------------------------------
1155: END commit_i_search_criteria;
1156: ----------------------------------------------------------

Line 1174: hr_utility.trace('Entering commit_d_search_criteria');

1170: l_object_version_number number;
1171: --
1172: BEGIN
1173: --
1174: hr_utility.trace('Entering commit_d_search_criteria');
1175: --
1176: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1177: --
1178: irc_search_criteria_swi.delete_vacancy_criteria (

Line 1186: hr_utility.trace('Exiting commit_d_search_criteria');

1182: ,P_VALIDATE => g_validate);
1183: --
1184: p_return_status := l_return_status;
1185: --
1186: hr_utility.trace('Exiting commit_d_search_criteria');
1187: --
1188: ----------------------------------------------------------
1189: END commit_d_search_criteria;
1190: ----------------------------------------------------------

Line 1209: hr_utility.trace('Entering commit_u_search_criteria');

1205: l_object_version_number number;
1206: --
1207: BEGIN
1208: --
1209: hr_utility.trace('Entering commit_u_search_criteria');
1210: --
1211: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1212: --
1213: irc_search_criteria_swi.update_vacancy_criteria (

Line 1300: hr_utility.trace('Exiting commit_u_search_criteria');

1296: ,P_DESCRIPTION => valueOf(commitNode,'Description'));
1297: --
1298: p_return_status := l_return_status;
1299: --
1300: hr_utility.trace('Exiting commit_u_search_criteria');
1301: --
1302: ----------------------------------------------------------
1303: END commit_u_search_criteria;
1304: ----------------------------------------------------------

Line 1323: hr_utility.trace('Entering commit_i_competence_element');

1319: l_object_version_number number;
1320: --
1321: BEGIN
1322: --
1323: hr_utility.trace('Entering commit_i_competence_element');
1324: --
1325: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1326: --
1327: hr_competence_element_swi.create_competence_element (

Line 1391: hr_utility.trace('Exiting commit_i_competence_element');

1387: ,P_VALIDATE => g_validate);
1388: --
1389: p_return_status := l_return_status;
1390: --
1391: hr_utility.trace('Exiting commit_i_competence_element');
1392: --
1393: ----------------------------------------------------------
1394: END commit_i_competence_element;
1395: ----------------------------------------------------------

Line 1412: hr_utility.trace('Entering commit_u_competence_element');

1408: l_object_version_number number;
1409: --
1410: BEGIN
1411: --
1412: hr_utility.trace('Entering commit_u_competence_element');
1413: --
1414: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1415: --
1416: hr_competence_element_swi.update_competence_element (

Line 1466: hr_utility.trace('Exiting commit_u_competence_element');

1462: ,P_COMPETENCE_ID => valueOf(commitNode,'CompetenceId'));
1463: --
1464: p_return_status := l_return_status;
1465: --
1466: hr_utility.trace('Exiting commit_u_competence_element');
1467: --
1468: ----------------------------------------------------------
1469: END commit_u_competence_element;
1470: ----------------------------------------------------------

Line 1486: hr_utility.trace('Entering commit_d_competence_element');

1482: l_object_version_number number;
1483: --
1484: BEGIN
1485: --
1486: hr_utility.trace('Entering commit_d_competence_element');
1487: --
1488: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1489: --
1490: hr_competence_element_swi.delete_competence_element (

Line 1498: hr_utility.trace('Exiting commit_d_competence_element');

1494: ,P_VALIDATE => g_validate);
1495: --
1496: p_return_status := l_return_status;
1497: --
1498: hr_utility.trace('Exiting commit_d_competence_element');
1499: --
1500: ----------------------------------------------------------
1501: END commit_d_competence_element;
1502: ----------------------------------------------------------

Line 1519: hr_utility.trace('Entering commit_i_variable_comp_element');

1515: l_object_version_number number;
1516: --
1517: BEGIN
1518: --
1519: hr_utility.trace('Entering commit_i_variable_comp_element');
1520: --
1521: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1522: --
1523: irc_variable_comp_element_swi.create_variable_compensation (

Line 1533: hr_utility.trace('Exiting commit_i_variable_comp_element');

1529: ,P_VALIDATE => g_validate);
1530: --
1531: p_return_status := l_return_status;
1532: --
1533: hr_utility.trace('Exiting commit_i_variable_comp_element');
1534: --
1535: ----------------------------------------------------------
1536: END commit_i_variable_comp_element;
1537: ----------------------------------------------------------

Line 1553: hr_utility.trace('Entering commit_d_variable_comp_element');

1549: l_object_version_number number;
1550: --
1551: BEGIN
1552: --
1553: hr_utility.trace('Entering commit_d_variable_comp_element');
1554: --
1555: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1556: --
1557: irc_variable_comp_element_swi.delete_variable_compensation (

Line 1566: hr_utility.trace('Exiting commit_d_variable_comp_element');

1562: ,P_VALIDATE => g_validate);
1563: --
1564: p_return_status := l_return_status;
1565: --
1566: hr_utility.trace('Exiting commit_d_variable_comp_element');
1567: --
1568: ----------------------------------------------------------
1569: END commit_d_variable_comp_element;
1570: ----------------------------------------------------------

Line 1586: hr_utility.trace('Entering commit_i_rec_team_member');

1582: l_return_status varchar2(1);
1583: --
1584: BEGIN
1585: --
1586: hr_utility.trace('Entering commit_i_rec_team_member');
1587: --
1588: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1589: --
1590: irc_rec_team_members_swi.create_rec_team_member (

Line 1605: hr_utility.trace('Exiting commit_i_rec_team_member');

1601: ,P_VALIDATE => g_validate);
1602: --
1603: p_return_status := l_return_status;
1604: --
1605: hr_utility.trace('Exiting commit_i_rec_team_member');
1606: --
1607: ----------------------------------------------------------
1608: END commit_i_rec_team_member;
1609: ----------------------------------------------------------

Line 1625: hr_utility.trace('Entering commit_d_rec_team_member');

1621: l_return_status varchar2(1);
1622: --
1623: BEGIN
1624: --
1625: hr_utility.trace('Entering commit_d_rec_team_member');
1626: --
1627: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1628: --
1629: irc_rec_team_members_swi.delete_rec_team_member (

Line 1637: hr_utility.trace('Exiting commit_d_rec_team_member');

1633: ,P_VALIDATE => g_validate);
1634: --
1635: p_return_status := l_return_status;
1636: --
1637: hr_utility.trace('Exiting commit_d_rec_team_member');
1638: --
1639: ----------------------------------------------------------
1640: END commit_d_rec_team_member;
1641: ----------------------------------------------------------

Line 1657: hr_utility.trace('Entering commit_u_rec_team_member');

1653: l_return_status varchar2(1);
1654: --
1655: BEGIN
1656: --
1657: hr_utility.trace('Entering commit_u_rec_team_member');
1658: --
1659: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1660: --
1661: irc_rec_team_members_swi.update_rec_team_member (

Line 1676: hr_utility.trace('Exiting commit_u_rec_team_member');

1672: ,P_VALIDATE => g_validate);
1673: --
1674: p_return_status := l_return_status;
1675: --
1676: hr_utility.trace('Exiting commit_u_rec_team_member');
1677: --
1678: ----------------------------------------------------------
1679: END commit_u_rec_team_member;
1680: ----------------------------------------------------------

Line 1694: hr_utility.trace('Entering commit_i_agency_vacancy');

1690: l_object_version_number number;
1691: --
1692: BEGIN
1693: --
1694: hr_utility.trace('Entering commit_i_agency_vacancy');
1695: --
1696: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1697: --
1698: irc_agency_vacancies_swi.create_agency_vacancy (

Line 1743: hr_utility.trace('Exiting commit_i_agency_vacancy');

1739: ,P_RETURN_STATUS => l_return_status);
1740: --
1741: p_return_status := l_return_status;
1742: --
1743: hr_utility.trace('Exiting commit_i_agency_vacancy');
1744: --
1745: ----------------------------------------------------------
1746: END commit_i_agency_vacancy;
1747: ----------------------------------------------------------

Line 1760: hr_utility.trace('Entering commit_d_agency_vacancy');

1756: l_object_version_number number;
1757: --
1758: BEGIN
1759: --
1760: hr_utility.trace('Entering commit_d_agency_vacancy');
1761: --
1762: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1763: --
1764: irc_agency_vacancies_swi.delete_agency_vacancy (

Line 1772: hr_utility.trace('Exiting commit_d_agency_vacancy');

1768: ,P_VALIDATE => g_validate);
1769: --
1770: p_return_status := l_return_status;
1771: --
1772: hr_utility.trace('Exiting commit_d_agency_vacancy');
1773: --
1774: ----------------------------------------------------------
1775: END commit_d_agency_vacancy;
1776: ----------------------------------------------------------

Line 1791: hr_utility.trace('Entering commit_u_agency_vacancy');

1787: l_object_version_number number;
1788: --
1789: BEGIN
1790: --
1791: hr_utility.trace('Entering commit_u_agency_vacancy');
1792: --
1793: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1794: --
1795: irc_agency_vacancies_swi.update_agency_vacancy (

Line 1840: hr_utility.trace('Exiting commit_u_agency_vacancy');

1836: ,P_VALIDATE => g_validate);
1837: --
1838: p_return_status := l_return_status;
1839: --
1840: hr_utility.trace('Exiting commit_u_agency_vacancy');
1841: --
1842: ----------------------------------------------------------
1843: END commit_u_agency_vacancy;
1844: ----------------------------------------------------------

Line 1860: hr_utility.trace('Entering commit_i_rec_activity_for');

1856: l_return_status varchar2(1);
1857: --
1858: BEGIN
1859: --
1860: hr_utility.trace('Entering commit_i_rec_activity_for');
1861: --
1862: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1863: --
1864: per_rec_activity_for_swi.create_rec_activity_for (

Line 1875: hr_utility.trace('Exiting commit_i_rec_activity_for');

1871: ,P_VALIDATE => g_validate);
1872: --
1873: p_return_status := l_return_status;
1874: --
1875: hr_utility.trace('Exiting commit_i_rec_activity_for');
1876: --
1877: ----------------------------------------------------------
1878: END commit_i_rec_activity_for;
1879: ----------------------------------------------------------

Line 1896: hr_utility.trace('Entering commit_d_rec_activity_for');

1892: l_return_status varchar2(1);
1893: --
1894: BEGIN
1895: --
1896: hr_utility.trace('Entering commit_d_rec_activity_for');
1897: --
1898: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1899: --
1900: per_rec_activity_for_swi.delete_rec_activity_for (

Line 1908: hr_utility.trace('Exiting commit_d_rec_activity_for');

1904: ,P_VALIDATE => g_validate);
1905: --
1906: p_return_status := l_return_status;
1907: --
1908: hr_utility.trace('Exiting commit_d_rec_activity_for');
1909: --
1910: ----------------------------------------------------------
1911: END commit_d_rec_activity_for;
1912: ----------------------------------------------------------

Line 1928: hr_utility.trace('Entering commit_u_rec_activity_for');

1924: l_return_status varchar2(1);
1925: --
1926: BEGIN
1927: --
1928: hr_utility.trace('Entering commit_u_rec_activity_for');
1929: --
1930: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1931: --
1932: per_rec_activity_for_swi.update_rec_activity_for (

Line 1942: hr_utility.trace('Exiting commit_u_rec_activity_for');

1938: ,P_VALIDATE => g_validate);
1939: --
1940: p_return_status := l_return_status;
1941: --
1942: hr_utility.trace('Exiting commit_u_rec_activity_for');
1943: --
1944: ----------------------------------------------------------
1945: END commit_u_rec_activity_for;
1946: ----------------------------------------------------------

Line 1963: hr_utility.trace('Entering commit_i_recruitment_activity');

1959: l_return_status varchar2(1);
1960: --
1961: BEGIN
1962: --
1963: hr_utility.trace('Entering commit_i_recruitment_activity');
1964: --
1965: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1966: --
1967: per_recruitment_activity_swi.create_recruitment_activity (

Line 2016: hr_utility.trace('Exiting commit_i_recruitment_activity');

2012: ,P_RECRUITING_SITE_RESPONSE => valueOf(commitNode,'RecruitingSiteResponse'));
2013: --
2014: p_return_status := l_return_status;
2015: --
2016: hr_utility.trace('Exiting commit_i_recruitment_activity');
2017: --
2018: ----------------------------------------------------------
2019: END commit_i_recruitment_activity;
2020: ----------------------------------------------------------

Line 2035: hr_utility.trace('Entering commit_d_recruitment_activity');

2031: l_return_status varchar2(1);
2032: --
2033: BEGIN
2034: --
2035: hr_utility.trace('Entering commit_d_recruitment_activity');
2036: --
2037: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2038: --
2039: per_recruitment_activity_swi.delete_recruitment_activity (

Line 2047: hr_utility.trace('Exiting commit_d_recruitment_activity');

2043: ,P_VALIDATE => g_validate);
2044: --
2045: p_return_status := l_return_status;
2046: --
2047: hr_utility.trace('Exiting commit_d_recruitment_activity');
2048: --
2049: ----------------------------------------------------------
2050: END commit_d_recruitment_activity;
2051: ----------------------------------------------------------

Line 2067: hr_utility.trace('Entering commit_u_recruitment_activity');

2063: l_return_status varchar2(1);
2064: --
2065: BEGIN
2066: --
2067: hr_utility.trace('Entering commit_u_recruitment_activity');
2068: --
2069: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2070: --
2071: per_recruitment_activity_swi.update_recruitment_activity (

Line 2119: hr_utility.trace('Exiting commit_u_recruitment_activity');

2115: ,P_RECRUITING_SITE_RESPONSE => valueOf(commitNode,'RecruitingSiteResponse'));
2116: --
2117: p_return_status := l_return_status;
2118: --
2119: hr_utility.trace('Exiting commit_u_recruitment_activity');
2120: --
2121: ----------------------------------------------------------
2122: END commit_u_recruitment_activity;
2123: ----------------------------------------------------------

Line 2140: hr_utility.trace('Entering commit_i_posting_content');

2136: l_return_status varchar2(1);
2137: --
2138: BEGIN
2139: --
2140: hr_utility.trace('Entering commit_i_posting_content');
2141: --
2142: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2143: --
2144: irc_posting_content_swi.create_posting_content (

Line 2229: hr_utility.trace('Exiting commit_i_posting_content');

2225: ,P_DATE_APPROVED => l_effective_date);
2226: --
2227: p_return_status := l_return_status;
2228: --
2229: hr_utility.trace('Exiting commit_i_posting_content');
2230: --
2231: ----------------------------------------------------------
2232: END commit_i_posting_content;
2233: ----------------------------------------------------------

Line 2249: hr_utility.trace('Entering commit_d_posting_content');

2245: l_return_status varchar2(1);
2246: --
2247: BEGIN
2248: --
2249: hr_utility.trace('Entering commit_d_posting_content');
2250: --
2251: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2252: --
2253: irc_posting_content_swi.delete_posting_content (

Line 2261: hr_utility.trace('Exiting commit_d_posting_content');

2257: ,P_VALIDATE => g_validate);
2258: --
2259: p_return_status := l_return_status;
2260: --
2261: hr_utility.trace('Exiting commit_d_posting_content');
2262: --
2263: ----------------------------------------------------------
2264: END commit_d_posting_content;
2265: ----------------------------------------------------------

Line 2281: hr_utility.trace('Entering commit_u_posting_content');

2277: l_return_status varchar2(1);
2278: --
2279: BEGIN
2280: --
2281: hr_utility.trace('Entering commit_u_posting_content');
2282: --
2283: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2284: --
2285: irc_posting_content_swi.update_posting_content (

Line 2370: hr_utility.trace('Exiting commit_u_posting_content');

2366: ,P_DATE_APPROVED => date_value(valueOf(commitNode,'DateApproved')));
2367: --
2368: p_return_status := l_return_status;
2369: --
2370: hr_utility.trace('Exiting commit_u_posting_content');
2371: --
2372: ----------------------------------------------------------
2373: END commit_u_posting_content;
2374: ----------------------------------------------------------

Line 2401: hr_utility.trace('Entering isSelfApprove');

2397: requestor varchar2(240);
2398: --
2399: BEGIN
2400: --
2401: hr_utility.trace('Entering isSelfApprove');
2402: --
2403: approver := wf_engine.getItemAttrText
2404: (itemtype => itemtype,
2405: itemkey => itemkey,

Line 2409: hr_utility.trace('Exiting isSelfApprove returning TRUE');

2405: itemkey => itemkey,
2406: aname => 'IRC_APPROVER');
2407: --
2408: if (approver is null) then
2409: hr_utility.trace('Exiting isSelfApprove returning TRUE');
2410: return true;
2411: end if;
2412: --
2413: hr_utility.trace('Exiting isSelfApprove returning FALSE');

Line 2413: hr_utility.trace('Exiting isSelfApprove returning FALSE');

2409: hr_utility.trace('Exiting isSelfApprove returning TRUE');
2410: return true;
2411: end if;
2412: --
2413: hr_utility.trace('Exiting isSelfApprove returning FALSE');
2414: return false;
2415: --
2416: END isSelfApprove;
2417: --

Line 2426: hr_utility.trace('Entering found_IrcVacancyCompetence');

2422: l_row_count number;
2423: --
2424: BEGIN
2425: --
2426: hr_utility.trace('Entering found_IrcVacancyCompetence');
2427: --
2428: l_competence_element_id :=
2429: valueOf(commitNode,'CompetenceElementId');
2430: --

Line 2437: hr_utility.trace('Exiting found_IrcVacancyCompetence returning FALSE');

2433: from per_competence_elements
2434: where competence_element_id = l_competence_element_id;
2435: --
2436: if (l_row_count = 0) then
2437: hr_utility.trace('Exiting found_IrcVacancyCompetence returning FALSE');
2438: return false;
2439: end if;
2440: --
2441: hr_utility.trace('Exiting found_IrcVacancyCompetence returning TRUE');

Line 2441: hr_utility.trace('Exiting found_IrcVacancyCompetence returning TRUE');

2437: hr_utility.trace('Exiting found_IrcVacancyCompetence returning FALSE');
2438: return false;
2439: end if;
2440: --
2441: hr_utility.trace('Exiting found_IrcVacancyCompetence returning TRUE');
2442: --
2443: return true;
2444: --
2445: END found_IrcVacancyCompetence;

Line 2467: hr_utility.trace('Exiting found_IrcRecTeamDisplay returning FALSE');

2463: where party_id = l_party_id
2464: and vacancy_id = l_vacancy_id;
2465: --
2466: if (l_row_count = 0) then
2467: hr_utility.trace('Exiting found_IrcRecTeamDisplay returning FALSE');
2468: return false;
2469: end if;
2470: --
2471: hr_utility.trace('Exiting found_IrcRecTeamDisplay returning TRUE');

Line 2471: hr_utility.trace('Exiting found_IrcRecTeamDisplay returning TRUE');

2467: hr_utility.trace('Exiting found_IrcRecTeamDisplay returning FALSE');
2468: return false;
2469: end if;
2470: --
2471: hr_utility.trace('Exiting found_IrcRecTeamDisplay returning TRUE');
2472: return true;
2473: --
2474: END found_IrcRecTeamDisplay;
2475: --

Line 2492: hr_utility.trace('Exiting found_agency_vacancy returning FALSE');

2488: from IRC_AGENCY_VACANCIES
2489: where agency_vacancy_id = l_agency_vacancy_id;
2490: --
2491: if (l_row_count = 0) then
2492: hr_utility.trace('Exiting found_agency_vacancy returning FALSE');
2493: return false;
2494: end if;
2495: --
2496: hr_utility.trace('Exiting found_agency_vacancy returning TRUE');

Line 2496: hr_utility.trace('Exiting found_agency_vacancy returning TRUE');

2492: hr_utility.trace('Exiting found_agency_vacancy returning FALSE');
2493: return false;
2494: end if;
2495: --
2496: hr_utility.trace('Exiting found_agency_vacancy returning TRUE');
2497: return true;
2498: --
2499: END found_agency_vacancy;
2500: --

Line 2520: hr_utility.trace('Exiting found_IrcVariableCompElements returning FALSE');

2516: where vacancy_id = l_vacancy_id
2517: and variable_comp_lookup = l_lookup_code;
2518: --
2519: if (l_row_count = 0) then
2520: hr_utility.trace('Exiting found_IrcVariableCompElements returning FALSE');
2521: return false;
2522: end if;
2523: --
2524: hr_utility.trace('Exiting found_IrcVariableCompElements returning TRUE');

Line 2524: hr_utility.trace('Exiting found_IrcVariableCompElements returning TRUE');

2520: hr_utility.trace('Exiting found_IrcVariableCompElements returning FALSE');
2521: return false;
2522: end if;
2523: --
2524: hr_utility.trace('Exiting found_IrcVariableCompElements returning TRUE');
2525: return true;
2526: --
2527: END found_IrcVariableCompElements;
2528: --

Line 2547: hr_utility.trace('Exiting found_rec_activity returning FALSE');

2543: from per_recruitment_activities
2544: where recruitment_activity_id = l_recruitment_activity_id;
2545: --
2546: if (l_row_count = 0) then
2547: hr_utility.trace('Exiting found_rec_activity returning FALSE');
2548: return false;
2549: end if;
2550: --
2551: hr_utility.trace('Exiting found_rec_activity returning TRUE');

Line 2551: hr_utility.trace('Exiting found_rec_activity returning TRUE');

2547: hr_utility.trace('Exiting found_rec_activity returning FALSE');
2548: return false;
2549: end if;
2550: --
2551: hr_utility.trace('Exiting found_rec_activity returning TRUE');
2552: return true;
2553: --
2554: END found_rec_activity;
2555: --

Line 2574: hr_utility.trace('Exiting found_rec_activity_for returning FALSE');

2570: from per_recruitment_activity_for
2571: where recruitment_activity_for_id = l_recruitment_activity_for_id;
2572: --
2573: if (l_row_count = 0) then
2574: hr_utility.trace('Exiting found_rec_activity_for returning FALSE');
2575: return false;
2576: end if;
2577: --
2578: hr_utility.trace('Exiting found_rec_activity_for returning TRUE');

Line 2578: hr_utility.trace('Exiting found_rec_activity_for returning TRUE');

2574: hr_utility.trace('Exiting found_rec_activity_for returning FALSE');
2575: return false;
2576: end if;
2577: --
2578: hr_utility.trace('Exiting found_rec_activity_for returning TRUE');
2579: return true;
2580: --
2581: END found_rec_activity_for;
2582: --

Line 2601: hr_utility.trace('Exiting found_IrcSearchCriteria returning FALSE');

2597: from irc_search_criteria
2598: where search_criteria_id = l_search_criteria_id;
2599: --
2600: if (l_row_count = 0) then
2601: hr_utility.trace('Exiting found_IrcSearchCriteria returning FALSE');
2602: return false;
2603: end if;
2604: --
2605: hr_utility.trace('Exiting found_IrcSearchCriteria returning TRUE');

Line 2605: hr_utility.trace('Exiting found_IrcSearchCriteria returning TRUE');

2601: hr_utility.trace('Exiting found_IrcSearchCriteria returning FALSE');
2602: return false;
2603: end if;
2604: --
2605: hr_utility.trace('Exiting found_IrcSearchCriteria returning TRUE');
2606: return true;
2607: --
2608: END found_IrcSearchCriteria;
2609: --

Line 2628: hr_utility.trace('Exiting found_IrcPostingContent returning FALSE');

2624: from irc_posting_contents
2625: where posting_content_id = l_posting_content_id;
2626: --
2627: if (l_row_count = 0) then
2628: hr_utility.trace('Exiting found_IrcPostingContent returning FALSE');
2629: return false;
2630: end if;
2631: --
2632: hr_utility.trace('Exiting found_IrcPostingContent returning TRUE');

Line 2632: hr_utility.trace('Exiting found_IrcPostingContent returning TRUE');

2628: hr_utility.trace('Exiting found_IrcPostingContent returning FALSE');
2629: return false;
2630: end if;
2631: --
2632: hr_utility.trace('Exiting found_IrcPostingContent returning TRUE');
2633: return true;
2634: --
2635: END found_IrcPostingContent;
2636: --

Line 2646: hr_utility.trace('Entering get_internal_posting_days');

2642: number_of_days varchar2(10);
2643: --
2644: BEGIN
2645: --
2646: hr_utility.trace('Entering get_internal_posting_days');
2647: --
2648: number_of_days := fnd_profile.value('IRC_INTERNAL_POSTING_DAYS');
2649:
2650: if (number_of_days is null) then

Line 2651: hr_utility.trace('Number of days is null - returning -1');

2647: --
2648: number_of_days := fnd_profile.value('IRC_INTERNAL_POSTING_DAYS');
2649:
2650: if (number_of_days is null) then
2651: hr_utility.trace('Number of days is null - returning -1');
2652: return -1;
2653: else
2654: hr_utility.trace('Returning number of days as :' || number_of_days || ':');
2655: return to_number(number_of_days);

Line 2654: hr_utility.trace('Returning number of days as :' || number_of_days || ':');

2650: if (number_of_days is null) then
2651: hr_utility.trace('Number of days is null - returning -1');
2652: return -1;
2653: else
2654: hr_utility.trace('Returning number of days as :' || number_of_days || ':');
2655: return to_number(number_of_days);
2656: end if;
2657: --
2658: END get_internal_posting_days;

Line 2678: hr_utility.trace('Entering is_site_internal');

2674: where RECRUITING_SITE_ID = c_site_id;
2675: --
2676: BEGIN
2677: --
2678: hr_utility.trace('Entering is_site_internal');
2679: --
2680: open csr_irs(p_site_id);
2681: fetch csr_irs into l_internal, l_external, l_third_party;
2682: if csr_irs%notfound then

Line 2690: hr_utility.trace('internal=Y so return I');

2686: close csr_irs;
2687: --
2688: if (l_internal = 'Y') then
2689: --
2690: hr_utility.trace('internal=Y so return I');
2691: --
2692: return 'I';
2693: end if;
2694: --

Line 2697: hr_utility.trace('external=Y so return X');

2693: end if;
2694: --
2695: if (l_external = 'Y') then
2696: --
2697: hr_utility.trace('external=Y so return X');
2698: --
2699: return 'X';
2700: end if;
2701: --

Line 2702: hr_utility.trace('neither internal nor external is Y so return 3');

2698: --
2699: return 'X';
2700: end if;
2701: --
2702: hr_utility.trace('neither internal nor external is Y so return 3');
2703: return '3';
2704: --
2705: END is_site_internal;
2706: --

Line 2717: hr_utility.trace('Entering get_date_changes');

2713: internalStartDate date;
2714: --
2715: BEGIN
2716: --
2717: hr_utility.trace('Entering get_date_changes');
2718: --
2719: -- If the start date of the external posting was not enterable
2720: -- because the IRC: Internal Posting Days profile option was set then
2721: -- the start date of the external posting will be set to be that

Line 2736: hr_utility.trace('Checking node :' || to_char(j) || ':');

2732: -- the start date of the external posting will be moved by the same amount.
2733: --
2734: for j in 1..xmldom.getLength(commitNodes) loop
2735: --
2736: hr_utility.trace('Checking node :' || to_char(j) || ':');
2737: --
2738: commitNode:=xmldom.item(commitNodes,j-1);
2739: --
2740: if (is_site_internal(valueOf(commitNode,'RecruitingSiteId')) = 'I') then

Line 2744: hr_utility.trace('Internal Site date found :' || to_char(internalStartDate) || ':');

2740: if (is_site_internal(valueOf(commitNode,'RecruitingSiteId')) = 'I') then
2741: --
2742: internalStartDate := date_value(valueOf(commitNode,'DateStart'));
2743: --
2744: hr_utility.trace('Internal Site date found :' || to_char(internalStartDate) || ':');
2745: --
2746: if (internalStartDate < sysdate) then
2747: internal_date_change := sysdate - internalStartDate;
2748: --

Line 2749: hr_utility.trace('internalStartDate < sysdate, internal change :'

2745: --
2746: if (internalStartDate < sysdate) then
2747: internal_date_change := sysdate - internalStartDate;
2748: --
2749: hr_utility.trace('internalStartDate < sysdate, internal change :'
2750: || internal_date_change || ':');
2751: --
2752: if (external_date_change = -1) then
2753: external_date_change := internal_date_change;

Line 2755: hr_utility.trace('external_date_change found as -1, changing to :'

2751: --
2752: if (external_date_change = -1) then
2753: external_date_change := internal_date_change;
2754: --
2755: hr_utility.trace('external_date_change found as -1, changing to :'
2756: || external_date_change || ':');
2757: --
2758: else
2759: external_date_change := internal_date_change + external_date_change;

Line 2761: hr_utility.trace('external_date_change set to :' || external_date_change || ':');

2757: --
2758: else
2759: external_date_change := internal_date_change + external_date_change;
2760: --
2761: hr_utility.trace('external_date_change set to :' || external_date_change || ':');
2762: --
2763: end if;
2764: end if;
2765: end if;

Line 2770: hr_utility.trace('external_date_change is still -1, changing it to 0');

2766: end loop;
2767: --
2768: if (external_date_change = -1) then
2769: --
2770: hr_utility.trace('external_date_change is still -1, changing it to 0');
2771: --
2772: external_date_change := 0;
2773: end if;
2774: --

Line 2775: hr_utility.trace('Exiting get_date_changes');

2771: --
2772: external_date_change := 0;
2773: end if;
2774: --
2775: hr_utility.trace('Exiting get_date_changes');
2776: --
2777: return;
2778: --
2779: END get_date_changes;

Line 2799: hr_utility.trace('Entering get_error for :' || itemtype || '-' || itemkey || ':');

2795: messageText varchar2(1000);
2796: --
2797: BEGIN
2798: --
2799: hr_utility.trace('Entering get_error for :' || itemtype || '-' || itemkey || ':');
2800: --
2801: pMessageCount := FND_MSG_PUB.COUNT_MSG();
2802: --
2803: messageBuffer := FND_MSG_PUB.GET_DETAIL(p_msg_index => FND_MSG_PUB.G_FIRST);

Line 2809: hr_utility.trace('Exiting get_error returning :' || error_tabs1 || ':');

2805: errorField := FND_MESSAGE.GET_TOKEN('FND_ERROR_LOCATION_FIELD','Y');
2806: messageType := FND_MESSAGE.GET_TOKEN('FND_MESSAGE_TYPE','Y');
2807: error_tabs1 := FND_MESSAGE.GET;
2808: --
2809: hr_utility.trace('Exiting get_error returning :' || error_tabs1 || ':');
2810: --
2811: return error_tabs1;
2812: --
2813: ----------------------------------------------------------

Line 2836: hr_utility.trace('Entering set_up_error_message with message :'

2832: l_encrypted_id varchar2(2000);
2833: --
2834: BEGIN
2835: --
2836: hr_utility.trace('Entering set_up_error_message with message :'
2837: || error_tabs || ':');
2838: --
2839: apr_item_type := wf_engine.getItemAttrText
2840: (itemtype => itemtype,

Line 2900: hr_utility.trace('Exiting set_up_error_message');

2896: itemkey => itemkey,
2897: aname => 'IRCAPPROVALURL',
2898: avalue => urlBase);
2899: --
2900: hr_utility.trace('Exiting set_up_error_message');
2901: --
2902: return;
2903: --
2904: ----------------------------------------------------------