40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pay_pwa_shd.api_updating
47: (p_account_id => p_account_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_account_id;
75: --
76: -- ----------------------------------------------------------------------------
80: --
81: l_proc varchar2(72) := g_package||'insert_validate';
82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: --
86: -- Call all supporting business operations
87: --
88: chk_account_id
90: p_object_version_number => p_rec.object_version_number);
91: --
92: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: End insert_validate;
96: --
97: -- ----------------------------------------------------------------------------
98: -- |---------------------------< update_validate >----------------------------|
101: --
102: l_proc varchar2(72) := g_package||'update_validate';
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Call all supporting business operations
108: --
109: chk_account_id
111: p_object_version_number => p_rec.object_version_number);
112: --
113: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End update_validate;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |---------------------------< delete_validate >----------------------------|
122: --
123: l_proc varchar2(72) := g_package||'delete_validate';
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: -- Call all supporting business operations
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: -- Call all supporting business operations
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: End delete_validate;
132: --
133: --
134: -- ---------------------------------------------------------------------------
153: l_proc varchar2(72) := g_package||'return_legislation_code';
154: --
155: begin
156: --
157: hr_utility.set_location('Entering:'|| l_proc, 10);
158: --
159: -- Ensure that all the mandatory parameter are not null
160: --
161: hr_api.mandatory_arg_error(p_api_name => l_proc,
171: close csr_leg_code;
172: --
173: -- The primary key is invalid therefore we must error
174: --
175: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
176: hr_utility.raise_error;
177: --
178: end if;
179: --
172: --
173: -- The primary key is invalid therefore we must error
174: --
175: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
176: hr_utility.raise_error;
177: --
178: end if;
179: --
180: close csr_leg_code;
178: end if;
179: --
180: close csr_leg_code;
181: --
182: hr_utility.set_location(' Leaving:'|| l_proc, 20);
183: --
184: return l_legislation_code;
185: --
186: end return_legislation_code;