DBA Data[Home] [Help]

APPS.PQH_WEL_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_wel_shd.api_updating
47: (p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_worksheet_bdgt_elmnt_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.worksheet_budget_set_id = p_worksheet_budget_set_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_wel_shd.api_updating
119: (p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id,
120: p_object_version_number => p_object_version_number);

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

143: close c1;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: End chk_worksheet_budget_set_id;
150: --
151: --

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

168: where a.element_type_id = p_element_type_id;
169: --
170: Begin
171: --
172: hr_utility.set_location('Entering:'||l_proc,5);
173: --
174: l_api_updating := pqh_wel_shd.api_updating
175: (p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id,
176: p_object_version_number => p_object_version_number);

Line 195: hr_utility.set_message(8302,'PQH_INVALID_WKS_ELEMENT_TYPE');

191: --
192: -- raise error as FK does not relate to PK in pay_element_types_f
193: -- table.
194: --
195: hr_utility.set_message(8302,'PQH_INVALID_WKS_ELEMENT_TYPE');
196: hr_utility.raise_error;
197: --
198: end if;
199: --

Line 196: hr_utility.raise_error;

192: -- raise error as FK does not relate to PK in pay_element_types_f
193: -- table.
194: --
195: hr_utility.set_message(8302,'PQH_INVALID_WKS_ELEMENT_TYPE');
196: hr_utility.raise_error;
197: --
198: end if;
199: --
200: close c1;

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

200: close c1;
201: --
202: end if;
203: --
204: hr_utility.set_location('Leaving:'||l_proc,10);
205: --
206: End chk_element_type_id;
207: --
208: --

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

215: l_api_updating boolean;
216: --
217: Begin
218: --
219: hr_utility.set_location('Entering:'||l_proc,5);
220: --
221: l_api_updating := pqh_wel_shd.api_updating
222: (p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id,
223: p_object_version_number => p_object_version_number);

Line 234: hr_utility.set_message(8302,'PQH_INVALID_DISTRIB_PERCENT');

230: --
231: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table
232: --
233: If p_distribution_percentage < 0 then
234: hr_utility.set_message(8302,'PQH_INVALID_DISTRIB_PERCENT');
235: hr_utility.raise_error;
236: End if;
237: --
238: end if;

Line 235: hr_utility.raise_error;

231: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table
232: --
233: If p_distribution_percentage < 0 then
234: hr_utility.set_message(8302,'PQH_INVALID_DISTRIB_PERCENT');
235: hr_utility.raise_error;
236: End if;
237: --
238: end if;
239: --

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

236: End if;
237: --
238: end if;
239: --
240: hr_utility.set_location('Leaving:'||l_proc,10);
241: --
242: End chk_distribution_percentage;
243: --
244: -- ----------------------------------------------------------------------------

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

248: --
249: l_proc varchar2(72) := g_package||'insert_validate';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- Call all supporting business operations
255: --
256: chk_worksheet_bdgt_elmnt_id

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

274: p_object_version_number => p_rec.object_version_number);
275: --
276: --
277: --
278: hr_utility.set_location(' Leaving:'||l_proc, 10);
279: End insert_validate;
280: --
281: -- ----------------------------------------------------------------------------
282: -- |---------------------------< update_validate >----------------------------|

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

285: --
286: l_proc varchar2(72) := g_package||'update_validate';
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Call all supporting business operations
292: --
293: chk_worksheet_bdgt_elmnt_id

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

311: p_object_version_number => p_rec.object_version_number);
312: --
313: --
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: End update_validate;
317: --
318: -- ----------------------------------------------------------------------------
319: -- |---------------------------< delete_validate >----------------------------|

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

322: --
323: l_proc varchar2(72) := g_package||'delete_validate';
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- Call all supporting business operations
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- Call all supporting business operations
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End delete_validate;
332: --
333: end pqh_wel_bus;