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