31: (p_effective_date => p_effective_date
32: ,p_lookup_type => 'YES_NO'
33: ,p_lookup_code => p_flag
34: ) THEN
35: fnd_message.set_name('801','HR_52970_COL_Y_OR_N');
36: fnd_message.set_token('COLUMN',p_flag_name);
37: fnd_message.raise_error;
38: end if;
39: --
32: ,p_lookup_type => 'YES_NO'
33: ,p_lookup_code => p_flag
34: ) THEN
35: fnd_message.set_name('801','HR_52970_COL_Y_OR_N');
36: fnd_message.set_token('COLUMN',p_flag_name);
37: fnd_message.raise_error;
38: end if;
39: --
40: hr_utility.set_location('Leaving:'||l_proc, 30);
33: ,p_lookup_code => p_flag
34: ) THEN
35: fnd_message.set_name('801','HR_52970_COL_Y_OR_N');
36: fnd_message.set_token('COLUMN',p_flag_name);
37: fnd_message.raise_error;
38: end if;
39: --
40: hr_utility.set_location('Leaving:'||l_proc, 30);
41: --
257: close csr_sec_grp;
258: --
259: -- The primary key is invalid therefore we must error
260: --
261: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
262: fnd_message.raise_error;
263: --
264: end if;
265: close csr_sec_grp;
258: --
259: -- The primary key is invalid therefore we must error
260: --
261: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
262: fnd_message.raise_error;
263: --
264: end if;
265: close csr_sec_grp;
266: --
330: --
331: -- The primary key is invalid therefore we must error
332: --
333: close csr_leg_code;
334: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
335: fnd_message.raise_error;
336: end if;
337: hr_utility.set_location(l_proc,30);
338: --
331: -- The primary key is invalid therefore we must error
332: --
333: close csr_leg_code;
334: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
335: fnd_message.raise_error;
336: end if;
337: hr_utility.set_location(l_proc,30);
338: --
339: -- Set the global variables so the values are
528: IF NOT per_pst_shd.api_updating
529: (p_position_structure_id => p_rec.position_structure_id
530: ,p_object_version_number => p_rec.object_version_number
531: ) THEN
532: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE ', l_proc);
534: fnd_message.set_token('STEP ', '5');
535: fnd_message.raise_error;
536: END IF;
529: (p_position_structure_id => p_rec.position_structure_id
530: ,p_object_version_number => p_rec.object_version_number
531: ) THEN
532: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE ', l_proc);
534: fnd_message.set_token('STEP ', '5');
535: fnd_message.raise_error;
536: END IF;
537: EXCEPTION
530: ,p_object_version_number => p_rec.object_version_number
531: ) THEN
532: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE ', l_proc);
534: fnd_message.set_token('STEP ', '5');
535: fnd_message.raise_error;
536: END IF;
537: EXCEPTION
538: WHEN l_error THEN
531: ) THEN
532: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE ', l_proc);
534: fnd_message.set_token('STEP ', '5');
535: fnd_message.raise_error;
536: END IF;
537: EXCEPTION
538: WHEN l_error THEN
539: hr_api.argument_changed_error