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

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_ldc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ler_chg_dpnt_cvg_id;
78: --
79: -- ----------------------------------------------------------------------------

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

131: and p_validation_end_date >= effective_start_date;
132: --
133: Begin
134: --
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: l_api_updating := ben_ldc_shd.api_updating
138: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id ,
139: p_effective_date => p_effective_date,

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

161: close chk_unique;
162: --
163: end if;
164: --
165: hr_utility.set_location('Leaving:'||l_proc,10);
166: --
167: end chk_ler_id;
168: --
169:

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

219: and ff.effective_end_date;
220: --
221: Begin
222: --
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: --
225: l_api_updating := ben_ldc_shd.api_updating
226: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
227: p_effective_date => p_effective_date,

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

255: close c1;
256: --
257: end if;
258: --
259: hr_utility.set_location('Leaving:'||l_proc,10);
260: --
261: end chk_cvg_eff_end_rl;
262: --
263: -- ----------------------------------------------------------------------------

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

312: and ff.effective_end_date;
313: --
314: Begin
315: --
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: l_api_updating := ben_ldc_shd.api_updating
319: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
320: p_effective_date => p_effective_date,

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

348: close c1;
349: --
350: end if;
351: --
352: hr_utility.set_location('Leaving:'||l_proc,10);
353: --
354: end chk_cvg_eff_strt_rl;
355: --
356: -- ----------------------------------------------------------------------------

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

405: and ff.effective_end_date;
406: --
407: Begin
408: --
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: l_api_updating := ben_ldc_shd.api_updating
412: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
413: p_effective_date => p_effective_date,

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

441: close c1;
442: --
443: end if;
444: --
445: hr_utility.set_location('Leaving:'||l_proc,10);
446: --
447: end chk_ler_chg_dpnt_cvg_rl;
448: --
449: -- ----------------------------------------------------------------------------

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

481: l_api_updating boolean;
482: --
483: Begin
484: --
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: --
487: l_api_updating := ben_ldc_shd.api_updating
488: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
489: p_effective_date => p_effective_date,

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

512: end if;
513: --
514: end if;
515: --
516: hr_utility.set_location('Leaving:'||l_proc,10);
517: --
518: end chk_cvg_eff_strt_cd;
519: --
520: -- ----------------------------------------------------------------------------

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

552: l_api_updating boolean;
553: --
554: Begin
555: --
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: l_api_updating := ben_ldc_shd.api_updating
559: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
560: p_effective_date => p_effective_date,

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

583: end if;
584: --
585: end if;
586: --
587: hr_utility.set_location('Leaving:'||l_proc,10);
588: --
589: end chk_cvg_eff_end_cd;
590: --
591: -- ----------------------------------------------------------------------------

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

623: l_api_updating boolean;
624: --
625: Begin
626: --
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: l_api_updating := ben_ldc_shd.api_updating
630: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
631: p_effective_date => p_effective_date,

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

654: end if;
655: --
656: end if;
657: --
658: hr_utility.set_location('Leaving:'||l_proc,10);
659: --
660: end chk_add_rmv_cvg_cd;
661: --
662: -- ----------------------------------------------------------------------------

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

713: -- have a dpnt_dsgn_cd, so we may need to add 2 more cursors here in the
714: -- future.
715: Begin
716: --
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: if p_pgm_id is not null then
720: --
721: open chk_dpnt_dsgn;

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

733: close chk_dpnt_dsgn;
734: --
735: end if;
736: --
737: hr_utility.set_location('Leaving:'||l_proc,10);
738: --
739: end chk_dpnt_dsgn_cd;
740: --
741: -- ----------------------------------------------------------------------------

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

780: l_api_updating boolean;
781: --
782: Begin
783: --
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: --
786: l_api_updating := ben_ldc_shd.api_updating
787: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
788: p_effective_date => p_effective_date,

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

829: fnd_message.raise_error;
830: end if;
831:
832: --
833: hr_utility.set_location('Leaving:'||l_proc,10);
834: --
835: end chk_ler_chg_dpnt_cvg_cd;
836: --
837: -- ----------------------------------------------------------------------------

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

873: l_api_updating boolean;
874: --
875: Begin
876: --
877: hr_utility.set_location('Entering:'||l_proc, 5);
878: --
879: l_api_updating := ben_ldc_shd.api_updating
880: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
881: p_effective_date => p_effective_date,

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

904: end if;
905: --
906: end if;
907: --
908: hr_utility.set_location('Leaving:'||l_proc,10);
909: --
910: end chk_cvg_eff_strt_dependency;
911: --
912: -- ----------------------------------------------------------------------------

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

948: l_api_updating boolean;
949: --
950: Begin
951: --
952: hr_utility.set_location('Entering:'||l_proc, 5);
953: --
954: l_api_updating := ben_ldc_shd.api_updating
955: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
956: p_effective_date => p_effective_date,

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

981: end if;
982: --
983: end if;
984: --
985: hr_utility.set_location('Leaving:'||l_proc,10);
986: --
987: end chk_cvg_eff_end_dependency;
988: --
989: -- ----------------------------------------------------------------------------

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

1025: l_api_updating boolean;
1026: --
1027: Begin
1028: --
1029: hr_utility.set_location('Entering:'||l_proc, 5);
1030: --
1031: l_api_updating := ben_ldc_shd.api_updating
1032: (p_ler_chg_dpnt_cvg_id => p_ler_chg_dpnt_cvg_id,
1033: p_effective_date => p_effective_date,

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

1058: end if;
1059: --
1060: end if;
1061: --
1062: hr_utility.set_location('Leaving:'||l_proc,10);
1063: --
1064: end chk_chg_dpnt_cvg_dependency;
1065: --
1066: -- ----------------------------------------------------------------------------

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

1108: l_integrity_error Exception;
1109: l_table_name all_tables.table_name%TYPE;
1110: --
1111: Begin
1112: hr_utility.set_location('Entering:'||l_proc, 5);
1113: --
1114: -- Ensure that the p_datetrack_mode argument is not null
1115: --
1116: hr_api.mandatory_arg_error

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

1207: End If;
1208: --
1209: End If;
1210: --
1211: hr_utility.set_location(' Leaving:'||l_proc, 10);
1212: Exception
1213: When l_integrity_error Then
1214: --
1215: -- A referential integrity check was violated therefore

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

1272: l_rows_exist Exception;
1273: l_table_name all_tables.table_name%TYPE;
1274: --
1275: Begin
1276: hr_utility.set_location('Entering:'||l_proc, 5);
1277: --
1278: -- Ensure that the p_datetrack_mode argument is not null
1279: --
1280: hr_api.mandatory_arg_error

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

1317: End If;
1318: --
1319: End If;
1320: --
1321: hr_utility.set_location(' Leaving:'||l_proc, 10);
1322: Exception
1323: When l_rows_exist Then
1324: --
1325: -- A referential integrity check was violated therefore

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

1349: --
1350: l_proc varchar2(72) := g_package||'insert_validate';
1351: --
1352: Begin
1353: hr_utility.set_location('Entering:'||l_proc, 5);
1354: --
1355: -- Call all supporting business operations
1356: --
1357: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1451: p_ler_chg_dpnt_cvg_rl => p_rec.ler_chg_dpnt_cvg_rl,
1452: p_effective_date => p_effective_date,
1453: p_object_version_number => p_rec.object_version_number);
1454: --
1455: hr_utility.set_location(' Leaving:'||l_proc, 10);
1456: End insert_validate;
1457: --
1458: -- ----------------------------------------------------------------------------
1459: -- |---------------------------< update_validate >----------------------------|

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

1467: --
1468: l_proc varchar2(72) := g_package||'update_validate';
1469: --
1470: Begin
1471: hr_utility.set_location('Entering:'||l_proc, 5);
1472: --
1473: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1474: --
1475: -- Call all supporting business operations

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

1583: p_datetrack_mode => p_datetrack_mode,
1584: p_validation_start_date => p_validation_start_date,
1585: p_validation_end_date => p_validation_end_date);
1586: --
1587: hr_utility.set_location(' Leaving:'||l_proc, 10);
1588: End update_validate;
1589: --
1590: -- ----------------------------------------------------------------------------
1591: -- |---------------------------< delete_validate >----------------------------|

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

1599: --
1600: l_proc varchar2(72) := g_package||'delete_validate';
1601: --
1602: Begin
1603: hr_utility.set_location('Entering:'||l_proc, 5);
1604: --
1605: -- Call all supporting business operations
1606: --
1607: dt_delete_validate

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

1609: p_validation_start_date => p_validation_start_date,
1610: p_validation_end_date => p_validation_end_date,
1611: p_ler_chg_dpnt_cvg_id => p_rec.ler_chg_dpnt_cvg_id);
1612: --
1613: hr_utility.set_location(' Leaving:'||l_proc, 10);
1614: End delete_validate;
1615: --
1616: --
1617: -- ---------------------------------------------------------------------------

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

1636: l_proc varchar2(72) := g_package||'return_legislation_code';
1637: --
1638: begin
1639: --
1640: hr_utility.set_location('Entering:'|| l_proc, 10);
1641: --
1642: -- Ensure that all the mandatory parameter are not null
1643: --
1644: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1661: end if;
1662: --
1663: close csr_leg_code;
1664: --
1665: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1666: --
1667: return l_legislation_code;
1668: --
1669: end return_legislation_code;