DBA Data[Home] [Help]

APPS.IRC_OFFERS_API dependencies on FND_MESSAGE

Line 181: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');

177: if csr_assignment_record%notfound
178: then
179: --
180: close csr_assignment_record;
181: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
182: fnd_message.raise_error;
183: --
184: end if;
185: close csr_assignment_record;

Line 182: fnd_message.raise_error;

178: then
179: --
180: close csr_assignment_record;
181: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
182: fnd_message.raise_error;
183: --
184: end if;
185: close csr_assignment_record;
186: --

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

446: --
447: hr_utility.set_location(l_proc,70);
448: --
449: --
450: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
451: fnd_message.raise_error;
452: --
453: end if;
454: close csr_assignment_ovn;

Line 451: fnd_message.raise_error;

447: hr_utility.set_location(l_proc,70);
448: --
449: --
450: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
451: fnd_message.raise_error;
452: --
453: end if;
454: close csr_assignment_ovn;
455: --

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

477: close csr_prev_assg_status_type;
478: --
479: hr_utility.set_location(l_proc,40);
480: --
481: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
482: fnd_message.raise_error;
483: --
484: end if;
485: close csr_prev_assg_status_type;

Line 482: fnd_message.raise_error;

478: --
479: hr_utility.set_location(l_proc,40);
480: --
481: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
482: fnd_message.raise_error;
483: --
484: end if;
485: close csr_prev_assg_status_type;
486: --

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

534: close csr_prev_assg_status_type;
535: --
536: hr_utility.set_location(l_proc,40);
537: --
538: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
539: fnd_message.raise_error;
540: --
541: end if;
542: close csr_prev_assg_status_type;

Line 539: fnd_message.raise_error;

535: --
536: hr_utility.set_location(l_proc,40);
537: --
538: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
539: fnd_message.raise_error;
540: --
541: end if;
542: close csr_prev_assg_status_type;
543: --Update only if it is an applicant assignment

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

695: if csr_offer_details%notfound
696: then
697: --
698: close csr_offer_details;
699: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
700: fnd_message.raise_error;
701: --
702: end if;
703: close csr_offer_details;

Line 700: fnd_message.raise_error;

696: then
697: --
698: close csr_offer_details;
699: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
700: fnd_message.raise_error;
701: --
702: end if;
703: close csr_offer_details;
704: --

Line 758: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');

754: --
755: hr_utility.set_location(l_proc, 65);
756: --
757: close csr_assignment_ovn;
758: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
759: fnd_message.raise_error;
760: --
761: end if;
762: close csr_assignment_ovn;

Line 759: fnd_message.raise_error;

755: hr_utility.set_location(l_proc, 65);
756: --
757: close csr_assignment_ovn;
758: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
759: fnd_message.raise_error;
760: --
761: end if;
762: close csr_assignment_ovn;
763: --

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

970: if csr_assignment_ids%notfound
971: then
972: --
973: close csr_assignment_ids;
974: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
975: fnd_message.raise_error;
976: --
977: end if;
978: close csr_assignment_ids;

Line 975: fnd_message.raise_error;

971: then
972: --
973: close csr_assignment_ids;
974: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
975: fnd_message.raise_error;
976: --
977: end if;
978: close csr_assignment_ids;
979: --

Line 987: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');

983: if csr_assignment_record%notfound
984: then
985: --
986: close csr_assignment_record;
987: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
988: fnd_message.raise_error;
989: --
990: end if;
991: close csr_assignment_record;

Line 988: fnd_message.raise_error;

984: then
985: --
986: close csr_assignment_record;
987: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
988: fnd_message.raise_error;
989: --
990: end if;
991: close csr_assignment_record;
992: --

Line 1010: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');

1006: if csr_appl_asg_effective_date%notfound
1007: then
1008: --
1009: close csr_appl_asg_effective_date;
1010: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
1011: fnd_message.raise_error;
1012: --
1013: end if;
1014: close csr_appl_asg_effective_date;

Line 1011: fnd_message.raise_error;

1007: then
1008: --
1009: close csr_appl_asg_effective_date;
1010: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
1011: fnd_message.raise_error;
1012: --
1013: end if;
1014: close csr_appl_asg_effective_date;
1015: --

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

1290: if csr_assignment_ids%notfound
1291: then
1292: --
1293: close csr_assignment_ids;
1294: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
1295: fnd_message.raise_error;
1296: --
1297: end if;
1298: close csr_assignment_ids;

Line 1295: fnd_message.raise_error;

1291: then
1292: --
1293: close csr_assignment_ids;
1294: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
1295: fnd_message.raise_error;
1296: --
1297: end if;
1298: close csr_assignment_ids;
1299:

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

1515: then
1516: --
1517: close csr_person_id;
1518: --
1519: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
1520: fnd_message.raise_error;
1521: --
1522: end if;
1523: close csr_person_id;

Line 1520: fnd_message.raise_error;

1516: --
1517: close csr_person_id;
1518: --
1519: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
1520: fnd_message.raise_error;
1521: --
1522: end if;
1523: close csr_person_id;
1524: --

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

2306: if csr_prev_offer_details%notfound
2307: then
2308: --
2309: close csr_prev_offer_details;
2310: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2311: fnd_message.raise_error;
2312: --
2313: end if;
2314: close csr_prev_offer_details;

Line 2311: fnd_message.raise_error;

2307: then
2308: --
2309: close csr_prev_offer_details;
2310: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2311: fnd_message.raise_error;
2312: --
2313: end if;
2314: close csr_prev_offer_details;
2315: --

Line 2330: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');

2326: if csr_assignment_record%notfound
2327: then
2328: --
2329: close csr_assignment_record;
2330: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
2331: fnd_message.raise_error;
2332: --
2333: end if;
2334: close csr_assignment_record;

Line 2331: fnd_message.raise_error;

2327: then
2328: --
2329: close csr_assignment_record;
2330: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
2331: fnd_message.raise_error;
2332: --
2333: end if;
2334: close csr_assignment_record;
2335: --

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

2502: --
2503: hr_utility.set_location(l_proc, 75);
2504: --
2505: close csr_offer_record;
2506: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2507: fnd_message.raise_error;
2508: --
2509: end if;
2510: close csr_offer_record;

Line 2507: fnd_message.raise_error;

2503: hr_utility.set_location(l_proc, 75);
2504: --
2505: close csr_offer_record;
2506: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2507: fnd_message.raise_error;
2508: --
2509: end if;
2510: close csr_offer_record;
2511: --

Line 2863: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as

2859: --
2860: -- This happens when an offer is being EXTENDED. Throw an error refusing to
2861: -- EXTEND another offer to the candidate
2862: --
2863: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
2864: -- an active offer exists for this application
2865: fnd_message.raise_error;
2866: --
2867: end if;

Line 2865: fnd_message.raise_error;

2861: -- EXTEND another offer to the candidate
2862: --
2863: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
2864: -- an active offer exists for this application
2865: fnd_message.raise_error;
2866: --
2867: end if;
2868: end if;
2869: --

Line 2903: fnd_message.set_name('PER','IRC_412299_CLOSE_REASON_MNDTRY');

2899: --
2900: if p_change_reason is null
2901: then
2902: --
2903: fnd_message.set_name('PER','IRC_412299_CLOSE_REASON_MNDTRY');
2904: fnd_message.raise_error;
2905: --
2906: end if;
2907: --

Line 2904: fnd_message.raise_error;

2900: if p_change_reason is null
2901: then
2902: --
2903: fnd_message.set_name('PER','IRC_412299_CLOSE_REASON_MNDTRY');
2904: fnd_message.raise_error;
2905: --
2906: end if;
2907: --
2908: -- Check if the change_reason is 'WITHDRAWAL'. If yes, close

Line 2926: fnd_message.set_name('PER','IRC_412300_OFFER_NOT_EXTENDED');

2922: then
2923: --
2924: hr_utility.set_location(l_proc,105);
2925: --
2926: fnd_message.set_name('PER','IRC_412300_OFFER_NOT_EXTENDED');
2927: fnd_message.raise_error;
2928: --
2929: end if;
2930: --

Line 2927: fnd_message.raise_error;

2923: --
2924: hr_utility.set_location(l_proc,105);
2925: --
2926: fnd_message.set_name('PER','IRC_412300_OFFER_NOT_EXTENDED');
2927: fnd_message.raise_error;
2928: --
2929: end if;
2930: --
2931: if ( p_change_reason <> 'WITHDRAWAL'

Line 2949: fnd_message.set_name('PER','IRC_412301_OFR_CANT_BE_CLOSED');

2945: -- Close offer can be called on a closed offer with change
2946: -- reason APL_DECLINED_ACCEPTANCE, MGR_WITHDRAW, APL_HIRED
2947: --
2948: if p_change_reason<>'APL_DECLINED_ACCEPTANCE' and p_change_reason<>'MGR_WITHDRAW' and p_change_reason<>'APL_HIRED' then
2949: fnd_message.set_name('PER','IRC_412301_OFR_CANT_BE_CLOSED');
2950: fnd_message.raise_error;
2951: end if;
2952: end if;
2953: end if;

Line 2950: fnd_message.raise_error;

2946: -- reason APL_DECLINED_ACCEPTANCE, MGR_WITHDRAW, APL_HIRED
2947: --
2948: if p_change_reason<>'APL_DECLINED_ACCEPTANCE' and p_change_reason<>'MGR_WITHDRAW' and p_change_reason<>'APL_HIRED' then
2949: fnd_message.set_name('PER','IRC_412301_OFR_CANT_BE_CLOSED');
2950: fnd_message.raise_error;
2951: end if;
2952: end if;
2953: end if;
2954: --

Line 3046: fnd_message.set_name('PER','IRC_412302_PNDNG_EXTNDD_MODFD');

3042: l_offer_status := 'EXTENDED';
3043: --
3044: else
3045: --
3046: fnd_message.set_name('PER','IRC_412302_PNDNG_EXTNDD_MODFD');
3047: fnd_message.raise_error;
3048: --
3049: end if;
3050: --

Line 3047: fnd_message.raise_error;

3043: --
3044: else
3045: --
3046: fnd_message.set_name('PER','IRC_412302_PNDNG_EXTNDD_MODFD');
3047: fnd_message.raise_error;
3048: --
3049: end if;
3050: --
3051: end if;

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

3261: if csr_offer_status_history_id%notfound
3262: then
3263: --
3264: close csr_offer_status_history_id;
3265: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3266: fnd_message.raise_error;
3267: --
3268: end if;
3269: close csr_offer_status_history_id;

Line 3266: fnd_message.raise_error;

3262: then
3263: --
3264: close csr_offer_status_history_id;
3265: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3266: fnd_message.raise_error;
3267: --
3268: end if;
3269: close csr_offer_status_history_id;
3270: --

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

3463: if csr_prev_offer_rec%notfound
3464: then
3465: --
3466: close csr_prev_offer_rec;
3467: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3468: fnd_message.raise_error;
3469: --
3470: end if;
3471: --

Line 3468: fnd_message.raise_error;

3464: then
3465: --
3466: close csr_prev_offer_rec;
3467: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3468: fnd_message.raise_error;
3469: --
3470: end if;
3471: --
3472: close csr_prev_offer_rec;

Line 3482: fnd_message.set_name('PER','IRC_412303_OFFER_CANT_BE_DLTD');

3478: if ( l_prev_offer_rec.offer_status <> 'SAVED'
3479: AND l_prev_offer_rec.offer_status <> 'CORRECTION'
3480: ) then
3481: --
3482: fnd_message.set_name('PER','IRC_412303_OFFER_CANT_BE_DLTD');
3483: fnd_message.raise_error;
3484: --
3485: end if;
3486: --

Line 3483: fnd_message.raise_error;

3479: AND l_prev_offer_rec.offer_status <> 'CORRECTION'
3480: ) then
3481: --
3482: fnd_message.set_name('PER','IRC_412303_OFFER_CANT_BE_DLTD');
3483: fnd_message.raise_error;
3484: --
3485: end if;
3486: --
3487: -- Truncate the time portion from all IN date parameters

Line 3537: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');

3533: if csr_assignment_ovn%notfound
3534: then
3535: --
3536: close csr_assignment_ovn;
3537: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
3538: fnd_message.raise_error;
3539: --
3540: end if;
3541: close csr_assignment_ovn;

Line 3538: fnd_message.raise_error;

3534: then
3535: --
3536: close csr_assignment_ovn;
3537: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
3538: fnd_message.raise_error;
3539: --
3540: end if;
3541: close csr_assignment_ovn;
3542: --

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

3805: if csr_offer_assignment_2%notfound
3806: then
3807: --
3808: close csr_offer_assignment_2;
3809: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3810: fnd_message.raise_error;
3811: --
3812: end if;
3813: close csr_offer_assignment_2;

Line 3810: fnd_message.raise_error;

3806: then
3807: --
3808: close csr_offer_assignment_2;
3809: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3810: fnd_message.raise_error;
3811: --
3812: end if;
3813: close csr_offer_assignment_2;
3814: -- Store the offer_id

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

3873: if csr_iof_object_version_number%notfound
3874: then
3875: --
3876: close csr_iof_object_version_number;
3877: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3878: fnd_message.raise_error;
3879: --
3880: end if;
3881: --

Line 3878: fnd_message.raise_error;

3874: then
3875: --
3876: close csr_iof_object_version_number;
3877: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3878: fnd_message.raise_error;
3879: --
3880: end if;
3881: --
3882: close csr_iof_object_version_number;

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

4092: if csr_prev_offer_status%notfound
4093: then
4094: --
4095: close csr_prev_offer_status;
4096: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4097: fnd_message.raise_error;
4098: --
4099: end if;
4100: close csr_prev_offer_status;

Line 4097: fnd_message.raise_error;

4093: then
4094: --
4095: close csr_prev_offer_status;
4096: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4097: fnd_message.raise_error;
4098: --
4099: end if;
4100: close csr_prev_offer_status;
4101: --

Line 4105: fnd_message.set_name('PER','IRC_412304_OFFER_NOT_HELD');

4101: --
4102: if l_prev_offer_status <> 'HOLD'
4103: then
4104: --
4105: fnd_message.set_name('PER','IRC_412304_OFFER_NOT_HELD');
4106: fnd_message.raise_error;
4107: --
4108: end if;
4109: --

Line 4106: fnd_message.raise_error;

4102: if l_prev_offer_status <> 'HOLD'
4103: then
4104: --
4105: fnd_message.set_name('PER','IRC_412304_OFFER_NOT_HELD');
4106: fnd_message.raise_error;
4107: --
4108: end if;
4109: --
4110: open csr_prev_to_prev_offer_status;

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

4115: if csr_prev_to_prev_offer_status%notfound
4116: then
4117: --
4118: close csr_prev_to_prev_offer_status;
4119: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
4120: fnd_message.raise_error;
4121: --
4122: end if;
4123: close csr_prev_to_prev_offer_status;

Line 4120: fnd_message.raise_error;

4116: then
4117: --
4118: close csr_prev_to_prev_offer_status;
4119: fnd_message.set_name('PER','IRC_412305_INV_PREVTOPREV_OFR');
4120: fnd_message.raise_error;
4121: --
4122: end if;
4123: close csr_prev_to_prev_offer_status;
4124:

Line 4168: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as

4164: --
4165: if l_other_extended_offer_count > 0
4166: then
4167: --
4168: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
4169: -- an active offer exists for this application
4170: fnd_message.raise_error;
4171: --
4172: end if;

Line 4170: fnd_message.raise_error;

4166: then
4167: --
4168: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
4169: -- an active offer exists for this application
4170: fnd_message.raise_error;
4171: --
4172: end if;
4173: --
4174: end if;

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

4816: --
4817: hr_utility.set_location(l_proc, 20);
4818: --
4819: close csr_prev_offer_details;
4820: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4821: fnd_message.raise_error;
4822: --
4823: end if;
4824: close csr_prev_offer_details;

Line 4821: fnd_message.raise_error;

4817: hr_utility.set_location(l_proc, 20);
4818: --
4819: close csr_prev_offer_details;
4820: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4821: fnd_message.raise_error;
4822: --
4823: end if;
4824: close csr_prev_offer_details;
4825: --

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

4829: if csr_asg_effective_start_date%notfound
4830: then
4831: --
4832: close csr_asg_effective_start_date;
4833: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
4834: fnd_message.raise_error;
4835: --
4836: end if;
4837: close csr_asg_effective_start_date;

Line 4834: fnd_message.raise_error;

4830: then
4831: --
4832: close csr_asg_effective_start_date;
4833: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
4834: fnd_message.raise_error;
4835: --
4836: end if;
4837: close csr_asg_effective_start_date;
4838: --

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

4856: then
4857: --
4858: hr_utility.set_location(l_proc, 25);
4859: --
4860: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
4861: fnd_message.raise_error;
4862: --
4863: elsif l_prev_offer_status in ('EXTENDED','APPROVED','CLOSED')
4864: OR p_offer_status in ('EXTENDED','APPROVED','CLOSED')

Line 4861: fnd_message.raise_error;

4857: --
4858: hr_utility.set_location(l_proc, 25);
4859: --
4860: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
4861: fnd_message.raise_error;
4862: --
4863: elsif l_prev_offer_status in ('EXTENDED','APPROVED','CLOSED')
4864: OR p_offer_status in ('EXTENDED','APPROVED','CLOSED')
4865: then

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

4903: --
4904: hr_utility.set_location(l_proc, 50);
4905: --
4906: close csr_offer_record;
4907: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4908: fnd_message.raise_error;
4909: --
4910: end if;
4911: close csr_offer_record;

Line 4908: fnd_message.raise_error;

4904: hr_utility.set_location(l_proc, 50);
4905: --
4906: close csr_offer_record;
4907: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4908: fnd_message.raise_error;
4909: --
4910: end if;
4911: close csr_offer_record;
4912: --

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

5227: --
5228: hr_utility.set_location(l_proc, 20);
5229: --
5230: close csr_offer_id;
5231: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
5232: fnd_message.raise_error;
5233: --
5234: end if;
5235: close csr_offer_id;

Line 5232: fnd_message.raise_error;

5228: hr_utility.set_location(l_proc, 20);
5229: --
5230: close csr_offer_id;
5231: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
5232: fnd_message.raise_error;
5233: --
5234: end if;
5235: close csr_offer_id;
5236: --