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.HR_JP_DATA_MIGRATION_PKG dependencies on HR_UTILITY

Line 94: hr_utility.set_location('Start ' || p_mode || p_parameter_name, 5);

90:
91: --
92: BEGIN
93:
94: hr_utility.set_location('Start ' || p_mode || p_parameter_name, 5);
95: if p_mode = 'ELE_RR_COPY_TO' then
96: -- find ELE_RR_COPY_FROM element_type_id
97: l_element_type_id_to := p_parameter_value;
98: --

Line 129: hr_utility.trace('Successefully created run_result');

125: from pay_run_results prr_to
126: where prr_to.assignment_action_id = prr_from.assignment_action_id
127: and prr_to.element_type_id = l_element_type_id_to);
128:
129: hr_utility.trace('Successefully created run_result');
130:
131: -- get related input values
132: for rec_related_iv in csr_related_iv
133: loop

Line 181: hr_utility.trace('Successefully created run_result_value');

177: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
178:
179: end if;
180: end loop;
181: hr_utility.trace('Successefully created run_result_value');
182: end if;
183: end if;
184: END;
185:

Line 266: hr_utility.set_location('Start procedure in the hr_jp_data_migration_pkg' || p_mode || p_parameter_name, 5);

262:
263: --
264: BEGIN
265:
266: hr_utility.set_location('Start procedure in the hr_jp_data_migration_pkg' || p_mode || p_parameter_name, 5);
267: if p_mode = 'ADD_NEW_IV' then
268: l_input_value_id_to := p_parameter_value;
269:
270: -- find element_link_id of parent element

Line 317: hr_utility.trace('Successefully created link_input_value '|| to_char(rec_element_link.element_link_id));

313: select null
314: from pay_link_input_values_f
315: where element_link_id = rec_element_link.element_link_id
316: and input_value_id = l_input_value_id_to);
317: hr_utility.trace('Successefully created link_input_value '|| to_char(rec_element_link.element_link_id));
318:
319: for rec_element_entry in csr_element_entry_id(rec_element_link.element_link_id,l_input_value_id_to) loop
320: insert into pay_element_entry_values_f(
321: ELEMENT_ENTRY_VALUE_ID,

Line 342: hr_utility.trace('Successefully created element_entry_value');

338: commit;
339: l_total_upd_actions := 0;
340: end if;
341: end loop;
342: hr_utility.trace('Successefully created element_entry_value');
343: if l_total_upd_actions > 0 then
344: l_total_upd_actions := 0;
345: commit;
346: end if;

Line 366: hr_utility.trace('Successefully created run_result_value '|| to_char(l_input_value_id_to));

362: commit;
363: l_total_upd_actions := 0;
364: end if;
365: end loop;
366: hr_utility.trace('Successefully created run_result_value '|| to_char(l_input_value_id_to));
367:
368: if l_total_upd_actions > 0 then
369: commit;
370: end if;

Line 418: hr_utility.set_location('Start procedure in the hr_jp_data_migration_pkg' || p_mode || p_parameter_name, 5);

414: and p_session_date
415: between pee.effective_start_date and pee.effective_end_date;
416:
417: BEGIN
418: hr_utility.set_location('Start procedure in the hr_jp_data_migration_pkg' || p_mode || p_parameter_name, 5);
419: if p_mode = 'ELE_END_ENTRY' then
420: l_element_type_id := p_parameter_value;
421: for rec_element_link in csr_element_link_id
422: loop

Line 482: hr_utility.set_location(l_proc,0);

478: --
479: begin
480: --
481: if g_debug then
482: hr_utility.set_location(l_proc,0);
483: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
484: end if;
485: --
486: if g_ass_info.ass_id <> p_assignment_id

Line 483: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));

479: begin
480: --
481: if g_debug then
482: hr_utility.set_location(l_proc,0);
483: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
484: end if;
485: --
486: if g_ass_info.ass_id <> p_assignment_id
487: or g_ass_info.ass_id is null then

Line 501: hr_utility.set_location(l_proc,1000);

497: --
498: end if;
499: --
500: if g_debug then
501: hr_utility.set_location(l_proc,1000);
502: end if;
503: --
504: return g_ass_info;
505: --

Line 519: hr_utility.set_location(l_proc,0);

515: --
516: begin
517: --
518: if g_debug then
519: hr_utility.set_location(l_proc,0);
520: end if;
521: --
522: c_com_hi_smr_elm_id := hr_jp_id_pkg.element_type_id(c_com_hi_smr_elm,null,c_legislation_code,c_skip_warning);
523: c_am_iv_id := hr_jp_id_pkg.input_value_id(c_com_hi_smr_elm_id,c_am_iv,c_skip_warning);

Line 531: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));

527: c_smr_o_iv_id := hr_jp_id_pkg.input_value_id(c_com_hi_smr_elm_id,c_smr_o_iv,c_skip_warning);
528: c_at_iv_id := hr_jp_id_pkg.input_value_id(c_com_hi_smr_elm_id,c_at_iv,c_skip_warning);
529: --
530: if g_debug then
531: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
532: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));

Line 532: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));

528: c_at_iv_id := hr_jp_id_pkg.input_value_id(c_com_hi_smr_elm_id,c_at_iv,c_skip_warning);
529: --
530: if g_debug then
531: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
532: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));

Line 533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));

529: --
530: if g_debug then
531: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
532: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
537: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));

Line 534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));

530: if g_debug then
531: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
532: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
537: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
538: hr_utility.set_location(l_proc,1000);

Line 535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));

531: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
532: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
537: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
538: hr_utility.set_location(l_proc,1000);
539: end if;

Line 536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));

532: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
537: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
538: hr_utility.set_location(l_proc,1000);
539: end if;
540: --

Line 537: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));

533: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
537: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
538: hr_utility.set_location(l_proc,1000);
539: end if;
540: --
541: end set_hi_smr_id;

Line 538: hr_utility.set_location(l_proc,1000);

534: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
535: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
536: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
537: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
538: hr_utility.set_location(l_proc,1000);
539: end if;
540: --
541: end set_hi_smr_id;
542: --

Line 554: hr_utility.set_location(l_proc,0);

550: --
551: begin
552: --
553: if g_debug then
554: hr_utility.set_location(l_proc,0);
555: end if;
556: --
557: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
558: c_fut_exist_mesg := fnd_message.get;

Line 573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);

569: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_MR_NULL');
570: c_mr_null_mesg := fnd_message.get;
571: --
572: if g_debug then
573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
575: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
576: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
577: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);

Line 574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);

570: c_mr_null_mesg := fnd_message.get;
571: --
572: if g_debug then
573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
575: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
576: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
577: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
578: hr_utility.set_location(l_proc,1000);

Line 575: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);

571: --
572: if g_debug then
573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
575: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
576: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
577: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
578: hr_utility.set_location(l_proc,1000);
579: end if;

Line 576: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);

572: if g_debug then
573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
575: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
576: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
577: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
578: hr_utility.set_location(l_proc,1000);
579: end if;
580: --

Line 577: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);

573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
575: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
576: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
577: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
578: hr_utility.set_location(l_proc,1000);
579: end if;
580: --
581: end set_hi_smr_mesg;

Line 578: hr_utility.set_location(l_proc,1000);

574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
575: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
576: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
577: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
578: hr_utility.set_location(l_proc,1000);
579: end if;
580: --
581: end set_hi_smr_mesg;
582: --

Line 594: hr_utility.set_location(l_proc,0);

590: --
591: begin
592: --
593: if g_debug then
594: hr_utility.set_location(l_proc,0);
595: end if;
596: --
597: c_yea_dep_exm_elm_id := hr_jp_id_pkg.element_type_id(c_yea_dep_exm_elm,null,c_legislation_code,c_skip_warning);
598: c_sec_sal_iv_id := hr_jp_id_pkg.input_value_id(c_yea_dep_exm_elm_id,c_sec_sal_iv,c_skip_warning);

Line 601: hr_utility.trace('c_yea_dep_exm_elm_id : '||to_char(c_yea_dep_exm_elm_id));

597: c_yea_dep_exm_elm_id := hr_jp_id_pkg.element_type_id(c_yea_dep_exm_elm,null,c_legislation_code,c_skip_warning);
598: c_sec_sal_iv_id := hr_jp_id_pkg.input_value_id(c_yea_dep_exm_elm_id,c_sec_sal_iv,c_skip_warning);
599: --
600: if g_debug then
601: hr_utility.trace('c_yea_dep_exm_elm_id : '||to_char(c_yea_dep_exm_elm_id));
602: hr_utility.trace('c_sec_sal_iv_id : '||to_char(c_sec_sal_iv_id));
603: hr_utility.set_location(l_proc,1000);
604: end if;
605: --

Line 602: hr_utility.trace('c_sec_sal_iv_id : '||to_char(c_sec_sal_iv_id));

598: c_sec_sal_iv_id := hr_jp_id_pkg.input_value_id(c_yea_dep_exm_elm_id,c_sec_sal_iv,c_skip_warning);
599: --
600: if g_debug then
601: hr_utility.trace('c_yea_dep_exm_elm_id : '||to_char(c_yea_dep_exm_elm_id));
602: hr_utility.trace('c_sec_sal_iv_id : '||to_char(c_sec_sal_iv_id));
603: hr_utility.set_location(l_proc,1000);
604: end if;
605: --
606: end set_dep_id;

Line 603: hr_utility.set_location(l_proc,1000);

599: --
600: if g_debug then
601: hr_utility.trace('c_yea_dep_exm_elm_id : '||to_char(c_yea_dep_exm_elm_id));
602: hr_utility.trace('c_sec_sal_iv_id : '||to_char(c_sec_sal_iv_id));
603: hr_utility.set_location(l_proc,1000);
604: end if;
605: --
606: end set_dep_id;
607: --

Line 619: hr_utility.set_location(l_proc,0);

615: --
616: begin
617: --
618: if g_debug then
619: hr_utility.set_location(l_proc,0);
620: end if;
621: --
622: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_FUT_EXIST');
623: c_dep_fut_cei_exist_mesg := fnd_message.get;

Line 635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);

631: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
632: c_dep_fut_ee_exist_mesg := fnd_message.get;
633: --
634: if g_debug then
635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);
636: hr_utility.trace('c_dep_fut_cei_oe_exist_mesg : '||c_dep_fut_cei_oe_exist_mesg);
637: hr_utility.trace('c_dep_already_ee_upd_mesg : '||c_dep_already_ee_upd_mesg);
638: hr_utility.trace('c_dep_fut_ee_exist_mesg : '||c_dep_fut_ee_exist_mesg);
639: hr_utility.set_location(l_proc,1000);

Line 636: hr_utility.trace('c_dep_fut_cei_oe_exist_mesg : '||c_dep_fut_cei_oe_exist_mesg);

632: c_dep_fut_ee_exist_mesg := fnd_message.get;
633: --
634: if g_debug then
635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);
636: hr_utility.trace('c_dep_fut_cei_oe_exist_mesg : '||c_dep_fut_cei_oe_exist_mesg);
637: hr_utility.trace('c_dep_already_ee_upd_mesg : '||c_dep_already_ee_upd_mesg);
638: hr_utility.trace('c_dep_fut_ee_exist_mesg : '||c_dep_fut_ee_exist_mesg);
639: hr_utility.set_location(l_proc,1000);
640: end if;

Line 637: hr_utility.trace('c_dep_already_ee_upd_mesg : '||c_dep_already_ee_upd_mesg);

633: --
634: if g_debug then
635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);
636: hr_utility.trace('c_dep_fut_cei_oe_exist_mesg : '||c_dep_fut_cei_oe_exist_mesg);
637: hr_utility.trace('c_dep_already_ee_upd_mesg : '||c_dep_already_ee_upd_mesg);
638: hr_utility.trace('c_dep_fut_ee_exist_mesg : '||c_dep_fut_ee_exist_mesg);
639: hr_utility.set_location(l_proc,1000);
640: end if;
641: --

Line 638: hr_utility.trace('c_dep_fut_ee_exist_mesg : '||c_dep_fut_ee_exist_mesg);

634: if g_debug then
635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);
636: hr_utility.trace('c_dep_fut_cei_oe_exist_mesg : '||c_dep_fut_cei_oe_exist_mesg);
637: hr_utility.trace('c_dep_already_ee_upd_mesg : '||c_dep_already_ee_upd_mesg);
638: hr_utility.trace('c_dep_fut_ee_exist_mesg : '||c_dep_fut_ee_exist_mesg);
639: hr_utility.set_location(l_proc,1000);
640: end if;
641: --
642: end set_dep_mesg;

Line 639: hr_utility.set_location(l_proc,1000);

635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);
636: hr_utility.trace('c_dep_fut_cei_oe_exist_mesg : '||c_dep_fut_cei_oe_exist_mesg);
637: hr_utility.trace('c_dep_already_ee_upd_mesg : '||c_dep_already_ee_upd_mesg);
638: hr_utility.trace('c_dep_fut_ee_exist_mesg : '||c_dep_fut_ee_exist_mesg);
639: hr_utility.set_location(l_proc,1000);
640: end if;
641: --
642: end set_dep_mesg;
643: --

Line 682: hr_utility.set_location(l_proc,0);

678: --
679: begin
680: --
681: if g_debug then
682: hr_utility.set_location(l_proc,0);
683: hr_utility.trace('g_mig_date : '||to_char(g_mig_date,'YYYY/MM/DD'));
684: end if;
685: --
686: if g_debug then

Line 683: hr_utility.trace('g_mig_date : '||to_char(g_mig_date,'YYYY/MM/DD'));

679: begin
680: --
681: if g_debug then
682: hr_utility.set_location(l_proc,0);
683: hr_utility.trace('g_mig_date : '||to_char(g_mig_date,'YYYY/MM/DD'));
684: end if;
685: --
686: if g_debug then
687: hr_utility.set_location(l_proc,1000);

Line 687: hr_utility.set_location(l_proc,1000);

683: hr_utility.trace('g_mig_date : '||to_char(g_mig_date,'YYYY/MM/DD'));
684: end if;
685: --
686: if g_debug then
687: hr_utility.set_location(l_proc,1000);
688: end if;
689: --
690: return g_mig_date;
691: --

Line 762: hr_utility.set_location(l_proc,0);

758: --
759: begin
760: --
761: if g_debug then
762: hr_utility.set_location(l_proc,0);
763: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
764: end if;
765: --
766: if g_qualify_ini_ass_id is null

Line 763: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));

759: begin
760: --
761: if g_debug then
762: hr_utility.set_location(l_proc,0);
763: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
764: end if;
765: --
766: if g_qualify_ini_ass_id is null
767: or g_qualify_ini_ass_id = p_assignment_id then

Line 777: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));

773: --
774: end if;
775: --
776: if g_debug then
777: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
778: hr_utility.set_location(l_proc,1000);
779: end if;
780: --
781: end qualify_hi_smr_hd;

Line 778: hr_utility.set_location(l_proc,1000);

774: end if;
775: --
776: if g_debug then
777: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
778: hr_utility.set_location(l_proc,1000);
779: end if;
780: --
781: end qualify_hi_smr_hd;
782: --

Line 796: hr_utility.set_location(l_proc,0);

792: --
793: begin
794: --
795: if g_debug then
796: hr_utility.set_location(l_proc,0);
797: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
798: end if;
799: --
800: if g_migrate_ini_ass_id is null

Line 797: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));

793: begin
794: --
795: if g_debug then
796: hr_utility.set_location(l_proc,0);
797: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
798: end if;
799: --
800: if g_migrate_ini_ass_id is null
801: or g_migrate_ini_ass_id = p_assignment_id then

Line 811: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));

807: --
808: end if;
809: --
810: if g_debug then
811: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
812: hr_utility.set_location(l_proc,1000);
813: end if;
814: --
815: end migrate_hi_smr_hd;

Line 812: hr_utility.set_location(l_proc,1000);

808: end if;
809: --
810: if g_debug then
811: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
812: hr_utility.set_location(l_proc,1000);
813: end if;
814: --
815: end migrate_hi_smr_hd;
816: --

Line 829: hr_utility.set_location(l_proc,0);

825: --
826: begin
827: --
828: if g_debug then
829: hr_utility.set_location(l_proc,0);
830: hr_utility.trace('g_legislation_code : '||g_legislation_code);
831: end if;
832: --
833: -- temporary solution because of no initialize.

Line 830: hr_utility.trace('g_legislation_code : '||g_legislation_code);

826: begin
827: --
828: if g_debug then
829: hr_utility.set_location(l_proc,0);
830: hr_utility.trace('g_legislation_code : '||g_legislation_code);
831: end if;
832: --
833: -- temporary solution because of no initialize.
834: -- run once for each thread.

Line 851: hr_utility.trace('g_legislation_code : '||g_legislation_code);

847: --
848: end if;
849: --
850: if g_debug then
851: hr_utility.trace('g_legislation_code : '||g_legislation_code);
852: hr_utility.set_location(l_proc,1000);
853: end if;
854: --
855: end init_def_hi_smr_data;

Line 852: hr_utility.set_location(l_proc,1000);

848: end if;
849: --
850: if g_debug then
851: hr_utility.trace('g_legislation_code : '||g_legislation_code);
852: hr_utility.set_location(l_proc,1000);
853: end if;
854: --
855: end init_def_hi_smr_data;
856: --

Line 917: hr_utility.set_location(l_proc,0);

913: --
914: begin
915: --
916: if g_detail_debug then
917: hr_utility.set_location(l_proc,0);
918: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
919: end if;
920: --
921: if p_valid_delete = 'N' then

Line 918: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');

914: begin
915: --
916: if g_detail_debug then
917: hr_utility.set_location(l_proc,0);
918: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
919: end if;
920: --
921: if p_valid_delete = 'N' then
922: --

Line 948: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_already_upd_mesg);

944: if g_sql_run = 'Y' then
945: --
946: if g_log = 'Y' then
947: --
948: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_already_upd_mesg);
949: --
950: end if;
951: --
952: else

Line 963: hr_utility.set_location(l_proc,10);

959: --
960: end if;
961: --
962: if g_detail_debug then
963: hr_utility.set_location(l_proc,10);
964: hr_utility.trace('skip manual upd : l_valid_delete : '||l_valid_delete);
965: end if;
966: --
967: -- skip future entry exists

Line 964: hr_utility.trace('skip manual upd : l_valid_delete : '||l_valid_delete);

960: end if;
961: --
962: if g_detail_debug then
963: hr_utility.set_location(l_proc,10);
964: hr_utility.trace('skip manual upd : l_valid_delete : '||l_valid_delete);
965: end if;
966: --
967: -- skip future entry exists
968: --

Line 983: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_exist_mesg);

979: if g_sql_run = 'Y' then
980: --
981: if g_log = 'Y' then
982: --
983: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_exist_mesg);
984: --
985: end if;
986: --
987: else

Line 998: hr_utility.set_location(l_proc,20);

994: --
995: end if;
996: --
997: if g_detail_debug then
998: hr_utility.set_location(l_proc,20);
999: hr_utility.trace('skip future entry : l_valid_delete : '||l_valid_delete);
1000: end if;
1001: --
1002: -- skip in update mode applied month is future (>= p_session_date)

Line 999: hr_utility.trace('skip future entry : l_valid_delete : '||l_valid_delete);

995: end if;
996: --
997: if g_detail_debug then
998: hr_utility.set_location(l_proc,20);
999: hr_utility.trace('skip future entry : l_valid_delete : '||l_valid_delete);
1000: end if;
1001: --
1002: -- skip in update mode applied month is future (>= p_session_date)
1003: --

Line 1024: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_am_mesg);

1020: if g_sql_run = 'Y' then
1021: --
1022: if g_log = 'Y' then
1023: --
1024: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_am_mesg);
1025: --
1026: end if;
1027: --
1028: else

Line 1044: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_am_null_mesg);

1040: if g_sql_run = 'Y' then
1041: --
1042: if g_log = 'Y' then
1043: --
1044: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_am_null_mesg);
1045: --
1046: end if;
1047: --
1048: else

Line 1059: hr_utility.set_location(l_proc,30);

1055: --
1056: end if;
1057: --
1058: if g_detail_debug then
1059: hr_utility.set_location(l_proc,30);
1060: hr_utility.trace('skip applied month in future : l_valid_delete : '||l_valid_delete);
1061: end if;
1062: --
1063: -- skip mr is null.

Line 1060: hr_utility.trace('skip applied month in future : l_valid_delete : '||l_valid_delete);

1056: end if;
1057: --
1058: if g_detail_debug then
1059: hr_utility.set_location(l_proc,30);
1060: hr_utility.trace('skip applied month in future : l_valid_delete : '||l_valid_delete);
1061: end if;
1062: --
1063: -- skip mr is null.
1064: -- target only assignment, who belongs to new mr range.

Line 1081: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_mr_null_mesg);

1077: if g_sql_run = 'Y' then
1078: --
1079: if g_log = 'Y' then
1080: --
1081: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_mr_null_mesg);
1082: --
1083: end if;
1084: --
1085: else

Line 1109: hr_utility.set_location(l_proc,40);

1105: --
1106: end if;
1107: --
1108: if g_detail_debug then
1109: hr_utility.set_location(l_proc,40);
1110: hr_utility.trace('skip mr is null or out range : l_valid_delete : '||l_valid_delete);
1111: end if;
1112: --
1113: if l_valid_delete = 'Y' then

Line 1110: hr_utility.trace('skip mr is null or out range : l_valid_delete : '||l_valid_delete);

1106: end if;
1107: --
1108: if g_detail_debug then
1109: hr_utility.set_location(l_proc,40);
1110: hr_utility.trace('skip mr is null or out range : l_valid_delete : '||l_valid_delete);
1111: end if;
1112: --
1113: if l_valid_delete = 'Y' then
1114: --

Line 1122: hr_utility.set_location(l_proc,1000);

1118: --
1119: end if;
1120: --
1121: if g_detail_debug then
1122: hr_utility.set_location(l_proc,1000);
1123: end if;
1124: --
1125: exception
1126: when others then

Line 1129: hr_utility.set_location(l_proc,-1000);

1125: exception
1126: when others then
1127: --
1128: if g_debug then
1129: hr_utility.set_location(l_proc,-1000);
1130: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1131: end if;
1132: --
1133: end val_mig_smr_assact;

Line 1130: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);

1126: when others then
1127: --
1128: if g_debug then
1129: hr_utility.set_location(l_proc,-1000);
1130: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1131: end if;
1132: --
1133: end val_mig_smr_assact;
1134: --

Line 1199: hr_utility.set_location(l_proc,0);

1195: --
1196: begin
1197: --
1198: if g_detail_debug then
1199: hr_utility.set_location(l_proc,0);
1200: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
1201: end if;
1202: --
1203: open csr_entry;

Line 1200: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');

1196: begin
1197: --
1198: if g_detail_debug then
1199: hr_utility.set_location(l_proc,0);
1200: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
1201: end if;
1202: --
1203: open csr_entry;
1204: loop

Line 1231: hr_utility.set_location(l_proc,10);

1227: end loop;
1228: close csr_entry;
1229: --
1230: if g_detail_debug then
1231: hr_utility.set_location(l_proc,10);
1232: hr_utility.trace('l_smr_eev : '||l_smr_eev||', l_smr_o_eev : '||l_smr_o_eev||', l_mr_eev : '||l_mr_eev||', l_mr_o_eev : '||l_mr_o_eev);
1233: end if;
1234: --
1235: if p_hi_mr is not null then

Line 1232: hr_utility.trace('l_smr_eev : '||l_smr_eev||', l_smr_o_eev : '||l_smr_o_eev||', l_mr_eev : '||l_mr_eev||', l_mr_o_eev : '||l_mr_o_eev);

1228: close csr_entry;
1229: --
1230: if g_detail_debug then
1231: hr_utility.set_location(l_proc,10);
1232: hr_utility.trace('l_smr_eev : '||l_smr_eev||', l_smr_o_eev : '||l_smr_o_eev||', l_mr_eev : '||l_mr_eev||', l_mr_o_eev : '||l_mr_o_eev);
1233: end if;
1234: --
1235: if p_hi_mr is not null then
1236: --

Line 1253: hr_utility.set_location(l_proc,20);

1249: p_row_value => l_exp_mr_eev,
1250: p_effective_date => p_session_date))),0,60);
1251: --
1252: if g_detail_debug then
1253: hr_utility.set_location(l_proc,20);
1254: hr_utility.trace('l_exp_mr_eev : '||l_exp_mr_eev||', l_exp_smr_eev : '||l_exp_smr_eev);
1255: end if;
1256: --
1257: if g_exc_match_exp_smr = 'Y' then

Line 1254: hr_utility.trace('l_exp_mr_eev : '||l_exp_mr_eev||', l_exp_smr_eev : '||l_exp_smr_eev);

1250: p_effective_date => p_session_date))),0,60);
1251: --
1252: if g_detail_debug then
1253: hr_utility.set_location(l_proc,20);
1254: hr_utility.trace('l_exp_mr_eev : '||l_exp_mr_eev||', l_exp_smr_eev : '||l_exp_smr_eev);
1255: end if;
1256: --
1257: if g_exc_match_exp_smr = 'Y' then
1258: --

Line 1280: hr_utility.set_location(l_proc,30);

1276: --
1277: end if;
1278: --
1279: if g_detail_debug then
1280: hr_utility.set_location(l_proc,30);
1281: hr_utility.trace('l_exp_smr_o_eev : '||l_exp_smr_o_eev||', l_exp_mr_o_eev : '||l_exp_mr_o_eev);
1282: end if;
1283: --
1284: l_ovn := l_csr_entry.object_version_number;

Line 1281: hr_utility.trace('l_exp_smr_o_eev : '||l_exp_smr_o_eev||', l_exp_mr_o_eev : '||l_exp_mr_o_eev);

1277: end if;
1278: --
1279: if g_detail_debug then
1280: hr_utility.set_location(l_proc,30);
1281: hr_utility.trace('l_exp_smr_o_eev : '||l_exp_smr_o_eev||', l_exp_mr_o_eev : '||l_exp_mr_o_eev);
1282: end if;
1283: --
1284: l_ovn := l_csr_entry.object_version_number;
1285: --

Line 1314: hr_utility.set_location(l_proc,40);

1310: p_effective_end_date => l_eed,
1311: p_update_warning => l_warning);
1312: --
1313: if g_detail_debug then
1314: hr_utility.set_location(l_proc,40);
1315: end if;
1316: --
1317: end if;
1318: --

Line 1323: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));

1319: if g_sql_run = 'Y' then
1320: --
1321: if g_log = 'Y' then
1322: --
1323: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));
1324: --
1325: end if;
1326: --
1327: else

Line 1339: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' X '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));

1335: if g_sql_run = 'Y' then
1336: --
1337: if g_log = 'Y' then
1338: --
1339: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' X '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));
1340: --
1341: end if;
1342: --
1343: else

Line 1350: hr_utility.set_location(l_proc,45);

1346: --
1347: end if;
1348: --
1349: if g_detail_debug then
1350: hr_utility.set_location(l_proc,45);
1351: end if;
1352: --
1353: end if;
1354: --

Line 1356: hr_utility.set_location(l_proc,1000);

1352: --
1353: end if;
1354: --
1355: if g_detail_debug then
1356: hr_utility.set_location(l_proc,1000);
1357: end if;
1358: --
1359: exception
1360: when hr_api.object_locked then

Line 1363: hr_utility.set_location(l_proc,-1000);

1359: exception
1360: when hr_api.object_locked then
1361: --
1362: if g_debug then
1363: hr_utility.set_location(l_proc,-1000);
1364: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1365: end if;
1366: --
1367: if g_sql_run = 'Y' then

Line 1364: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));

1360: when hr_api.object_locked then
1361: --
1362: if g_debug then
1363: hr_utility.set_location(l_proc,-1000);
1364: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1365: end if;
1366: --
1367: if g_sql_run = 'Y' then
1368: --

Line 1371: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));

1367: if g_sql_run = 'Y' then
1368: --
1369: if g_log = 'Y' then
1370: --
1371: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1372: --
1373: end if;
1374: --
1375: else

Line 1384: hr_utility.set_location(l_proc,-1000);

1380: --
1381: when others then
1382: --
1383: if g_debug then
1384: hr_utility.set_location(l_proc,-1000);
1385: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1386: end if;
1387: --
1388: if g_sql_run = 'Y' then

Line 1385: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);

1381: when others then
1382: --
1383: if g_debug then
1384: hr_utility.set_location(l_proc,-1000);
1385: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1386: end if;
1387: --
1388: if g_sql_run = 'Y' then
1389: --

Line 1392: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);

1388: if g_sql_run = 'Y' then
1389: --
1390: if g_log = 'Y' then
1391: --
1392: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);
1393: --
1394: end if;
1395: --
1396: else

Line 1454: hr_utility.set_location(l_proc,0);

1450: g_debug := false;
1451: end if;
1452: --
1453: if g_debug then
1454: hr_utility.set_location(l_proc,0);
1455: end if;
1456: --
1457: if g_skip_qualify is null then
1458: g_skip_qualify := 'N';

Line 1490: hr_utility.set_location(l_proc,10);

1486: -- for api use
1487: insert_session(g_mig_date);
1488: --
1489: if g_debug then
1490: hr_utility.set_location(l_proc,10);
1491: end if;
1492: --
1493: -- --
1494: -- range

Line 1520: hr_utility.set_location(l_proc,15);

1516: end if;
1517: --
1518: if g_debug then
1519: --
1520: hr_utility.set_location(l_proc,15);
1521: hr_utility.trace('g_range_ass_hi_smr_tbl.count : '||to_char(g_range_ass_hi_smr_tbl.count));
1522: --
1523: if g_range_ass_hi_smr_tbl.count > 0 then
1524: --

Line 1521: hr_utility.trace('g_range_ass_hi_smr_tbl.count : '||to_char(g_range_ass_hi_smr_tbl.count));

1517: --
1518: if g_debug then
1519: --
1520: hr_utility.set_location(l_proc,15);
1521: hr_utility.trace('g_range_ass_hi_smr_tbl.count : '||to_char(g_range_ass_hi_smr_tbl.count));
1522: --
1523: if g_range_ass_hi_smr_tbl.count > 0 then
1524: --
1525: for i in 0..g_range_ass_hi_smr_tbl.count - 1 loop

Line 1529: hr_utility.trace(to_char(g_range_ass_hi_smr_tbl(i).bg_id)

1525: for i in 0..g_range_ass_hi_smr_tbl.count - 1 loop
1526: --
1527: if g_detail_debug then
1528: --
1529: hr_utility.trace(to_char(g_range_ass_hi_smr_tbl(i).bg_id)
1530: ||':'||g_range_ass_hi_smr_tbl(i).ass_num
1531: ||'('||to_char(g_range_ass_hi_smr_tbl(i).ass_id)
1532: ||').'||g_range_ass_hi_smr_tbl(i).del_done);
1533: --

Line 1543: hr_utility.set_location(l_proc,20);

1539: --
1540: end if;
1541: --
1542: if g_debug then
1543: hr_utility.set_location(l_proc,20);
1544: end if;
1545: --
1546: -- --
1547: -- qualify

Line 1552: hr_utility.trace('Business Group Name Assignment Number Message');

1548: -- --
1549: --
1550: if g_log = 'Y' then
1551: --
1552: hr_utility.trace('Business Group Name Assignment Number Message');
1553: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');
1554: --
1555: end if;
1556: --

Line 1553: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');

1549: --
1550: if g_log = 'Y' then
1551: --
1552: hr_utility.trace('Business Group Name Assignment Number Message');
1553: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');
1554: --
1555: end if;
1556: --
1557: if g_skip_qualify = 'N' then

Line 1618: hr_utility.trace(to_char(g_qualify_hi_smr_ass_tbl(l).bg_id)

1614: for l in 0..g_qualify_hi_smr_ass_tbl.count - 1 loop
1615: --
1616: if g_detail_debug then
1617: --
1618: hr_utility.trace(to_char(g_qualify_hi_smr_ass_tbl(l).bg_id)
1619: ||':'||g_qualify_hi_smr_ass_tbl(l).ass_num
1620: ||'('||to_char(g_qualify_hi_smr_ass_tbl(l).ass_id)
1621: ||').'||g_qualify_hi_smr_ass_tbl(l).del_done);
1622: --

Line 1634: hr_utility.set_location(l_proc,30);

1630: --
1631: end if;
1632: --
1633: if g_debug then
1634: hr_utility.set_location(l_proc,30);
1635: end if;
1636: --
1637: -- --
1638: -- upgrade

Line 1643: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');

1639: -- --
1640: --
1641: if g_log = 'Y' then
1642: --
1643: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1644: hr_utility.trace('Business Group Name Assignment Number E MR SMR Exp SMR');
1645: hr_utility.trace('------------------------------ ------------------------------ - ---------- ---------- ----------');
1646: --
1647: end if;

Line 1644: hr_utility.trace('Business Group Name Assignment Number E MR SMR Exp SMR');

1640: --
1641: if g_log = 'Y' then
1642: --
1643: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1644: hr_utility.trace('Business Group Name Assignment Number E MR SMR Exp SMR');
1645: hr_utility.trace('------------------------------ ------------------------------ - ---------- ---------- ----------');
1646: --
1647: end if;
1648: --

Line 1645: hr_utility.trace('------------------------------ ------------------------------ - ---------- ---------- ----------');

1641: if g_log = 'Y' then
1642: --
1643: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1644: hr_utility.trace('Business Group Name Assignment Number E MR SMR Exp SMR');
1645: hr_utility.trace('------------------------------ ------------------------------ - ---------- ---------- ----------');
1646: --
1647: end if;
1648: --
1649: if l_qualify_valid_update = 'Y' then

Line 1684: hr_utility.set_location(l_proc,40);

1680: --
1681: end if;
1682: --
1683: if g_debug then
1684: hr_utility.set_location(l_proc,40);
1685: end if;
1686: --
1687: -- --
1688: -- deinitialize

Line 1693: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');

1689: -- --
1690: --
1691: if g_log = 'Y' then
1692: --
1693: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1694: --
1695: end if;
1696: --
1697: delete_session;

Line 1706: hr_utility.set_location(l_proc,1000);

1702: --
1703: end if;
1704: --
1705: if g_debug then
1706: hr_utility.set_location(l_proc,1000);
1707: end if;
1708: --
1709: end run_mig_smr;
1710: --

Line 1724: hr_utility.set_location(l_proc,0);

1720: --
1721: begin
1722: --
1723: if g_debug then
1724: hr_utility.set_location(l_proc,0);
1725: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
1726: end if;
1727: --
1728: if g_qualify_ini_ass_id is null

Line 1725: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));

1721: begin
1722: --
1723: if g_debug then
1724: hr_utility.set_location(l_proc,0);
1725: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
1726: end if;
1727: --
1728: if g_qualify_ini_ass_id is null
1729: or g_qualify_ini_ass_id = p_assignment_id then

Line 1739: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));

1735: --
1736: end if;
1737: --
1738: if g_debug then
1739: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
1740: hr_utility.set_location(l_proc,1000);
1741: end if;
1742: --
1743: end qualify_dep_hd;

Line 1740: hr_utility.set_location(l_proc,1000);

1736: end if;
1737: --
1738: if g_debug then
1739: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
1740: hr_utility.set_location(l_proc,1000);
1741: end if;
1742: --
1743: end qualify_dep_hd;
1744: --

Line 1758: hr_utility.set_location(l_proc,0);

1754: --
1755: begin
1756: --
1757: if g_debug then
1758: hr_utility.set_location(l_proc,0);
1759: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
1760: end if;
1761: --
1762: if g_migrate_ini_ass_id is null

Line 1759: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));

1755: begin
1756: --
1757: if g_debug then
1758: hr_utility.set_location(l_proc,0);
1759: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
1760: end if;
1761: --
1762: if g_migrate_ini_ass_id is null
1763: or g_migrate_ini_ass_id = p_assignment_id then

Line 1773: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));

1769: --
1770: end if;
1771: --
1772: if g_debug then
1773: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
1774: hr_utility.set_location(l_proc,1000);
1775: end if;
1776: --
1777: end migrate_dep_hd;

Line 1774: hr_utility.set_location(l_proc,1000);

1770: end if;
1771: --
1772: if g_debug then
1773: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
1774: hr_utility.set_location(l_proc,1000);
1775: end if;
1776: --
1777: end migrate_dep_hd;
1778: --

Line 1791: hr_utility.set_location(l_proc,0);

1787: --
1788: begin
1789: --
1790: if g_debug then
1791: hr_utility.set_location(l_proc,0);
1792: hr_utility.trace('g_legislation_code : '||g_legislation_code);
1793: end if;
1794: --
1795: -- temporary solution because of no initialize.

Line 1792: hr_utility.trace('g_legislation_code : '||g_legislation_code);

1788: begin
1789: --
1790: if g_debug then
1791: hr_utility.set_location(l_proc,0);
1792: hr_utility.trace('g_legislation_code : '||g_legislation_code);
1793: end if;
1794: --
1795: -- temporary solution because of no initialize.
1796: -- run once for each thread.

Line 1812: hr_utility.trace('g_legislation_code : '||g_legislation_code);

1808: --
1809: end if;
1810: --
1811: if g_debug then
1812: hr_utility.trace('g_legislation_code : '||g_legislation_code);
1813: hr_utility.set_location(l_proc,1000);
1814: end if;
1815: --
1816: end init_def_dep_data;

Line 1813: hr_utility.set_location(l_proc,1000);

1809: end if;
1810: --
1811: if g_debug then
1812: hr_utility.trace('g_legislation_code : '||g_legislation_code);
1813: hr_utility.set_location(l_proc,1000);
1814: end if;
1815: --
1816: end init_def_dep_data;
1817: --

Line 2012: hr_utility.set_location(l_proc,0);

2008: --
2009: begin
2010: --
2011: if g_detail_debug then
2012: hr_utility.set_location(l_proc,0);
2013: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
2014: end if;
2015: --
2016: if p_valid_update = 'N' then

Line 2013: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');

2009: begin
2010: --
2011: if g_detail_debug then
2012: hr_utility.set_location(l_proc,0);
2013: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
2014: end if;
2015: --
2016: if p_valid_update = 'N' then
2017: --

Line 2034: hr_utility.set_location(l_proc,10);

2030: --
2031: end if;
2032: --
2033: if g_detail_debug then
2034: hr_utility.set_location(l_proc,10);
2035: hr_utility.trace('l_cei_target_id : '||to_char(l_cei_target_id));
2036: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);
2037: end if;
2038: --

Line 2035: hr_utility.trace('l_cei_target_id : '||to_char(l_cei_target_id));

2031: end if;
2032: --
2033: if g_detail_debug then
2034: hr_utility.set_location(l_proc,10);
2035: hr_utility.trace('l_cei_target_id : '||to_char(l_cei_target_id));
2036: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);
2037: end if;
2038: --
2039: -- target for cei oe update

Line 2036: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);

2032: --
2033: if g_detail_debug then
2034: hr_utility.set_location(l_proc,10);
2035: hr_utility.trace('l_cei_target_id : '||to_char(l_cei_target_id));
2036: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);
2037: end if;
2038: --
2039: -- target for cei oe update
2040: --

Line 2055: hr_utility.set_location(l_proc,20);

2051: --
2052: end if;
2053: --
2054: if g_detail_debug then
2055: hr_utility.set_location(l_proc,20);
2056: hr_utility.trace('l_cei_oe_target_id : '||to_char(l_cei_oe_target_id));
2057: end if;
2058: --
2059: end if;

Line 2056: hr_utility.trace('l_cei_oe_target_id : '||to_char(l_cei_oe_target_id));

2052: end if;
2053: --
2054: if g_detail_debug then
2055: hr_utility.set_location(l_proc,20);
2056: hr_utility.trace('l_cei_oe_target_id : '||to_char(l_cei_oe_target_id));
2057: end if;
2058: --
2059: end if;
2060: --

Line 2075: hr_utility.set_location(l_proc,30);

2071: --
2072: end if;
2073: --
2074: if g_detail_debug then
2075: hr_utility.set_location(l_proc,30);
2076: hr_utility.trace('l_ee_target_id : '||to_char(l_ee_target_id));
2077: end if;
2078: --
2079: -- validation for each target, if there is one no valid_update, the target will be skipped.

Line 2076: hr_utility.trace('l_ee_target_id : '||to_char(l_ee_target_id));

2072: end if;
2073: --
2074: if g_detail_debug then
2075: hr_utility.set_location(l_proc,30);
2076: hr_utility.trace('l_ee_target_id : '||to_char(l_ee_target_id));
2077: end if;
2078: --
2079: -- validation for each target, if there is one no valid_update, the target will be skipped.
2080: --

Line 2099: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_exist_mesg);

2095: if g_sql_run = 'Y' then
2096: --
2097: if g_log = 'Y' then
2098: --
2099: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_exist_mesg);
2100: --
2101: end if;
2102: --
2103: else

Line 2114: hr_utility.set_location(l_proc,40);

2110: --
2111: end if;
2112: --
2113: if g_detail_debug then
2114: hr_utility.set_location(l_proc,40);
2115: hr_utility.trace('skip future cei : l_valid_update : '||l_valid_update);
2116: end if;
2117: --
2118: end if;

Line 2115: hr_utility.trace('skip future cei : l_valid_update : '||l_valid_update);

2111: end if;
2112: --
2113: if g_detail_debug then
2114: hr_utility.set_location(l_proc,40);
2115: hr_utility.trace('skip future cei : l_valid_update : '||l_valid_update);
2116: end if;
2117: --
2118: end if;
2119: --

Line 2138: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_oe_exist_mesg);

2134: if g_sql_run = 'Y' then
2135: --
2136: if g_log = 'Y' then
2137: --
2138: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_oe_exist_mesg);
2139: --
2140: end if;
2141: --
2142: else

Line 2153: hr_utility.set_location(l_proc,50);

2149: --
2150: end if;
2151: --
2152: if g_detail_debug then
2153: hr_utility.set_location(l_proc,50);
2154: hr_utility.trace('skip future cei : l_valid_update : '||l_valid_update);
2155: end if;
2156: --
2157: end if;

Line 2154: hr_utility.trace('skip future cei : l_valid_update : '||l_valid_update);

2150: end if;
2151: --
2152: if g_detail_debug then
2153: hr_utility.set_location(l_proc,50);
2154: hr_utility.trace('skip future cei : l_valid_update : '||l_valid_update);
2155: end if;
2156: --
2157: end if;
2158: --

Line 2182: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_already_ee_upd_mesg);

2178: if g_sql_run = 'Y' then
2179: --
2180: if g_log = 'Y' then
2181: --
2182: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_already_ee_upd_mesg);
2183: --
2184: end if;
2185: --
2186: else

Line 2199: hr_utility.set_location(l_proc,60);

2195: --
2196: end if;
2197: --
2198: if g_detail_debug then
2199: hr_utility.set_location(l_proc,60);
2200: hr_utility.trace('skip manual upd entry : l_valid_update : '||l_valid_update);
2201: end if;
2202: --
2203: -- skip future entry exists (ee validation)

Line 2200: hr_utility.trace('skip manual upd entry : l_valid_update : '||l_valid_update);

2196: end if;
2197: --
2198: if g_detail_debug then
2199: hr_utility.set_location(l_proc,60);
2200: hr_utility.trace('skip manual upd entry : l_valid_update : '||l_valid_update);
2201: end if;
2202: --
2203: -- skip future entry exists (ee validation)
2204: --

Line 2219: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_ee_exist_mesg);

2215: if g_sql_run = 'Y' then
2216: --
2217: if g_log = 'Y' then
2218: --
2219: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_ee_exist_mesg);
2220: --
2221: end if;
2222: --
2223: else

Line 2234: hr_utility.set_location(l_proc,70);

2230: --
2231: end if;
2232: --
2233: if g_detail_debug then
2234: hr_utility.set_location(l_proc,70);
2235: hr_utility.trace('skip future entry : l_valid_update : '||l_valid_update);
2236: end if;
2237: --
2238: end if;

Line 2235: hr_utility.trace('skip future entry : l_valid_update : '||l_valid_update);

2231: end if;
2232: --
2233: if g_detail_debug then
2234: hr_utility.set_location(l_proc,70);
2235: hr_utility.trace('skip future entry : l_valid_update : '||l_valid_update);
2236: end if;
2237: --
2238: end if;
2239: --

Line 2249: hr_utility.set_location(l_proc,1000);

2245: --
2246: end if;
2247: --
2248: if g_detail_debug then
2249: hr_utility.set_location(l_proc,1000);
2250: end if;
2251: --
2252: exception
2253: when others then

Line 2256: hr_utility.set_location(l_proc,-1000);

2252: exception
2253: when others then
2254: --
2255: if g_debug then
2256: hr_utility.set_location(l_proc,-1000);
2257: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
2258: end if;
2259: --
2260: end val_mig_dep_assact;

Line 2257: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);

2253: when others then
2254: --
2255: if g_debug then
2256: hr_utility.set_location(l_proc,-1000);
2257: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
2258: end if;
2259: --
2260: end val_mig_dep_assact;
2261: --

Line 2424: hr_utility.set_location(l_proc,0);

2420: --
2421: begin
2422: --
2423: if g_detail_debug then
2424: hr_utility.set_location(l_proc,0);
2425: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);
2426: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
2427: end if;
2428: -- ---------------------------

Line 2425: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);

2421: begin
2422: --
2423: if g_detail_debug then
2424: hr_utility.set_location(l_proc,0);
2425: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);
2426: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
2427: end if;
2428: -- ---------------------------
2429: -- upgrade cei

Line 2426: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');

2422: --
2423: if g_detail_debug then
2424: hr_utility.set_location(l_proc,0);
2425: hr_utility.trace('g_expire_cei_dep_oe : '||g_expire_cei_dep_oe);
2426: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
2427: end if;
2428: -- ---------------------------
2429: -- upgrade cei
2430: -- ---------------------------

Line 2459: hr_utility.set_location(l_proc,10);

2455: p_effective_start_date => l_esd,
2456: p_effective_end_date => l_eed);
2457: --
2458: if g_detail_debug then
2459: hr_utility.set_location(l_proc,10);
2460: end if;
2461: --
2462: if g_sql_run = 'Y' then
2463: --

Line 2466: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));

2462: if g_sql_run = 'Y' then
2463: --
2464: if g_log = 'Y' then
2465: --
2466: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));
2467: --
2468: end if;
2469: --
2470: else

Line 2482: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));

2478: if g_sql_run = 'Y' then
2479: --
2480: if g_log = 'Y' then
2481: --
2482: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));
2483: --
2484: end if;
2485: --
2486: else

Line 2498: hr_utility.set_location(l_proc,20);

2494: end loop;
2495: close csr_cei;
2496: --
2497: if g_detail_debug then
2498: hr_utility.set_location(l_proc,20);
2499: end if;
2500: --
2501: -- ---------------------------
2502: -- upgrade cei oe

Line 2526: hr_utility.set_location(l_proc,30);

2522: p_effective_start_date => l_esd,
2523: p_effective_end_date => l_eed);
2524: --
2525: if g_detail_debug then
2526: hr_utility.set_location(l_proc,30);
2527: end if;
2528: --
2529: if g_sql_run = 'Y' then
2530: --

Line 2533: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));

2529: if g_sql_run = 'Y' then
2530: --
2531: if g_log = 'Y' then
2532: --
2533: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));
2534: --
2535: end if;
2536: --
2537: else

Line 2549: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));

2545: if g_sql_run = 'Y' then
2546: --
2547: if g_log = 'Y' then
2548: --
2549: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));
2550: --
2551: end if;
2552: --
2553: else

Line 2567: hr_utility.set_location(l_proc,40);

2563: --
2564: end if;
2565: --
2566: if g_detail_debug then
2567: hr_utility.set_location(l_proc,40);
2568: end if;
2569: --
2570: -- ---------------------------
2571: -- upgrade ee

Line 2578: hr_utility.set_location(l_proc,50);

2574: fetch csr_ee into l_ee_id;
2575: close csr_ee;
2576: --
2577: if g_detail_debug then
2578: hr_utility.set_location(l_proc,50);
2579: hr_utility.trace('l_ee_id : '||to_char(l_ee_id));
2580: end if;
2581: --
2582: if l_ee_id is not null then

Line 2579: hr_utility.trace('l_ee_id : '||to_char(l_ee_id));

2575: close csr_ee;
2576: --
2577: if g_detail_debug then
2578: hr_utility.set_location(l_proc,50);
2579: hr_utility.trace('l_ee_id : '||to_char(l_ee_id));
2580: end if;
2581: --
2582: if l_ee_id is not null then
2583: --

Line 2589: hr_utility.set_location(l_proc,60);

2585: fetch csr_entry into l_csr_entry;
2586: close csr_entry;
2587: --
2588: if g_detail_debug then
2589: hr_utility.set_location(l_proc,60);
2590: hr_utility.trace('sec_sal : '||l_csr_entry.sec_sal);
2591: end if;
2592: --
2593: --if l_csr_entry.element_entry_id is not null then

Line 2590: hr_utility.trace('sec_sal : '||l_csr_entry.sec_sal);

2586: close csr_entry;
2587: --
2588: if g_detail_debug then
2589: hr_utility.set_location(l_proc,60);
2590: hr_utility.trace('sec_sal : '||l_csr_entry.sec_sal);
2591: end if;
2592: --
2593: --if l_csr_entry.element_entry_id is not null then
2594: ----

Line 2613: -- hr_utility.set_location(l_proc,70);

2609: -- p_effective_end_date => l_eed,
2610: -- p_update_warning => l_warning);
2611: -- --
2612: -- if g_detail_debug then
2613: -- hr_utility.set_location(l_proc,70);
2614: -- end if;
2615: -- --
2616: -- if g_sql_run = 'Y' then
2617: -- --

Line 2620: -- hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2616: -- if g_sql_run = 'Y' then
2617: -- --
2618: -- if g_log = 'Y' then
2619: -- --
2620: -- hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2621: -- --
2622: -- end if;
2623: -- --
2624: -- else

Line 2636: -- hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2632: -- if g_sql_run = 'Y' then
2633: -- --
2634: -- if g_log = 'Y' then
2635: -- --
2636: -- hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2637: -- --
2638: -- end if;
2639: -- --
2640: -- else

Line 2674: hr_utility.set_location(l_proc,80);

2670: p_effective_end_date => l_eed,
2671: p_create_warning => l_warning);
2672: --
2673: if g_detail_debug then
2674: hr_utility.set_location(l_proc,80);
2675: end if;
2676: --
2677: if g_sql_run = 'Y' then
2678: --

Line 2681: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2677: if g_sql_run = 'Y' then
2678: --
2679: if g_log = 'Y' then
2680: --
2681: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2682: --
2683: end if;
2684: --
2685: else

Line 2697: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2693: if g_sql_run = 'Y' then
2694: --
2695: if g_log = 'Y' then
2696: --
2697: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2698: --
2699: end if;
2700: --
2701: else

Line 2714: hr_utility.set_location(l_proc,1000);

2710: --
2711: end if;
2712: --
2713: if g_detail_debug then
2714: hr_utility.set_location(l_proc,1000);
2715: end if;
2716: --
2717: exception
2718: when hr_api.object_locked then

Line 2721: hr_utility.set_location(l_proc,-1000);

2717: exception
2718: when hr_api.object_locked then
2719: --
2720: if g_debug then
2721: hr_utility.set_location(l_proc,-1000);
2722: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
2723: end if;
2724: --
2725: if g_sql_run = 'Y' then

Line 2722: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));

2718: when hr_api.object_locked then
2719: --
2720: if g_debug then
2721: hr_utility.set_location(l_proc,-1000);
2722: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
2723: end if;
2724: --
2725: if g_sql_run = 'Y' then
2726: --

Line 2729: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));

2725: if g_sql_run = 'Y' then
2726: --
2727: if g_log = 'Y' then
2728: --
2729: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
2730: --
2731: end if;
2732: --
2733: else

Line 2742: hr_utility.set_location(l_proc,-1000);

2738: --
2739: when others then
2740: --
2741: if g_debug then
2742: hr_utility.set_location(l_proc,-1000);
2743: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
2744: end if;
2745: --
2746: if g_sql_run = 'Y' then

Line 2743: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);

2739: when others then
2740: --
2741: if g_debug then
2742: hr_utility.set_location(l_proc,-1000);
2743: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
2744: end if;
2745: --
2746: if g_sql_run = 'Y' then
2747: --

Line 2750: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);

2746: if g_sql_run = 'Y' then
2747: --
2748: if g_log = 'Y' then
2749: --
2750: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);
2751: --
2752: end if;
2753: --
2754: else

Line 2812: hr_utility.set_location(l_proc,0);

2808: g_debug := false;
2809: end if;
2810: --
2811: if g_debug then
2812: hr_utility.set_location(l_proc,0);
2813: end if;
2814: --
2815: if g_skip_qualify is null then
2816: g_skip_qualify := 'N';

Line 2844: hr_utility.set_location(l_proc,10);

2840: -- for api use
2841: insert_session(g_mig_date);
2842: --
2843: if g_debug then
2844: hr_utility.set_location(l_proc,10);
2845: end if;
2846: --
2847: -- --
2848: -- range

Line 2874: hr_utility.set_location(l_proc,15);

2870: end if;
2871: --
2872: if g_debug then
2873: --
2874: hr_utility.set_location(l_proc,15);
2875: hr_utility.trace('g_range_ass_dep_tbl.count : '||to_char(g_range_ass_dep_tbl.count));
2876: --
2877: if g_range_ass_dep_tbl.count > 0 then
2878: --

Line 2875: hr_utility.trace('g_range_ass_dep_tbl.count : '||to_char(g_range_ass_dep_tbl.count));

2871: --
2872: if g_debug then
2873: --
2874: hr_utility.set_location(l_proc,15);
2875: hr_utility.trace('g_range_ass_dep_tbl.count : '||to_char(g_range_ass_dep_tbl.count));
2876: --
2877: if g_range_ass_dep_tbl.count > 0 then
2878: --
2879: for i in 0..g_range_ass_dep_tbl.count - 1 loop

Line 2883: hr_utility.trace(to_char(g_range_ass_dep_tbl(i).bg_id)

2879: for i in 0..g_range_ass_dep_tbl.count - 1 loop
2880: --
2881: if g_detail_debug then
2882: --
2883: hr_utility.trace(to_char(g_range_ass_dep_tbl(i).bg_id)
2884: ||':'||g_range_ass_dep_tbl(i).ass_num
2885: ||'('||to_char(g_range_ass_dep_tbl(i).ass_id)
2886: ||').'||g_range_ass_dep_tbl(i).upd_done);
2887: --

Line 2897: hr_utility.set_location(l_proc,20);

2893: --
2894: end if;
2895: --
2896: if g_debug then
2897: hr_utility.set_location(l_proc,20);
2898: end if;
2899: --
2900: -- --
2901: -- qualify

Line 2906: hr_utility.trace('Business Group Name Assignment Number Message');

2902: -- --
2903: --
2904: if g_log = 'Y' then
2905: --
2906: hr_utility.trace('Business Group Name Assignment Number Message');
2907: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');
2908: --
2909: end if;
2910: --

Line 2907: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');

2903: --
2904: if g_log = 'Y' then
2905: --
2906: hr_utility.trace('Business Group Name Assignment Number Message');
2907: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');
2908: --
2909: end if;
2910: --
2911: if g_skip_qualify = 'N' then

Line 2971: hr_utility.trace(to_char(g_qualify_dep_ass_tbl(l).bg_id)

2967: for l in 0..g_qualify_dep_ass_tbl.count - 1 loop
2968: --
2969: if g_detail_debug then
2970: --
2971: hr_utility.trace(to_char(g_qualify_dep_ass_tbl(l).bg_id)
2972: ||':'||g_qualify_dep_ass_tbl(l).ass_num
2973: ||'('||to_char(g_qualify_dep_ass_tbl(l).ass_id)
2974: ||').'||g_qualify_dep_ass_tbl(l).upd_done);
2975: --

Line 2987: hr_utility.set_location(l_proc,30);

2983: --
2984: end if;
2985: --
2986: if g_debug then
2987: hr_utility.set_location(l_proc,30);
2988: end if;
2989: --
2990: -- --
2991: -- upgrade

Line 2996: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');

2992: -- --
2993: --
2994: if g_log = 'Y' then
2995: --
2996: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
2997: hr_utility.trace('Business Group Name Assignment Number Age Type Contact');
2998: hr_utility.trace('------------------------------ ------------------------- ---- ------ ------------------------------------------------------------');
2999: --
3000: end if;

Line 2997: hr_utility.trace('Business Group Name Assignment Number Age Type Contact');

2993: --
2994: if g_log = 'Y' then
2995: --
2996: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
2997: hr_utility.trace('Business Group Name Assignment Number Age Type Contact');
2998: hr_utility.trace('------------------------------ ------------------------- ---- ------ ------------------------------------------------------------');
2999: --
3000: end if;
3001: --

Line 2998: hr_utility.trace('------------------------------ ------------------------- ---- ------ ------------------------------------------------------------');

2994: if g_log = 'Y' then
2995: --
2996: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
2997: hr_utility.trace('Business Group Name Assignment Number Age Type Contact');
2998: hr_utility.trace('------------------------------ ------------------------- ---- ------ ------------------------------------------------------------');
2999: --
3000: end if;
3001: --
3002: if l_qualify_valid_update = 'Y' then

Line 3036: hr_utility.set_location(l_proc,40);

3032: --
3033: end if;
3034: --
3035: if g_debug then
3036: hr_utility.set_location(l_proc,40);
3037: end if;
3038: --
3039: -- --
3040: -- deinitialize

Line 3045: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');

3041: -- --
3042: --
3043: if g_log = 'Y' then
3044: --
3045: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
3046: --
3047: end if;
3048: --
3049: delete_session;

Line 3058: hr_utility.set_location(l_proc,1000);

3054: --
3055: end if;
3056: --
3057: if g_debug then
3058: hr_utility.set_location(l_proc,1000);
3059: end if;
3060: --
3061: end run_mig_dep;
3062: --