DBA Data[Home] [Help]

APPS.BEN_XRF_BUS dependencies on HR_UTILITY

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

79: l_proc varchar2(72) := g_package||'set_security_group_id';
80: --
81: begin
82: --
83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --
85: -- Ensure that all the mandatory parameter are not null
86: --
87: hr_api.mandatory_arg_error

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

110: hr_api.set_security_group_id
111: (p_security_group_id => l_security_group_id
112: );
113: --
114: hr_utility.set_location(' Leaving:'|| l_proc, 20);
115: --
116: end set_security_group_id;
117:
118: --

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

149: l_api_updating boolean;
150: --
151: Begin
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: l_api_updating := ben_xrf_shd.api_updating
156: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
157: p_object_version_number => p_object_version_number);

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

177: end if;
178: --
179: end if;
180: --
181: hr_utility.set_location('Leaving:'||l_proc, 10);
182: --
183: End chk_ext_rcd_in_file_id;
184: --
185: -- ----------------------------------------------------------------------------

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

221: where a.ext_rcd_id = p_ext_rcd_id;
222: --
223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc,5);
226: --
227: l_api_updating := ben_xrf_shd.api_updating
228: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
229: p_object_version_number => p_object_version_number);

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

252: close c1;
253: --
254: end if;
255: --
256: hr_utility.set_location('Leaving:'||l_proc,10);
257: --
258: End chk_ext_rcd_id;
259: --
260: -- ----------------------------------------------------------------------------

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

296: where a.ext_file_id = p_ext_file_id;
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := ben_xrf_shd.api_updating
303: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
304: p_object_version_number => p_object_version_number);

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

327: close c1;
328: --
329: end if;
330: --
331: hr_utility.set_location('Leaving:'||l_proc,10);
332: --
333: End chk_ext_file_id;
334: --
335: -- ----------------------------------------------------------------------------

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

369: l_api_updating boolean;
370: --
371: Begin
372: --
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: l_api_updating := ben_xrf_shd.api_updating
376: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
377: p_object_version_number => p_object_version_number);

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

418: --
419: end if; /* if (l_api_updating.... */
420:
421: --
422: hr_utility.set_location('Leaving:'||l_proc,10);
423: --
424: end chk_sprs_cd;
425: --
426: --

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

461: l_api_updating boolean;
462: --
463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_xrf_shd.api_updating
468: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
469: p_object_version_number => p_object_version_number);

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

509: end if;
510: --
511: end if;
512: --
513: hr_utility.set_location('Leaving:'||l_proc,10);
514: --
515: end chk_any_or_all_cd;
516: --
517: -- ----------------------------------------------------------------------------

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

550: l_api_updating boolean;
551: --
552: Begin
553: --
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: l_api_updating := ben_xrf_shd.api_updating
557: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
558: p_object_version_number => p_object_version_number);

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

599: end if;
600: --
601: end if;
602: --
603: hr_utility.set_location('Leaving:'||l_proc,10);
604: --
605: end chk_rqd_flag;
606: --
607:

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

643: l_api_updating boolean;
644: --
645: Begin
646: --
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: l_api_updating := ben_xrf_shd.api_updating
650: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
651: p_object_version_number => p_object_version_number);

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

697: fnd_message.set_name('BEN','BEN_94267_EXT_DUPS_MERGE_EXCLS');
698: fnd_message.raise_error;
699: end if ;
700: --
701: hr_utility.set_location('Leaving:'||l_proc,10);
702: --
703: end chk_chg_rcd_upd_flag;
704:
705:

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

739: l_api_updating boolean;
740: --
741: Begin
742: --
743: hr_utility.set_location('Entering:'||l_proc, 5);
744: --
745: l_api_updating := ben_xrf_shd.api_updating
746: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
747: p_object_version_number => p_object_version_number);

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

786: end if;
787: --
788: end if;
789: --
790: hr_utility.set_location('Leaving:'||l_proc,10);
791: --
792: end chk_hide_flag;
793: --
794: -- ----------------------------------------------------------------------------

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

820: l_dummy char(1);
821: --
822: Begin
823: --
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: --
826: --
827: if p_seq_num is null or p_seq_num =0 or p_seq_num <0 then
828: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');

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

828: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');
829: fnd_message.raise_error;
830: end if;
831: --
832: hr_utility.set_location('Leaving:'||l_proc,10);
833: --
834: end chk_seq_num;
835: --
836: -- ----------------------------------------------------------------------------

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

876: );
877: --
878: Begin
879: --
880: hr_utility.set_location('Entering:'||l_proc, 5);
881: --
882: --
883: open c1;
884: fetch c1 into l_dummy;

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

886: close c1;
887: fnd_message.set_name('BEN','BEN_91954_SEQ_NOT_UNIQUE');
888: fnd_message.raise_error;
889: end if;
890: hr_utility.set_location('Leaving:'||l_proc,10);
891: --
892: end chk_seq_num_unq;
893: --
894: -- ----------------------------------------------------------------------------

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

923: l_api_updating boolean;
924: --
925: begin
926: --
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: --
930: l_api_updating := ben_xrf_shd.api_updating
931: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,

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

965: end if;
966: --
967: end if;
968: --
969: hr_utility.set_location('Leaving:'||l_proc, 10);
970: --
971: End chk_sort_ids;
972: --
973: --bug 2804169 -- check if child records exist

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

1026:
1027: --
1028: Begin
1029: --
1030: hr_utility.set_location('Entering:'||l_proc, 5);
1031: --
1032: open c_ext_where_clause;
1033: fetch c_ext_where_clause into l_ext_where_clause_id;
1034: close c_ext_where_clause;

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

1062: end if ;
1063: close c_ext_file_group ;
1064:
1065: --
1066: hr_utility.set_location('Leaving:'||l_proc,10);
1067: --
1068: end chk_child_recs;
1069: --
1070:

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

1076: --
1077: l_proc varchar2(72) := g_package||'insert_validate';
1078: --
1079: Begin
1080: hr_utility.set_location('Entering:'||l_proc, 5);
1081: --
1082: -- Call all supporting business operations
1083: --
1084: --

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

1161: p_sort4_data_elmt_in_rcd_id => p_rec.sort4_data_elmt_in_rcd_id ,
1162: p_business_group_id=> p_rec.business_group_id,
1163: p_object_version_number => p_rec.object_version_number);
1164: --
1165: hr_utility.set_location(' Leaving:'||l_proc, 10);
1166: End insert_validate;
1167: --
1168: -- ----------------------------------------------------------------------------
1169: -- |---------------------------< update_validate >----------------------------|

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

1173: --
1174: l_proc varchar2(72) := g_package||'update_validate';
1175: --
1176: Begin
1177: hr_utility.set_location('Entering:'||l_proc, 5);
1178: --
1179: -- Call all supporting business operations
1180: --
1181: --

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

1257: p_sort4_data_elmt_in_rcd_id => p_rec.sort4_data_elmt_in_rcd_id ,
1258: p_business_group_id=> p_rec.business_group_id,
1259: p_object_version_number => p_rec.object_version_number);
1260: --
1261: hr_utility.set_location(' Leaving:'||l_proc, 10);
1262: End update_validate;
1263: --
1264: -- ----------------------------------------------------------------------------
1265: -- |---------------------------< delete_validate >----------------------------|

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

1269: --
1270: l_proc varchar2(72) := g_package||'delete_validate';
1271: --
1272: Begin
1273: hr_utility.set_location('Entering:'||l_proc, 5);
1274: --
1275: --bug 2804169 -- check if child records exist
1276: chk_child_recs ( p_rec.ext_rcd_in_file_id);
1277:

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

1280: chk_startup_action(False
1281: ,ben_xrf_shd.g_old_rec.business_group_id
1282: ,ben_xrf_shd.g_old_rec.legislation_code);
1283: --
1284: hr_utility.set_location(' Leaving:'||l_proc, 10);
1285: End delete_validate;
1286: --
1287: --
1288: -- ---------------------------------------------------------------------------

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

1307: l_proc varchar2(72) := g_package||'return_legislation_code';
1308: --
1309: begin
1310: --
1311: hr_utility.set_location('Entering:'|| l_proc, 10);
1312: --
1313: -- Ensure that all the mandatory parameter are not null
1314: --
1315: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1332: end if;
1333: --
1334: close csr_leg_code;
1335: --
1336: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1337: --
1338: return l_legislation_code;
1339: --
1340: end return_legislation_code;