eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EVENT_UTILS dependencies on PA_EVENT_PUB

Line 28: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

24: --handling exceptions
25: Exception
26: When pa_event_core.util_excp then
27: p_project_id := NULL; --NOCOPY
28: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
29: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PROJECT->';
30: Raise pa_event_pvt.pub_excp;
31:
32: When others then

Line 29: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PROJECT->';

25: Exception
26: When pa_event_core.util_excp then
27: p_project_id := NULL; --NOCOPY
28: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
29: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PROJECT->';
30: Raise pa_event_pvt.pub_excp;
31:
32: When others then
33: p_project_id := NULL; --NOCOPY

Line 34: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

30: Raise pa_event_pvt.pub_excp;
31:
32: When others then
33: p_project_id := NULL; --NOCOPY
34: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
35: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PROJECT->';
36: Raise pa_event_pvt.pub_excp;
37:
38: END CHECK_VALID_PROJECT;

Line 35: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PROJECT->';

31:
32: When others then
33: p_project_id := NULL; --NOCOPY
34: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
35: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PROJECT->';
36: Raise pa_event_pvt.pub_excp;
37:
38: END CHECK_VALID_PROJECT;
39: -- ============================================================================

Line 65: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

61: Exception
62: When pa_event_core.util_excp
63: then
64: p_task_id := NULL; --NOCOPY
65: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
66: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_TASK->';
67: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
68:
69: When others

Line 66: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_TASK->';

62: When pa_event_core.util_excp
63: then
64: p_task_id := NULL; --NOCOPY
65: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
66: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_TASK->';
67: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
68:
69: When others
70: then

Line 72: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

68:
69: When others
70: then
71: p_task_id := NULL; --NOCOPY
72: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
73: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_TASK->';
74: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
75:
76: END CHECK_VALID_TASK;

Line 73: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_TASK->';

69: When others
70: then
71: p_task_id := NULL; --NOCOPY
72: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
73: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_TASK->';
74: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
75:
76: END CHECK_VALID_TASK;
77: -- ============================================================================

Line 103: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

99: Exception
100: When pa_event_core.util_excp
101: then
102: x_event_type_classification := NULL; --NOCOPY
103: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
104: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_TYPE->';
105: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
106:
107: When others

Line 104: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_TYPE->';

100: When pa_event_core.util_excp
101: then
102: x_event_type_classification := NULL; --NOCOPY
103: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
104: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_TYPE->';
105: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
106:
107: When others
108: then

Line 110: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

106:
107: When others
108: then
109: x_event_type_classification := NULL; --NOCOPY
110: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
111: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_TYPE->';
112: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
113:
114: END CHECK_VALID_EVENT_TYPE;

Line 111: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_TYPE->';

107: When others
108: then
109: x_event_type_classification := NULL; --NOCOPY
110: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
111: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_TYPE->';
112: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
113:
114: END CHECK_VALID_EVENT_TYPE;
115: -- ============================================================================

Line 140: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

136: Exception
137: When pa_event_core.util_excp
138: then
139: p_event_org_id := NULL; -- NOCOPY
140: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
141: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_ORG->';
142: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
143:
144: When others

Line 141: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_ORG->';

137: When pa_event_core.util_excp
138: then
139: p_event_org_id := NULL; -- NOCOPY
140: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
141: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_ORG->';
142: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
143:
144: When others
145: then

Line 147: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

143:
144: When others
145: then
146: p_event_org_id := NULL; -- NOCOPY
147: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
148: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_ORG->';
149: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
150:
151: END CHECK_VALID_EVENT_ORG;

Line 148: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_ORG->';

144: When others
145: then
146: p_event_org_id := NULL; -- NOCOPY
147: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
148: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_ORG->';
149: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
150:
151: END CHECK_VALID_EVENT_ORG;
152: -- ============================================================================

Line 173: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

169: --handling exceptions
170: Exception
171: When pa_event_core.util_excp
172: then
173: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
174: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_CURR->';
175: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
176:
177: When others

Line 174: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_CURR->';

170: Exception
171: When pa_event_core.util_excp
172: then
173: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
174: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_CURR->';
175: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
176:
177: When others
178: then

Line 179: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

175: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
176:
177: When others
178: then
179: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
180: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_CURR->';
181: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
182:
183: END CHECK_VALID_CURR;

Line 180: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_CURR->';

176:
177: When others
178: then
179: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
180: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_CURR->';
181: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
182:
183: END CHECK_VALID_CURR;
184: -- ============================================================================

Line 209: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

205: Exception
206: When pa_event_core.util_excp
207: then
208: x_fund_rate_type := NULL; --NOCOPY
209: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
210: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_FUND_RATE_TYPE->';
211: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
212:
213: When others

Line 210: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_FUND_RATE_TYPE->';

206: When pa_event_core.util_excp
207: then
208: x_fund_rate_type := NULL; --NOCOPY
209: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
210: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_FUND_RATE_TYPE->';
211: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
212:
213: When others
214: then

Line 216: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

212:
213: When others
214: then
215: x_fund_rate_type := NULL; --NOCOPY
216: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
217: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_FUND_RATE_TYPE->';
218: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
219:
220: END CHECK_VALID_FUND_RATE_TYPE;

Line 217: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_FUND_RATE_TYPE->';

213: When others
214: then
215: x_fund_rate_type := NULL; --NOCOPY
216: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
217: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_FUND_RATE_TYPE->';
218: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
219:
220: END CHECK_VALID_FUND_RATE_TYPE;
221:

Line 258: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

254: Exception
255: When pa_event_core.util_excp
256: then
257: x_proj_rate_type := NULL; -- NOCOPY
258: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
259: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PROJ_RATE_TYPE->';
260: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
261:
262: When others

Line 259: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PROJ_RATE_TYPE->';

255: When pa_event_core.util_excp
256: then
257: x_proj_rate_type := NULL; -- NOCOPY
258: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
259: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PROJ_RATE_TYPE->';
260: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
261:
262: When others
263: then

Line 265: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

261:
262: When others
263: then
264: x_proj_rate_type := NULL; -- NOCOPY
265: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
266: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PROJ_RATE_TYPE->';
267: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
268:
269: END CHECK_VALID_PROJ_RATE_TYPE;

Line 266: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PROJ_RATE_TYPE->';

262: When others
263: then
264: x_proj_rate_type := NULL; -- NOCOPY
265: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
266: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PROJ_RATE_TYPE->';
267: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
268:
269: END CHECK_VALID_PROJ_RATE_TYPE;
270: -- ============================================================================

Line 306: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

302: Exception
303: When pa_event_core.util_excp
304: then
305: x_pfc_rate_type := NULL; --NOCOPY
306: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
307: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PFC_RATE_TYPE->';
308: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
309:
310: When others

Line 307: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PFC_RATE_TYPE->';

303: When pa_event_core.util_excp
304: then
305: x_pfc_rate_type := NULL; --NOCOPY
306: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
307: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_PFC_RATE_TYPE->';
308: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
309:
310: When others
311: then

Line 313: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

309:
310: When others
311: then
312: x_pfc_rate_type := NULL; --NOCOPY
313: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
314: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PFC_RATE_TYPE->';
315: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
316:
317: END CHECK_VALID_PFC_RATE_TYPE;

Line 314: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PFC_RATE_TYPE->';

310: When others
311: then
312: x_pfc_rate_type := NULL; --NOCOPY
313: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
314: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_PFC_RATE_TYPE->';
315: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
316:
317: END CHECK_VALID_PFC_RATE_TYPE;
318:

Line 342: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

338: --handling exceptions
339: Exception
340: When pa_event_core.util_excp
341: then
342: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
343: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_REV_AMT->';
344: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
345:
346: When others

Line 343: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_REV_AMT->';

339: Exception
340: When pa_event_core.util_excp
341: then
342: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
343: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_REV_AMT->';
344: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
345:
346: When others
347: then

Line 348: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

344: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
345:
346: When others
347: then
348: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
349: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_REV_AMT->';
350: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
351:
352: END CHECK_VALID_REV_AMT;

Line 349: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_REV_AMT->';

345:
346: When others
347: then
348: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
349: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_REV_AMT->';
350: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
351:
352: END CHECK_VALID_REV_AMT;
353: -- ============================================================================

Line 376: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

372: --handling exceptions
373: Exception
374: When pa_event_core.util_excp
375: then
376: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
377: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_BILL_AMT->';
378: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
379:
380: When others

Line 377: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_BILL_AMT->';

373: Exception
374: When pa_event_core.util_excp
375: then
376: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
377: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_BILL_AMT->';
378: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
379:
380: When others
381: then

Line 382: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

378: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
379:
380: When others
381: then
382: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
383: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_BILL_AMT->';
384: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
385:
386: END CHECK_VALID_BILL_AMT;

Line 383: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_BILL_AMT->';

379:
380: When others
381: then
382: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
383: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_BILL_AMT->';
384: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
385:
386: END CHECK_VALID_BILL_AMT;
387: -- ============================================================================

Line 412: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

408: --handling exceptions
409: Exception
410: When pa_event_core.util_excp
411: then
412: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
413: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_NUM->';
414: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
415:
416: When others

Line 413: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_NUM->';

409: Exception
410: When pa_event_core.util_excp
411: then
412: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
413: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_NUM->';
414: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
415:
416: When others
417: then

Line 418: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

414: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
415:
416: When others
417: then
418: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
419: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_NUM->';
420: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
421:
422: END CHECK_VALID_EVENT_NUM;

Line 419: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_NUM->';

415:
416: When others
417: then
418: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
419: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_NUM->';
420: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
421:
422: END CHECK_VALID_EVENT_NUM;
423: -- ============================================================================

Line 448: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

444: Exception
445: When pa_event_core.util_excp
446: then
447: p_inv_org_id := NULL; -- NOCOPY
448: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
449: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_INV_ORG->';
450: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
451:
452: When others

Line 449: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_INV_ORG->';

445: When pa_event_core.util_excp
446: then
447: p_inv_org_id := NULL; -- NOCOPY
448: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
449: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_INV_ORG->';
450: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
451:
452: When others
453: then

Line 455: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

451:
452: When others
453: then
454: p_inv_org_id := NULL; -- NOCOPY
455: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
456: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_INV_ORG->';
457: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
458:
459: END CHECK_VALID_INV_ORG;

Line 456: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_INV_ORG->';

452: When others
453: then
454: p_inv_org_id := NULL; -- NOCOPY
455: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
456: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_INV_ORG->';
457: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
458:
459: END CHECK_VALID_INV_ORG;
460: -- ============================================================================

Line 481: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

477: --handling exceptions
478: Exception
479: When pa_event_core.util_excp
480: then
481: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
482: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_INV_ITEM->';
483: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
484:
485: When others

Line 482: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_INV_ITEM->';

478: Exception
479: When pa_event_core.util_excp
480: then
481: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
482: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_INV_ITEM->';
483: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
484:
485: When others
486: then

Line 487: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

483: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
484:
485: When others
486: then
487: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
488: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_INV_ITEM->';
489: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
490:
491: END CHECK_VALID_INV_ITEM;

Line 488: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_INV_ITEM->';

484:
485: When others
486: then
487: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
488: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_INV_ITEM->';
489: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
490:
491: END CHECK_VALID_INV_ITEM;
492: -- ============================================================================

Line 514: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

510: --handling exceptions
511: Exception
512: When pa_event_core.util_excp
513: then
514: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
515: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_EVENT_PROCESSED->';
516: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
517:
518: When others

Line 515: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_EVENT_PROCESSED->';

511: Exception
512: When pa_event_core.util_excp
513: then
514: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
515: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_EVENT_PROCESSED->';
516: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
517:
518: When others
519: then

Line 520: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

516: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
517:
518: When others
519: then
520: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
521: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_EVENT_PROCESSED->';
522: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
523:
524: END CHECK_EVENT_PROCESSED;

Line 521: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_EVENT_PROCESSED->';

517:
518: When others
519: then
520: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
521: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_EVENT_PROCESSED->';
522: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
523:
524: END CHECK_EVENT_PROCESSED;
525: -- ============================================================================

Line 548: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

544: --handling exceptions
545: Exception
546: When pa_event_core.util_excp
547: then
548: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
549: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_FUNDING->';
550: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
551:
552: When others

Line 549: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_FUNDING->';

545: Exception
546: When pa_event_core.util_excp
547: then
548: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
549: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_FUNDING->';
550: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
551:
552: When others
553: then

Line 554: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

550: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
551:
552: When others
553: then
554: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
555: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_FUNDING->';
556: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
557:
558: END CHECK_FUNDING;

Line 555: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_FUNDING->';

551:
552: When others
553: then
554: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
555: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_FUNDING->';
556: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
557:
558: END CHECK_FUNDING;
559: -- ============================================================================

Line 597: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

593: --handling exceptions
594: Exception
595: When pa_event_core.util_excp
596: then
597: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
598: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_WRITE_OFF_AMT->';
599: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
600:
601: When others

Line 598: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_WRITE_OFF_AMT->';

594: Exception
595: When pa_event_core.util_excp
596: then
597: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
598: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_WRITE_OFF_AMT->';
599: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
600:
601: When others
602: then

Line 603: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

599: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
600:
601: When others
602: then
603: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
604: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_WRITE_OFF_AMT->';
605: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
606:
607: END CHECK_WRITE_OFF_AMT;

Line 604: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_WRITE_OFF_AMT->';

600:
601: When others
602: then
603: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
604: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_WRITE_OFF_AMT->';
605: Raise pa_event_utils.pvt_excp;--Raising exception to handled in private body.
606:
607: END CHECK_WRITE_OFF_AMT;
608:

Line 640: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

636: --handling exceptions
637: Exception
638: When pa_event_core.util_excp then
639: p_agreement_id := NULL; --NOCOPY
640: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
641: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_AGREEMENT->';
642: Raise pa_event_pvt.pub_excp;
643:
644: When others then

Line 641: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_AGREEMENT->';

637: Exception
638: When pa_event_core.util_excp then
639: p_agreement_id := NULL; --NOCOPY
640: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
641: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_AGREEMENT->';
642: Raise pa_event_pvt.pub_excp;
643:
644: When others then
645: p_agreement_id := NULL; --NOCOPY

Line 646: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

642: Raise pa_event_pvt.pub_excp;
643:
644: When others then
645: p_agreement_id := NULL; --NOCOPY
646: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
647: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_AGREEMENT->';
648: Raise pa_event_pvt.pub_excp;
649:
650: END CHECK_VALID_AGREEMENT;

Line 647: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_AGREEMENT->';

643:
644: When others then
645: p_agreement_id := NULL; --NOCOPY
646: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
647: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_AGREEMENT->';
648: Raise pa_event_pvt.pub_excp;
649:
650: END CHECK_VALID_AGREEMENT;
651:

Line 675: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

671:
672: --handling exceptions
673: Exception
674: When pa_event_core.util_excp then
675: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
676: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_DATE->';
677: Raise pa_event_pvt.pub_excp;
678:
679: When others then

Line 676: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_DATE->';

672: --handling exceptions
673: Exception
674: When pa_event_core.util_excp then
675: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
676: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_DATE->';
677: Raise pa_event_pvt.pub_excp;
678:
679: When others then
680: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

Line 680: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';

676: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_VALID_EVENT_DATE->';
677: Raise pa_event_pvt.pub_excp;
678:
679: When others then
680: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
681: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_DATE->';
682: Raise pa_event_pvt.pub_excp;
683:
684: END CHECK_VALID_EVENT_DATE;

Line 681: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_DATE->';

677: Raise pa_event_pvt.pub_excp;
678:
679: When others then
680: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'UTILS->';
681: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_VALID_EVENT_DATE->';
682: Raise pa_event_pvt.pub_excp;
683:
684: END CHECK_VALID_EVENT_DATE;
685: