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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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:
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
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
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;
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: -- ============================================================================
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
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
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;
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:
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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: -- ============================================================================
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
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
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;
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:
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
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
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;
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:
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
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->';
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;
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: