57: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: fnd_message.raise_error;
63: --
64: end if;
65: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: fnd_message.raise_error;
63: --
64: end if;
65: close csr_sec_grp;
66: --
130: --
131: -- The primary key is invalid therefore we must error
132: --
133: close csr_leg_code;
134: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
135: fnd_message.raise_error;
136: end if;
137: hr_utility.set_location(l_proc,30);
138: --
131: -- The primary key is invalid therefore we must error
132: --
133: close csr_leg_code;
134: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
135: fnd_message.raise_error;
136: end if;
137: hr_utility.set_location(l_proc,30);
138: --
139: -- Set the global variables so the values are
190: --
191: if not per_chk_shd.api_updating
192: (p_checklist_item_id => p_rec.checklist_item_id,
193: p_object_version_number => p_rec.object_version_number) then
194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE', l_proc);
196: fnd_message.set_token('STEP', '5');
197: end if;
198: --
191: if not per_chk_shd.api_updating
192: (p_checklist_item_id => p_rec.checklist_item_id,
193: p_object_version_number => p_rec.object_version_number) then
194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE', l_proc);
196: fnd_message.set_token('STEP', '5');
197: end if;
198: --
199: hr_utility.set_location(l_proc, 6);
192: (p_checklist_item_id => p_rec.checklist_item_id,
193: p_object_version_number => p_rec.object_version_number) then
194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE', l_proc);
196: fnd_message.set_token('STEP', '5');
197: end if;
198: --
199: hr_utility.set_location(l_proc, 6);
200: --
275: FETCH chk_valid_person into l_person_id;
276: IF chk_valid_person%NOTFOUND THEN
277: CLOSE chk_valid_person;
278: -- Error Message : Invalid person id
279: fnd_message.set_name('PER', 'HR_52783_CHK_INVALID_PER');
280: fnd_message.raise_error;
281: END IF;
282:
283: CLOSE chk_valid_person;
276: IF chk_valid_person%NOTFOUND THEN
277: CLOSE chk_valid_person;
278: -- Error Message : Invalid person id
279: fnd_message.set_name('PER', 'HR_52783_CHK_INVALID_PER');
280: fnd_message.raise_error;
281: END IF;
282:
283: CLOSE chk_valid_person;
284:
327: IF hr_api.not_exists_in_hr_lookups( p_effective_date => p_effective_date,
328: p_lookup_type => 'CHECKLIST_STATUS',
329: p_lookup_code => p_status ) THEN
330: -- Error Message : Invalid checklist status
331: fnd_message.set_name('PER', 'HR_52781_CHK_INVALID_STATUS');
332: fnd_message.raise_error;
333: END IF;
334:
335: end if;
328: p_lookup_type => 'CHECKLIST_STATUS',
329: p_lookup_code => p_status ) THEN
330: -- Error Message : Invalid checklist status
331: fnd_message.set_name('PER', 'HR_52781_CHK_INVALID_STATUS');
332: fnd_message.raise_error;
333: END IF;
334:
335: end if;
336: --
377: IF hr_api.not_exists_in_hr_lookups( p_effective_date => p_effective_date,
378: p_lookup_type => 'CHECKLIST_ITEM',
379: p_lookup_code => p_item_code ) THEN
380: -- Error Message - Invalid Checklist value
381: fnd_message.set_name('PER', 'HR_52778_CHK_INVALID_ITEM');
382: fnd_message.raise_error;
383: END IF;
384:
385:
378: p_lookup_type => 'CHECKLIST_ITEM',
379: p_lookup_code => p_item_code ) THEN
380: -- Error Message - Invalid Checklist value
381: fnd_message.set_name('PER', 'HR_52778_CHK_INVALID_ITEM');
382: fnd_message.raise_error;
383: END IF;
384:
385:
386: -- Checking to see it the item code entered is unique for that
469: (p_rec.attribute28 is null) and
470: (p_rec.attribute29 is null) and
471: (p_rec.attribute30 is null) ) )
472: then
473: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
474: fnd_message.set_token('PROCEDURE','chk_df');
475: fnd_message.set_token('STEP',1);
476: fnd_message.raise_error;
477: End if;
470: (p_rec.attribute29 is null) and
471: (p_rec.attribute30 is null) ) )
472: then
473: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
474: fnd_message.set_token('PROCEDURE','chk_df');
475: fnd_message.set_token('STEP',1);
476: fnd_message.raise_error;
477: End if;
478: End if;
471: (p_rec.attribute30 is null) ) )
472: then
473: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
474: fnd_message.set_token('PROCEDURE','chk_df');
475: fnd_message.set_token('STEP',1);
476: fnd_message.raise_error;
477: End if;
478: End if;
479: --
472: then
473: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
474: fnd_message.set_token('PROCEDURE','chk_df');
475: fnd_message.set_token('STEP',1);
476: fnd_message.raise_error;
477: End if;
478: End if;
479: --
480: --