DBA Data[Home] [Help]

APPS.PQH_BPR_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_bpr_shd.api_updating
47: (p_budget_period_id => p_budget_period_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_period_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.time_period_id = p_end_time_period_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_bpr_shd.api_updating
119: (p_budget_period_id => p_budget_period_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_end_time_period_id;
150: --
151: -- ----------------------------------------------------------------------------

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

187: where a.time_period_id = p_start_time_period_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := pqh_bpr_shd.api_updating
194: (p_budget_period_id => p_budget_period_id,
195: p_object_version_number => p_object_version_number);

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

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

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

262: where a.budget_detail_id = p_budget_detail_id;
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc,5);
267: --
268: l_api_updating := pqh_bpr_shd.api_updating
269: (p_budget_period_id => p_budget_period_id,
270: p_object_version_number => p_object_version_number);

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

293: close c1;
294: --
295: end if;
296: --
297: hr_utility.set_location('Leaving:'||l_proc,10);
298: --
299: End chk_budget_detail_id;
300: --
301: --

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

334: l_api_updating boolean;
335: --
336: Begin
337: --
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: l_api_updating := pqh_bpr_shd.api_updating
341: (p_budget_period_id => p_budget_period_id,
342: p_object_version_number => p_object_version_number);

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

355: p_effective_date => p_effective_date) then
356: --
357: -- raise error as does not exist as lookup
358: --
359: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
360: hr_utility.raise_error;
361: --
362: end if;
363: --

Line 360: hr_utility.raise_error;

356: --
357: -- raise error as does not exist as lookup
358: --
359: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
360: hr_utility.raise_error;
361: --
362: end if;
363: --
364: end if;

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

362: end if;
363: --
364: end if;
365: --
366: hr_utility.set_location('Leaving:'||l_proc,10);
367: --
368: end chk_budget_unit3_value_type_cd;
369: --
370: -- ----------------------------------------------------------------------------

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

402: l_api_updating boolean;
403: --
404: Begin
405: --
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: l_api_updating := pqh_bpr_shd.api_updating
409: (p_budget_period_id => p_budget_period_id,
410: p_object_version_number => p_object_version_number);

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

423: p_effective_date => p_effective_date) then
424: --
425: -- raise error as does not exist as lookup
426: --
427: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
428: hr_utility.raise_error;
429: --
430: end if;
431: --

Line 428: hr_utility.raise_error;

424: --
425: -- raise error as does not exist as lookup
426: --
427: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
428: hr_utility.raise_error;
429: --
430: end if;
431: --
432: end if;

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

430: end if;
431: --
432: end if;
433: --
434: hr_utility.set_location('Leaving:'||l_proc,10);
435: --
436: end chk_budget_unit2_value_type_cd;
437: --
438: -- ----------------------------------------------------------------------------

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

470: l_api_updating boolean;
471: --
472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := pqh_bpr_shd.api_updating
477: (p_budget_period_id => p_budget_period_id,
478: p_object_version_number => p_object_version_number);

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

491: p_effective_date => p_effective_date) then
492: --
493: -- raise error as does not exist as lookup
494: --
495: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
496: hr_utility.raise_error;
497: --
498: end if;
499: --

Line 496: hr_utility.raise_error;

492: --
493: -- raise error as does not exist as lookup
494: --
495: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
496: hr_utility.raise_error;
497: --
498: end if;
499: --
500: end if;

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

498: end if;
499: --
500: end if;
501: --
502: hr_utility.set_location('Leaving:'||l_proc,10);
503: --
504: end chk_budget_unit1_value_type_cd;
505: --
506: -- ----------------------------------------------------------------------------

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

510: --
511: l_proc varchar2(72) := g_package||'insert_validate';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call all supporting business operations
517: --
518: chk_budget_period_id

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

553: p_object_version_number => p_rec.object_version_number);
554: --
555: --
556: --
557: hr_utility.set_location(' Leaving:'||l_proc, 10);
558: End insert_validate;
559: --
560: -- ----------------------------------------------------------------------------
561: -- |---------------------------< update_validate >----------------------------|

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

564: --
565: l_proc varchar2(72) := g_package||'update_validate';
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Call all supporting business operations
571: --
572: chk_budget_period_id

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

607: p_object_version_number => p_rec.object_version_number);
608: --
609: --
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End update_validate;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< delete_validate >----------------------------|

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

618: --
619: l_proc varchar2(72) := g_package||'delete_validate';
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: End delete_validate;
628: --
629: end pqh_bpr_bus;