DBA Data[Home] [Help]

APPS.PSP_ER_WORKFLOW dependencies on WF_CORE

Line 63: wf_core.context('PSP_EFFORT_REPORTS', 'FATAL_ERR_OCCURED', itemtype, itemkey, to_char(actid), funcmode);

59: exception
60: when others then
61: -- populate stack with error message
62: result := 'ERROR';
63: wf_core.context('PSP_EFFORT_REPORTS', 'FATAL_ERR_OCCURED', itemtype, itemkey, to_char(actid), funcmode);
64: raise;
65: end;
66:
67: /* Main Procedure */

Line 178: wf_core.context('PSP_EFFORT_REPORTS', 'RECORD_INITIATOR_APPRVL', itemtype, itemkey, to_char(actid), funcmode);

174: exception
175: when others then
176: -- populate stack with error message
177: result := 'ERROR';
178: wf_core.context('PSP_EFFORT_REPORTS', 'RECORD_INITIATOR_APPRVL', itemtype, itemkey, to_char(actid), funcmode);
179: raise;
180:
181: end;
182:

Line 201: wf_core.context('PSP_EFFORT_REPORTS', 'RECORD_INITIATOR', itemtype, itemkey, to_char(actid), funcmode);

197: exception
198: when others then
199: -- populate stack with error message
200: result := 'ERROR';
201: wf_core.context('PSP_EFFORT_REPORTS', 'RECORD_INITIATOR', itemtype, itemkey, to_char(actid), funcmode);
202: raise;
203: end;
204:
205: procedure init_approvals(itemtype in varchar2,

Line 438: wf_core.context('PSP_EFFORT_REPORTS', 'INIT_APPROVALS', itemtype, itemkey, to_char(actid), funcmode);

434: exception
435: when others then
436: hr_utility.trace('er_workflow --> err '||sqlerrm);
437: result := 'ERROR';
438: wf_core.context('PSP_EFFORT_REPORTS', 'INIT_APPROVALS', itemtype, itemkey, to_char(actid), funcmode);
439: raise;
440: end;
441:
442: procedure purge_er(itemtype in varchar2,

Line 508: wf_core.context('PSP_EFFORT_REPORTS', 'PURGE_ER', itemtype, itemkey, to_char(actid), funcmode);

504:
505: exception
506: when others then
507: result := 'ERROR';
508: wf_core.context('PSP_EFFORT_REPORTS', 'PURGE_ER', itemtype, itemkey, to_char(actid), funcmode);
509: raise;
510: end;
511:
512: /* GET_NEXT_APPROVER:

Line 898: wf_core.context('PSP_EFFORT_REPORTS', 'GET_NEXT_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

894: exception
895: when others then
896: result := 'ERROR';
897: --result := substr(sqlerrm,15);
898: wf_core.context('PSP_EFFORT_REPORTS', 'GET_NEXT_APPROVER', itemtype, itemkey, to_char(actid), funcmode);
899: raise;
900: end;
901:
902: procedure process_rejections(itemtype in varchar2,

Line 1130: wf_core.context('PSP_EFFORT_REPORTS', 'PROCESS_REJECTIONS', itemtype, itemkey, to_char(actid), funcmode);

1126: exception
1127: when others then
1128: hr_utility.trace('er_workflow -->when others then exception occured Error = '||sqlerrm);
1129: result := 'ERROR';
1130: wf_core.context('PSP_EFFORT_REPORTS', 'PROCESS_REJECTIONS', itemtype, itemkey, to_char(actid), funcmode);
1131: --- debug;
1132: raise;
1133: end;
1134:

Line 1273: wf_core.context('PSP_EFFORT_REPORTS', 'PROCESS_APPROVALS', itemtype, itemkey, to_char(actid), funcmode);

1269: exception
1270: when others then
1271: result := 'ERROR';
1272: --result := result||'=='||sqlerrm;
1273: wf_core.context('PSP_EFFORT_REPORTS', 'PROCESS_APPROVALS', itemtype, itemkey, to_char(actid), funcmode);
1274: raise;
1275: end;
1276: procedure approver_post_notify(itemtype in varchar2,
1277: itemkey in varchar2,

Line 1591: wf_core.context('PSP_EFFORT_REPORTS', 'APPROVER_POST_NOTIFY', itemtype, itemkey, to_char(actid), funcmode);

1587: exception
1588: when others then
1589: result := 'ERROR';
1590: --result := result||'=='||sqlerrm;
1591: wf_core.context('PSP_EFFORT_REPORTS', 'APPROVER_POST_NOTIFY', itemtype, itemkey, to_char(actid), funcmode);
1592: raise;
1593: end;
1594:
1595: procedure set_pdf_gen_failures(itemtype in varchar2,

Line 1698: wf_core.context('PSP_EFFORT_REPORTS', 'APPROVER_PDF_FAIL', itemtype, itemkey, to_char(actid), funcmode);

1694: result := 'COMPLETE';
1695: exception
1696: when others then
1697: result := 'ERROR';
1698: wf_core.context('PSP_EFFORT_REPORTS', 'APPROVER_PDF_FAIL', itemtype, itemkey, to_char(actid), funcmode);
1699: raise;
1700: end;
1701:
1702: procedure start_initiator_wf(p_request_id in integer)

Line 2003: wf_core.context('PSP_EFFORT_REPORTS', 'INITIATOR_RESPONSE', itemtype, itemkey, to_char(actid), funcmode);

1999: end if;
2000: exception
2001: when others then
2002: result := 'ERROR';
2003: wf_core.context('PSP_EFFORT_REPORTS', 'INITIATOR_RESPONSE', itemtype, itemkey, to_char(actid), funcmode);
2004: raise;
2005: end;
2006:
2007: procedure create_frp_role(itemtype in varchar2,

Line 2089: wf_core.context('PSP_EFFORT_REPORTS', 'CREATE_FRP_ROLE', itemtype, itemkey, to_char(actid), funcmode);

2085: when others then
2086: ---l_debug := sqlerrm;
2087: ---hr_utility.trace('er_workflow --> 120'||l_debug);
2088: result := 'ERROR';
2089: wf_core.context('PSP_EFFORT_REPORTS', 'CREATE_FRP_ROLE', itemtype, itemkey, to_char(actid), funcmode);
2090: end;
2091:
2092: procedure get_pdf_for_apprvr(itemtype in varchar2,
2093: itemkey in varchar2,

Line 2285: wf_core.context('PSP_EFFORT_REPORTS', 'PRE_APPROVED', itemtype, itemkey, to_char(actid),

2281: end if;
2282: exception
2283: when others then
2284: result := 'ERROR';
2285: wf_core.context('PSP_EFFORT_REPORTS', 'PRE_APPROVED', itemtype, itemkey, to_char(actid),
2286: funcmode);
2287:
2288: end;
2289:

Line 2312: wf_core.context('PSP_EFFORT_REPORTS', 'update_initiator_message', itemtype, itemkey, to_char(actid), funcmode);

2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: -- Populate stack with error message
2311: result := 'ERROR';
2312: wf_core.context('PSP_EFFORT_REPORTS', 'update_initiator_message', itemtype, itemkey, to_char(actid), funcmode);
2313: RAISE;
2314: END update_initiator_message;
2315:
2316: PROCEDURE set_wf_admin(itemtype IN varchar2,

Line 2363: wf_core.context('PSP_EFFORT_REPORTS', 'SET_WF_ADMIN', itemtype, itemkey, to_char(actid), funcmode);

2359: result);
2360: EXCEPTION
2361: WHEN OTHERS THEN
2362: result := 'ERROR';
2363: wf_core.context('PSP_EFFORT_REPORTS', 'SET_WF_ADMIN', itemtype, itemkey, to_char(actid), funcmode);
2364: raise;
2365: END;
2366:
2367: PROCEDURE get_timeout_approver(itemtype IN varchar2,

Line 2385: wf_core.context('PSP_EFFORT_REPORTS', 'GET_TIMEOUT_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: -- Populate stack with error message
2384: result := 'ERROR';
2385: wf_core.context('PSP_EFFORT_REPORTS', 'GET_TIMEOUT_APPROVER', itemtype, itemkey, to_char(actid), funcmode);
2386: RAISE;
2387: END;
2388:
2389: PROCEDURE preview_er (itemtype IN varchar2,

Line 2432: wf_core.context('PSP_EFFORT_REPORTS', 'PREVIEW_ER', itemtype, itemkey, TO_CHAR(actid), funcmode);

2428: EXCEPTION
2429: WHEN OTHERS THEN
2430: -- Populate stack with error message
2431: result := 'ERROR';
2432: wf_core.context('PSP_EFFORT_REPORTS', 'PREVIEW_ER', itemtype, itemkey, TO_CHAR(actid), funcmode);
2433: RAISE;
2434: END preview_er;
2435:
2436: -- Added this function for Bug 7135471