DBA Data[Home] [Help]

APPS.BEN_CONC_REPORTS dependencies on HR_UTILITY

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

154: l_proc varchar2(80) := g_package || '.person_error_cnt';
155: --
156: begin
157: --
158: hr_utility.set_location('Entering : ' || l_proc, 10);
159: --
160: -- Increment the error count
161: --
162: g_error_person_cnt := g_error_person_cnt + 1;

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

160: -- Increment the error count
161: --
162: g_error_person_cnt := g_error_person_cnt + 1;
163: --
164: hr_utility.set_location('Leaving : ' || l_proc, 10);
165: --
166: end person_error_cnt;
167: --
168: -- ----------------------------------------------------------------------------

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

174: l_proc varchar2(80) := g_package || '.print_parameters';
175: --
176: begin
177: --
178: hr_utility.set_location('Entering : ' || l_proc, 10);
179: --
180: if fnd_global.conc_request_id = -1 then
181: return;
182: end if;

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

341: fnd_file.put_line(which => fnd_file.log,
342: buff => 'Elec Choice Flexfields Flag: '||
343: g_parm.disp_epe_flxfld_flag );
344:
345: hr_utility.set_location('Leaving : ' || l_proc, 10);
346: --
347: --
348: end print_parameters;
349: --

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

415: --
416: begin
417: --
418: -- fnd_file.put_line(fnd_file.log,'Inside check rules ');
419: hr_utility.set_location ('Entering '||l_proc,10);
420: --
421: -- This procedure checks validity of parameters that have been passed
422: --
423: -- Check if mandatory arguments have been stipulated

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

533: fnd_message.raise_error;
534: --
535: end if;
536: --
537: hr_utility.set_location ('Leaving '||l_proc,10);
538: --
539: end check_business_rules;
540: --
541: -- ==================================================================================

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

568: l_assignment_id number;
569: l_actn varchar2(80);
570: value_exception exception ;
571: Begin
572: hr_utility.set_location ('Entering '||l_proc,10);
573: --
574: -- Get assignment ID form per_assignments_f table.
575: --
576: l_actn := 'Opening C1 Assignment cursor...';

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

599: If upper(p_return) not in ('Y', 'N') then
600: Raise value_exception ;
601: End if;
602: --
603: hr_utility.set_location ('Leaving '||l_proc,10);
604: Exception
605: When ben_batch_utils.g_record_error then
606: p_return := 'N' ;
607: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');

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

658: asg_record_error exception;
659: wrong_output_error exception;
660: begin
661: l_step := 10;
662: hr_utility.set_location ('Entering '||l_proc,10);
663: --
664: -- Get assignment ID,organization_id form per_assignments_f table.
665: --
666: open c1;

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

703: fnd_message.set_token('PROC',l_proc);
704: raise wrong_output_error;
705: end if;
706: return l_return;
707: hr_utility.set_location ('Leaving '||l_proc,10);
708: exception
709: When asg_record_error then
710: ben_batch_utils.rpt_error(p_proc => l_proc,
711: p_last_actn => 'Step = '||to_char(l_step),p_rpt_flag => TRUE);

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

726: l_proc varchar2(80) := g_package || '.write_logfile';
727: --
728: begin
729: --
730: hr_utility.set_location('Entering : ' || l_proc, 10);
731: --
732: benutils.write(p_text => benutils.g_banner_minus);
733: benutils.write(p_text => 'Batch Process Statistical Information');
734: benutils.write(p_text => benutils.g_banner_minus);

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

739: benutils.write_table_and_file(p_table => true
740: ,p_file => true);
741: commit;
742: --
743: hr_utility.set_location('Leaving : ' || l_proc, 10);
744: --
745: exception
746: --
747: when others then

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

779: l_err_message varchar2(2000);
780: l_actn varchar2(2000);
781: begin
782: --
783: hr_utility.set_location('Entering : ' || l_proc, 10);
784: --
785: skip := FALSE;
786: rl_ret := 'Y';
787: --

Line 818: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);

814: -- fnd_file.put_line(fnd_file.log, ' after person selection rule ');
815: -- Create a person action only if the person passes the person selection rule
816: If ( not skip) then
817: --
818: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
819: -- fnd_file.put_line(fnd_file.log, 'not skip...Inserting Ben_person_actions');
820: --
821: l_actn := 'Create person actions ...';
822: ben_person_actions_api.create_person_actions(

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

865: ,p_effective_date => g_parm.effective_date );
866: fnd_file.put_line(fnd_file.log, ' persons excluded by the selection rule');
867: end if;
868: --
869: hr_utility.set_location('Leaving : ' || l_proc, 10);
870: -- fnd_file.put_line(fnd_file.log, ' Leaving : create_actions_ranges ');
871: --
872: exception
873: when others then

Line 1023: hr_utility.set_location('Entering : ' || l_package , 10);

1019: l_object_version_number number;
1020: --
1021: l_per_rec c_person%rowtype ;
1022: begin
1023: hr_utility.set_location('Entering : ' || l_package , 10);
1024: --
1025: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);
1026: --
1027: --fnd_file.put_line(fnd_file.log, 'before person loop : ');

Line 1025: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);

1021: l_per_rec c_person%rowtype ;
1022: begin
1023: hr_utility.set_location('Entering : ' || l_package , 10);
1024: --
1025: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);
1026: --
1027: --fnd_file.put_line(fnd_file.log, 'before person loop : ');
1028: open c_person ;
1029: loop

Line 1050: hr_utility.set_location('Ranges for remaining people ' || l_package, 25);

1046: --
1047: If g_person_actn_cnt > 0 and
1048: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
1049: --
1050: hr_utility.set_location('Ranges for remaining people ' || l_package, 25);
1051: --
1052: --fnd_file.put_line(fnd_file.log, 'before create batch ranges ');
1053: ben_batch_ranges_api.create_batch_ranges
1054: (p_validate => FALSE

Line 1067: hr_utility.set_location('Leaving : ' || l_package, 10);

1063: g_num_ranges := g_num_ranges + 1;
1064: --
1065: end if;
1066: --
1067: hr_utility.set_location('Leaving : ' || l_package, 10);
1068: --fnd_file.put_line(fnd_file.log, 'leaving create_bensmrep_ranges ');
1069: end create_bensmrep_ranges;
1070: --
1071: -- ==================================================================================

Line 1176: hr_utility.set_location('Entering : ' || l_package , 10);

1172: l_object_version_number number;
1173: --
1174: l_per_rec c_person%rowtype ;
1175: begin
1176: hr_utility.set_location('Entering : ' || l_package , 10);
1177: --
1178: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);
1179: --
1180: --fnd_file.put_line(fnd_file.log, 'before person loop : ');

Line 1178: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);

1174: l_per_rec c_person%rowtype ;
1175: begin
1176: hr_utility.set_location('Entering : ' || l_package , 10);
1177: --
1178: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);
1179: --
1180: --fnd_file.put_line(fnd_file.log, 'before person loop : ');
1181: open c_person ;
1182: loop

Line 1203: hr_utility.set_location('Ranges for remaining people ' || l_package, 25);

1199: --
1200: If g_person_actn_cnt > 0 and
1201: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
1202: --
1203: hr_utility.set_location('Ranges for remaining people ' || l_package, 25);
1204: --
1205: --fnd_file.put_line(fnd_file.log, 'before create batch ranges ');
1206: ben_batch_ranges_api.create_batch_ranges
1207: (p_validate => FALSE

Line 1220: hr_utility.set_location('Leaving : ' || l_package, 10);

1216: g_num_ranges := g_num_ranges + 1;
1217: --
1218: end if;
1219: --
1220: hr_utility.set_location('Leaving : ' || l_package, 10);
1221: --fnd_file.put_line(fnd_file.log, 'leaving create_bensmrep_ranges ');
1222:
1223: end ;
1224: -- ==================================================================================

Line 1289: hr_utility.set_location ('Entering '|| l_package,10);

1285: l_count number;
1286: --
1287: begin
1288: --
1289: hr_utility.set_location ('Entering '|| l_package,10);
1290: l_effective_date:= to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
1291: l_effective_date:= to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
1292: --
1293: l_lf_evt_ocrd_dt := to_date(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');

Line 1309: hr_utility.set_location('Checking arguments',12);

1305: dt_fndate.change_ses_date
1306: (p_ses_date => l_effective_date,
1307: p_commit => l_commit);
1308:
1309: hr_utility.set_location('Checking arguments',12);
1310: --
1311: l_actn := 'Initialise globals...';
1312:
1313: initialize_globals;

Line 1392: hr_utility.set_location('Num Threads = ' || g_threads, 10);

1388: -- fnd_file.put_line(fnd_file.log, 'g_threads : ' || g_threads );
1389: -- fnd_file.put_line(fnd_file.log, 'g_chunk_size : ' || g_chunk_size);
1390: -- fnd_file.put_line(fnd_file.log, 'g_max_errors : ' || g_max_errors);
1391: --
1392: hr_utility.set_location('Num Threads = ' || g_threads, 10);
1393: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
1394: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
1395: --
1396: -- Create benefit actions parameters in the benefit action table.

Line 1393: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);

1389: -- fnd_file.put_line(fnd_file.log, 'g_chunk_size : ' || g_chunk_size);
1390: -- fnd_file.put_line(fnd_file.log, 'g_max_errors : ' || g_max_errors);
1391: --
1392: hr_utility.set_location('Num Threads = ' || g_threads, 10);
1393: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
1394: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
1395: --
1396: -- Create benefit actions parameters in the benefit action table.
1397: -- Do not create if a benefit action already exists, in other words

Line 1394: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);

1390: -- fnd_file.put_line(fnd_file.log, 'g_max_errors : ' || g_max_errors);
1391: --
1392: hr_utility.set_location('Num Threads = ' || g_threads, 10);
1393: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
1394: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
1395: --
1396: -- Create benefit actions parameters in the benefit action table.
1397: -- Do not create if a benefit action already exists, in other words
1398: -- we are doing a restart.

Line 1402: hr_utility.set_location('p_benefit_action_id is null',14);

1398: -- we are doing a restart.
1399: --
1400: if p_benefit_action_id is null then
1401: --
1402: hr_utility.set_location('p_benefit_action_id is null',14);
1403: --
1404: -- This call inserts the parameters given and the request id of
1405: -- the concurrent program into the Benefit Actions table
1406: --

Line 1449: hr_utility.set_location('Delete rows from ben_batch_ranges',16);

1445: commit;
1446: --
1447: -- Delete/clear ranges from ben_batch_ranges table
1448: --
1449: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
1450: --
1451: Delete from ben_batch_ranges
1452: Where benefit_action_id = l_benefit_action_id;
1453: --

Line 1480: hr_utility.set_location('restart batch process ' || l_actn, 20);

1476: -- Benefit action id is not null i.e. the batch process is being restarted
1477: -- for a certain benefit action id. Create batch ranges and person actions
1478: -- for restarting.
1479: --
1480: hr_utility.set_location('restart batch process ' || l_actn, 20);
1481: --
1482: ben_batch_utils.create_restart_person_actions
1483: (p_benefit_action_id => p_benefit_action_id
1484: ,p_effective_date => l_effective_date

Line 1523: hr_utility.set_location('Number of Threads : ' || g_threads, 20);

1519: -- and the number of ranges created above.
1520: --
1521: g_threads := least(g_threads, g_num_ranges);
1522: --
1523: hr_utility.set_location('Number of Threads : ' || g_threads, 20);
1524: --
1525: --fnd_file.put_line(fnd_file.log, 'Number of Threads : ' || g_threads);
1526: -- Submit requests
1527: --

Line 1532: hr_utility.set_location('Sumitting thread : ' || l_count, 25);

1528: -- for l_count in 1..g_threads loop
1529: if g_num_ranges <> 0 then
1530: --
1531: --
1532: hr_utility.set_location('Sumitting thread : ' || l_count, 25);
1533: --
1534: l_actn := 'Submit request for report ...';
1535: --
1536: if p_report_name = 'BENSMREP' then

Line 1627: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);

1623: --
1624: benutils.write(p_text => fnd_message.get);
1625: benutils.write(p_text => sqlerrm);
1626: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1627: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1629: fnd_message.set_token('PROCEDURE', l_package);
1630: fnd_message.set_token('STEP', l_actn );
1631: fnd_file.put_line(fnd_file.log, fnd_message.get );