DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_WF_PKG dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_timekeeper_wf_pkg AS
2: /* $Header: hxctimekeeperwf.pkb 120.4 2007/01/10 21:14:38 arundell noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: -------------------------------------------------------------------
7: -- Function to get the next Item Key for the Process
8: -------------------------------------------------------------------

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

236: fetch c_updated_by into l_login;
237:
238: if (c_updated_by%NOTFOUND) then
239: close c_updated_by;
240: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
241: hr_utility.set_message_token('PROCEDURE', l_proc);
242: hr_utility.set_message_token('STEP', '20');
243: hr_utility.raise_error;
244: end if;

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

237:
238: if (c_updated_by%NOTFOUND) then
239: close c_updated_by;
240: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
241: hr_utility.set_message_token('PROCEDURE', l_proc);
242: hr_utility.set_message_token('STEP', '20');
243: hr_utility.raise_error;
244: end if;
245: close c_updated_by;

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

238: if (c_updated_by%NOTFOUND) then
239: close c_updated_by;
240: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
241: hr_utility.set_message_token('PROCEDURE', l_proc);
242: hr_utility.set_message_token('STEP', '20');
243: hr_utility.raise_error;
244: end if;
245: close c_updated_by;
246: end if;

Line 243: hr_utility.raise_error;

239: close c_updated_by;
240: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
241: hr_utility.set_message_token('PROCEDURE', l_proc);
242: hr_utility.set_message_token('STEP', '20');
243: hr_utility.raise_error;
244: end if;
245: close c_updated_by;
246: end if;
247:

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

691: into l_resource_id, l_tc_start_time, l_tc_stop_time;
692:
693: if c_tc_info%notfound then
694: close c_tc_info;
695: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
696: hr_utility.set_message_token('PROCEDURE', l_proc);
697: hr_utility.set_message_token('STEP', '12');
698: hr_utility.raise_error;
699: end if;

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

692:
693: if c_tc_info%notfound then
694: close c_tc_info;
695: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
696: hr_utility.set_message_token('PROCEDURE', l_proc);
697: hr_utility.set_message_token('STEP', '12');
698: hr_utility.raise_error;
699: end if;
700: close c_tc_info;

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

693: if c_tc_info%notfound then
694: close c_tc_info;
695: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
696: hr_utility.set_message_token('PROCEDURE', l_proc);
697: hr_utility.set_message_token('STEP', '12');
698: hr_utility.raise_error;
699: end if;
700: close c_tc_info;
701:

Line 698: hr_utility.raise_error;

694: close c_tc_info;
695: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
696: hr_utility.set_message_token('PROCEDURE', l_proc);
697: hr_utility.set_message_token('STEP', '12');
698: hr_utility.raise_error;
699: end if;
700: close c_tc_info;
701:
702: wf_engine.SetItemAttrDate(itemtype => p_itemtype,

Line 817: g_debug := hr_utility.debug_enabled;

813: l_timekeeper_id hxc_time_building_blocks.resource_id%TYPE;
814: l_tc_url varchar2(1000);
815: BEGIN
816:
817: g_debug := hr_utility.debug_enabled;
818:
819: l_tc_bb_id := wf_engine.GetItemAttrNumber(
820: itemtype => p_itemtype,
821: itemkey => p_itemkey,

Line 826: hr_utility.trace('l_tc_bb_id='||l_tc_bb_id);

822: aname => 'TC_BLD_BLK_ID');
823:
824: if g_debug then
825: l_proc := 'hxc_timekeeper_wf_pkg.PERSON_NOTIFY';
826: hr_utility.trace('l_tc_bb_id='||l_tc_bb_id);
827: end if;
828:
829: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(
830: itemtype => p_itemtype,

Line 835: hr_utility.trace('l_tc_bb_ovn='||l_tc_bb_ovn);

831: itemkey => p_itemkey,
832: aname => 'TC_BLD_BLK_OVN');
833:
834: if g_debug then
835: hr_utility.trace('l_tc_bb_ovn='||l_tc_bb_ovn);
836: end if;
837:
838: l_resource_id := wf_engine.GetItemAttrNumber(
839: itemtype => p_itemtype,

Line 844: hr_utility.trace('l_resource_id='||l_resource_id);

840: itemkey => p_itemkey,
841: aname => 'RESOURCE_ID');
842:
843: if g_debug then
844: hr_utility.trace('l_resource_id='||l_resource_id);
845: end if;
846:
847: l_start_date := wf_engine.GetItemAttrDate(
848: itemtype => p_itemtype,

Line 853: hr_utility.trace('l_start_date='||to_char(l_start_date));

849: itemkey => p_itemkey ,
850: aname => 'TC_START');
851:
852: if g_debug then
853: hr_utility.trace('l_start_date='||to_char(l_start_date));
854: end if;
855:
856: l_stop_date := wf_engine.GetItemAttrDate(
857: itemtype => p_itemtype,

Line 862: hr_utility.trace('l_stop_date='||to_char(l_stop_date));

858: itemkey => p_itemkey ,
859: aname => 'TC_STOP');
860:
861: if g_debug then
862: hr_utility.trace('l_stop_date='||to_char(l_stop_date));
863: end if;
864:
865: l_ntf_type := wf_engine.GetItemAttrText(
866: itemtype => p_itemtype,

Line 871: hr_utility.trace('l_ntf_type='||l_ntf_type);

867: itemkey => p_itemkey ,
868: aname => 'APR_NOTIFY_TYPE');
869:
870: if g_debug then
871: hr_utility.trace('l_ntf_type='||l_ntf_type);
872: end if;
873:
874: l_timekeeper_id := wf_engine.GetItemAttrNumber(
875: itemtype => p_itemtype,

Line 880: hr_utility.trace('l_timekeeper_id='||l_timekeeper_id);

876: itemkey => p_itemkey,
877: aname => 'TIMEKEEPER_ID');
878:
879: if g_debug then
880: hr_utility.trace('l_timekeeper_id='||l_timekeeper_id);
881: end if;
882:
883: wf_engine.SetItemAttrNumber(
884: itemtype => p_itemtype,

Line 890: hr_utility.trace('before login');

886: aname => 'APR_PERSON_ID',
887: avalue => l_resource_id);
888:
889: if g_debug then
890: hr_utility.trace('before login');
891: end if;
892:
893: l_login := set_login(p_person_id => l_timekeeper_id
894: ,p_tc_bb_id => l_tc_bb_id

Line 898: hr_utility.trace('l_login'||l_login);

894: ,p_tc_bb_id => l_tc_bb_id
895: ,p_tc_bb_ovn => l_tc_bb_ovn );
896:
897: if g_debug then
898: hr_utility.trace('l_login'||l_login);
899: end if;
900:
901: --set role attribute
902: wf_engine.SetItemAttrText(

Line 913: hr_utility.trace('l_fyi_login='||l_fyi_login);

909: ,p_tc_bb_id => l_tc_bb_id
910: ,p_tc_bb_ovn => l_tc_bb_ovn );
911:
912: if g_debug then
913: hr_utility.trace('l_fyi_login='||l_fyi_login);
914: end if;
915:
916: wf_engine.SetItemAttrText(
917: itemtype => p_itemtype,

Line 948: hr_utility.trace('l_title='||substr(l_title,1,20));

944:
945: l_title := fnd_message.get();
946:
947: if g_debug then
948: hr_utility.trace('l_title='||substr(l_title,1,20));
949: end if;
950:
951: wf_engine.SetItemAttrText(
952: itemtype => p_itemtype,

Line 960: hr_utility.trace('l_otl_appr_id='||l_otl_appr_id);

956:
957: l_otl_appr_id := l_tc_bb_id||'#'||p_itemkey;
958:
959: if g_debug then
960: hr_utility.trace('l_otl_appr_id='||l_otl_appr_id);
961: end if;
962:
963: wf_engine.SetItemAttrText(
964: itemtype => p_itemtype,

Line 1229: g_debug := hr_utility.debug_enabled;

1225: and (date_to=hr_general.end_of_time OR date_to is NULL);
1226:
1227: BEGIN
1228:
1229: g_debug := hr_utility.debug_enabled;
1230:
1231: l_tc_resource_id := wf_engine.GetItemAttrNumber(
1232: itemtype => p_itemtype,
1233: itemkey => p_itemkey ,

Line 1329: hr_utility.trace(sqlerrm);

1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: --
1328: if g_debug then
1329: hr_utility.trace(sqlerrm);
1330: end if;
1331: IF sqlerrm like '%HXC_TIME_BLD_BLK_NOT_LATEST%' THEN
1332: RETURN;
1333: END IF;