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

417: --
418: hr_utility.set_location(l_proc,70);
419: --
420: --
421: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
422: fnd_message.raise_error;
423: --
424: end if;
425: close csr_assignment_ovn;

Line 422: fnd_message.raise_error;

418: hr_utility.set_location(l_proc,70);
419: --
420: --
421: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
422: fnd_message.raise_error;
423: --
424: end if;
425: close csr_assignment_ovn;
426: --

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

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

Line 453: fnd_message.raise_error;

449: --
450: hr_utility.set_location(l_proc,40);
451: --
452: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
453: fnd_message.raise_error;
454: --
455: end if;
456: close csr_prev_assg_status_type;
457: --

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

499: close csr_prev_assg_status_type;
500: --
501: hr_utility.set_location(l_proc,40);
502: --
503: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
504: fnd_message.raise_error;
505: --
506: end if;
507: close csr_prev_assg_status_type;

Line 504: fnd_message.raise_error;

500: --
501: hr_utility.set_location(l_proc,40);
502: --
503: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
504: fnd_message.raise_error;
505: --
506: end if;
507: close csr_prev_assg_status_type;
508: --

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

626: if csr_offer_details%notfound
627: then
628: --
629: close csr_offer_details;
630: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
631: fnd_message.raise_error;
632: --
633: end if;
634: close csr_offer_details;

Line 631: fnd_message.raise_error;

627: then
628: --
629: close csr_offer_details;
630: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
631: fnd_message.raise_error;
632: --
633: end if;
634: close csr_offer_details;
635: --

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

685: --
686: hr_utility.set_location(l_proc, 65);
687: --
688: close csr_assignment_ovn;
689: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
690: fnd_message.raise_error;
691: --
692: end if;
693: close csr_assignment_ovn;

Line 690: fnd_message.raise_error;

686: hr_utility.set_location(l_proc, 65);
687: --
688: close csr_assignment_ovn;
689: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
690: fnd_message.raise_error;
691: --
692: end if;
693: close csr_assignment_ovn;
694: --

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

901: if csr_assignment_ids%notfound
902: then
903: --
904: close csr_assignment_ids;
905: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
906: fnd_message.raise_error;
907: --
908: end if;
909: close csr_assignment_ids;

Line 906: fnd_message.raise_error;

902: then
903: --
904: close csr_assignment_ids;
905: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
906: fnd_message.raise_error;
907: --
908: end if;
909: close csr_assignment_ids;
910: --

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

914: if csr_assignment_record%notfound
915: then
916: --
917: close csr_assignment_record;
918: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
919: fnd_message.raise_error;
920: --
921: end if;
922: close csr_assignment_record;

Line 919: fnd_message.raise_error;

915: then
916: --
917: close csr_assignment_record;
918: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
919: fnd_message.raise_error;
920: --
921: end if;
922: close csr_assignment_record;
923: --

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

937: if csr_appl_asg_effective_date%notfound
938: then
939: --
940: close csr_appl_asg_effective_date;
941: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
942: fnd_message.raise_error;
943: --
944: end if;
945: close csr_appl_asg_effective_date;

Line 942: fnd_message.raise_error;

938: then
939: --
940: close csr_appl_asg_effective_date;
941: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
942: fnd_message.raise_error;
943: --
944: end if;
945: close csr_appl_asg_effective_date;
946: --

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

1220: if csr_assignment_ids%notfound
1221: then
1222: --
1223: close csr_assignment_ids;
1224: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
1225: fnd_message.raise_error;
1226: --
1227: end if;
1228: close csr_assignment_ids;

Line 1225: fnd_message.raise_error;

1221: then
1222: --
1223: close csr_assignment_ids;
1224: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
1225: fnd_message.raise_error;
1226: --
1227: end if;
1228: close csr_assignment_ids;
1229:

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

1408: then
1409: --
1410: close csr_person_id;
1411: --
1412: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
1413: fnd_message.raise_error;
1414: --
1415: end if;
1416: close csr_person_id;

Line 1413: fnd_message.raise_error;

1409: --
1410: close csr_person_id;
1411: --
1412: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
1413: fnd_message.raise_error;
1414: --
1415: end if;
1416: close csr_person_id;
1417: --

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

2166: if csr_prev_offer_details%notfound
2167: then
2168: --
2169: close csr_prev_offer_details;
2170: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2171: fnd_message.raise_error;
2172: --
2173: end if;
2174: close csr_prev_offer_details;

Line 2171: fnd_message.raise_error;

2167: then
2168: --
2169: close csr_prev_offer_details;
2170: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2171: fnd_message.raise_error;
2172: --
2173: end if;
2174: close csr_prev_offer_details;
2175: --

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

2186: if csr_assignment_record%notfound
2187: then
2188: --
2189: close csr_assignment_record;
2190: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
2191: fnd_message.raise_error;
2192: --
2193: end if;
2194: close csr_assignment_record;

Line 2191: fnd_message.raise_error;

2187: then
2188: --
2189: close csr_assignment_record;
2190: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
2191: fnd_message.raise_error;
2192: --
2193: end if;
2194: close csr_assignment_record;
2195: --

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

2362: --
2363: hr_utility.set_location(l_proc, 75);
2364: --
2365: close csr_offer_record;
2366: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2367: fnd_message.raise_error;
2368: --
2369: end if;
2370: close csr_offer_record;

Line 2367: fnd_message.raise_error;

2363: hr_utility.set_location(l_proc, 75);
2364: --
2365: close csr_offer_record;
2366: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2367: fnd_message.raise_error;
2368: --
2369: end if;
2370: close csr_offer_record;
2371: --

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

2718: --
2719: -- This happens when an offer is being EXTENDED. Throw an error refusing to
2720: -- EXTEND another offer to the candidate
2721: --
2722: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
2723: -- an active offer exists for this application
2724: fnd_message.raise_error;
2725: --
2726: end if;

Line 2724: fnd_message.raise_error;

2720: -- EXTEND another offer to the candidate
2721: --
2722: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
2723: -- an active offer exists for this application
2724: fnd_message.raise_error;
2725: --
2726: end if;
2727: end if;
2728: --

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

2758: --
2759: if p_change_reason is null
2760: then
2761: --
2762: fnd_message.set_name('PER','IRC_412299_CLOSE_REASON_MNDTRY');
2763: fnd_message.raise_error;
2764: --
2765: end if;
2766: --

Line 2763: fnd_message.raise_error;

2759: if p_change_reason is null
2760: then
2761: --
2762: fnd_message.set_name('PER','IRC_412299_CLOSE_REASON_MNDTRY');
2763: fnd_message.raise_error;
2764: --
2765: end if;
2766: --
2767: -- Check if the change_reason is 'WITHDRAWAL'. If yes, close

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

2781: then
2782: --
2783: hr_utility.set_location(l_proc,105);
2784: --
2785: fnd_message.set_name('PER','IRC_412300_OFFER_NOT_EXTENDED');
2786: fnd_message.raise_error;
2787: --
2788: end if;
2789: --

Line 2786: fnd_message.raise_error;

2782: --
2783: hr_utility.set_location(l_proc,105);
2784: --
2785: fnd_message.set_name('PER','IRC_412300_OFFER_NOT_EXTENDED');
2786: fnd_message.raise_error;
2787: --
2788: end if;
2789: --
2790: if ( p_change_reason <> 'WITHDRAWAL'

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

2804: -- Close offer can be called on a closed offer with change
2805: -- reason APL_DECLINED_ACCEPTANCE, MGR_WITHDRAW, APL_HIRED
2806: --
2807: if p_change_reason<>'APL_DECLINED_ACCEPTANCE' and p_change_reason<>'MGR_WITHDRAW' and p_change_reason<>'APL_HIRED' then
2808: fnd_message.set_name('PER','IRC_412301_OFR_CANT_BE_CLOSED');
2809: fnd_message.raise_error;
2810: end if;
2811: end if;
2812: end if;

Line 2809: fnd_message.raise_error;

2805: -- reason APL_DECLINED_ACCEPTANCE, MGR_WITHDRAW, APL_HIRED
2806: --
2807: if p_change_reason<>'APL_DECLINED_ACCEPTANCE' and p_change_reason<>'MGR_WITHDRAW' and p_change_reason<>'APL_HIRED' then
2808: fnd_message.set_name('PER','IRC_412301_OFR_CANT_BE_CLOSED');
2809: fnd_message.raise_error;
2810: end if;
2811: end if;
2812: end if;
2813: --

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

2901: l_offer_status := 'EXTENDED';
2902: --
2903: else
2904: --
2905: fnd_message.set_name('PER','IRC_412302_PNDNG_EXTNDD_MODFD');
2906: fnd_message.raise_error;
2907: --
2908: end if;
2909: --

Line 2906: fnd_message.raise_error;

2902: --
2903: else
2904: --
2905: fnd_message.set_name('PER','IRC_412302_PNDNG_EXTNDD_MODFD');
2906: fnd_message.raise_error;
2907: --
2908: end if;
2909: --
2910: end if;

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

3110: if csr_offer_status_history_id%notfound
3111: then
3112: --
3113: close csr_offer_status_history_id;
3114: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3115: fnd_message.raise_error;
3116: --
3117: end if;
3118: close csr_offer_status_history_id;

Line 3115: fnd_message.raise_error;

3111: then
3112: --
3113: close csr_offer_status_history_id;
3114: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3115: fnd_message.raise_error;
3116: --
3117: end if;
3118: close csr_offer_status_history_id;
3119: --

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

3312: if csr_prev_offer_rec%notfound
3313: then
3314: --
3315: close csr_prev_offer_rec;
3316: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3317: fnd_message.raise_error;
3318: --
3319: end if;
3320: --

Line 3317: fnd_message.raise_error;

3313: then
3314: --
3315: close csr_prev_offer_rec;
3316: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3317: fnd_message.raise_error;
3318: --
3319: end if;
3320: --
3321: close csr_prev_offer_rec;

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

3327: if ( l_prev_offer_rec.offer_status <> 'SAVED'
3328: AND l_prev_offer_rec.offer_status <> 'CORRECTION'
3329: ) then
3330: --
3331: fnd_message.set_name('PER','IRC_412303_OFFER_CANT_BE_DLTD');
3332: fnd_message.raise_error;
3333: --
3334: end if;
3335: --

Line 3332: fnd_message.raise_error;

3328: AND l_prev_offer_rec.offer_status <> 'CORRECTION'
3329: ) then
3330: --
3331: fnd_message.set_name('PER','IRC_412303_OFFER_CANT_BE_DLTD');
3332: fnd_message.raise_error;
3333: --
3334: end if;
3335: --
3336: -- Truncate the time portion from all IN date parameters

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

3382: if csr_assignment_ovn%notfound
3383: then
3384: --
3385: close csr_assignment_ovn;
3386: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
3387: fnd_message.raise_error;
3388: --
3389: end if;
3390: close csr_assignment_ovn;

Line 3387: fnd_message.raise_error;

3383: then
3384: --
3385: close csr_assignment_ovn;
3386: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
3387: fnd_message.raise_error;
3388: --
3389: end if;
3390: close csr_assignment_ovn;
3391: --

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

3576: if csr_offer_assignment_2%notfound
3577: then
3578: --
3579: close csr_offer_assignment_2;
3580: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3581: fnd_message.raise_error;
3582: --
3583: end if;
3584: close csr_offer_assignment_2;

Line 3581: fnd_message.raise_error;

3577: then
3578: --
3579: close csr_offer_assignment_2;
3580: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3581: fnd_message.raise_error;
3582: --
3583: end if;
3584: close csr_offer_assignment_2;
3585: -- Store the offer_id

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

3644: if csr_iof_object_version_number%notfound
3645: then
3646: --
3647: close csr_iof_object_version_number;
3648: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3649: fnd_message.raise_error;
3650: --
3651: end if;
3652: --

Line 3649: fnd_message.raise_error;

3645: then
3646: --
3647: close csr_iof_object_version_number;
3648: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3649: fnd_message.raise_error;
3650: --
3651: end if;
3652: --
3653: close csr_iof_object_version_number;

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

3850: if csr_prev_offer_status%notfound
3851: then
3852: --
3853: close csr_prev_offer_status;
3854: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3855: fnd_message.raise_error;
3856: --
3857: end if;
3858: close csr_prev_offer_status;

Line 3855: fnd_message.raise_error;

3851: then
3852: --
3853: close csr_prev_offer_status;
3854: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
3855: fnd_message.raise_error;
3856: --
3857: end if;
3858: close csr_prev_offer_status;
3859: --

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

3859: --
3860: if l_prev_offer_status <> 'HOLD'
3861: then
3862: --
3863: fnd_message.set_name('PER','IRC_412304_OFFER_NOT_HELD');
3864: fnd_message.raise_error;
3865: --
3866: end if;
3867: --

Line 3864: fnd_message.raise_error;

3860: if l_prev_offer_status <> 'HOLD'
3861: then
3862: --
3863: fnd_message.set_name('PER','IRC_412304_OFFER_NOT_HELD');
3864: fnd_message.raise_error;
3865: --
3866: end if;
3867: --
3868: open csr_prev_to_prev_offer_status;

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

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

Line 3878: fnd_message.raise_error;

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

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

3921: --
3922: if l_other_extended_offer_count > 0
3923: then
3924: --
3925: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
3926: -- an active offer exists for this application
3927: fnd_message.raise_error;
3928: --
3929: end if;

Line 3927: fnd_message.raise_error;

3923: then
3924: --
3925: fnd_message.set_name('PER','IRC_412377_MULTIPLE_OFFER_SEND'); -- You cannot send another offer to this applicant as
3926: -- an active offer exists for this application
3927: fnd_message.raise_error;
3928: --
3929: end if;
3930: --
3931: end if;

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

4573: --
4574: hr_utility.set_location(l_proc, 20);
4575: --
4576: close csr_prev_offer_details;
4577: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4578: fnd_message.raise_error;
4579: --
4580: end if;
4581: close csr_prev_offer_details;

Line 4578: fnd_message.raise_error;

4574: hr_utility.set_location(l_proc, 20);
4575: --
4576: close csr_prev_offer_details;
4577: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4578: fnd_message.raise_error;
4579: --
4580: end if;
4581: close csr_prev_offer_details;
4582: --

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

4586: if csr_asg_effective_start_date%notfound
4587: then
4588: --
4589: close csr_asg_effective_start_date;
4590: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
4591: fnd_message.raise_error;
4592: --
4593: end if;
4594: close csr_asg_effective_start_date;

Line 4591: fnd_message.raise_error;

4587: then
4588: --
4589: close csr_asg_effective_start_date;
4590: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
4591: fnd_message.raise_error;
4592: --
4593: end if;
4594: close csr_asg_effective_start_date;
4595: --

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

4613: then
4614: --
4615: hr_utility.set_location(l_proc, 25);
4616: --
4617: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
4618: fnd_message.raise_error;
4619: --
4620: elsif l_prev_offer_status in ('EXTENDED','APPROVED','CLOSED')
4621: OR p_offer_status in ('EXTENDED','APPROVED','CLOSED')

Line 4618: fnd_message.raise_error;

4614: --
4615: hr_utility.set_location(l_proc, 25);
4616: --
4617: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
4618: fnd_message.raise_error;
4619: --
4620: elsif l_prev_offer_status in ('EXTENDED','APPROVED','CLOSED')
4621: OR p_offer_status in ('EXTENDED','APPROVED','CLOSED')
4622: then

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

4660: --
4661: hr_utility.set_location(l_proc, 50);
4662: --
4663: close csr_offer_record;
4664: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4665: fnd_message.raise_error;
4666: --
4667: end if;
4668: close csr_offer_record;

Line 4665: fnd_message.raise_error;

4661: hr_utility.set_location(l_proc, 50);
4662: --
4663: close csr_offer_record;
4664: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4665: fnd_message.raise_error;
4666: --
4667: end if;
4668: close csr_offer_record;
4669: --

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

4984: --
4985: hr_utility.set_location(l_proc, 20);
4986: --
4987: close csr_offer_id;
4988: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4989: fnd_message.raise_error;
4990: --
4991: end if;
4992: close csr_offer_id;

Line 4989: fnd_message.raise_error;

4985: hr_utility.set_location(l_proc, 20);
4986: --
4987: close csr_offer_id;
4988: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4989: fnd_message.raise_error;
4990: --
4991: end if;
4992: close csr_offer_id;
4993: --