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.12.12020000.2 2012/07/04 23:56:16 amnaraya ship $ */
3:
4: -- Package Variables
5: --

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

2: /* $Header: hrsflutlss.pkb 120.12.12020000.2 2012/07/04 23:56:16 amnaraya 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 660: hr_utility.set_location('HR_SFLUTIL_SS.getSFLTransactionDetails errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

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

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

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

Line 744: hr_sflutil_ss.getsfltransactiondetails(p_transaction_id,

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

Line 1166: END HR_SFLUTIL_SS;

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