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_CCT_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_cct_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cm_typ_id => p_cm_typ_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_cm_typ_id;
78: --
79: -- ----------------------------------------------------------------------------

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

114: and cm_typ_id <> nvl(p_cm_typ_id,-1)
115: and business_group_id = p_business_group_id;
116: --
117: Begin
118: hr_utility.set_location('Entering:'||l_proc, 5);
119: --
120: open c1;
121: fetch c1 into l_dummy;
122: if c1%found then

Line 128: hr_utility.set_location('Leaving:'||l_proc, 15);

124: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
125: fnd_message.raise_error;
126: end if;
127: --
128: hr_utility.set_location('Leaving:'||l_proc, 15);
129: End chk_name_unique;
130: --
131: -- ----------------------------------------------------------------------------
132: -- |------------------------< chk_rcpent_cd >-------------------------|

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

163: l_api_updating boolean;
164: --
165: Begin
166: --
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: l_api_updating := ben_cct_shd.api_updating
170: (p_cm_typ_id => p_cm_typ_id,
171: p_effective_date => p_effective_date,

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

194: end if;
195: --
196: end if;
197: --
198: hr_utility.set_location('Leaving:'||l_proc,10);
199: --
200: end chk_rcpent_cd;
201: --
202: -- ----------------------------------------------------------------------------

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

235: l_api_updating boolean;
236: --
237: Begin
238: --
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: --
241: l_api_updating := ben_cct_shd.api_updating
242: (p_cm_typ_id => p_cm_typ_id,
243: p_effective_date => p_effective_date,

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

265: end if;
266: --
267: end if;
268: --
269: hr_utility.set_location('Leaving:'||l_proc,10);
270: --
271: end chk_inspn_rqd_rl;
272: --
273: -- ----------------------------------------------------------------------------

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

305: l_api_updating boolean;
306: --
307: Begin
308: --
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: l_api_updating := ben_cct_shd.api_updating
312: (p_cm_typ_id => p_cm_typ_id,
313: p_effective_date => p_effective_date,

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

335: end if;
336: --
337: end if;
338: --
339: hr_utility.set_location('Leaving:'||l_proc,10);
340: --
341: end chk_inspn_rqd_flag;
342: --
343: -- ----------------------------------------------------------------------------

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

376: l_api_updating boolean;
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := ben_cct_shd.api_updating
383: (p_cm_typ_id => p_cm_typ_id,
384: p_effective_date => p_effective_date,

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

406: end if;
407: --
408: end if;
409: --
410: hr_utility.set_location('Leaving:'||l_proc,10);
411: --
412: end chk_to_be_sent_dt_rl;
413: --
414: -- ----------------------------------------------------------------------------

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

446: l_api_updating boolean;
447: --
448: Begin
449: --
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: l_api_updating := ben_cct_shd.api_updating
453: (p_cm_typ_id => p_cm_typ_id,
454: p_effective_date => p_effective_date,

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

478: end if;
479: --
480: end if;
481: --
482: hr_utility.set_location('Leaving:'||l_proc,10);
483: --
484: end chk_to_be_sent_dt_cd;
485: --
486: -- ----------------------------------------------------------------------------

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

518: l_api_updating boolean;
519: --
520: Begin
521: --
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: l_api_updating := ben_cct_shd.api_updating
525: (p_cm_typ_id => p_cm_typ_id,
526: p_effective_date => p_effective_date,

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

549: end if;
550: --
551: end if;
552: --
553: hr_utility.set_location('Leaving:'||l_proc,10);
554: --
555: end chk_trk_mlg_flag;
556: --
557: -- ----------------------------------------------------------------------------

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

589: l_api_updating boolean;
590: --
591: Begin
592: --
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: l_api_updating := ben_cct_shd.api_updating
596: (p_cm_typ_id => p_cm_typ_id,
597: p_effective_date => p_effective_date,

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

620: end if;
621: --
622: end if;
623: --
624: hr_utility.set_location('Leaving:'||l_proc,10);
625: --
626: end chk_pc_kit_cd;
627: --
628: -- ----------------------------------------------------------------------------

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

660: l_api_updating boolean;
661: --
662: Begin
663: --
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: l_api_updating := ben_cct_shd.api_updating
667: (p_cm_typ_id => p_cm_typ_id,
668: p_effective_date => p_effective_date,

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

691: end if;
692: --
693: end if;
694: --
695: hr_utility.set_location('Leaving:'||l_proc,10);
696: --
697: end chk_whnvr_trgrd_flag;
698: --
699: -- ----------------------------------------------------------------------------

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

732: l_api_updating boolean;
733: --
734: Begin
735: --
736: hr_utility.set_location('Entering:'||l_proc, 5);
737: --
738: l_api_updating := ben_cct_shd.api_updating
739: (p_cm_typ_id => p_cm_typ_id,
740: p_effective_date => p_effective_date,

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

772: fnd_message.raise_error;
773: End if ;
774:
775:
776: hr_utility.set_location('Leaving:'||l_proc,10);
777: --
778: end chk_cm_usg_cd;
779: --
780: -- ----------------------------------------------------------------------------

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

813: l_api_updating boolean;
814: --
815: Begin
816: --
817: hr_utility.set_location('Entering:'||l_proc, 5);
818: --
819: l_api_updating := ben_cct_shd.api_updating
820: (p_cm_typ_id => p_cm_typ_id,
821: p_effective_date => p_effective_date,

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

843: end if;
844: --
845: end if;
846: --
847: hr_utility.set_location('Leaving:'||l_proc,10);
848: --
849: end chk_cm_typ_rl;
850: --
851: -- ----------------------------------------------------------------------------

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

887: l_integrity_error Exception;
888: l_table_name all_tables.table_name%TYPE;
889: --
890: Begin
891: hr_utility.set_location('Entering:'||l_proc, 5);
892: --
893: -- Ensure that the p_datetrack_mode argument is not null
894: --
895: hr_api.mandatory_arg_error

Line 917: hr_utility.set_location('*******b4 check min/max dates', 5);

913: (p_api_name => l_proc,
914: p_argument => 'validation_end_date',
915: p_argument_value => p_validation_end_date);
916: --
917: hr_utility.set_location('*******b4 check min/max dates', 5);
918: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
919: NOT (dt_api.check_min_max_dates
920: (p_base_table_name => 'ben_cm_typ_f',
921: p_base_key_column => 'cm_typ_id',

Line 928: hr_utility.set_location('*******after check min/max dates', 5);

924: p_to_date => p_validation_end_date))) Then
925: l_table_name := 'ben_cm_typ_f';
926: Raise l_integrity_error;
927: End If;
928: hr_utility.set_location('*******after check min/max dates', 5);
929: --
930: End If;
931: --
932: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

928: hr_utility.set_location('*******after check min/max dates', 5);
929: --
930: End If;
931: --
932: hr_utility.set_location(' Leaving:'||l_proc, 10);
933: Exception
934: When l_integrity_error Then
935: --
936: -- A referential integrity check was violated therefore

Line 945: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

941: --
942: -- An unhandled or unexpected error has occurred which
943: -- we must report
944: --
945: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
946: hr_utility.set_message_token('PROCEDURE', l_proc);
947: hr_utility.set_message_token('STEP','15');
948: hr_utility.raise_error;
949: End dt_update_validate;

Line 946: hr_utility.set_message_token('PROCEDURE', l_proc);

942: -- An unhandled or unexpected error has occurred which
943: -- we must report
944: --
945: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
946: hr_utility.set_message_token('PROCEDURE', l_proc);
947: hr_utility.set_message_token('STEP','15');
948: hr_utility.raise_error;
949: End dt_update_validate;
950: --

Line 947: hr_utility.set_message_token('STEP','15');

943: -- we must report
944: --
945: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
946: hr_utility.set_message_token('PROCEDURE', l_proc);
947: hr_utility.set_message_token('STEP','15');
948: hr_utility.raise_error;
949: End dt_update_validate;
950: --
951: -- ----------------------------------------------------------------------------

Line 948: hr_utility.raise_error;

944: --
945: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
946: hr_utility.set_message_token('PROCEDURE', l_proc);
947: hr_utility.set_message_token('STEP','15');
948: hr_utility.raise_error;
949: End dt_update_validate;
950: --
951: -- ----------------------------------------------------------------------------
952: -- |--------------------------< dt_delete_validate >--------------------------|

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

993: l_rows_exist Exception;
994: l_table_name all_tables.table_name%TYPE;
995: --
996: Begin
997: hr_utility.set_location('Entering:'||l_proc, 5);
998: --
999: -- Ensure that the p_datetrack_mode argument is not null
1000: --
1001: hr_api.mandatory_arg_error

Line 1030: hr_utility.set_location('*******b4 check rows exist', 5);

1026: (p_api_name => l_proc,
1027: p_argument => 'cm_typ_id',
1028: p_argument_value => p_cm_typ_id);
1029: --
1030: hr_utility.set_location('*******b4 check rows exist', 5);
1031: If (dt_api.rows_exist
1032: (p_base_table_name => 'ben_cm_typ_f',
1033: p_base_key_column => 'parnt_cm_typ_id',
1034: p_base_key_value => p_cm_typ_id,

Line 1040: hr_utility.set_location('*******after check rows exist', 5);

1036: p_to_date => p_validation_end_date)) Then
1037: l_table_name := 'ben_cm_typ_f';
1038: Raise l_rows_exist;
1039: End If;
1040: hr_utility.set_location('*******after check rows exist', 5);
1041: If (dt_api.rows_exist
1042: (p_base_table_name => 'ben_cm_typ_trgr_f',
1043: p_base_key_column => 'cm_typ_id',
1044: p_base_key_value => p_cm_typ_id,

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

1067: End If;
1068: --
1069: End If;
1070: --
1071: hr_utility.set_location(' Leaving:'||l_proc, 10);
1072: Exception
1073: When l_rows_exist Then
1074: --
1075: -- A referential integrity check was violated therefore

Line 1084: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1080: --
1081: -- An unhandled or unexpected error has occurred which
1082: -- we must report
1083: --
1084: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1085: hr_utility.set_message_token('PROCEDURE', l_proc);
1086: hr_utility.set_message_token('STEP','15');
1087: hr_utility.raise_error;
1088: End dt_delete_validate;

Line 1085: hr_utility.set_message_token('PROCEDURE', l_proc);

1081: -- An unhandled or unexpected error has occurred which
1082: -- we must report
1083: --
1084: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1085: hr_utility.set_message_token('PROCEDURE', l_proc);
1086: hr_utility.set_message_token('STEP','15');
1087: hr_utility.raise_error;
1088: End dt_delete_validate;
1089: --

Line 1086: hr_utility.set_message_token('STEP','15');

1082: -- we must report
1083: --
1084: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1085: hr_utility.set_message_token('PROCEDURE', l_proc);
1086: hr_utility.set_message_token('STEP','15');
1087: hr_utility.raise_error;
1088: End dt_delete_validate;
1089: --
1090: -- ----------------------------------------------------------------------------

Line 1087: hr_utility.raise_error;

1083: --
1084: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1085: hr_utility.set_message_token('PROCEDURE', l_proc);
1086: hr_utility.set_message_token('STEP','15');
1087: hr_utility.raise_error;
1088: End dt_delete_validate;
1089: --
1090: -- ----------------------------------------------------------------------------
1091: -- |---------------------------< insert_validate >----------------------------|

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

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

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

1180: p_effective_date => p_effective_date,
1181: p_business_group_id => p_rec.business_group_id,
1182: p_object_version_number => p_rec.object_version_number);
1183: --
1184: hr_utility.set_location(' Leaving:'||l_proc, 10);
1185: End insert_validate;
1186: --
1187: -- ----------------------------------------------------------------------------
1188: -- |---------------------------< update_validate >----------------------------|

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

1196: --
1197: l_proc varchar2(72) := g_package||'update_validate';
1198: --
1199: Begin
1200: hr_utility.set_location('Entering:'||l_proc, 5);
1201: --
1202: -- Call all supporting business operations
1203: --
1204: --

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

1286: p_datetrack_mode => p_datetrack_mode,
1287: p_validation_start_date => p_validation_start_date,
1288: p_validation_end_date => p_validation_end_date);
1289: --
1290: hr_utility.set_location(' Leaving:'||l_proc, 10);
1291: End update_validate;
1292: --
1293: -- ----------------------------------------------------------------------------
1294: -- |---------------------------< delete_validate >----------------------------|

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

1302: --
1303: l_proc varchar2(72) := g_package||'delete_validate';
1304: --
1305: Begin
1306: hr_utility.set_location('Entering:'||l_proc, 5);
1307: --
1308: -- Call all supporting business operations
1309: --
1310: dt_delete_validate

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

1312: p_validation_start_date => p_validation_start_date,
1313: p_validation_end_date => p_validation_end_date,
1314: p_cm_typ_id => p_rec.cm_typ_id);
1315: --
1316: hr_utility.set_location(' Leaving:'||l_proc, 10);
1317: End delete_validate;
1318: --
1319: --
1320: -- ---------------------------------------------------------------------------

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

1339: l_proc varchar2(72) := g_package||'return_legislation_code';
1340: --
1341: begin
1342: --
1343: hr_utility.set_location('Entering:'|| l_proc, 10);
1344: --
1345: -- Ensure that all the mandatory parameter are not null
1346: --
1347: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1361: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

1357: close csr_leg_code;
1358: --
1359: -- The primary key is invalid therefore we must error
1360: --
1361: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1362: hr_utility.raise_error;
1363: --
1364: end if;
1365: --

Line 1362: hr_utility.raise_error;

1358: --
1359: -- The primary key is invalid therefore we must error
1360: --
1361: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1362: hr_utility.raise_error;
1363: --
1364: end if;
1365: --
1366: close csr_leg_code;

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

1364: end if;
1365: --
1366: close csr_leg_code;
1367: --
1368: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1369: --
1370: return l_legislation_code;
1371: --
1372: end return_legislation_code;