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