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.PER_PGN_BUS dependencies on HR_UTILITY

Line 40: hr_utility.set_location('Entering:'|| l_proc, 10);

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

Line 71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

Line 100: hr_utility.set_location('Entering:'|| l_proc, 10);

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

Line 118: hr_utility.set_location(l_proc, 20);

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_pgn_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

Line 135: hr_utility.set_location(l_proc,30);

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

Line 144: hr_utility.set_location(' Leaving:'|| l_proc, 40);

140: close csr_leg_code;
141: per_pgn_bus.g_hierarchy_node_id := p_hierarchy_node_id;
142: per_pgn_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- -----------------------------------------------------------------------------

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

180: l_proc varchar2(72) := g_package||'chk_ddf';
181: l_error exception;
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: -- Check if the row is being inserted or updated and a
187: -- value has changed
188: --

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

320: );
321: --
322: end if;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: end chk_ddf;
326: --
327: --
328: -- ----------------------------------------------------------------------------

Line 363: hr_utility.set_location('Entering:'||l_proc,15);

359: --
360: l_proc varchar2(72) := g_package || 'chk_df';
361: --
362: begin
363: hr_utility.set_location('Entering:'||l_proc,15);
364: --
365: if ((p_rec.hierarchy_node_id is not null) and (
366: nvl(per_pgn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

498: ,p_attribute30_value => p_rec.attribute30
499: );
500: end if;
501: --
502: hr_utility.set_location(' Leaving:'||l_proc,20);
503: end chk_df;
504: --
505: -- ----------------------------------------------------------------------------
506: -- |-----------------------< chk_non_updateable_args >------------------------|

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

629: l_proc varchar2(72) := g_package||'chk_entity_id';
630: --
631: Begin
632: --
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- Check mandatory parameters have been set
636: --
637: hr_api.mandatory_arg_error

Line 643: hr_utility.set_location(l_proc, 10);

639: ,p_argument => 'entity_id'
640: ,p_argument_value => p_entity_id
641: );
642: --
643: hr_utility.set_location(l_proc, 10);
644: --
645: if nvl(per_pgn_shd.g_old_rec.entity_id, hr_api.g_varchar2) <>
646: nvl(p_entity_id, hr_api.g_varchar2) then
647: --

Line 650: hr_utility.set_location(l_proc, 20);

646: nvl(p_entity_id, hr_api.g_varchar2) then
647: --
648: if p_node_type = 'PAR' then
649: --
650: hr_utility.set_location(l_proc, 20);
651: --
652: open csr_org_exists;
653: --
654: fetch csr_org_exists into l_ent_exists;

Line 664: hr_utility.set_location(l_proc, 30);

660: --
661: close csr_org_exists;
662: elsif p_node_type = 'LOC' then
663: --
664: hr_utility.set_location(l_proc, 30);
665: --
666: open csr_loc_exists;
667: fetch csr_loc_exists into l_ent_exists;
668: if csr_loc_exists%notfound then

Line 677: hr_utility.set_location(l_proc, 30);

673: close csr_loc_exists;
674: end if;
675: elsif p_node_type = 'EST' then
676: --
677: hr_utility.set_location(l_proc, 30);
678: --
679: open csr_loc_extra_exists;
680: fetch csr_loc_extra_exists into l_ent_exists;
681: if csr_loc_extra_exists%notfound then

Line 690: -- hr_utility.set_location(l_proc, 50);

686: close csr_loc_extra_exists;
687: end if;
688: -- else
689: --
690: -- hr_utility.set_location(l_proc, 50);
691: -- fnd_message.set_name('PER', 'HR_289063_INV_NODE_TYPE');
692: -- fnd_message.raise_error;
693: --
694: end if;

Line 696: hr_utility.set_location(l_proc, 60);

692: -- fnd_message.raise_error;
693: --
694: end if;
695: --
696: hr_utility.set_location(l_proc, 60);
697: --
698: -- changes are done Nitesh
699:
700: if p_node_type IN ('EST','PAR','LOC') then

Line 715: hr_utility.set_location('Leaving: '||l_proc, 70);

711: end if;
712:
713: end if;
714: --
715: hr_utility.set_location('Leaving: '||l_proc, 70);
716: --
717: end chk_entity_id;
718: --
719: --

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

739: where hierarchy_version_id = p_hierarchy_version_id;
740: --
741: Begin
742: --
743: hr_utility.set_location('Entering:'||l_proc, 5);
744: --
745: --
746: l_api_updating := per_pgn_shd.api_updating
747: (p_hierarchy_node_id => p_hierarchy_node_id

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

763: close csr_hier_vers;
764: end if;
765: --
766: end if;
767: hr_utility.set_location('Leaving: '||l_proc, 10);
768: end chk_hierarchy_version_id;
769: --
770: --
771: --

Line 799: hr_utility.set_location('Entering:'|| l_proc, 10);

795: l_seq c1%ROWTYPE;
796: --
797: BEGIN
798: --
799: hr_utility.set_location('Entering:'|| l_proc, 10);
800: --
801: --
802: -- Check if the sequence number is unique for a given parent
803: hr_utility.set_location(l_proc, 20);

Line 803: hr_utility.set_location(l_proc, 20);

799: hr_utility.set_location('Entering:'|| l_proc, 10);
800: --
801: --
802: -- Check if the sequence number is unique for a given parent
803: hr_utility.set_location(l_proc, 20);
804: --
805: l_api_updating := per_pgn_shd.api_updating
806: (p_hierarchy_node_id => p_hierarchy_node_id
807: ,p_object_version_number => p_object_version_number);

Line 822: hr_utility.set_location(l_proc, 30);

818: fnd_message.raise_error;
819: end if;
820: close c1;
821: --
822: hr_utility.set_location(l_proc, 30);
823: --
824: if p_seq < 0 then
825: fnd_message.set_name('PER', 'HR_289082_PGN_NEG_SEQ');
826: fnd_message.raise_error;

Line 830: hr_utility.set_location('Leaving:'||l_proc, 40);

826: fnd_message.raise_error;
827: end if;
828: --
829: end if;
830: hr_utility.set_location('Leaving:'||l_proc, 40);
831: --
832: END chk_seq;
833: --
834: --

Line 861: hr_utility.set_location('Entering:'|| l_proc, 10);

857: --
858: --
859: BEGIN
860: --
861: hr_utility.set_location('Entering:'|| l_proc, 10);
862: --
863: -- Check mandatory parameters have been set
864: --
865: hr_utility.set_location(l_proc, 20);

Line 865: hr_utility.set_location(l_proc, 20);

861: hr_utility.set_location('Entering:'|| l_proc, 10);
862: --
863: -- Check mandatory parameters have been set
864: --
865: hr_utility.set_location(l_proc, 20);
866: --
867: hr_api.mandatory_arg_error
868: (p_api_name => l_proc
869: ,p_argument => 'effective date'

Line 874: hr_utility.set_location(l_proc, 30);

870: ,p_argument_value => p_effective_date
871: );
872: --
873: -- Check if the node type is valid
874: hr_utility.set_location(l_proc, 30);
875: --
876: l_api_updating := per_pgn_shd.api_updating
877: (p_hierarchy_node_id => p_hierarchy_node_id
878: ,p_object_version_number => p_object_version_number);

Line 895: hr_utility.set_location(l_proc, 40);

891: fnd_message.raise_error;
892: --
893: end if;
894: --
895: hr_utility.set_location(l_proc, 40);
896: --
897: if p_node_type = 'PAR' then
898: open c1;
899: fetch c1 into l_exists;

Line 909: hr_utility.set_location('Leaving:'||l_proc, 50);

905: end if;
906: --
907: end if;
908: --
909: hr_utility.set_location('Leaving:'||l_proc, 50);
910: --
911: END chk_node_type;
912: --
913: --

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

933: where hierarchy_version_id = p_hierarchy_version_id
934: and hierarchy_node_id = p_parent_hierarchy_node_id;
935: Begin
936: --
937: hr_utility.set_location('Entering:'||l_proc, 5);
938: -- Check mandatory parameters
939: --
940: hr_utility.set_location(l_proc, 10);
941: --

Line 940: hr_utility.set_location(l_proc, 10);

936: --
937: hr_utility.set_location('Entering:'||l_proc, 5);
938: -- Check mandatory parameters
939: --
940: hr_utility.set_location(l_proc, 10);
941: --
942: hr_api.mandatory_arg_error
943: (p_api_name => l_proc
944: ,p_argument => 'hierarchy_version_id'

Line 958: hr_utility.set_location(l_proc, 20);

954: nvl(p_parent_hierarchy_node_id, hr_api.g_number))
955: or
956: NOT l_api_updating) then
957: --
958: hr_utility.set_location(l_proc, 20);
959: --
960: if p_parent_hierarchy_node_id is not null then
961: --
962: hr_utility.set_location(l_proc, 30);

Line 962: hr_utility.set_location(l_proc, 30);

958: hr_utility.set_location(l_proc, 20);
959: --
960: if p_parent_hierarchy_node_id is not null then
961: --
962: hr_utility.set_location(l_proc, 30);
963: --
964: open csr_par_node;
965: fetch csr_par_node into l_exists;
966: if csr_par_node%notfound then

Line 975: hr_utility.set_location(l_proc, 40);

971: close csr_par_node;
972: end if;
973: else
974: --
975: hr_utility.set_location(l_proc, 40);
976: --
977: -- if p_node_type <> 'PAR' then
978: -- fnd_message.set_name('PER', 'HR_289069_PGN_PARENT_ID');
979: -- fnd_message.raise_error;

Line 983: hr_utility.set_location('Leaving:'||l_proc,50);

979: -- fnd_message.raise_error;
980: -- end if;
981: end if;
982: end if;
983: hr_utility.set_location('Leaving:'||l_proc,50);
984: end chk_parent_hierarchy_node_id;
985: --
986: --
987: -- ----------------------------------------------------------------------------

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

1007: where hierarchy_node_id = p_hierarchy_node_id;
1008: --
1009: Begin
1010: --
1011: hr_utility.set_location('Entering :'||l_proc, 5);
1012: -- Check mandatory arguments
1013: --
1014: hr_utility.set_location(l_proc, 10);
1015: --

Line 1014: hr_utility.set_location(l_proc, 10);

1010: --
1011: hr_utility.set_location('Entering :'||l_proc, 5);
1012: -- Check mandatory arguments
1013: --
1014: hr_utility.set_location(l_proc, 10);
1015: --
1016: -- Check if the node has children
1017: --
1018: hr_utility.set_location(l_proc, 20);

Line 1018: hr_utility.set_location(l_proc, 20);

1014: hr_utility.set_location(l_proc, 10);
1015: --
1016: -- Check if the node has children
1017: --
1018: hr_utility.set_location(l_proc, 20);
1019: --
1020: open csr_node_id;
1021: fetch csr_node_id into l_exists;
1022: if csr_node_id%notfound then

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

1039: fnd_message.raise_error;
1040: end if;
1041:
1042: --
1043: hr_utility.set_location('Leaving :'||l_proc, 10);
1044: --
1045: end chk_delete;
1046: --
1047: --

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

1055: --
1056: l_proc varchar2(72) := g_package||'insert_validate';
1057: --
1058: Begin
1059: hr_utility.set_location('Entering:'||l_proc, 5);
1060: --
1061: -- Call all supporting business operations
1062: --
1063: if p_rec.business_group_id is not null then

Line 1067: hr_utility.set_location(l_proc, 10);

1063: if p_rec.business_group_id is not null then
1064: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1065: end if;
1066: --
1067: hr_utility.set_location(l_proc, 10);
1068: --
1069: -- Validate Entity ID
1070: -- ==================
1071: --

Line 1079: hr_utility.set_location(l_proc, 20);

1075: , p_node_type => p_rec.node_type
1076: , p_hierarchy_version_id => p_rec.hierarchy_version_id
1077: );
1078: --
1079: hr_utility.set_location(l_proc, 20);
1080: --
1081: -- Validate Hierarchy Version ID
1082: -- =============================
1083: --

Line 1090: hr_utility.set_location(l_proc, 30);

1086: , p_hierarchy_node_id => p_rec.hierarchy_node_id
1087: , p_object_version_number => p_rec.object_version_number
1088: );
1089: --
1090: hr_utility.set_location(l_proc, 30);
1091: --
1092: -- Validate Sequence (Seq)
1093: -- ========================
1094: --

Line 1103: hr_utility.set_location(l_proc, 40);

1099: ,p_hierarchy_node_id => p_rec.hierarchy_node_id
1100: ,p_object_version_number => p_rec.object_version_number
1101: );
1102: --
1103: hr_utility.set_location(l_proc, 40);
1104: --
1105: -- Validate Hierarchy Node Type
1106: -- ============================
1107: --

Line 1116: hr_utility.set_location(l_proc, 50);

1112: ,p_hierarchy_version_id => p_rec.hierarchy_version_id
1113: ,p_object_version_number => p_rec.object_version_number
1114: );
1115: --
1116: hr_utility.set_location(l_proc, 50);
1117: --
1118: -- Validate Parent Hierarchy Node ID
1119: -- ================================
1120: --

Line 1129: hr_utility.set_location(l_proc, 60);

1125: , p_hierarchy_node_id => p_rec.hierarchy_node_id
1126: , p_object_version_number => p_rec.object_version_number
1127: );
1128: --
1129: hr_utility.set_location(l_proc, 60);
1130: --
1131: --
1132: -- Call developer descriptive flexfield validation routines
1133: per_pgn_bus.chk_ddf(p_rec);

Line 1135: hr_utility.set_location(l_proc, 65);

1131: --
1132: -- Call developer descriptive flexfield validation routines
1133: per_pgn_bus.chk_ddf(p_rec);
1134: --
1135: hr_utility.set_location(l_proc, 65);
1136: --
1137: per_pgn_bus.chk_df(p_rec);
1138: --
1139: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1139: hr_utility.set_location(' Leaving:'||l_proc, 70);

1135: hr_utility.set_location(l_proc, 65);
1136: --
1137: per_pgn_bus.chk_df(p_rec);
1138: --
1139: hr_utility.set_location(' Leaving:'||l_proc, 70);
1140: End insert_validate;
1141: --
1142: -- ----------------------------------------------------------------------------
1143: -- |---------------------------< update_validate >----------------------------|

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

1149: --
1150: l_proc varchar2(72) := g_package||'update_validate';
1151: --
1152: Begin
1153: hr_utility.set_location('Entering:'||l_proc, 5);
1154: --
1155: -- Call all supporting business operations
1156: --
1157: if p_rec.business_group_id is not null then

Line 1167: hr_utility.set_location(l_proc, 10);

1163: ,p_rec => p_rec
1164: );
1165: --
1166: --
1167: hr_utility.set_location(l_proc, 10);
1168: --
1169: -- Validate Entity ID
1170: -- ==================
1171: --

Line 1179: hr_utility.set_location(l_proc, 20);

1175: , p_node_type => p_rec.node_type
1176: , p_hierarchy_version_id => p_rec.hierarchy_version_id
1177: );
1178: --
1179: hr_utility.set_location(l_proc, 20);
1180: --
1181: -- Validate Hierarchy Version ID
1182: -- =============================
1183: --

Line 1190: hr_utility.set_location(l_proc, 30);

1186: , p_hierarchy_node_id => p_rec.hierarchy_node_id
1187: , p_object_version_number => p_rec.object_version_number
1188: );
1189: --
1190: hr_utility.set_location(l_proc, 30);
1191: --
1192: -- Validate Sequence (Seq)
1193: -- ========================
1194: --

Line 1203: hr_utility.set_location(l_proc, 40);

1199: ,p_hierarchy_node_id => p_rec.hierarchy_node_id
1200: ,p_object_version_number => p_rec.object_version_number
1201: );
1202: --
1203: hr_utility.set_location(l_proc, 40);
1204: --
1205: -- Validate Parent Hierarchy Node ID
1206: -- ================================
1207: --

Line 1216: hr_utility.set_location(l_proc, 50);

1212: , p_hierarchy_node_id => p_rec.hierarchy_node_id
1213: , p_object_version_number => p_rec.object_version_number
1214: );
1215: --
1216: hr_utility.set_location(l_proc, 50);
1217: --
1218: --
1219: -- Call developer descriptive flexfield validation routines
1220: per_pgn_bus.chk_ddf(p_rec);

Line 1222: hr_utility.set_location(' Leaving:'||l_proc, 60);

1218: --
1219: -- Call developer descriptive flexfield validation routines
1220: per_pgn_bus.chk_ddf(p_rec);
1221: --
1222: hr_utility.set_location(' Leaving:'||l_proc, 60);
1223: --
1224: per_pgn_bus.chk_df(p_rec);
1225: --
1226: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1226: hr_utility.set_location(' Leaving:'||l_proc, 70);

1222: hr_utility.set_location(' Leaving:'||l_proc, 60);
1223: --
1224: per_pgn_bus.chk_df(p_rec);
1225: --
1226: hr_utility.set_location(' Leaving:'||l_proc, 70);
1227: End update_validate;
1228: --
1229: -- ----------------------------------------------------------------------------
1230: -- |---------------------------< delete_validate >----------------------------|

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

1235: --
1236: l_proc varchar2(72) := g_package||'delete_validate';
1237: --
1238: Begin
1239: hr_utility.set_location('Entering:'||l_proc, 5);
1240: --
1241: -- Call all supporting business operations
1242: --
1243: -- Verify if the node included in the record has children

Line 1246: hr_utility.set_location(l_proc, 10);

1242: --
1243: -- Verify if the node included in the record has children
1244: -- ======================================================
1245: --
1246: hr_utility.set_location(l_proc, 10);
1247: --
1248: chk_delete
1249: ( p_hierarchy_node_id => p_rec.hierarchy_node_id
1250: );

Line 1252: hr_utility.set_location(' Leaving:'||l_proc, 20);

1248: chk_delete
1249: ( p_hierarchy_node_id => p_rec.hierarchy_node_id
1250: );
1251: --
1252: hr_utility.set_location(' Leaving:'||l_proc, 20);
1253: End delete_validate;
1254: --
1255: end per_pgn_bus;