eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WST_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_wst_shd.api_updating
47: (p_worksheet_budget_set_id => p_worksheet_budget_set_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_budget_set_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_wst_shd.api_updating
119: (p_worksheet_budget_set_id => p_worksheet_budget_set_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 191: hr_utility.set_location('Entering:'||l_proc,5);

187: where a.worksheet_period_id = p_worksheet_period_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := pqh_wst_shd.api_updating
194: (p_worksheet_budget_set_id => p_worksheet_budget_set_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_worksheet_period_id;
225: --
226: -- ----------------------------------------------------------------------------

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

258: l_api_updating boolean;
259: --
260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := pqh_wst_shd.api_updating
265: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
266: p_object_version_number => p_object_version_number);

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

279: p_effective_date => p_effective_date) then
280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --

Line 284: hr_utility.raise_error;

280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --
288: end if;

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

286: end if;
287: --
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: end chk_budget_unit3_value_type_cd;
293: --
294: -- ----------------------------------------------------------------------------

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

326: l_api_updating boolean;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := pqh_wst_shd.api_updating
333: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
334: p_object_version_number => p_object_version_number);

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

347: p_effective_date => p_effective_date) then
348: --
349: -- raise error as does not exist as lookup
350: --
351: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
352: hr_utility.raise_error;
353: --
354: end if;
355: --

Line 352: hr_utility.raise_error;

348: --
349: -- raise error as does not exist as lookup
350: --
351: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
352: hr_utility.raise_error;
353: --
354: end if;
355: --
356: end if;

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

354: end if;
355: --
356: end if;
357: --
358: hr_utility.set_location('Leaving:'||l_proc,10);
359: --
360: end chk_budget_unit2_value_type_cd;
361: --
362: -- ----------------------------------------------------------------------------

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

394: l_api_updating boolean;
395: --
396: Begin
397: --
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: l_api_updating := pqh_wst_shd.api_updating
401: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
402: p_object_version_number => p_object_version_number);

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

415: p_effective_date => p_effective_date) then
416: --
417: -- raise error as does not exist as lookup
418: --
419: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
420: hr_utility.raise_error;
421: --
422: end if;
423: --

Line 420: hr_utility.raise_error;

416: --
417: -- raise error as does not exist as lookup
418: --
419: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
420: hr_utility.raise_error;
421: --
422: end if;
423: --
424: end if;

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

422: end if;
423: --
424: end if;
425: --
426: hr_utility.set_location('Leaving:'||l_proc,10);
427: --
428: end chk_budget_unit1_value_type_cd;
429: --
430: --

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

445: --
446: --
447: Begin
448: --
449: hr_utility.set_location('Entering:'||l_proc,5);
450: --
451: l_api_updating := pqh_wst_shd.api_updating
452: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
453: p_object_version_number => p_object_version_number);

Line 464: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');

460: --
461: -- Raise error if the value is negative
462: --
463: If p_budget_unit1_percent < 0 then
464: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
465: hr_utility.raise_error;
466: End if;
467: end if;
468: --

Line 465: hr_utility.raise_error;

461: -- Raise error if the value is negative
462: --
463: If p_budget_unit1_percent < 0 then
464: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
465: hr_utility.raise_error;
466: End if;
467: end if;
468: --
469: --

Line 479: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');

475: --
476: -- Raise error if the value is negative
477: --
478: If p_budget_unit1_value < 0 then
479: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
480: hr_utility.raise_error;
481: End if;
482: end if;
483: --

Line 480: hr_utility.raise_error;

476: -- Raise error if the value is negative
477: --
478: If p_budget_unit1_value < 0 then
479: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
480: hr_utility.raise_error;
481: End if;
482: end if;
483: --
484: --

Line 495: hr_utility.set_message(8302,'PQH_INVALID_UNIT1_CONSUMED');

491: --
492: -- Raise error if the value is negative
493: --
494: If p_budget_unit1_available < 0 then
495: hr_utility.set_message(8302,'PQH_INVALID_UNIT1_CONSUMED');
496: hr_utility.raise_error;
497: End if;
498: end if;
499: **/

Line 496: hr_utility.raise_error;

492: -- Raise error if the value is negative
493: --
494: If p_budget_unit1_available < 0 then
495: hr_utility.set_message(8302,'PQH_INVALID_UNIT1_CONSUMED');
496: hr_utility.raise_error;
497: End if;
498: end if;
499: **/
500: --

Line 512: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');

508: --
509: -- Raise error if the value is negative
510: --
511: If p_budget_unit2_percent < 0 then
512: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
513: hr_utility.raise_error;
514: End if;
515: end if;
516: --

Line 513: hr_utility.raise_error;

509: -- Raise error if the value is negative
510: --
511: If p_budget_unit2_percent < 0 then
512: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
513: hr_utility.raise_error;
514: End if;
515: end if;
516: --
517: --

Line 527: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');

523: --
524: -- Raise error if the value is negative
525: --
526: If p_budget_unit2_value < 0 then
527: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
528: hr_utility.raise_error;
529: End if;
530: end if;
531: --

Line 528: hr_utility.raise_error;

524: -- Raise error if the value is negative
525: --
526: If p_budget_unit2_value < 0 then
527: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
528: hr_utility.raise_error;
529: End if;
530: end if;
531: --
532: --

Line 543: hr_utility.set_message(8302,'PQH_INVALID_UNIT2_CONSUMED');

539: --
540: -- Raise error if the value is negative
541: --
542: If p_budget_unit2_available < 0 then
543: hr_utility.set_message(8302,'PQH_INVALID_UNIT2_CONSUMED');
544: hr_utility.raise_error;
545: End if;
546: end if;
547: **/

Line 544: hr_utility.raise_error;

540: -- Raise error if the value is negative
541: --
542: If p_budget_unit2_available < 0 then
543: hr_utility.set_message(8302,'PQH_INVALID_UNIT2_CONSUMED');
544: hr_utility.raise_error;
545: End if;
546: end if;
547: **/
548: --

Line 559: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');

555: --
556: -- Raise error if the value is negative
557: --
558: If p_budget_unit3_percent < 0 then
559: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
560: hr_utility.raise_error;
561: End if;
562: end if;
563: --

Line 560: hr_utility.raise_error;

556: -- Raise error if the value is negative
557: --
558: If p_budget_unit3_percent < 0 then
559: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
560: hr_utility.raise_error;
561: End if;
562: end if;
563: --
564: --

Line 574: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');

570: --
571: -- Raise error if the value is negative
572: --
573: If p_budget_unit3_value < 0 then
574: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
575: hr_utility.raise_error;
576: End if;
577: end if;
578: --

Line 575: hr_utility.raise_error;

571: -- Raise error if the value is negative
572: --
573: If p_budget_unit3_value < 0 then
574: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
575: hr_utility.raise_error;
576: End if;
577: end if;
578: --
579: --

Line 590: hr_utility.set_message(8302,'PQH_INVALID_UNIT3_CONSUMED');

586: --
587: -- Raise error if the value is negative
588: --
589: If p_budget_unit3_available < 0 then
590: hr_utility.set_message(8302,'PQH_INVALID_UNIT3_CONSUMED');
591: hr_utility.raise_error;
592: End if;
593: end if;
594: **/

Line 591: hr_utility.raise_error;

587: -- Raise error if the value is negative
588: --
589: If p_budget_unit3_available < 0 then
590: hr_utility.set_message(8302,'PQH_INVALID_UNIT3_CONSUMED');
591: hr_utility.raise_error;
592: End if;
593: end if;
594: **/
595: --

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

593: end if;
594: **/
595: --
596: --
597: hr_utility.set_location('Leaving:'||l_proc,10);
598: --
599: End chk_numeric_values;
600: --
601: -- ----------------------------------------------------------------------------

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

606: --
607: l_proc varchar2(72) := g_package||'insert_validate';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: -- Call all supporting business operations
613: --
614: chk_worksheet_budget_set_id

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

655: p_object_version_number => p_rec.object_version_number);
656: --
657: --
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 10);
660: End insert_validate;
661: --
662: -- ----------------------------------------------------------------------------
663: -- |---------------------------< update_validate >----------------------------|

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

667: --
668: l_proc varchar2(72) := g_package||'update_validate';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);
672: --
673: -- Call all supporting business operations
674: --
675: chk_worksheet_budget_set_id

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

716: p_object_version_number => p_rec.object_version_number);
717: --
718: --
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 10);
721: End update_validate;
722: --
723: -- ----------------------------------------------------------------------------
724: -- |---------------------------< delete_validate >----------------------------|

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

728: --
729: l_proc varchar2(72) := g_package||'delete_validate';
730: --
731: Begin
732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- Call all supporting business operations
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- Call all supporting business operations
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 10);
737: End delete_validate;
738: --
739: end pqh_wst_bus;