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.HXC_FIND_NOTIFY_APRS_PKG dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3:
4: g_pkg constant varchar2(30) := 'hxc_find_notify_aprs_pkg.';
5: g_trace VARCHAR2(2000);
6:
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: --
10: -- useful information from time card building block
11: --

Line 95: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');

91: p_message in varchar2)
92: is
93: begin
94: if not p_expression then
95: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
96: hr_utility.set_message_token('LOCATION', p_message);
97: hr_utility.raise_error;
98: end if;
99: end assert;

Line 96: hr_utility.set_message_token('LOCATION', p_message);

92: is
93: begin
94: if not p_expression then
95: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
96: hr_utility.set_message_token('LOCATION', p_message);
97: hr_utility.raise_error;
98: end if;
99: end assert;
100:

Line 97: hr_utility.raise_error;

93: begin
94: if not p_expression then
95: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
96: hr_utility.set_message_token('LOCATION', p_message);
97: hr_utility.raise_error;
98: end if;
99: end assert;
100:
101:

Line 443: g_debug := hr_utility.debug_enabled;

439: -- Bug 3345143
440: --cancel all the notifications associated with current
441: --application period and abort the current process.
442:
443: g_debug := hr_utility.debug_enabled;
444:
445:
446: if g_debug then
447: hr_utility.trace('cancelling notifications for ' || p_app_bb_id);

Line 447: hr_utility.trace('cancelling notifications for ' || p_app_bb_id);

443: g_debug := hr_utility.debug_enabled;
444:
445:
446: if g_debug then
447: hr_utility.trace('cancelling notifications for ' || p_app_bb_id);
448: end if;
449: -- OPEN c_duplicate_notifications(p_app_bb_id);
450: -- LOOP
451: -- FETCH c_duplicate_notifications into l_notification_id;

Line 456: -- hr_utility.trace('cancelled ' || l_notification_id);

452: -- EXIT WHEN c_duplicate_notifications%NOTFOUND;
453: -- wf_notification.cancel(l_notification_id,
454: -- 'canceled because a new notification is sent');
455: -- if g_debug then
456: -- hr_utility.trace('cancelled ' || l_notification_id);
457: -- end if;
458: -- END LOOP;
459: -- CLOSE c_duplicate_notifications;
460:

Line 633: g_debug:=hr_utility.debug_enabled;

629:
630: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE;
631:
632: BEGIN
633: g_debug:=hr_utility.debug_enabled;
634: OPEN c_app_periods(p_timecard_id);
635:
636: LOOP
637: FETCH c_app_periods INTO l_app_id;

Line 642: hr_utility.trace('in cancelling notifications: found app id=' || l_app_id);

638:
639: EXIT WHEN c_app_periods%NOTFOUND;
640:
641: if g_debug then
642: hr_utility.trace('in cancelling notifications: found app id=' || l_app_id);
643: end if;
644: cancel_notifications(l_app_id);
645: END LOOP;
646:

Line 687: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

683: fetch csr_tc_info into g_info.tc;
684:
685: if csr_tc_info%notfound then
686: close csr_tc_info;
687: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
688: hr_utility.set_message_token('PROCEDURE', l_proc);
689: hr_utility.set_message_token('STEP', '10');
690: hr_utility.raise_error;
691: end if;

Line 688: hr_utility.set_message_token('PROCEDURE', l_proc);

684:
685: if csr_tc_info%notfound then
686: close csr_tc_info;
687: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
688: hr_utility.set_message_token('PROCEDURE', l_proc);
689: hr_utility.set_message_token('STEP', '10');
690: hr_utility.raise_error;
691: end if;
692:

Line 689: hr_utility.set_message_token('STEP', '10');

685: if csr_tc_info%notfound then
686: close csr_tc_info;
687: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
688: hr_utility.set_message_token('PROCEDURE', l_proc);
689: hr_utility.set_message_token('STEP', '10');
690: hr_utility.raise_error;
691: end if;
692:
693: close csr_tc_info;

Line 690: hr_utility.raise_error;

686: close csr_tc_info;
687: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
688: hr_utility.set_message_token('PROCEDURE', l_proc);
689: hr_utility.set_message_token('STEP', '10');
690: hr_utility.raise_error;
691: end if;
692:
693: close csr_tc_info;
694: end if;

Line 704: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

700: fetch csr_ap_info into g_info.ap;
701:
702: if csr_ap_info%notfound then
703: close csr_ap_info;
704: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
705: hr_utility.set_message_token('PROCEDURE', l_proc);
706: hr_utility.set_message_token('STEP', '20');
707: hr_utility.raise_error;
708: end if;

Line 705: hr_utility.set_message_token('PROCEDURE', l_proc);

701:
702: if csr_ap_info%notfound then
703: close csr_ap_info;
704: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
705: hr_utility.set_message_token('PROCEDURE', l_proc);
706: hr_utility.set_message_token('STEP', '20');
707: hr_utility.raise_error;
708: end if;
709:

Line 706: hr_utility.set_message_token('STEP', '20');

702: if csr_ap_info%notfound then
703: close csr_ap_info;
704: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
705: hr_utility.set_message_token('PROCEDURE', l_proc);
706: hr_utility.set_message_token('STEP', '20');
707: hr_utility.raise_error;
708: end if;
709:
710: close csr_ap_info;

Line 707: hr_utility.raise_error;

703: close csr_ap_info;
704: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
705: hr_utility.set_message_token('PROCEDURE', l_proc);
706: hr_utility.set_message_token('STEP', '20');
707: hr_utility.raise_error;
708: end if;
709:
710: close csr_ap_info;
711:

Line 828: g_debug:=hr_utility.debug_enabled;

824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
826: l_wf_name hxc_approval_comps.wf_name%TYPE;
827: begin
828: g_debug:=hr_utility.debug_enabled;
829: --sb_msgs_pkg.begin_call(l_proc);
830: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
831: g_trace := '10';
832:

Line 858: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

854: g_trace := '20';
855:
856: if l_tc_bb_id is null or l_tc_bb_ovn is null or
857: l_ap_bb_id is null or l_ap_bb_ovn is null then
858: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
859: hr_utility.set_message_token('PROCEDURE', l_proc);
860: hr_utility.set_message_token('STEP', '10');
861: hr_utility.raise_error;
862: end if;

Line 859: hr_utility.set_message_token('PROCEDURE', l_proc);

855:
856: if l_tc_bb_id is null or l_tc_bb_ovn is null or
857: l_ap_bb_id is null or l_ap_bb_ovn is null then
858: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
859: hr_utility.set_message_token('PROCEDURE', l_proc);
860: hr_utility.set_message_token('STEP', '10');
861: hr_utility.raise_error;
862: end if;
863:

Line 860: hr_utility.set_message_token('STEP', '10');

856: if l_tc_bb_id is null or l_tc_bb_ovn is null or
857: l_ap_bb_id is null or l_ap_bb_ovn is null then
858: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
859: hr_utility.set_message_token('PROCEDURE', l_proc);
860: hr_utility.set_message_token('STEP', '10');
861: hr_utility.raise_error;
862: end if;
863:
864: g_trace := '30';

Line 861: hr_utility.raise_error;

857: l_ap_bb_id is null or l_ap_bb_ovn is null then
858: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
859: hr_utility.set_message_token('PROCEDURE', l_proc);
860: hr_utility.set_message_token('STEP', '10');
861: hr_utility.raise_error;
862: end if;
863:
864: g_trace := '30';
865:

Line 874: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

870:
871: if c_tc_info%notfound then
872:
873: close c_tc_info;
874: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
875: hr_utility.set_message_token('PROCEDURE', l_proc);
876: hr_utility.set_message_token('STEP', '12');
877: hr_utility.raise_error;
878: end if;

Line 875: hr_utility.set_message_token('PROCEDURE', l_proc);

871: if c_tc_info%notfound then
872:
873: close c_tc_info;
874: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
875: hr_utility.set_message_token('PROCEDURE', l_proc);
876: hr_utility.set_message_token('STEP', '12');
877: hr_utility.raise_error;
878: end if;
879:

Line 876: hr_utility.set_message_token('STEP', '12');

872:
873: close c_tc_info;
874: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
875: hr_utility.set_message_token('PROCEDURE', l_proc);
876: hr_utility.set_message_token('STEP', '12');
877: hr_utility.raise_error;
878: end if;
879:
880: close c_tc_info;

Line 877: hr_utility.raise_error;

873: close c_tc_info;
874: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
875: hr_utility.set_message_token('PROCEDURE', l_proc);
876: hr_utility.set_message_token('STEP', '12');
877: hr_utility.raise_error;
878: end if;
879:
880: close c_tc_info;
881:

Line 887: hr_utility.trace('app id=' || l_ap_bb_id);

883: g_trace := '40';
884:
885: --fetch approval detail
886: if g_debug then
887: hr_utility.trace('app id=' || l_ap_bb_id);
888: hr_utility.trace('app ovn=' || l_ap_bb_ovn);
889: end if;
890: OPEN c_approval_comp(l_ap_bb_id, l_ap_bb_ovn);
891: FETCH c_approval_comp INTO l_approval_mechanism

Line 888: hr_utility.trace('app ovn=' || l_ap_bb_ovn);

884:
885: --fetch approval detail
886: if g_debug then
887: hr_utility.trace('app id=' || l_ap_bb_id);
888: hr_utility.trace('app ovn=' || l_ap_bb_ovn);
889: end if;
890: OPEN c_approval_comp(l_ap_bb_id, l_ap_bb_ovn);
891: FETCH c_approval_comp INTO l_approval_mechanism
892: ,l_approval_mechanism_id

Line 917: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

913: ,l_wf_name;
914:
915: if(c_approval_comp_alt%notfound) then
916: close c_approval_comp_alt;
917: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
918: hr_utility.set_message_token('PROCEDURE', l_proc);
919: hr_utility.set_message_token('STEP', '18');
920: hr_utility.raise_error;
921: else

Line 918: hr_utility.set_message_token('PROCEDURE', l_proc);

914:
915: if(c_approval_comp_alt%notfound) then
916: close c_approval_comp_alt;
917: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
918: hr_utility.set_message_token('PROCEDURE', l_proc);
919: hr_utility.set_message_token('STEP', '18');
920: hr_utility.raise_error;
921: else
922: close c_approval_comp_alt;

Line 919: hr_utility.set_message_token('STEP', '18');

915: if(c_approval_comp_alt%notfound) then
916: close c_approval_comp_alt;
917: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
918: hr_utility.set_message_token('PROCEDURE', l_proc);
919: hr_utility.set_message_token('STEP', '18');
920: hr_utility.raise_error;
921: else
922: close c_approval_comp_alt;
923: end if;

Line 920: hr_utility.raise_error;

916: close c_approval_comp_alt;
917: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
918: hr_utility.set_message_token('PROCEDURE', l_proc);
919: hr_utility.set_message_token('STEP', '18');
920: hr_utility.raise_error;
921: else
922: close c_approval_comp_alt;
923: end if;
924:

Line 929: hr_utility.trace('mechanism=' || l_approval_mechanism);

925: else
926: CLOSE c_approval_comp;
927: END IF;
928: if g_debug then
929: hr_utility.trace('mechanism=' || l_approval_mechanism);
930: hr_utility.trace('mechanism_id=' || l_approval_mechanism_id);
931: hr_utility.trace('item_type=' || l_wf_item_type);
932: hr_utility.trace('wf_name=' || l_wf_name);
933: end if;

Line 930: hr_utility.trace('mechanism_id=' || l_approval_mechanism_id);

926: CLOSE c_approval_comp;
927: END IF;
928: if g_debug then
929: hr_utility.trace('mechanism=' || l_approval_mechanism);
930: hr_utility.trace('mechanism_id=' || l_approval_mechanism_id);
931: hr_utility.trace('item_type=' || l_wf_item_type);
932: hr_utility.trace('wf_name=' || l_wf_name);
933: end if;
934: g_trace := '60';

Line 931: hr_utility.trace('item_type=' || l_wf_item_type);

927: END IF;
928: if g_debug then
929: hr_utility.trace('mechanism=' || l_approval_mechanism);
930: hr_utility.trace('mechanism_id=' || l_approval_mechanism_id);
931: hr_utility.trace('item_type=' || l_wf_item_type);
932: hr_utility.trace('wf_name=' || l_wf_name);
933: end if;
934: g_trace := '60';
935:

Line 932: hr_utility.trace('wf_name=' || l_wf_name);

928: if g_debug then
929: hr_utility.trace('mechanism=' || l_approval_mechanism);
930: hr_utility.trace('mechanism_id=' || l_approval_mechanism_id);
931: hr_utility.trace('item_type=' || l_wf_item_type);
932: hr_utility.trace('wf_name=' || l_wf_name);
933: end if;
934: g_trace := '60';
935:
936: -- set tokens used by all notifications

Line 970: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

966: );
967:
968: exception
969: when others then
970: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
971: hr_utility.set_message_token('PROCEDURE', l_proc);
972: hr_utility.set_message_token('STEP', '20');
973: hr_utility.raise_error;
974: end;

Line 971: hr_utility.set_message_token('PROCEDURE', l_proc);

967:
968: exception
969: when others then
970: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
971: hr_utility.set_message_token('PROCEDURE', l_proc);
972: hr_utility.set_message_token('STEP', '20');
973: hr_utility.raise_error;
974: end;
975:

Line 972: hr_utility.set_message_token('STEP', '20');

968: exception
969: when others then
970: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
971: hr_utility.set_message_token('PROCEDURE', l_proc);
972: hr_utility.set_message_token('STEP', '20');
973: hr_utility.raise_error;
974: end;
975:
976: end if;

Line 973: hr_utility.raise_error;

969: when others then
970: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
971: hr_utility.set_message_token('PROCEDURE', l_proc);
972: hr_utility.set_message_token('STEP', '20');
973: hr_utility.raise_error;
974: end;
975:
976: end if;
977:

Line 1082: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1078: p_result := 'COMPLETE:PROJECT_MANAGER';
1079:
1080: else
1081: g_trace := '250';
1082: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1083: hr_utility.set_message_token('PROCEDURE', l_proc);
1084: hr_utility.set_message_token('STEP', '30');
1085: hr_utility.raise_error;
1086: end if;

Line 1083: hr_utility.set_message_token('PROCEDURE', l_proc);

1079:
1080: else
1081: g_trace := '250';
1082: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1083: hr_utility.set_message_token('PROCEDURE', l_proc);
1084: hr_utility.set_message_token('STEP', '30');
1085: hr_utility.raise_error;
1086: end if;
1087:

Line 1084: hr_utility.set_message_token('STEP', '30');

1080: else
1081: g_trace := '250';
1082: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1083: hr_utility.set_message_token('PROCEDURE', l_proc);
1084: hr_utility.set_message_token('STEP', '30');
1085: hr_utility.raise_error;
1086: end if;
1087:
1088: end if;

Line 1085: hr_utility.raise_error;

1081: g_trace := '250';
1082: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1083: hr_utility.set_message_token('PROCEDURE', l_proc);
1084: hr_utility.set_message_token('STEP', '30');
1085: hr_utility.raise_error;
1086: end if;
1087:
1088: end if;
1089:

Line 1182: g_debug:=hr_utility.debug_enabled;

1178: is
1179: l_proc constant varchar2(61) := g_pkg || '.' || 'capture_approved_status';
1180: l_approvers_visited number;
1181: begin
1182: g_debug:=hr_utility.debug_enabled;
1183: --sb_msgs_pkg.begin_call(l_proc);
1184: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
1185: if g_debug then
1186: hr_utility.trace('capture approved status');

Line 1186: hr_utility.trace('capture approved status');

1182: g_debug:=hr_utility.debug_enabled;
1183: --sb_msgs_pkg.begin_call(l_proc);
1184: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
1185: if g_debug then
1186: hr_utility.trace('capture approved status');
1187: end if;
1188: if p_funcmode = 'RUN' then
1189:
1190: set_real_approver(

Line 1202: hr_utility.trace('l_approvers_visited=' || l_approvers_visited);

1198: itemtype => p_itemtype,
1199: itemkey => p_itemkey,
1200: aname => 'APPROVERS_VISITED');
1201: if g_debug then
1202: hr_utility.trace('l_approvers_visited=' || l_approvers_visited);
1203: end if;
1204: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
1205: itemkey => p_itemkey,
1206: aname => 'APPROVED_AT_LEVEL',

Line 1434: g_debug:=hr_utility.debug_enabled;

1430:
1431: l_proc VARCHAR2(100);
1432: l_is_blank varchar2(1);
1433: begin
1434: g_debug:=hr_utility.debug_enabled;
1435: if g_debug then
1436: l_proc := g_pkg || 'find_project_manager';
1437: hr_utility.trace('in ' || l_proc);
1438: end if;

Line 1437: hr_utility.trace('in ' || l_proc);

1433: begin
1434: g_debug:=hr_utility.debug_enabled;
1435: if g_debug then
1436: l_proc := g_pkg || 'find_project_manager';
1437: hr_utility.trace('in ' || l_proc);
1438: end if;
1439: l_ap_bb_id := wf_engine.GetItemAttrNumber(
1440: itemtype => p_itemtype,
1441: itemkey => p_itemkey,

Line 1490: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1486: IF l_project_manager IS NULL
1487: THEN
1488: g_trace :=' project manager is null';
1489:
1490: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1491: hr_utility.set_message_token('PROCEDURE', l_proc);
1492: hr_utility.set_message_token('STEP', '10');
1493: hr_utility.raise_error;
1494:

Line 1491: hr_utility.set_message_token('PROCEDURE', l_proc);

1487: THEN
1488: g_trace :=' project manager is null';
1489:
1490: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1491: hr_utility.set_message_token('PROCEDURE', l_proc);
1492: hr_utility.set_message_token('STEP', '10');
1493: hr_utility.raise_error;
1494:
1495: END IF;

Line 1492: hr_utility.set_message_token('STEP', '10');

1488: g_trace :=' project manager is null';
1489:
1490: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1491: hr_utility.set_message_token('PROCEDURE', l_proc);
1492: hr_utility.set_message_token('STEP', '10');
1493: hr_utility.raise_error;
1494:
1495: END IF;
1496:

Line 1493: hr_utility.raise_error;

1489:
1490: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1491: hr_utility.set_message_token('PROCEDURE', l_proc);
1492: hr_utility.set_message_token('STEP', '10');
1493: hr_utility.raise_error;
1494:
1495: END IF;
1496:
1497: wf_engine.SetItemAttrNumber(

Line 1523: hr_utility.trace('project id and previous approver are null');

1519: avalue => l_project_manager);
1520: p_result := 'COMPLETE';
1521: else
1522: if g_debug then
1523: hr_utility.trace('project id and previous approver are null');
1524: end if;
1525: g_trace :='no project id or approver';
1526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1527: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 1526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1522: if g_debug then
1523: hr_utility.trace('project id and previous approver are null');
1524: end if;
1525: g_trace :='no project id or approver';
1526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1527: hr_utility.set_message_token('PROCEDURE', l_proc);
1528: hr_utility.set_message_token('STEP', '20');
1529: hr_utility.raise_error;
1530: end if;

Line 1527: hr_utility.set_message_token('PROCEDURE', l_proc);

1523: hr_utility.trace('project id and previous approver are null');
1524: end if;
1525: g_trace :='no project id or approver';
1526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1527: hr_utility.set_message_token('PROCEDURE', l_proc);
1528: hr_utility.set_message_token('STEP', '20');
1529: hr_utility.raise_error;
1530: end if;
1531: END IF;

Line 1528: hr_utility.set_message_token('STEP', '20');

1524: end if;
1525: g_trace :='no project id or approver';
1526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1527: hr_utility.set_message_token('PROCEDURE', l_proc);
1528: hr_utility.set_message_token('STEP', '20');
1529: hr_utility.raise_error;
1530: end if;
1531: END IF;
1532:

Line 1529: hr_utility.raise_error;

1525: g_trace :='no project id or approver';
1526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1527: hr_utility.set_message_token('PROCEDURE', l_proc);
1528: hr_utility.set_message_token('STEP', '20');
1529: hr_utility.raise_error;
1530: end if;
1531: END IF;
1532:
1533: EXCEPTION

Line 1539: hr_utility.set_location(l_proc, 999);

1535: -- The line below records this function call in the error system
1536: -- in the case of an exception.
1537: --
1538: if g_debug then
1539: hr_utility.set_location(l_proc, 999);
1540: --
1541: hr_utility.trace('IN EXCEPTION IN find_project_manager');
1542: --
1543: end if;

Line 1541: hr_utility.trace('IN EXCEPTION IN find_project_manager');

1537: --
1538: if g_debug then
1539: hr_utility.set_location(l_proc, 999);
1540: --
1541: hr_utility.trace('IN EXCEPTION IN find_project_manager');
1542: --
1543: end if;
1544: wf_core.context('HCAPPRWF', l_proc,
1545: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode, g_trace);

Line 1598: hr_utility.trace(l_proc);

1594:
1595: begin
1596: --sb_msgs_pkg.begin_call(l_proc);
1597:
1598: hr_utility.trace(l_proc);
1599:
1600: -- Bug 9946628
1601: -- Need to validate the approval style before timecard is Auto Approved.
1602:

Line 1618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1614: FETCH c_tc_info INTO l_resource_id, l_tc_start_time, l_tc_stop_time;
1615:
1616: IF c_tc_info%NOTFOUND THEN
1617: CLOSE c_tc_info;
1618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1619: hr_utility.set_message_token('PROCEDURE', l_proc);
1620: hr_utility.set_message_token('STEP', '10');
1621: hr_utility.raise_error;
1622: END IF;

Line 1619: hr_utility.set_message_token('PROCEDURE', l_proc);

1615:
1616: IF c_tc_info%NOTFOUND THEN
1617: CLOSE c_tc_info;
1618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1619: hr_utility.set_message_token('PROCEDURE', l_proc);
1620: hr_utility.set_message_token('STEP', '10');
1621: hr_utility.raise_error;
1622: END IF;
1623:

Line 1620: hr_utility.set_message_token('STEP', '10');

1616: IF c_tc_info%NOTFOUND THEN
1617: CLOSE c_tc_info;
1618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1619: hr_utility.set_message_token('PROCEDURE', l_proc);
1620: hr_utility.set_message_token('STEP', '10');
1621: hr_utility.raise_error;
1622: END IF;
1623:
1624: CLOSE c_tc_info;

Line 1621: hr_utility.raise_error;

1617: CLOSE c_tc_info;
1618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1619: hr_utility.set_message_token('PROCEDURE', l_proc);
1620: hr_utility.set_message_token('STEP', '10');
1621: hr_utility.raise_error;
1622: END IF;
1623:
1624: CLOSE c_tc_info;
1625:

Line 1627: hr_utility.trace('Person Id ::'||l_resource_id);

1623:
1624: CLOSE c_tc_info;
1625:
1626: IF g_debug THEN
1627: hr_utility.trace('Person Id ::'||l_resource_id);
1628: hr_utility.trace('Timecard Start Time ::'||l_tc_start_time);
1629: hr_utility.trace('Timecard Stop Time ::'||l_tc_stop_time);
1630: END IF;
1631:

Line 1628: hr_utility.trace('Timecard Start Time ::'||l_tc_start_time);

1624: CLOSE c_tc_info;
1625:
1626: IF g_debug THEN
1627: hr_utility.trace('Person Id ::'||l_resource_id);
1628: hr_utility.trace('Timecard Start Time ::'||l_tc_start_time);
1629: hr_utility.trace('Timecard Stop Time ::'||l_tc_stop_time);
1630: END IF;
1631:
1632: -- get approval style

Line 1629: hr_utility.trace('Timecard Stop Time ::'||l_tc_stop_time);

1625:
1626: IF g_debug THEN
1627: hr_utility.trace('Person Id ::'||l_resource_id);
1628: hr_utility.trace('Timecard Start Time ::'||l_tc_start_time);
1629: hr_utility.trace('Timecard Stop Time ::'||l_tc_stop_time);
1630: END IF;
1631:
1632: -- get approval style
1633: hxc_preference_evaluation.resource_preferences(p_resource_id => l_resource_id,

Line 1643: hr_utility.trace('Approval Style Id ::'||to_char(l_approval_style_id));

1639:
1640: l_approval_style_id := TO_NUMBER(l_pref_table(1).attribute1);
1641:
1642: IF g_debug THEN
1643: hr_utility.trace('Approval Style Id ::'||to_char(l_approval_style_id));
1644: END IF;
1645:
1646: -- check whether is set to OTL Auto Approve
1647: IF l_approval_style_id >0 THEN

Line 1652: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1648: OPEN c_appr_style(l_approval_style_id);
1649: FETCH c_appr_style INTO l_approval_style_name;
1650: IF c_appr_style%NOTFOUND THEN
1651: CLOSE c_appr_style;
1652: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1653: hr_utility.set_message_token('PROCEDURE', l_proc);
1654: hr_utility.set_message_token('STEP', '12');
1655: hr_utility.raise_error;
1656: END IF;

Line 1653: hr_utility.set_message_token('PROCEDURE', l_proc);

1649: FETCH c_appr_style INTO l_approval_style_name;
1650: IF c_appr_style%NOTFOUND THEN
1651: CLOSE c_appr_style;
1652: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1653: hr_utility.set_message_token('PROCEDURE', l_proc);
1654: hr_utility.set_message_token('STEP', '12');
1655: hr_utility.raise_error;
1656: END IF;
1657: CLOSE c_appr_style;

Line 1654: hr_utility.set_message_token('STEP', '12');

1650: IF c_appr_style%NOTFOUND THEN
1651: CLOSE c_appr_style;
1652: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1653: hr_utility.set_message_token('PROCEDURE', l_proc);
1654: hr_utility.set_message_token('STEP', '12');
1655: hr_utility.raise_error;
1656: END IF;
1657: CLOSE c_appr_style;
1658:

Line 1655: hr_utility.raise_error;

1651: CLOSE c_appr_style;
1652: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1653: hr_utility.set_message_token('PROCEDURE', l_proc);
1654: hr_utility.set_message_token('STEP', '12');
1655: hr_utility.raise_error;
1656: END IF;
1657: CLOSE c_appr_style;
1658:
1659: IF g_debug THEN

Line 1660: hr_utility.trace('Approval Style Name ::'||l_approval_style_name);

1656: END IF;
1657: CLOSE c_appr_style;
1658:
1659: IF g_debug THEN
1660: hr_utility.trace('Approval Style Name ::'||l_approval_style_name);
1661: END IF;
1662:
1663: IF l_approval_style_name <> 'OTL Auto Approve' THEN
1664: -- Raise an error if approval style is not set to OTL Auto Approve

Line 1665: hr_utility.set_message(809, 'HXC_APPR_WF_WRONG_AS');

1661: END IF;
1662:
1663: IF l_approval_style_name <> 'OTL Auto Approve' THEN
1664: -- Raise an error if approval style is not set to OTL Auto Approve
1665: hr_utility.set_message(809, 'HXC_APPR_WF_WRONG_AS');
1666: hr_utility.set_message_token('APPROVAL_STYLE',l_approval_style_name);
1667: hr_utility.raise_error;
1668: END IF;
1669: END IF;

Line 1666: hr_utility.set_message_token('APPROVAL_STYLE',l_approval_style_name);

1662:
1663: IF l_approval_style_name <> 'OTL Auto Approve' THEN
1664: -- Raise an error if approval style is not set to OTL Auto Approve
1665: hr_utility.set_message(809, 'HXC_APPR_WF_WRONG_AS');
1666: hr_utility.set_message_token('APPROVAL_STYLE',l_approval_style_name);
1667: hr_utility.raise_error;
1668: END IF;
1669: END IF;
1670:

Line 1667: hr_utility.raise_error;

1663: IF l_approval_style_name <> 'OTL Auto Approve' THEN
1664: -- Raise an error if approval style is not set to OTL Auto Approve
1665: hr_utility.set_message(809, 'HXC_APPR_WF_WRONG_AS');
1666: hr_utility.set_message_token('APPROVAL_STYLE',l_approval_style_name);
1667: hr_utility.raise_error;
1668: END IF;
1669: END IF;
1670:
1671: END IF;

Line 2005: hr_utility.set_message(809, 'HXC_APPR_WF_TERMINATED_APPR');-- If approver is terminated then raise an error

2001: avalue => l_apr_person_id);
2002: ELSE
2003: -- Check if the approver is terminated (Bug#3160848)
2004:
2005: hr_utility.set_message(809, 'HXC_APPR_WF_TERMINATED_APPR');-- If approver is terminated then raise an error
2006: hr_utility.raise_error;
2007: end if;
2008: END IF;
2009:

Line 2006: hr_utility.raise_error;

2002: ELSE
2003: -- Check if the approver is terminated (Bug#3160848)
2004:
2005: hr_utility.set_message(809, 'HXC_APPR_WF_TERMINATED_APPR');-- If approver is terminated then raise an error
2006: hr_utility.raise_error;
2007: end if;
2008: END IF;
2009:
2010: --

Line 2020: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2016: -- if null returned, approver does not have a self service login name,
2017: -- where does notification get sent?
2018: --
2019: if l_login is null then
2020: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2021: hr_utility.set_message_token('PROCEDURE', l_proc);
2022: hr_utility.set_message_token('STEP', '10');
2023: hr_utility.raise_error;
2024: end if;

Line 2021: hr_utility.set_message_token('PROCEDURE', l_proc);

2017: -- where does notification get sent?
2018: --
2019: if l_login is null then
2020: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2021: hr_utility.set_message_token('PROCEDURE', l_proc);
2022: hr_utility.set_message_token('STEP', '10');
2023: hr_utility.raise_error;
2024: end if;
2025:

Line 2022: hr_utility.set_message_token('STEP', '10');

2018: --
2019: if l_login is null then
2020: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2021: hr_utility.set_message_token('PROCEDURE', l_proc);
2022: hr_utility.set_message_token('STEP', '10');
2023: hr_utility.raise_error;
2024: end if;
2025:
2026: --sb_msgs_pkg.trace('approver login>' || l_login || '<');

Line 2023: hr_utility.raise_error;

2019: if l_login is null then
2020: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2021: hr_utility.set_message_token('PROCEDURE', l_proc);
2022: hr_utility.set_message_token('STEP', '10');
2023: hr_utility.raise_error;
2024: end if;
2025:
2026: --sb_msgs_pkg.trace('approver login>' || l_login || '<');
2027:

Line 2234: hr_utility.trace('After client extension');

2230: IN OUT l_approver_person_id,
2231: IN OUT l_message;
2232:
2233: if g_debug then
2234: hr_utility.trace('After client extension');
2235: --
2236: hr_utility.trace('Previous APPR ID is : ' || to_char(l_previous_approver_id));
2237: hr_utility.trace('APPR ID is : ' || to_char(l_approver_person_id));
2238: hr_utility.trace('Message is : ' || l_message);

Line 2236: hr_utility.trace('Previous APPR ID is : ' || to_char(l_previous_approver_id));

2232:
2233: if g_debug then
2234: hr_utility.trace('After client extension');
2235: --
2236: hr_utility.trace('Previous APPR ID is : ' || to_char(l_previous_approver_id));
2237: hr_utility.trace('APPR ID is : ' || to_char(l_approver_person_id));
2238: hr_utility.trace('Message is : ' || l_message);
2239: end if;
2240: IF l_message IS NOT NULL

Line 2237: hr_utility.trace('APPR ID is : ' || to_char(l_approver_person_id));

2233: if g_debug then
2234: hr_utility.trace('After client extension');
2235: --
2236: hr_utility.trace('Previous APPR ID is : ' || to_char(l_previous_approver_id));
2237: hr_utility.trace('APPR ID is : ' || to_char(l_approver_person_id));
2238: hr_utility.trace('Message is : ' || l_message);
2239: end if;
2240: IF l_message IS NOT NULL
2241: THEN

Line 2238: hr_utility.trace('Message is : ' || l_message);

2234: hr_utility.trace('After client extension');
2235: --
2236: hr_utility.trace('Previous APPR ID is : ' || to_char(l_previous_approver_id));
2237: hr_utility.trace('APPR ID is : ' || to_char(l_approver_person_id));
2238: hr_utility.trace('Message is : ' || l_message);
2239: end if;
2240: IF l_message IS NOT NULL
2241: THEN
2242: l_message_table := hxc_deposit_wrapper_utilities.string_to_messages

Line 2378: g_debug:=hr_utility.debug_enabled;

2374:
2375: --
2376: begin
2377:
2378: g_debug:=hr_utility.debug_enabled;
2379:
2380: IF p_funcmode <> 'CANCEL' THEN
2381:
2382: g_trace := 'Begin hr_supervisor_approval';

Line 2384: hr_utility.trace('Begin hr_supervisor_approval');

2380: IF p_funcmode <> 'CANCEL' THEN
2381:
2382: g_trace := 'Begin hr_supervisor_approval';
2383: if g_debug then
2384: hr_utility.trace('Begin hr_supervisor_approval');
2385: end if;
2386:
2387: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
2388: (itemtype => p_itemtype,

Line 2395: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));

2391:
2392: g_trace := 'Timecard BB ID is : ' || to_char(l_tc_bld_blk_id);
2393:
2394: if g_debug then
2395: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
2396: end if;
2397: l_tc_ovn := wf_engine.GetItemAttrNumber
2398: (itemtype => p_itemtype,
2399: itemkey => p_itemkey,

Line 2456: hr_utility.trace('Before client extension=' || l_ext_func2);

2452: close csr_get_extension;
2453:
2454: g_trace := 'Before client extension=' || l_ext_func2;
2455: if g_debug then
2456: hr_utility.trace('Before client extension=' || l_ext_func2);
2457: end if;
2458: -- Bug 4177487. For an empty Timecard (Timecard that does not have DETAIL level records),
2459: -- we need not call the PA extension function.
2460: open c_details_of_timecard( l_tc_bld_blk_id );

Line 2473: hr_utility.trace('extension not null');

2469: IF l_ext_func2 IS NOT NULL and l_tc_has_details_flag = 'Y'
2470: THEN
2471: g_trace := 'extension not null';
2472: if g_debug then
2473: hr_utility.trace('extension not null');
2474: end if;
2475: IF hxc_approval_wf_pkg.code_chk(l_ext_func2)
2476: THEN
2477: g_trace := 'extension code exists';

Line 2479: hr_utility.trace('extension code exists');

2475: IF hxc_approval_wf_pkg.code_chk(l_ext_func2)
2476: THEN
2477: g_trace := 'extension code exists';
2478: if g_debug then
2479: hr_utility.trace('extension code exists');
2480: end if;
2481: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2482: itemkey => p_itemkey,
2483: aname => 'APR_KEY_LEVEL',

Line 2501: hr_utility.trace('before processing extension l_previous_approver_id='

2497:
2498: g_trace := 'before processing extension l_previous_approver_id='
2499: || to_char(l_person_id);
2500: if g_debug then
2501: hr_utility.trace('before processing extension l_previous_approver_id='
2502: || to_char(l_person_id));
2503: end if;
2504:
2505: --Bug 5386274

Line 2524: hr_utility.trace('after processing extension l_supervisor_id='

2520:
2521: g_trace := 'after processing extension l_supervisor_id='
2522: || to_char(l_supervisor_id);
2523: if g_debug then
2524: hr_utility.trace('after processing extension l_supervisor_id='
2525: || to_char(l_supervisor_id));
2526: end if;
2527: IF l_supervisor_id IS NOT NULL
2528: THEN

Line 2531: hr_utility.trace('testing if this is the final approver');

2527: IF l_supervisor_id IS NOT NULL
2528: THEN
2529: g_trace := 'testing if this is the final approver';
2530: if g_debug then
2531: hr_utility.trace('testing if this is the final approver');
2532: end if;
2533: process_extension_func2(
2534: p_tc_id => l_tc_bld_blk_id
2535: ,p_tc_ovn => l_tc_ovn

Line 2544: hr_utility.trace('end calling extension');

2540: );
2541:
2542: g_trace := 'end calling extension';
2543: if g_debug then
2544: hr_utility.trace('end calling extension');
2545: end if;
2546: IF l_next_supervisor_id = -99
2547: THEN
2548: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 2555: hr_utility.trace('FINAL_APR is : YES');

2551: avalue => 'YES');
2552:
2553: g_trace := 'FINAL_APR is : YES';
2554: if g_debug then
2555: hr_utility.trace('FINAL_APR is : YES');
2556: end if;
2557: END IF;
2558:
2559: g_trace := 'end testing final approver';

Line 2561: hr_utility.trace('end testing final approver');

2557: END IF;
2558:
2559: g_trace := 'end testing final approver';
2560: if g_debug then
2561: hr_utility.trace('end testing final approver');
2562: end if;
2563: END IF;
2564:
2565: ELSE

Line 2567: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2563: END IF;
2564:
2565: ELSE
2566: g_trace := 'extension function=' || l_ext_func2 || 'not exist in db';
2567: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2568: hr_utility.set_message_token('PROCEDURE', l_proc);
2569: hr_utility.set_message_token('STEP', '10');
2570: hr_utility.raise_error;
2571:

Line 2568: hr_utility.set_message_token('PROCEDURE', l_proc);

2564:
2565: ELSE
2566: g_trace := 'extension function=' || l_ext_func2 || 'not exist in db';
2567: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2568: hr_utility.set_message_token('PROCEDURE', l_proc);
2569: hr_utility.set_message_token('STEP', '10');
2570: hr_utility.raise_error;
2571:
2572: END IF;

Line 2569: hr_utility.set_message_token('STEP', '10');

2565: ELSE
2566: g_trace := 'extension function=' || l_ext_func2 || 'not exist in db';
2567: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2568: hr_utility.set_message_token('PROCEDURE', l_proc);
2569: hr_utility.set_message_token('STEP', '10');
2570: hr_utility.raise_error;
2571:
2572: END IF;
2573: ELSE -- if no client extension, find supervisor from assignments

Line 2570: hr_utility.raise_error;

2566: g_trace := 'extension function=' || l_ext_func2 || 'not exist in db';
2567: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2568: hr_utility.set_message_token('PROCEDURE', l_proc);
2569: hr_utility.set_message_token('STEP', '10');
2570: hr_utility.raise_error;
2571:
2572: END IF;
2573: ELSE -- if no client extension, find supervisor from assignments
2574: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 2583: hr_utility.trace('no extension function checking assignment');

2579:
2580: --Bug 2777538 sonarasi 20-FEB-2003
2581: g_trace := 'no extension function checking assignment';
2582: if g_debug then
2583: hr_utility.trace('no extension function checking assignment');
2584: end if;
2585:
2586: -- Bug 4202019. These variables need to be set outside this IF block.
2587: /*

Line 2624: hr_utility.trace('200');

2620: --
2621: if l_supervisor_id is null and l_approvers_visited = 0 then
2622: g_trace := '200';
2623: if g_debug then
2624: hr_utility.trace('200');
2625: end if;
2626:
2627: hr_utility.set_message(809, 'HXC_APPR_WF_NO_HR_SUP');
2628: hr_utility.raise_error;

Line 2627: hr_utility.set_message(809, 'HXC_APPR_WF_NO_HR_SUP');

2623: if g_debug then
2624: hr_utility.trace('200');
2625: end if;
2626:
2627: hr_utility.set_message(809, 'HXC_APPR_WF_NO_HR_SUP');
2628: hr_utility.raise_error;
2629: end if;
2630:
2631: g_trace := 'supervisor is not null';

Line 2628: hr_utility.raise_error;

2624: hr_utility.trace('200');
2625: end if;
2626:
2627: hr_utility.set_message(809, 'HXC_APPR_WF_NO_HR_SUP');
2628: hr_utility.raise_error;
2629: end if;
2630:
2631: g_trace := 'supervisor is not null';
2632: if g_debug then

Line 2633: hr_utility.trace('supervisor is not null');

2629: end if;
2630:
2631: g_trace := 'supervisor is not null';
2632: if g_debug then
2633: hr_utility.trace('supervisor is not null');
2634: end if;
2635: -- set up timeout properties for first approver in hierarchy
2636:
2637: IF l_ext_func2 IS NULL

Line 2641: hr_utility.trace('setting timeout');

2637: IF l_ext_func2 IS NULL
2638: THEN
2639: g_trace := 'setting timeout';
2640: if g_debug then
2641: hr_utility.trace('setting timeout');
2642: end if;
2643: if l_approvers_visited = 0 then
2644:
2645: -- if supervisors exist after first approver then notification

Line 2652: hr_utility.trace('allow timeout');

2648: if get_supervisor(l_supervisor_id, SYSDATE) is not null
2649: then
2650: g_trace :='allow timeout';
2651: if g_debug then
2652: hr_utility.trace('allow timeout');
2653: end if;
2654: l_default_timeout := wf_engine.GetItemAttrText(
2655: itemtype => p_itemtype,
2656: itemkey => p_itemkey,

Line 2667: hr_utility.trace('timeout=' || to_char(l_default_timeout));

2663: avalue => l_default_timeout);
2664:
2665: g_trace := 'timeout=' || to_char(l_default_timeout);
2666: if g_debug then
2667: hr_utility.trace('timeout=' || to_char(l_default_timeout));
2668: end if;
2669: -- if no more supervisors exist after first approver then
2670: -- notification sent to next approver NOT allowed to timeout
2671: else

Line 2674: hr_utility.trace('NOT allow timeout');

2670: -- notification sent to next approver NOT allowed to timeout
2671: else
2672: g_trace :='NOT allow timeout';
2673: if g_debug then
2674: hr_utility.trace('NOT allow timeout');
2675: end if;
2676: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2677: itemkey => p_itemkey,
2678: aname => 'APPROVAL_TIMEOUT',

Line 2689: hr_utility.trace('find supervisor self service login');

2685:
2686:
2687: g_trace := 'find supervisor self service login';
2688: if g_debug then
2689: hr_utility.trace('find supervisor self service login');
2690: end if;
2691: -- find supervisor self service login
2692: l_login := get_login(p_person_id =>l_supervisor_id);
2693:

Line 2697: hr_utility.trace('RAISE: no self service login for supervisor');

2693:
2694: if l_login is null then
2695: g_trace := 'RAISE: no self service login for supervisor';
2696: if g_debug then
2697: hr_utility.trace('RAISE: no self service login for supervisor');
2698: end if;
2699: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2700: hr_utility.set_message_token('PROCEDURE', l_proc);
2701: hr_utility.set_message_token('STEP', '30');

Line 2699: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2695: g_trace := 'RAISE: no self service login for supervisor';
2696: if g_debug then
2697: hr_utility.trace('RAISE: no self service login for supervisor');
2698: end if;
2699: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2700: hr_utility.set_message_token('PROCEDURE', l_proc);
2701: hr_utility.set_message_token('STEP', '30');
2702: hr_utility.raise_error;
2703: end if;

Line 2700: hr_utility.set_message_token('PROCEDURE', l_proc);

2696: if g_debug then
2697: hr_utility.trace('RAISE: no self service login for supervisor');
2698: end if;
2699: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2700: hr_utility.set_message_token('PROCEDURE', l_proc);
2701: hr_utility.set_message_token('STEP', '30');
2702: hr_utility.raise_error;
2703: end if;
2704:

Line 2701: hr_utility.set_message_token('STEP', '30');

2697: hr_utility.trace('RAISE: no self service login for supervisor');
2698: end if;
2699: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2700: hr_utility.set_message_token('PROCEDURE', l_proc);
2701: hr_utility.set_message_token('STEP', '30');
2702: hr_utility.raise_error;
2703: end if;
2704:
2705: g_trace := 'supervisor ss login=' || l_login;

Line 2702: hr_utility.raise_error;

2698: end if;
2699: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2700: hr_utility.set_message_token('PROCEDURE', l_proc);
2701: hr_utility.set_message_token('STEP', '30');
2702: hr_utility.raise_error;
2703: end if;
2704:
2705: g_trace := 'supervisor ss login=' || l_login;
2706: if g_debug then

Line 2707: hr_utility.trace('supervisor ss login=' || l_login);

2703: end if;
2704:
2705: g_trace := 'supervisor ss login=' || l_login;
2706: if g_debug then
2707: hr_utility.trace('supervisor ss login=' || l_login);
2708: end if;
2709:
2710: -- supervisor found and notification to be sent,
2711: -- keep track of approvers visted to date

Line 2715: hr_utility.trace('increase approvers visited');

2711: -- keep track of approvers visted to date
2712:
2713: g_trace := 'increase approvers visited';
2714: if g_debug then
2715: hr_utility.trace('increase approvers visited');
2716: end if;
2717: inc_approvers_visited(p_itemtype, p_itemkey);
2718:
2719: wf_engine.SetItemAttrText(

Line 2728: hr_utility.trace('setting apr_name');

2724: );
2725:
2726: g_trace := 'setting apr_name';
2727: if g_debug then
2728: hr_utility.trace('setting apr_name');
2729: end if;
2730: -- set information for notification
2731: wf_engine.SetItemAttrText(
2732: itemtype => p_itemtype,

Line 2740: hr_utility.trace('setting from_role');

2736: );
2737:
2738: g_trace := 'setting from_role';
2739: if g_debug then
2740: hr_utility.trace('setting from_role');
2741: end if;
2742: wf_engine.SetItemAttrText(
2743: itemtype => p_itemtype,
2744: itemkey => p_itemkey,

Line 2751: hr_utility.trace('Notification Sent to : '||to_char(l_supervisor_id));

2747: );
2748:
2749: g_trace := '300';
2750: if g_debug then
2751: hr_utility.trace('Notification Sent to : '||to_char(l_supervisor_id));
2752: end if;
2753: --
2754: -- set supervisor's person id, ready for next iteration
2755:

Line 2822: hr_utility.trace('500');

2818:
2819:
2820: g_trace := '500';
2821: if g_debug then
2822: hr_utility.trace('500');
2823: end if;
2824: p_result := 'COMPLETE:Y';
2825:
2826: end if;

Line 2996: g_debug:=hr_utility.debug_enabled;

2992: l_apr_key_level number;
2993: l_approved_at_level number;
2994: l_approvers_visited number;
2995: begin
2996: g_debug:=hr_utility.debug_enabled;
2997: --sb_msgs_pkg.begin_call(l_proc);
2998: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
2999: if g_debug then
3000: hr_utility.trace('is final approver');

Line 3000: hr_utility.trace('is final approver');

2996: g_debug:=hr_utility.debug_enabled;
2997: --sb_msgs_pkg.begin_call(l_proc);
2998: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
2999: if g_debug then
3000: hr_utility.trace('is final approver');
3001: end if;
3002: if p_funcmode = 'RUN' then
3003:
3004: l_final_apr := wf_engine.GetItemAttrText(

Line 3012: hr_utility.trace('Final!');

3008:
3009:
3010: IF l_final_apr = 'YES' THEN
3011: if g_debug then
3012: hr_utility.trace('Final!');
3013: end if;
3014: p_result := 'COMPLETE:Y';
3015: return;
3016: ELSIF l_final_apr = 'NO' THEN

Line 3018: hr_utility.trace('extension not final');

3014: p_result := 'COMPLETE:Y';
3015: return;
3016: ELSIF l_final_apr = 'NO' THEN
3017: if g_debug then
3018: hr_utility.trace('extension not final');
3019: end if;
3020: p_result := 'COMPLETE:N';
3021: return;
3022: END IF;

Line 3036: hr_utility.trace('NOT final');

3032: return;
3033: END IF;
3034:
3035: if g_debug then
3036: hr_utility.trace('NOT final');
3037: end if;
3038:
3039: l_effective_date := wf_engine.GetItemAttrDate(
3040: itemtype => p_itemtype,

Line 3080: hr_utility.trace('not final 1');

3076: if l_approvers_visited + 1 < l_apr_key_level then
3077: --sb_msgs_pkg.trace('10 - if');
3078:
3079: if g_debug then
3080: hr_utility.trace('not final 1');
3081: end if;
3082:
3083: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3084: itemkey => p_itemkey,

Line 3120: hr_utility.trace('not final 2');

3116: avalue => 0);
3117: end if;
3118:
3119: if g_debug then
3120: hr_utility.trace('not final 2');
3121: end if;
3122:
3123: p_result := 'COMPLETE:N';
3124: --

Line 3136: hr_utility.trace('Yes final 1');

3132:
3133: if l_approved_at_level >= l_apr_key_level then
3134: --sb_msgs_pkg.trace('32 - if');
3135: if g_debug then
3136: hr_utility.trace('Yes final 1');
3137: end if;
3138: p_result := 'COMPLETE:Y';
3139: else
3140: --sb_msgs_pkg.trace('34 - else');

Line 3143: hr_utility.trace('not final 3');

3139: else
3140: --sb_msgs_pkg.trace('34 - else');
3141:
3142: if g_debug then
3143: hr_utility.trace('not final 3');
3144: end if;
3145:
3146: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3147: itemkey => p_itemkey,

Line 3166: hr_utility.trace('cancelled');

3162: end if;
3163:
3164: if p_funcmode = 'CANCEL' then
3165: if g_debug then
3166: hr_utility.trace('cancelled');
3167: end if;
3168:
3169: p_result := 'COMPLETE';
3170: end if;

Line 3175: hr_utility.trace('completed');

3171:
3172: if p_funcmode = 'TIMEOUT' then
3173:
3174: if g_debug then
3175: hr_utility.trace('completed');
3176: end if;
3177:
3178: p_result := 'COMPLETE';
3179: end if;

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

3207: begin
3208:
3209: if g_debug then
3210: l_proc := g_pkg || '.' || 'check_user_exists';
3211: hr_utility.set_location(l_proc, 10);
3212: end if;
3213:
3214: if p_funcmode = 'RUN' then
3215:

Line 3236: hr_utility.trace('cancelled');

3232: end if;
3233:
3234: if p_funcmode = 'CANCEL' then
3235: if g_debug then
3236: hr_utility.trace('cancelled');
3237: end if;
3238:
3239: p_result := 'COMPLETE';
3240: end if;

Line 3245: hr_utility.trace('completed');

3241:
3242: if p_funcmode = 'TIMEOUT' then
3243:
3244: if g_debug then
3245: hr_utility.trace('completed');
3246: end if;
3247:
3248: p_result := 'COMPLETE';
3249: end if;

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

3283: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
3284:
3285: if g_debug then
3286: l_proc := g_pkg || '.' || 'formula_selects_mechanism';
3287: hr_utility.set_location(l_proc, 10);
3288: end if;
3289:
3290: l_person_id := wf_engine.GetItemAttrNumber(
3291: itemtype => p_itemtype,

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

3302: itemkey => p_itemkey,
3303: aname => 'FORMULA_ID');
3304:
3305: if g_debug then
3306: hr_utility.set_location(l_proc, 20);
3307: end if;
3308:
3309: --
3310: -- initialise formula

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

3319: -- nb. no contexts are used
3320: --
3321:
3322: if g_debug then
3323: hr_utility.set_location(l_proc, 30);
3324: end if;
3325:
3326: hr_utility.trace('Input count is:'||l_inputs.count);
3327:

Line 3326: hr_utility.trace('Input count is:'||l_inputs.count);

3322: if g_debug then
3323: hr_utility.set_location(l_proc, 30);
3324: end if;
3325:
3326: hr_utility.trace('Input count is:'||l_inputs.count);
3327:
3328: -- Added IF END IF condition for bug 8646570
3329: -- do not assign values to the formula inputs when none of the inputs are used within the formula
3330:

Line 3334: hr_utility.trace('Input name:'||l_inputs(i).name);

3330:
3331: if (l_inputs.count > 0) then
3332: for i in l_inputs.first..l_inputs.last loop
3333:
3334: hr_utility.trace('Input name:'||l_inputs(i).name);
3335:
3336: if l_inputs(i).name = 'TIMECARD_BB_ID' then
3337:
3338: if g_debug then

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

3335:
3336: if l_inputs(i).name = 'TIMECARD_BB_ID' then
3337:
3338: if g_debug then
3339: hr_utility.set_location(l_proc, 40);
3340: end if;
3341: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3342: itemtype => p_itemtype,
3343: itemkey => p_itemkey,

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

3344: aname => 'TC_BLD_BLK_ID');
3345:
3346: elsif l_inputs(i).name = 'TIMECARD_BB_OVN' then
3347: if g_debug then
3348: hr_utility.set_location(l_proc, 50);
3349: end if;
3350: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3351: itemtype => p_itemtype,
3352: itemkey => p_itemkey,

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

3353: aname => 'TC_BLD_BLK_OVN');
3354:
3355: elsif l_inputs(i).name = 'APPLICATION_PERIOD_BB_ID' then
3356: if g_debug then
3357: hr_utility.set_location(l_proc, 60);
3358: end if;
3359: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3360: itemtype => p_itemtype,
3361: itemkey => p_itemkey,

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

3362: aname => 'APP_BB_ID');
3363:
3364: elsif l_inputs(i).name = 'APPLICATION_PERIOD_BB_OVN' then
3365: if g_debug then
3366: hr_utility.set_location(l_proc, 70);
3367: end if;
3368: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3369: itemtype => p_itemtype,
3370: itemkey => p_itemkey,

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

3371: aname => 'APP_BB_OVN');
3372:
3373: elsif l_inputs(i).name = 'TIME_RECIPIENT_ID' then
3374: if g_debug then
3375: hr_utility.set_location(l_proc, 80);
3376: end if;
3377: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3378: itemtype => p_itemtype,
3379: itemkey => p_itemkey,

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

3381: l_inputs(i).value := 5;
3382:
3383: elsif l_inputs(i).name = 'RESOURCE_ID' then
3384: if g_debug then
3385: hr_utility.set_location(l_proc, 90);
3386: end if;
3387: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3388: itemtype => p_itemtype,
3389: itemkey => p_itemkey,

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

3390: aname => 'RESOURCE_ID');
3391:
3392: elsif l_inputs(i).name = 'RESOURCE_TYPE' then
3393: if g_debug then
3394: hr_utility.set_location(l_proc, 100);
3395: end if;
3396: l_inputs(i).value := 'abc';
3397:
3398: else

Line 3402: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

3398: else
3399: --
3400: -- context not recognised
3401: --
3402: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3403: hr_utility.set_message_token('PROCEDURE', l_proc);
3404: hr_utility.set_message_token('STEP', '20');
3405: hr_utility.raise_error;
3406: end if;

Line 3403: hr_utility.set_message_token('PROCEDURE', l_proc);

3399: --
3400: -- context not recognised
3401: --
3402: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3403: hr_utility.set_message_token('PROCEDURE', l_proc);
3404: hr_utility.set_message_token('STEP', '20');
3405: hr_utility.raise_error;
3406: end if;
3407: end loop;

Line 3404: hr_utility.set_message_token('STEP', '20');

3400: -- context not recognised
3401: --
3402: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3403: hr_utility.set_message_token('PROCEDURE', l_proc);
3404: hr_utility.set_message_token('STEP', '20');
3405: hr_utility.raise_error;
3406: end if;
3407: end loop;
3408: end if; -- Bug 8646570

Line 3405: hr_utility.raise_error;

3401: --
3402: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3403: hr_utility.set_message_token('PROCEDURE', l_proc);
3404: hr_utility.set_message_token('STEP', '20');
3405: hr_utility.raise_error;
3406: end if;
3407: end loop;
3408: end if; -- Bug 8646570
3409:

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

3407: end loop;
3408: end if; -- Bug 8646570
3409:
3410: if g_debug then
3411: hr_utility.set_location(l_proc, 110);
3412: end if;
3413: --sb_msgs_pkg.trace('STEP 30 - before run_formula()');
3414: ff_exec.run_formula(l_inputs, l_outputs);
3415:

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

3413: --sb_msgs_pkg.trace('STEP 30 - before run_formula()');
3414: ff_exec.run_formula(l_inputs, l_outputs);
3415:
3416: if g_debug then
3417: hr_utility.set_location(l_proc, 120);
3418: end if;
3419:
3420: --
3421: -- obtain return values,

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

3425:
3426: for i in l_outputs.first..l_outputs.last loop
3427:
3428: if g_debug then
3429: hr_utility.set_location(l_proc, 130);
3430: end if;
3431:
3432: if l_outputs(i).name = 'APPROVAL_MECHANISM' then
3433: l_approval_mechanism := l_outputs(i).value;

Line 3451: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

3447: elsif l_outputs(i).name = 'FORMULA_MESSAGE' then
3448: l_formula_message := l_outputs(i).value;
3449:
3450: else
3451: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3452: hr_utility.set_message_token('PROCEDURE', l_proc);
3453: hr_utility.set_message_token('STEP', '50');
3454: hr_utility.raise_error;
3455: end if;

Line 3452: hr_utility.set_message_token('PROCEDURE', l_proc);

3448: l_formula_message := l_outputs(i).value;
3449:
3450: else
3451: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3452: hr_utility.set_message_token('PROCEDURE', l_proc);
3453: hr_utility.set_message_token('STEP', '50');
3454: hr_utility.raise_error;
3455: end if;
3456: end loop;

Line 3453: hr_utility.set_message_token('STEP', '50');

3449:
3450: else
3451: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3452: hr_utility.set_message_token('PROCEDURE', l_proc);
3453: hr_utility.set_message_token('STEP', '50');
3454: hr_utility.raise_error;
3455: end if;
3456: end loop;
3457:

Line 3454: hr_utility.raise_error;

3450: else
3451: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3452: hr_utility.set_message_token('PROCEDURE', l_proc);
3453: hr_utility.set_message_token('STEP', '50');
3454: hr_utility.raise_error;
3455: end if;
3456: end loop;
3457:
3458: --

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

3458: --
3459: -- check whether formual has raised an error and act appropriately
3460: --
3461: if g_debug then
3462: hr_utility.set_location(l_proc, 140);
3463: end if;
3464:
3465: if l_formula_status = 'E' then
3466: --

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

3466: --
3467: -- formula has failed, raise an error
3468: --
3469: if g_debug then
3470: hr_utility.set_location(l_proc, 150);
3471: end if;
3472:
3473: if l_formula_message is null then
3474: --

Line 3479: hr_utility.raise_error;

3475: -- user not defined an error message, raise OTC default message
3476: -- stub - need our own error message
3477: --
3478: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
3479: hr_utility.raise_error;
3480: else
3481: --
3482: -- user has defined message, raise it
3483: --

Line 3486: hr_utility.raise_error;

3482: -- user has defined message, raise it
3483: --
3484: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3485: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3486: hr_utility.raise_error;
3487: end if;
3488:
3489: elsif l_formula_status = 'W' then
3490:

Line 3492: hr_utility.set_location(l_proc, 160);

3488:
3489: elsif l_formula_status = 'W' then
3490:
3491: if g_debug then
3492: hr_utility.set_location(l_proc, 160);
3493: end if;
3494: --
3495: -- formula has failed, but only warning necessary
3496: --

Line 3502: hr_utility.set_warning;

3498: --
3499: -- user has not defined an error message
3500: --
3501: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
3502: hr_utility.set_warning;
3503: else
3504: --
3505: -- user has defined message, raise it
3506: --

Line 3509: hr_utility.set_warning;

3505: -- user has defined message, raise it
3506: --
3507: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3508: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3509: hr_utility.set_warning;
3510: end if;
3511: end if;
3512:
3513: --

Line 3519: hr_utility.set_location(l_proc, 170);

3515: --
3516: -- auto approval no further context is required
3517: --
3518: if g_debug then
3519: hr_utility.set_location(l_proc, 170);
3520: end if;
3521:
3522: if l_approval_mechanism = 'AUTO_APPROVE' then
3523: --sb_msgs_pkg.trace('formula selects auto approve approval');

Line 3532: hr_utility.set_location(l_proc, 180);

3528: --
3529: elsif l_approval_mechanism = 'PERSON' then
3530: --sb_msgs_pkg.trace('formula selects person approval');
3531: if g_debug then
3532: hr_utility.set_location(l_proc, 180);
3533: end if;
3534:
3535: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3536: itemkey => p_itemkey,

Line 3541: hr_utility.set_location(l_proc, 190);

3537: aname => 'APR_PERSON_ID',
3538: avalue => l_approval_mechanism_id);
3539:
3540: if g_debug then
3541: hr_utility.set_location(l_proc, 190);
3542: end if;
3543:
3544: --
3545: -- HR supervisor approval, approving person id can derived from

Line 3578: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

3574: elsif l_approval_mechanism = 'PROJECT_MANAGER'
3575: then
3576: NULL;
3577: else
3578: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3579: hr_utility.set_message_token('PROCEDURE', l_proc);
3580: hr_utility.set_message_token('STEP', '60');
3581: hr_utility.raise_error;
3582: end if;

Line 3579: hr_utility.set_message_token('PROCEDURE', l_proc);

3575: then
3576: NULL;
3577: else
3578: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3579: hr_utility.set_message_token('PROCEDURE', l_proc);
3580: hr_utility.set_message_token('STEP', '60');
3581: hr_utility.raise_error;
3582: end if;
3583:

Line 3580: hr_utility.set_message_token('STEP', '60');

3576: NULL;
3577: else
3578: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3579: hr_utility.set_message_token('PROCEDURE', l_proc);
3580: hr_utility.set_message_token('STEP', '60');
3581: hr_utility.raise_error;
3582: end if;
3583:
3584: --

Line 3581: hr_utility.raise_error;

3577: else
3578: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3579: hr_utility.set_message_token('PROCEDURE', l_proc);
3580: hr_utility.set_message_token('STEP', '60');
3581: hr_utility.raise_error;
3582: end if;
3583:
3584: --
3585: -- set result code for transition to next activity

Line 3791: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

3787: );
3788: p_result := 'COMPLETE:REJECTED';
3789:
3790: else
3791: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3792: hr_utility.set_message_token('PROCEDURE', l_proc);
3793: hr_utility.set_message_token('STEP', '10');
3794: hr_utility.raise_error;
3795: end if;

Line 3792: hr_utility.set_message_token('PROCEDURE', l_proc);

3788: p_result := 'COMPLETE:REJECTED';
3789:
3790: else
3791: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3792: hr_utility.set_message_token('PROCEDURE', l_proc);
3793: hr_utility.set_message_token('STEP', '10');
3794: hr_utility.raise_error;
3795: end if;
3796: end if;

Line 3793: hr_utility.set_message_token('STEP', '10');

3789:
3790: else
3791: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3792: hr_utility.set_message_token('PROCEDURE', l_proc);
3793: hr_utility.set_message_token('STEP', '10');
3794: hr_utility.raise_error;
3795: end if;
3796: end if;
3797:

Line 3794: hr_utility.raise_error;

3790: else
3791: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3792: hr_utility.set_message_token('PROCEDURE', l_proc);
3793: hr_utility.set_message_token('STEP', '10');
3794: hr_utility.raise_error;
3795: end if;
3796: end if;
3797:
3798: if p_funcmode = 'CANCEL' then

Line 3834: g_debug:=hr_utility.debug_enabled;

3830:
3831: l_proc VARCHAR2(150);
3832:
3833: BEGIN
3834: g_debug:=hr_utility.debug_enabled;
3835: if g_debug then
3836: l_proc := 'set_next_app_period';
3837: hr_utility.trace('in set next period');
3838: end if;

Line 3837: hr_utility.trace('in set next period');

3833: BEGIN
3834: g_debug:=hr_utility.debug_enabled;
3835: if g_debug then
3836: l_proc := 'set_next_app_period';
3837: hr_utility.trace('in set next period');
3838: end if;
3839: IF p_funcmode = 'RUN'
3840: THEN
3841: l_next_period_id := wf_engine.GetItemAttrNumber(

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

3843: itemkey => p_itemkey,
3844: aname => 'NEXT_APP_BB_ID');
3845:
3846: if g_debug then
3847: hr_utility.set_location(l_proc, 60);
3848: end if;
3849:
3850: l_next_period_ovn := wf_engine.GetItemAttrNumber(
3851: itemtype => p_itemtype,

Line 3877: hr_utility.trace('next app id=' || l_next_period_id);

3873: avalue => '');
3874:
3875:
3876: if g_debug then
3877: hr_utility.trace('next app id=' || l_next_period_id);
3878: hr_utility.trace('next app ovn=' || l_next_period_ovn);
3879: end if;
3880: p_result := 'COMPLETE';
3881: END IF;

Line 3878: hr_utility.trace('next app ovn=' || l_next_period_ovn);

3874:
3875:
3876: if g_debug then
3877: hr_utility.trace('next app id=' || l_next_period_id);
3878: hr_utility.trace('next app ovn=' || l_next_period_ovn);
3879: end if;
3880: p_result := 'COMPLETE';
3881: END IF;
3882: