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 1707: WHEN app_exception.application_exception THEN

1703: END IF;
1704: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1705:
1706: EXCEPTION
1707: WHEN app_exception.application_exception THEN
1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1709: hr_utility.set_location(' Leaving:'||w_proc, 60);
1710: RAISE;
1711: END IF;

Line 1924: WHEN app_exception.application_exception THEN

1920:
1921: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1922:
1923: EXCEPTION
1924: WHEN app_exception.application_exception THEN
1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1926: hr_utility.set_location(' Leaving:'||w_proc, 60);
1927: RAISE;
1928: END IF;

Line 2000: WHEN app_exception.application_exception THEN

1996: --
1997: end if;
1998: --
1999: EXCEPTION
2000: WHEN app_exception.application_exception THEN
2001: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
2002: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
2003: hr_utility.set_location(' Leaving:'||w_proc, 40);
2004: RAISE;

Line 2035: WHEN app_exception.application_exception THEN

2031: --
2032: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2033: --
2034: EXCEPTION
2035: WHEN app_exception.application_exception THEN
2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2037: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2039: hr_utility.set_location(' Leaving:'||v_proc, 40);

Line 2097: WHEN app_exception.application_exception THEN

2093: --
2094: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2095: --
2096: EXCEPTION
2097: WHEN app_exception.application_exception THEN
2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2099: hr_utility.set_location(' Leaving:'||w_proc, 40);
2100: RAISE;
2101: END IF;

Line 2387: WHEN app_exception.application_exception THEN

2383: end if;
2384: --
2385: hr_utility.set_location ('Leaving:'||l_proc,10);
2386: EXCEPTION
2387: WHEN app_exception.application_exception THEN
2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2389: hr_utility.set_location(' Leaving:'||l_proc, 40);
2390: RAISE;
2391: END IF;

Line 3062: WHEN app_exception.application_exception THEN

3058:
3059:
3060: hr_utility.set_location(' Leaving:'||l_proc, 10);
3061: EXCEPTION
3062: WHEN app_exception.application_exception THEN
3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3064: hr_utility.set_location(' Leaving:'||l_proc, 70);
3065: RAISE;
3066: END IF;

Line 3185: WHEN app_exception.application_exception THEN

3181: hr_utility.set_location('Leaving:'||l_proc, 40);
3182: END IF;
3183: End if;
3184: EXCEPTION
3185: WHEN app_exception.application_exception THEN
3186: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3187: hr_utility.set_location(' Leaving:'||l_proc, 40);
3188: RAISE;
3189: END IF;

Line 3237: WHEN app_exception.application_exception THEN

3233: end if;
3234: end if;
3235: hr_utility.set_location('Entering:'||l_proc, 30);
3236: EXCEPTION
3237: WHEN app_exception.application_exception THEN
3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3239: hr_utility.set_location(' Leaving:'||l_proc, 40);
3240: RAISE;
3241: END IF;

Line 3385: WHEN app_exception.application_exception THEN

3381:
3382: end if;
3383: hr_utility.set_location('Leaving:'||l_proc, 30);
3384: EXCEPTION
3385: WHEN app_exception.application_exception THEN
3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3387: hr_utility.set_location(' Leaving:'||l_proc, 40);
3388: RAISE;
3389: END IF;

Line 3441: WHEN app_exception.application_exception THEN

3437: end if;
3438: end if;
3439: hr_utility.set_location('Entering:'||l_proc, 30);
3440: EXCEPTION
3441: WHEN app_exception.application_exception THEN
3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3443: hr_utility.set_location(' Leaving:'||l_proc, 40);
3444: RAISE;
3445: END IF;

Line 3499: WHEN app_exception.application_exception THEN

3495: end if;
3496: end if;
3497: hr_utility.set_location('Entering:'||l_proc, 30);
3498: EXCEPTION
3499: WHEN app_exception.application_exception THEN
3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3501: hr_utility.set_location(' Leaving:'||l_proc, 40);
3502: RAISE;
3503: END IF;

Line 3557: WHEN app_exception.application_exception THEN

3553: end if;
3554: end if;
3555: hr_utility.set_location('Leaving:'||l_proc, 30);
3556: EXCEPTION
3557: WHEN app_exception.application_exception THEN
3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3559: hr_utility.set_location(' Leaving:'||l_proc, 70);
3560: RAISE;
3561: END IF;

Line 3607: WHEN app_exception.application_exception THEN

3603: end if;
3604: close csr_offering;
3605: hr_utility.set_location('Leaving:'||l_proc, 20);
3606: EXCEPTION
3607: WHEN app_exception.application_exception THEN
3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3609: hr_utility.set_location(' Leaving:'||l_proc, 70);
3610: RAISE;
3611: END IF;

Line 3669: WHEN app_exception.application_exception THEN

3665: CLOSE csr_org;*/
3666: hr_utility.set_location('Leaving:'||l_proc, 20);
3667:
3668: EXCEPTION
3669: WHEN app_exception.application_exception THEN
3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3671: hr_utility.set_location('Leaving:'||l_proc, 40);
3672: RAISE;
3673: END IF;