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_RHT_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_rht_shd.api_updating
47: (p_routing_history_id => p_routing_history_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_routing_history_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.pos_structure_version_id = p_pos_structure_version_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rht_shd.api_updating
119: (p_routing_history_id => p_routing_history_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_pos_structure_version_id;
151: --
152: -- ----------------------------------------------------------------------------

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

188: where a.routing_list_member_id = p_forwarded_to_member_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_rht_shd.api_updating
195: (p_routing_history_id => p_routing_history_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_forwarded_to_member_id;
227: --
228: -- ----------------------------------------------------------------------------

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

264: where a.routing_list_member_id = p_forwarded_by_member_id;
265: --
266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_rht_shd.api_updating
271: (p_routing_history_id => p_routing_history_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_forwarded_by_member_id;
303: --
304: -- ----------------------------------------------------------------------------

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

340: where a.transaction_category_id = p_transaction_category_id;
341: --
342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc,5);
345: --
346: l_api_updating := pqh_rht_shd.api_updating
347: (p_routing_history_id => p_routing_history_id,
348: p_object_version_number => p_object_version_number);

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

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

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

415: where a.position_id = p_forwarded_to_position_id;
416: --
417: Begin
418: --
419: hr_utility.set_location('Entering:'||l_proc,5);
420: --
421: l_api_updating := pqh_rht_shd.api_updating
422: (p_routing_history_id => p_routing_history_id,
423: p_object_version_number => p_object_version_number);

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

447: close c1;
448: --
449: end if;
450: --
451: hr_utility.set_location('Leaving:'||l_proc,10);
452: --
453: End chk_forwarded_to_position_id;
454: --
455: -- ----------------------------------------------------------------------------

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

491: where a.position_id = p_forwarded_by_position_id;
492: --
493: Begin
494: --
495: hr_utility.set_location('Entering:'||l_proc,5);
496: --
497: l_api_updating := pqh_rht_shd.api_updating
498: (p_routing_history_id => p_routing_history_id,
499: p_object_version_number => p_object_version_number);

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

523: close c1;
524: --
525: end if;
526: --
527: hr_utility.set_location('Leaving:'||l_proc,10);
528: --
529: End chk_forwarded_by_position_id;
530: --
531: -- ----------------------------------------------------------------------------

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

567: where a.routing_category_id = p_routing_category_id;
568: --
569: Begin
570: --
571: hr_utility.set_location('Entering:'||l_proc,5);
572: --
573: l_api_updating := pqh_rht_shd.api_updating
574: (p_routing_history_id => p_routing_history_id,
575: p_object_version_number => p_object_version_number);

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

599: close c1;
600: --
601: end if;
602: --
603: hr_utility.set_location('Leaving:'||l_proc,10);
604: --
605: End chk_routing_category_id;
606: --
607: -- ----------------------------------------------------------------------------

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

639: l_api_updating boolean;
640: --
641: Begin
642: --
643: hr_utility.set_location('Entering:'||l_proc, 5);
644: --
645: l_api_updating := pqh_rht_shd.api_updating
646: (p_routing_history_id => p_routing_history_id,
647: p_object_version_number => p_object_version_number);

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

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

Line 665: hr_utility.raise_error;

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

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

667: end if;
668: --
669: end if;
670: --
671: hr_utility.set_location('Leaving:'||l_proc,10);
672: --
673: end chk_approval_cd;
674: --
675: -- ----------------------------------------------------------------------------

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

707: l_api_updating boolean;
708: --
709: Begin
710: --
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: l_api_updating := pqh_rht_shd.api_updating
714: (p_routing_history_id => p_routing_history_id,
715: p_object_version_number => p_object_version_number);

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

728: p_effective_date => p_effective_date) then
729: --
730: -- raise error as does not exist as lookup
731: --
732: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
733: hr_utility.raise_error;
734: --
735: end if;
736: --

Line 733: hr_utility.raise_error;

729: --
730: -- raise error as does not exist as lookup
731: --
732: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
733: hr_utility.raise_error;
734: --
735: end if;
736: --
737: end if;

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

735: end if;
736: --
737: end if;
738: --
739: hr_utility.set_location('Leaving:'||l_proc,10);
740: --
741: end chk_user_action_cd;
742: --
743: --

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

782: and p_effective_date between a.effective_start_date and a.effective_end_date;
783: --
784: Begin
785: --
786: hr_utility.set_location('Entering:'||l_proc,5);
787: --
788: l_api_updating := pqh_rht_shd.api_updating
789: (p_routing_history_id => p_routing_history_id,
790: p_object_version_number => p_object_version_number);

Line 810: hr_utility.set_message(8302,'PQH_INVALID_ASSIGNMENT');

806: --
807: -- raise error as FK does not relate to PK in per_all_assignments table
808: -- table.
809: --
810: hr_utility.set_message(8302,'PQH_INVALID_ASSIGNMENT');
811: hr_utility.raise_error;
812: --
813: end if;
814: --

Line 811: hr_utility.raise_error;

807: -- raise error as FK does not relate to PK in per_all_assignments table
808: -- table.
809: --
810: hr_utility.set_message(8302,'PQH_INVALID_ASSIGNMENT');
811: hr_utility.raise_error;
812: --
813: end if;
814: --
815: close c1;

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

815: close c1;
816: --
817: end if;
818: --
819: hr_utility.set_location('Leaving:'||l_proc,10);
820: --
821: End chk_forwarded_to_assignment_id;
822: --
823: -- ----------------------------------------------------------------------------

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

861: and p_effective_date between a.effective_start_date and a.effective_end_date;
862: --
863: Begin
864: --
865: hr_utility.set_location('Entering:'||l_proc,5);
866: --
867: l_api_updating := pqh_rht_shd.api_updating
868: (p_routing_history_id => p_routing_history_id,
869: p_object_version_number => p_object_version_number);

Line 889: hr_utility.set_message(8302,'PQH_INVALID_ASSIGNMENT');

885: --
886: -- raise error as FK does not relate to PK in per_all_assignments table
887: -- table.
888: --
889: hr_utility.set_message(8302,'PQH_INVALID_ASSIGNMENT');
890: hr_utility.raise_error;
891: --
892: end if;
893: --

Line 890: hr_utility.raise_error;

886: -- raise error as FK does not relate to PK in per_all_assignments table
887: -- table.
888: --
889: hr_utility.set_message(8302,'PQH_INVALID_ASSIGNMENT');
890: hr_utility.raise_error;
891: --
892: end if;
893: --
894: close c1;

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

894: close c1;
895: --
896: end if;
897: --
898: hr_utility.set_location('Leaving:'||l_proc,10);
899: --
900: End chk_forwarded_by_assignment_id;
901: --
902: -- ----------------------------------------------------------------------------

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

939: and nvl(a.enable_flag,'X') ='Y';
940: --
941: Begin
942: --
943: hr_utility.set_location('Entering:'||l_proc,5);
944: --
945: l_api_updating := pqh_rht_shd.api_updating
946: (p_routing_history_id => p_routing_history_id,
947: p_object_version_number => p_object_version_number);

Line 956: hr_utility.set_location('checking forwarded_to_role '||p_forwarded_to_role_id||l_proc,5);

952: or not l_api_updating) and
953: p_forwarded_to_role_id is not null then
954: --
955: -- check if forwarded_to_role_id value exists in pqh_roles table
956: hr_utility.set_location('checking forwarded_to_role '||p_forwarded_to_role_id||l_proc,5);
957: --
958: open c1;
959: --
960: fetch c1 into l_dummy;

Line 968: hr_utility.set_message(8302,'PQH_INVALID_ROLE');

964: --
965: -- raise error as FK does not relate to PK in pqh_roles table
966: -- table.
967: --
968: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
969: hr_utility.raise_error;
970: --
971: end if;
972: --

Line 969: hr_utility.raise_error;

965: -- raise error as FK does not relate to PK in pqh_roles table
966: -- table.
967: --
968: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
969: hr_utility.raise_error;
970: --
971: end if;
972: --
973: close c1;

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

973: close c1;
974: --
975: end if;
976: --
977: hr_utility.set_location('Leaving:'||l_proc,10);
978: --
979: End chk_forwarded_to_role_id;
980: --
981: --

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

1019: and nvl(a.enable_flag,'X') ='Y';
1020: --
1021: Begin
1022: --
1023: hr_utility.set_location('Entering:'||l_proc,5);
1024: --
1025: l_api_updating := pqh_rht_shd.api_updating
1026: (p_routing_history_id => p_routing_history_id,
1027: p_object_version_number => p_object_version_number);

Line 1036: hr_utility.set_location('checking forwarded_by_role '||p_forwarded_by_role_id||l_proc,5);

1032: or not l_api_updating) and
1033: p_forwarded_by_role_id is not null then
1034: --
1035: -- check if forwarded_by_role_id value exists in pqh_roles table
1036: hr_utility.set_location('checking forwarded_by_role '||p_forwarded_by_role_id||l_proc,5);
1037: --
1038: open c1;
1039: --
1040: fetch c1 into l_dummy;

Line 1048: hr_utility.set_message(8302,'PQH_INVALID_ROLE');

1044: --
1045: -- raise error as FK does not relate to PK in fnd_user table
1046: -- table.
1047: --
1048: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
1049: hr_utility.raise_error;
1050: --
1051: end if;
1052: --

Line 1049: hr_utility.raise_error;

1045: -- raise error as FK does not relate to PK in fnd_user table
1046: -- table.
1047: --
1048: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
1049: hr_utility.raise_error;
1050: --
1051: end if;
1052: --
1053: close c1;

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

1053: close c1;
1054: --
1055: end if;
1056: --
1057: hr_utility.set_location('Leaving:'||l_proc,10);
1058: --
1059: End chk_forwarded_by_role_id;
1060: --
1061: -- ----------------------------------------------------------------------------

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

1097: where a.user_id = p_forwarded_to_user_id;
1098: --
1099: Begin
1100: --
1101: hr_utility.set_location('Entering:'||l_proc,5);
1102: --
1103: l_api_updating := pqh_rht_shd.api_updating
1104: (p_routing_history_id => p_routing_history_id,
1105: p_object_version_number => p_object_version_number);

Line 1125: hr_utility.set_message(8302,'PQH_INVALID_USER');

1121: --
1122: -- raise error as FK does not relate to PK in fnd_user table
1123: -- table.
1124: --
1125: hr_utility.set_message(8302,'PQH_INVALID_USER');
1126: hr_utility.raise_error;
1127: --
1128: end if;
1129: --

Line 1126: hr_utility.raise_error;

1122: -- raise error as FK does not relate to PK in fnd_user table
1123: -- table.
1124: --
1125: hr_utility.set_message(8302,'PQH_INVALID_USER');
1126: hr_utility.raise_error;
1127: --
1128: end if;
1129: --
1130: close c1;

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

1130: close c1;
1131: --
1132: end if;
1133: --
1134: hr_utility.set_location('Leaving:'||l_proc,10);
1135: --
1136: End chk_forwarded_to_user_id;
1137: --
1138: --

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

1175: where a.user_id = p_forwarded_by_user_id;
1176: --
1177: Begin
1178: --
1179: hr_utility.set_location('Entering:'||l_proc,5);
1180: --
1181: l_api_updating := pqh_rht_shd.api_updating
1182: (p_routing_history_id => p_routing_history_id,
1183: p_object_version_number => p_object_version_number);

Line 1203: hr_utility.set_message(8302,'PQH_INVALID_USER');

1199: --
1200: -- raise error as FK does not relate to PK in fnd_user table
1201: -- table.
1202: --
1203: hr_utility.set_message(8302,'PQH_INVALID_USER');
1204: hr_utility.raise_error;
1205: --
1206: end if;
1207: --

Line 1204: hr_utility.raise_error;

1200: -- raise error as FK does not relate to PK in fnd_user table
1201: -- table.
1202: --
1203: hr_utility.set_message(8302,'PQH_INVALID_USER');
1204: hr_utility.raise_error;
1205: --
1206: end if;
1207: --
1208: close c1;

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

1208: close c1;
1209: --
1210: end if;
1211: --
1212: hr_utility.set_location('Leaving:'||l_proc,10);
1213: --
1214: End chk_forwarded_by_user_id;
1215: --
1216: -- ----------------------------------------------------------------------------

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

1221: --
1222: l_proc varchar2(72) := g_package||'insert_validate';
1223: --
1224: Begin
1225: hr_utility.set_location('Entering:'||l_proc, 5);
1226: --
1227: -- Call all supporting business operations
1228: --
1229: chk_routing_history_id

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

1309: p_forwarded_to_role_id => p_rec.forwarded_to_role_id,
1310: p_object_version_number => p_rec.object_version_number);
1311: --
1312: --
1313: hr_utility.set_location(' Leaving:'||l_proc, 10);
1314: End insert_validate;
1315: --
1316: -- ----------------------------------------------------------------------------
1317: -- |---------------------------< update_validate >----------------------------|

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

1321: --
1322: l_proc varchar2(72) := g_package||'update_validate';
1323: --
1324: Begin
1325: hr_utility.set_location('Entering:'||l_proc, 5);
1326: --
1327: -- Call all supporting business operations
1328: --
1329: chk_routing_history_id

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

1411: --
1412: --
1413: --
1414: --
1415: hr_utility.set_location(' Leaving:'||l_proc, 10);
1416: End update_validate;
1417: --
1418: -- ----------------------------------------------------------------------------
1419: -- |---------------------------< delete_validate >----------------------------|

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

1423: --
1424: l_proc varchar2(72) := g_package||'delete_validate';
1425: --
1426: Begin
1427: hr_utility.set_location('Entering:'||l_proc, 5);
1428: --
1429: -- Call all supporting business operations
1430: --
1431: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1427: hr_utility.set_location('Entering:'||l_proc, 5);
1428: --
1429: -- Call all supporting business operations
1430: --
1431: hr_utility.set_location(' Leaving:'||l_proc, 10);
1432: End delete_validate;
1433: --
1434: end pqh_rht_bus;