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

Line 319: hr_utility.set_location(l_proc, 10);

315:
316: --
317: BEGIN
318: --
319: hr_utility.set_location(l_proc, 10);
320: IF (funcmode='RUN') THEN
321:
322: hr_utility.set_location(l_proc, 20);
323:

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

318: --
319: hr_utility.set_location(l_proc, 10);
320: IF (funcmode='RUN') THEN
321:
322: hr_utility.set_location(l_proc, 20);
323:
324: -- get the event name
325: Event:=wf_engine.getActivityAttrEvent
326: (itemtype => itemtype

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

338: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,
339: -- proceed further
340: IF ( l_offer_status = 'EXTENDED') THEN
341:
342: hr_utility.set_location(l_proc, 30);
343:
344: -- get the note entered when extending the offer
345: open csr_offer_notes(l_offer_status_history_id);
346: fetch csr_offer_notes into l_note;

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

362: open csr_get_user_name(l_creator_id);
363: fetch csr_get_user_name into l_creator_name;
364: close csr_get_user_name;
365:
366: hr_utility.set_location(l_proc, 40);
367:
368: -- get the view offer letter url
369: -- pass the applicant assignment id because drilldown used in application details page uses it
370: l_url := get_view_offer_url

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

378: fetch csr_get_employee_id into l_applicant_id;
379: close csr_get_employee_id;
380:
381:
382: hr_utility.set_location(l_proc, 50);
383:
384: -- build subject message
385: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
386: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

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

386: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
387: fnd_message.set_token('JOB_TITLE',l_job_title, false);
388: l_subject := fnd_message.get;
389:
390: hr_utility.set_location(l_proc, 60);
391:
392: -- build html body
393: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
394: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

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

408: || ''
409: || '
';
410: end if;
411:
412: hr_utility.set_location(l_proc, 70);
413:
414: -- build text body
415: --
416: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');

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

429: || '\n';
430: end if;
431:
432: --
433: hr_utility.set_location(l_proc, 80);
434:
435: -- send notification
436: l_id := irc_notification_helper_pkg.send_notification
437: ( p_person_id => l_applicant_id

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

440: , p_text_body => l_text_body
441: , p_from_role => l_creator_name
442: );
443:
444: hr_utility.set_location(l_proc, 90);
445:
446: -- now send the notification to manager also
447: IF( l_manager_id is not null) THEN
448: --

Line 449: hr_utility.set_location(l_proc, 100);

445:
446: -- now send the notification to manager also
447: IF( l_manager_id is not null) THEN
448: --
449: hr_utility.set_location(l_proc, 100);
450:
451: -- get the employee id for manager
452: open csr_get_employee_id(l_manager_id);
453: fetch csr_get_employee_id into l_manager_id;

Line 462: hr_utility.set_location(l_proc, 110);

458: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
459: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
460: l_subject := fnd_message.get;
461:
462: hr_utility.set_location(l_proc, 110);
463:
464:
465: -- build html body
466: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');

Line 472: hr_utility.set_location(l_proc, 120);

468: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
469: l_html_body := fnd_message.get || '
' || l_note_text;
470:
471: --
472: hr_utility.set_location(l_proc, 120);
473:
474: -- build text body
475: --
476: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');

Line 482: hr_utility.set_location(l_proc, 130);

478: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
479: l_text_body := fnd_message.get || '\n' || l_note_text;
480:
481: --
482: hr_utility.set_location(l_proc, 130);
483:
484: -- send notification
485: l_id := irc_notification_helper_pkg.send_notification
486: ( p_person_id => l_manager_id

Line 492: hr_utility.set_location(l_proc, 140);

488: , p_html_body => l_html_body
489: , p_text_body => l_text_body
490: , p_from_role => l_creator_name
491: );
492: hr_utility.set_location(l_proc, 140);
493:
494: --
495: END IF;
496: END IF;

Line 500: hr_utility.set_location(' Leaving:'||l_proc, 150);

496: END IF;
497: --
498: END IF;
499: resultout:='COMPLETE';
500: hr_utility.set_location(' Leaving:'||l_proc, 150);
501: --
502: END send_rcvd_wf_notification;
503: --
504: --

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

531:
532: --
533: BEGIN
534: --
535: hr_utility.set_location('Entering'||l_proc, 10);
536: -- Loop through all the job seekers and send them
537: -- a general notification.
538: for offer_expiry_rec in csr_get_expiry_offer_rec
539: (p_number_of_days => p_number_of_days)loop

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

554: open csr_get_user_name(offer_expiry_rec.creator_id);
555: fetch csr_get_user_name into l_creator_name;
556: close csr_get_user_name;
557:
558: hr_utility.set_location(l_proc,20);
559:
560: -- get offer view url
561: l_url := get_view_offer_url
562: (p_person_id => offer_expiry_rec.applicant_id

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

567: open csr_get_employee_id(offer_expiry_rec.applicant_id);
568: fetch csr_get_employee_id into l_applicant_id;
569: close csr_get_employee_id;
570:
571: hr_utility.set_location(l_proc,30);
572:
573:
574:
575: --

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

592: || ''
593: || '
';
594: end if;
595: --
596: hr_utility.set_location(l_proc,40);
597:
598: -- build text body
599:
600: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');

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

609: || '\n'||l_url
610: || '\n';
611: end if;
612: --
613: hr_utility.set_location(l_proc,50);
614:
615: -- send notification to applicant
616: l_id := irc_notification_helper_pkg.send_notification
617: ( p_person_id => l_applicant_id

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

619: , p_html_body => l_html_body
620: , p_text_body => l_text_body
621: , p_from_role => l_creator_name
622: );
623: hr_utility.set_location(l_proc,60);
624:
625: -- send notification to manager
626: IF ( offer_expiry_rec.manager_id is not null) THEN
627:

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

624:
625: -- send notification to manager
626: IF ( offer_expiry_rec.manager_id is not null) THEN
627:
628: hr_utility.set_location(l_proc,70);
629:
630: --get the employee id for manager
631: open csr_get_employee_id(offer_expiry_rec.manager_id);
632: fetch csr_get_employee_id into l_manager_id;

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

631: open csr_get_employee_id(offer_expiry_rec.manager_id);
632: fetch csr_get_employee_id into l_manager_id;
633: close csr_get_employee_id;
634:
635: hr_utility.set_location(l_proc,80);
636:
637: -- get extend offer duration url
638: l_url := get_extend_offer_duration_url
639: (p_person_id => l_manager_id

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

639: (p_person_id => l_manager_id
640: ,p_offer_id => offer_expiry_rec.offer_id);
641:
642:
643: hr_utility.set_location(l_proc,90);
644:
645: --
646: -- Build the body of the message both in text and html
647: --

Line 663: hr_utility.set_location(l_proc,100);

659: || 'Extend Duration'
660: || ''
661: || '
';
662: --
663: hr_utility.set_location(l_proc,100);
664:
665: -- build text body
666:
667: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');

Line 679: hr_utility.set_location(l_proc,110);

675: || '\n'||'Extend Duration'
676: || '\n'||l_url
677: || '\n';
678: --
679: hr_utility.set_location(l_proc,110);
680:
681: l_id := irc_notification_helper_pkg.send_notification
682: ( p_person_id => l_manager_id
683: , p_subject => l_subject

Line 690: hr_utility.set_location(l_proc,120);

686: , p_from_role => l_creator_name
687: );
688: END IF;
689:
690: hr_utility.set_location(l_proc,120);
691:
692:
693: end loop;
694: hr_utility.set_location(' Leaving:'||l_proc, 130);

Line 694: hr_utility.set_location(' Leaving:'||l_proc, 130);

690: hr_utility.set_location(l_proc,120);
691:
692:
693: end loop;
694: hr_utility.set_location(' Leaving:'||l_proc, 130);
695:
696: --
697: END send_expiry_notification;
698: --

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

723:
724: --
725: BEGIN
726: --
727: hr_utility.set_location('Entering'||l_proc, 10);
728: -- Loop through all the job seekers and send them
729: -- a general notification.
730: for offer_expired_rec in csr_get_expired_offer_rec loop
731:

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

744: open csr_get_user_name(offer_expired_rec.creator_id);
745: fetch csr_get_user_name into l_creator_name;
746: close csr_get_user_name;
747:
748: hr_utility.set_location(l_proc,20);
749:
750: -- get the person id
751: open csr_get_employee_id(offer_expired_rec.applicant_id);
752: fetch csr_get_employee_id into l_applicant_id;

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

752: fetch csr_get_employee_id into l_applicant_id;
753: close csr_get_employee_id;
754:
755:
756: hr_utility.set_location(l_proc,30);
757:
758: --
759: -- Build the body of the message both in text and html
760: --

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

764: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
765: l_html_body := fnd_message.get;
766:
767: --
768: hr_utility.set_location(l_proc,40);
769:
770: -- build text body
771: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_TEXT');
772: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);

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

772: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
773: l_text_body := fnd_message.get;
774:
775: --
776: hr_utility.set_location(l_proc,50);
777:
778: -- send notification
779: l_id := irc_notification_helper_pkg.send_notification
780: ( p_person_id => l_applicant_id

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

782: , p_html_body => l_html_body
783: , p_text_body => l_text_body
784: , p_from_role => l_creator_name
785: );
786: hr_utility.set_location(l_proc,60);
787:
788: -- send notification to manager
789: IF ( offer_expired_rec.manager_id is not null) THEN
790: --

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

787:
788: -- send notification to manager
789: IF ( offer_expired_rec.manager_id is not null) THEN
790: --
791: hr_utility.set_location(l_proc,70);
792:
793: --get the employee id for manager
794: open csr_get_employee_id(offer_expired_rec.manager_id);
795: fetch csr_get_employee_id into l_manager_id;

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

816: || 'Extend Duration'
817: || ''
818: || '
';
819: --
820: hr_utility.set_location(l_proc,80);
821:
822: -- build text body
823: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_MGR_TEXT');
824: fnd_message.set_token('APPLICANT_NAME',offer_expired_rec.applicant_name, false);

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

830: || '\n'||'Extend Duration'
831: || '\n'||l_url
832: || '\n';
833: --
834: hr_utility.set_location(l_proc,90);
835:
836: l_id := irc_notification_helper_pkg.send_notification
837: ( p_person_id => l_manager_id
838: , p_subject => l_subject

Line 843: hr_utility.set_location(l_proc,100);

839: , p_html_body => l_html_body
840: , p_text_body => l_text_body
841: , p_from_role => l_creator_name
842: );
843: hr_utility.set_location(l_proc,100);
844: --
845: END IF;
846:
847: -- Set the offer status to 'CLOSED' for the expired offers

Line 856: hr_utility.set_location(l_proc,110);

852: ,p_change_reason => 'EXPIRED'
853: ,p_status_change_date => trunc(sysdate)
854: );
855:
856: hr_utility.set_location(l_proc,110);
857:
858: end loop;
859: hr_utility.set_location(' Leaving:'||l_proc, 120);
860: --

Line 859: hr_utility.set_location(' Leaving:'||l_proc, 120);

855:
856: hr_utility.set_location(l_proc,110);
857:
858: end loop;
859: hr_utility.set_location(' Leaving:'||l_proc, 120);
860: --
861: END send_expired_notification;
862: --
863: -- ----------------------------------------------------------------------------

Line 935: hr_utility.set_location(l_proc, 10);

931: --
932: BEGIN
933: --
934:
935: hr_utility.set_location(l_proc, 10);
936: IF (funcmode='RUN') THEN
937:
938: hr_utility.set_location(l_proc, 20);
939:

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

934:
935: hr_utility.set_location(l_proc, 10);
936: IF (funcmode='RUN') THEN
937:
938: hr_utility.set_location(l_proc, 20);
939:
940: Event:=wf_engine.getActivityAttrEvent
941: (itemtype => itemtype
942: ,itemkey => itemkey

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

961: END IF;
962:
963: IF ( l_apl_response = true ) THEN
964: --
965: hr_utility.set_location(l_proc, 30);
966:
967: open csr_send_apl_resp(l_offer_id);
968: fetch csr_send_apl_resp into l_vacancy_name,l_manager_id,l_recruiter_id,l_creator_id,l_job_title,l_applicant_id,l_applicant_name,l_job_posting_title,l_last_updated_by;
969: close csr_send_apl_resp;

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

977: open csr_get_user_employee_id(l_creator_id);
978: fetch csr_get_user_employee_id into l_creator_id;
979: close csr_get_user_employee_id;
980:
981: hr_utility.set_location(l_proc, 40);
982:
983: -- get the person id
984: open csr_get_employee_id(l_applicant_id);
985: fetch csr_get_employee_id into l_applicant_id;

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

989: open csr_get_apl_referrer_id(l_offer_id);
990: fetch csr_get_apl_referrer_id into l_referrer_id;
991: close csr_get_apl_referrer_id;
992:
993: hr_utility.set_location(l_proc, 50);
994:
995: -- build subject message for applicant
996: fnd_message.set_name('PER','IRC_OFFER_RESPONSE_APL_SUBJECT');
997: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

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

999: l_subject := fnd_message.get;
1000: --
1001:
1002: --
1003: hr_utility.set_location(l_proc, 60);
1004:
1005: open csr_offer_notes(l_offer_status_history_id);
1006: fetch csr_offer_notes into l_note;
1007: if csr_offer_notes%found then

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

1023: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
1024: fnd_message.set_token('JOB_TITLE',l_job_title, false);
1025: l_html_body := fnd_message.get || '
' || l_note_text;
1026:
1027: hr_utility.set_location(l_proc, 70);
1028:
1029: -- build text body
1030: IF ( l_apl_accepted = true ) THEN
1031: fnd_message.set_name('PER','IRC_OFFER_ACCEPTED_APL_TEXT');

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

1037: l_text_body := fnd_message.get || '\n' || l_note_text;
1038:
1039:
1040: --
1041: hr_utility.set_location(l_proc, 80);
1042:
1043: -- send notification
1044: l_id := irc_notification_helper_pkg.send_notification
1045: ( p_person_id => l_applicant_id

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

1047: , p_html_body => l_html_body
1048: , p_text_body => l_text_body
1049: , p_from_role => l_creator_name
1050: );
1051: hr_utility.set_location(l_proc, 90);
1052:
1053: --send notification to manager
1054: IF( l_manager_id is not null or l_recruiter_id is not null or l_creator_id is not null) THEN
1055:

Line 1056: hr_utility.set_location(l_proc, 100);

1052:
1053: --send notification to manager
1054: IF( l_manager_id is not null or l_recruiter_id is not null or l_creator_id is not null) THEN
1055:
1056: hr_utility.set_location(l_proc, 100);
1057:
1058: IF ( l_apl_accepted = false ) THEN
1059: -- get the decline reason
1060: l_decline_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');

Line 1088: hr_utility.set_location(l_proc, 110);

1084: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
1085: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
1086: l_html_body := fnd_message.get || '
' || l_note_text;
1087:
1088: hr_utility.set_location(l_proc, 110);
1089:
1090: -- build text body
1091: IF ( l_apl_accepted = true ) THEN
1092: fnd_message.set_name('PER','IRC_OFFER_ACCEPTED_MGR_TEXT');

Line 1103: hr_utility.set_location(l_proc, 120);

1099: l_text_body := fnd_message.get || '\n' || l_note_text;
1100:
1101:
1102: --
1103: hr_utility.set_location(l_proc, 120);
1104:
1105: -- send notification to manager
1106: IF( l_manager_id is not null ) THEN
1107: l_id := irc_notification_helper_pkg.send_notification

Line 1114: hr_utility.set_location(l_proc, 130);

1110: , p_html_body => l_html_body
1111: , p_text_body => l_text_body
1112: , p_from_role => l_creator_name
1113: );
1114: hr_utility.set_location(l_proc, 130);
1115: END IF;
1116: -- send notification to recruiter
1117: IF( l_recruiter_id is not null
1118: and (l_manager_id is null or l_recruiter_id <> l_manager_id) ) THEN

Line 1126: hr_utility.set_location(l_proc, 140);

1122: , p_html_body => l_html_body
1123: , p_text_body => l_text_body
1124: , p_from_role => l_creator_name
1125: );
1126: hr_utility.set_location(l_proc, 140);
1127: END IF;
1128: -- send notification to creator
1129: IF( l_creator_id is not null
1130: and (l_recruiter_id is null or l_creator_id <> l_recruiter_id )

Line 1139: hr_utility.set_location(l_proc, 150);

1135: , p_html_body => l_html_body
1136: , p_text_body => l_text_body
1137: , p_from_role => l_creator_name
1138: );
1139: hr_utility.set_location(l_proc, 150);
1140:
1141: END IF;
1142:
1143: -- send notification to referrer

Line 1161: hr_utility.set_location(l_proc, 155);

1157: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
1158: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
1159: l_html_body := fnd_message.get;
1160:
1161: hr_utility.set_location(l_proc, 155);
1162:
1163: -- build text body
1164: fnd_message.set_name('PER','IRC_412509_OFR_ACCEPT_REF_TEXT');
1165: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);

Line 1183: hr_utility.set_location(' Leaving:'||l_proc, 160);

1179: END IF;
1180: --
1181: END IF;
1182: resultout:='COMPLETE';
1183: hr_utility.set_location(' Leaving:'||l_proc, 160);
1184: --
1185: END send_applicant_response;
1186: --
1187: -- ----------------------------------------------------------------------------

Line 1221: hr_utility.set_location(l_proc, 10);

1217: --
1218: BEGIN
1219: --
1220:
1221: hr_utility.set_location(l_proc, 10);
1222: IF (funcmode='RUN') THEN
1223:
1224: hr_utility.set_location(l_proc, 20);
1225:

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

1220:
1221: hr_utility.set_location(l_proc, 10);
1222: IF (funcmode='RUN') THEN
1223:
1224: hr_utility.set_location(l_proc, 20);
1225:
1226: Event:=wf_engine.getActivityAttrEvent
1227: (itemtype => itemtype
1228: ,itemkey => itemkey

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

1233: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1234: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1235:
1236:
1237: hr_utility.set_location(l_proc, 30);
1238: open csr_onhold_offer(l_offer_id);
1239: fetch csr_onhold_offer into l_vacancy_name,l_creator_id,l_job_title,l_applicant_name;
1240: close csr_onhold_offer;
1241:

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

1248: open csr_get_user_employee_id(l_creator_id);
1249: fetch csr_get_user_employee_id into l_creator_id;
1250: close csr_get_user_employee_id;
1251:
1252: hr_utility.set_location(l_proc, 40);
1253:
1254: --send notification to manager
1255: IF(l_creator_id is not null) THEN
1256:

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

1253:
1254: --send notification to manager
1255: IF(l_creator_id is not null) THEN
1256:
1257: hr_utility.set_location(l_proc, 50);
1258:
1259: -- build subject message for manager
1260: fnd_message.set_name('PER','IRC_OFFER_ONHOLD_MGR_SUBJECT');
1261: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);

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

1274: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
1275: l_text_body := fnd_message.get;
1276:
1277: --
1278: hr_utility.set_location(l_proc, 60);
1279:
1280: -- send notification to creator
1281: IF( l_creator_id is not null ) THEN
1282: l_id := irc_notification_helper_pkg.send_notification

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

1285: , p_html_body => l_html_body
1286: , p_text_body => l_text_body
1287: , p_from_role => l_creator_name
1288: );
1289: hr_utility.set_location(l_proc, 70);
1290:
1291: END IF;
1292: --
1293: END IF;

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

1293: END IF;
1294:
1295: END IF;
1296: resultout:='COMPLETE';
1297: hr_utility.set_location(' Leaving:'||l_proc, 90);
1298: --
1299: END send_onhold_notification;
1300: -- ----------------------------------------------------------------------------
1301: -- send_withdrawal_notification --

Line 1386: hr_utility.set_location(l_proc, 10);

1382: --
1383: BEGIN
1384: --
1385:
1386: hr_utility.set_location(l_proc, 10);
1387: IF (funcmode='RUN') THEN
1388:
1389: hr_utility.set_location(l_proc, 20);
1390:

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

1385:
1386: hr_utility.set_location(l_proc, 10);
1387: IF (funcmode='RUN') THEN
1388:
1389: hr_utility.set_location(l_proc, 20);
1390:
1391: Event:=wf_engine.getActivityAttrEvent
1392: (itemtype => itemtype
1393: ,itemkey => itemkey

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

1412: END IF;
1413:
1414: IF ( l_mgr_withdraw = true ) THEN
1415: --
1416: hr_utility.set_location(l_proc, 30);
1417:
1418: open csr_send_apl_resp(l_offer_id);
1419: fetch csr_send_apl_resp into l_vacancy_name,l_manager_id,l_recruiter_id,l_creator_id,l_job_title,l_applicant_id,l_applicant_name,l_job_posting_title,l_last_updated_by;
1420: close csr_send_apl_resp;

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

1438: open csr_get_user_employee_id(l_creator_id);
1439: fetch csr_get_user_employee_id into l_creator_id;
1440: close csr_get_user_employee_id;
1441:
1442: hr_utility.set_location(l_proc, 40);
1443:
1444: -- get the person id
1445: open csr_get_employee_id(l_applicant_id);
1446: fetch csr_get_employee_id into l_applicant_id;

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

1445: open csr_get_employee_id(l_applicant_id);
1446: fetch csr_get_employee_id into l_applicant_id;
1447: close csr_get_employee_id;
1448:
1449: hr_utility.set_location(l_proc, 50);
1450:
1451: open csr_offer_notes(l_offer_status_history_id);
1452: fetch csr_offer_notes into l_note;
1453: if csr_offer_notes%found then

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

1458: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1459: end if;
1460: close csr_offer_notes;
1461:
1462: hr_utility.set_location(l_proc, 55);
1463: -- Send notification to the candidate only when the offer has already been extended
1464:
1465: if l_prev_offer_status='EXTENDED' or l_prev_offer_status='PENDING_EXTENDED_DURATION' or l_prev_change_reason='APL_ACCEPTED' then
1466:

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

1470: l_subject := fnd_message.get;
1471: --
1472:
1473: --
1474: hr_utility.set_location(l_proc, 60);
1475:
1476: -- build html body for applicant
1477: fnd_message.set_name('PER','IRC_412573_WITHDRAWAL_APL_HTML');
1478: fnd_message.set_token('JOB_TITLE',l_job_posting_title, false);

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

1478: fnd_message.set_token('JOB_TITLE',l_job_posting_title, false);
1479: fnd_message.set_token('HIRING_MANAGER',l_hiring_manager, false);
1480: l_html_body := fnd_message.get || '
' || l_note_text;
1481:
1482: hr_utility.set_location(l_proc, 70);
1483:
1484: -- build text body
1485: fnd_message.set_name('PER','IRC_412574_WITHDRAWAL_APL_TEXT');
1486: fnd_message.set_token('JOB_TITLE',l_job_posting_title, false);

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

1488:
1489: l_text_body := fnd_message.get || '\n' || l_note_text;
1490:
1491: --
1492: hr_utility.set_location(l_proc, 80);
1493:
1494: -- send notification
1495: l_id := irc_notification_helper_pkg.send_notification
1496: ( p_person_id => l_applicant_id

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

1498: , p_html_body => l_html_body
1499: , p_text_body => l_text_body
1500: , p_from_role => l_creator_name
1501: );
1502: hr_utility.set_location(l_proc, 90);
1503:
1504: end if;
1505:
1506: --send notification to manager

Line 1509: hr_utility.set_location(l_proc, 100);

1505:
1506: --send notification to manager
1507: IF( l_manager_id is not null or l_recruiter_id is not null or l_creator_id is not null) THEN
1508:
1509: hr_utility.set_location(l_proc, 100);
1510:
1511: hr_utility.set_location('l_last_updated_by' || l_last_updated_by, 20);
1512:
1513: open csr_get_user_employee_id(l_last_updated_by);

Line 1511: hr_utility.set_location('l_last_updated_by' || l_last_updated_by, 20);

1507: IF( l_manager_id is not null or l_recruiter_id is not null or l_creator_id is not null) THEN
1508:
1509: hr_utility.set_location(l_proc, 100);
1510:
1511: hr_utility.set_location('l_last_updated_by' || l_last_updated_by, 20);
1512:
1513: open csr_get_user_employee_id(l_last_updated_by);
1514: fetch csr_get_user_employee_id into l_last_updated_emp_id;
1515: close csr_get_user_employee_id;

Line 1517: hr_utility.set_location('l_last_updated_emp_id' || l_last_updated_emp_id, 20);

1513: open csr_get_user_employee_id(l_last_updated_by);
1514: fetch csr_get_user_employee_id into l_last_updated_emp_id;
1515: close csr_get_user_employee_id;
1516:
1517: hr_utility.set_location('l_last_updated_emp_id' || l_last_updated_emp_id, 20);
1518:
1519: open csr_get_name(l_last_updated_emp_id);
1520: fetch csr_get_name into l_action_performer;
1521: close csr_get_name;

Line 1523: hr_utility.set_location('l_action_performer' || l_action_performer, 20);

1519: open csr_get_name(l_last_updated_emp_id);
1520: fetch csr_get_name into l_action_performer;
1521: close csr_get_name;
1522:
1523: hr_utility.set_location('l_action_performer' || l_action_performer, 20);
1524:
1525: -- get the decline reason
1526: l_withdrawal_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');
1527: open csr_get_withdrawal_reason(l_withdrawal_reason);

Line 1547: hr_utility.set_location(l_proc, 110);

1543: fnd_message.set_token('NOTES',l_note_text, false);
1544:
1545: l_html_body := fnd_message.get;
1546:
1547: hr_utility.set_location(l_proc, 110);
1548:
1549: -- build text body
1550: fnd_message.set_name('PER','IRC_412565_WITHDRAWAL_MGR_TEXT');
1551: fnd_message.set_token('ACTION_PERFORMER',l_action_performer, false);

Line 1560: hr_utility.set_location(l_proc, 120);

1556:
1557: l_text_body := fnd_message.get;
1558:
1559: --
1560: hr_utility.set_location(l_proc, 120);
1561:
1562: -- send notification to manager
1563: IF( l_manager_id is not null ) THEN
1564: l_id := irc_notification_helper_pkg.send_notification

Line 1571: hr_utility.set_location(l_proc, 130);

1567: , p_html_body => l_html_body
1568: , p_text_body => l_text_body
1569: , p_from_role => l_creator_name
1570: );
1571: hr_utility.set_location(l_proc, 130);
1572: END IF;
1573: -- send notification to recruiter
1574: IF( l_recruiter_id is not null
1575: and (l_manager_id is null or l_recruiter_id <> l_manager_id) ) THEN

Line 1583: hr_utility.set_location(l_proc, 140);

1579: , p_html_body => l_html_body
1580: , p_text_body => l_text_body
1581: , p_from_role => l_creator_name
1582: );
1583: hr_utility.set_location(l_proc, 140);
1584: END IF;
1585: -- send notification to creator
1586: IF( l_creator_id is not null
1587: and (l_recruiter_id is null or l_creator_id <> l_recruiter_id )

Line 1596: hr_utility.set_location(l_proc, 150);

1592: , p_html_body => l_html_body
1593: , p_text_body => l_text_body
1594: , p_from_role => l_creator_name
1595: );
1596: hr_utility.set_location(l_proc, 150);
1597:
1598: END IF;
1599:
1600: END IF;

Line 1605: hr_utility.set_location(' Leaving:'||l_proc, 160);

1601: END IF;
1602: --
1603: END IF;
1604: resultout:='COMPLETE';
1605: hr_utility.set_location(' Leaving:'||l_proc, 160);
1606: --
1607: END send_withdrawal_notification;
1608: --
1609: -- ----------------------------------------------------------------------------

Line 1692: hr_utility.set_location(l_proc, 10);

1688: --
1689: BEGIN
1690: --
1691:
1692: hr_utility.set_location(l_proc, 10);
1693: IF (funcmode='RUN') THEN
1694:
1695: hr_utility.set_location(l_proc, 20);
1696:

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

1691:
1692: hr_utility.set_location(l_proc, 10);
1693: IF (funcmode='RUN') THEN
1694:
1695: hr_utility.set_location(l_proc, 20);
1696:
1697: Event:=wf_engine.getActivityAttrEvent
1698: (itemtype => itemtype
1699: ,itemkey => itemkey

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

1713: END IF;
1714:
1715: IF ( l_apl_dec_acpt = true ) THEN
1716: --
1717: hr_utility.set_location(l_proc, 30);
1718:
1719: open csr_send_apl_resp(l_offer_id);
1720: fetch csr_send_apl_resp into l_vacancy_name,l_manager_id,l_recruiter_id,l_creator_id,l_job_title,l_applicant_id,l_applicant_name,l_job_posting_title,l_last_updated_by;
1721: close csr_send_apl_resp;

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

1739: open csr_get_user_employee_id(l_creator_id);
1740: fetch csr_get_user_employee_id into l_creator_id;
1741: close csr_get_user_employee_id;
1742:
1743: hr_utility.set_location(l_proc, 40);
1744:
1745: -- get the person id
1746: open csr_get_employee_id(l_applicant_id);
1747: fetch csr_get_employee_id into l_applicant_id;

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

1746: open csr_get_employee_id(l_applicant_id);
1747: fetch csr_get_employee_id into l_applicant_id;
1748: close csr_get_employee_id;
1749:
1750: hr_utility.set_location(l_proc, 50);
1751:
1752: open csr_offer_notes(l_offer_status_history_id);
1753: fetch csr_offer_notes into l_note;
1754: if csr_offer_notes%found then

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

1765: open csr_get_decline_reason(l_decline_reason);
1766: fetch csr_get_decline_reason into l_decline_reason_meaning;
1767: close csr_get_decline_reason;
1768:
1769: hr_utility.set_location(l_proc, 55);
1770:
1771: -- build subject message for applicant
1772: fnd_message.set_name('PER','IRC_412566_DECLINED_ACCEPT_APL');
1773: fnd_message.set_token('JOB_TITLE',l_job_posting_title, false);

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

1774: l_subject := fnd_message.get;
1775: --
1776:
1777: --
1778: hr_utility.set_location(l_proc, 60);
1779:
1780: -- build html body for applicant
1781: fnd_message.set_name('PER','IRC_412567_DEC_ACCEPT_APL_HTML');
1782: fnd_message.set_token('DECLINE_REASON',l_decline_reason_meaning, false);

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

1782: fnd_message.set_token('DECLINE_REASON',l_decline_reason_meaning, false);
1783: fnd_message.set_token('HIRING_MANAGER',l_hiring_manager, false);
1784: l_html_body := fnd_message.get || '
' || l_note_text;
1785:
1786: hr_utility.set_location(l_proc, 70);
1787:
1788: -- build text body
1789: fnd_message.set_name('PER','IRC_412568_DEC_ACCEPT_APL_TEXT');
1790: fnd_message.set_token('DECLINE_REASON',l_decline_reason_meaning, false);

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

1792:
1793: l_text_body := fnd_message.get || '\n' || l_note_text;
1794:
1795: --
1796: hr_utility.set_location(l_proc, 80);
1797:
1798: -- send notification
1799: l_id := irc_notification_helper_pkg.send_notification
1800: ( p_person_id => l_applicant_id

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

1802: , p_html_body => l_html_body
1803: , p_text_body => l_text_body
1804: , p_from_role => l_creator_name
1805: );
1806: hr_utility.set_location(l_proc, 90);
1807:
1808: end if;
1809:
1810: --send notification to manager

Line 1813: hr_utility.set_location(l_proc, 100);

1809:
1810: --send notification to manager
1811: IF( l_manager_id is not null or l_recruiter_id is not null or l_creator_id is not null) THEN
1812:
1813: hr_utility.set_location(l_proc, 100);
1814:
1815: -- build subject message for manager
1816: fnd_message.set_name('PER','IRC_412569_DECLINED_ACCEPT_MGR');
1817: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);

Line 1830: hr_utility.set_location(l_proc, 110);

1826: fnd_message.set_token('NOTES',l_note_text, false);
1827:
1828: l_html_body := fnd_message.get;
1829:
1830: hr_utility.set_location(l_proc, 110);
1831:
1832: -- build text body
1833: fnd_message.set_name('PER','IRC_412571_DEC_ACCEPT_MGR_TEXT');
1834: fnd_message.set_token('DECLINE_REASON',l_decline_reason_meaning, false);

Line 1842: hr_utility.set_location(l_proc, 120);

1838:
1839: l_text_body := fnd_message.get;
1840:
1841: --
1842: hr_utility.set_location(l_proc, 120);
1843:
1844: -- send notification to manager
1845: IF( l_manager_id is not null ) THEN
1846: l_id := irc_notification_helper_pkg.send_notification

Line 1853: hr_utility.set_location(l_proc, 130);

1849: , p_html_body => l_html_body
1850: , p_text_body => l_text_body
1851: , p_from_role => l_creator_name
1852: );
1853: hr_utility.set_location(l_proc, 130);
1854: END IF;
1855: -- send notification to recruiter
1856: IF( l_recruiter_id is not null
1857: and (l_manager_id is null or l_recruiter_id <> l_manager_id) ) THEN

Line 1865: hr_utility.set_location(l_proc, 140);

1861: , p_html_body => l_html_body
1862: , p_text_body => l_text_body
1863: , p_from_role => l_creator_name
1864: );
1865: hr_utility.set_location(l_proc, 140);
1866: END IF;
1867: -- send notification to creator
1868: IF( l_creator_id is not null
1869: and (l_recruiter_id is null or l_creator_id <> l_recruiter_id )

Line 1878: hr_utility.set_location(l_proc, 150);

1874: , p_html_body => l_html_body
1875: , p_text_body => l_text_body
1876: , p_from_role => l_creator_name
1877: );
1878: hr_utility.set_location(l_proc, 150);
1879:
1880: END IF;
1881:
1882: END IF;

Line 1886: hr_utility.set_location(' Leaving:'||l_proc, 160);

1882: END IF;
1883: --
1884: END IF;
1885: resultout:='COMPLETE';
1886: hr_utility.set_location(' Leaving:'||l_proc, 160);
1887: --
1888: END send_dcln_acptd_offer_notif;
1889:
1890: --