DBA Data[Home] [Help]

APPS.BEN_PREMIUM_CONCURRENT dependencies on HR_UTILITY

Line 68: hr_utility.set_location ('Entering '||l_proc,05);

64: l_proc varchar2(80) := g_package||'.submit_all_reports';
65: l_actn varchar2(80);
66: l_request_id number;
67: Begin
68: hr_utility.set_location ('Entering '||l_proc,05);
69: l_actn := 'Calling ben_batch_utils.batch_report (BENPRSUM)...';
70: ben_batch_utils.batch_report
71: (p_concurrent_request_id => fnd_global.conc_request_id
72: ,p_program_name => 'BENPRSUM'

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

90: ,p_program_name => 'BENERPER'
91: ,p_request_id => l_request_id
92: );
93:
94: hr_utility.set_location ('Leaving '||l_proc,10);
95: Exception
96: When others then
97: ben_batch_utils.rpt_error(p_proc => l_proc
98: ,p_last_actn => l_actn

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

135: l_assignment_id number;
136: l_actn varchar2(80);
137: value_exception exception ;
138: Begin
139: hr_utility.set_location ('Entering '||l_proc,10);
140: --
141: -- Get assignment ID form per_assignments_f table.
142: --
143: l_actn := 'Opening C1 Assignment cursor...';

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

167: If upper(p_return) not in ('Y', 'N') then
168: Raise value_exception ;
169: End if;
170: --p_return := 'Y';
171: hr_utility.set_location ('Leaving '||l_proc,10);
172: Exception
173: When ben_batch_utils.g_record_error then
174: p_return := 'N' ;
175: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');

Line 266: hr_utility.set_location ('Entering '||l_proc,05);

262: l_error_text varchar2(200) := null;
263:
264: Begin
265:
266: hr_utility.set_location ('Entering '||l_proc,05);
267:
268: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
269: l_effective_date:=to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
270:

Line 375: hr_utility.set_location ('Fetch person:'||

371: ,g_cache_person_process(l_record_number+1).person_action_id
372: ,g_cache_person_process(l_record_number+1).object_version_number
373: ,g_cache_person_process(l_record_number+1).ler_id;
374: exit when c_person_thread%notfound;
375: hr_utility.set_location ('Fetch person:'||
376: to_char(g_cache_person_process(l_record_number+1).person_id),20);
377: l_record_number := l_record_number + 1;
378: End loop;
379: close c_person_thread;

Line 387: hr_utility.set_location ('Call ben_prem_prtt_monthly.main:',30);

383: -- Process the rows from the person process cache
384: --
385: For l_cnt in 1..l_record_number loop
386: Begin
387: hr_utility.set_location ('Call ben_prem_prtt_monthly.main:',30);
388:
389: ben_prem_prtt_monthly.main
390: (p_validate => p_validate
391: ,p_person_id => g_cache_person_process(l_cnt).person_id

Line 408: hr_utility.set_location ('Person Failed in '||l_proc,777);

404: g_persons_processed := g_persons_processed + 1;
405: Exception
406: When others then
407: l_error_text := sqlerrm;
408: hr_utility.set_location ('Person Failed in '||l_proc,777);
409: hr_utility.set_location (' with error '||l_error_text,777);
410:
411: g_persons_errored := g_persons_errored + 1;
412:

Line 409: hr_utility.set_location (' with error '||l_error_text,777);

405: Exception
406: When others then
407: l_error_text := sqlerrm;
408: hr_utility.set_location ('Person Failed in '||l_proc,777);
409: hr_utility.set_location (' with error '||l_error_text,777);
410:
411: g_persons_errored := g_persons_errored + 1;
412:
413: If (g_persons_errored > g_max_errors_allowed) then

Line 414: hr_utility.set_location ('Person errors exceeds max allowed',778);

410:
411: g_persons_errored := g_persons_errored + 1;
412:
413: If (g_persons_errored > g_max_errors_allowed) then
414: hr_utility.set_location ('Person errors exceeds max allowed',778);
415: fnd_message.raise_error;
416: End if;
417: End;
418: End loop;

Line 423: hr_utility.set_location ('BEN_91709_PER_NOT_FND_IN_RNG',778);

419: Else
420: --
421: l_actn := 'Erroring out nocopy since not person is found in range...' ;
422: --
423: hr_utility.set_location ('BEN_91709_PER_NOT_FND_IN_RNG',778);
424: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
425: fnd_message.raise_error;
426: End if;
427: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);

Line 435: hr_utility.set_location ('Leaving '||l_proc,70);

431: l_actn := 'Calling Log_statistics...';
432: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
433: ,p_num_pers_errored => g_persons_errored
434: );
435: hr_utility.set_location ('Leaving '||l_proc,70);
436: Exception
437: When others then
438: l_error_text := sqlerrm;
439: hr_utility.set_location ('Fail in '||l_proc,998);

Line 439: hr_utility.set_location ('Fail in '||l_proc,998);

435: hr_utility.set_location ('Leaving '||l_proc,70);
436: Exception
437: When others then
438: l_error_text := sqlerrm;
439: hr_utility.set_location ('Fail in '||l_proc,998);
440: hr_utility.set_location (' with error '||l_error_text,999);
441:
442: ben_batch_utils.rpt_error(p_proc => l_proc
443: ,p_last_actn => l_actn

Line 440: hr_utility.set_location (' with error '||l_error_text,999);

436: Exception
437: When others then
438: l_error_text := sqlerrm;
439: hr_utility.set_location ('Fail in '||l_proc,998);
440: hr_utility.set_location (' with error '||l_error_text,999);
441:
442: ben_batch_utils.rpt_error(p_proc => l_proc
443: ,p_last_actn => l_actn
444: ,p_rpt_flag => TRUE

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

489: l_errbuf varchar2(80);
490: l_retcode number;
491: l_actn varchar2(80);
492: Begin
493: hr_utility.set_location ('Entering '||l_proc,10);
494: --
495: -- get the parameters for a previous run and do a restart
496: --
497: l_actn := 'Getting parameter data...';

Line 505: hr_utility.set_location ('BEN_91710_RESTRT_PARMS_NOT_FND',778);

501: ben_batch_utils.rpt_error(p_proc => l_proc
502: ,p_last_actn => l_actn
503: ,p_rpt_flag => TRUE
504: );
505: hr_utility.set_location ('BEN_91710_RESTRT_PARMS_NOT_FND',778);
506: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
507: fnd_message.raise_error;
508: End if;
509: close c_parameters;

Line 530: hr_utility.set_location ('Leaving '||l_proc,70);

526: ,p_organization_id => l_parameters.organization_id
527: ,p_legal_entity_id => l_parameters.legal_entity_id
528: ,p_debug_messages => l_parameters.debug_messages_flag
529: );
530: hr_utility.set_location ('Leaving '||l_proc,70);
531: Exception
532: when others then
533: ben_batch_utils.rpt_error(p_proc => l_proc
534: ,p_last_actn => l_actn

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

633: l_retcode number;
634: l_restart boolean;
635: l_err_message varchar2(800);
636: Begin
637: hr_utility.set_location ('Entering '||l_proc,10);
638:
639: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
640: l_effective_date:=to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
641: -- No matter what date the user entered, make sure we process on the last day of the

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

663: -- Check that all the mandatory input parameters
664: -- such as p_business_group_id, p_mode, p_effective_date
665: --
666: l_actn := 'Checking arguments...';
667: hr_utility.set_location('Checking arguments',12);
668: hr_api.mandatory_arg_error(p_api_name => g_package
669: ,p_argument => 'p_business_group_id'
670: ,p_argument_value => p_business_group_id
671: );

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

694: -- we are doing a restart.
695: --
696: If(p_benefit_action_id is null) then
697:
698: hr_utility.set_location('p_benefit_action_id is null',14);
699: l_restart := FALSE;
700:
701: ben_benefit_actions_api.create_benefit_actions
702: (p_validate => false

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

739: --
740: -- Delete/clear ranges from ben_batch_ranges table
741: --
742: l_actn := 'Delete rows from ben_batch_ranges..';
743: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
744:
745: Delete from ben_batch_ranges
746: Where benefit_action_id = l_benefit_action_id;
747: --

Line 761: hr_utility.set_location('LAMC: person_id='||to_char(l_person_id)||

757: Exit when c_person%notfound;
758: l_cnt := l_cnt + 1;
759:
760:
761: hr_utility.set_location('LAMC: person_id='||to_char(l_person_id)||
762: ' l_cnt='||to_char(l_cnt),18);
763:
764: -- check person rule criteria that the user entered on the submit form.
765: skip := FALSE;

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

805: --
806: -- Store data into person actions table.
807: --
808: If ( not skip) then
809: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
810:
811: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
812: Ben_person_actions_api.create_person_actions
813: (p_validate => false

Line 854: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);

850: End if;
851: End loop;
852: Close c_person;
853:
854: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
855:
856: If (l_num_row <> 0) then
857: l_actn := 'Calling Ben_batch_ranges_api.create_batch_ranges(Last)...';
858: Ben_batch_ranges_api.create_batch_ranges

Line 871: hr_utility.set_location('p_benefit_action_id is not null',30);

867: );
868: l_num_range := l_num_range + 1;
869: End if;
870: Else
871: hr_utility.set_location('p_benefit_action_id is not null',30);
872: l_restart := TRUE;
873: l_benefit_action_id := p_benefit_action_id;
874: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';
875: Ben_batch_utils.create_restart_person_actions

Line 888: hr_utility.set_location('l_num_range '||to_char(l_num_range),30);

884: commit;
885: --
886: -- Now to multithread the code.
887: --
888: hr_utility.set_location('l_num_range '||to_char(l_num_range),30);
889:
890: If l_num_range > 1 then
891: For l_count in 1..least(l_threads,l_num_range)-1 loop
892: --

Line 894: hr_utility.set_location('Submitting BENPRCOM to con-current manager ',32);

890: If l_num_range > 1 then
891: For l_count in 1..least(l_threads,l_num_range)-1 loop
892: --
893: l_actn := 'Submitting job to con-current manager...';
894: hr_utility.set_location('Submitting BENPRCOM to con-current manager ',32);
895:
896: l_request_id := fnd_request.submit_request
897: (application => 'BEN'
898: ,program => 'BENPRCOM'

Line 918: hr_utility.set_location('Calling Ben_batch_utils.print_parameters ',34);

914: := l_request_id;
915: End loop;
916: Elsif (l_num_range = 0 ) then
917: l_actn := 'Calling Ben_batch_utils.print_parameters...';
918: hr_utility.set_location('Calling Ben_batch_utils.print_parameters ',34);
919:
920: Ben_batch_utils.print_parameters
921: (p_thread_id => 99
922: ,p_benefit_action_id => l_benefit_action_id

Line 948: -- hr_utility.set_location ('BEN_91769_NOONE_TO_PROCESS',778);

944: -- noone to process.
945:
946: Ben_batch_utils.write(p_text =>
947: '<< No Person was selected for Participant Premiums with above selection criteria >>' );
948: -- hr_utility.set_location ('BEN_91769_NOONE_TO_PROCESS',778);
949: -- fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
950: -- fnd_message.raise_error;
951: End if;
952:

Line 955: hr_utility.set_location('Calling do_multithread ',34);

951: End if;
952:
953: if (l_num_range <> 0 ) then
954: l_actn := 'Calling do_multithread...';
955: hr_utility.set_location('Calling do_multithread ',34);
956: do_multithread(errbuf => errbuf
957: ,retcode => retcode
958: ,p_validate => p_validate
959: ,p_benefit_action_id => l_benefit_action_id

Line 969: hr_utility.set_location('Calling ben_batch_utils.check_all_slaves_finished ',38);

965: ,p_first_day_of_month => l_first_day_of_month_char
966: );
967: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
968:
969: hr_utility.set_location('Calling ben_batch_utils.check_all_slaves_finished ',38);
970:
971: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
972: end if;
973: --------------------------------------------------------------------------

Line 1018: hr_utility.set_location ('Leaving '||l_proc,70);

1014: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1015: ,p_person_selected => l_person_cnt
1016: ,p_business_group_id => p_business_group_id);
1017: submit_all_reports;
1018: hr_utility.set_location ('Leaving '||l_proc,70);
1019: --
1020: Exception
1021: when others then
1022: ben_batch_utils.rpt_error(p_proc => l_proc

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

1033: ,p_person_selected => l_person_cnt
1034: ,p_business_group_id => p_business_group_id
1035: ) ;
1036: End if;
1037: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1038: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1039: fnd_message.set_token('PROCEDURE', l_proc);
1040: fnd_message.set_token('STEP', l_actn );
1041: fnd_message.raise_error;