eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_REOPEN_LER_CONC dependencies on HR_UTILITY

Line 158: -- hr_utility.trace_on (NULL, 'ORACLE');

154: -- Type declarations
155: --
156: --
157: BEGIN
158: -- hr_utility.trace_on (NULL, 'ORACLE');
159: hr_utility.set_location ('Entering ' || l_proc, 10);
160: -- changing in date format
161: hr_utility.set_location ('Changing date formats ', 20);
162: l_effective_date :=

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

155: --
156: --
157: BEGIN
158: -- hr_utility.trace_on (NULL, 'ORACLE');
159: hr_utility.set_location ('Entering ' || l_proc, 10);
160: -- changing in date format
161: hr_utility.set_location ('Changing date formats ', 20);
162: l_effective_date :=
163: TRUNC (fnd_date.canonical_to_date (p_effective_date));

Line 161: hr_utility.set_location ('Changing date formats ', 20);

157: BEGIN
158: -- hr_utility.trace_on (NULL, 'ORACLE');
159: hr_utility.set_location ('Entering ' || l_proc, 10);
160: -- changing in date format
161: hr_utility.set_location ('Changing date formats ', 20);
162: l_effective_date :=
163: TRUNC (fnd_date.canonical_to_date (p_effective_date));
164: l_from_ocrd_date :=
165: TRUNC (fnd_date.canonical_to_date (p_from_ocrd_date));

Line 172: hr_utility.set_location ('Created fnd session ', 30);

168: --
169: dt_fndate.change_ses_date (p_ses_date => l_effective_date,
170: p_commit => l_commit
171: );
172: hr_utility.set_location ('Created fnd session ', 30);
173: --
174: -- Check business rules and mandatory parameters
175: -- as effective date, ler_id and from occured date are mandatory
176: hr_api.mandatory_arg_error (p_api_name => l_proc,

Line 190: hr_utility.set_location ('Checked mandatory checks ', 20);

186: hr_api.mandatory_arg_error (p_api_name => l_proc,
187: p_argument => 'p_from_ocrd_date',
188: p_argument_value => p_from_ocrd_date
189: );
190: hr_utility.set_location ('Checked mandatory checks ', 20);
191: --
192: --
193: -- Initialize the batch process.
194: --

Line 205: hr_utility.set_location ('l_chunk_size ' || TO_CHAR (l_chunk_size),70);

201: p_threads => l_threads,
202: p_chunk_size => l_chunk_size,
203: p_max_errors => g_max_person_err
204: );
205: hr_utility.set_location ('l_chunk_size ' || TO_CHAR (l_chunk_size),70);
206: hr_utility.set_location ('l_threads ' || TO_CHAR (l_threads),70);
207:
208: --
209: -- If p_benefit_action_id is null then this is a new batch process. Create the

Line 206: hr_utility.set_location ('l_threads ' || TO_CHAR (l_threads),70);

202: p_chunk_size => l_chunk_size,
203: p_max_errors => g_max_person_err
204: );
205: hr_utility.set_location ('l_chunk_size ' || TO_CHAR (l_chunk_size),70);
206: hr_utility.set_location ('l_threads ' || TO_CHAR (l_threads),70);
207:
208: --
209: -- If p_benefit_action_id is null then this is a new batch process. Create the
210: -- batch ranges and person actions. Else restart using the benefit_action_id.

Line 261: hr_utility.set_location('processing from c_pil for person_id: '|| TO_CHAR (l_rec.person_id),40);

257: LOOP
258: --
259: -- set variables for this iteration
260: --
261: hr_utility.set_location('processing from c_pil for person_id: '|| TO_CHAR (l_rec.person_id),40);
262: l_person_ok := 'Y';
263: --
264: -- Check the person selection rule.
265: --

Line 335: hr_utility.set_location ('l_range_id: '||to_char(l_range_id),60);

331: --
332: -- The number of person actions that got created equals the chunk
333: -- size. Create a batch range for the person actions.
334: --
335: hr_utility.set_location ('l_range_id: '||to_char(l_range_id),60);
336: hr_utility.set_location ('l_start_person_actn_id '||to_char(l_start_person_actn_id),60);
337: hr_utility.set_location ('l_end_person_actn_id '||to_char(l_end_person_actn_id),60);
338:
339: ben_batch_ranges_api.create_batch_ranges

Line 336: hr_utility.set_location ('l_start_person_actn_id '||to_char(l_start_person_actn_id),60);

332: -- The number of person actions that got created equals the chunk
333: -- size. Create a batch range for the person actions.
334: --
335: hr_utility.set_location ('l_range_id: '||to_char(l_range_id),60);
336: hr_utility.set_location ('l_start_person_actn_id '||to_char(l_start_person_actn_id),60);
337: hr_utility.set_location ('l_end_person_actn_id '||to_char(l_end_person_actn_id),60);
338:
339: ben_batch_ranges_api.create_batch_ranges
340: (p_validate => FALSE,

Line 337: hr_utility.set_location ('l_end_person_actn_id '||to_char(l_end_person_actn_id),60);

333: -- size. Create a batch range for the person actions.
334: --
335: hr_utility.set_location ('l_range_id: '||to_char(l_range_id),60);
336: hr_utility.set_location ('l_start_person_actn_id '||to_char(l_start_person_actn_id),60);
337: hr_utility.set_location ('l_end_person_actn_id '||to_char(l_end_person_actn_id),60);
338:
339: ben_batch_ranges_api.create_batch_ranges
340: (p_validate => FALSE,
341: p_effective_date => l_effective_date,

Line 358: hr_utility.set_location ('l_num_ranges: ' || TO_CHAR (l_num_ranges),60);

354: --
355: END IF;
356: --
357: END LOOP;
358: hr_utility.set_location ('l_num_ranges: ' || TO_CHAR (l_num_ranges),60);
359: hr_utility.set_location ('l_chunck_num ' || TO_CHAR (l_chunk_num),70);
360: --
361: -- There may be a few person actions left over from the loop above that may
362: -- not have got inserted into a batch range because the number was less than

Line 359: hr_utility.set_location ('l_chunck_num ' || TO_CHAR (l_chunk_num),70);

355: END IF;
356: --
357: END LOOP;
358: hr_utility.set_location ('l_num_ranges: ' || TO_CHAR (l_num_ranges),60);
359: hr_utility.set_location ('l_chunck_num ' || TO_CHAR (l_chunk_num),70);
360: --
361: -- There may be a few person actions left over from the loop above that may
362: -- not have got inserted into a batch range because the number was less than
363: -- the chunk size. Create a range for the remaining person actions. This

Line 393: hr_utility.set_location ( 'Restarting for benefit action id : '|| TO_CHAR (l_benefit_action_id),10);

389: -- for restarting.
390: --
391: l_benefit_action_id := p_benefit_action_id;
392: --
393: hr_utility.set_location ( 'Restarting for benefit action id : '|| TO_CHAR (l_benefit_action_id),10);
394: --
395: ben_batch_utils.create_restart_person_actions
396: (p_benefit_action_id => p_benefit_action_id,
397: p_effective_date => l_effective_date,

Line 414: hr_utility.set_location ('More than one range got created.', 10);

410: --
411: IF l_num_ranges > 1
412: THEN
413: --
414: hr_utility.set_location ('More than one range got created.', 10);
415: --
416: --
417: -- Set the number of threads to the lesser of the defined number of threads
418: -- and the number of ranges created above. There's no point in submitting

Line 431: hr_utility.set_location ('Submitting request no: '|| TO_CHAR (l_count),10);

427: -- We are subtracting one from the number of threads because the main
428: -- process will act as the last thread and will be able to keep track of
429: -- the child requests that get submitted.
430: --
431: hr_utility.set_location ('Submitting request no: '|| TO_CHAR (l_count),10);
432: --
433: l_request_id :=
434: -- submitting the process for multi threading
435: fnd_request.submit_request (application => 'BEN',

Line 459: hr_utility.set_location ('l_num_ranges = 0 ', 50);

455: END LOOP;
456: ELSIF (l_num_ranges = 0)
457: THEN
458: --
459: hr_utility.set_location ('l_num_ranges = 0 ', 50);
460: hr_utility.set_location ('p_validate ' || p_validate, 10);
461: ben_batch_utils.print_parameters
462: (p_thread_id => 99,
463: p_benefit_action_id => l_benefit_action_id,

Line 460: hr_utility.set_location ('p_validate ' || p_validate, 10);

456: ELSIF (l_num_ranges = 0)
457: THEN
458: --
459: hr_utility.set_location ('l_num_ranges = 0 ', 50);
460: hr_utility.set_location ('p_validate ' || p_validate, 10);
461: ben_batch_utils.print_parameters
462: (p_thread_id => 99,
463: p_benefit_action_id => l_benefit_action_id,
464: p_validate => p_validate,

Line 489: hr_utility.set_location ('Submitting the master process', 10);

485: END IF;
486: --
487: -- Carry on with the master. This will ensure that the master finishes last.
488: --
489: hr_utility.set_location ('Submitting the master process', 10);
490: --
491: do_multithread (errbuf => errbuf,
492: retcode => retcode,
493: p_validate => p_validate,

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

513: -- Submit reports.
514: --
515: submit_all_reports;
516: --
517: hr_utility.set_location ('Leaving ' || l_proc, 10);
518: --
519: EXCEPTION
520: -- bug: 5589226
521: when l_no_one_to_process then

Line 532: hr_utility.set_location ('Un identified Exception ', 80);

528: DECLARE
529: l_sqlerrm VARCHAR2 (100);
530: BEGIN
531: l_sqlerrm := SUBSTR (SQLERRM, 1, 100);
532: hr_utility.set_location ('Un identified Exception ', 80);
533: hr_utility.set_location (l_sqlerrm, 90);
534: END;
535:
536: ben_batch_utils.rpt_error (p_proc => l_proc,

Line 533: hr_utility.set_location (l_sqlerrm, 90);

529: l_sqlerrm VARCHAR2 (100);
530: BEGIN
531: l_sqlerrm := SUBSTR (SQLERRM, 1, 100);
532: hr_utility.set_location ('Un identified Exception ', 80);
533: hr_utility.set_location (l_sqlerrm, 90);
534: END;
535:
536: ben_batch_utils.rpt_error (p_proc => l_proc,
537: p_last_actn => l_actn,

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

661: l_message_name VARCHAR2 (2000);
662: g_rec ben_type.g_report_rec;
663: --
664: BEGIN
665: hr_utility.set_location ('Entering ' || l_proc, 10);
666: l_effective_date :=
667: TRUNC (fnd_date.canonical_to_date (p_effective_date));
668: --
669: -- Put row in fnd_sessions

Line 726: hr_utility.set_location ('p_validate ' || p_validate, 10);

722: END IF;
723: --
724: -- Print the parameters to the log file.
725: --
726: hr_utility.set_location ('p_validate ' || p_validate, 10);
727: ben_batch_utils.print_parameters
728: (p_thread_id => p_thread_id,
729: p_benefit_action_id => p_benefit_action_id,
730: p_validate => p_validate,

Line 759: hr_utility.set_location ('Updated range '|| TO_CHAR (l_range_id)|| ' status code to P',10);

755: UPDATE ben_batch_ranges ran
756: SET ran.range_status_cd = 'P'
757: WHERE ran.range_id = l_range_id;
758: --
759: hr_utility.set_location ('Updated range '|| TO_CHAR (l_range_id)|| ' status code to P',10);
760: --
761: COMMIT;
762: --
763: -- Remove all records from cache

Line 771: hr_utility.set_location ('Load person actions into the cache', 10);

767: OPEN c_person_thread;
768: --
769: l_record_number := 0;
770: --
771: hr_utility.set_location ('Load person actions into the cache', 10);
772: --
773: LOOP
774: --
775: FETCH c_person_thread

Line 808: hr_utility.set_location('Reopening Life event for '|| TO_CHAR(g_cache_per_proc (l_cnt).person_id),10);

804: THEN
805: fnd_message.set_name('BEN','BEN_94665_BENROLER_ERROR_LIMIT');
806: fnd_message.raise_error;
807: END IF;
808: hr_utility.set_location('Reopening Life event for '|| TO_CHAR(g_cache_per_proc (l_cnt).person_id),10);
809: --
810: hr_utility.set_location ('Printing person details ', 20);
811: -- Storing the value for a person
812: l_person_id := g_cache_per_proc (l_cnt).person_id;

Line 810: hr_utility.set_location ('Printing person details ', 20);

806: fnd_message.raise_error;
807: END IF;
808: hr_utility.set_location('Reopening Life event for '|| TO_CHAR(g_cache_per_proc (l_cnt).person_id),10);
809: --
810: hr_utility.set_location ('Printing person details ', 20);
811: -- Storing the value for a person
812: l_person_id := g_cache_per_proc (l_cnt).person_id;
813: ben_manage_life_events.person_header
814: (p_person_id => g_cache_per_proc(l_cnt).person_id,

Line 818: hr_utility.set_location ('Printed person header', 30);

814: (p_person_id => g_cache_per_proc(l_cnt).person_id,
815: p_business_group_id => p_business_group_id,
816: p_effective_date => l_effective_date
817: );
818: hr_utility.set_location ('Printed person header', 30);
819:
820: BEGIN
821: hr_utility.set_location('Before Api call ',10);
822: OPEN c_per_in_ler (g_cache_per_proc (l_cnt).ler_id);

Line 821: hr_utility.set_location('Before Api call ',10);

817: );
818: hr_utility.set_location ('Printed person header', 30);
819:
820: BEGIN
821: hr_utility.set_location('Before Api call ',10);
822: OPEN c_per_in_ler (g_cache_per_proc (l_cnt).ler_id);
823: LOOP
824: FETCH c_per_in_ler
825: INTO l_lf_evt_ocrd_dt, l_object_version_number;

Line 829: hr_utility.set_location ('Calling main proc', 10);

825: INTO l_lf_evt_ocrd_dt, l_object_version_number;
826: EXIT;
827: END LOOP;
828: CLOSE c_per_in_ler;
829: hr_utility.set_location ('Calling main proc', 10);
830: -- call the procedure for reopening here
831: ben_close_enrollment.reopen_single_life_event
832: (p_per_in_ler_id => g_cache_per_proc(l_cnt).ler_id,
833: p_person_id => g_cache_per_proc(l_cnt).person_id,

Line 901: hr_utility.set_location ('No records found. Erroring out.', 10);

897: --
898: END LOOP;
899: ELSE
900: --
901: hr_utility.set_location ('No records found. Erroring out.', 10);
902: --
903: l_actn := 'Reporting error since there is no record found';
904: --
905: fnd_message.set_name ('BEN', 'BEN_91906_PER_NOT_FND_IN_RNG');

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

930: ben_batch_utils.write_logfile (p_num_pers_processed => g_persons_procd,
931: p_num_pers_errored => g_persons_errored
932: );
933: --
934: hr_utility.set_location ('Leaving ' || l_proc, 70);
935: --
936: EXCEPTION
937: --
938: WHEN OTHERS

Line 943: hr_utility.set_location ('BENROLER Super Error ' || l_proc, 10);

939: THEN
940: --
941: ROLLBACK;
942: --
943: hr_utility.set_location ('BENROLER Super Error ' || l_proc, 10);
944: hr_utility.set_location (SQLERRM, 10);
945: benutils.rollback_cache;
946: g_rec.rep_typ_cd := 'FATAL';
947: g_rec.text := fnd_message.get;

Line 944: hr_utility.set_location (SQLERRM, 10);

940: --
941: ROLLBACK;
942: --
943: hr_utility.set_location ('BENROLER Super Error ' || l_proc, 10);
944: hr_utility.set_location (SQLERRM, 10);
945: benutils.rollback_cache;
946: g_rec.rep_typ_cd := 'FATAL';
947: g_rec.text := fnd_message.get;
948: g_rec.person_id := l_person_id;

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

981: l_request_id NUMBER;
982: --
983: BEGIN
984: --
985: hr_utility.set_location ('Entering ' || l_proc, 05);
986:
987: --
988: IF fnd_global.conc_request_id <> -1
989: THEN

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

1004: --
1005: END IF;
1006:
1007: --
1008: hr_utility.set_location ('Leaving ' || l_proc, 10);
1009: --
1010: EXCEPTION
1011: --
1012: WHEN OTHERS