DBA Data[Home] [Help]

APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BENUTILS

Line 116: ben_batch_utils.write('Error is : '||benutils.get_message_name||' - '||fnd_message.get);

112: --
113: when others then
114: --
115: hr_utility.set_location('Error || sqlerrm',10);
116: ben_batch_utils.write('Error is : '||benutils.get_message_name||' - '||fnd_message.get);
117: fnd_message.raise_error;
118: --
119: end check_business_rules;
120: --

Line 168: benutils.iftrue

164: buff => 'Business Group ID :'||
165: l_parm.business_group_id);
166: fnd_file.put_line(which => fnd_file.log,
167: buff => 'Program ID :'||
168: benutils.iftrue
169: (p_expression => l_parm.pgm_id is null,
170: p_true => 'All',
171: p_false => l_parm.pgm_id));
172: fnd_file.put_line(which => fnd_file.log,

Line 174: benutils.iftrue

170: p_true => 'All',
171: p_false => l_parm.pgm_id));
172: fnd_file.put_line(which => fnd_file.log,
173: buff => 'Plan ID :'||
174: benutils.iftrue
175: (p_expression => l_parm.pl_id is null,
176: p_true => 'All',
177: p_false => l_parm.pl_id));
178: fnd_file.put_line(which => fnd_file.log,

Line 180: benutils.iftrue

176: p_true => 'All',
177: p_false => l_parm.pl_id));
178: fnd_file.put_line(which => fnd_file.log,
179: buff => 'Person ID :'||
180: benutils.iftrue
181: (p_expression => l_parm.person_id is null,
182: p_true => 'None',
183: p_false => l_parm.person_id));
184: fnd_file.put_line(which => fnd_file.log,

Line 186: benutils.iftrue

182: p_true => 'None',
183: p_false => l_parm.person_id));
184: fnd_file.put_line(which => fnd_file.log,
185: buff => 'Person Selection Rule :'||
186: benutils.iftrue
187: (p_expression => l_parm.person_selection_rl is null,
188: p_true => 'None',
189: p_false => l_parm.person_selection_rl));
190: fnd_file.put_line(which => fnd_file.log,

Line 192: benutils.iftrue

188: p_true => 'None',
189: p_false => l_parm.person_selection_rl));
190: fnd_file.put_line(which => fnd_file.log,
191: buff => 'Ler ID :'||
192: benutils.iftrue
193: (p_expression => l_parm.ler_id is null,
194: p_true => 'None',
195: p_false => l_parm.ler_id));
196: fnd_file.put_line(which => fnd_file.log,

Line 198: benutils.iftrue

194: p_true => 'None',
195: p_false => l_parm.ler_id));
196: fnd_file.put_line(which => fnd_file.log,
197: buff => 'New Enrollment End Date :'||
198: benutils.iftrue
199: (p_expression => l_parm.bft_attribute3 is null,
200: p_true => 'NONE',
201: p_false => l_parm.bft_attribute3));
202: fnd_file.put_line(which => fnd_file.log,

Line 204: benutils.iftrue

200: p_true => 'NONE',
201: p_false => l_parm.bft_attribute3));
202: fnd_file.put_line(which => fnd_file.log,
203: buff => 'New Processing End Date :'||
204: benutils.iftrue
205: (p_expression => l_parm.bft_attribute4 is null,
206: p_true => 'NONE',
207: p_false => l_parm.bft_attribute4));
208: fnd_file.put_line(which => fnd_file.log,

Line 210: benutils.iftrue

206: p_true => 'NONE',
207: p_false => l_parm.bft_attribute4));
208: fnd_file.put_line(which => fnd_file.log,
209: buff => 'New Default Enrollment Date:'||
210: benutils.iftrue
211: (p_expression => l_parm.bft_attribute5 is null,
212: p_true => 'NONE',
213: p_false => l_parm.bft_attribute5));
214: fnd_file.put_line(which => fnd_file.log,

Line 216: benutils.iftrue

212: p_true => 'NONE',
213: p_false => l_parm.bft_attribute5));
214: fnd_file.put_line(which => fnd_file.log,
215: buff => 'Number of Days to Shift :'||
216: benutils.iftrue
217: (p_expression => l_parm.bft_attribute6 is null,
218: p_true => 'NONE',
219: p_false => l_parm.bft_attribute6));
220: -- added bug: 5611643

Line 223: benutils.iftrue

219: p_false => l_parm.bft_attribute6));
220: -- added bug: 5611643
221: fnd_file.put_line(which => fnd_file.log,
222: buff => 'Life Event Occured Date :'||
223: benutils.iftrue
224: (p_expression => l_parm.bft_attribute7 is null,
225: p_true => 'NONE',
226: p_false => to_char(
227: fnd_date.canonical_to_date(l_parm.bft_attribute7),'DD/MM/YYYY')));

Line 232: benutils.iftrue

228: --
229:
230: fnd_file.put_line(which => fnd_file.log,
231: buff => 'Organization ID :'||
232: benutils.iftrue
233: (p_expression => l_parm.organization_id is null,
234: p_true => 'All',
235: p_false => l_parm.organization_id));
236:

Line 239: benutils.iftrue

235: p_false => l_parm.organization_id));
236:
237: fnd_file.put_line(which => fnd_file.log,
238: buff => 'Benefit Group ID :'||
239: benutils.iftrue
240: (p_expression => l_parm.benfts_grp_id is null,
241: p_true => 'All',
242: p_false => l_parm.benfts_grp_id));
243:

Line 246: benutils.iftrue

242: p_false => l_parm.benfts_grp_id));
243:
244: fnd_file.put_line(which => fnd_file.log,
245: buff => 'Location ID :'||
246: benutils.iftrue
247: (p_expression => l_parm.location_id is null,
248: p_true => 'All',
249: p_false => l_parm.location_id));
250:

Line 253: benutils.iftrue

249: p_false => l_parm.location_id));
250:
251: fnd_file.put_line(which => fnd_file.log,
252: buff => 'Postal Zip Range ID :'||
253: benutils.iftrue
254: (p_expression => l_parm.pstl_zip_rng_id is null,
255: p_true => 'All',
256: p_false => l_parm.pstl_zip_rng_id));
257:

Line 260: benutils.iftrue

256: p_false => l_parm.pstl_zip_rng_id));
257:
258: fnd_file.put_line(which => fnd_file.log,
259: buff => 'Reporting Group ID :'||
260: benutils.iftrue
261: (p_expression => l_parm.rptg_grp_id is null,
262: p_true => 'All',
263: p_false => l_parm.rptg_grp_id));
264:

Line 267: benutils.iftrue

263: p_false => l_parm.rptg_grp_id));
264:
265: fnd_file.put_line(which => fnd_file.log,
266: buff => 'Legal Entity ID :'||
267: benutils.iftrue
268: (p_expression => l_parm.legal_entity_id is null,
269: p_true => 'All',
270: p_false => l_parm.legal_entity_id));
271:

Line 274: benutils.iftrue

270: p_false => l_parm.legal_entity_id));
271:
272: fnd_file.put_line(which => fnd_file.log,
273: buff => 'Payroll ID :'||
274: benutils.iftrue
275: (p_expression => l_parm.payroll_id is null,
276: p_true => 'All',
277: p_false => l_parm.payroll_id));
278:

Line 417: fnd_message.set_token('PROC','benutils.get_parameter');

413: (p_ses_date => l_effective_date,
414: p_commit => l_commit);
415: --
416: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
417: fnd_message.set_token('PROC','benutils.get_parameter');
418: benutils.get_parameter(p_business_group_id => p_business_group_id
419: -- bug: 5611643
420: -- ,p_batch_exe_cd => 'BENMNOEM'
421: ,p_batch_exe_cd => 'BENMNOEW'

Line 418: benutils.get_parameter(p_business_group_id => p_business_group_id

414: p_commit => l_commit);
415: --
416: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
417: fnd_message.set_token('PROC','benutils.get_parameter');
418: benutils.get_parameter(p_business_group_id => p_business_group_id
419: -- bug: 5611643
420: -- ,p_batch_exe_cd => 'BENMNOEM'
421: ,p_batch_exe_cd => 'BENMNOEW'
422: ,p_threads => l_threads

Line 436: -- Copy benefit action id to global in benutils package

432: p_threads => l_threads,
433: p_max_errors => g_max_errors_allowed,
434: p_benefit_action_id => p_benefit_action_id);
435: --
436: -- Copy benefit action id to global in benutils package
437: --
438: benutils.g_benefit_action_id := p_benefit_action_id;
439: benutils.g_thread_id := p_thread_id;
440: g_persons_errored := 0;

Line 438: benutils.g_benefit_action_id := p_benefit_action_id;

434: p_benefit_action_id => p_benefit_action_id);
435: --
436: -- Copy benefit action id to global in benutils package
437: --
438: benutils.g_benefit_action_id := p_benefit_action_id;
439: benutils.g_thread_id := p_thread_id;
440: g_persons_errored := 0;
441: g_persons_processed := 0;
442: --

Line 439: benutils.g_thread_id := p_thread_id;

435: --
436: -- Copy benefit action id to global in benutils package
437: --
438: benutils.g_benefit_action_id := p_benefit_action_id;
439: benutils.g_thread_id := p_thread_id;
440: g_persons_errored := 0;
441: g_persons_processed := 0;
442: --
443: print_parameters

Line 513: benutils.set_cache_record_position;

509: --
510: exit when c_person_thread%notfound;
511: --
512: savepoint last_place;
513: benutils.set_cache_record_position;
514: --
515: begin
516: --
517: open c_pel;

Line 612: benutils.rollback_cache;

608: --
609: end if;
610: --
611: rollback to last_place;
612: benutils.rollback_cache;
613: --
614: update ben_person_actions
615: set action_status_cd = 'E'
616: where person_id = l_person_id

Line 628: benutils.get_message_name||' - '||substr(fnd_message.get,1,80));

624: if p_audit_log_flag = 'Y' then
625: -- changed bug: 5611643
626: /*
627: ben_batch_utils.write('| '||rpad(l_pel.full_name,18)||'| '||'UNSUCCESSFUL | Error is - '||
628: benutils.get_message_name||' - '||substr(fnd_message.get,1,80));
629: */
630: DECLARE
631: l_message_text VARCHAR2 (2100);
632: l_message_length NUMBER := 148; -- := 136;

Line 639: || benutils.get_message_name

635: '| '
636: || RPAD (l_pel.full_name, 30)
637: || '| '
638: || 'UNSUCCESSFUL | Error is - '
639: || benutils.get_message_name
640: || ' - '
641: || fnd_message.get;
642: ben_batch_utils.WRITE (SUBSTR (l_message_text, 1, l_message_length) || ' |');
643:

Line 715: benutils.rollback_cache;

711: hr_utility.set_location('Super Error',10);
712: hr_utility.set_location(sqlerrm,10);
713: hr_utility.set_location('Super Error',10);
714: rollback;
715: benutils.rollback_cache;
716: --
717: g_rec.ler_id := p_ler_id;
718: g_rec.rep_typ_cd := 'FATAL';
719: g_rec.text := fnd_message.get;

Line 722: benutils.write(p_text => g_rec.text);

718: g_rec.rep_typ_cd := 'FATAL';
719: g_rec.text := fnd_message.get;
720: g_rec.person_id := l_person_id;
721: --
722: benutils.write(p_text => g_rec.text);
723: benutils.write(p_rec => g_rec);
724: --
725: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
726: ,p_num_pers_errored => g_persons_errored);

Line 723: benutils.write(p_rec => g_rec);

719: g_rec.text := fnd_message.get;
720: g_rec.person_id := l_person_id;
721: --
722: benutils.write(p_text => g_rec.text);
723: benutils.write(p_rec => g_rec);
724: --
725: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
726: ,p_num_pers_errored => g_persons_errored);
727: commit;

Line 1026: benutils.get_parameter(p_business_group_id => p_business_group_id

1022: --
1023: ben_batch_utils.ini;
1024: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
1025: --
1026: benutils.get_parameter(p_business_group_id => p_business_group_id
1027: -- bug 5611643
1028: -- ,p_batch_exe_cd => 'BENMNGLE'
1029: ,p_batch_exe_cd => 'BENMNOEW'
1030: ,p_threads => l_threads

Line 1088: benutils.g_benefit_action_id := l_benefit_action_id;

1084: -- added bug 5611643
1085: ,p_bft_attribute7 => p_lf_evt_ocrd_dt
1086: );
1087: --
1088: benutils.g_benefit_action_id := l_benefit_action_id;
1089: --
1090: if g_debug then
1091: hr_utility.set_location (' l_benefit_action_id : '||l_benefit_action_id,20);
1092: hr_utility.set_location (l_proc||' Dn Create BFT ',20);