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 79: hr_utility.set_location('Start ' || p_mode || p_parameter_name, 5);

75:
76: --
77: BEGIN
78:
79: hr_utility.set_location('Start ' || p_mode || p_parameter_name, 5);
80: if p_mode = 'ELE_RR_COPY_TO' then
81: -- find ELE_RR_COPY_FROM element_type_id
82: l_element_type_id_to := p_parameter_value;
83: --

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

110: from pay_run_results prr_to
111: where prr_to.assignment_action_id = prr_from.assignment_action_id
112: and prr_to.element_type_id = l_element_type_id_to);
113:
114: hr_utility.trace('Successefully created run_result');
115:
116: -- get related input values
117: for rec_related_iv in csr_related_iv
118: loop

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

162: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
163:
164: end if;
165: end loop;
166: hr_utility.trace('Successefully created run_result_value');
167: end if;
168: end if;
169: END;
170:

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

247:
248: --
249: BEGIN
250:
251: hr_utility.set_location('Start procedure in the hr_jp_data_migration_pkg' || p_mode || p_parameter_name, 5);
252: if p_mode = 'ADD_NEW_IV' then
253: l_input_value_id_to := p_parameter_value;
254:
255: -- find element_link_id of parent element

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

298: select null
299: from pay_link_input_values_f
300: where element_link_id = rec_element_link.element_link_id
301: and input_value_id = l_input_value_id_to);
302: hr_utility.trace('Successefully created link_input_value '|| to_char(rec_element_link.element_link_id));
303:
304: for rec_element_entry in csr_element_entry_id(rec_element_link.element_link_id,l_input_value_id_to) loop
305: insert into pay_element_entry_values_f(
306: ELEMENT_ENTRY_VALUE_ID,

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

323: commit;
324: l_total_upd_actions := 0;
325: end if;
326: end loop;
327: hr_utility.trace('Successefully created element_entry_value');
328: if l_total_upd_actions > 0 then
329: l_total_upd_actions := 0;
330: commit;
331: end if;

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

347: commit;
348: l_total_upd_actions := 0;
349: end if;
350: end loop;
351: hr_utility.trace('Successefully created run_result_value '|| to_char(l_input_value_id_to));
352:
353: if l_total_upd_actions > 0 then
354: commit;
355: end if;

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

399: and p_session_date
400: between pee.effective_start_date and pee.effective_end_date;
401:
402: BEGIN
403: hr_utility.set_location('Start procedure in the hr_jp_data_migration_pkg' || p_mode || p_parameter_name, 5);
404: if p_mode = 'ELE_END_ENTRY' then
405: l_element_type_id := p_parameter_value;
406: for rec_element_link in csr_element_link_id
407: loop

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

464: --
465: begin
466: --
467: if g_debug then
468: hr_utility.set_location(l_proc,0);
469: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
470: end if;
471: --
472: if g_ass_info.ass_id <> p_assignment_id

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

465: begin
466: --
467: if g_debug then
468: hr_utility.set_location(l_proc,0);
469: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
470: end if;
471: --
472: if g_ass_info.ass_id <> p_assignment_id
473: or g_ass_info.ass_id is null then

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

483: --
484: end if;
485: --
486: if g_debug then
487: hr_utility.set_location(l_proc,1000);
488: end if;
489: --
490: return g_ass_info;
491: --

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

501: --
502: begin
503: --
504: if g_debug then
505: hr_utility.set_location(l_proc,0);
506: end if;
507: --
508: 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);
509: c_am_iv_id := hr_jp_id_pkg.input_value_id(c_com_hi_smr_elm_id,c_am_iv,c_skip_warning);

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

513: 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);
514: c_at_iv_id := hr_jp_id_pkg.input_value_id(c_com_hi_smr_elm_id,c_at_iv,c_skip_warning);
515: --
516: if g_debug then
517: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
518: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
519: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));

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

514: c_at_iv_id := hr_jp_id_pkg.input_value_id(c_com_hi_smr_elm_id,c_at_iv,c_skip_warning);
515: --
516: if g_debug then
517: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
518: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
519: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
522: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));

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

515: --
516: if g_debug then
517: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
518: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
519: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
522: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
523: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));

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

516: if g_debug then
517: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
518: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
519: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
522: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
523: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
524: hr_utility.set_location(l_proc,1000);

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

517: hr_utility.trace('c_com_hi_smr_elm_id : '||to_char(c_com_hi_smr_elm_id));
518: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
519: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
522: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
523: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
524: hr_utility.set_location(l_proc,1000);
525: end if;

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

518: hr_utility.trace('c_am_iv_id : '||to_char(c_am_iv_id));
519: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
522: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
523: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
524: hr_utility.set_location(l_proc,1000);
525: end if;
526: --

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

519: hr_utility.trace('c_mr_iv_id : '||to_char(c_mr_iv_id));
520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
522: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
523: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
524: hr_utility.set_location(l_proc,1000);
525: end if;
526: --
527: end set_hi_smr_id;

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

520: hr_utility.trace('c_mr_o_iv_id : '||to_char(c_mr_o_iv_id));
521: hr_utility.trace('c_smr_iv_id : '||to_char(c_smr_iv_id));
522: hr_utility.trace('c_smr_o_iv_id : '||to_char(c_smr_o_iv_id));
523: hr_utility.trace('c_at_iv_id : '||to_char(c_at_iv_id));
524: hr_utility.set_location(l_proc,1000);
525: end if;
526: --
527: end set_hi_smr_id;
528: --

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

536: --
537: begin
538: --
539: if g_debug then
540: hr_utility.set_location(l_proc,0);
541: end if;
542: --
543: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
544: c_fut_exist_mesg := fnd_message.get;

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

555: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_MR_NULL');
556: c_mr_null_mesg := fnd_message.get;
557: --
558: if g_debug then
559: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
560: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
561: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
562: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
563: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);

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

556: c_mr_null_mesg := fnd_message.get;
557: --
558: if g_debug then
559: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
560: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
561: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
562: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
563: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
564: hr_utility.set_location(l_proc,1000);

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

557: --
558: if g_debug then
559: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
560: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
561: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
562: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
563: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
564: hr_utility.set_location(l_proc,1000);
565: end if;

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

558: if g_debug then
559: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
560: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
561: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
562: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
563: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
564: hr_utility.set_location(l_proc,1000);
565: end if;
566: --

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

559: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
560: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
561: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
562: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
563: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
564: hr_utility.set_location(l_proc,1000);
565: end if;
566: --
567: end set_hi_smr_mesg;

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

560: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
561: hr_utility.trace('c_fut_am_mesg : '||c_fut_am_mesg);
562: hr_utility.trace('c_am_null_mesg : '||c_am_null_mesg);
563: hr_utility.trace('c_mr_null_mesg : '||c_mr_null_mesg);
564: hr_utility.set_location(l_proc,1000);
565: end if;
566: --
567: end set_hi_smr_mesg;
568: --

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

603: --
604: begin
605: --
606: if g_debug then
607: hr_utility.set_location(l_proc,0);
608: hr_utility.trace('g_mig_date : '||to_char(g_mig_date,'YYYY/MM/DD'));
609: end if;
610: --
611: if g_debug then

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

604: begin
605: --
606: if g_debug then
607: hr_utility.set_location(l_proc,0);
608: hr_utility.trace('g_mig_date : '||to_char(g_mig_date,'YYYY/MM/DD'));
609: end if;
610: --
611: if g_debug then
612: hr_utility.set_location(l_proc,1000);

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

608: hr_utility.trace('g_mig_date : '||to_char(g_mig_date,'YYYY/MM/DD'));
609: end if;
610: --
611: if g_debug then
612: hr_utility.set_location(l_proc,1000);
613: end if;
614: --
615: return g_mig_date;
616: --

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

683: --
684: begin
685: --
686: if g_debug then
687: hr_utility.set_location(l_proc,0);
688: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
689: end if;
690: --
691: if g_qualify_ini_ass_id is null

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

684: begin
685: --
686: if g_debug then
687: hr_utility.set_location(l_proc,0);
688: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
689: end if;
690: --
691: if g_qualify_ini_ass_id is null
692: or g_qualify_ini_ass_id = p_assignment_id then

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

698: --
699: end if;
700: --
701: if g_debug then
702: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
703: hr_utility.set_location(l_proc,1000);
704: end if;
705: --
706: end qualify_hi_smr_hd;

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

699: end if;
700: --
701: if g_debug then
702: hr_utility.trace('g_qualify_ini_ass_id : '||to_char(g_qualify_ini_ass_id));
703: hr_utility.set_location(l_proc,1000);
704: end if;
705: --
706: end qualify_hi_smr_hd;
707: --

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

717: --
718: begin
719: --
720: if g_debug then
721: hr_utility.set_location(l_proc,0);
722: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
723: end if;
724: --
725: if g_migrate_ini_ass_id is null

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

718: begin
719: --
720: if g_debug then
721: hr_utility.set_location(l_proc,0);
722: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
723: end if;
724: --
725: if g_migrate_ini_ass_id is null
726: or g_migrate_ini_ass_id = p_assignment_id then

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

732: --
733: end if;
734: --
735: if g_debug then
736: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
737: hr_utility.set_location(l_proc,1000);
738: end if;
739: --
740: end migrate_hi_smr_hd;

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

733: end if;
734: --
735: if g_debug then
736: hr_utility.trace('g_migrate_ini_ass_id : '||to_char(g_migrate_ini_ass_id));
737: hr_utility.set_location(l_proc,1000);
738: end if;
739: --
740: end migrate_hi_smr_hd;
741: --

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

750: --
751: begin
752: --
753: if g_debug then
754: hr_utility.set_location(l_proc,0);
755: hr_utility.trace('g_legislation_code : '||g_legislation_code);
756: end if;
757: --
758: -- temporary solution because of no initialize.

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

751: begin
752: --
753: if g_debug then
754: hr_utility.set_location(l_proc,0);
755: hr_utility.trace('g_legislation_code : '||g_legislation_code);
756: end if;
757: --
758: -- temporary solution because of no initialize.
759: -- run once for each thread.

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

772: --
773: end if;
774: --
775: if g_debug then
776: hr_utility.trace('g_legislation_code : '||g_legislation_code);
777: hr_utility.set_location(l_proc,1000);
778: end if;
779: --
780: end init_def_hi_smr_data;

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

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

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

838: --
839: begin
840: --
841: if g_detail_debug then
842: hr_utility.set_location(l_proc,0);
843: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
844: end if;
845: --
846: if p_valid_delete = 'N' then

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

839: begin
840: --
841: if g_detail_debug then
842: hr_utility.set_location(l_proc,0);
843: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
844: end if;
845: --
846: if p_valid_delete = 'N' then
847: --

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

869: if g_sql_run = 'Y' then
870: --
871: if g_log = 'Y' then
872: --
873: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_already_upd_mesg);
874: --
875: end if;
876: --
877: else

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

884: --
885: end if;
886: --
887: if g_detail_debug then
888: hr_utility.set_location(l_proc,10);
889: hr_utility.trace('skip manual upd : l_valid_delete : '||l_valid_delete);
890: end if;
891: --
892: -- skip future entry exists

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

885: end if;
886: --
887: if g_detail_debug then
888: hr_utility.set_location(l_proc,10);
889: hr_utility.trace('skip manual upd : l_valid_delete : '||l_valid_delete);
890: end if;
891: --
892: -- skip future entry exists
893: --

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

904: if g_sql_run = 'Y' then
905: --
906: if g_log = 'Y' then
907: --
908: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_exist_mesg);
909: --
910: end if;
911: --
912: else

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

919: --
920: end if;
921: --
922: if g_detail_debug then
923: hr_utility.set_location(l_proc,20);
924: hr_utility.trace('skip future entry : l_valid_delete : '||l_valid_delete);
925: end if;
926: --
927: -- skip in update mode applied month is future (>= p_session_date)

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

920: end if;
921: --
922: if g_detail_debug then
923: hr_utility.set_location(l_proc,20);
924: hr_utility.trace('skip future entry : l_valid_delete : '||l_valid_delete);
925: end if;
926: --
927: -- skip in update mode applied month is future (>= p_session_date)
928: --

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

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

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

965: if g_sql_run = 'Y' then
966: --
967: if g_log = 'Y' then
968: --
969: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_am_null_mesg);
970: --
971: end if;
972: --
973: else

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

980: --
981: end if;
982: --
983: if g_detail_debug then
984: hr_utility.set_location(l_proc,30);
985: hr_utility.trace('skip applied month in future : l_valid_delete : '||l_valid_delete);
986: end if;
987: --
988: -- skip mr is null.

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

981: end if;
982: --
983: if g_detail_debug then
984: hr_utility.set_location(l_proc,30);
985: hr_utility.trace('skip applied month in future : l_valid_delete : '||l_valid_delete);
986: end if;
987: --
988: -- skip mr is null.
989: -- target only assignment, who belongs to new mr range.

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

1002: if g_sql_run = 'Y' then
1003: --
1004: if g_log = 'Y' then
1005: --
1006: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_mr_null_mesg);
1007: --
1008: end if;
1009: --
1010: else

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

1030: --
1031: end if;
1032: --
1033: if g_detail_debug then
1034: hr_utility.set_location(l_proc,40);
1035: hr_utility.trace('skip mr is null or out range : l_valid_delete : '||l_valid_delete);
1036: end if;
1037: --
1038: if l_valid_delete = 'Y' then

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

1031: end if;
1032: --
1033: if g_detail_debug then
1034: hr_utility.set_location(l_proc,40);
1035: hr_utility.trace('skip mr is null or out range : l_valid_delete : '||l_valid_delete);
1036: end if;
1037: --
1038: if l_valid_delete = 'Y' then
1039: --

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

1043: --
1044: end if;
1045: --
1046: if g_detail_debug then
1047: hr_utility.set_location(l_proc,1000);
1048: end if;
1049: --
1050: exception
1051: when others then

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

1050: exception
1051: when others then
1052: --
1053: if g_debug then
1054: hr_utility.set_location(l_proc,-1000);
1055: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1056: end if;
1057: --
1058: end val_mig_smr_assact;

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

1051: when others then
1052: --
1053: if g_debug then
1054: hr_utility.set_location(l_proc,-1000);
1055: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1056: end if;
1057: --
1058: end val_mig_smr_assact;
1059: --

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

1120: --
1121: begin
1122: --
1123: if g_detail_debug then
1124: hr_utility.set_location(l_proc,0);
1125: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
1126: end if;
1127: --
1128: open csr_entry;

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

1121: begin
1122: --
1123: if g_detail_debug then
1124: hr_utility.set_location(l_proc,0);
1125: hr_utility.trace(p_business_group_id ||' : '||p_assignment_id||'('||p_assignment_number||')');
1126: end if;
1127: --
1128: open csr_entry;
1129: loop

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

1152: end loop;
1153: close csr_entry;
1154: --
1155: if g_detail_debug then
1156: hr_utility.set_location(l_proc,10);
1157: 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);
1158: end if;
1159: --
1160: if p_hi_mr is not null then

Line 1157: 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);

1153: close csr_entry;
1154: --
1155: if g_detail_debug then
1156: hr_utility.set_location(l_proc,10);
1157: 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);
1158: end if;
1159: --
1160: if p_hi_mr is not null then
1161: --

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

1174: p_row_value => l_exp_mr_eev,
1175: p_effective_date => p_session_date))),0,60);
1176: --
1177: if g_detail_debug then
1178: hr_utility.set_location(l_proc,20);
1179: hr_utility.trace('l_exp_mr_eev : '||l_exp_mr_eev||', l_exp_smr_eev : '||l_exp_smr_eev);
1180: end if;
1181: --
1182: if g_exc_match_exp_smr = 'Y' then

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

1175: p_effective_date => p_session_date))),0,60);
1176: --
1177: if g_detail_debug then
1178: hr_utility.set_location(l_proc,20);
1179: hr_utility.trace('l_exp_mr_eev : '||l_exp_mr_eev||', l_exp_smr_eev : '||l_exp_smr_eev);
1180: end if;
1181: --
1182: if g_exc_match_exp_smr = 'Y' then
1183: --

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

1201: --
1202: end if;
1203: --
1204: if g_detail_debug then
1205: hr_utility.set_location(l_proc,30);
1206: hr_utility.trace('l_exp_smr_o_eev : '||l_exp_smr_o_eev||', l_exp_mr_o_eev : '||l_exp_mr_o_eev);
1207: end if;
1208: --
1209: l_ovn := l_csr_entry.object_version_number;

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

1202: end if;
1203: --
1204: if g_detail_debug then
1205: hr_utility.set_location(l_proc,30);
1206: hr_utility.trace('l_exp_smr_o_eev : '||l_exp_smr_o_eev||', l_exp_mr_o_eev : '||l_exp_mr_o_eev);
1207: end if;
1208: --
1209: l_ovn := l_csr_entry.object_version_number;
1210: --

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

1235: p_effective_end_date => l_eed,
1236: p_update_warning => l_warning);
1237: --
1238: if g_detail_debug then
1239: hr_utility.set_location(l_proc,40);
1240: end if;
1241: --
1242: end if;
1243: --

Line 1248: 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));

1244: if g_sql_run = 'Y' then
1245: --
1246: if g_log = 'Y' then
1247: --
1248: 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));
1249: --
1250: end if;
1251: --
1252: else

Line 1264: 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));

1260: if g_sql_run = 'Y' then
1261: --
1262: if g_log = 'Y' then
1263: --
1264: 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));
1265: --
1266: end if;
1267: --
1268: else

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

1271: --
1272: end if;
1273: --
1274: if g_detail_debug then
1275: hr_utility.set_location(l_proc,45);
1276: end if;
1277: --
1278: end if;
1279: --

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

1277: --
1278: end if;
1279: --
1280: if g_detail_debug then
1281: hr_utility.set_location(l_proc,1000);
1282: end if;
1283: --
1284: exception
1285: when hr_api.object_locked then

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

1284: exception
1285: when hr_api.object_locked then
1286: --
1287: if g_debug then
1288: hr_utility.set_location(l_proc,-1000);
1289: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1290: end if;
1291: --
1292: if g_sql_run = 'Y' then

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

1285: when hr_api.object_locked then
1286: --
1287: if g_debug then
1288: hr_utility.set_location(l_proc,-1000);
1289: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1290: end if;
1291: --
1292: if g_sql_run = 'Y' then
1293: --

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

1292: if g_sql_run = 'Y' then
1293: --
1294: if g_log = 'Y' then
1295: --
1296: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1297: --
1298: end if;
1299: --
1300: else

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

1305: --
1306: when others then
1307: --
1308: if g_debug then
1309: hr_utility.set_location(l_proc,-1000);
1310: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1311: end if;
1312: --
1313: if g_sql_run = 'Y' then

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

1306: when others then
1307: --
1308: if g_debug then
1309: hr_utility.set_location(l_proc,-1000);
1310: hr_utility.trace(to_char(p_assignment_id)||':'||get_sqlerrm);
1311: end if;
1312: --
1313: if g_sql_run = 'Y' then
1314: --

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

1313: if g_sql_run = 'Y' then
1314: --
1315: if g_log = 'Y' then
1316: --
1317: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);
1318: --
1319: end if;
1320: --
1321: else

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

1378: g_debug := false;
1379: end if;
1380: --
1381: if g_debug then
1382: hr_utility.set_location(l_proc,0);
1383: end if;
1384: --
1385: if g_skip_qualify is null then
1386: g_skip_qualify := 'N';

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

1414: -- for api use
1415: insert_session(g_mig_date);
1416: --
1417: if g_debug then
1418: hr_utility.set_location(l_proc,10);
1419: end if;
1420: --
1421: -- --
1422: -- range

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

1444: end if;
1445: --
1446: if g_debug then
1447: --
1448: hr_utility.set_location(l_proc,15);
1449: hr_utility.trace('g_range_ass_hi_smr_tbl.count : '||to_char(g_range_ass_hi_smr_tbl.count));
1450: --
1451: if g_range_ass_hi_smr_tbl.count > 0 then
1452: --

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

1445: --
1446: if g_debug then
1447: --
1448: hr_utility.set_location(l_proc,15);
1449: hr_utility.trace('g_range_ass_hi_smr_tbl.count : '||to_char(g_range_ass_hi_smr_tbl.count));
1450: --
1451: if g_range_ass_hi_smr_tbl.count > 0 then
1452: --
1453: for i in 0..g_range_ass_hi_smr_tbl.count - 1 loop

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

1453: for i in 0..g_range_ass_hi_smr_tbl.count - 1 loop
1454: --
1455: if g_detail_debug then
1456: --
1457: hr_utility.trace(to_char(g_range_ass_hi_smr_tbl(i).bg_id)
1458: ||':'||g_range_ass_hi_smr_tbl(i).ass_num
1459: ||'('||to_char(g_range_ass_hi_smr_tbl(i).ass_id)
1460: ||').'||g_range_ass_hi_smr_tbl(i).del_done);
1461: --

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

1467: --
1468: end if;
1469: --
1470: if g_debug then
1471: hr_utility.set_location(l_proc,20);
1472: end if;
1473: --
1474: -- --
1475: -- qualify

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

1476: -- --
1477: --
1478: if g_log = 'Y' then
1479: --
1480: hr_utility.trace('Business Group Name Assignment Number Message');
1481: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');
1482: --
1483: end if;
1484: --

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

1477: --
1478: if g_log = 'Y' then
1479: --
1480: hr_utility.trace('Business Group Name Assignment Number Message');
1481: hr_utility.trace('------------------------------ ------------------------------ --------------------------------------------------------------------------------');
1482: --
1483: end if;
1484: --
1485: if g_skip_qualify = 'N' then

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

1542: for l in 0..g_qualify_hi_smr_ass_tbl.count - 1 loop
1543: --
1544: if g_detail_debug then
1545: --
1546: hr_utility.trace(to_char(g_qualify_hi_smr_ass_tbl(l).bg_id)
1547: ||':'||g_qualify_hi_smr_ass_tbl(l).ass_num
1548: ||'('||to_char(g_qualify_hi_smr_ass_tbl(l).ass_id)
1549: ||').'||g_qualify_hi_smr_ass_tbl(l).del_done);
1550: --

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

1558: --
1559: end if;
1560: --
1561: if g_debug then
1562: hr_utility.set_location(l_proc,30);
1563: end if;
1564: --
1565: -- --
1566: -- upgrade

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

1567: -- --
1568: --
1569: if g_log = 'Y' then
1570: --
1571: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1572: hr_utility.trace('Business Group Name Assignment Number E MR SMR Exp SMR');
1573: hr_utility.trace('------------------------------ ------------------------------ - ---------- ---------- ----------');
1574: --
1575: end if;

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

1568: --
1569: if g_log = 'Y' then
1570: --
1571: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1572: hr_utility.trace('Business Group Name Assignment Number E MR SMR Exp SMR');
1573: hr_utility.trace('------------------------------ ------------------------------ - ---------- ---------- ----------');
1574: --
1575: end if;
1576: --

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

1569: if g_log = 'Y' then
1570: --
1571: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1572: hr_utility.trace('Business Group Name Assignment Number E MR SMR Exp SMR');
1573: hr_utility.trace('------------------------------ ------------------------------ - ---------- ---------- ----------');
1574: --
1575: end if;
1576: --
1577: if l_qualify_valid_update = 'Y' then

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

1608: --
1609: end if;
1610: --
1611: if g_debug then
1612: hr_utility.set_location(l_proc,40);
1613: end if;
1614: --
1615: -- --
1616: -- deinitialize

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

1617: -- --
1618: --
1619: if g_log = 'Y' then
1620: --
1621: hr_utility.trace('----------------------------------------------------------------------------------------------------------------------------------------------');
1622: --
1623: end if;
1624: --
1625: delete_session;

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

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