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_PVT dependencies on PA_EVENT_PUB

Line 227: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224:
225: When pa_event_utils.pvt_excp
226: then
227: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
228: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'check_mdty_params1->';
229: Raise pub_excp;--raising exception to be handled in public package
230:
231:

Line 228: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'check_mdty_params1->';

224:
225: When pa_event_utils.pvt_excp
226: then
227: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
228: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'check_mdty_params1->';
229: Raise pub_excp;--raising exception to be handled in public package
230:
231:
232: When others

Line 234: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

230:
231:
232: When others
233: then
234: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
235: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'check_mdty_params1->';
236: Raise pub_excp;--raising exception to be handled in public package
237:
238: END check_mdty_params1;

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

231:
232: When others
233: then
234: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
235: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'check_mdty_params1->';
236: Raise pub_excp;--raising exception to be handled in public package
237:
238: END check_mdty_params1;
239:

Line 449: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

445: RAISE FND_API.G_EXC_ERROR;
446:
447: When pa_event_utils.pvt_excp
448: then
449: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
450: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_MDTY_PARAMS2->';
451: Raise pub_excp;--raising exception to be handled in public package
452:
453: When others

Line 450: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_MDTY_PARAMS2->';

446:
447: When pa_event_utils.pvt_excp
448: then
449: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
450: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_MDTY_PARAMS2->';
451: Raise pub_excp;--raising exception to be handled in public package
452:
453: When others
454: then

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

451: Raise pub_excp;--raising exception to be handled in public package
452:
453: When others
454: then
455: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
456: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_MDTY_PARAMS2->';
457: Raise pub_excp;--raising exception to be handled in public package
458:
459:

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

452:
453: When others
454: then
455: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
456: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_MDTY_PARAMS2->';
457: Raise pub_excp;--raising exception to be handled in public package
458:
459:
460: END CHECK_MDTY_PARAMS2;

Line 486: ,P_event_in_rec IN pa_event_pub.Event_rec_in_type

482: -- PA_EVENT_UTILS.CHECK_VALID_EVENT_DATE
483: -- ============================================================================
484: FUNCTION CHECK_CREATE_EVENT_OK
485: (P_pm_product_code IN VARCHAR2
486: ,P_event_in_rec IN pa_event_pub.Event_rec_in_type
487: ,P_project_currency_code IN VARCHAR2
488: ,P_proj_func_currency_code IN VARCHAR2
489: ,P_project_bil_rate_date_code IN VARCHAR2
490: ,P_project_rate_type IN VARCHAR2

Line 1561: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

1557: x_task_id := NULL; -- NOCOPY
1558: x_organization_id := NULL; --NOCOPY
1559: x_inv_org_id := NULL; --NOCOPY
1560: P_event_type_classification := NULL; --NOCOPY
1561: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
1562: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_CREATE_EVENT_OK->';
1563: Raise pub_excp;--raising exception to be handled in public package
1564:
1565: When others

Line 1562: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_CREATE_EVENT_OK->';

1558: x_organization_id := NULL; --NOCOPY
1559: x_inv_org_id := NULL; --NOCOPY
1560: P_event_type_classification := NULL; --NOCOPY
1561: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
1562: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_CREATE_EVENT_OK->';
1563: Raise pub_excp;--raising exception to be handled in public package
1564:
1565: When others
1566: then

Line 1571: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

1567: x_task_id := NULL; --NOCOPY
1568: x_organization_id := NULL; --NOCOPY
1569: x_inv_org_id := NULL; --NOCOPY
1570: P_event_type_classification := NULL; --NOCOPY
1571: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
1572: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_CREATE_EVENT_OK->';
1573: Raise pub_excp;--raising exception to be handled in public package
1574:
1575: END CHECK_CREATE_EVENT_OK;

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

1568: x_organization_id := NULL; --NOCOPY
1569: x_inv_org_id := NULL; --NOCOPY
1570: P_event_type_classification := NULL; --NOCOPY
1571: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
1572: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_CREATE_EVENT_OK->';
1573: Raise pub_excp;--raising exception to be handled in public package
1574:
1575: END CHECK_CREATE_EVENT_OK;
1576:

Line 1601: ,P_event_in_rec IN pa_event_pub.Event_rec_in_type

1597: -- PA_EVENT_UTILS.CHECK_VALID_EVENT_DATE
1598: -- ============================================================================
1599: FUNCTION CHECK_UPDATE_EVENT_OK
1600: (P_pm_product_code IN VARCHAR2
1601: ,P_event_in_rec IN pa_event_pub.Event_rec_in_type
1602: ,P_project_currency_code IN VARCHAR2
1603: ,P_proj_func_currency_code IN VARCHAR2
1604: ,P_project_bil_rate_date_code IN VARCHAR2
1605: ,P_project_rate_type IN VARCHAR2

Line 2917: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

2913: x_task_id := NULL; --NOCOPY
2914: x_organization_id := NULL; --NOCOPY
2915: x_inv_org_id := NULL; --NOCOPY
2916: P_event_type_classification:= NULL; --NOCOPY
2917: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2918: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_UPDATE_EVENT_OK->';
2919: Raise pub_excp;--raising exception to be handled in public package
2920:
2921: When others

Line 2918: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_UPDATE_EVENT_OK->';

2914: x_organization_id := NULL; --NOCOPY
2915: x_inv_org_id := NULL; --NOCOPY
2916: P_event_type_classification:= NULL; --NOCOPY
2917: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2918: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_UPDATE_EVENT_OK->';
2919: Raise pub_excp;--raising exception to be handled in public package
2920:
2921: When others
2922: then

Line 2927: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

2923: x_task_id := NULL; --NOCOPY
2924: x_organization_id := NULL; --NOCOPY
2925: x_inv_org_id := NULL; --NOCOPY
2926: P_event_type_classification:= NULL; --NOCOPY
2927: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2928: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_UPDATE_EVENT_OK->';
2929: Raise pub_excp;--raising exception to be handled in public package
2930:
2931:

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

2924: x_organization_id := NULL; --NOCOPY
2925: x_inv_org_id := NULL; --NOCOPY
2926: P_event_type_classification:= NULL; --NOCOPY
2927: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2928: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_UPDATE_EVENT_OK->';
2929: Raise pub_excp;--raising exception to be handled in public package
2930:
2931:
2932: END CHECK_UPDATE_EVENT_OK;

Line 2991: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

2987: --handling exceptions
2988: Exception
2989: When pa_event_utils.pvt_excp
2990: then
2991: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2992: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'VALIDATE_FLEXFIELD->';
2993: Raise pub_excp;--raising exception to be handled in public package
2994:
2995: When others

Line 2992: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'VALIDATE_FLEXFIELD->';

2988: Exception
2989: When pa_event_utils.pvt_excp
2990: then
2991: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2992: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'VALIDATE_FLEXFIELD->';
2993: Raise pub_excp;--raising exception to be handled in public package
2994:
2995: When others
2996: then

Line 2997: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

2993: Raise pub_excp;--raising exception to be handled in public package
2994:
2995: When others
2996: then
2997: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2998: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'VALIDATE_FLEXFIELD->';
2999: Raise pub_excp;--raising exception to be handled in public package
3000:
3001: END VALIDATE_FLEXFIELD;

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

2994:
2995: When others
2996: then
2997: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
2998: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'VALIDATE_FLEXFIELD->';
2999: Raise pub_excp;--raising exception to be handled in public package
3000:
3001: END VALIDATE_FLEXFIELD;
3002: -- ============================================================================

Line 3183: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3179: When pa_event_utils.pvt_excp
3180: then
3181: p_pm_event_reference := l_pm_event_reference ; -- NOCOPY
3182: p_event_id := l1_event_id; -- NOCOPY
3183: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3184: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CONV_EVENT_REF_TO_ID->';
3185: Raise pub_excp;--raising exception to be handled in public package
3186:
3187: When others

Line 3184: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CONV_EVENT_REF_TO_ID->';

3180: then
3181: p_pm_event_reference := l_pm_event_reference ; -- NOCOPY
3182: p_event_id := l1_event_id; -- NOCOPY
3183: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3184: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CONV_EVENT_REF_TO_ID->';
3185: Raise pub_excp;--raising exception to be handled in public package
3186:
3187: When others
3188: then

Line 3191: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3187: When others
3188: then
3189: p_pm_event_reference := l_pm_event_reference ; -- NOCOPY
3190: p_event_id := l1_event_id; -- NOCOPY
3191: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3192: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CONV_EVENT_REF_TO_ID->';
3193: Raise pub_excp;--raising exception to be handled in public package
3194:
3195:

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

3188: then
3189: p_pm_event_reference := l_pm_event_reference ; -- NOCOPY
3190: p_event_id := l1_event_id; -- NOCOPY
3191: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3192: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CONV_EVENT_REF_TO_ID->';
3193: Raise pub_excp;--raising exception to be handled in public package
3194:
3195:
3196: END CONV_EVENT_REF_TO_ID;

Line 3408: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3404: --handling exceptions
3405: Exception
3406: When pa_event_utils.pvt_excp
3407: then
3408: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3409: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_DELETE_EVENT_OK->';
3410: Raise pub_excp;--raising exception to be handled in public package
3411:
3412: When others

Line 3409: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_DELETE_EVENT_OK->';

3405: Exception
3406: When pa_event_utils.pvt_excp
3407: then
3408: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3409: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_DELETE_EVENT_OK->';
3410: Raise pub_excp;--raising exception to be handled in public package
3411:
3412: When others
3413: then

Line 3414: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3410: Raise pub_excp;--raising exception to be handled in public package
3411:
3412: When others
3413: then
3414: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3415: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK->';
3416: Raise pub_excp;--raising exception to be handled in public package
3417:
3418: END CHECK_DELETE_EVENT_OK;

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

3411:
3412: When others
3413: then
3414: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3415: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK->';
3416: Raise pub_excp;--raising exception to be handled in public package
3417:
3418: END CHECK_DELETE_EVENT_OK;
3419:

Line 3478: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3474: --handling exceptions
3475: Exception
3476: When pa_event_utils.pvt_excp
3477: then
3478: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3479: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_EVENT_REF_UNQ->';
3480: Raise pub_excp;--raising exception to be handled in public package
3481:
3482: When others

Line 3479: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_EVENT_REF_UNQ->';

3475: Exception
3476: When pa_event_utils.pvt_excp
3477: then
3478: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3479: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_EVENT_REF_UNQ->';
3480: Raise pub_excp;--raising exception to be handled in public package
3481:
3482: When others
3483: then

Line 3484: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3480: Raise pub_excp;--raising exception to be handled in public package
3481:
3482: When others
3483: then
3484: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3485: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_EVENT_REF_UNQ->';
3486: Raise pub_excp;--raising exception to be handled in public package
3487:
3488: END CHECK_EVENT_REF_UNQ;

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

3481:
3482: When others
3483: then
3484: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3485: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_EVENT_REF_UNQ->';
3486: Raise pub_excp;--raising exception to be handled in public package
3487:
3488: END CHECK_EVENT_REF_UNQ;
3489: -- ============================================================================

Line 3520: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3516: --handling exceptions
3517: Exception
3518: When pa_event_utils.pvt_excp
3519: then
3520: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3521: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_YES_NO->';
3522: Raise pub_excp;--raising exception to be handled in public package
3523:
3524: When others

Line 3521: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_YES_NO->';

3517: Exception
3518: When pa_event_utils.pvt_excp
3519: then
3520: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3521: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CHECK_YES_NO->';
3522: Raise pub_excp;--raising exception to be handled in public package
3523:
3524: When others
3525: then

Line 3526: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3522: Raise pub_excp;--raising exception to be handled in public package
3523:
3524: When others
3525: then
3526: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3527: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_YES_NO->';
3528: Raise pub_excp;--raising exception to be handled in public package
3529:
3530: END CHECK_YES_NO;

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

3523:
3524: When others
3525: then
3526: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3527: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_YES_NO->';
3528: Raise pub_excp;--raising exception to be handled in public package
3529:
3530: END CHECK_YES_NO;
3531:

Line 3574: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3570: --handling exceptions
3571: Exception
3572: When pa_event_utils.pvt_excp
3573: then
3574: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3575: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'FETCH_EVENT_ID->';
3576: Raise pub_excp;--raising exception to be handled in public package
3577:
3578: When others

Line 3575: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'FETCH_EVENT_ID->';

3571: Exception
3572: When pa_event_utils.pvt_excp
3573: then
3574: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3575: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'FETCH_EVENT_ID->';
3576: Raise pub_excp;--raising exception to be handled in public package
3577:
3578: When others
3579: then

Line 3580: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';

3576: Raise pub_excp;--raising exception to be handled in public package
3577:
3578: When others
3579: then
3580: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3581: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT_ID->';
3582: Raise pub_excp;--raising exception to be handled in public package
3583:
3584: END FETCH_EVENT_ID;

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

3577:
3578: When others
3579: then
3580: PA_EVENT_PUB.PACKAGE_NAME:=PA_EVENT_PUB.PACKAGE_NAME||'PRIVATE->';
3581: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT_ID->';
3582: Raise pub_excp;--raising exception to be handled in public package
3583:
3584: END FETCH_EVENT_ID;
3585: