82: p_s_pay_bas;
83: --
84: if get_assgt%notfound then
85: close get_assgt;
86: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
87: fnd_message.set_token('PROCEDURE',
88: 'PER_ASSIGNMENTS_F2_PKG.GET_SAVE_FIELDS');
89: fnd_message.set_token('STEP', '1');
90: fnd_message.raise_error;
83: --
84: if get_assgt%notfound then
85: close get_assgt;
86: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
87: fnd_message.set_token('PROCEDURE',
88: 'PER_ASSIGNMENTS_F2_PKG.GET_SAVE_FIELDS');
89: fnd_message.set_token('STEP', '1');
90: fnd_message.raise_error;
91: end if;
85: close get_assgt;
86: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
87: fnd_message.set_token('PROCEDURE',
88: 'PER_ASSIGNMENTS_F2_PKG.GET_SAVE_FIELDS');
89: fnd_message.set_token('STEP', '1');
90: fnd_message.raise_error;
91: end if;
92: --
93: close get_assgt;
86: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
87: fnd_message.set_token('PROCEDURE',
88: 'PER_ASSIGNMENTS_F2_PKG.GET_SAVE_FIELDS');
89: fnd_message.set_token('STEP', '1');
90: fnd_message.raise_error;
91: end if;
92: --
93: close get_assgt;
94: --
147: open curr_emp;
148: fetch curr_emp into l_null;
149: if curr_emp%notfound then
150: close curr_emp;
151: fnd_message.set_name('PAY', 'HR_6254_EMP_ASS_EMP_ENDED');
152: fnd_message.raise_error;
153: end if;
154: close curr_emp;
155: --
148: fetch curr_emp into l_null;
149: if curr_emp%notfound then
150: close curr_emp;
151: fnd_message.set_name('PAY', 'HR_6254_EMP_ASS_EMP_ENDED');
152: fnd_message.raise_error;
153: end if;
154: close curr_emp;
155: --
156: -- CHECK VALID STATUS:
164: open asg_type;
165: fetch asg_type into l_null;
166: if asg_type%notfound then
167: close asg_type;
168: fnd_message.set_name('PAY',
169: 'HR_6073_APP_ASS_INVALID_STATUS');
170: fnd_message.raise_error;
171: end if;
172: close asg_type;
166: if asg_type%notfound then
167: close asg_type;
168: fnd_message.set_name('PAY',
169: 'HR_6073_APP_ASS_INVALID_STATUS');
170: fnd_message.raise_error;
171: end if;
172: close asg_type;
173: end if;
174: --
416: P_DEF_USER_ST,
417: P_DEF_ST_ID;
418: if def_assgt_status%notfound then
419: close def_assgt_status;
420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
421: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F2_PKG.INITIATE_ASSIGNMENT');
422: fnd_message.set_token('STEP', '1');
423: fnd_message.raise_error;
424: end if;
417: P_DEF_ST_ID;
418: if def_assgt_status%notfound then
419: close def_assgt_status;
420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
421: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F2_PKG.INITIATE_ASSIGNMENT');
422: fnd_message.set_token('STEP', '1');
423: fnd_message.raise_error;
424: end if;
425: close def_assgt_status;
418: if def_assgt_status%notfound then
419: close def_assgt_status;
420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
421: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F2_PKG.INITIATE_ASSIGNMENT');
422: fnd_message.set_token('STEP', '1');
423: fnd_message.raise_error;
424: end if;
425: close def_assgt_status;
426: --
419: close def_assgt_status;
420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
421: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F2_PKG.INITIATE_ASSIGNMENT');
422: fnd_message.set_token('STEP', '1');
423: fnd_message.raise_error;
424: end if;
425: close def_assgt_status;
426: --
427: hr_utility.set_location('per_assignments_f2_pkg.initiate_assignment',30);
447: open get_pd_of_ser;
448: fetch get_pd_of_ser into l_dummy_dt, P_PERIOD_OF_SERVICE_ID;
449: if get_pd_of_ser%notfound then
450: close get_pd_of_ser;
451: fnd_message.set_name('PAY', 'HR_6346_EMP_ASS_NO_POS');
452: fnd_message.raise_error;
453: end if;
454: close get_pd_of_ser;
455: end if;
448: fetch get_pd_of_ser into l_dummy_dt, P_PERIOD_OF_SERVICE_ID;
449: if get_pd_of_ser%notfound then
450: close get_pd_of_ser;
451: fnd_message.set_name('PAY', 'HR_6346_EMP_ASS_NO_POS');
452: fnd_message.raise_error;
453: end if;
454: close get_pd_of_ser;
455: end if;
456: --
663: fetch chk_ass into l_null;
664: if chk_ass%notfound then
665: close chk_ass;
666: close pd_os;
667: fnd_message.set_name('PAY',
668: 'HR_6435_EMP_ASS_DEL_FIRST');
669: fnd_message.raise_error;
670: end if;
671: close chk_ass;
665: close chk_ass;
666: close pd_os;
667: fnd_message.set_name('PAY',
668: 'HR_6435_EMP_ASS_DEL_FIRST');
669: fnd_message.raise_error;
670: end if;
671: close chk_ass;
672: end if;
673: close pd_os;
947: if (p_org_id <> p_s_org_id) and (p_pos_id is not null) then
948: open consistent_org;
949: fetch consistent_org into l_dummy;
950: if consistent_org%notfound then
951: fnd_message.set_name('PAY',
952: 'HR_6102_EMP_ASS_ORGANIZATION');
953: close consistent_org;
954: fnd_message.raise_error;
955: end if;
950: if consistent_org%notfound then
951: fnd_message.set_name('PAY',
952: 'HR_6102_EMP_ASS_ORGANIZATION');
953: close consistent_org;
954: fnd_message.raise_error;
955: end if;
956: close consistent_org;
957: end if;
958: --
967: ,'ACTIVE_CWK') then
968: open first_assgt;
969: fetch first_assgt into l_dummy;
970: if first_assgt%notfound then
971: fnd_message.set_name('PAY',
972: 'HR_7139_EMP_ASS_FIRST_EMP_ASS');
973: close first_assgt;
974: fnd_message.raise_error;
975: end if;
970: if first_assgt%notfound then
971: fnd_message.set_name('PAY',
972: 'HR_7139_EMP_ASS_FIRST_EMP_ASS');
973: close first_assgt;
974: fnd_message.raise_error;
975: end if;
976: close first_assgt;
977: end if;
978: --