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_PGV_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_pgv_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_pgv_bus.g_hierarchy_version_id := p_hierarchy_version_id;
142: per_pgv_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 364: hr_utility.set_location('Entering:'||l_proc,10);

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

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

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

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

543: --
544: -- Only proceed with the validation if a row exists for the current
545: -- record in the HR Schema.
546: --
547: hr_utility.set_location('Entering:'|| l_proc, 10);
548: --
549: IF NOT per_pgv_shd.api_updating
550: (p_hierarchy_version_id => p_rec.hierarchy_version_id
551: ,p_object_version_number => p_rec.object_version_number

Line 562: hr_utility.set_location(l_proc, 15);

558: --
559: -- EDIT_HERE: Add checks to ensure non-updateable args have
560: -- not been updated
561: --
562: hr_utility.set_location(l_proc, 15);
563: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
564: nvl(per_pgv_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
565: l_argument := 'business_group_id';
566: RAISE l_error;

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

566: RAISE l_error;
567: END IF;
568: --
569: --
570: hr_utility.set_location(l_proc, 20);
571: --
572: IF nvl(p_rec.hierarchy_id, hr_api.g_number) <>
573: nvl(per_pgv_shd.g_old_rec.hierarchy_id, hr_api.g_number) THEN
574: l_argument := 'Hierarchy_Id';

Line 577: hr_utility.set_location('Exiting:'|| l_proc, 30);

573: nvl(per_pgv_shd.g_old_rec.hierarchy_id, hr_api.g_number) THEN
574: l_argument := 'Hierarchy_Id';
575: RAISE l_error;
576: END IF;
577: hr_utility.set_location('Exiting:'|| l_proc, 30);
578: --
579: EXCEPTION
580: WHEN l_error THEN
581: hr_api.argument_changed_error

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

631: AND hierarchy_id = p_hierarchy_id;
632: --
633: BEGIN
634: --
635: hr_utility.set_location('Entering:'|| l_proc, 10);
636: --
637: --
638: hr_api.mandatory_arg_error
639: (p_api_name => l_proc

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

646: --
647: OPEN csr_hierarchy_id;
648: FETCH csr_hierarchy_id INTO l_exists;
649: --
650: hr_utility.set_location(l_proc, 20);
651: --
652: IF csr_hierarchy_id%notfound THEN
653: fnd_message.set_name('PER', 'HR_289071_PGV_HIER_NOT_EXIST');
654: fnd_message.raise_error;

Line 661: hr_utility.set_location('Leaving:'||l_proc, 30);

657: CLOSE csr_hierarchy_id;
658: END IF;
659: --
660: --
661: hr_utility.set_location('Leaving:'||l_proc, 30);
662: --
663: END chk_hierarchy_id;
664: --
665: --

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

722: l_proc Varchar2(72):= 'chk_multiple_versions';
723: --
724: BEGIN
725: --
726: hr_utility.set_location('Entering:'||l_proc, 10);
727: --
728: Open csr_multiple_version_flag;
729: Fetch csr_multiple_version_flag into l_multiple_versions;
730: Close csr_multiple_version_flag;

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

728: Open csr_multiple_version_flag;
729: Fetch csr_multiple_version_flag into l_multiple_versions;
730: Close csr_multiple_version_flag;
731: --
732: hr_utility.set_location(l_proc, 20);
733: --
734: Open csr_version_exists;
735: Fetch csr_version_exists into l_version_exists;
736: If csr_version_exists%found and l_multiple_versions = 'N'

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

734: Open csr_version_exists;
735: Fetch csr_version_exists into l_version_exists;
736: If csr_version_exists%found and l_multiple_versions = 'N'
737: then
738: hr_utility.set_location(l_proc, 30);
739: Close csr_version_exists;
740: fnd_message.set_name('PER','HR_449061_PGV_MULTIPLE_VERSION');
741: fnd_message.raise_error;
742: else

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

742: else
743: Close csr_version_exists;
744: End if;
745: --
746: hr_utility.set_location('Leaving:'||l_proc, 40);
747: --
748: end chk_multiple_versions;
749: --
750: -- ----------------------------------------------------------------------------

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

785: l_api_updating boolean;
786: --
787: BEGIN
788: --
789: hr_utility.set_location('Entering:'|| l_proc, 10);
790: --
791: hr_utility.set_location(l_proc, 20);
792: hr_api.mandatory_arg_error
793: (p_api_name => l_proc

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

787: BEGIN
788: --
789: hr_utility.set_location('Entering:'|| l_proc, 10);
790: --
791: hr_utility.set_location(l_proc, 20);
792: hr_api.mandatory_arg_error
793: (p_api_name => l_proc
794: ,p_argument => 'version_number'
795: ,p_argument_value => p_version_number

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

794: ,p_argument => 'version_number'
795: ,p_argument_value => p_version_number
796: );
797: --
798: hr_utility.set_location(l_proc, 30);
799: l_api_updating := per_pgv_shd.api_updating
800: (p_hierarchy_version_id => p_hierarchy_version_id
801: ,p_object_version_number => p_object_version_number);
802: --

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

799: l_api_updating := per_pgv_shd.api_updating
800: (p_hierarchy_version_id => p_hierarchy_version_id
801: ,p_object_version_number => p_object_version_number);
802: --
803: hr_utility.set_location(l_proc, 40);
804: if ((l_api_updating and
805: nvl(per_pgv_shd.g_old_rec.version_number, hr_api.g_number) <>
806: nvl(p_version_number, hr_api.g_number))
807: or

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

806: nvl(p_version_number, hr_api.g_number))
807: or
808: NOT l_api_updating) then
809: --
810: hr_utility.set_location(l_proc, 50);
811: --
812: if p_version_number < 0 then
813: fnd_message.set_name('PER', 'HR_289078_PGV_VERSION_IS_NEG');
814: fnd_message.raise_error;

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

815: end if;
816: --
817: end if;
818: --
819: hr_utility.set_location('Leaving:'||l_proc, 60);
820: --
821: END chk_version_number;
822: -- ----------------------------------------------------------------------------
823: -- |-----------------------< chk_duplicate_version >--------------------------|

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

864: version_number = p_version_number;
865: --
866: BEGIN
867: --
868: hr_utility.set_location('Entering:'|| l_proc, 10);
869: --
870: hr_utility.set_location(l_proc, 20);
871: hr_api.mandatory_arg_error
872: (p_api_name => l_proc

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

866: BEGIN
867: --
868: hr_utility.set_location('Entering:'|| l_proc, 10);
869: --
870: hr_utility.set_location(l_proc, 20);
871: hr_api.mandatory_arg_error
872: (p_api_name => l_proc
873: ,p_argument => 'hierarchy_id'
874: ,p_argument_value => p_hierarchy_id

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

873: ,p_argument => 'hierarchy_id'
874: ,p_argument_value => p_hierarchy_id
875: );
876: --
877: hr_utility.set_location(l_proc, 30);
878: hr_api.mandatory_arg_error
879: (p_api_name => l_proc
880: ,p_argument => 'version_number'
881: ,p_argument_value => p_version_number

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

881: ,p_argument_value => p_version_number
882: );
883:
884: --
885: hr_utility.set_location(l_proc, 40);
886: --
887: OPEN csr_dup_version;
888: FETCH csr_dup_version INTO l_exists;
889: --

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

895: CLOSE csr_dup_version;
896: end if;
897: --
898: --
899: hr_utility.set_location('Leaving:'||l_proc, 50);
900: --
901: END chk_duplicate_version;
902: --
903: -- ----------------------------------------------------------------------------

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

974: AND hierarchy_version_id <> nvl(p_hierarchy_version_id,-1)
975: AND hierarchy_id = p_hierarchy_id;
976: --
977: BEGIN
978: hr_utility.set_location('Entering:'|| l_proc, 10);
979: --
980: hr_utility.set_location(l_proc, 20);
981: hr_api.mandatory_arg_error
982: (p_api_name => l_proc

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

976: --
977: BEGIN
978: hr_utility.set_location('Entering:'|| l_proc, 10);
979: --
980: hr_utility.set_location(l_proc, 20);
981: hr_api.mandatory_arg_error
982: (p_api_name => l_proc
983: ,p_argument => 'Date_From'
984: ,p_argument_value => p_date_from

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

983: ,p_argument => 'Date_From'
984: ,p_argument_value => p_date_from
985: );
986: --
987: hr_utility.set_location(l_proc, 40);
988: l_api_updating := per_pgv_shd.api_updating
989: (p_hierarchy_version_id => p_hierarchy_version_id
990: ,p_object_version_number => p_object_version_number);
991: --

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

988: l_api_updating := per_pgv_shd.api_updating
989: (p_hierarchy_version_id => p_hierarchy_version_id
990: ,p_object_version_number => p_object_version_number);
991: --
992: hr_utility.set_location(l_proc, 50);
993: if ((l_api_updating and
994: nvl(per_pgv_shd.g_old_rec.date_from, hr_api.g_date) <>
995: nvl(p_date_from, hr_api.g_date))
996: or

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

995: nvl(p_date_from, hr_api.g_date))
996: or
997: NOT l_api_updating) then
998: --
999: hr_utility.set_location(l_proc, 60);
1000: --
1001: -- Check date_from is between date_from and date_to for the business group
1002: --
1003: if p_business_group_id is not null then

Line 1016: hr_utility.set_location(l_proc, 70);

1012: end if;
1013: --
1014: -- Check if the DATE_FROM is before DATE_TO
1015: --
1016: hr_utility.set_location(l_proc, 70);
1017: if not p_date_from <= nvl(p_date_to,p_date_from) then
1018: fnd_message.set_name('PER', 'HR_289073_PGV_DATE_FROM_BEFORE');
1019: fnd_message.raise_error;
1020: end if;

Line 1024: hr_utility.set_location(l_proc, 75);

1020: end if;
1021: --
1022: -- Check if the DATE_FROM is not after the DATE_FROM of an existing version that is open ended
1023: --
1024: hr_utility.set_location(l_proc, 75);
1025: --
1026: --
1027: OPEN csr_other_open_ended_vers;
1028: FETCH csr_other_open_ended_vers INTO l_date_between;

Line 1038: hr_utility.set_location(l_proc, 80);

1034: CLOSE csr_other_open_ended_vers;
1035: --
1036: -- Check if the DATE_FROM is not overlaped by dates of another version.
1037: --
1038: hr_utility.set_location(l_proc, 80);
1039: --
1040: OPEN csr_other_vers;
1041: FETCH csr_other_vers INTO l_date_between;
1042: IF csr_other_vers%found THEN

Line 1050: hr_utility.set_location('Leaving:'||l_proc, 90);

1046: END IF;
1047: CLOSE csr_other_vers;
1048: --
1049: end if;
1050: hr_utility.set_location('Leaving:'||l_proc, 90);
1051: --
1052: END chk_date_from;
1053: --
1054: --

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

1119: AND hierarchy_version_id <> nvl(p_hierarchy_version_id,-1)
1120: AND hierarchy_id = p_hierarchy_id;
1121: --
1122: BEGIN
1123: hr_utility.set_location('Entering:'|| l_proc, 10);
1124: --
1125: l_date_to := nvl(p_date_to, hr_api.g_eot);
1126: --
1127: hr_utility.set_location(l_proc, 20);

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

1123: hr_utility.set_location('Entering:'|| l_proc, 10);
1124: --
1125: l_date_to := nvl(p_date_to, hr_api.g_eot);
1126: --
1127: hr_utility.set_location(l_proc, 20);
1128: --
1129: hr_utility.set_location(l_proc, 30);
1130: l_api_updating := per_pgv_shd.api_updating
1131: (p_hierarchy_version_id => p_hierarchy_version_id

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

1125: l_date_to := nvl(p_date_to, hr_api.g_eot);
1126: --
1127: hr_utility.set_location(l_proc, 20);
1128: --
1129: hr_utility.set_location(l_proc, 30);
1130: l_api_updating := per_pgv_shd.api_updating
1131: (p_hierarchy_version_id => p_hierarchy_version_id
1132: ,p_object_version_number => p_object_version_number);
1133: --

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

1130: l_api_updating := per_pgv_shd.api_updating
1131: (p_hierarchy_version_id => p_hierarchy_version_id
1132: ,p_object_version_number => p_object_version_number);
1133: --
1134: hr_utility.set_location(l_proc, 40);
1135: if ((l_api_updating and
1136: nvl(per_pgv_shd.g_old_rec.date_to, hr_api.g_date) <>
1137: nvl(p_date_to, hr_api.g_date))
1138: or

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

1137: nvl(p_date_to, hr_api.g_date))
1138: or
1139: NOT l_api_updating) then
1140: --
1141: hr_utility.set_location(l_proc, 50);
1142: --
1143: -- Check date_to is between date_from and date_to for the business group
1144: --
1145: if p_business_group_id is not null then

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

1154: end if;
1155: --
1156: -- Check if the DATE_TO is after DATE_FROM
1157: --
1158: hr_utility.set_location(l_proc, 60);
1159: if not l_date_to >= p_date_from then
1160: fnd_message.set_name('PER', 'HR_289073_PGV_DATE_FROM_BEFORE');
1161: fnd_message.raise_error;
1162: end if;

Line 1166: hr_utility.set_location(l_proc, 70);

1162: end if;
1163: --
1164: -- Check if the DATE_TO is not overlaped by dates of another version.
1165: --
1166: hr_utility.set_location(l_proc, 70);
1167: --
1168: OPEN csr_other_vers;
1169: FETCH csr_other_vers INTO l_date_between;
1170: IF csr_other_vers%found THEN

Line 1177: hr_utility.set_location('Leaving:'||l_proc, 80);

1173: fnd_message.raise_error;
1174: END IF;
1175: CLOSE csr_other_vers;
1176: --
1177: hr_utility.set_location('Leaving:'||l_proc, 80);
1178: end if;
1179: --
1180: --
1181: END chk_date_to;

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

1199: l_api_updating boolean;
1200: --
1201: Begin
1202: --
1203: hr_utility.set_location('Entering: '||l_proc, 10);
1204: --
1205: hr_api.mandatory_arg_error
1206: (p_api_name => l_proc
1207: ,p_argument => 'effective_date'

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

1207: ,p_argument => 'effective_date'
1208: ,p_argument_value => p_effective_date
1209: );
1210: --
1211: hr_utility.set_location(l_proc, 20);
1212: --
1213: l_api_updating := per_pgv_shd.api_updating
1214: (p_hierarchy_version_id => p_hierarchy_version_id
1215: ,p_object_version_number => p_object_version_number);

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

1213: l_api_updating := per_pgv_shd.api_updating
1214: (p_hierarchy_version_id => p_hierarchy_version_id
1215: ,p_object_version_number => p_object_version_number);
1216: --
1217: hr_utility.set_location(l_proc, 30);
1218: if ((l_api_updating and
1219: nvl(per_pgv_shd.g_old_rec.status, hr_api.g_varchar2) <>
1220: nvl(p_status, hr_api.g_varchar2))
1221: or

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

1230: fnd_message.set_name('PER', 'HR_289075_PGV_INV_STATUS');
1231: fnd_message.raise_error;
1232: end if;
1233: --
1234: hr_utility.set_location(l_proc, 40);
1235: --
1236: end if;
1237: --
1238: hr_utility.set_location('Leaving: '||l_proc, 50);

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

1234: hr_utility.set_location(l_proc, 40);
1235: --
1236: end if;
1237: --
1238: hr_utility.set_location('Leaving: '||l_proc, 50);
1239: --
1240: end chk_status;
1241: --
1242: --

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

1258: l_api_updating boolean;
1259: --
1260: Begin
1261: --
1262: hr_utility.set_location('Entering: '||l_proc, 10);
1263: --
1264: hr_api.mandatory_arg_error
1265: (p_api_name => l_proc
1266: ,p_argument => 'effective_date'

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

1266: ,p_argument => 'effective_date'
1267: ,p_argument_value => p_effective_date
1268: );
1269: --
1270: hr_utility.set_location(l_proc, 20);
1271: --
1272: l_api_updating := per_pgv_shd.api_updating
1273: (p_hierarchy_version_id => p_hierarchy_version_id
1274: ,p_object_version_number => p_object_version_number);

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

1272: l_api_updating := per_pgv_shd.api_updating
1273: (p_hierarchy_version_id => p_hierarchy_version_id
1274: ,p_object_version_number => p_object_version_number);
1275: --
1276: hr_utility.set_location(l_proc, 30);
1277: if ((l_api_updating and
1278: nvl(per_pgv_shd.g_old_rec.validate_flag, hr_api.g_varchar2) <>
1279: nvl(p_validate_flag, hr_api.g_varchar2))
1280: or

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

1289: fnd_message.set_name('PER', 'HR_289076_PGV_INV_VALIDATE');
1290: fnd_message.raise_error;
1291: end if;
1292: --
1293: hr_utility.set_location(l_proc, 40);
1294: --
1295: end if;
1296: --
1297: hr_utility.set_location('Leaving: '||l_proc, 50);

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

1293: hr_utility.set_location(l_proc, 40);
1294: --
1295: end if;
1296: --
1297: hr_utility.set_location('Leaving: '||l_proc, 50);
1298: --
1299: end chk_validate_flag;
1300: --
1301: --

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

1317: where hierarchy_version_id = p_hierarchy_version_id;
1318: --
1319: Begin
1320: --
1321: hr_utility.set_location('Entering: '||l_proc, 5);
1322: --
1323: hr_utility.set_location(l_proc, 10);
1324: hr_api.mandatory_arg_error
1325: (p_api_name => l_proc

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

1319: Begin
1320: --
1321: hr_utility.set_location('Entering: '||l_proc, 5);
1322: --
1323: hr_utility.set_location(l_proc, 10);
1324: hr_api.mandatory_arg_error
1325: (p_api_name => l_proc
1326: ,p_argument => 'hierarchy_version_id'
1327: ,p_argument_value => p_hierarchy_version_id

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

1328: );
1329: --
1330: -- Check if nodes of the hierarchy version exist
1331: --
1332: hr_utility.set_location(l_proc, 20);
1333: --
1334: open csr_node_exists;
1335: fetch csr_node_exists into l_exists;
1336: if csr_node_exists%notfound then

Line 1344: hr_utility.set_location('Leaving :'||l_proc, 30);

1340: fnd_message.set_name('PER', 'HR_289077_PGV_DEL_HIER_VERS');
1341: fnd_message.raise_error;
1342: end if;
1343: --
1344: hr_utility.set_location('Leaving :'||l_proc, 30);
1345: --
1346: end chk_delete;
1347: --
1348: --

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

1356: --
1357: l_proc varchar2(72) := g_package||'insert_validate';
1358: --
1359: Begin
1360: hr_utility.set_location('Entering:'||l_proc, 5);
1361: --
1362: -- Call all supporting business operations
1363: --
1364: if p_rec.business_group_id is not null then

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

1365: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1366: end if;
1367:
1368: --
1369: hr_utility.set_location(l_proc, 10);
1370: --
1371: -- Validate hierarchy_id
1372: -- ======================
1373: chk_hierarchy_id

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

1374: (p_hierarchy_id => p_rec.hierarchy_id
1375: ,p_business_group_id => p_rec.business_group_id
1376: );
1377: --
1378: hr_utility.set_location(l_proc, 20);
1379: --
1380: --
1381: -- Validate Allow Multiple Version flag
1382: -- =====================================

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

1391: ,p_hierarchy_version_id => p_rec.hierarchy_version_id
1392: ,p_object_version_number => p_rec.object_version_number
1393: );
1394: --
1395: hr_utility.set_location(l_proc, 30);
1396: --
1397: -- Validate version_number is unique
1398: -- ================================
1399: chk_duplicate_version

Line 1404: hr_utility.set_location(l_proc, 35);

1400: (p_version_number => p_rec.version_number
1401: ,p_hierarchy_id => p_rec.hierarchy_id
1402: );
1403: --
1404: hr_utility.set_location(l_proc, 35);
1405: --
1406: -- Validate date_from
1407: -- ======================
1408: chk_date_from

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

1413: ,p_business_group_id => p_rec.business_group_id
1414: ,p_object_version_number => p_rec.object_version_number
1415: );
1416: --
1417: hr_utility.set_location(l_proc, 40);
1418: --
1419: -- Validate date_to
1420: -- ======================
1421: chk_date_to

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

1427: ,p_business_group_id => p_rec.business_group_id
1428: ,p_object_version_number => p_rec.object_version_number
1429: );
1430: --
1431: hr_utility.set_location(l_proc, 50);
1432: --
1433: -- Validate Status
1434: -- ======================
1435: chk_status

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

1438: ,p_hierarchy_version_id => p_rec.hierarchy_version_id
1439: ,p_object_version_number => p_rec.object_version_number
1440: );
1441: --
1442: hr_utility.set_location(l_proc, 60);
1443: --
1444: -- Validate Validate Flag
1445: -- ======================
1446: chk_validate_flag

Line 1453: hr_utility.set_location(l_proc, 70);

1449: ,p_hierarchy_version_id => p_rec.hierarchy_version_id
1450: ,p_object_version_number => p_rec.object_version_number
1451: );
1452: --
1453: hr_utility.set_location(l_proc, 70);
1454: --
1455: per_pgv_bus.chk_ddf(p_rec);
1456:
1457: per_pgv_bus.chk_df(p_rec);

Line 1459: hr_utility.set_location(' Leaving:'||l_proc, 80);

1455: per_pgv_bus.chk_ddf(p_rec);
1456:
1457: per_pgv_bus.chk_df(p_rec);
1458: --
1459: hr_utility.set_location(' Leaving:'||l_proc, 80);
1460: End insert_validate;
1461: --
1462: -- ----------------------------------------------------------------------------
1463: -- |---------------------------< update_validate >----------------------------|

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

1469: --
1470: l_proc varchar2(72) := g_package||'update_validate';
1471: --
1472: Begin
1473: hr_utility.set_location('Entering:'||l_proc, 5);
1474: --
1475: -- Call all supporting business operations
1476: --
1477: if p_rec.business_group_id is not null then

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

1482: (p_effective_date => p_effective_date
1483: ,p_rec => p_rec
1484: );
1485: --
1486: hr_utility.set_location(l_proc, 10);
1487: --
1488: -- Validate version_number
1489: -- ======================
1490: chk_version_number

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

1493: ,p_object_version_number => p_rec.object_version_number
1494: );
1495: --
1496: --
1497: hr_utility.set_location(l_proc, 20);
1498: --
1499: -- Validate date_from
1500: -- ======================
1501: chk_date_from

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

1506: ,p_business_group_id => p_rec.business_group_id
1507: ,p_object_version_number => p_rec.object_version_number
1508: );
1509: --
1510: hr_utility.set_location(l_proc, 30);
1511: --
1512: -- Validate date_to
1513: -- ======================
1514: chk_date_to

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

1520: ,p_business_group_id => p_rec.business_group_id
1521: ,p_object_version_number => p_rec.object_version_number
1522: );
1523: --
1524: hr_utility.set_location(l_proc, 40);
1525: --
1526: -- Validate Status
1527: -- ======================
1528: chk_status

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

1531: ,p_hierarchy_version_id => p_rec.hierarchy_version_id
1532: ,p_object_version_number => p_rec.object_version_number
1533: );
1534: --
1535: hr_utility.set_location(l_proc, 50);
1536: --
1537: -- Validate Validate Flag
1538: -- ======================
1539: chk_validate_flag

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

1542: ,p_hierarchy_version_id => p_rec.hierarchy_version_id
1543: ,p_object_version_number => p_rec.object_version_number
1544: );
1545: --
1546: hr_utility.set_location(l_proc, 60);
1547: --
1548: per_pgv_bus.chk_ddf(p_rec);
1549: per_pgv_bus.chk_df(p_rec);
1550: --

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

1547: --
1548: per_pgv_bus.chk_ddf(p_rec);
1549: per_pgv_bus.chk_df(p_rec);
1550: --
1551: hr_utility.set_location(' Leaving:'||l_proc, 70);
1552: --
1553: End update_validate;
1554: --
1555: --

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

1562: --
1563: l_proc varchar2(72) := g_package||'delete_validate';
1564: --
1565: Begin
1566: hr_utility.set_location('Entering:'||l_proc, 5);
1567: --
1568: -- Call all supporting business operations
1569: --
1570: hr_utility.set_location(l_proc, 10);

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

1566: hr_utility.set_location('Entering:'||l_proc, 5);
1567: --
1568: -- Call all supporting business operations
1569: --
1570: hr_utility.set_location(l_proc, 10);
1571: --
1572: chk_delete
1573: (p_hierarchy_version_id => p_rec.hierarchy_version_id
1574: );

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

1572: chk_delete
1573: (p_hierarchy_version_id => p_rec.hierarchy_version_id
1574: );
1575: --
1576: hr_utility.set_location(' Leaving:'||l_proc, 20);
1577: End delete_validate;
1578: --
1579: end per_pgv_bus;