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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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:
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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: --
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
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: --
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'
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;
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: --
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: --
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;
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;
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: --
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: --
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;
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: --
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
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;
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: --
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;
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
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: --
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;
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;
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: --
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: --
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;
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;
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:
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;
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;
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;
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: --
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;
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: --
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')
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
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;
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: --
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;
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: --