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_CTU_BUS dependencies on APP_EXCEPTION

Line 357: when app_exception.application_exception then

353: End IF;
354: --
355: hr_utility.set_location(' Leaving:' || l_proc,10);
356: Exception
357: when app_exception.application_exception then
358: IF hr_multi_message.exception_add
359: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
360: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
361: ) THEN

Line 439: when app_exception.application_exception then

435: Close cur_child_cat_dates;
436: --
437: hr_utility.set_location(' Leaving:' || l_proc,10);
438: Exception
439: when app_exception.application_exception then
440: IF hr_multi_message.exception_add
441: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
442: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
443: ) THEN

Line 532: when app_exception.application_exception then

528:
529:
530: hr_utility.set_location(' Leaving:' || l_proc,10);
531: Exception
532: when app_exception.application_exception then
533: IF hr_multi_message.exception_add
534: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
535: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
536: ) THEN

Line 625: when app_exception.application_exception then

621:
622:
623: hr_utility.set_location(' Leaving:' || l_proc,10);
624: Exception
625: when app_exception.application_exception then
626: IF hr_multi_message.exception_add
627: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
628: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
629: ) THEN

Line 681: when app_exception.application_exception then

677:
678: --
679: hr_utility.set_location(' Leaving:' || l_proc,10);
680: Exception
681: when app_exception.application_exception then
682: IF hr_multi_message.exception_add
683: (p_associated_column1 => 'OTA_CATEGORY_USAGES.BUSINESS_GROUP_ID'
684: ) THEN
685: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 769: when app_exception.application_exception then

765:
766:
767: hr_utility.set_location(' Leaving:' || l_proc,10);
768: Exception
769: when app_exception.application_exception then
770: IF hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
772: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
773: ) THEN

Line 824: when app_exception.application_exception then

820: --
821: hr_utility.set_location(' Leaving:' || l_proc,10);
822: --
823: Exception
824: when app_exception.application_exception then
825: IF hr_multi_message.exception_add
826: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
827: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
828: ) THEN

Line 1275: when app_exception.application_exception then

1271: END IF;
1272: --
1273: hr_utility.set_location(' Leaving:'||l_proc, 10);
1274: Exception
1275: when app_exception.application_exception then
1276: IF hr_multi_message.exception_add
1277: (p_associated_column1 => 'OTA_CATEGORY_USAGES_TL.CATEGORY'
1278: ) THEN
1279: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 1329: when app_exception.application_exception then

1325: hr_utility.set_location(' Leaving:' || l_proc,10);
1326: --
1327:
1328: Exception
1329: when app_exception.application_exception then
1330: IF hr_multi_message.exception_add
1331: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1332: ,p_same_associated_columns => 'Y'
1333: ) THEN

Line 1384: when app_exception.application_exception then

1380:
1381: --
1382: hr_utility.set_location(' Leaving:' || l_proc,10);
1383: Exception
1384: when app_exception.application_exception then
1385: IF hr_multi_message.exception_add
1386: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1387: ,p_same_associated_columns => 'Y'
1388: ) THEN

Line 1466: when app_exception.application_exception then

1462: --
1463: hr_utility.set_location(' Leaving:' || l_proc,10);
1464: --
1465: Exception
1466: when app_exception.application_exception then
1467: if hr_multi_message.exception_add
1468: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
1469: ) then
1470: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 1505: when app_exception.application_exception then

1501: --
1502: hr_utility.set_location(' Leaving:' || l_proc,10);
1503: --
1504: Exception
1505: when app_exception.application_exception then
1506: if hr_multi_message.exception_add
1507: (p_associated_column1 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
1508: ) then
1509: hr_utility.set_location(' Leaving:'|| l_proc,70);

Line 1547: when app_exception.application_exception then

1543: --
1544: hr_utility.set_location (' leaving:' || l_proc, 10);
1545: --
1546: Exception
1547: when app_exception.application_exception then
1548: IF hr_multi_message.exception_add
1549: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
1550: ) THEN
1551: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 1600: when app_exception.application_exception then

1596:
1597: --
1598: hr_utility.set_location(' Leaving:' || l_proc,10);
1599: Exception
1600: when app_exception.application_exception then
1601: IF hr_multi_message.exception_add
1602: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1603: ,p_same_associated_columns => 'Y'
1604: ) THEN

Line 1658: when app_exception.application_exception then

1654: END IF;
1655: --
1656: hr_utility.set_location(' Leaving:' || l_proc,10);
1657: Exception
1658: when app_exception.application_exception then
1659: IF hr_multi_message.exception_add
1660: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1661: ,p_same_associated_columns => 'Y'
1662: ) THEN