DBA Data[Home] [Help]

APPS.IRC_IOF_BUS dependencies on APP_EXCEPTION

Line 501: when app_exception.application_exception then

497: close csr_applicant_assignment_id;
498: --
499: hr_utility.set_location(' Leaving:'||l_proc,30);
500: exception
501: when app_exception.application_exception then
502: if hr_multi_message.exception_add
503: (p_associated_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
504: ) then
505: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 600: when app_exception.application_exception then

596: end if; -- no_exclusive_error
597: --
598: hr_utility.set_location(' Leaving:'||l_proc,30);
599: exception
600: when app_exception.application_exception then
601: if hr_multi_message.exception_add
602: (p_associated_column1 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
603: ) then
604: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 681: when app_exception.application_exception then

677: end if; -- no_exclusive_error
678: --
679: hr_utility.set_location(' Leaving:'||l_proc,40);
680: exception
681: when app_exception.application_exception then
682: if hr_multi_message.exception_add
683: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'
684: ) then
685: hr_utility.set_location(' Leaving:'|| l_proc, 50);

Line 866: when app_exception.application_exception then

862: --
863: end if; -- if l_chk_vacancy_count check
864: hr_utility.set_location(' Leaving:'||l_proc,30);
865: exception
866: when app_exception.application_exception then
867: if hr_multi_message.exception_add
868: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'
869: ) then
870: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 965: when app_exception.application_exception then

961: end if;
962: end if; -- no_exclusive_error
963: --
964: exception
965: when app_exception.application_exception then
966: if hr_multi_message.exception_add
967: (p_associated_column1 => 'IRC_OFFERS.RESPONDENT_ID'
968: ) then
969: hr_utility.set_location(' Leaving:'|| l_proc, 60);

Line 1129: when app_exception.application_exception then

1125: --
1126: hr_utility.set_location(' Leaving:'||l_proc,70);
1127: --
1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 => 'IRC_OFFERS.EXPIRY_DATE'
1132: ) then
1133: hr_utility.set_location(' Leaving:'|| l_proc, 80);

Line 1223: when app_exception.application_exception then

1219: end if;
1220: end if; -- no_exclusive_error
1221: --
1222: exception
1223: when app_exception.application_exception then
1224: if hr_multi_message.exception_add
1225: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1226: ) then
1227: hr_utility.set_location(' Leaving:'|| l_proc, 50);

Line 1319: when app_exception.application_exception then

1315: end if;
1316: end if; -- no_exclusive_error
1317: --
1318: exception
1319: when app_exception.application_exception then
1320: if hr_multi_message.exception_add
1321: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1322: ) then
1323: hr_utility.set_location(' Leaving:'|| l_proc, 50);

Line 1495: when app_exception.application_exception then

1491: end if; -- no_exclusive_error
1492: hr_utility.set_location(' Leaving:'||l_proc,90);
1493: --
1494: exception
1495: when app_exception.application_exception then
1496: if hr_multi_message.exception_add
1497: (p_associated_column1 => 'IRC_OFFERS.TEMPLATE_ID'
1498: ) then
1499: hr_utility.set_location(' Leaving:'|| l_proc, 100);

Line 1558: when app_exception.application_exception then

1554: --
1555: hr_utility.set_location(' Leaving:'||l_proc,20);
1556: --
1557: exception
1558: when app_exception.application_exception then
1559: if hr_multi_message.exception_add
1560: (p_associated_column1 => 'IRC_OFFERS.OFFER_VERSION'
1561: ) then
1562: hr_utility.set_location(' Leaving:'|| l_proc, 30);

Line 1737: when app_exception.application_exception then

1733: end if;
1734: end if; -- no_exclusive_error
1735: --
1736: exception
1737: when app_exception.application_exception then
1738: if hr_multi_message.exception_add
1739: (p_associated_column1 => 'IRC_OFFERS.LATEST_OFFER'
1740: ) then
1741: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 1832: when app_exception.application_exception then

1828: end if;
1829: end if; -- no_exclusive_error
1830: --
1831: exception
1832: when app_exception.application_exception then
1833: if hr_multi_message.exception_add
1834: (p_associated_column1 => 'IRC_OFFER.OFFER_VERSION'
1835: ,p_associated_column2 => 'IRC_OFFER.APPLICANT_ASSIGNMENT_ID'
1836: ) then

Line 1954: when app_exception.application_exception then

1950: end if; -- no_exclusive_error
1951: --
1952: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1953: exception
1954: when app_exception.application_exception then
1955: if hr_multi_message.exception_add
1956: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
1957: ) then
1958: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 2138: when app_exception.application_exception then

2134: end if; -- Offer_status = 'CLOSED'
2135: --
2136: hr_utility.set_location(' Leaving:'|| l_proc, 80);
2137: exception
2138: when app_exception.application_exception then
2139: if hr_multi_message.exception_add
2140: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
2141: ) then
2142: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 3059: when app_exception.application_exception then

3055: end if; -- no_exclusive_error
3056: --
3057: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3058: exception
3059: when app_exception.application_exception then
3060: if hr_multi_message.exception_add
3061: (p_associated_column1 => 'IRC_OFFERS.OFFER_EXTENDED_METHOD'
3062: ) then
3063: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 3163: when app_exception.application_exception then

3159: end if; -- no_exclusive_error
3160: --
3161: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3162: exception
3163: when app_exception.application_exception then
3164: if hr_multi_message.exception_add
3165: (p_associated_column1 => 'IRC_OFFERS.OFFER_POSTAL_SERVICE'
3166: ) then
3167: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 3259: when app_exception.application_exception then

3255: end if; -- no_exclusive_error
3256: --
3257: hr_utility.set_location(' Leaving:'|| l_proc, 50);
3258: exception
3259: when app_exception.application_exception then
3260: if hr_multi_message.exception_add
3261: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER'
3262: ) then
3263: hr_utility.set_location(' Leaving:'|| l_proc, 60);

Line 3363: when app_exception.application_exception then

3359: end if; -- no_exclusive_error
3360: --
3361: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3362: exception
3363: when app_exception.application_exception then
3364: if hr_multi_message.exception_add
3365: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER_FILE_TYPE'
3366: ) then
3367: hr_utility.set_location(' Leaving:'|| l_proc, 40);