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.OTA_TAV_BUS dependencies on APP_EXCEPTION

Line 175: when app_exception.application_exception then

171: --
172: hr_utility.set_location(' Leaving:'||v_proc, 10);
173: --
174: exception
175: when app_exception.application_exception then
176: if hr_multi_message.exception_add
177: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.MINIMUM_ATTENDEES'
178: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.MAXIMUM_ATTENDEES'
179: ) then

Line 269: WHEN app_exception.application_exception THEN

265: hr_utility.set_location(' Leaving:'||l_proc, 40);
266:
267: EXCEPTION
268:
269: WHEN app_exception.application_exception THEN
270:
271: IF hr_multi_message.exception_add
272: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN
273:

Line 311: when app_exception.application_exception then

307: --
308: hr_utility.set_location(' Leaving:'|| v_proc, 10);
309: --
310: exception
311: when app_exception.application_exception then
312: if hr_multi_message.exception_add
313: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUPERSEDE_BY_ACT_VERSION_ID'
314: ) then
315: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 345: when app_exception.application_exception then

341: --
342: hr_utility.set_location(' Leaving:'|| v_proc, 10);
343: --
344: exception
345: when app_exception.application_exception then
346: if hr_multi_message.exception_add
347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.USER_STATUS'
348: ) then
349: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 379: when app_exception.application_exception then

375: --
376: hr_utility.set_location(' Leaving:'|| v_proc, 10);
377: --
378: exception
379: when app_exception.application_exception then
380: if hr_multi_message.exception_add
381: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUCCESS_CRITERIA'
382: ) then
383: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 466: when app_exception.application_exception then

462: --
463: hr_utility.set_location(' Leaving:'|| v_proc, 10);
464: --
465: exception
466: when app_exception.application_exception then
467: if hr_multi_message.exception_add
468: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
469: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
470: ) then

Line 520: when app_exception.application_exception then

516: hr_utility.set_location(' Leaving:'|| v_proc, 10);
517: --
518: end if;
519: exception
520: when app_exception.application_exception then
521: if hr_multi_message.exception_add
522: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
523: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
524: ) then

Line 565: when app_exception.application_exception then

561: hr_utility.set_location(' Leaving:'|| v_proc, 10);
562: --
563: end if;
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
568: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
569: ) then

Line 613: when app_exception.application_exception then

609: hr_utility.set_location(' Leaving:'|| v_proc, 10);
610: --
611: end if;
612: exception
613: when app_exception.application_exception then
614: if hr_multi_message.exception_add
615: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
616: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
617: ) then

Line 659: when app_exception.application_exception then

655: hr_utility.set_location(' Leaving:'|| v_proc, 10);
656: --
657: end if;
658: exception
659: when app_exception.application_exception then
660: if hr_multi_message.exception_add
661: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
662: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
663: ) then

Line 697: when app_exception.application_exception then

693: --
694: hr_utility.set_location(' Leaving:'|| v_proc, 10);
695: --
696: exception
697: when app_exception.application_exception then
698: if hr_multi_message.exception_add
699: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
700: ) then
701: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 732: when app_exception.application_exception then

728: --
729: hr_utility.set_location(' Leaving:'|| v_proc, 10);
730: --
731: exception
732: when app_exception.application_exception then
733: if hr_multi_message.exception_add
734: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
735: ) then
736: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 769: when app_exception.application_exception then

765: hr_utility.set_location(' Leaving:'|| v_proc, 10);
766: --
767: --
768: exception
769: when app_exception.application_exception then
770: if hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
772: ) then
773: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 807: when app_exception.application_exception then

803: hr_utility.set_location(' Leaving:'|| v_proc, 10);
804: --
805: --
806: exception
807: when app_exception.application_exception then
808: if hr_multi_message.exception_add
809: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
810: ) then
811: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 845: when app_exception.application_exception then

841: --
842: hr_utility.set_location(' Leaving:'|| v_proc, 10);
843: --
844: exception
845: when app_exception.application_exception then
846: if hr_multi_message.exception_add
847: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
848: ) then
849: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 882: when app_exception.application_exception then

878: --
879: hr_utility.set_location(' Leaving:'|| v_proc, 10);
880: --
881: exception
882: when app_exception.application_exception then
883: if hr_multi_message.exception_add
884: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
885: ) then
886: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 919: when app_exception.application_exception then

915: --
916: hr_utility.set_location(' Leaving:'|| v_proc, 10);
917: --
918: exception
919: when app_exception.application_exception then
920: if hr_multi_message.exception_add
921: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
922: ) then
923: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 956: when app_exception.application_exception then

952: --
953: hr_utility.set_location(' Leaving:'|| v_proc, 10);
954: --
955: exception
956: when app_exception.application_exception then
957: if hr_multi_message.exception_add
958: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
959: ) then
960: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 991: when app_exception.application_exception then

987: --
988: hr_utility.set_location(' Leaving:'|| v_proc, 10);
989: --
990: exception
991: when app_exception.application_exception then
992: if hr_multi_message.exception_add
993: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
994: ) then
995: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1027: when app_exception.application_exception then

1023: --
1024: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1025: --
1026: exception
1027: when app_exception.application_exception then
1028: if hr_multi_message.exception_add
1029: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS'
1030: ) then
1031: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1061: when app_exception.application_exception then

1057: --
1058: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1059: --
1060: exception
1061: when app_exception.application_exception then
1062: if hr_multi_message.exception_add
1063: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'
1064: ) then
1065: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1090: WHEN app_exception.application_exception THEN

1086: fnd_message.set_name('OTA','OTA_13881_NHS_COMB_INVALID');
1087: fnd_message.raise_error;
1088: end if;
1089: Exception
1090: WHEN app_exception.application_exception THEN
1091:
1092: IF hr_multi_message.exception_add(
1093: p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'
1094: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS')

Line 1127: when app_exception.application_exception then

1123: --
1124: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1125: --
1126: exception
1127: when app_exception.application_exception then
1128: if hr_multi_message.exception_add
1129: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.LANGUAGE_ID'
1130: ) then
1131: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1164: when app_exception.application_exception then

1160: --
1161: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1162: --
1163: exception
1164: when app_exception.application_exception then
1165: if hr_multi_message.exception_add
1166: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CONTROLLING_PERSON_ID'
1167: ) then
1168: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1207: when app_exception.application_exception then

1203: --
1204: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1205: --
1206: exception
1207: when app_exception.application_exception then
1208: if hr_multi_message.exception_add
1209: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1210: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1211: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

Line 1247: when app_exception.application_exception then

1243: --
1244: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1245: --
1246: exception
1247: when app_exception.application_exception then
1248: if hr_multi_message.exception_add
1249: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_ID'
1250: ) then
1251: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1293: when app_exception.application_exception then

1289: hr_utility.set_location('Entering:'||l_proc, 5);
1290: ota_tav_api_business_rules.check_course_lp_dates( p_activity_version_id, p_start_date, p_end_date );
1291:
1292: exception
1293: when app_exception.application_exception then
1294: if l_start_date_changed AND hr_multi_message.exception_add
1295: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1296: ) then
1297: hr_utility.set_location(' Leaving:'|| l_proc,70);

Line 1345: when app_exception.application_exception then

1341: hr_utility.set_location('Entering:'||l_proc, 5);
1342: ota_tav_api_business_rules.check_course_crt_dates( p_activity_version_id, p_start_date, p_end_date );
1343:
1344: exception
1345: when app_exception.application_exception then
1346: if l_start_date_changed AND hr_multi_message.exception_add
1347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1348: ) then
1349: hr_utility.set_location(' Leaving:'|| l_proc,70);

Line 1408: WHEN app_exception.application_exception THEN

1404: hr_utility.set_location(' Leaving:'||l_proc, 20);
1405:
1406: EXCEPTION
1407:
1408: WHEN app_exception.application_exception THEN
1409:
1410: IF hr_multi_message.exception_add
1411: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN
1412:

Line 1958: when app_exception.application_exception then

1954: --
1955: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1956: --
1957: exception
1958: when app_exception.application_exception then
1959: if hr_multi_message.exception_add
1960: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1961: ) then
1962: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1995: when app_exception.application_exception then

1991: --
1992: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1993: --
1994: exception
1995: when app_exception.application_exception then
1996: if hr_multi_message.exception_add
1997: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1998: ) then
1999: hr_utility.set_location(' Leaving:'|| v_proc,70);