DBA Data[Home] [Help]

APPS.XDPCORE_ORU dependencies on XDPCORE_ORU

Line 1: PACKAGE BODY XDPCORE_ORU AS

1: PACKAGE BODY XDPCORE_ORU AS
2: /* $Header: XDPCORUB.pls 120.1 2005/06/15 22:40:59 appldev $ */
3:
4:
5: /****

Line 58: wf_core.context('XDPCORE_ORU', 'INITIALIZE_ORU_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

54:
55:
56: EXCEPTION
57: WHEN OTHERS THEN
58: wf_core.context('XDPCORE_ORU', 'INITIALIZE_ORU_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
59: raise;
60: END INITIALIZE_ORU_PROCESS;
61:
62:

Line 96: wf_core.context('XDPCORE_ORU', 'LAUNCH_RESUBMISSION_FAS', itemtype, itemkey, to_char(actid), funcmode);

92:
93:
94: EXCEPTION
95: WHEN OTHERS THEN
96: wf_core.context('XDPCORE_ORU', 'LAUNCH_RESUBMISSION_FAS', itemtype, itemkey, to_char(actid), funcmode);
97: raise;
98: END LAUNCH_RESUBMISSION_FAS;
99:
100:

Line 132: wf_core.context('XDPCORE_ORU', 'SET_ORU_STATUS', itemtype, itemkey, to_char(actid), funcmode);

128:
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: wf_core.context('XDPCORE_ORU', 'SET_ORU_STATUS', itemtype, itemkey, to_char(actid), funcmode);
133: raise;
134: END SET_ORU_STATUS;
135:
136: /****

Line 256: x_Progress := 'XDPCORE_ORU.LaunchResubmissionFAs. No Jobs found to be processed for Resubmission Job ID: ' || l_ResubmissionJOBID;

252:
253: CLOSE c_GetResubFAs;
254:
255: IF l_Counter = 0 THEN
256: x_Progress := 'XDPCORE_ORU.LaunchResubmissionFAs. No Jobs found to be processed for Resubmission Job ID: ' || l_ResubmissionJOBID;
257: RAISE e_NoJobsFoundException;
258:
259: ELSE
260: null;

Line 268: wf_core.context('XDPCORE_ORU', 'LaunchResubmissionFAs', itemtype, itemkey, null,x_progress);

264:
265: EXCEPTION
266: WHEN e_LaunchFAException THEN
267:
268: wf_core.context('XDPCORE_ORU', 'LaunchResubmissionFAs', itemtype, itemkey, null,x_progress);
269: raise;
270:
271: when e_NoJobsFoundException THEN
272:

Line 277: wf_core.context('XDPCORE_ORU', 'LaunchResubmissionFAs', itemtype, itemkey, null,null);

273: IF c_GetResubFAs%ISOPEN THEN
274: close c_GetResubFAs;
275: END IF;
276:
277: wf_core.context('XDPCORE_ORU', 'LaunchResubmissionFAs', itemtype, itemkey, null,null);
278: raise;
279:
280: WHEN others THEN
281:

Line 286: x_Progress := 'XDPCORE_ORU.LaunchResubmissionFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

282: IF c_GetResubFAs%ISOPEN THEN
283: close c_GetResubFAs;
284: END IF;
285:
286: x_Progress := 'XDPCORE_ORU.LaunchResubmissionFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
287: wf_core.context('XDPCORE_ORU', 'LaunchResubmissionFAs', itemtype, itemkey, null,null);
288: raise;
289: END LaunchResubmissionFAs;
290:

Line 287: wf_core.context('XDPCORE_ORU', 'LaunchResubmissionFAs', itemtype, itemkey, null,null);

283: close c_GetResubFAs;
284: END IF;
285:
286: x_Progress := 'XDPCORE_ORU.LaunchResubmissionFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
287: wf_core.context('XDPCORE_ORU', 'LaunchResubmissionFAs', itemtype, itemkey, null,null);
288: raise;
289: END LaunchResubmissionFAs;
290:
291:

Line 316: x_Progress := 'XDPCORE_ORU.InitializeORUProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

312: WHERE resubmission_job_id = l_ResubmissionJobID;
313:
314: EXCEPTION
315: WHEN others THEN
316: x_Progress := 'XDPCORE_ORU.InitializeORUProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
317: wf_core.context('XDPCORE_ORU', 'InitializeORUProcess', itemtype, itemkey, null,null);
318: raise;
319: END InitializeORUProcess;
320:

Line 317: wf_core.context('XDPCORE_ORU', 'InitializeORUProcess', itemtype, itemkey, null,null);

313:
314: EXCEPTION
315: WHEN others THEN
316: x_Progress := 'XDPCORE_ORU.InitializeORUProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
317: wf_core.context('XDPCORE_ORU', 'InitializeORUProcess', itemtype, itemkey, null,null);
318: raise;
319: END InitializeORUProcess;
320:
321:

Line 345: x_Progress := 'XDPCORE_ORU.SetORUStatus. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

341: WHERE resubmission_job_id = l_ResubmissionJobID;
342:
343: EXCEPTION
344: WHEN others THEN
345: x_Progress := 'XDPCORE_ORU.SetORUStatus. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
346: wf_core.context('XDPCORE_ORU', 'SetORUStatus', itemtype, itemkey, null,null);
347: raise;
348: END SetORUStatus;
349:

Line 346: wf_core.context('XDPCORE_ORU', 'SetORUStatus', itemtype, itemkey, null,null);

342:
343: EXCEPTION
344: WHEN others THEN
345: x_Progress := 'XDPCORE_ORU.SetORUStatus. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
346: wf_core.context('XDPCORE_ORU', 'SetORUStatus', itemtype, itemkey, null,null);
347: raise;
348: END SetORUStatus;
349:
350: END XDPCORE_ORU;

Line 350: END XDPCORE_ORU;

346: wf_core.context('XDPCORE_ORU', 'SetORUStatus', itemtype, itemkey, null,null);
347: raise;
348: END SetORUStatus;
349:
350: END XDPCORE_ORU;