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_PGS_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := per_pgs_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: per_pgs_bus.g_grade_spine_id := p_grade_spine_id;
154: per_pgs_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

196: l_proc varchar2(72) := g_package||'chk_grade_spine_id';
197: l_api_updating boolean;
198: --
199: Begin
200: hr_utility.set_location('Entering:'||l_proc, 10);
201: --
202: l_api_updating := per_pgs_shd.api_updating
203: (p_effective_date => p_effective_date
204: ,p_grade_spine_id => p_grade_spine_id

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

226: end if;
227: --
228: end if;
229: --
230: hr_utility.set_location('Leaving:'||l_proc, 20);
231: --
232: End chk_grade_spine_id;
233: --
234: --

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

284: and pps.parent_spine_id = p_parent_spine_id;
285: --
286: begin
287:
288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: -- Check mandatory parameters have been set
291: --
292: hr_api.mandatory_arg_error

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

318: --
319: end if;
320: close csr_valid_parent_spines;
321:
322: hr_utility.set_location(' Leaving:'|| l_proc, 20);
323:
324: end chk_parent_spine_id;
325: --
326: -- ----------------------------------------------------------------------------

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

376: and nvl(pg.date_to, hr_api.g_eot);
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 10);
381:
382: --
383: --
384: -- Check mandatory parameters have been set

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

403: hr_api.g_number) = nvl(p_grade_id, hr_api.g_number)) then
404: return;
405: end if;
406:
407: hr_utility.set_location(l_proc, 20);
408:
409: --
410: -- Check that the grade_id should exist in per_grades and has the business group
411: --

Line 417: hr_utility.raise_error;

413: fetch csr_valid_grade_id into l_exists;
414: if csr_valid_grade_id%notfound then
415: close csr_valid_grade_id;
416: per_pgs_shd.constraint_error(p_constraint_name => 'PER_GRADE_SPINES_F_FK3');
417: hr_utility.raise_error;
418: end if;
419: close csr_valid_grade_id;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 30);

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

417: hr_utility.raise_error;
418: end if;
419: close csr_valid_grade_id;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 30);
422: --
423: End chk_grade_id;
424: --
425: -- ---------------------------------------------------------------------------

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

489: select per_spinal_point_steps_s.nextval
490: from sys.dual;
491: --
492: begin
493: hr_utility.set_location('Entering:'|| l_proc, 10);
494:
495: if p_ceiling_step_id is not NULL then
496: --
497: -- Only proceed with validation if :

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

508: = nvl(p_ceiling_step_id, hr_api.g_number) then
509: return;
510: else
511:
512: hr_utility.set_location(l_proc, 20);
513:
514: /* skip mandatory parameter check BUG3389808
515: --
516: -- Check mandatory parameters have been set

Line 534: hr_utility.set_message(800, 'HR_289687_SPINAL_POINT_INV');

530: fetch csr_valid_parent_spine into l_exists;
531: if csr_valid_parent_spine%notfound then
532: close csr_valid_parent_spine;
533: --
534: hr_utility.set_message(800, 'HR_289687_SPINAL_POINT_INV');
535: hr_utility.raise_error;
536: --
537: end if;
538: close csr_valid_parent_spine;

Line 535: hr_utility.raise_error;

531: if csr_valid_parent_spine%notfound then
532: close csr_valid_parent_spine;
533: --
534: hr_utility.set_message(800, 'HR_289687_SPINAL_POINT_INV');
535: hr_utility.raise_error;
536: --
537: end if;
538: close csr_valid_parent_spine;
539: */

Line 546: hr_utility.set_message(800, 'HR_289567_CEILING_STEP_INVALID');

542: fetch csr_valid_spinal_point_step into l_exists;
543: if csr_valid_spinal_point_step%notfound then
544: close csr_valid_spinal_point_step;
545: --
546: hr_utility.set_message(800, 'HR_289567_CEILING_STEP_INVALID');
547: hr_utility.raise_error;
548: --
549: end if;
550: close csr_valid_spinal_point_step;

Line 547: hr_utility.raise_error;

543: if csr_valid_spinal_point_step%notfound then
544: close csr_valid_spinal_point_step;
545: --
546: hr_utility.set_message(800, 'HR_289567_CEILING_STEP_INVALID');
547: hr_utility.raise_error;
548: --
549: end if;
550: close csr_valid_spinal_point_step;
551: end if;

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

550: close csr_valid_spinal_point_step;
551: end if;
552: else
553:
554: hr_utility.set_location(l_proc, 30);
555:
556: --
557: hr_utility.set_location(l_proc, 40);
558: --

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

553:
554: hr_utility.set_location(l_proc, 30);
555:
556: --
557: hr_utility.set_location(l_proc, 40);
558: --
559: /*
560: --
561: -- This validation was replaced by csr_valid_spinal_point_step

Line 568: hr_utility.set_message(800, 'HR_289687_SPINAL_POINT_INV');

564: fetch csr_valid_parent_spine into l_exists;
565: if csr_valid_parent_spine%notfound then
566: close csr_valid_parent_spine;
567: --
568: hr_utility.set_message(800, 'HR_289687_SPINAL_POINT_INV');
569: hr_utility.raise_error;
570: --
571: end if;
572: close csr_valid_parent_spine;

Line 569: hr_utility.raise_error;

565: if csr_valid_parent_spine%notfound then
566: close csr_valid_parent_spine;
567: --
568: hr_utility.set_message(800, 'HR_289687_SPINAL_POINT_INV');
569: hr_utility.raise_error;
570: --
571: end if;
572: close csr_valid_parent_spine;
573: */

Line 580: hr_utility.set_message(800, 'HR_289567_CEILING_STEP_INVALID');

576: fetch csr_valid_spinal_point_step into l_exists;
577: if csr_valid_spinal_point_step%notfound then
578: close csr_valid_spinal_point_step;
579: --
580: hr_utility.set_message(800, 'HR_289567_CEILING_STEP_INVALID');
581: hr_utility.raise_error;
582: --
583: end if;
584: close csr_valid_spinal_point_step;

Line 581: hr_utility.raise_error;

577: if csr_valid_spinal_point_step%notfound then
578: close csr_valid_spinal_point_step;
579: --
580: hr_utility.set_message(800, 'HR_289567_CEILING_STEP_INVALID');
581: hr_utility.raise_error;
582: --
583: end if;
584: close csr_valid_spinal_point_step;
585: end if;

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

584: close csr_valid_spinal_point_step;
585: end if;
586: end if;
587:
588: hr_utility.set_location(' Leaving:'|| l_proc, 60);
589:
590: end chk_ceiling_step_id;
591:
592: --

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

648: effective_end_date ;
649: --
650: begin
651:
652: hr_utility.set_location('Entering:'|| l_proc, 10);
653: --
654: -- Only proceed with validation if :
655: -- a) The current g_old_rec is current and
656: -- b) The value for grade_id and parent_spine_id have changed

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

668: ) then
669: return;
670: end if;
671:
672: hr_utility.set_location(l_proc, 20);
673:
674: open csr_uniq_grade_pay_scale;
675: fetch csr_uniq_grade_pay_scale into l_exists;
676: if csr_uniq_grade_pay_scale%found then

Line 679: hr_utility.set_message(800, 'PER_7932_GRDSPN_GRD_EXISTS');

675: fetch csr_uniq_grade_pay_scale into l_exists;
676: if csr_uniq_grade_pay_scale%found then
677: close csr_uniq_grade_pay_scale;
678: --
679: hr_utility.set_message(800, 'PER_7932_GRDSPN_GRD_EXISTS');
680: hr_utility.raise_error;
681: --
682: end if;
683: close csr_uniq_grade_pay_scale;

Line 680: hr_utility.raise_error;

676: if csr_uniq_grade_pay_scale%found then
677: close csr_uniq_grade_pay_scale;
678: --
679: hr_utility.set_message(800, 'PER_7932_GRDSPN_GRD_EXISTS');
680: hr_utility.raise_error;
681: --
682: end if;
683: close csr_uniq_grade_pay_scale;
684:

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

681: --
682: end if;
683: close csr_uniq_grade_pay_scale;
684:
685: hr_utility.set_location(' Leaving:'|| l_proc, 30);
686:
687: end chk_uniq_grade_pay_scale;
688:
689: --

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

752:
753: --
754: Begin
755: --
756: hr_utility.set_location('Entering:'||l_proc, 10);
757: --
758: -- Check there are no values in per_spinal_point_steps_f
759: -- and per_spinal_point_placements_f
760: --

Line 769: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');

765: If csr_spinal_point_placements%found Then
766: --
767: close csr_spinal_point_placements;
768: --
769: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');
770: hr_utility.raise_error;
771: --
772: End If;
773: --

Line 770: hr_utility.raise_error;

766: --
767: close csr_spinal_point_placements;
768: --
769: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');
770: hr_utility.raise_error;
771: --
772: End If;
773: --
774: close csr_spinal_point_placements;

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

772: End If;
773: --
774: close csr_spinal_point_placements;
775:
776: hr_utility.set_location(l_proc, 20);
777:
778: --
779: -- Check there are no values in per_all_assignments_f
780: --

Line 788: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');

784: If csr_assignments%found Then
785: --
786: close csr_assignments;
787: --
788: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');
789: hr_utility.raise_error;
790: --
791: End If;
792: --

Line 789: hr_utility.raise_error;

785: --
786: close csr_assignments;
787: --
788: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');
789: hr_utility.raise_error;
790: --
791: End If;
792: --
793: close csr_assignments;

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

791: End If;
792: --
793: close csr_assignments;
794: --
795: hr_utility.set_location(' Leaving:' || l_proc, 30);
796: --
797: end chk_delete;
798: --
799: -- ----------------------------------------------------------------------------

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

1098: --
1099: l_proc varchar2(72) := g_package||'insert_validate';
1100: --
1101: Begin
1102: hr_utility.set_location('Entering:'||l_proc, 10);
1103: --
1104: -- Call all supporting business operations
1105: --
1106: hr_api.validate_bus_grp_id

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

1116: ,p_object_version_number => p_rec.object_version_number
1117: ,p_effective_date => p_effective_date
1118: ) ;
1119:
1120: hr_utility.set_location(l_proc, 20);
1121:
1122: --
1123: -- After validating the set of important attributes,
1124: -- if Multiple Message detection is enabled and at least

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

1141: ,p_object_version_number => p_rec.object_version_number
1142: ,p_effective_date => p_effective_date
1143: );
1144:
1145: hr_utility.set_location(l_proc, 30);
1146:
1147: --
1148: -- Validate grade id
1149: --

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

1154: ,p_object_version_number => p_rec.object_version_number
1155: ,p_effective_date => p_effective_date
1156: ) ;
1157:
1158: hr_utility.set_location(l_proc, 40);
1159:
1160: --
1161: -- Validate ceiling step id
1162: --

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

1168: ,p_effective_date => p_effective_date
1169: );
1170:
1171:
1172: hr_utility.set_location(l_proc, 50);
1173:
1174: --
1175: -- Validate the combination of grade id and parent spine id
1176: --

Line 1186: hr_utility.set_location(' Leaving:'||l_proc, 100);

1182: ,p_object_version_number => p_rec.object_version_number
1183: ,p_effective_date => p_effective_date
1184: );
1185:
1186: hr_utility.set_location(' Leaving:'||l_proc, 100);
1187: End insert_validate;
1188: --
1189: -- ----------------------------------------------------------------------------
1190: -- |---------------------------< update_validate >----------------------------|

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

1199: --
1200: l_proc varchar2(72) := g_package||'update_validate';
1201: --
1202: Begin
1203: hr_utility.set_location('Entering:'||l_proc, 10);
1204: --
1205: -- Call all supporting business operations
1206: --
1207: hr_api.validate_bus_grp_id

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

1217: ,p_object_version_number => p_rec.object_version_number
1218: ,p_effective_date => p_effective_date
1219: ) ;
1220:
1221: hr_utility.set_location(l_proc, 20);
1222:
1223: --
1224: -- After validating the set of important attributes,
1225: -- if Multiple Message detection is enabled and at least

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

1241: (p_effective_date => p_effective_date
1242: ,p_rec => p_rec
1243: );
1244:
1245: hr_utility.set_location(l_proc, 30);
1246:
1247: --
1248: -- After validating the set of important attributes,
1249: -- if Multiple Message detection is enabled and at least

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

1266: ,p_object_version_number => p_rec.object_version_number
1267: ,p_effective_date => p_effective_date
1268: );
1269:
1270: hr_utility.set_location(l_proc, 40);
1271:
1272: --
1273: -- Validate grade id
1274: --

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

1279: ,p_object_version_number => p_rec.object_version_number
1280: ,p_effective_date => p_effective_date
1281: ) ;
1282:
1283: hr_utility.set_location(l_proc, 50);
1284:
1285: --
1286: -- Validate ceiling step id
1287: --

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

1293: ,p_effective_date => p_effective_date
1294: );
1295:
1296:
1297: hr_utility.set_location(l_proc, 60);
1298:
1299: --
1300: -- Validate the combination of grade id and parent spine id
1301: --

Line 1311: hr_utility.set_location(' Leaving:'||l_proc, 100);

1307: ,p_object_version_number => p_rec.object_version_number
1308: ,p_effective_date => p_effective_date
1309: );
1310: --
1311: hr_utility.set_location(' Leaving:'||l_proc, 100);
1312: End update_validate;
1313: --
1314: -- ----------------------------------------------------------------------------
1315: -- |---------------------------< delete_validate >----------------------------|

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

1324: --
1325: l_proc varchar2(72) := g_package||'delete_validate';
1326: --
1327: Begin
1328: hr_utility.set_location('Entering:'||l_proc, 5);
1329: --
1330: -- Call all supporting business operations
1331: --
1332: dt_delete_validate

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

1336: ,p_grade_spine_id => p_rec.grade_spine_id
1337: );
1338: --
1339:
1340: hr_utility.set_location(l_proc, 20);
1341:
1342: chk_delete(p_parent_spine_id => p_rec.parent_spine_id
1343: ,p_grade_id => p_rec.grade_id);
1344: --

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

1342: chk_delete(p_parent_spine_id => p_rec.parent_spine_id
1343: ,p_grade_id => p_rec.grade_id);
1344: --
1345: --
1346: hr_utility.set_location(' Leaving:'||l_proc, 30);
1347: End delete_validate;
1348: --
1349: end per_pgs_bus;