DBA Data[Home] [Help]

APPS.PAY_SGB_BUS dependencies on HR_UTILITY

Line 98: hr_utility.set_location('Entering:'||l_proc, 5);

94: l_proc varchar2(72) := g_package||'chk_source_id';
95: l_exists varchar2(1);
96: --
97: Begin
98: hr_utility.set_location('Entering:'||l_proc, 5);
99: --
100: -- Check that the source_id is not null.
101: --
102: hr_api.mandatory_arg_error

Line 118: hr_utility.set_location('Leaving:'||l_proc, 10);

114: fnd_message.set_name('PAY', 'PAY_50095_ETM_INVALID_ELE_TYPE');
115: fnd_message.raise_error;
116: end if;
117: close c_element_type_exists;
118: hr_utility.set_location('Leaving:'||l_proc, 10);
119: End chk_source_id;
120: --
121: -- ----------------------------------------------------------------------------
122: -- |---------------------------< chk_source_type >----------------------------|

Line 131: hr_utility.set_location('Entering:'||l_proc, 5);

127: --
128: l_proc varchar2(72) := g_package||'chk_source_type';
129: --
130: Begin
131: hr_utility.set_location('Entering:'||l_proc, 5);
132: if UPPER(p_source_type) <> 'ET' then
133: fnd_message.set_name('PAY', 'PAY_50120_SGB_BAD_SOURCE_TYPE');
134: fnd_message.set_token('SOURCE_TYPE', p_source_type);
135: fnd_message.raise_error;

Line 137: hr_utility.set_location('Leaving:'||l_proc, 10);

133: fnd_message.set_name('PAY', 'PAY_50120_SGB_BAD_SOURCE_TYPE');
134: fnd_message.set_token('SOURCE_TYPE', p_source_type);
135: fnd_message.raise_error;
136: end if;
137: hr_utility.set_location('Leaving:'||l_proc, 10);
138: End chk_source_type;
139: --
140: -- ----------------------------------------------------------------------------
141: -- |------------------------< chk_balance_type_name >-------------------------|

Line 151: hr_utility.set_location('Entering:'||l_proc, 5);

147: --
148: l_proc varchar2(72) := g_package||'chk_balance_type_name';
149: --
150: Begin
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: if p_balance_type_id is null then
153: --
154: -- Balance type name is mandatory
155: --

Line 162: hr_utility.set_location('Leaving:'||l_proc, 10);

158: ,p_argument => 'BALANCE_TYPE_NAME'
159: ,p_argument_value => p_balance_type_name
160: );
161: end if;
162: hr_utility.set_location('Leaving:'||l_proc, 10);
163: End chk_balance_type_name;
164: --
165: -- ----------------------------------------------------------------------------
166: -- |-------------------------< chk_balance_type_id >--------------------------|

Line 191: hr_utility.set_location('Entering:'||l_proc, 5);

187: l_api_updating boolean;
188: l_valid varchar2(1);
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: l_api_updating := pay_sgb_shd.api_updating
193: (p_grossup_balances_id => p_grossup_balances_id
194: ,p_object_version_number => p_object_version_number
195: );

Line 222: hr_utility.set_location('Leaving:'||l_proc, 10);

218: end if;
219: close c_bal_type_id_valid;
220: end if;
221: end if;
222: hr_utility.set_location('Leaving:'||l_proc, 10);
223: End chk_balance_type_id;
224: --
225: -- ----------------------------------------------------------------------------
226: -- |-------------------------< chk_exclusion_rule_id >------------------------|

Line 250: hr_utility.set_location('Entering:'||l_proc, 5);

246: l_api_updating boolean;
247: l_valid varchar2(1);
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: l_api_updating := pay_sgb_shd.api_updating
252: (p_grossup_balances_id => p_grossup_balances_id
253: ,p_object_version_number => p_object_version_number
254: );

Line 270: hr_utility.set_location('Leaving:'||l_proc, 10);

266: end if;
267: close c_exclusion_rule_id_valid;
268: end if;
269: end if;
270: hr_utility.set_location('Leaving:'||l_proc, 10);
271: End chk_exclusion_rule_id;
272: --
273: -- ----------------------------------------------------------------------------
274: -- |-----------------------------< chk_delete >-------------------------------|

Line 293: hr_utility.set_location('Entering:'||l_proc, 5);

289: l_error exception;
290: l_exists varchar2(1);
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: open c_core_objects;
296: fetch c_core_objects into l_exists;
297: if c_core_objects%found then

Line 302: hr_utility.set_location('Leaving:'||l_proc, 10);

298: close c_core_objects;
299: raise l_error;
300: end if;
301: close c_core_objects;
302: hr_utility.set_location('Leaving:'||l_proc, 10);
303: exception
304: when l_error then
305: fnd_message.set_name('PAY', 'PAY_50119_SGB_INVALID_DELETE');
306: fnd_message.raise_error;

Line 308: hr_utility.set_location('Leaving:'||l_proc, 15);

304: when l_error then
305: fnd_message.set_name('PAY', 'PAY_50119_SGB_INVALID_DELETE');
306: fnd_message.raise_error;
307: when others then
308: hr_utility.set_location('Leaving:'||l_proc, 15);
309: raise;
310: End chk_delete;
311: --
312: -- ----------------------------------------------------------------------------

Line 323: hr_utility.set_location('Entering:'||l_proc, 5);

319: --
320: l_proc varchar2(72) := g_package||'insert_validate';
321: --
322: Begin
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: --
325: -- Call all supporting business operations
326: --
327: chk_source_id(p_rec.source_id);

Line 352: hr_utility.set_location(' Leaving:'||l_proc, 10);

348: ,p_object_version_number => p_rec.object_version_number
349: );
350: --
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: End insert_validate;
354: --
355: -- ----------------------------------------------------------------------------
356: -- |---------------------------< update_validate >----------------------------|

Line 366: hr_utility.set_location('Entering:'||l_proc, 5);

362: --
363: l_proc varchar2(72) := g_package||'update_validate';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- Call all supporting business operations
369: --
370: chk_non_updateable_args(p_rec);

Line 395: hr_utility.set_location(' Leaving:'||l_proc, 10);

391: ,p_object_version_number => p_rec.object_version_number
392: );
393: --
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End update_validate;
397: --
398: -- ----------------------------------------------------------------------------
399: -- |---------------------------< delete_validate >----------------------------|

Line 408: hr_utility.set_location('Entering:'||l_proc, 5);

404: --
405: l_proc varchar2(72) := g_package||'delete_validate';
406: --
407: Begin
408: hr_utility.set_location('Entering:'||l_proc, 5);
409: --
410: -- Call all supporting business operations
411: --
412: chk_delete(p_rec.grossup_balances_id);

Line 414: hr_utility.set_location(' Leaving:'||l_proc, 10);

410: -- Call all supporting business operations
411: --
412: chk_delete(p_rec.grossup_balances_id);
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: End delete_validate;
416: --
417: end pay_sgb_bus;