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 882: wf_core.context('PSP_EFFORT_REPORTS', 'GET_NEXT_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

878: exception
879: when others then
880: result := 'ERROR';
881: --result := substr(sqlerrm,15);
882: wf_core.context('PSP_EFFORT_REPORTS', 'GET_NEXT_APPROVER', itemtype, itemkey, to_char(actid), funcmode);
883: raise;
884: end;
885:
886: procedure process_rejections(itemtype in varchar2,

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

1110: exception
1111: when others then
1112: hr_utility.trace('er_workflow -->when others then exception occured Error = '||sqlerrm);
1113: result := 'ERROR';
1114: wf_core.context('PSP_EFFORT_REPORTS', 'PROCESS_REJECTIONS', itemtype, itemkey, to_char(actid), funcmode);
1115: --- debug;
1116: raise;
1117: end;
1118:

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

1237: exception
1238: when others then
1239: result := 'ERROR';
1240: --result := result||'=='||sqlerrm;
1241: wf_core.context('PSP_EFFORT_REPORTS', 'PROCESS_APPROVALS', itemtype, itemkey, to_char(actid), funcmode);
1242: raise;
1243: end;
1244: procedure approver_post_notify(itemtype in varchar2,
1245: itemkey in varchar2,

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

1547: exception
1548: when others then
1549: result := 'ERROR';
1550: --result := result||'=='||sqlerrm;
1551: wf_core.context('PSP_EFFORT_REPORTS', 'APPROVER_POST_NOTIFY', itemtype, itemkey, to_char(actid), funcmode);
1552: raise;
1553: end;
1554:
1555: procedure set_pdf_gen_failures(itemtype in varchar2,

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

1654: result := 'COMPLETE';
1655: exception
1656: when others then
1657: result := 'ERROR';
1658: wf_core.context('PSP_EFFORT_REPORTS', 'APPROVER_PDF_FAIL', itemtype, itemkey, to_char(actid), funcmode);
1659: raise;
1660: end;
1661:
1662: procedure start_initiator_wf(p_request_id in integer)

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

1959: end if;
1960: exception
1961: when others then
1962: result := 'ERROR';
1963: wf_core.context('PSP_EFFORT_REPORTS', 'INITIATOR_RESPONSE', itemtype, itemkey, to_char(actid), funcmode);
1964: raise;
1965: end;
1966:
1967: procedure create_frp_role(itemtype in varchar2,

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

2045: when others then
2046: ---l_debug := sqlerrm;
2047: ---hr_utility.trace('er_workflow --> 120'||l_debug);
2048: result := 'ERROR';
2049: wf_core.context('PSP_EFFORT_REPORTS', 'CREATE_FRP_ROLE', itemtype, itemkey, to_char(actid), funcmode);
2050: end;
2051:
2052: procedure get_pdf_for_apprvr(itemtype in varchar2,
2053: itemkey in varchar2,

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

2206: end if;
2207: exception
2208: when others then
2209: result := 'ERROR';
2210: wf_core.context('PSP_EFFORT_REPORTS', 'PRE_APPROVED', itemtype, itemkey, to_char(actid),
2211: funcmode);
2212:
2213: end;
2214:

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

2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: -- Populate stack with error message
2236: result := 'ERROR';
2237: wf_core.context('PSP_EFFORT_REPORTS', 'update_initiator_message', itemtype, itemkey, to_char(actid), funcmode);
2238: RAISE;
2239: END update_initiator_message;
2240:
2241: PROCEDURE set_wf_admin(itemtype IN varchar2,

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

2284: result);
2285: EXCEPTION
2286: WHEN OTHERS THEN
2287: result := 'ERROR';
2288: wf_core.context('PSP_EFFORT_REPORTS', 'SET_WF_ADMIN', itemtype, itemkey, to_char(actid), funcmode);
2289: raise;
2290: END;
2291:
2292: PROCEDURE get_timeout_approver(itemtype IN varchar2,

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

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

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

2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: -- Populate stack with error message
2338: result := 'ERROR';
2339: wf_core.context('PSP_EFFORT_REPORTS', 'PREVIEW_ER', itemtype, itemkey, TO_CHAR(actid), funcmode);
2340: RAISE;
2341: END preview_er;
2342:
2343: -- Added this function for Bug 7135471