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 HR_MULTI_MESSAGE

Line 176: if hr_multi_message.exception_add

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
180: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 271: IF hr_multi_message.exception_add

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:
274: hr_utility.set_location(' Leaving:'||l_proc, 42);
275: RAISE;

Line 312: if hr_multi_message.exception_add

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);
316: raise;

Line 346: if hr_multi_message.exception_add

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);
350: raise;

Line 380: if hr_multi_message.exception_add

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);
384: raise;

Line 467: if hr_multi_message.exception_add

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
471: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 505: if hr_multi_message.no_error_message

501: from ota_price_list_entries ple
502: where ple.activity_version_id = p_activity_version_id;
503: --
504: Begin
505: if hr_multi_message.no_error_message
506: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
507: ) then
508:
509: --

Line 521: if hr_multi_message.exception_add

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
525: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 551: if hr_multi_message.no_error_message

547: --
548: v_proc varchar2(72) := g_package||'check_dates_update_tbd';
549: --
550: Begin
551: if hr_multi_message.no_error_message
552: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
553: ) then
554: --
555: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 566: if hr_multi_message.exception_add

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
570: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 599: if hr_multi_message.no_error_message

595: --
596: v_proc varchar2(72) := g_package||'check_dates_update_evt';
597: --
598: Begin
599: if hr_multi_message.no_error_message
600: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
601: ) then
602: --
603: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 614: if hr_multi_message.exception_add

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
618: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 644: if hr_multi_message.no_error_message

640: --
641: v_proc varchar2(72) := g_package||'check_dates_update_tpm';
642: --
643: Begin
644: if hr_multi_message.no_error_message
645: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
646: ) then
647: --
648: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 660: if hr_multi_message.exception_add

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
664: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 698: if hr_multi_message.exception_add

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);
702: raise;

Line 733: if hr_multi_message.exception_add

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);
737: raise;

Line 770: if hr_multi_message.exception_add

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);
774: raise;

Line 808: if hr_multi_message.exception_add

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);
812: raise;

Line 846: if hr_multi_message.exception_add

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);
850: raise;

Line 883: if hr_multi_message.exception_add

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);
887: raise;

Line 920: if hr_multi_message.exception_add

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);
924: raise;

Line 957: if hr_multi_message.exception_add

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);
961: raise;

Line 992: if hr_multi_message.exception_add

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);
996: raise;

Line 1028: if hr_multi_message.exception_add

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);
1032: raise;

Line 1062: if hr_multi_message.exception_add

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);
1066: raise;

Line 1092: IF hr_multi_message.exception_add(

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')
1095: THEN
1096:

Line 1128: if hr_multi_message.exception_add

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);
1132: raise;

Line 1165: if hr_multi_message.exception_add

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);
1169: raise;

Line 1208: if hr_multi_message.exception_add

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'
1212: ) then

Line 1248: if hr_multi_message.exception_add

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);
1252: raise;

Line 1294: if l_start_date_changed AND hr_multi_message.exception_add

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);
1298: raise;

Line 1299: elsif l_end_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);
1298: raise;
1299: elsif l_end_date_changed AND hr_multi_message.exception_add
1300: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1301: ) then
1302: hr_utility.set_location(' Leaving:'|| l_proc,80);
1303: raise;

Line 1346: if l_start_date_changed AND hr_multi_message.exception_add

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);
1350: raise;

Line 1351: elsif l_end_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);
1350: raise;
1351: elsif l_end_date_changed AND hr_multi_message.exception_add
1352: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1353: ) then
1354: hr_utility.set_location(' Leaving:'|| l_proc,80);
1355: raise;

Line 1410: IF hr_multi_message.exception_add

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:
1413: hr_utility.set_location(' Leaving:'||l_proc, 30);
1414: RAISE;

Line 1446: hr_multi_message.end_validation_set;

1442: -- After validating the set of important attributes,
1443: -- if multiple message detection is enabled and atleast
1444: -- one error has been found then abort further validation.
1445: --
1446: hr_multi_message.end_validation_set;
1447: --
1448: -- Validate Dependent Attributes
1449: --
1450: --

Line 1647: hr_multi_message.end_validation_set;

1643: --
1644: -- After validating the set of important attributes,
1645: -- if multiple message detection is enabled and atleast
1646: -- one error has been found then abort further validation.
1647: hr_multi_message.end_validation_set;
1648: --
1649: --
1650: -- Validate Dependent Attributes
1651: --

Line 1959: if hr_multi_message.exception_add

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);
1963: raise;

Line 1996: if hr_multi_message.exception_add

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);
2000: raise;