APPS.HR_SFLUTIL_SS dependencies on HR_SFLUTIL_SS

Line 1: PACKAGE BODY HR_SFLUTIL_SS AS

1: PACKAGE BODY HR_SFLUTIL_SS AS
2: /* $Header: hrsflutlss.pkb 120.8.12000000.5 2007/09/27 10:47:14 dbatra ship $ */
3:
4: -- Package Variables
5: --

Line 6: g_package constant varchar2(14) := 'hr_sflutil_ss.';

2: /* $Header: hrsflutlss.pkb 120.8.12000000.5 2007/09/27 10:47:14 dbatra ship $ */
3:
4: -- Package Variables
5: --
6: g_package constant varchar2(14) := 'hr_sflutil_ss.';
7: g_debug boolean ;
8:
9: --5672792
10: function isCurrentTxnSFLClose ( p_transaction_id hr_api_transactions.transaction_id%type )

Line 48: if HR_SFLUTIL_SS.OpenNotificationsExist(wf_engine.getitemattrnumber(p_item_type,p_item_key,'HR_LAST_SFL_NTF_ID_ATTR',true))=false then

44: --hr_utility.trace_off();
45: return result;
46: end;
47:
48: if HR_SFLUTIL_SS.OpenNotificationsExist(wf_engine.getitemattrnumber(p_item_type,p_item_key,'HR_LAST_SFL_NTF_ID_ATTR',true))=false then
49: if g_debug then
50: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 4);
51: end if;
52: result := 'TRUE';

Line 106: Wf_Core.Context('HR_SFLUTIL_SS.sflBlock', itemtype,

102: end if;
103:
104: exception
105: when others then
106: Wf_Core.Context('HR_SFLUTIL_SS.sflBlock', itemtype,
107: itemkey, to_char(actid), funmode);
108: raise;
109: end sflBlock;
110:

Line 177: Wf_Core.Context('HR_SFLUTIL_SS.closeSFLTransaction', itemtype,

173: end if;
174: end if;
175: exception
176: when others then
177: Wf_Core.Context('HR_SFLUTIL_SS.closeSFLTransaction', itemtype,
178: itemkey, to_char(actid), funmode);
179: raise;
180: end closeSFLTransaction;
181:

Line 301: Wf_Core.Context('HR_SFLUTIL_SS.Notify', itemtype,

297: notid:= Wf_Engine.g_nid ;
298:
299: exception
300: when others then
301: Wf_Core.Context('HR_SFLUTIL_SS.Notify', itemtype,
302: itemkey, to_char(actid), funcmode);
303: raise;
304: end Notify;
305:

Line 542: hr_utility.set_location('HR_SFLUTIL_SS.getSFLMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);

538:
539: exception
540: when others then
541: document :=null;
542: hr_utility.set_location('HR_SFLUTIL_SS.getSFLMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
543: Wf_Core.Context('HR_SFLUTIL_SS', 'getSFLMsgSubject', document_id, display_type);
544: raise;
545: end getSFLMsgSubject;
546:

Line 543: Wf_Core.Context('HR_SFLUTIL_SS', 'getSFLMsgSubject', document_id, display_type);

539: exception
540: when others then
541: document :=null;
542: hr_utility.set_location('HR_SFLUTIL_SS.getSFLMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
543: Wf_Core.Context('HR_SFLUTIL_SS', 'getSFLMsgSubject', document_id, display_type);
544: raise;
545: end getSFLMsgSubject;
546:
547:

Line 659: hr_utility.set_location('HR_SFLUTIL_SS.getSFLTransactionDetails errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

655:
656:
657: exception
658: when others then
659: hr_utility.set_location('HR_SFLUTIL_SS.getSFLTransactionDetails errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
660: Wf_Core.Context('HR_SFLUTIL_SS', 'getSFLTransactionDetails', p_transaction_id);
661: raise;
662: end getSFLTransactionDetails;
663:

Line 660: Wf_Core.Context('HR_SFLUTIL_SS', 'getSFLTransactionDetails', p_transaction_id);

656:
657: exception
658: when others then
659: hr_utility.set_location('HR_SFLUTIL_SS.getSFLTransactionDetails errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
660: Wf_Core.Context('HR_SFLUTIL_SS', 'getSFLTransactionDetails', p_transaction_id);
661: raise;
662: end getSFLTransactionDetails;
663:
664: procedure startSFLTransaction(p_transaction_id IN NUMBER

Line 743: hr_sflutil_ss.getsfltransactiondetails(p_transaction_id,

739: lv_process_name wf_items.root_activity%type;
740: ln_sfl_block_activity_id number;
741: lv_relaunchSFLLink varchar2(2000);
742: begin
743: hr_sflutil_ss.getsfltransactiondetails(p_transaction_id,
744: ln_notification_id,
745: lv_item_type,
746: lv_item_key);
747: if(lv_item_key is null) then

Line 1165: END HR_SFLUTIL_SS;

1161: end closeOpenSFLNotification;
1162:
1163:
1164:
1165: END HR_SFLUTIL_SS;