eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IOF_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

59: close csr_sec_grp;
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

Line 140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

136: --
137: -- The primary key is invalid therefore we must error
138: --
139: close csr_leg_code;
140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: end if;
143: hr_utility.set_location(l_proc,30);
144: --

Line 141: fnd_message.raise_error;

137: -- The primary key is invalid therefore we must error
138: --
139: close csr_leg_code;
140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: end if;
143: hr_utility.set_location(l_proc,30);
144: --
145: -- Set the global variables so the values are

Line 377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

373: IF NOT irc_iof_shd.api_updating
374: (p_offer_id => p_rec.offer_id
375: ,p_object_version_number => p_rec.object_version_number
376: ) THEN
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '5');
380: fnd_message.raise_error;
381: END IF;

Line 378: fnd_message.set_token('PROCEDURE ', l_proc);

374: (p_offer_id => p_rec.offer_id
375: ,p_object_version_number => p_rec.object_version_number
376: ) THEN
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '5');
380: fnd_message.raise_error;
381: END IF;
382: --

Line 379: fnd_message.set_token('STEP ', '5');

375: ,p_object_version_number => p_rec.object_version_number
376: ) THEN
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '5');
380: fnd_message.raise_error;
381: END IF;
382: --
383: if irc_iof_shd.g_old_rec.offer_id <> p_rec.offer_id

Line 380: fnd_message.raise_error;

376: ) THEN
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '5');
380: fnd_message.raise_error;
381: END IF;
382: --
383: if irc_iof_shd.g_old_rec.offer_id <> p_rec.offer_id
384: then

Line 494: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');

490: hr_utility.set_location(l_proc,20);
491: if (csr_applicant_assignment_id%notfound)
492: then
493: close csr_applicant_assignment_id;
494: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
495: fnd_message.raise_error;
496: end if;
497: close csr_applicant_assignment_id;
498: --

Line 495: fnd_message.raise_error;

491: if (csr_applicant_assignment_id%notfound)
492: then
493: close csr_applicant_assignment_id;
494: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
495: fnd_message.raise_error;
496: end if;
497: close csr_applicant_assignment_id;
498: --
499: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 575: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');

571: --
572: hr_utility.set_location(l_proc,20);
573: --
574: close csr_offer_assignment_id;
575: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
576: fnd_message.raise_error;
577: end if;
578: close csr_offer_assignment_id;
579: --

Line 576: fnd_message.raise_error;

572: hr_utility.set_location(l_proc,20);
573: --
574: close csr_offer_assignment_id;
575: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
576: fnd_message.raise_error;
577: end if;
578: close csr_offer_assignment_id;
579: --
580: -- Check to see if an offer already exists with this

Line 592: fnd_message.set_name('PER','IRC_412348_OFR_ASNMT_EXISTS');

588: --
589: hr_utility.set_location(l_proc,25);
590: --
591: close csr_offer_assigment_exists;
592: fnd_message.set_name('PER','IRC_412348_OFR_ASNMT_EXISTS');
593: fnd_message.raise_error;
594: end if;
595: close csr_offer_assigment_exists;
596: end if; -- no_exclusive_error

Line 593: fnd_message.raise_error;

589: hr_utility.set_location(l_proc,25);
590: --
591: close csr_offer_assigment_exists;
592: fnd_message.set_name('PER','IRC_412348_OFR_ASNMT_EXISTS');
593: fnd_message.raise_error;
594: end if;
595: close csr_offer_assigment_exists;
596: end if; -- no_exclusive_error
597: --

Line 670: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');

666: --
667: hr_utility.set_location(l_proc,30);
668: --
669: close csr_appl_vac_id;
670: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
671: fnd_message.raise_error;
672: end if;
673: close csr_appl_vac_id;
674: --

Line 671: fnd_message.raise_error;

667: hr_utility.set_location(l_proc,30);
668: --
669: close csr_appl_vac_id;
670: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
671: fnd_message.raise_error;
672: end if;
673: close csr_appl_vac_id;
674: --
675: p_vacancy_id := l_vacancy_id;

Line 805: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');

801: if csr_prev_offer_status%notfound
802: then
803: --
804: close csr_prev_offer_status;
805: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
806: fnd_message.raise_error;
807: --
808: end if;
809: close csr_prev_offer_status;

Line 806: fnd_message.raise_error;

802: then
803: --
804: close csr_prev_offer_status;
805: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
806: fnd_message.raise_error;
807: --
808: end if;
809: close csr_prev_offer_status;
810: --

Line 824: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');

820: if csr_prev_to_prev_offer_chg_rsn%notfound
821: then
822: --
823: close csr_prev_to_prev_offer_chg_rsn;
824: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
825: fnd_message.raise_error;
826: --
827: end if;
828: close csr_prev_to_prev_offer_chg_rsn;

Line 825: fnd_message.raise_error;

821: then
822: --
823: close csr_prev_to_prev_offer_chg_rsn;
824: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
825: fnd_message.raise_error;
826: --
827: end if;
828: close csr_prev_to_prev_offer_chg_rsn;
829: --

Line 882: fnd_message.set_name('PER','IRC_412331_OFR_EXCDD_VAC_COUNT');

878: close csr_offer_count;
879: --
880: if (l_offer_count >= l_vacancy_opening_count.budget_measurement_value)
881: then
882: fnd_message.set_name('PER','IRC_412331_OFR_EXCDD_VAC_COUNT');
883: fnd_message.raise_error;
884: end if;
885: --
886: end if;

Line 883: fnd_message.raise_error;

879: --
880: if (l_offer_count >= l_vacancy_opening_count.budget_measurement_value)
881: then
882: fnd_message.set_name('PER','IRC_412331_OFR_EXCDD_VAC_COUNT');
883: fnd_message.raise_error;
884: end if;
885: --
886: end if;
887: --

Line 980: fnd_message.set_name('FND','FND_GRANTS_GNT_USER_INVALID');

976: hr_utility.set_location(l_proc,40);
977: if (csr_respondent_id%notfound)
978: then
979: close csr_respondent_id;
980: fnd_message.set_name('FND','FND_GRANTS_GNT_USER_INVALID');
981: fnd_message.raise_error;
982: end if;
983: close csr_respondent_id;
984: --

Line 981: fnd_message.raise_error;

977: if (csr_respondent_id%notfound)
978: then
979: close csr_respondent_id;
980: fnd_message.set_name('FND','FND_GRANTS_GNT_USER_INVALID');
981: fnd_message.raise_error;
982: end if;
983: close csr_respondent_id;
984: --
985: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 1071: fnd_message.set_name('PER','IRC_412352_INV_EXP_DATE');

1067: --
1068: if p_expiry_date < p_effective_date
1069: then
1070: --
1071: fnd_message.set_name('PER','IRC_412352_INV_EXP_DATE');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --

Line 1072: fnd_message.raise_error;

1068: if p_expiry_date < p_effective_date
1069: then
1070: --
1071: fnd_message.set_name('PER','IRC_412352_INV_EXP_DATE');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --
1076: else -- p_expiry_date is null or is the previous expiry date

Line 1136: fnd_message.set_name('PER','IRC_412353_NULL_EXPIRY_DATE');

1132: else -- l_offer_duration_value is null
1133: --
1134: -- Both, the entered value and the profile value are null. Throw an error
1135: --
1136: fnd_message.set_name('PER','IRC_412353_NULL_EXPIRY_DATE');
1137: fnd_message.raise_error;
1138: --
1139: end if;
1140: --

Line 1137: fnd_message.raise_error;

1133: --
1134: -- Both, the entered value and the profile value are null. Throw an error
1135: --
1136: fnd_message.set_name('PER','IRC_412353_NULL_EXPIRY_DATE');
1137: fnd_message.raise_error;
1138: --
1139: end if;
1140: --
1141: end if;

Line 1335: fnd_message.set_name('PER','IRC_412001_BAD_ADDRESS_ID');

1331: hr_utility.set_location(l_proc,30);
1332: if (csr_address_id%notfound)
1333: then
1334: close csr_address_id;
1335: fnd_message.set_name('PER','IRC_412001_BAD_ADDRESS_ID');
1336: fnd_message.raise_error;
1337: end if;
1338: close csr_address_id;
1339: --

Line 1336: fnd_message.raise_error;

1332: if (csr_address_id%notfound)
1333: then
1334: close csr_address_id;
1335: fnd_message.set_name('PER','IRC_412001_BAD_ADDRESS_ID');
1336: fnd_message.raise_error;
1337: end if;
1338: close csr_address_id;
1339: --
1340: hr_utility.set_location(' Leaving:'||l_proc,40);

Line 1472: fnd_message.set_name('PER','IRC_412326_OFFER_INV_TEMPLT_ID');

1468: --
1469: hr_utility.set_location(l_proc,40);
1470: --
1471: close csr_template_id;
1472: fnd_message.set_name('PER','IRC_412326_OFFER_INV_TEMPLT_ID');
1473: fnd_message.raise_error;
1474: end if;
1475: close csr_template_id;
1476: --

Line 1473: fnd_message.raise_error;

1469: hr_utility.set_location(l_proc,40);
1470: --
1471: close csr_template_id;
1472: fnd_message.set_name('PER','IRC_412326_OFFER_INV_TEMPLT_ID');
1473: fnd_message.raise_error;
1474: end if;
1475: close csr_template_id;
1476: --
1477: else

Line 1715: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');

1711: hr_utility.set_location(l_proc,30);
1712: if (csr_latest_offer_ins%found)
1713: then
1714: close csr_latest_offer_ins;
1715: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1716: fnd_message.raise_error;
1717: end if;
1718: close csr_latest_offer_ins;
1719: --

Line 1716: fnd_message.raise_error;

1712: if (csr_latest_offer_ins%found)
1713: then
1714: close csr_latest_offer_ins;
1715: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1716: fnd_message.raise_error;
1717: end if;
1718: close csr_latest_offer_ins;
1719: --
1720: end if;

Line 1736: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');

1732: hr_utility.set_location(l_proc,30);
1733: if (csr_latest_offer_upd%found)
1734: then
1735: close csr_latest_offer_upd;
1736: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1737: fnd_message.raise_error;
1738: end if;
1739: close csr_latest_offer_upd;
1740: --

Line 1737: fnd_message.raise_error;

1733: if (csr_latest_offer_upd%found)
1734: then
1735: close csr_latest_offer_upd;
1736: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1737: fnd_message.raise_error;
1738: end if;
1739: close csr_latest_offer_upd;
1740: --
1741: end if;

Line 1765: fnd_message.set_name(800, 'IRC_412307_INV_LATEST_OFR_VAL');

1761: -- Error: Invalid latest offer value.
1762: --
1763: hr_utility.set_location(l_proc,50);
1764: --
1765: fnd_message.set_name(800, 'IRC_412307_INV_LATEST_OFR_VAL');
1766: fnd_message.raise_error;
1767: end if;
1768: --
1769: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1766: fnd_message.raise_error;

1762: --
1763: hr_utility.set_location(l_proc,50);
1764: --
1765: fnd_message.set_name(800, 'IRC_412307_INV_LATEST_OFR_VAL');
1766: fnd_message.raise_error;
1767: end if;
1768: --
1769: hr_utility.set_location(' Leaving:'||l_proc,60);
1770: end if;

Line 1861: fnd_message.set_name(800,'IRC_412308_INV_OFFER_VER_COMB');

1857: fetch csr_version into l_version;
1858: hr_utility.set_location(l_proc,20);
1859: if csr_version%found then
1860: close csr_version;
1861: fnd_message.set_name(800,'IRC_412308_INV_OFFER_VER_COMB');
1862: fnd_message.raise_error;
1863: end if;
1864: close csr_version;
1865: end if;

Line 1862: fnd_message.raise_error;

1858: hr_utility.set_location(l_proc,20);
1859: if csr_version%found then
1860: close csr_version;
1861: fnd_message.set_name(800,'IRC_412308_INV_OFFER_VER_COMB');
1862: fnd_message.raise_error;
1863: end if;
1864: close csr_version;
1865: end if;
1866: end if; -- no_exclusive_error

Line 1964: fnd_message.set_name('PER', 'IRC_412323_INV_OFFER_STATUS');

1960: ) then
1961: --
1962: hr_utility.set_location(l_proc, 30);
1963: -- Error: Invalid offer status type.
1964: fnd_message.set_name('PER', 'IRC_412323_INV_OFFER_STATUS');
1965: fnd_message.raise_error;
1966: end if;
1967: end if;
1968: --

Line 1965: fnd_message.raise_error;

1961: --
1962: hr_utility.set_location(l_proc, 30);
1963: -- Error: Invalid offer status type.
1964: fnd_message.set_name('PER', 'IRC_412323_INV_OFFER_STATUS');
1965: fnd_message.raise_error;
1966: end if;
1967: end if;
1968: --
1969: -- While creation the offer cannot of any of the following statuses:

Line 1980: fnd_message.set_name('PER', 'IRC_412309_INV_CRT_OFR_STATUS');

1976: if p_offer_status in ('CLOSED', 'EXTENDED', 'HOLD', 'CORRECTION', 'PENDING_EXTENDED')
1977: then
1978: --
1979: hr_utility.set_location(l_proc, 50);
1980: fnd_message.set_name('PER', 'IRC_412309_INV_CRT_OFR_STATUS');
1981: fnd_message.raise_error;
1982: --
1983: end if;
1984: end if;

Line 1981: fnd_message.raise_error;

1977: then
1978: --
1979: hr_utility.set_location(l_proc, 50);
1980: fnd_message.set_name('PER', 'IRC_412309_INV_CRT_OFR_STATUS');
1981: fnd_message.raise_error;
1982: --
1983: end if;
1984: end if;
1985: --

Line 2090: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');

2086: ) then
2087: --
2088: hr_utility.set_location(l_proc,40);
2089: --
2090: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2091: fnd_message.raise_error;
2092: end if;
2093: --
2094: -- Also Check that when in HOLD, no other data can be

Line 2091: fnd_message.raise_error;

2087: --
2088: hr_utility.set_location(l_proc,40);
2089: --
2090: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2091: fnd_message.raise_error;
2092: end if;
2093: --
2094: -- Also Check that when in HOLD, no other data can be
2095: -- changed in the offer record.

Line 2151: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');

2147: then
2148: --
2149: hr_utility.set_location(l_proc,45);
2150: --
2151: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2152: fnd_message.raise_error;
2153: end if;
2154: --
2155: else

Line 2152: fnd_message.raise_error;

2148: --
2149: hr_utility.set_location(l_proc,45);
2150: --
2151: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2152: fnd_message.raise_error;
2153: end if;
2154: --
2155: else
2156: --

Line 2179: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');

2175: ) then
2176: --
2177: hr_utility.set_location(l_proc,70);
2178: --
2179: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
2180: fnd_message.raise_error;
2181: --
2182: end if;
2183: end if;

Line 2180: fnd_message.raise_error;

2176: --
2177: hr_utility.set_location(l_proc,70);
2178: --
2179: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
2180: fnd_message.raise_error;
2181: --
2182: end if;
2183: end if;
2184: end if; -- if-else-end if

Line 2345: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

2341: Close C_Sel1;
2342: --
2343: -- The primary key is invalid therefore we must error
2344: --
2345: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2346: fnd_message.raise_error;
2347: End If;
2348: Close C_Sel1;
2349: --

Line 2346: fnd_message.raise_error;

2342: --
2343: -- The primary key is invalid therefore we must error
2344: --
2345: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2346: fnd_message.raise_error;
2347: End If;
2348: Close C_Sel1;
2349: --
2350: -- If any field has changed, increment l_update_count.

Line 3101: fnd_message.set_name(800, 'IRC_412310_INV_OFR_EXTNDD_MTHD');

3097: ,p_lookup_code => p_offer_extended_method
3098: ) then
3099: --
3100: -- Error: Invalid offer extended method.
3101: fnd_message.set_name(800, 'IRC_412310_INV_OFR_EXTNDD_MTHD');
3102: fnd_message.raise_error;
3103: end if;
3104: end if;
3105: end if;

Line 3102: fnd_message.raise_error;

3098: ) then
3099: --
3100: -- Error: Invalid offer extended method.
3101: fnd_message.set_name(800, 'IRC_412310_INV_OFR_EXTNDD_MTHD');
3102: fnd_message.raise_error;
3103: end if;
3104: end if;
3105: end if;
3106: end if; -- no_exclusive_error

Line 3205: fnd_message.set_name(800, 'IRC_412311_INV_OFR_POSTAL_SERV');

3201: ,p_lookup_code => p_offer_postal_service
3202: ) then
3203: --
3204: -- Error: Invalid offer extended method.
3205: fnd_message.set_name(800, 'IRC_412311_INV_OFR_POSTAL_SERV');
3206: fnd_message.raise_error;
3207: end if;
3208: end if;
3209: end if;

Line 3206: fnd_message.raise_error;

3202: ) then
3203: --
3204: -- Error: Invalid offer extended method.
3205: fnd_message.set_name(800, 'IRC_412311_INV_OFR_POSTAL_SERV');
3206: fnd_message.raise_error;
3207: end if;
3208: end if;
3209: end if;
3210: end if; -- no_exclusive_error

Line 3285: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

3281: then
3282: --
3283: hr_utility.set_location(l_proc, 30);
3284: --
3285: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
3286: fnd_message.raise_error;
3287: --
3288: end if;
3289: --

Line 3286: fnd_message.raise_error;

3282: --
3283: hr_utility.set_location(l_proc, 30);
3284: --
3285: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
3286: fnd_message.raise_error;
3287: --
3288: end if;
3289: --
3290: -- Check if the offer letter is present. If blob length is 0, it means that

Line 3298: fnd_message.set_name('PER','IRC_412312_UPLOAD_OFFER_LETTER');

3294: then
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: --

Line 3405: fnd_message.set_name(800, 'IRC_412312_UPLOAD_OFFER_LETTER');

3401: ,p_lookup_type => 'XDO_OUTPUT_TYPE'
3402: ,p_lookup_code => p_offer_letter_file_type
3403: ) then
3404:
3405: fnd_message.set_name(800, 'IRC_412312_UPLOAD_OFFER_LETTER');
3406: fnd_message.raise_error;
3407: end if;
3408: end if;
3409: end if;

Line 3406: fnd_message.raise_error;

3402: ,p_lookup_code => p_offer_letter_file_type
3403: ) then
3404:
3405: fnd_message.set_name(800, 'IRC_412312_UPLOAD_OFFER_LETTER');
3406: fnd_message.raise_error;
3407: end if;
3408: end if;
3409: end if;
3410: end if; -- no_exclusive_error