DBA Data[Home] [Help]

APPS.PQH_DEL_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_del_shd.api_updating
47: (p_dflt_budget_element_id => p_dflt_budget_element_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_dflt_budget_element_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.dflt_budget_set_id = p_dflt_budget_set_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_del_shd.api_updating
119: (p_dflt_budget_element_id => p_dflt_budget_element_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_dflt_budget_set_id;
150: --
151: --

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

168: and element_type_id = p_element_type_id;
169:
170: Begin
171: --
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: open csr_element;
175: fetch csr_element into l_dummy;
176: close csr_element;

Line 180: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_ELEMENTS');

176: close csr_element;
177:
178: if nvl(l_dummy ,'Y') = 'X' then
179: --
180: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_ELEMENTS');
181: hr_utility.raise_error;
182: --
183: end if;
184:

Line 181: hr_utility.raise_error;

177:
178: if nvl(l_dummy ,'Y') = 'X' then
179: --
180: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_ELEMENTS');
181: hr_utility.raise_error;
182: --
183: end if;
184:
185: --

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

182: --
183: end if;
184:
185: --
186: hr_utility.set_location('Leaving:'||l_proc,10);
187: --
188: end chk_duplicate_elements;
189: --
190: -- ----------------------------------------------------------------------------

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

203: where dflt_budget_set_id = p_dflt_budget_set_id;
204:
205: Begin
206: --
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: open csr_element;
210: fetch csr_element into l_sum;
211: close csr_element;

Line 216: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');

212:
213: if l_sum > 100 then
214: -- sum cannot be more then 100
215: --
216: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');
217: hr_utility.raise_error;
218: --
219: end if;
220:

Line 217: hr_utility.raise_error;

213: if l_sum > 100 then
214: -- sum cannot be more then 100
215: --
216: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');
217: hr_utility.raise_error;
218: --
219: end if;
220:
221: --

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

218: --
219: end if;
220:
221: --
222: hr_utility.set_location('Leaving:'||l_proc,10);
223: --
224: end chk_sum;
225: --
226: -- ----------------------------------------------------------------------------

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

232: --
233:
234: Begin
235: --
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: if NVL(p_dflt_dist_percentage,0) < 0 then
239: -- percentage cannot be less then zero
240: --

Line 241: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_PERCENT');

237: --
238: if NVL(p_dflt_dist_percentage,0) < 0 then
239: -- percentage cannot be less then zero
240: --
241: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_PERCENT');
242: hr_utility.raise_error;
243: --
244: end if;
245:

Line 242: hr_utility.raise_error;

238: if NVL(p_dflt_dist_percentage,0) < 0 then
239: -- percentage cannot be less then zero
240: --
241: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_PERCENT');
242: hr_utility.raise_error;
243: --
244: end if;
245:
246: --

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

243: --
244: end if;
245:
246: --
247: hr_utility.set_location('Leaving:'||l_proc,10);
248: --
249: end chk_percentage;
250: --
251: --

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

256: --
257: l_proc varchar2(72) := g_package||'insert_validate';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- Call all supporting business operations
263: --
264: chk_dflt_budget_element_id

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

278: --
279: chk_percentage
280: (p_dflt_dist_percentage => p_rec.dflt_dist_percentage );
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: End insert_validate;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |---------------------------< update_validate >----------------------------|

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

289: --
290: l_proc varchar2(72) := g_package||'update_validate';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Call all supporting business operations
296: --
297: chk_dflt_budget_element_id

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

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

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

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

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

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