DBA Data[Home] [Help]

APPS.OTA_EVT_BUS dependencies on APP_EXCEPTION

Line 476: WHEN app_exception.application_exception THEN

472: --
473: hr_utility.set_location('Leaving '||l_proc,10);
474: --
475: EXCEPTION
476: WHEN app_exception.application_exception THEN
477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
478: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
479: hr_utility.set_location(' Leaving:'||l_proc, 40);
480: RAISE;

Line 518: WHEN app_exception.application_exception THEN

514: --
515: hr_utility.set_location('Leaving '||l_proc,10);
516: --
517: EXCEPTION
518: WHEN app_exception.application_exception THEN
519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
520: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
521: hr_utility.set_location(' Leaving:'||l_proc, 40);
522: RAISE;

Line 715: WHEN app_exception.application_exception THEN

711: end if;
712: end if;
713: hr_utility.set_location(' Leaving:'||l_proc,10);
714: EXCEPTION
715: WHEN app_exception.application_exception THEN
716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN
717: hr_utility.set_location(' Leaving:'||l_proc, 40);
718: RAISE;
719: END IF;

Line 832: WHEN app_exception.application_exception THEN

828: end if;
829: --
830: hr_utility.set_location(' Leaving:'||l_proc,10);
831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN
834: hr_utility.set_location(' Leaving:'||l_proc, 40);
835: RAISE;
836: END IF;

Line 886: WHEN app_exception.application_exception THEN

882:
883: hr_utility.set_location(' Exitting:'||l_proc,10);
884: --
885: EXCEPTION
886: WHEN app_exception.application_exception THEN
887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',
888: p_associated_column2 => 'OTA_EVENTS.ENROLMENT_END_DATE') THEN
889: hr_utility.set_location(' Leaving:'||l_proc, 40);
890: RAISE;

Line 1014: WHEN app_exception.application_exception THEN

1010: end if;
1011: hr_utility.set_location('Leaving:'||l_proc,20);
1012:
1013: EXCEPTION
1014: WHEN app_exception.application_exception THEN
1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1016: hr_utility.set_location(' Leaving:'||l_proc, 40);
1017: RAISE;
1018: END IF;

Line 1046: WHEN app_exception.application_exception THEN

1042: end if;
1043: hr_utility.set_location('Leaving:'||l_proc,20);
1044:
1045: EXCEPTION
1046: WHEN app_exception.application_exception THEN
1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN
1048: hr_utility.set_location(' Leaving:'||l_proc, 40);
1049: RAISE;
1050: END IF;

Line 1567: WHEN app_exception.application_exception THEN

1563: --
1564: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
1565: --
1566: EXCEPTION
1567: WHEN app_exception.application_exception THEN
1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN
1569: hr_utility.set_location(' Leaving:'||W_PROC, 40);
1570: RAISE;
1571: END IF;

Line 1688: WHEN app_exception.application_exception THEN

1684: END IF;
1685: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1686:
1687: EXCEPTION
1688: WHEN app_exception.application_exception THEN
1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1690: hr_utility.set_location(' Leaving:'||w_proc, 60);
1691: RAISE;
1692: END IF;

Line 1905: WHEN app_exception.application_exception THEN

1901:
1902: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1903:
1904: EXCEPTION
1905: WHEN app_exception.application_exception THEN
1906: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1907: hr_utility.set_location(' Leaving:'||w_proc, 60);
1908: RAISE;
1909: END IF;

Line 1981: WHEN app_exception.application_exception THEN

1977: --
1978: end if;
1979: --
1980: EXCEPTION
1981: WHEN app_exception.application_exception THEN
1982: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
1983: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
1984: hr_utility.set_location(' Leaving:'||w_proc, 40);
1985: RAISE;

Line 2016: WHEN app_exception.application_exception THEN

2012: --
2013: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2014: --
2015: EXCEPTION
2016: WHEN app_exception.application_exception THEN
2017: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2018: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2019: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2020: hr_utility.set_location(' Leaving:'||v_proc, 40);

Line 2078: WHEN app_exception.application_exception THEN

2074: --
2075: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2076: --
2077: EXCEPTION
2078: WHEN app_exception.application_exception THEN
2079: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2080: hr_utility.set_location(' Leaving:'||w_proc, 40);
2081: RAISE;
2082: END IF;

Line 2368: WHEN app_exception.application_exception THEN

2364: end if;
2365: --
2366: hr_utility.set_location ('Leaving:'||l_proc,10);
2367: EXCEPTION
2368: WHEN app_exception.application_exception THEN
2369: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2370: hr_utility.set_location(' Leaving:'||l_proc, 40);
2371: RAISE;
2372: END IF;

Line 3042: WHEN app_exception.application_exception THEN

3038:
3039:
3040: hr_utility.set_location(' Leaving:'||l_proc, 10);
3041: EXCEPTION
3042: WHEN app_exception.application_exception THEN
3043: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3044: hr_utility.set_location(' Leaving:'||l_proc, 70);
3045: RAISE;
3046: END IF;

Line 3165: WHEN app_exception.application_exception THEN

3161: hr_utility.set_location('Leaving:'||l_proc, 40);
3162: END IF;
3163: End if;
3164: EXCEPTION
3165: WHEN app_exception.application_exception THEN
3166: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3167: hr_utility.set_location(' Leaving:'||l_proc, 40);
3168: RAISE;
3169: END IF;

Line 3217: WHEN app_exception.application_exception THEN

3213: end if;
3214: end if;
3215: hr_utility.set_location('Entering:'||l_proc, 30);
3216: EXCEPTION
3217: WHEN app_exception.application_exception THEN
3218: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3219: hr_utility.set_location(' Leaving:'||l_proc, 40);
3220: RAISE;
3221: END IF;

Line 3365: WHEN app_exception.application_exception THEN

3361:
3362: end if;
3363: hr_utility.set_location('Leaving:'||l_proc, 30);
3364: EXCEPTION
3365: WHEN app_exception.application_exception THEN
3366: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3367: hr_utility.set_location(' Leaving:'||l_proc, 40);
3368: RAISE;
3369: END IF;

Line 3421: WHEN app_exception.application_exception THEN

3417: end if;
3418: end if;
3419: hr_utility.set_location('Entering:'||l_proc, 30);
3420: EXCEPTION
3421: WHEN app_exception.application_exception THEN
3422: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3423: hr_utility.set_location(' Leaving:'||l_proc, 40);
3424: RAISE;
3425: END IF;

Line 3479: WHEN app_exception.application_exception THEN

3475: end if;
3476: end if;
3477: hr_utility.set_location('Entering:'||l_proc, 30);
3478: EXCEPTION
3479: WHEN app_exception.application_exception THEN
3480: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3481: hr_utility.set_location(' Leaving:'||l_proc, 40);
3482: RAISE;
3483: END IF;

Line 3537: WHEN app_exception.application_exception THEN

3533: end if;
3534: end if;
3535: hr_utility.set_location('Leaving:'||l_proc, 30);
3536: EXCEPTION
3537: WHEN app_exception.application_exception THEN
3538: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3539: hr_utility.set_location(' Leaving:'||l_proc, 70);
3540: RAISE;
3541: END IF;

Line 3587: WHEN app_exception.application_exception THEN

3583: end if;
3584: close csr_offering;
3585: hr_utility.set_location('Leaving:'||l_proc, 20);
3586: EXCEPTION
3587: WHEN app_exception.application_exception THEN
3588: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3589: hr_utility.set_location(' Leaving:'||l_proc, 70);
3590: RAISE;
3591: END IF;

Line 3649: WHEN app_exception.application_exception THEN

3645: CLOSE csr_org;*/
3646: hr_utility.set_location('Leaving:'||l_proc, 20);
3647:
3648: EXCEPTION
3649: WHEN app_exception.application_exception THEN
3650: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3651: hr_utility.set_location('Leaving:'||l_proc, 40);
3652: RAISE;
3653: END IF;