117:
118:
119: --Print all input parameters
120:
121: fnd_message.set_name ('PN','PN_HRSYNC_INP_PARAMS');
122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
118:
119: --Print all input parameters
120:
121: fnd_message.set_name ('PN','PN_HRSYNC_INP_PARAMS');
122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
119: --Print all input parameters
120:
121: fnd_message.set_name ('PN','PN_HRSYNC_INP_PARAMS');
122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
127: pnp_debug_pkg.put_log_msg(fnd_message.get);
120:
121: fnd_message.set_name ('PN','PN_HRSYNC_INP_PARAMS');
122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
127: pnp_debug_pkg.put_log_msg(fnd_message.get);
128:
121: fnd_message.set_name ('PN','PN_HRSYNC_INP_PARAMS');
122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
127: pnp_debug_pkg.put_log_msg(fnd_message.get);
128:
129: l_log_context := ' Getting as of Date..';
122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
127: pnp_debug_pkg.put_log_msg(fnd_message.get);
128:
129: l_log_context := ' Getting as of Date..';
130: l_as_of_date := trunc(fnd_date.canonical_to_date(p_as_of_date));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
127: pnp_debug_pkg.put_log_msg(fnd_message.get);
128:
129: l_log_context := ' Getting as of Date..';
130: l_as_of_date := trunc(fnd_date.canonical_to_date(p_as_of_date));
131:
405: /* Comapre cost centers and make changes if necessary */
406:
407: IF l_cost_center IS NULL THEN
408:
409: fnd_message.set_name ('PN', 'PN_CC_NOT_FOUND_MSG');
410: l_err_msg1 := fnd_message.get;
411: l_failure_msg := rpad(nvl(l_emp_name,' '), 50, ' ') ||
412: rpad(asg_rec.emp_assign_start_date, 15, ' ') ||
413: rpad(nvl(to_char(asg_rec.emp_assign_end_date),' '), 15, ' ') ||
406:
407: IF l_cost_center IS NULL THEN
408:
409: fnd_message.set_name ('PN', 'PN_CC_NOT_FOUND_MSG');
410: l_err_msg1 := fnd_message.get;
411: l_failure_msg := rpad(nvl(l_emp_name,' '), 50, ' ') ||
412: rpad(asg_rec.emp_assign_start_date, 15, ' ') ||
413: rpad(nvl(to_char(asg_rec.emp_assign_end_date),' '), 15, ' ') ||
414: rpad(pnp_util_func.get_location_code(asg_rec.location_id, l_as_of_date), 30, ' ') ||
576:
577: pnp_debug_pkg.put_log_msg('===============================================================================');
578:
579:
580: fnd_message.set_name ('PN','PN_CAFM_LOCATION_TOTAL');
581: fnd_message.set_token ('TOTAL', TO_CHAR(l_count_total));
582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
577: pnp_debug_pkg.put_log_msg('===============================================================================');
578:
579:
580: fnd_message.set_name ('PN','PN_CAFM_LOCATION_TOTAL');
581: fnd_message.set_token ('TOTAL', TO_CHAR(l_count_total));
582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
578:
579:
580: fnd_message.set_name ('PN','PN_CAFM_LOCATION_TOTAL');
581: fnd_message.set_token ('TOTAL', TO_CHAR(l_count_total));
582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
580: fnd_message.set_name ('PN','PN_CAFM_LOCATION_TOTAL');
581: fnd_message.set_token ('TOTAL', TO_CHAR(l_count_total));
582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
581: fnd_message.set_token ('TOTAL', TO_CHAR(l_count_total));
582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
590: pnp_debug_pkg.put_log_msg(fnd_message.get);
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
590: pnp_debug_pkg.put_log_msg(fnd_message.get);
591:
592: pnp_debug_pkg.put_log_msg('===============================================================================');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
590: pnp_debug_pkg.put_log_msg(fnd_message.get);
591:
592: pnp_debug_pkg.put_log_msg('===============================================================================');
593:
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
590: pnp_debug_pkg.put_log_msg(fnd_message.get);
591:
592: pnp_debug_pkg.put_log_msg('===============================================================================');
593:
594:
598: l_log_context := ' printing failure table...';
599: pnp_debug_pkg.put_log_msg(' ');
600: pnp_debug_pkg.put_log_msg(' ');
601:
602: fnd_message.set_name ('PN','PN_HRSYNC_FAIL_DTLS');
603: pnp_debug_pkg.put_log_msg(fnd_message.get);
604:
605: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
606: l_message := fnd_message.get;
599: pnp_debug_pkg.put_log_msg(' ');
600: pnp_debug_pkg.put_log_msg(' ');
601:
602: fnd_message.set_name ('PN','PN_HRSYNC_FAIL_DTLS');
603: pnp_debug_pkg.put_log_msg(fnd_message.get);
604:
605: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
606: l_message := fnd_message.get;
607: l_message := l_message||' ';
601:
602: fnd_message.set_name ('PN','PN_HRSYNC_FAIL_DTLS');
603: pnp_debug_pkg.put_log_msg(fnd_message.get);
604:
605: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
606: l_message := fnd_message.get;
607: l_message := l_message||' ';
608:
609: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
602: fnd_message.set_name ('PN','PN_HRSYNC_FAIL_DTLS');
603: pnp_debug_pkg.put_log_msg(fnd_message.get);
604:
605: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
606: l_message := fnd_message.get;
607: l_message := l_message||' ';
608:
609: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
610: l_message := l_message||fnd_message.get||' ';
605: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
606: l_message := fnd_message.get;
607: l_message := l_message||' ';
608:
609: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
610: l_message := l_message||fnd_message.get||' ';
611:
612: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
613: l_message := l_message||fnd_message.get||' ';
606: l_message := fnd_message.get;
607: l_message := l_message||' ';
608:
609: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
610: l_message := l_message||fnd_message.get||' ';
611:
612: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
613: l_message := l_message||fnd_message.get||' ';
614:
608:
609: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
610: l_message := l_message||fnd_message.get||' ';
611:
612: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
613: l_message := l_message||fnd_message.get||' ';
614:
615: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
616: l_message := l_message||fnd_message.get||' ';
609: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
610: l_message := l_message||fnd_message.get||' ';
611:
612: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
613: l_message := l_message||fnd_message.get||' ';
614:
615: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
616: l_message := l_message||fnd_message.get||' ';
617:
611:
612: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
613: l_message := l_message||fnd_message.get||' ';
614:
615: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
616: l_message := l_message||fnd_message.get||' ';
617:
618: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_CC');
619: l_message := l_message||fnd_message.get||' ';
612: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
613: l_message := l_message||fnd_message.get||' ';
614:
615: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
616: l_message := l_message||fnd_message.get||' ';
617:
618: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_CC');
619: l_message := l_message||fnd_message.get||' ';
620:
614:
615: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
616: l_message := l_message||fnd_message.get||' ';
617:
618: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_CC');
619: l_message := l_message||fnd_message.get||' ';
620:
621: fnd_message.set_name ('PN','PN_ERR');
622: l_message := l_message||fnd_message.get||' ';
615: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
616: l_message := l_message||fnd_message.get||' ';
617:
618: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_CC');
619: l_message := l_message||fnd_message.get||' ';
620:
621: fnd_message.set_name ('PN','PN_ERR');
622: l_message := l_message||fnd_message.get||' ';
623:
617:
618: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_CC');
619: l_message := l_message||fnd_message.get||' ';
620:
621: fnd_message.set_name ('PN','PN_ERR');
622: l_message := l_message||fnd_message.get||' ';
623:
624: pnp_debug_pkg.put_log_msg(l_message);
625: pnp_debug_pkg.put_log_msg(' ');
618: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_CC');
619: l_message := l_message||fnd_message.get||' ';
620:
621: fnd_message.set_name ('PN','PN_ERR');
622: l_message := l_message||fnd_message.get||' ';
623:
624: pnp_debug_pkg.put_log_msg(l_message);
625: pnp_debug_pkg.put_log_msg(' ');
626:
643: IF success_table.COUNT > 0 THEN
644: l_log_context := ' printing success table...';
645: pnp_debug_pkg.put_log_msg(' ');
646: pnp_debug_pkg.put_log_msg(' ');
647: fnd_message.set_name ('PN','PN_HRSYNC_SUC_DTLS');
648: pnp_debug_pkg.put_log_msg(fnd_message.get);
649:
650: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
651: l_message := fnd_message.get;
644: l_log_context := ' printing success table...';
645: pnp_debug_pkg.put_log_msg(' ');
646: pnp_debug_pkg.put_log_msg(' ');
647: fnd_message.set_name ('PN','PN_HRSYNC_SUC_DTLS');
648: pnp_debug_pkg.put_log_msg(fnd_message.get);
649:
650: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
651: l_message := fnd_message.get;
652: l_message := l_message||' ';
646: pnp_debug_pkg.put_log_msg(' ');
647: fnd_message.set_name ('PN','PN_HRSYNC_SUC_DTLS');
648: pnp_debug_pkg.put_log_msg(fnd_message.get);
649:
650: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
651: l_message := fnd_message.get;
652: l_message := l_message||' ';
653:
654: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
647: fnd_message.set_name ('PN','PN_HRSYNC_SUC_DTLS');
648: pnp_debug_pkg.put_log_msg(fnd_message.get);
649:
650: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
651: l_message := fnd_message.get;
652: l_message := l_message||' ';
653:
654: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
655: l_message := l_message||fnd_message.get||' ';
650: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
651: l_message := fnd_message.get;
652: l_message := l_message||' ';
653:
654: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
655: l_message := l_message||fnd_message.get||' ';
656:
657: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
658: l_message := l_message||fnd_message.get||' ';
651: l_message := fnd_message.get;
652: l_message := l_message||' ';
653:
654: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
655: l_message := l_message||fnd_message.get||' ';
656:
657: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
658: l_message := l_message||fnd_message.get||' ';
659:
653:
654: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
655: l_message := l_message||fnd_message.get||' ';
656:
657: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
658: l_message := l_message||fnd_message.get||' ';
659:
660: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
661: l_message := l_message||fnd_message.get||' ';
654: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_FROM');
655: l_message := l_message||fnd_message.get||' ';
656:
657: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
658: l_message := l_message||fnd_message.get||' ';
659:
660: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
661: l_message := l_message||fnd_message.get||' ';
662:
656:
657: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
658: l_message := l_message||fnd_message.get||' ';
659:
660: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
661: l_message := l_message||fnd_message.get||' ';
662:
663: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_OLD_CC');
664: l_message := l_message||fnd_message.get||' ';
657: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_TO');
658: l_message := l_message||fnd_message.get||' ';
659:
660: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
661: l_message := l_message||fnd_message.get||' ';
662:
663: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_OLD_CC');
664: l_message := l_message||fnd_message.get||' ';
665:
659:
660: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
661: l_message := l_message||fnd_message.get||' ';
662:
663: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_OLD_CC');
664: l_message := l_message||fnd_message.get||' ';
665:
666: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NEW_CC');
667: l_message := l_message||fnd_message.get||' ';
660: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_LOC');
661: l_message := l_message||fnd_message.get||' ';
662:
663: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_OLD_CC');
664: l_message := l_message||fnd_message.get||' ';
665:
666: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NEW_CC');
667: l_message := l_message||fnd_message.get||' ';
668:
662:
663: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_OLD_CC');
664: l_message := l_message||fnd_message.get||' ';
665:
666: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NEW_CC');
667: l_message := l_message||fnd_message.get||' ';
668:
669: pnp_debug_pkg.put_log_msg(l_message);
670: pnp_debug_pkg.put_log_msg(' ');
663: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_OLD_CC');
664: l_message := l_message||fnd_message.get||' ';
665:
666: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NEW_CC');
667: l_message := l_message||fnd_message.get||' ';
668:
669: pnp_debug_pkg.put_log_msg(l_message);
670: pnp_debug_pkg.put_log_msg(' ');
671: