DBA Data[Home] [Help]

APPS.IRC_ISC_BUS dependencies on APP_EXCEPTION

Line 566: when app_exception.application_exception then

562: end if;
563: close csr_person_id;
564: hr_utility.set_location(' Leaving:'||l_proc,40);
565: exception
566: when app_exception.application_exception then
567: if hr_multi_message.exception_add
568: (p_associated_column1 =>
569: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
570: ) then

Line 626: when app_exception.application_exception then

622: close csr_work_choices;
623: end if;
624: hr_utility.set_location(' Leaving:'||l_proc,40);
625: exception
626: when app_exception.application_exception then
627: if hr_multi_message.exception_add
628: (p_associated_column1 =>
629: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
630: ) then

Line 708: when app_exception.application_exception then

704: end if;
705: end if;
706: hr_utility.set_location(' Leaving:'||l_proc,60);
707: exception
708: when app_exception.application_exception then
709: if hr_multi_message.exception_add
710: (p_associated_column1 =>
711: 'IRC_SEARCH_CRITERIA.SEARCH_NAME'
712: ) then

Line 988: when app_exception.application_exception then

984: end if;
985: end if;
986: hr_utility.set_location(' Leaving:'||l_proc,50);
987: exception
988: when app_exception.application_exception then
989: if hr_multi_message.exception_add
990: (p_associated_column1 =>
991: 'IRC_SEARCH_CRITERIA.USE_FOR_MATCHING'
992: ) then

Line 1058: when app_exception.application_exception then

1054: end if;
1055: end if;
1056: hr_utility.set_location(' Leaving:'||l_proc,50);
1057: exception
1058: when app_exception.application_exception then
1059: if hr_multi_message.exception_add
1060: (p_associated_column1 =>
1061: 'IRC_SEARCH_CRITERIA.MATCH_COMPETENCE'
1062: ) then

Line 1129: when app_exception.application_exception then

1125: end if;
1126: end if;
1127: hr_utility.set_location(' Leaving:'||l_proc,50);
1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>
1132: 'IRC_SEARCH_CRITERIA.MATCH_QUALIFICATION'
1133: ) then

Line 1197: when app_exception.application_exception then

1193: end if;
1194: close csr_vacancy_id;
1195: hr_utility.set_location(' Leaving:'||l_proc,40);
1196: exception
1197: when app_exception.application_exception then
1198: if hr_multi_message.exception_add
1199: (p_associated_column1 =>
1200: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
1201: ) then

Line 1278: when app_exception.application_exception then

1274: end if;
1275: end if;
1276: hr_utility.set_location(' Leaving:'||l_proc,60);
1277: exception
1278: when app_exception.application_exception then
1279: if hr_multi_message.exception_add
1280: (p_associated_column1 =>
1281: 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1282: ) then

Line 1354: when app_exception.application_exception then

1350: end if;
1351: end if;
1352: hr_utility.set_location('Leaving:'||l_proc,40);
1353: exception
1354: when app_exception.application_exception then
1355: if hr_multi_message.exception_add
1356: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1357: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1358: ) then

Line 1428: when app_exception.application_exception then

1424: end if;
1425: end if;
1426: hr_utility.set_location(' Leaving:'||l_proc,50);
1427: exception
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1431: ) then
1432: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1518: when app_exception.application_exception then

1514: -- When Multiple error detection is enabled handle the application errors
1515: -- which have been raised by this procedure. Transfer the error to the
1516: -- Multiple message list and associate the error with max_salary and
1517: -- min_salary
1518: when app_exception.application_exception then
1519: if hr_multi_message.exception_add
1520: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1521: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
1522: ) then

Line 1583: when app_exception.application_exception then

1579: end if;
1580: end if;
1581: hr_utility.set_location(' Leaving:'||l_proc,40);
1582: exception
1583: when app_exception.application_exception then
1584: if hr_multi_message.exception_add
1585: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'
1586: ) then
1587: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 1645: when app_exception.application_exception then

1641: end if;
1642: end if;
1643: hr_utility.set_location(' Leaving:'||l_proc,40);
1644: exception
1645: when app_exception.application_exception then
1646: if hr_multi_message.exception_add
1647: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.CONTRACTOR'
1648: ) then
1649: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 1719: when app_exception.application_exception then

1715: end if;
1716: end if;
1717: hr_utility.set_location(' Leaving:'||l_proc,50);
1718: exception
1719: when app_exception.application_exception then
1720: if hr_multi_message.exception_add
1721: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.PROFESSIONAL_AREA'
1722: ) then
1723: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1796: when app_exception.application_exception then

1792: end if;
1793: end if;
1794: hr_utility.set_location(' Leaving:'||l_proc,50);
1795: exception
1796: when app_exception.application_exception then
1797: if hr_multi_message.exception_add
1798: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYMENT_CATEGORY'
1799: ) then
1800: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1873: when app_exception.application_exception then

1869: end if;
1870: end if;
1871: hr_utility.set_location(' Leaving:'||l_proc,50);
1872: exception
1873: when app_exception.application_exception then
1874: if hr_multi_message.exception_add
1875: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.WORK_AT_HOME'
1876: ) then
1877: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1950: when app_exception.application_exception then

1946: end if;
1947: end if;
1948: hr_utility.set_location(' Leaving:'||l_proc,50);
1949: exception
1950: when app_exception.application_exception then
1951: if hr_multi_message.exception_add
1952: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.TRAVEL_PERCENTAGE'
1953: ) then
1954: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 2047: when app_exception.application_exception then

2043: end if;
2044: end if;
2045: hr_utility.set_location(' Leaving:'||l_proc,50);
2046: exception
2047: when app_exception.application_exception then
2048: if hr_multi_message.exception_add
2049: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.SALARY_PERIOD'
2050: ) then
2051: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 2168: when app_exception.application_exception then

2164: -- When Multiple error detection is enabled handle the application errors
2165: -- which have been raised by this procedure. Transfer the error to the
2166: -- Multiple message list and associate the error with max_salary,
2167: -- min_salary and salary_currency columns.
2168: when app_exception.application_exception then
2169: if hr_multi_message.exception_add
2170: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2171: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2172: ,p_associated_column3 => 'IRC_SEARCH_CRITERIA.SALARY_CURRENCY'

Line 2247: when app_exception.application_exception then

2243: end if;
2244: end if;
2245: hr_utility.set_location(' Leaving:'||l_proc,50);
2246: exception
2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DATE_POSTED'
2250: ) then
2251: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 2374: when app_exception.application_exception then

2370: end if;
2371: --
2372: hr_utility.set_location(' Leaving:'||l_proc,50);
2373: exception
2374: when app_exception.application_exception then
2375: if hr_multi_message.exception_add
2376: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'
2377: ) then
2378: hr_utility.set_location(' Leaving:'||l_proc,60);