DBA Data[Home] [Help]

APPS.IRC_IOF_BUS dependencies on HR_MULTI_MESSAGE

Line 64: hr_multi_message.add

60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1 => nvl(p_associated_column1,'OFFER_ID'));
66: --
67: else
68: close csr_sec_grp;

Line 502: if hr_multi_message.exception_add

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

Line 556: if hr_multi_message.no_exclusive_error(

552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc,10);
555: --
556: if hr_multi_message.no_exclusive_error(
557: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
558: ) then
559: --
560: hr_api.mandatory_arg_error

Line 601: if hr_multi_message.exception_add

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

Line 653: if hr_multi_message.no_exclusive_error(

649: --
650: Begin
651: hr_utility.set_location('Entering:'||l_proc,10);
652: --
653: if hr_multi_message.no_exclusive_error(
654: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
655: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
656: ) then
657: --

Line 682: if hr_multi_message.exception_add

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

Line 854: if hr_multi_message.no_exclusive_error(

850: --
851: if l_chk_vacancy_count = true
852: then
853: --
854: if hr_multi_message.no_exclusive_error(
855: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
856: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
857: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
858: )

Line 894: if hr_multi_message.exception_add

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

Line 945: if hr_multi_message.no_exclusive_error(

941: --
942: Begin
943: hr_utility.set_location('Entering:'||l_proc,10);
944: --
945: if hr_multi_message.no_exclusive_error(
946: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
947: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
948: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
949: ) then

Line 993: if hr_multi_message.exception_add

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

Line 1052: if hr_multi_message.no_exclusive_error(

1048: --
1049: Begin
1050: hr_utility.set_location('Entering:'||l_proc,10);
1051: --
1052: if hr_multi_message.no_exclusive_error(
1053: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1054: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1055: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1056: ) then

Line 1157: if hr_multi_message.exception_add

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

Line 1218: if hr_multi_message.no_exclusive_error(

1214: --
1215: Begin
1216: hr_utility.set_location('Entering:'||l_proc,10);
1217: --
1218: if hr_multi_message.no_exclusive_error(
1219: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1220: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1221: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1222: ) then

Line 1251: if hr_multi_message.exception_add

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

Line 1302: if hr_multi_message.no_exclusive_error(

1298: --
1299: Begin
1300: hr_utility.set_location('Entering:'||l_proc,10);
1301: --
1302: if hr_multi_message.no_exclusive_error(
1303: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1304: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1305: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1306: ) then

Line 1347: if hr_multi_message.exception_add

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

Line 1436: if hr_multi_message.no_exclusive_error(

1432: --
1433: Begin
1434: hr_utility.set_location('Entering:'||l_proc,10);
1435: --
1436: if hr_multi_message.no_exclusive_error(
1437: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1438: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1439: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1440: ) then

Line 1523: if hr_multi_message.exception_add

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

Line 1596: if hr_multi_message.exception_add

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

Line 1683: if hr_multi_message.no_exclusive_error(

1679: --
1680: Begin
1681: hr_utility.set_location('Entering:'||l_proc,10);
1682: --
1683: if hr_multi_message.no_exclusive_error(
1684: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1685: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1686: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1687: ) then

Line 1775: if hr_multi_message.exception_add

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

Line 1832: if hr_multi_message.no_exclusive_error(

1828: Begin
1829: --
1830: hr_utility.set_location(' Entering:'||l_proc,10);
1831: --
1832: if hr_multi_message.no_exclusive_error(
1833: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1834: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1835: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1836: ) then

Line 1870: if hr_multi_message.exception_add

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

Line 1921: if hr_multi_message.no_exclusive_error(

1917: --
1918: begin
1919: hr_utility.set_location('Entering:'|| l_proc, 10);
1920: --
1921: if hr_multi_message.no_exclusive_error(
1922: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1923: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1924: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1925: ) then

Line 1992: if hr_multi_message.exception_add

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

Line 2190: if hr_multi_message.exception_add

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

Line 3056: if hr_multi_message.no_exclusive_error(

3052: --
3053: begin
3054: hr_utility.set_location('Entering:'|| l_proc, 10);
3055: --
3056: if hr_multi_message.no_exclusive_error(
3057: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3058: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3059: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3060: ) then

Line 3111: if hr_multi_message.exception_add

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

Line 3160: if hr_multi_message.no_exclusive_error(

3156: --
3157: begin
3158: hr_utility.set_location('Entering:'|| l_proc, 10);
3159: --
3160: if hr_multi_message.no_exclusive_error(
3161: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3162: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3163: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3164: ) then

Line 3215: if hr_multi_message.exception_add

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

Line 3265: if hr_multi_message.no_exclusive_error(

3261: --
3262: begin
3263: hr_utility.set_location('Entering:'|| l_proc, 10);
3264: --
3265: if hr_multi_message.no_exclusive_error(
3266: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3267: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3268: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3269: ) then

Line 3299: hr_multi_message.add

3295: --
3296: hr_utility.set_location(l_proc, 40);
3297: --
3298: fnd_message.set_name('PER','IRC_412312_UPLOAD_OFFER_LETTER');
3299: hr_multi_message.add
3300: (p_message_type => hr_multi_message.g_warning_msg
3301: );
3302: --
3303: end if;

Line 3300: (p_message_type => hr_multi_message.g_warning_msg

3296: hr_utility.set_location(l_proc, 40);
3297: --
3298: fnd_message.set_name('PER','IRC_412312_UPLOAD_OFFER_LETTER');
3299: hr_multi_message.add
3300: (p_message_type => hr_multi_message.g_warning_msg
3301: );
3302: --
3303: end if;
3304: --

Line 3311: if hr_multi_message.exception_add

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

Line 3361: if hr_multi_message.no_exclusive_error(

3357: --
3358: begin
3359: hr_utility.set_location('Entering:'|| l_proc, 10);
3360: --
3361: if hr_multi_message.no_exclusive_error(
3362: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3363: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3364: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3365: ) then

Line 3415: if hr_multi_message.exception_add

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