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 778: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');

774: if csr_prev_offer_status%notfound
775: then
776: --
777: close csr_prev_offer_status;
778: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
779: fnd_message.raise_error;
780: --
781: end if;
782: close csr_prev_offer_status;

Line 779: fnd_message.raise_error;

775: then
776: --
777: close csr_prev_offer_status;
778: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
779: fnd_message.raise_error;
780: --
781: end if;
782: close csr_prev_offer_status;
783: --

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

793: if csr_prev_to_prev_offer_chg_rsn%notfound
794: then
795: --
796: close csr_prev_to_prev_offer_chg_rsn;
797: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
798: fnd_message.raise_error;
799: --
800: end if;
801: close csr_prev_to_prev_offer_chg_rsn;

Line 798: fnd_message.raise_error;

794: then
795: --
796: close csr_prev_to_prev_offer_chg_rsn;
797: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
798: fnd_message.raise_error;
799: --
800: end if;
801: close csr_prev_to_prev_offer_chg_rsn;
802: --

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

851: close csr_offer_count;
852: --
853: if (l_offer_count >= l_vacancy_opening_count.budget_measurement_value)
854: then
855: fnd_message.set_name('PER','IRC_412331_OFR_EXCDD_VAC_COUNT');
856: fnd_message.raise_error;
857: end if;
858: --
859: end if;

Line 856: fnd_message.raise_error;

852: --
853: if (l_offer_count >= l_vacancy_opening_count.budget_measurement_value)
854: then
855: fnd_message.set_name('PER','IRC_412331_OFR_EXCDD_VAC_COUNT');
856: fnd_message.raise_error;
857: end if;
858: --
859: end if;
860: --

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

949: hr_utility.set_location(l_proc,40);
950: if (csr_respondent_id%notfound)
951: then
952: close csr_respondent_id;
953: fnd_message.set_name('FND','FND_GRANTS_GNT_USER_INVALID');
954: fnd_message.raise_error;
955: end if;
956: close csr_respondent_id;
957: --

Line 954: fnd_message.raise_error;

950: if (csr_respondent_id%notfound)
951: then
952: close csr_respondent_id;
953: fnd_message.set_name('FND','FND_GRANTS_GNT_USER_INVALID');
954: fnd_message.raise_error;
955: end if;
956: close csr_respondent_id;
957: --
958: hr_utility.set_location(' Leaving:'||l_proc,50);

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

1040: --
1041: if p_expiry_date < p_effective_date
1042: then
1043: --
1044: fnd_message.set_name('PER','IRC_412352_INV_EXP_DATE');
1045: fnd_message.raise_error;
1046: --
1047: end if;
1048: --

Line 1045: fnd_message.raise_error;

1041: if p_expiry_date < p_effective_date
1042: then
1043: --
1044: fnd_message.set_name('PER','IRC_412352_INV_EXP_DATE');
1045: fnd_message.raise_error;
1046: --
1047: end if;
1048: --
1049: else -- p_expiry_date is null or is the previous expiry date

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

1105: else -- l_offer_duration_value is null
1106: --
1107: -- Both, the entered value and the profile value are null. Throw an error
1108: --
1109: fnd_message.set_name('PER','IRC_412353_NULL_EXPIRY_DATE');
1110: fnd_message.raise_error;
1111: --
1112: end if;
1113: --

Line 1110: fnd_message.raise_error;

1106: --
1107: -- Both, the entered value and the profile value are null. Throw an error
1108: --
1109: fnd_message.set_name('PER','IRC_412353_NULL_EXPIRY_DATE');
1110: fnd_message.raise_error;
1111: --
1112: end if;
1113: --
1114: end if;

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

1304: hr_utility.set_location(l_proc,30);
1305: if (csr_address_id%notfound)
1306: then
1307: close csr_address_id;
1308: fnd_message.set_name('PER','IRC_412001_BAD_ADDRESS_ID');
1309: fnd_message.raise_error;
1310: end if;
1311: close csr_address_id;
1312: --

Line 1309: fnd_message.raise_error;

1305: if (csr_address_id%notfound)
1306: then
1307: close csr_address_id;
1308: fnd_message.set_name('PER','IRC_412001_BAD_ADDRESS_ID');
1309: fnd_message.raise_error;
1310: end if;
1311: close csr_address_id;
1312: --
1313: hr_utility.set_location(' Leaving:'||l_proc,40);

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

1441: --
1442: hr_utility.set_location(l_proc,40);
1443: --
1444: close csr_template_id;
1445: fnd_message.set_name('PER','IRC_412326_OFFER_INV_TEMPLT_ID');
1446: fnd_message.raise_error;
1447: end if;
1448: close csr_template_id;
1449: --

Line 1446: fnd_message.raise_error;

1442: hr_utility.set_location(l_proc,40);
1443: --
1444: close csr_template_id;
1445: fnd_message.set_name('PER','IRC_412326_OFFER_INV_TEMPLT_ID');
1446: fnd_message.raise_error;
1447: end if;
1448: close csr_template_id;
1449: --
1450: else

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

1674: hr_utility.set_location(l_proc,30);
1675: if (csr_latest_offer_ins%found)
1676: then
1677: close csr_latest_offer_ins;
1678: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1679: fnd_message.raise_error;
1680: end if;
1681: close csr_latest_offer_ins;
1682: --

Line 1679: fnd_message.raise_error;

1675: if (csr_latest_offer_ins%found)
1676: then
1677: close csr_latest_offer_ins;
1678: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1679: fnd_message.raise_error;
1680: end if;
1681: close csr_latest_offer_ins;
1682: --
1683: end if;

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

1695: hr_utility.set_location(l_proc,30);
1696: if (csr_latest_offer_upd%found)
1697: then
1698: close csr_latest_offer_upd;
1699: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1700: fnd_message.raise_error;
1701: end if;
1702: close csr_latest_offer_upd;
1703: --

Line 1700: fnd_message.raise_error;

1696: if (csr_latest_offer_upd%found)
1697: then
1698: close csr_latest_offer_upd;
1699: fnd_message.set_name('PER','IRC_412332_INV_APL_LSTOFR_COMB');
1700: fnd_message.raise_error;
1701: end if;
1702: close csr_latest_offer_upd;
1703: --
1704: end if;

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

1724: -- Error: Invalid latest offer value.
1725: --
1726: hr_utility.set_location(l_proc,50);
1727: --
1728: fnd_message.set_name(800, 'IRC_412307_INV_LATEST_OFR_VAL');
1729: fnd_message.raise_error;
1730: end if;
1731: --
1732: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1729: fnd_message.raise_error;

1725: --
1726: hr_utility.set_location(l_proc,50);
1727: --
1728: fnd_message.set_name(800, 'IRC_412307_INV_LATEST_OFR_VAL');
1729: fnd_message.raise_error;
1730: end if;
1731: --
1732: hr_utility.set_location(' Leaving:'||l_proc,60);
1733: end if;

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

1820: fetch csr_version into l_version;
1821: hr_utility.set_location(l_proc,20);
1822: if csr_version%found then
1823: close csr_version;
1824: fnd_message.set_name(800,'IRC_412308_INV_OFFER_VER_COMB');
1825: fnd_message.raise_error;
1826: end if;
1827: close csr_version;
1828: end if;

Line 1825: fnd_message.raise_error;

1821: hr_utility.set_location(l_proc,20);
1822: if csr_version%found then
1823: close csr_version;
1824: fnd_message.set_name(800,'IRC_412308_INV_OFFER_VER_COMB');
1825: fnd_message.raise_error;
1826: end if;
1827: close csr_version;
1828: end if;
1829: end if; -- no_exclusive_error

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

1923: ) then
1924: --
1925: hr_utility.set_location(l_proc, 30);
1926: -- Error: Invalid offer status type.
1927: fnd_message.set_name('PER', 'IRC_412323_INV_OFFER_STATUS');
1928: fnd_message.raise_error;
1929: end if;
1930: end if;
1931: --

Line 1928: fnd_message.raise_error;

1924: --
1925: hr_utility.set_location(l_proc, 30);
1926: -- Error: Invalid offer status type.
1927: fnd_message.set_name('PER', 'IRC_412323_INV_OFFER_STATUS');
1928: fnd_message.raise_error;
1929: end if;
1930: end if;
1931: --
1932: -- While creation the offer cannot of any of the following statuses:

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

1939: if p_offer_status in ('CLOSED', 'EXTENDED', 'HOLD', 'CORRECTION', 'PENDING_EXTENDED')
1940: then
1941: --
1942: hr_utility.set_location(l_proc, 50);
1943: fnd_message.set_name('PER', 'IRC_412309_INV_CRT_OFR_STATUS');
1944: fnd_message.raise_error;
1945: --
1946: end if;
1947: end if;

Line 1944: fnd_message.raise_error;

1940: then
1941: --
1942: hr_utility.set_location(l_proc, 50);
1943: fnd_message.set_name('PER', 'IRC_412309_INV_CRT_OFR_STATUS');
1944: fnd_message.raise_error;
1945: --
1946: end if;
1947: end if;
1948: --

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

2035: ) then
2036: --
2037: hr_utility.set_location(l_proc,40);
2038: --
2039: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2040: fnd_message.raise_error;
2041: end if;
2042: --
2043: -- Also Check that when in HOLD, no other data can be

Line 2040: fnd_message.raise_error;

2036: --
2037: hr_utility.set_location(l_proc,40);
2038: --
2039: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2040: fnd_message.raise_error;
2041: end if;
2042: --
2043: -- Also Check that when in HOLD, no other data can be
2044: -- changed in the offer record.

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

2096: then
2097: --
2098: hr_utility.set_location(l_proc,45);
2099: --
2100: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2101: fnd_message.raise_error;
2102: end if;
2103: --
2104: else

Line 2101: fnd_message.raise_error;

2097: --
2098: hr_utility.set_location(l_proc,45);
2099: --
2100: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
2101: fnd_message.raise_error;
2102: end if;
2103: --
2104: else
2105: --

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

2124: ) then
2125: --
2126: hr_utility.set_location(l_proc,70);
2127: --
2128: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
2129: fnd_message.raise_error;
2130: --
2131: end if;
2132: end if;

Line 2129: fnd_message.raise_error;

2125: --
2126: hr_utility.set_location(l_proc,70);
2127: --
2128: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
2129: fnd_message.raise_error;
2130: --
2131: end if;
2132: end if;
2133: end if; -- if-else-end if

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

2290: Close C_Sel1;
2291: --
2292: -- The primary key is invalid therefore we must error
2293: --
2294: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2295: fnd_message.raise_error;
2296: End If;
2297: Close C_Sel1;
2298: --

Line 2295: fnd_message.raise_error;

2291: --
2292: -- The primary key is invalid therefore we must error
2293: --
2294: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2295: fnd_message.raise_error;
2296: End If;
2297: Close C_Sel1;
2298: --
2299: -- If any field has changed, increment l_update_count.

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

3046: ,p_lookup_code => p_offer_extended_method
3047: ) then
3048: --
3049: -- Error: Invalid offer extended method.
3050: fnd_message.set_name(800, 'IRC_412310_INV_OFR_EXTNDD_MTHD');
3051: fnd_message.raise_error;
3052: end if;
3053: end if;
3054: end if;

Line 3051: fnd_message.raise_error;

3047: ) then
3048: --
3049: -- Error: Invalid offer extended method.
3050: fnd_message.set_name(800, 'IRC_412310_INV_OFR_EXTNDD_MTHD');
3051: fnd_message.raise_error;
3052: end if;
3053: end if;
3054: end if;
3055: end if; -- no_exclusive_error

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

3150: ,p_lookup_code => p_offer_postal_service
3151: ) then
3152: --
3153: -- Error: Invalid offer extended method.
3154: fnd_message.set_name(800, 'IRC_412311_INV_OFR_POSTAL_SERV');
3155: fnd_message.raise_error;
3156: end if;
3157: end if;
3158: end if;

Line 3155: fnd_message.raise_error;

3151: ) then
3152: --
3153: -- Error: Invalid offer extended method.
3154: fnd_message.set_name(800, 'IRC_412311_INV_OFR_POSTAL_SERV');
3155: fnd_message.raise_error;
3156: end if;
3157: end if;
3158: end if;
3159: end if; -- no_exclusive_error

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

3230: then
3231: --
3232: hr_utility.set_location(l_proc, 30);
3233: --
3234: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
3235: fnd_message.raise_error;
3236: --
3237: end if;
3238: --

Line 3235: fnd_message.raise_error;

3231: --
3232: hr_utility.set_location(l_proc, 30);
3233: --
3234: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
3235: fnd_message.raise_error;
3236: --
3237: end if;
3238: --
3239: -- Check if the offer letter is present. If blob length is 0, it means that

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

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

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

3350: ,p_lookup_type => 'XDO_OUTPUT_TYPE'
3351: ,p_lookup_code => p_offer_letter_file_type
3352: ) then
3353:
3354: fnd_message.set_name(800, 'IRC_412312_UPLOAD_OFFER_LETTER');
3355: fnd_message.raise_error;
3356: end if;
3357: end if;
3358: end if;

Line 3355: fnd_message.raise_error;

3351: ,p_lookup_code => p_offer_letter_file_type
3352: ) then
3353:
3354: fnd_message.set_name(800, 'IRC_412312_UPLOAD_OFFER_LETTER');
3355: fnd_message.raise_error;
3356: end if;
3357: end if;
3358: end if;
3359: end if; -- no_exclusive_error