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 893: when app_exception.application_exception then

889: --
890: end if; -- if l_chk_vacancy_count check
891: hr_utility.set_location(' Leaving:'||l_proc,30);
892: exception
893: when app_exception.application_exception then
894: if hr_multi_message.exception_add
895: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'
896: ) then
897: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 992: when app_exception.application_exception then

988: end if;
989: end if; -- no_exclusive_error
990: --
991: exception
992: when app_exception.application_exception then
993: if hr_multi_message.exception_add
994: (p_associated_column1 => 'IRC_OFFERS.RESPONDENT_ID'
995: ) then
996: hr_utility.set_location(' Leaving:'|| l_proc, 60);

Line 1156: when app_exception.application_exception then

1152: --
1153: hr_utility.set_location(' Leaving:'||l_proc,70);
1154: --
1155: exception
1156: when app_exception.application_exception then
1157: if hr_multi_message.exception_add
1158: (p_associated_column1 => 'IRC_OFFERS.EXPIRY_DATE'
1159: ) then
1160: hr_utility.set_location(' Leaving:'|| l_proc, 80);

Line 1250: when app_exception.application_exception then

1246: end if;
1247: end if; -- no_exclusive_error
1248: --
1249: exception
1250: when app_exception.application_exception then
1251: if hr_multi_message.exception_add
1252: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1253: ) then
1254: hr_utility.set_location(' Leaving:'|| l_proc, 50);

Line 1346: when app_exception.application_exception then

1342: end if;
1343: end if; -- no_exclusive_error
1344: --
1345: exception
1346: when app_exception.application_exception then
1347: if hr_multi_message.exception_add
1348: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1349: ) then
1350: hr_utility.set_location(' Leaving:'|| l_proc, 50);

Line 1522: when app_exception.application_exception then

1518: end if; -- no_exclusive_error
1519: hr_utility.set_location(' Leaving:'||l_proc,90);
1520: --
1521: exception
1522: when app_exception.application_exception then
1523: if hr_multi_message.exception_add
1524: (p_associated_column1 => 'IRC_OFFERS.TEMPLATE_ID'
1525: ) then
1526: hr_utility.set_location(' Leaving:'|| l_proc, 100);

Line 1595: when app_exception.application_exception then

1591: --
1592: hr_utility.set_location(' Leaving:'||l_proc,20);
1593: --
1594: exception
1595: when app_exception.application_exception then
1596: if hr_multi_message.exception_add
1597: (p_associated_column1 => 'IRC_OFFERS.OFFER_VERSION'
1598: ) then
1599: hr_utility.set_location(' Leaving:'|| l_proc, 30);

Line 1774: when app_exception.application_exception then

1770: end if;
1771: end if; -- no_exclusive_error
1772: --
1773: exception
1774: when app_exception.application_exception then
1775: if hr_multi_message.exception_add
1776: (p_associated_column1 => 'IRC_OFFERS.LATEST_OFFER'
1777: ) then
1778: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 1869: when app_exception.application_exception then

1865: end if;
1866: end if; -- no_exclusive_error
1867: --
1868: exception
1869: when app_exception.application_exception then
1870: if hr_multi_message.exception_add
1871: (p_associated_column1 => 'IRC_OFFER.OFFER_VERSION'
1872: ,p_associated_column2 => 'IRC_OFFER.APPLICANT_ASSIGNMENT_ID'
1873: ) then

Line 1991: when app_exception.application_exception then

1987: end if; -- no_exclusive_error
1988: --
1989: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1990: exception
1991: when app_exception.application_exception then
1992: if hr_multi_message.exception_add
1993: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
1994: ) then
1995: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 2189: when app_exception.application_exception then

2185: end if; -- Offer_status = 'CLOSED'
2186: --
2187: hr_utility.set_location(' Leaving:'|| l_proc, 80);
2188: exception
2189: when app_exception.application_exception then
2190: if hr_multi_message.exception_add
2191: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
2192: ) then
2193: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 3110: when app_exception.application_exception then

3106: end if; -- no_exclusive_error
3107: --
3108: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3109: exception
3110: when app_exception.application_exception then
3111: if hr_multi_message.exception_add
3112: (p_associated_column1 => 'IRC_OFFERS.OFFER_EXTENDED_METHOD'
3113: ) then
3114: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 3214: when app_exception.application_exception then

3210: end if; -- no_exclusive_error
3211: --
3212: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3213: exception
3214: when app_exception.application_exception then
3215: if hr_multi_message.exception_add
3216: (p_associated_column1 => 'IRC_OFFERS.OFFER_POSTAL_SERVICE'
3217: ) then
3218: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 3310: when app_exception.application_exception then

3306: end if; -- no_exclusive_error
3307: --
3308: hr_utility.set_location(' Leaving:'|| l_proc, 50);
3309: exception
3310: when app_exception.application_exception then
3311: if hr_multi_message.exception_add
3312: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER'
3313: ) then
3314: hr_utility.set_location(' Leaving:'|| l_proc, 60);

Line 3414: when app_exception.application_exception then

3410: end if; -- no_exclusive_error
3411: --
3412: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3413: exception
3414: when app_exception.application_exception then
3415: if hr_multi_message.exception_add
3416: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER_FILE_TYPE'
3417: ) then
3418: hr_utility.set_location(' Leaving:'|| l_proc, 40);