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 827: if hr_multi_message.no_exclusive_error(

823: --
824: if l_chk_vacancy_count = true
825: then
826: --
827: if hr_multi_message.no_exclusive_error(
828: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
829: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
830: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
831: )

Line 867: if hr_multi_message.exception_add

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

Line 918: if hr_multi_message.no_exclusive_error(

914: --
915: Begin
916: hr_utility.set_location('Entering:'||l_proc,10);
917: --
918: if hr_multi_message.no_exclusive_error(
919: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
920: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
921: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
922: ) then

Line 966: if hr_multi_message.exception_add

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

Line 1025: if hr_multi_message.no_exclusive_error(

1021: --
1022: Begin
1023: hr_utility.set_location('Entering:'||l_proc,10);
1024: --
1025: if hr_multi_message.no_exclusive_error(
1026: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1027: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1028: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1029: ) then

Line 1130: if hr_multi_message.exception_add

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

Line 1191: if hr_multi_message.no_exclusive_error(

1187: --
1188: Begin
1189: hr_utility.set_location('Entering:'||l_proc,10);
1190: --
1191: if hr_multi_message.no_exclusive_error(
1192: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1193: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1194: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1195: ) then

Line 1224: if hr_multi_message.exception_add

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

Line 1275: if hr_multi_message.no_exclusive_error(

1271: --
1272: Begin
1273: hr_utility.set_location('Entering:'||l_proc,10);
1274: --
1275: if hr_multi_message.no_exclusive_error(
1276: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1277: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1278: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1279: ) then

Line 1320: if hr_multi_message.exception_add

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

Line 1409: if hr_multi_message.no_exclusive_error(

1405: --
1406: Begin
1407: hr_utility.set_location('Entering:'||l_proc,10);
1408: --
1409: if hr_multi_message.no_exclusive_error(
1410: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1411: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1412: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1413: ) then

Line 1496: if hr_multi_message.exception_add

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

Line 1559: if hr_multi_message.exception_add

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

Line 1646: if hr_multi_message.no_exclusive_error(

1642: --
1643: Begin
1644: hr_utility.set_location('Entering:'||l_proc,10);
1645: --
1646: if hr_multi_message.no_exclusive_error(
1647: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1648: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1649: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1650: ) then

Line 1738: if hr_multi_message.exception_add

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

Line 1795: if hr_multi_message.no_exclusive_error(

1791: Begin
1792: --
1793: hr_utility.set_location(' Entering:'||l_proc,10);
1794: --
1795: if hr_multi_message.no_exclusive_error(
1796: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1797: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1798: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1799: ) then

Line 1833: if hr_multi_message.exception_add

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

Line 1884: if hr_multi_message.no_exclusive_error(

1880: --
1881: begin
1882: hr_utility.set_location('Entering:'|| l_proc, 10);
1883: --
1884: if hr_multi_message.no_exclusive_error(
1885: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1886: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1887: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1888: ) then

Line 1955: if hr_multi_message.exception_add

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

Line 2139: if hr_multi_message.exception_add

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

Line 3005: if hr_multi_message.no_exclusive_error(

3001: --
3002: begin
3003: hr_utility.set_location('Entering:'|| l_proc, 10);
3004: --
3005: if hr_multi_message.no_exclusive_error(
3006: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3007: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3008: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3009: ) then

Line 3060: if hr_multi_message.exception_add

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

Line 3109: if hr_multi_message.no_exclusive_error(

3105: --
3106: begin
3107: hr_utility.set_location('Entering:'|| l_proc, 10);
3108: --
3109: if hr_multi_message.no_exclusive_error(
3110: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3111: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3112: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3113: ) then

Line 3164: if hr_multi_message.exception_add

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

Line 3214: if hr_multi_message.no_exclusive_error(

3210: --
3211: begin
3212: hr_utility.set_location('Entering:'|| l_proc, 10);
3213: --
3214: if hr_multi_message.no_exclusive_error(
3215: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3216: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3217: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3218: ) then

Line 3248: hr_multi_message.add

3244: --
3245: hr_utility.set_location(l_proc, 40);
3246: --
3247: fnd_message.set_name('PER','IRC_412312_UPLOAD_OFFER_LETTER');
3248: hr_multi_message.add
3249: (p_message_type => hr_multi_message.g_warning_msg
3250: );
3251: --
3252: end if;

Line 3249: (p_message_type => hr_multi_message.g_warning_msg

3245: hr_utility.set_location(l_proc, 40);
3246: --
3247: fnd_message.set_name('PER','IRC_412312_UPLOAD_OFFER_LETTER');
3248: hr_multi_message.add
3249: (p_message_type => hr_multi_message.g_warning_msg
3250: );
3251: --
3252: end if;
3253: --

Line 3260: if hr_multi_message.exception_add

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

Line 3310: if hr_multi_message.no_exclusive_error(

3306: --
3307: begin
3308: hr_utility.set_location('Entering:'|| l_proc, 10);
3309: --
3310: if hr_multi_message.no_exclusive_error(
3311: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3312: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3313: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3314: ) then

Line 3364: if hr_multi_message.exception_add

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