38: hr_utility.set_location(' Leaving:'|| l_proc, 20);
39: --
40: exception
41: when no_data_found then
42: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
43: fnd_message.raise_error;
44: end get_business_group_id;
45:
46:
39: --
40: exception
41: when no_data_found then
42: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
43: fnd_message.raise_error;
44: end get_business_group_id;
45:
46:
47: --
91: (p_effective_date => p_effective_date
92: ,p_lookup_type => 'YES_NO'
93: ,p_lookup_code => p_flag
94: ) THEN
95: fnd_message.set_name('801','HR_52970_COL_Y_OR_N');
96: fnd_message.set_token('COLUMN',p_flag_name);
97: fnd_message.raise_error;
98: end if;
99: --
92: ,p_lookup_type => 'YES_NO'
93: ,p_lookup_code => p_flag
94: ) THEN
95: fnd_message.set_name('801','HR_52970_COL_Y_OR_N');
96: fnd_message.set_token('COLUMN',p_flag_name);
97: fnd_message.raise_error;
98: end if;
99: --
100: hr_utility.set_location('Leaving:'||l_proc, 30);
93: ,p_lookup_code => p_flag
94: ) THEN
95: fnd_message.set_name('801','HR_52970_COL_Y_OR_N');
96: fnd_message.set_token('COLUMN',p_flag_name);
97: fnd_message.raise_error;
98: end if;
99: --
100: hr_utility.set_location('Leaving:'||l_proc, 30);
101: --
363: close csr_sec_grp;
364: --
365: -- The primary key is invalid therefore we must error
366: --
367: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
368: fnd_message.raise_error;
369: --
370: end if;
371: close csr_sec_grp;
364: --
365: -- The primary key is invalid therefore we must error
366: --
367: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
368: fnd_message.raise_error;
369: --
370: end if;
371: close csr_sec_grp;
372: --
436: --
437: -- The primary key is invalid therefore we must error
438: --
439: close csr_leg_code;
440: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
441: fnd_message.raise_error;
442: end if;
443: hr_utility.set_location(l_proc,30);
444: --
437: -- The primary key is invalid therefore we must error
438: --
439: close csr_leg_code;
440: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
441: fnd_message.raise_error;
442: end if;
443: hr_utility.set_location(l_proc,30);
444: --
445: -- Set the global variables so the values are
497: IF NOT per_osv_shd.api_updating
498: (p_org_structure_version_id => p_rec.org_structure_version_id
499: ,p_object_version_number => p_rec.object_version_number
500: ) THEN
501: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
502: fnd_message.set_token('PROCEDURE ', l_proc);
503: fnd_message.set_token('STEP ', '5');
504: fnd_message.raise_error;
505: END IF;
498: (p_org_structure_version_id => p_rec.org_structure_version_id
499: ,p_object_version_number => p_rec.object_version_number
500: ) THEN
501: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
502: fnd_message.set_token('PROCEDURE ', l_proc);
503: fnd_message.set_token('STEP ', '5');
504: fnd_message.raise_error;
505: END IF;
506: --
499: ,p_object_version_number => p_rec.object_version_number
500: ) THEN
501: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
502: fnd_message.set_token('PROCEDURE ', l_proc);
503: fnd_message.set_token('STEP ', '5');
504: fnd_message.raise_error;
505: END IF;
506: --
507: -- EDIT_HERE: Add checks to ensure non-updateable args have
500: ) THEN
501: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
502: fnd_message.set_token('PROCEDURE ', l_proc);
503: fnd_message.set_token('STEP ', '5');
504: fnd_message.raise_error;
505: END IF;
506: --
507: -- EDIT_HERE: Add checks to ensure non-updateable args have
508: -- not been updated.