DBA Data[Home] [Help]

APPS.PQH_BVR_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_bvr_shd.api_updating
47: (p_budget_version_id => p_budget_version_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_budget_version_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.budget_id = p_budget_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_bvr_shd.api_updating
119: (p_budget_version_id => p_budget_version_id,
120: p_object_version_number => p_object_version_number);

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

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

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

184: l_api_updating boolean;
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := pqh_bvr_shd.api_updating
191: (p_budget_version_id => p_budget_version_id,
192: p_object_version_number => p_object_version_number);

Line 209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

205: p_effective_date => p_effective_date) then
206: --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error;
211: --
212: end if;
213: --

Line 210: hr_utility.raise_error;

206: --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error;
211: --
212: end if;
213: --
214: end if;

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

212: end if;
213: --
214: end if;
215: --
216: hr_utility.set_location('Leaving:'||l_proc,10);
217: --
218: end chk_xfer_to_other_apps_cd;
219: --
220: -- ----------------------------------------------------------------------------

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

252: l_api_updating boolean;
253: --
254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := pqh_bvr_shd.api_updating
259: (p_budget_version_id => p_budget_version_id,
260: p_object_version_number => p_object_version_number);

Line 277: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

273: p_effective_date => p_effective_date) then
274: --
275: -- raise error as does not exist as lookup
276: --
277: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
278: hr_utility.raise_error;
279: --
280: end if;
281: --

Line 278: hr_utility.raise_error;

274: --
275: -- raise error as does not exist as lookup
276: --
277: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
278: hr_utility.raise_error;
279: --
280: end if;
281: --
282: end if;

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

280: end if;
281: --
282: end if;
283: --
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: end chk_transfered_to_gl_flag;
287: --
288: -- ----------------------------------------------------------------------------

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

293: --
294: l_proc varchar2(72) := g_package||'insert_validate';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- Call all supporting business operations
300: --
301: chk_budget_version_id

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

320: p_object_version_number => p_rec.object_version_number);
321: --
322: --
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End insert_validate;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |---------------------------< update_validate >----------------------------|

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

332: --
333: l_proc varchar2(72) := g_package||'update_validate';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: -- Call all supporting business operations
339: --
340: chk_budget_version_id

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

359: p_object_version_number => p_rec.object_version_number);
360: --
361: --
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: End update_validate;
365: --
366: -- ----------------------------------------------------------------------------
367: -- |---------------------------< delete_validate >----------------------------|

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

380: l_gl_flag pqh_budget_versions.transfered_to_gl_flag%TYPE := '';
381: l_gl_status pqh_budget_versions.gl_status%TYPE := '';
382:
383: Begin
384: hr_utility.set_location('Entering:'||l_proc, 5);
385: --
386: -- Call all supporting business operations
387: --
388: --

Line 395: hr_utility.set_location('transfered_to_gl_flag: '||l_gl_flag, 10);

391: FETCH csr_bvr INTO l_gl_flag,l_gl_status;
392: CLOSE csr_bvr;
393:
394: --
395: hr_utility.set_location('transfered_to_gl_flag: '||l_gl_flag, 10);
396: hr_utility.set_location('gl_status: '||l_gl_status, 10);
397: --
398:
399: IF (l_gl_flag IS NOT NULL) AND (l_gl_status IS NOT NULL) THEN

Line 396: hr_utility.set_location('gl_status: '||l_gl_status, 10);

392: CLOSE csr_bvr;
393:
394: --
395: hr_utility.set_location('transfered_to_gl_flag: '||l_gl_flag, 10);
396: hr_utility.set_location('gl_status: '||l_gl_status, 10);
397: --
398:
399: IF (l_gl_flag IS NOT NULL) AND (l_gl_status IS NOT NULL) THEN
400: -- this is a posted version, delete not allowed

Line 401: hr_utility.set_message(8302,'PQH_GL_REC_EXISTS');

397: --
398:
399: IF (l_gl_flag IS NOT NULL) AND (l_gl_status IS NOT NULL) THEN
400: -- this is a posted version, delete not allowed
401: hr_utility.set_message(8302,'PQH_GL_REC_EXISTS');
402: hr_utility.raise_error;
403: --
404: END IF;
405:

Line 402: hr_utility.raise_error;

398:
399: IF (l_gl_flag IS NOT NULL) AND (l_gl_status IS NOT NULL) THEN
400: -- this is a posted version, delete not allowed
401: hr_utility.set_message(8302,'PQH_GL_REC_EXISTS');
402: hr_utility.raise_error;
403: --
404: END IF;
405:
406: --

Line 408: hr_utility.set_location(' Leaving:'||l_proc, 100);

404: END IF;
405:
406: --
407:
408: hr_utility.set_location(' Leaving:'||l_proc, 100);
409:
410: End delete_validate;
411:
412: --