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

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

31: l_proc varchar2(72) := g_package||'set_security_group_id';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error

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

62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);
67: --
68: end set_security_group_id;
69: --
70: --

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

101: l_api_updating boolean;
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: l_api_updating := ben_xer_shd.api_updating
108: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
109: p_object_version_number => p_object_version_number);

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

129: end if;
130: --
131: end if;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 10);
134: --
135: End chk_ext_data_elmt_in_rcd_id;
136: --
137: -- ----------------------------------------------------------------------------

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

173: where a.ext_rcd_id = p_ext_rcd_id;
174: --
175: Begin
176: --
177: hr_utility.set_location('Entering:'||l_proc,5);
178: --
179: l_api_updating := ben_xer_shd.api_updating
180: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
181: p_object_version_number => p_object_version_number);

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

204: close c1;
205: --
206: end if;
207: --
208: hr_utility.set_location('Leaving:'||l_proc,10);
209: --
210: End chk_ext_rcd_id;
211: --
212: -- ----------------------------------------------------------------------------

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

248: where a.ext_data_elmt_id = p_ext_data_elmt_id;
249: --
250: Begin
251: --
252: hr_utility.set_location('Entering:'||l_proc,5);
253: --
254: l_api_updating := ben_xer_shd.api_updating
255: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
256: p_object_version_number => p_object_version_number);

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

279: close c1;
280: --
281: end if;
282: --
283: hr_utility.set_location('Leaving:'||l_proc,10);
284: --
285: End chk_ext_data_elmt_id;
286: --
287: -- ----------------------------------------------------------------------------

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

331: ;
332: --
333: Begin
334: --
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: --
338: if p_seq_num is null or p_seq_num < 1 or p_seq_num > 300
339: then

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

340: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');
341: fnd_message.raise_error;
342: end if;
343: --
344: hr_utility.set_location('Leaving:'||l_proc,10);
345: --
346: end chk_seq_num;
347: --
348: -- ----------------------------------------------------------------------------

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

394: ;
395: --
396: Begin
397: --
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: --
401: open c1;
402: fetch c1 into l_dummy;

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

404: close c1;
405: fnd_message.set_name('BEN','BEN_91954_SEQ_NOT_UNIQUE');
406: fnd_message.raise_error;
407: end if;
408: hr_utility.set_location('Leaving:'||l_proc,10);
409: --
410: end chk_seq_num_unq;
411: -- ----------------------------------------------------------------------------
412: -- |------< chk_strt_pos >------|

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

434: l_proc varchar2(72) := g_package||'chk_strt_pos';
435: --
436: Begin
437: --
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: --
441: if p_strt_pos =0 or p_strt_pos <0 then
442: fnd_message.set_name('BEN','BEN_91864_INVLD_STRT_POS');

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

442: fnd_message.set_name('BEN','BEN_91864_INVLD_STRT_POS');
443: fnd_message.raise_error;
444: end if;
445: --
446: hr_utility.set_location('Leaving:'||l_proc,10);
447: --
448: end chk_strt_pos;
449: --
450: -- ----------------------------------------------------------------------------

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

485:
486: --
487: Begin
488: --
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: l_api_updating := ben_xer_shd.api_updating
492: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
493: p_object_version_number => p_object_version_number);

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

535: --
536: end if;
537:
538: --
539: hr_utility.set_location('Leaving:'||l_proc,10);
540: --
541: end chk_sprs_cd;
542: --
543: -- ----------------------------------------------------------------------------

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

576: l_api_updating boolean;
577: --
578: Begin
579: --
580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: l_api_updating := ben_xer_shd.api_updating
583: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
584: p_object_version_number => p_object_version_number);

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

625: end if;
626: --
627: end if;
628: --
629: hr_utility.set_location('Leaving:'||l_proc,10);
630: --
631: end chk_rqd_flag;
632: --
633: -- ----------------------------------------------------------------------------

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

666: l_api_updating boolean;
667: --
668: Begin
669: --
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: l_api_updating := ben_xer_shd.api_updating
673: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
674: p_object_version_number => p_object_version_number);

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

713: end if;
714: --
715: end if;
716: --
717: hr_utility.set_location('Leaving:'||l_proc,10);
718: --
719: end chk_any_or_all_cd;
720: --
721: -- ----------------------------------------------------------------------------

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

754: l_api_updating boolean;
755: --
756: Begin
757: --
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: l_api_updating := ben_xer_shd.api_updating
761: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
762: p_object_version_number => p_object_version_number);

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

801: end if;
802: --
803: end if;
804: --
805: hr_utility.set_location('Leaving:'||l_proc,10);
806: --
807: end chk_hide_flag;
808: --
809: -- ----------------------------------------------------------------------------

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

832: l_proc varchar2(72) := g_package||'chk_elmt_id';
833: --
834: Begin
835: --
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: --
839: if p_ext_data_elmt_id is null
840: then

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

841: fnd_message.set_name('BEN','BEN_92116_DATA_ELMT_NULL');
842: fnd_message.raise_error;
843: end if;
844: --
845: hr_utility.set_location('Leaving:'||l_proc,10);
846: --
847: end chk_elmt_id;
848: --
849: -- ----------------------------------------------------------------------------

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

894: alwd_cd ben_ext_fld.alwd_in_rcd_cd%type;
895: --
896: Begin
897: --
898: hr_utility.set_location('Entering:'||l_proc, 5);
899: --
900: l_api_updating := ben_xer_shd.api_updating
901: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
902: p_object_version_number => p_object_version_number);

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

939: close c2;
940: end if;
941:
942: --
943: hr_utility.set_location('Leaving:'||l_proc,10);
944: --
945: end chk_rcd_type;
946: --
947: -- ----------------------------------------------------------------------------

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

1055:
1056: --
1057: Begin
1058: --
1059: hr_utility.set_location('Entering:'||l_proc, 5);
1060: --
1061: open c_ext_where_clause;
1062: fetch c_ext_where_clause into l_ext_where_clause_id;
1063: close c_ext_where_clause;

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

1093: end if ;
1094: close c_ext_file_group ;
1095:
1096: --
1097: hr_utility.set_location('Leaving:'||l_proc,10);
1098: --
1099: end chk_child_recs;
1100: --
1101:

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

1108: --
1109: l_proc varchar2(72) := g_package||'insert_validate';
1110: --
1111: Begin
1112: hr_utility.set_location('Entering:'||l_proc, 5);
1113: --
1114: -- Call all supporting business operations
1115: --
1116: --

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

1186: p_ext_rcd_id => p_rec.ext_rcd_id,
1187: p_ext_data_elmt_id => p_rec.ext_data_elmt_id,
1188: p_object_version_number => p_rec.object_version_number);
1189: --
1190: hr_utility.set_location(' Leaving:'||l_proc, 10);
1191: End insert_validate;
1192: --
1193: -- ----------------------------------------------------------------------------
1194: -- |---------------------------< update_validate >----------------------------|

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

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

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

1276: p_ext_rcd_id => p_rec.ext_rcd_id,
1277: p_ext_data_elmt_id => p_rec.ext_data_elmt_id,
1278: p_object_version_number => p_rec.object_version_number);
1279: --
1280: hr_utility.set_location(' Leaving:'||l_proc, 10);
1281: End update_validate;
1282: --
1283: -- ----------------------------------------------------------------------------
1284: -- |---------------------------< delete_validate >----------------------------|

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

1288: --
1289: l_proc varchar2(72) := g_package||'delete_validate';
1290: --
1291: Begin
1292: hr_utility.set_location('Entering:'||l_proc, 5);
1293: --
1294: -- Call all supporting business operations
1295: --
1296: --bug 2804169 -- check if child records exist

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

1299: chk_startup_action(False
1300: ,ben_xer_shd.g_old_rec.business_group_id
1301: ,ben_xer_shd.g_old_rec.legislation_code);
1302: --
1303: hr_utility.set_location(' Leaving:'||l_proc, 10);
1304: End delete_validate;
1305: --
1306: --
1307: -- ---------------------------------------------------------------------------

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

1326: l_proc varchar2(72) := g_package||'return_legislation_code';
1327: --
1328: begin
1329: --
1330: hr_utility.set_location('Entering:'|| l_proc, 10);
1331: --
1332: -- Ensure that all the mandatory parameter are not null
1333: --
1334: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1351: end if;
1352: --
1353: close csr_leg_code;
1354: --
1355: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1356: --
1357: return l_legislation_code;
1358: --
1359: end return_legislation_code;