DBA Data[Home] [Help]

APPS.PQH_BDT_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_bdt_shd.api_updating
47: (p_budget_detail_id => p_budget_detail_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_detail_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.grade_id = p_grade_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_bdt_shd.api_updating
119: (p_budget_detail_id => p_budget_detail_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_grade_id;
151: --
152: -- ----------------------------------------------------------------------------

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

188: where a.job_id = p_job_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_bdt_shd.api_updating
195: (p_budget_detail_id => p_budget_detail_id,
196: p_object_version_number => p_object_version_number);

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

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

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

264: where a.budget_version_id = p_budget_version_id;
265: --
266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_bdt_shd.api_updating
271: (p_budget_detail_id => p_budget_detail_id,
272: p_object_version_number => p_object_version_number);

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

296: close c1;
297: --
298: end if;
299: --
300: hr_utility.set_location('Leaving:'||l_proc,10);
301: --
302: End chk_budget_version_id;
303: --
304: -- ----------------------------------------------------------------------------

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

340: where a.organization_id = p_organization_id;
341: --
342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc,5);
345: --
346: l_api_updating := pqh_bdt_shd.api_updating
347: (p_budget_detail_id => p_budget_detail_id,
348: p_object_version_number => p_object_version_number);

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

372: close c1;
373: --
374: end if;
375: --
376: hr_utility.set_location('Leaving:'||l_proc,10);
377: --
378: End chk_organization_id;
379: --
380: --

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

413: l_api_updating boolean;
414: --
415: Begin
416: --
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: l_api_updating := pqh_bdt_shd.api_updating
420: (p_budget_detail_id => p_budget_detail_id,
421: p_object_version_number => p_object_version_number);

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

434: p_effective_date => p_effective_date) then
435: --
436: -- raise error as does not exist as lookup
437: --
438: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
439: hr_utility.raise_error;
440: --
441: end if;
442: --

Line 439: hr_utility.raise_error;

435: --
436: -- raise error as does not exist as lookup
437: --
438: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
439: hr_utility.raise_error;
440: --
441: end if;
442: --
443: end if;

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

441: end if;
442: --
443: end if;
444: --
445: hr_utility.set_location('Leaving:'||l_proc,10);
446: --
447: end chk_budget_unit3_value_type_cd;
448: --
449: -- ----------------------------------------------------------------------------

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

481: l_api_updating boolean;
482: --
483: Begin
484: --
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: --
487: l_api_updating := pqh_bdt_shd.api_updating
488: (p_budget_detail_id => p_budget_detail_id,
489: p_object_version_number => p_object_version_number);

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

502: p_effective_date => p_effective_date) then
503: --
504: -- raise error as does not exist as lookup
505: --
506: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
507: hr_utility.raise_error;
508: --
509: end if;
510: --

Line 507: hr_utility.raise_error;

503: --
504: -- raise error as does not exist as lookup
505: --
506: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
507: hr_utility.raise_error;
508: --
509: end if;
510: --
511: end if;

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

509: end if;
510: --
511: end if;
512: --
513: hr_utility.set_location('Leaving:'||l_proc,10);
514: --
515: end chk_budget_unit2_value_type_cd;
516: --
517: -- ----------------------------------------------------------------------------

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

549: l_api_updating boolean;
550: --
551: Begin
552: --
553: hr_utility.set_location('Entering:'||l_proc, 5);
554: --
555: l_api_updating := pqh_bdt_shd.api_updating
556: (p_budget_detail_id => p_budget_detail_id,
557: p_object_version_number => p_object_version_number);

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

570: p_effective_date => p_effective_date) then
571: --
572: -- raise error as does not exist as lookup
573: --
574: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
575: hr_utility.raise_error;
576: --
577: end if;
578: --

Line 575: hr_utility.raise_error;

571: --
572: -- raise error as does not exist as lookup
573: --
574: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
575: hr_utility.raise_error;
576: --
577: end if;
578: --
579: end if;

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

577: end if;
578: --
579: end if;
580: --
581: hr_utility.set_location('Leaving:'||l_proc,10);
582: --
583: end chk_budget_unit1_value_type_cd;
584: --
585: -- ----------------------------------------------------------------------------

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

589: --
590: l_proc varchar2(72) := g_package||'insert_validate';
591: --
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- Call all supporting business operations
596: --
597: chk_budget_detail_id

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

638: --
639: --
640: --
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: End insert_validate;
644: --
645: -- ----------------------------------------------------------------------------
646: -- |---------------------------< update_validate >----------------------------|

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

649: --
650: l_proc varchar2(72) := g_package||'update_validate';
651: --
652: Begin
653: hr_utility.set_location('Entering:'||l_proc, 5);
654: --
655: -- Call all supporting business operations
656: --
657: chk_budget_detail_id

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

698: --
699: --
700: --
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 10);
703: End update_validate;
704: --
705: -- ----------------------------------------------------------------------------
706: -- |---------------------------< delete_validate >----------------------------|

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

709: --
710: l_proc varchar2(72) := g_package||'delete_validate';
711: --
712: Begin
713: hr_utility.set_location('Entering:'||l_proc, 5);
714: --
715: -- Call all supporting business operations
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

713: hr_utility.set_location('Entering:'||l_proc, 5);
714: --
715: -- Call all supporting business operations
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 10);
718: End delete_validate;
719: --
720: end pqh_bdt_bus;