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_SPS_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_sps_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_sps_bus.g_step_id := p_step_id;
154: per_sps_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 201: hr_utility.set_location('Entering:'||l_proc, 10);

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

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

234: end if;
235: --
236: end if;
237: --
238: hr_utility.set_location('Leaving:'||l_proc, 20);
239: --
240: End chk_step_id;
241: --
242: --

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

312: and pgs.parent_spine_id = psp.parent_spine_id;
313: --
314: begin
315:
316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Check mandatory parameters have been set
319: --
320: hr_api.mandatory_arg_error

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

337: hr_api.g_number) = nvl(p_spinal_point_id, hr_api.g_number)) then
338: return;
339: end if;
340:
341: hr_utility.set_location(l_proc, 20);
342:
343: open csr_valid_spinal_point;
344: fetch csr_valid_spinal_point into l_exists;
345: if csr_valid_spinal_point%notfound then

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

349: --
350: end if;
351: close csr_valid_spinal_point;
352:
353: hr_utility.set_location(l_proc, 30);
354:
355: --
356: -- check parent_spine_id in per_spinal_points is the same as
357: -- parent_spine_id in per_grade_spines_f

Line 364: hr_utility.set_message(800, 'HR_289286_PARENT_SPINE_INVALID');

360: fetch csr_valid_parent_spine into l_exists;
361: if csr_valid_parent_spine%notfound then
362: close csr_valid_parent_spine;
363: --
364: hr_utility.set_message(800, 'HR_289286_PARENT_SPINE_INVALID');
365: hr_utility.raise_error;
366: --
367: end if;
368: close csr_valid_parent_spine;

Line 365: hr_utility.raise_error;

361: if csr_valid_parent_spine%notfound then
362: close csr_valid_parent_spine;
363: --
364: hr_utility.set_message(800, 'HR_289286_PARENT_SPINE_INVALID');
365: hr_utility.raise_error;
366: --
367: end if;
368: close csr_valid_parent_spine;
369:

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

366: --
367: end if;
368: close csr_valid_parent_spine;
369:
370: hr_utility.set_location(' Leaving:'|| l_proc, 40);
371:
372: end chk_spinal_point_id;
373: --
374: -- ---------------------------------------------------------------------------

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

428: pgs.effective_start_date and pgs.effective_end_date;
429: --
430: begin
431:
432: hr_utility.set_location('Entering:'|| l_proc, 10);
433: --
434: -- Check mandatory parameters have been set
435: --
436: hr_api.mandatory_arg_error

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

453: hr_api.g_number) = nvl(p_grade_spine_id, hr_api.g_number)) then
454: return;
455: end if;
456:
457: hr_utility.set_location(l_proc, 20);
458:
459: open csr_valid_grade_spine;
460: fetch csr_valid_grade_spine into l_exists;
461: if csr_valid_grade_spine%notfound then

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

465: --
466: end if;
467: close csr_valid_grade_spine;
468:
469: hr_utility.set_location(' Leaving:'|| l_proc, 30);
470:
471: end chk_grade_spine_id;
472: --
473: -- ---------------------------------------------------------------------------

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

523: and psp.sequence = p_sequence;
524: --
525: begin
526:
527: hr_utility.set_location('Entering:'|| l_proc, 10);
528: --
529: -- Check mandatory parameters have been set
530: --
531: hr_api.mandatory_arg_error

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

548: hr_api.g_number) = nvl(p_sequence, hr_api.g_number)) then
549: return;
550: end if;
551:
552: hr_utility.set_location(l_proc, 20);
553:
554: open csr_valid_sequence;
555: fetch csr_valid_sequence into l_exists;
556: if csr_valid_sequence%notfound then

Line 559: hr_utility.set_message(800, 'HR_289568_INV_STEP_SEQUENCE');

555: fetch csr_valid_sequence into l_exists;
556: if csr_valid_sequence%notfound then
557: close csr_valid_sequence;
558: --
559: hr_utility.set_message(800, 'HR_289568_INV_STEP_SEQUENCE');
560: hr_utility.raise_error;
561: --
562: end if;
563: close csr_valid_sequence;

Line 560: hr_utility.raise_error;

556: if csr_valid_sequence%notfound then
557: close csr_valid_sequence;
558: --
559: hr_utility.set_message(800, 'HR_289568_INV_STEP_SEQUENCE');
560: hr_utility.raise_error;
561: --
562: end if;
563: close csr_valid_sequence;
564:

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

561: --
562: end if;
563: close csr_valid_sequence;
564:
565: hr_utility.set_location(' Leaving:'|| l_proc, 30);
566:
567: end chk_sequence;
568: --
569: -- ---------------------------------------------------------------------------

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

626: and effective_end_date);
627: --
628: begin
629:
630: hr_utility.set_location('Entering:'|| l_proc, 10);
631: --
632: -- Only proceed with validation if :
633: -- a) The current g_old_rec is current and
634: -- b) The value for spinal_point_id and grade_spine_id have changed

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

645: = nvl(p_grade_spine_id, hr_api.g_number)
646: ) then
647: return;
648: end if;
649: hr_utility.set_location(l_proc, 20);
650:
651: open csr_uniq_step_point;
652: fetch csr_uniq_step_point into l_exists;
653: if csr_uniq_step_point%found then

Line 656: hr_utility.set_message(800, 'HR_7936_GRDPSN_POINT_EXISTS');

652: fetch csr_uniq_step_point into l_exists;
653: if csr_uniq_step_point%found then
654: close csr_uniq_step_point;
655: --
656: hr_utility.set_message(800, 'HR_7936_GRDPSN_POINT_EXISTS');
657: hr_utility.raise_error;
658: --
659: end if;
660: close csr_uniq_step_point;

Line 657: hr_utility.raise_error;

653: if csr_uniq_step_point%found then
654: close csr_uniq_step_point;
655: --
656: hr_utility.set_message(800, 'HR_7936_GRDPSN_POINT_EXISTS');
657: hr_utility.raise_error;
658: --
659: end if;
660: close csr_uniq_step_point;
661:

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

658: --
659: end if;
660: close csr_uniq_step_point;
661:
662: hr_utility.set_location(' Leaving:'|| l_proc, 30);
663:
664: end chk_uniq_step_points;
665: --
666: --

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

758: -- end of fix for 4096238
759: --
760: begin
761: --
762: hr_utility.set_location('Entering:'||l_proc, 10);
763: --
764: -- Needs to be checked the existence of child records
765: -- based on the DT mode
766: if p_datetrack_mode = hr_api.g_delete then

Line 776: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');

772: open csr_spinal_point(l_date);
773: fetch csr_spinal_point into l_exists1;
774: close csr_spinal_point;
775: if l_exists1 = 'X' then
776: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');
777: hr_utility.raise_error;
778: end if;
779: --
780: hr_utility.set_location(l_proc, 20);

Line 777: hr_utility.raise_error;

773: fetch csr_spinal_point into l_exists1;
774: close csr_spinal_point;
775: if l_exists1 = 'X' then
776: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');
777: hr_utility.raise_error;
778: end if;
779: --
780: hr_utility.set_location(l_proc, 20);
781: -- Check on per_all_assignments_f

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

776: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');
777: hr_utility.raise_error;
778: end if;
779: --
780: hr_utility.set_location(l_proc, 20);
781: -- Check on per_all_assignments_f
782: open csr_assignment(l_date);
783: fetch csr_assignment into l_exists2;
784: close csr_assignment;

Line 786: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');

782: open csr_assignment(l_date);
783: fetch csr_assignment into l_exists2;
784: close csr_assignment;
785: if l_exists2 = 'X' then
786: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');
787: hr_utility.raise_error;
788: end if;
789: --
790: hr_utility.set_location(l_proc, 30);

Line 787: hr_utility.raise_error;

783: fetch csr_assignment into l_exists2;
784: close csr_assignment;
785: if l_exists2 = 'X' then
786: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');
787: hr_utility.raise_error;
788: end if;
789: --
790: hr_utility.set_location(l_proc, 30);
791: -- Check on hr_all_positions_f

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

786: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');
787: hr_utility.raise_error;
788: end if;
789: --
790: hr_utility.set_location(l_proc, 30);
791: -- Check on hr_all_positions_f
792: open csr_position(l_date);
793: fetch csr_position into l_exists3;
794: close csr_position;

Line 796: hr_utility.set_message(801, 'HR_289566_DEL_STEP_POSITION');

792: open csr_position(l_date);
793: fetch csr_position into l_exists3;
794: close csr_position;
795: if l_exists3 = 'X' then
796: hr_utility.set_message(801, 'HR_289566_DEL_STEP_POSITION');
797: hr_utility.raise_error;
798: end if;
799:
800: -- start of bug fix 4096238

Line 797: hr_utility.raise_error;

793: fetch csr_position into l_exists3;
794: close csr_position;
795: if l_exists3 = 'X' then
796: hr_utility.set_message(801, 'HR_289566_DEL_STEP_POSITION');
797: hr_utility.raise_error;
798: end if;
799:
800: -- start of bug fix 4096238
801:

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

806: open csr_ceiling_chk;
807: fetch csr_ceiling_chk into l_ceil_id;
808: close csr_ceiling_chk;
809: if l_ceil_id = 'X' then
810: hr_utility.set_location(l_proc, 40);
811: hr_utility.set_message(800, 'HR_449730_DEL_CEI_FUT_PAST');
812: hr_utility.raise_error;
813: end if;
814: end if;

Line 811: hr_utility.set_message(800, 'HR_449730_DEL_CEI_FUT_PAST');

807: fetch csr_ceiling_chk into l_ceil_id;
808: close csr_ceiling_chk;
809: if l_ceil_id = 'X' then
810: hr_utility.set_location(l_proc, 40);
811: hr_utility.set_message(800, 'HR_449730_DEL_CEI_FUT_PAST');
812: hr_utility.raise_error;
813: end if;
814: end if;
815: l_ceil_id :=Null;

Line 812: hr_utility.raise_error;

808: close csr_ceiling_chk;
809: if l_ceil_id = 'X' then
810: hr_utility.set_location(l_proc, 40);
811: hr_utility.set_message(800, 'HR_449730_DEL_CEI_FUT_PAST');
812: hr_utility.raise_error;
813: end if;
814: end if;
815: l_ceil_id :=Null;
816: if ( not p_called_from_del_grd_scale ) and (p_datetrack_mode = hr_api.g_delete ) then

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

817: open csr_ceiling_chk2;
818: fetch csr_ceiling_chk2 into l_ceil_id;
819: close csr_ceiling_chk2;
820: if l_ceil_id = 'X' then
821: hr_utility.set_location(l_proc, 50);
822: hr_utility.set_message(800, 'HR_449731_END_CEI_EXISTS');
823: hr_utility.raise_error;
824: end if;
825: end if;

Line 822: hr_utility.set_message(800, 'HR_449731_END_CEI_EXISTS');

818: fetch csr_ceiling_chk2 into l_ceil_id;
819: close csr_ceiling_chk2;
820: if l_ceil_id = 'X' then
821: hr_utility.set_location(l_proc, 50);
822: hr_utility.set_message(800, 'HR_449731_END_CEI_EXISTS');
823: hr_utility.raise_error;
824: end if;
825: end if;
826:

Line 823: hr_utility.raise_error;

819: close csr_ceiling_chk2;
820: if l_ceil_id = 'X' then
821: hr_utility.set_location(l_proc, 50);
822: hr_utility.set_message(800, 'HR_449731_END_CEI_EXISTS');
823: hr_utility.raise_error;
824: end if;
825: end if;
826:
827: --

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

826:
827: --
828: -- end of bug fix 4096238
829: --
830: hr_utility.set_location(' Leaving:' || l_proc, 99);
831: --
832: -- End of fix 3439542
833: end chk_delete;
834: --

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

866: --
867: l_proc varchar2(72) := g_package || 'chk_ddf';
868: --
869: begin
870: hr_utility.set_location('Entering:'||l_proc,10);
871: --
872: if ((p_rec.step_id is not null) and (
873: nvl(per_sps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
874: nvl(p_rec.information1, hr_api.g_varchar2) or

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

1005: ,p_attribute30_value => p_rec.information30
1006: );
1007: end if;
1008: --
1009: hr_utility.set_location(' Leaving:'||l_proc,20);
1010: end chk_ddf;
1011: --
1012: -- ----------------------------------------------------------------------------
1013: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1242: --
1243: l_proc varchar2(72) := g_package||'dt_delete_validate';
1244: --
1245: Begin
1246: hr_utility.set_location('Entering : ' || l_proc, 10);
1247: hr_utility.trace('p_step_id : ' || p_step_id);
1248: hr_utility.trace('p_datetrack_mode : ' || p_datetrack_mode);
1249: --
1250: -- Ensure that the p_datetrack_mode argument is not null

Line 1247: hr_utility.trace('p_step_id : ' || p_step_id);

1243: l_proc varchar2(72) := g_package||'dt_delete_validate';
1244: --
1245: Begin
1246: hr_utility.set_location('Entering : ' || l_proc, 10);
1247: hr_utility.trace('p_step_id : ' || p_step_id);
1248: hr_utility.trace('p_datetrack_mode : ' || p_datetrack_mode);
1249: --
1250: -- Ensure that the p_datetrack_mode argument is not null
1251: --

Line 1248: hr_utility.trace('p_datetrack_mode : ' || p_datetrack_mode);

1244: --
1245: Begin
1246: hr_utility.set_location('Entering : ' || l_proc, 10);
1247: hr_utility.trace('p_step_id : ' || p_step_id);
1248: hr_utility.trace('p_datetrack_mode : ' || p_datetrack_mode);
1249: --
1250: -- Ensure that the p_datetrack_mode argument is not null
1251: --
1252: hr_api.mandatory_arg_error

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

1281: ,p_argument => 'step_id'
1282: ,p_argument_value => p_step_id
1283: );
1284: --
1285: hr_utility.set_location(l_proc, 20);
1286: --
1287: If (dt_api.rows_exist
1288: (p_base_table_name => 'per_cagr_entitlement_lines_f'
1289: ,p_base_key_column => 'step_id'

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

1295: fnd_message.set_token('TABLE_NAME','cagr entitlement lines');
1296: hr_multi_message.add;
1297: End If;
1298:
1299: hr_utility.set_location(l_proc, 30);
1300:
1301: If (dt_api.rows_exist
1302: (p_base_table_name => 'hr_all_positions_f'
1303: ,p_base_key_column => 'entry_step_id'

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

1311: End If;
1312: --
1313: End If;
1314: --
1315: hr_utility.set_location(' Leaving: ' || l_proc, 40);
1316: --
1317: Exception
1318: When Others Then
1319: --

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

1340: --
1341: l_proc varchar2(72) := g_package||'insert_validate';
1342: --
1343: Begin
1344: hr_utility.set_location('Entering:'||l_proc, 10);
1345: --
1346: -- Call all supporting business operations
1347: --
1348: hr_api.validate_bus_grp_id

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

1368: -- Validate Dependent Attributes
1369: --
1370: --
1371:
1372: hr_utility.set_location(l_proc, 20);
1373:
1374: --
1375: -- check spinal point id
1376: --

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

1382: ,p_object_version_number => p_rec.object_version_number
1383: ,p_effective_date => p_effective_date
1384: );
1385:
1386: hr_utility.set_location(l_proc, 30);
1387:
1388: --
1389: -- Check grade spine id
1390: --

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

1395: ,p_object_version_number => p_rec.object_version_number
1396: ,p_effective_date => p_effective_date
1397: );
1398:
1399: hr_utility.set_location(l_proc, 40);
1400:
1401: --
1402: -- Check sequence
1403: --

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

1409: ,p_object_version_number => p_rec.object_version_number
1410: ,p_effective_date => p_effective_date
1411: );
1412:
1413: hr_utility.set_location(l_proc, 50);
1414:
1415: --
1416: -- Check the combination of spinal point id and grade spine id
1417: --

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

1422: ,p_object_version_number => p_rec.object_version_number
1423: ,p_effective_date => p_effective_date
1424: );
1425:
1426: hr_utility.set_location(l_proc, 60);
1427:
1428: per_sps_bus.chk_ddf(p_rec);
1429: --
1430: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

1426: hr_utility.set_location(l_proc, 60);
1427:
1428: per_sps_bus.chk_ddf(p_rec);
1429: --
1430: hr_utility.set_location(' Leaving:'||l_proc, 70);
1431: End insert_validate;
1432: --
1433: -- ----------------------------------------------------------------------------
1434: -- |---------------------------< update_validate >----------------------------|

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

1443: --
1444: l_proc varchar2(72) := g_package||'update_validate';
1445: --
1446: Begin
1447: hr_utility.set_location('Entering:'||l_proc, 10);
1448: --
1449: -- Call all supporting business operations
1450: --
1451: hr_api.validate_bus_grp_id

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

1481: ,p_validation_start_date => p_validation_start_date
1482: ,p_validation_end_date => p_validation_end_date
1483: );
1484:
1485: hr_utility.set_location(l_proc, 20);
1486:
1487: --
1488: chk_non_updateable_args
1489: (p_effective_date => p_effective_date

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

1491: );
1492: --
1493: --
1494:
1495: hr_utility.set_location(l_proc, 30);
1496:
1497: --
1498: -- check spinal point id
1499: --

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

1505: ,p_object_version_number => p_rec.object_version_number
1506: ,p_effective_date => p_effective_date
1507: );
1508:
1509: hr_utility.set_location(l_proc, 40);
1510:
1511: --
1512: -- Check grade spine id
1513: --

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

1518: ,p_object_version_number => p_rec.object_version_number
1519: ,p_effective_date => p_effective_date
1520: );
1521:
1522: hr_utility.set_location(l_proc, 50);
1523:
1524: --
1525: -- Check sequence
1526: --

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

1532: ,p_object_version_number => p_rec.object_version_number
1533: ,p_effective_date => p_effective_date
1534: );
1535:
1536: hr_utility.set_location(l_proc, 60);
1537:
1538: --
1539: -- Check the combination of spinal point id and grade spine id
1540: --

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

1545: ,p_object_version_number => p_rec.object_version_number
1546: ,p_effective_date => p_effective_date
1547: );
1548:
1549: hr_utility.set_location(l_proc, 70);
1550:
1551: per_sps_bus.chk_ddf(p_rec);
1552: --
1553:

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

1550:
1551: per_sps_bus.chk_ddf(p_rec);
1552: --
1553:
1554: hr_utility.set_location(' Leaving:'||l_proc, 80);
1555:
1556: End update_validate;
1557: --
1558: -- ----------------------------------------------------------------------------

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

1569: --
1570: l_proc varchar2(72) := g_package||'delete_validate';
1571: --
1572: Begin
1573: hr_utility.set_location('Entering:'||l_proc, 10);
1574: --
1575: -- Call all supporting business operations
1576: --
1577: dt_delete_validate

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

1580: ,p_validation_end_date => p_validation_end_date
1581: ,p_step_id => p_rec.step_id
1582: );
1583: --
1584: hr_utility.set_location(l_proc, 20);
1585:
1586: chk_delete
1587: (p_step_id => p_rec.step_id
1588: ,p_spinal_point_id => p_rec.spinal_point_id

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

1591: ,p_datetrack_mode => p_datetrack_mode
1592: ,p_called_from_del_grd_scale => p_called_from_del_grd_scale -- bug 4096238
1593: );
1594:
1595: hr_utility.set_location(' Leaving:'||l_proc, 30);
1596: End delete_validate;
1597: --
1598: end per_sps_bus;