APPS.OTA_OFF_BUS dependencies on APP_EXCEPTION

Line 436: when app_exception.application_exception then

432: CLOSE cur_dm_start_end_date;
433:
434: hr_utility.set_location(' Leaving:' || l_proc,10);
435: Exception
436: when app_exception.application_exception then
437: IF hr_multi_message.exception_add
438: (p_associated_column1 => 'OTA_OFFERINGS.START_DATE'
439: ,p_associated_column2 => 'OTA_OFFERINGS.END_DATE'
440: ) THEN

Line 524: WHEN app_exception.application_exception THEN

520: end loop;
521: --
522: hr_utility.set_location(' Exiting:'||l_proc,10);
523: Exception
524: WHEN app_exception.application_exception THEN
525:
526: IF hr_multi_message.exception_add(
527: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
528: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')

Line 604: WHEN app_exception.application_exception THEN

600: end if;
601: --
602: hr_utility.set_location(' Exiting:'||l_proc,10);
603: Exception
604: WHEN app_exception.application_exception THEN
605:
606: IF hr_multi_message.exception_add(
607: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
608: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')

Line 668: WHEN app_exception.application_exception THEN

664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665:
666: EXCEPTION
667:
668: WHEN app_exception.application_exception THEN
669:
670: IF hr_multi_message.exception_add
671: (p_associated_column1 => 'OTA_OFFERINGS.COMPETENCY_UPDATE_LEVEL') THEN
672:

Line 720: WHEN app_exception.application_exception THEN

716: --
717: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
718: --
719: Exception
720: WHEN app_exception.application_exception THEN
721:
722: IF hr_multi_message.exception_add(
723: p_associated_column1 => 'OTA_OFFERINGS.BUSINESS_GROUP_ID',
724: p_associated_column2 => 'OTA_OFFERINGS.DELIVERY_MODE_ID')

Line 841: WHEN app_exception.application_exception THEN

837: hr_utility.set_location('Leaving:'||l_proc, 40);
838:
839:
840: Exception
841: WHEN app_exception.application_exception THEN
842:
843: IF hr_multi_message.exception_add(
844: p_associated_column1 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_FLAG',
845: p_associated_column2 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_BITSET')

Line 920: WHEN app_exception.application_exception THEN

916: hr_utility.set_location('Leaving:'||l_proc, 40);
917: END IF;
918: End if;
919: Exception
920: WHEN app_exception.application_exception THEN
921:
922: IF hr_multi_message.exception_add(
923: p_associated_column1 => 'OTA_OFFERINGS.OWNER_ID')
924: THEN

Line 982: when app_exception.application_exception then

978: CLOSE cur_dm_online_flag;
979:
980: hr_utility.set_location(' Leaving:' || l_proc,10);
981: Exception
982: when app_exception.application_exception then
983: IF hr_multi_message.exception_add
984: (p_associated_column1 => 'OTA_OFFERINGS.LEARNING_OBJECT_ID'
985: ) THEN
986: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 1032: WHEN app_exception.application_exception THEN

1028: fnd_message.set_name('OTA','OTA_13449_EVT_ATTENDEES_POS');
1029: fnd_message.raise_error;
1030: end if;
1031: Exception
1032: WHEN app_exception.application_exception THEN
1033:
1034: IF hr_multi_message.exception_add(
1035: p_associated_column1 => 'OTA_OFFERINGS.MAXIMUM_ATTENDEES'
1036: ,p_associated_column2 => 'OTA_OFFERINGS.MAXIMUM_INTERNAL_ATTENDEES'

Line 1062: WHEN app_exception.application_exception THEN

1058: fnd_message.set_name('OTA','OTA_13881_NHS_COMB_INVALID');
1059: fnd_message.raise_error;
1060: end if;
1061: Exception
1062: WHEN app_exception.application_exception THEN
1063:
1064: IF hr_multi_message.exception_add(
1065: p_associated_column1 => 'OTA_OFFERINGS.DURATION'
1066: ,p_associated_column2 => 'OTA_OFFERINGS.DURATION_UNITS')

Line 1103: WHEN app_exception.application_exception THEN

1099: end if;
1100:
1101:
1102: Exception
1103: WHEN app_exception.application_exception THEN
1104:
1105: IF hr_multi_message.exception_add(
1106: p_associated_column1 => 'OTA_OFFERINGS.ACTUAL_COST'
1107: ,p_associated_column2 => 'OTA_OFFERINGS.BUDGET_COST'

Line 1134: when app_exception.application_exception then

1130: --
1131: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1132: --
1133: exception
1134: when app_exception.application_exception then
1135: if hr_multi_message.exception_add
1136: (p_associated_column1 => 'OTA_OFFERINGS.VENDOR_ID'
1137: ) then
1138: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1194: When app_exception.application_exception Then

1190: End If;
1191: --
1192: hr_utility.set_location(' Leaving:' || l_proc,10);
1193: Exception
1194: When app_exception.application_exception Then
1195: --
1196: If hr_multi_message.exception_add
1197: (p_associated_column1 => 'OTA_OFFERINGS.DELIVERY_MODE_ID'
1198: ) Then