DBA Data[Home] [Help]

APPS.BEN_XWC_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_xwc_shd.api_updating
156: (p_ext_where_clause_id => p_ext_where_clause_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_where_clause_id;
184: --
185: -- ----------------------------------------------------------------------------

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

221: where a.ext_data_elmt_in_rcd_id = p_cond_ext_data_elmt_in_rcd_id;
222: --
223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc,5);
226: --
227: l_api_updating := ben_xwc_shd.api_updating
228: (p_ext_where_clause_id => p_ext_where_clause_id,
229: p_object_version_number => p_object_version_number);

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

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

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

297: where a.ext_rcd_in_file_id = p_ext_rcd_in_file_id;
298: --
299: Begin
300: --
301: hr_utility.set_location('Entering:'||l_proc,5);
302: --
303: l_api_updating := ben_xwc_shd.api_updating
304: (p_ext_where_clause_id => p_ext_where_clause_id,
305: p_object_version_number => p_object_version_number);

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

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

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

373: where a.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
374: --
375: Begin
376: --
377: hr_utility.set_location('Entering:'||l_proc,5);
378: --
379: l_api_updating := ben_xwc_shd.api_updating
380: (p_ext_where_clause_id => p_ext_where_clause_id,
381: p_object_version_number => p_object_version_number);

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

405: close c1;
406: --
407: end if;
408: --
409: hr_utility.set_location('Leaving:'||l_proc,10);
410: --
411: End chk_ext_data_elmt_in_rcd_id;
412: --
413: -- ----------------------------------------------------------------------------

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

449: where a.ext_data_elmt_id = p_cond_ext_data_elmt_id;
450: --
451: Begin
452: --
453: hr_utility.set_location('Entering:'||l_proc,5);
454: --
455: l_api_updating := ben_xwc_shd.api_updating
456: (p_ext_where_clause_id => p_ext_where_clause_id,
457: p_object_version_number => p_object_version_number);

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

481: close c1;
482: --
483: end if;
484: --
485: hr_utility.set_location('Leaving:'||l_proc,10);
486: --
487: End chk_cond_ext_data_elmt_id;
488: --
489: -- ----------------------------------------------------------------------------

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

525: where a.ext_data_elmt_id = p_ext_data_elmt_id;
526: --
527: Begin
528: --
529: hr_utility.set_location('Entering:'||l_proc,5);
530: --
531: l_api_updating := ben_xwc_shd.api_updating
532: (p_ext_where_clause_id => p_ext_where_clause_id,
533: p_object_version_number => p_object_version_number);

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

557: close c1;
558: --
559: end if;
560: --
561: hr_utility.set_location('Leaving:'||l_proc,10);
562: --
563: End chk_ext_data_elmt_id;
564: --
565: -- ----------------------------------------------------------------------------

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

598: l_api_updating boolean;
599: --
600: Begin
601: --
602: hr_utility.set_location('Entering:'||l_proc, 5);
603: --
604: l_api_updating := ben_xwc_shd.api_updating
605: (p_ext_where_clause_id => p_ext_where_clause_id,
606: p_object_version_number => p_object_version_number);

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

646: end if;
647: --
648: end if; /* if (l_api_updating... */
649: --
650: hr_utility.set_location('Leaving:'||l_proc,10);
651: --
652: end chk_oper_cd;
653: --
654: -- ----------------------------------------------------------------------------

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

687: l_api_updating boolean;
688: --
689: Begin
690: --
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: l_api_updating := ben_xwc_shd.api_updating
694: (p_ext_where_clause_id => p_ext_where_clause_id,
695: p_object_version_number => p_object_version_number);

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

735: end if;
736: --
737: end if;
738: --
739: hr_utility.set_location('Leaving:'||l_proc,10);
740: --
741: end chk_and_or_cd;
742: --
743: -- ----------------------------------------------------------------------------

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

779: l_str varchar2(2000) ;
780: --
781: Begin
782: --
783: hr_utility.set_location('Entering:'||l_proc, 5);
784: --
785: l_api_updating := ben_xwc_shd.api_updating
786: (p_ext_where_clause_id => p_ext_where_clause_id,
787: p_object_version_number => p_object_version_number);

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

878: end;
879: end if;
880: end if ;
881: --
882: hr_utility.set_location('Leaving:'||l_proc,10);
883: --
884: end chk_val;
885: --
886: -- ----------------------------------------------------------------------------

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

951: --
952: l_proc varchar2(72) := g_package||'insert_validate';
953: --
954: Begin
955: hr_utility.set_location('Entering:'||l_proc, 5);
956: --
957: -- Call all supporting business operations
958: --
959: --

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

1023: p_ext_data_elmt_id => p_rec.ext_data_elmt_id,
1024: p_seq_num => p_rec.seq_num,
1025: p_object_version_number => p_rec.object_version_number);
1026: --
1027: hr_utility.set_location(' Leaving:'||l_proc, 10);
1028: End insert_validate;
1029: --
1030: -- ----------------------------------------------------------------------------
1031: -- |---------------------------< update_validate >----------------------------|

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

1035: --
1036: l_proc varchar2(72) := g_package||'update_validate';
1037: --
1038: Begin
1039: hr_utility.set_location('Entering:'||l_proc, 5);
1040: --
1041: -- Call all supporting business operations
1042: --
1043: --

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

1107: p_ext_data_elmt_id => p_rec.ext_data_elmt_id ,
1108: p_seq_num => p_rec.seq_num,
1109: p_object_version_number => p_rec.object_version_number);
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 10);
1112: End update_validate;
1113: --
1114: -- ----------------------------------------------------------------------------
1115: -- |---------------------------< delete_validate >----------------------------|

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

1119: --
1120: l_proc varchar2(72) := g_package||'delete_validate';
1121: --
1122: Begin
1123: hr_utility.set_location('Entering:'||l_proc, 5);
1124: --
1125: -- Call all supporting business operations
1126: --
1127: chk_startup_action(False

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

1127: chk_startup_action(False
1128: ,ben_xwc_shd.g_old_rec.business_group_id
1129: ,ben_xwc_shd.g_old_rec.legislation_code);
1130: --
1131: hr_utility.set_location(' Leaving:'||l_proc, 10);
1132: End delete_validate;
1133: --
1134: --
1135: -- ---------------------------------------------------------------------------

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

1154: l_proc varchar2(72) := g_package||'return_legislation_code';
1155: --
1156: begin
1157: --
1158: hr_utility.set_location('Entering:'|| l_proc, 10);
1159: --
1160: -- Ensure that all the mandatory parameter are not null
1161: --
1162: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1179: end if;
1180: --
1181: close csr_leg_code;
1182: --
1183: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1184: --
1185: return l_legislation_code;
1186: --
1187: end return_legislation_code;