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_TCA_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_tca_shd.api_updating
47: (p_txn_category_attribute_id => p_txn_category_attribute_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_txn_category_attribute_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.table_route_id = p_transaction_table_route_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_tca_shd.api_updating
119: (p_txn_category_attribute_id => p_txn_category_attribute_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_transaction_table_route_id;
151: --
152: -- ----------------------------------------------------------------------------

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

188: where a.flex_value_Set_id = p_value_set_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_tca_shd.api_updating
195: (p_txn_category_attribute_id => p_txn_category_attribute_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_value_set_id;
227: --
228: -- ----------------------------------------------------------------------------

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

264: where a.transaction_category_id = p_transaction_category_id;
265: --
266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_tca_shd.api_updating
271: (p_txn_category_attribute_id => p_txn_category_attribute_id,
272: p_object_version_number => p_object_version_number);

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

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

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

339: where a.attribute_id = p_attribute_id;
340: --
341: Begin
342: --
343: hr_utility.set_location('Entering:'||l_proc,5);
344: --
345: l_api_updating := pqh_tca_shd.api_updating
346: (p_txn_category_attribute_id => p_txn_category_attribute_id,
347: p_object_version_number => p_object_version_number);

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

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

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

410: l_api_updating boolean;
411: --
412: Begin
413: --
414: hr_utility.set_location('Entering:'||l_proc, 5);
415: --
416: l_api_updating := pqh_tca_shd.api_updating
417: (p_txn_category_attribute_id => p_txn_category_attribute_id,
418: p_object_version_number => p_object_version_number);

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

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

Line 436: hr_utility.raise_error;

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

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

438: end if;
439: --
440: end if;
441: --
442: hr_utility.set_location('Leaving:'||l_proc,10);
443: --
444: end chk_value_style_cd;
445: --
446: -- ----------------------------------------------------------------------------

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

478: l_api_updating boolean;
479: --
480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: l_api_updating := pqh_tca_shd.api_updating
485: (p_txn_category_attribute_id => p_txn_category_attribute_id,
486: p_object_version_number => p_object_version_number);

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

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

Line 504: hr_utility.raise_error;

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

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

506: end if;
507: --
508: end if;
509: --
510: hr_utility.set_location('Leaving:'||l_proc,10);
511: --
512: end chk_refresh_flag;
513: --
514: -- ----------------------------------------------------------------------------

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

546: l_api_updating boolean;
547: --
548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: l_api_updating := pqh_tca_shd.api_updating
553: (p_txn_category_attribute_id => p_txn_category_attribute_id,
554: p_object_version_number => p_object_version_number);

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

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

Line 572: hr_utility.raise_error;

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

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

574: end if;
575: --
576: end if;
577: --
578: hr_utility.set_location('Leaving:'||l_proc,10);
579: --
580: end chk_select_flag;
581: --
582: -- ----------------------------------------------------------------------------

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

618: l_api_updating boolean;
619: --
620: Begin
621: --
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: l_api_updating := pqh_tca_shd.api_updating
625: (p_txn_category_attribute_id => p_txn_category_attribute_id,
626: p_object_version_number => p_object_version_number);

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

661: p_effective_date => p_effective_date) then
662: --
663: -- raise error as does not exist as lookup
664: --
665: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
666: hr_utility.raise_error;
667: --
668: end if;
669: --

Line 666: hr_utility.raise_error;

662: --
663: -- raise error as does not exist as lookup
664: --
665: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
666: hr_utility.raise_error;
667: --
668: end if;
669: --
670: --

Line 678: hr_utility.set_message(8302,'PQH_INVALID_MEMBER_IDENTIFIER');

674: if nvl(p_identifier_flag,hr_api.g_varchar2) <> 'Y' and p_member_identifying_flag = 'Y' then
675: --
676: -- raise error
677: --
678: hr_utility.set_message(8302,'PQH_INVALID_MEMBER_IDENTIFIER');
679: hr_utility.raise_error;
680: --
681: end if;
682: --

Line 679: hr_utility.raise_error;

675: --
676: -- raise error
677: --
678: hr_utility.set_message(8302,'PQH_INVALID_MEMBER_IDENTIFIER');
679: hr_utility.raise_error;
680: --
681: end if;
682: --
683:

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

682: --
683:
684: end if;
685: --
686: hr_utility.set_location('Leaving:'||l_proc,10);
687: --
688: end chk_member_identifying_flag;
689: --
690: -- ----------------------------------------------------------------------------

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

726: l_api_updating boolean;
727: --
728: Begin
729: --
730: hr_utility.set_location('Entering:'||l_proc, 5);
731: --
732: l_api_updating := pqh_tca_shd.api_updating
733: (p_txn_category_attribute_id => p_txn_category_attribute_id,
734: p_object_version_number => p_object_version_number);

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

766: p_effective_date => p_effective_date) then
767: --
768: -- raise error as does not exist as lookup
769: --
770: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
771: hr_utility.raise_error;
772: --
773: end if;
774: --

Line 771: hr_utility.raise_error;

767: --
768: -- raise error as does not exist as lookup
769: --
770: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
771: hr_utility.raise_error;
772: --
773: end if;
774: --
775: --

Line 783: hr_utility.set_message(8302,'PQH_INVALID_LIST_IDENTIFIER');

779: if nvl(p_identifier_flag,hr_api.g_varchar2) <> 'Y' and p_list_identifying_flag = 'Y' then
780: --
781: -- raise error
782: --
783: hr_utility.set_message(8302,'PQH_INVALID_LIST_IDENTIFIER');
784: hr_utility.raise_error;
785: --
786: end if;
787: --

Line 784: hr_utility.raise_error;

780: --
781: -- raise error
782: --
783: hr_utility.set_message(8302,'PQH_INVALID_LIST_IDENTIFIER');
784: hr_utility.raise_error;
785: --
786: end if;
787: --
788:

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

787: --
788:
789: end if;
790: --
791: hr_utility.set_location('Leaving:'||l_proc,10);
792: --
793: end chk_list_identifying_flag;
794: --
795: -- ----------------------------------------------------------------------------

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

827: l_api_updating boolean;
828: --
829: Begin
830: --
831: hr_utility.set_location('Entering:'||l_proc, 5);
832: --
833: l_api_updating := pqh_tca_shd.api_updating
834: (p_txn_category_attribute_id => p_txn_category_attribute_id,
835: p_object_version_number => p_object_version_number);

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

848: p_effective_date => p_effective_date) then
849: --
850: -- raise error as does not exist as lookup
851: --
852: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
853: hr_utility.raise_error;
854: --
855: end if;
856: --

Line 853: hr_utility.raise_error;

849: --
850: -- raise error as does not exist as lookup
851: --
852: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
853: hr_utility.raise_error;
854: --
855: end if;
856: --
857: end if;

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

855: end if;
856: --
857: end if;
858: --
859: hr_utility.set_location('Leaving:'||l_proc,10);
860: --
861: end chk_identifier_flag;
862: --
863: ------------------------------------------------------------------------------

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

903: --
904: --
905: Begin
906: --
907: hr_utility.set_location('Entering:'||l_proc,5);
908: --
909: --
910: if l_freeze_status_cd = 'FREEZE_ATTRIBUTES'
911: OR l_freeze_status_cd = 'FREEZE_CATEGORY' then

Line 912: hr_utility.set_message(8302,'PQH_CANNOT_MODIFY_TXN_CAT_ATTR');

908: --
909: --
910: if l_freeze_status_cd = 'FREEZE_ATTRIBUTES'
911: OR l_freeze_status_cd = 'FREEZE_CATEGORY' then
912: hr_utility.set_message(8302,'PQH_CANNOT_MODIFY_TXN_CAT_ATTR');
913: hr_utility.raise_error;
914: End if;
915:
916: hr_utility.set_location('Leaving:'||l_proc,10);

Line 913: hr_utility.raise_error;

909: --
910: if l_freeze_status_cd = 'FREEZE_ATTRIBUTES'
911: OR l_freeze_status_cd = 'FREEZE_CATEGORY' then
912: hr_utility.set_message(8302,'PQH_CANNOT_MODIFY_TXN_CAT_ATTR');
913: hr_utility.raise_error;
914: End if;
915:
916: hr_utility.set_location('Leaving:'||l_proc,10);
917: --

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

912: hr_utility.set_message(8302,'PQH_CANNOT_MODIFY_TXN_CAT_ATTR');
913: hr_utility.raise_error;
914: End if;
915:
916: hr_utility.set_location('Leaving:'||l_proc,10);
917: --
918: End chk_transaction_cat_status;
919: --
920:

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

928: l_proc varchar2(72) := g_package||'insert_validate';
929:
930: --
931: Begin
932: hr_utility.set_location('Entering:'||l_proc, 5);
933: --
934: -- Call all supporting business operations
935: --
936: chk_txn_category_attribute_id

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

1004: p_object_version_number => p_rec.object_version_number);
1005: --
1006: --
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009: End insert_validate;
1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< update_validate >----------------------------|

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

1017: --
1018: l_proc varchar2(72) := g_package||'update_validate';
1019: --
1020: Begin
1021: hr_utility.set_location('Entering:'||l_proc, 5);
1022: --
1023: -- Call all supporting business operations
1024: --
1025: chk_txn_category_attribute_id

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

1092: (p_attribute_id => p_rec.attribute_id,
1093: p_object_version_number => p_rec.object_version_number);
1094: --
1095: --
1096: hr_utility.set_location(' Leaving:'||l_proc, 10);
1097: End update_validate;
1098: --
1099: -- ----------------------------------------------------------------------------
1100: -- |---------------------------< delete_validate >----------------------------|

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

1104: --
1105: l_proc varchar2(72) := g_package||'delete_validate';
1106: --
1107: Begin
1108: hr_utility.set_location('Entering:'||l_proc, 5);
1109: --
1110: -- Call all supporting business operations
1111: --
1112: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1108: hr_utility.set_location('Entering:'||l_proc, 5);
1109: --
1110: -- Call all supporting business operations
1111: --
1112: hr_utility.set_location(' Leaving:'||l_proc, 10);
1113: End delete_validate;
1114: --
1115: end pqh_tca_bus;