390: WHEN OTHERS THEN
391: l_failed := l_failed + 1;
392:
393: IF l_failed = 1 THEN
394: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
395: fnd_message.set_token ('ER_LNO', ' ');
396: pnp_debug_pkg.put_log_msg(fnd_message.get);
397: END IF;
398:
391: l_failed := l_failed + 1;
392:
393: IF l_failed = 1 THEN
394: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
395: fnd_message.set_token ('ER_LNO', ' ');
396: pnp_debug_pkg.put_log_msg(fnd_message.get);
397: END IF;
398:
399: fnd_message.set_name ('PN','PN_ITEM_ID');
392:
393: IF l_failed = 1 THEN
394: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
395: fnd_message.set_token ('ER_LNO', ' ');
396: pnp_debug_pkg.put_log_msg(fnd_message.get);
397: END IF;
398:
399: fnd_message.set_name ('PN','PN_ITEM_ID');
400: fnd_message.set_token ('ID', acct_rec.payment_item_id);
395: fnd_message.set_token ('ER_LNO', ' ');
396: pnp_debug_pkg.put_log_msg(fnd_message.get);
397: END IF;
398:
399: fnd_message.set_name ('PN','PN_ITEM_ID');
400: fnd_message.set_token ('ID', acct_rec.payment_item_id);
401: pnp_debug_pkg.put_log_msg(fnd_message.get);
402: END;
403: END LOOP;
396: pnp_debug_pkg.put_log_msg(fnd_message.get);
397: END IF;
398:
399: fnd_message.set_name ('PN','PN_ITEM_ID');
400: fnd_message.set_token ('ID', acct_rec.payment_item_id);
401: pnp_debug_pkg.put_log_msg(fnd_message.get);
402: END;
403: END LOOP;
404:
397: END IF;
398:
399: fnd_message.set_name ('PN','PN_ITEM_ID');
400: fnd_message.set_token ('ID', acct_rec.payment_item_id);
401: pnp_debug_pkg.put_log_msg(fnd_message.get);
402: END;
403: END LOOP;
404:
405: pnp_debug_pkg.log('Updating remaining payment items');
433: END IF;
434:
435: pnp_debug_pkg.put_log_msg('
436: ================================================================================');
437: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
438: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
434:
435: pnp_debug_pkg.put_log_msg('
436: ================================================================================');
437: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
438: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
435: pnp_debug_pkg.put_log_msg('
436: ================================================================================');
437: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
438: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
437: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
438: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
438: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
447: pnp_debug_pkg.put_log_msg(fnd_message.get);
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
447: pnp_debug_pkg.put_log_msg(fnd_message.get);
448:
449: pnp_debug_pkg.put_log_msg('
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
447: pnp_debug_pkg.put_log_msg(fnd_message.get);
448:
449: pnp_debug_pkg.put_log_msg('
450: ================================================================================');
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
447: pnp_debug_pkg.put_log_msg(fnd_message.get);
448:
449: pnp_debug_pkg.put_log_msg('
450: ================================================================================');
451:
659: WHEN OTHERS THEN
660: l_failed := l_failed + 1;
661:
662: IF l_failed = 1 THEN
663: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
664: fnd_message.set_token ('ER_LNO', ' ');
665: pnp_debug_pkg.put_log_msg(fnd_message.get);
666: END IF;
667:
660: l_failed := l_failed + 1;
661:
662: IF l_failed = 1 THEN
663: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
664: fnd_message.set_token ('ER_LNO', ' ');
665: pnp_debug_pkg.put_log_msg(fnd_message.get);
666: END IF;
667:
668: fnd_message.set_name ('PN','PN_ITEM_ID');
661:
662: IF l_failed = 1 THEN
663: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
664: fnd_message.set_token ('ER_LNO', ' ');
665: pnp_debug_pkg.put_log_msg(fnd_message.get);
666: END IF;
667:
668: fnd_message.set_name ('PN','PN_ITEM_ID');
669: fnd_message.set_token ('ID', acct_rec.payment_item_id);
664: fnd_message.set_token ('ER_LNO', ' ');
665: pnp_debug_pkg.put_log_msg(fnd_message.get);
666: END IF;
667:
668: fnd_message.set_name ('PN','PN_ITEM_ID');
669: fnd_message.set_token ('ID', acct_rec.payment_item_id);
670: pnp_debug_pkg.put_log_msg(fnd_message.get);
671:
672: END;
665: pnp_debug_pkg.put_log_msg(fnd_message.get);
666: END IF;
667:
668: fnd_message.set_name ('PN','PN_ITEM_ID');
669: fnd_message.set_token ('ID', acct_rec.payment_item_id);
670: pnp_debug_pkg.put_log_msg(fnd_message.get);
671:
672: END;
673: END LOOP;
666: END IF;
667:
668: fnd_message.set_name ('PN','PN_ITEM_ID');
669: fnd_message.set_token ('ID', acct_rec.payment_item_id);
670: pnp_debug_pkg.put_log_msg(fnd_message.get);
671:
672: END;
673: END LOOP;
674:
703: END IF;
704:
705: pnp_debug_pkg.put_log_msg('
706: ================================================================================');
707: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
708: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
704:
705: pnp_debug_pkg.put_log_msg('
706: ================================================================================');
707: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
708: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
705: pnp_debug_pkg.put_log_msg('
706: ================================================================================');
707: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
708: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
707: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
708: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
708: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
717: pnp_debug_pkg.put_log_msg(fnd_message.get);
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
717: pnp_debug_pkg.put_log_msg(fnd_message.get);
718:
719: pnp_debug_pkg.put_log_msg('
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
717: pnp_debug_pkg.put_log_msg(fnd_message.get);
718:
719: pnp_debug_pkg.put_log_msg('
720: ================================================================================');
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
717: pnp_debug_pkg.put_log_msg(fnd_message.get);
718:
719: pnp_debug_pkg.put_log_msg('
720: ================================================================================');
721:
781: AND pnl.gl_sl_link_id IS NULL ;
782:
783: BEGIN
784: --Print all input parameters
785: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
782:
783: BEGIN
784: --Print all input parameters
785: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
783: BEGIN
784: --Print all input parameters
785: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
784: --Print all input parameters
785: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
785: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
786: fnd_message.set_token ('JC', P_journal_category);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
787: fnd_message.set_token ('BATCH_NAME', p_batch_name);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
788: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
789: fnd_message.set_token ('NAME', p_period_name);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
790: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
791: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
792: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
800: fnd_message.set_token ('TYPE', p_selection_type);
793: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
800: fnd_message.set_token ('TYPE', p_selection_type);
801: pnp_debug_pkg.put_log_msg(fnd_message.get);
794: fnd_message.set_token ('VEND_ID', p_vendor_id);
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
800: fnd_message.set_token ('TYPE', p_selection_type);
801: pnp_debug_pkg.put_log_msg(fnd_message.get);
802:
795: fnd_message.set_token ('CUST_ID', p_customer_id);
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
800: fnd_message.set_token ('TYPE', p_selection_type);
801: pnp_debug_pkg.put_log_msg(fnd_message.get);
802:
803: IF pn_r12_util_pkg.is_r12 THEN
796: fnd_message.set_token ('MODE', p_gl_transfer_mode);
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
800: fnd_message.set_token ('TYPE', p_selection_type);
801: pnp_debug_pkg.put_log_msg(fnd_message.get);
802:
803: IF pn_r12_util_pkg.is_r12 THEN
804: NULL;
797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
800: fnd_message.set_token ('TYPE', p_selection_type);
801: pnp_debug_pkg.put_log_msg(fnd_message.get);
802:
803: IF pn_r12_util_pkg.is_r12 THEN
804: NULL;
805: ELSE
806: OPEN c_default_gl_period;
807: FETCH c_default_gl_period INTO p_default_period;
808: IF c_default_gl_period%NOTFOUND THEN
809: CLOSE c_default_gl_period;
810: fnd_message.set_name('PN','PN_GL_PERIOD_NOT_OPEN');
811: errbuf := fnd_message.get;
812: Retcode := 2;
813: ROLLBACK;
814: RETURN;
807: FETCH c_default_gl_period INTO p_default_period;
808: IF c_default_gl_period%NOTFOUND THEN
809: CLOSE c_default_gl_period;
810: fnd_message.set_name('PN','PN_GL_PERIOD_NOT_OPEN');
811: errbuf := fnd_message.get;
812: Retcode := 2;
813: ROLLBACK;
814: RETURN;
815: END IF;
1275: FETCH get_send_flag INTO l_send_flag;
1276: CLOSE get_send_flag;
1277: l_lease_id := v_pn_lease_id;
1278:
1279: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1280: fnd_message.set_token ('NUM', l_lease_id);
1281: fnd_message.set_token ('FLAG', l_send_flag);
1282: pnp_debug_pkg.put_log_msg(fnd_message.get);
1283:
1276: CLOSE get_send_flag;
1277: l_lease_id := v_pn_lease_id;
1278:
1279: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1280: fnd_message.set_token ('NUM', l_lease_id);
1281: fnd_message.set_token ('FLAG', l_send_flag);
1282: pnp_debug_pkg.put_log_msg(fnd_message.get);
1283:
1284: END IF;
1277: l_lease_id := v_pn_lease_id;
1278:
1279: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1280: fnd_message.set_token ('NUM', l_lease_id);
1281: fnd_message.set_token ('FLAG', l_send_flag);
1282: pnp_debug_pkg.put_log_msg(fnd_message.get);
1283:
1284: END IF;
1285:
1278:
1279: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1280: fnd_message.set_token ('NUM', l_lease_id);
1281: fnd_message.set_token ('FLAG', l_send_flag);
1282: pnp_debug_pkg.put_log_msg(fnd_message.get);
1283:
1284: END IF;
1285:
1286: /* Do processing only if send_flag is Yes */
1287: IF (nvl(l_send_flag,'Y') = 'Y') THEN
1288:
1289: pnp_debug_pkg.put_log_msg('
1290: ================================================================================');
1291: fnd_message.set_name ('PN','PN_LEASE_ID');
1292: fnd_message.set_token ('ID', v_pn_lease_id);
1293: l_message := fnd_message.get;
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1288:
1289: pnp_debug_pkg.put_log_msg('
1290: ================================================================================');
1291: fnd_message.set_name ('PN','PN_LEASE_ID');
1292: fnd_message.set_token ('ID', v_pn_lease_id);
1293: l_message := fnd_message.get;
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1289: pnp_debug_pkg.put_log_msg('
1290: ================================================================================');
1291: fnd_message.set_name ('PN','PN_LEASE_ID');
1292: fnd_message.set_token ('ID', v_pn_lease_id);
1293: l_message := fnd_message.get;
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1290: ================================================================================');
1291: fnd_message.set_name ('PN','PN_LEASE_ID');
1292: fnd_message.set_token ('ID', v_pn_lease_id);
1293: l_message := fnd_message.get;
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1291: fnd_message.set_name ('PN','PN_LEASE_ID');
1292: fnd_message.set_token ('ID', v_pn_lease_id);
1293: l_message := fnd_message.get;
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1299: l_message := l_message||' - '||fnd_message.get;
1292: fnd_message.set_token ('ID', v_pn_lease_id);
1293: l_message := fnd_message.get;
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1299: l_message := l_message||' - '||fnd_message.get;
1300: pnp_debug_pkg.put_log_msg(l_message);
1293: l_message := fnd_message.get;
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1299: l_message := l_message||' - '||fnd_message.get;
1300: pnp_debug_pkg.put_log_msg(l_message);
1301: pnp_debug_pkg.put_log_msg('
1294: fnd_message.set_name ('PN','PN_ITEM_ID');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1299: l_message := l_message||' - '||fnd_message.get;
1300: pnp_debug_pkg.put_log_msg(l_message);
1301: pnp_debug_pkg.put_log_msg('
1302: ================================================================================');
1295: fnd_message.set_token ('ID', v_pn_payment_item_id);
1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1299: l_message := l_message||' - '||fnd_message.get;
1300: pnp_debug_pkg.put_log_msg(l_message);
1301: pnp_debug_pkg.put_log_msg('
1302: ================================================================================');
1303:
1311: := PNP_UTIL_FUNC.check_conversion_type
1312: ( l_func_curr_code
1313: ,pn_mo_cache_utils.get_current_org_id);
1314:
1315: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1316: fnd_message.set_token ('CT', l_conv_rate_type);
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1312: ( l_func_curr_code
1313: ,pn_mo_cache_utils.get_current_org_id);
1314:
1315: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1316: fnd_message.set_token ('CT', l_conv_rate_type);
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1320: fnd_message.set_token ('CR', v_pn_rate);
1313: ,pn_mo_cache_utils.get_current_org_id);
1314:
1315: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1316: fnd_message.set_token ('CT', l_conv_rate_type);
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1320: fnd_message.set_token ('CR', v_pn_rate);
1321: pnp_debug_pkg.put_log_msg(fnd_message.get);
1315: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1316: fnd_message.set_token ('CT', l_conv_rate_type);
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1320: fnd_message.set_token ('CR', v_pn_rate);
1321: pnp_debug_pkg.put_log_msg(fnd_message.get);
1322:
1323:
1316: fnd_message.set_token ('CT', l_conv_rate_type);
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1320: fnd_message.set_token ('CR', v_pn_rate);
1321: pnp_debug_pkg.put_log_msg(fnd_message.get);
1322:
1323:
1324: /* if the accounted amount is null, then, GET IT!
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1320: fnd_message.set_token ('CR', v_pn_rate);
1321: pnp_debug_pkg.put_log_msg(fnd_message.get);
1322:
1323:
1324: /* if the accounted amount is null, then, GET IT!
1325: Ensure we populate accounted_CR/DR in the AE Lines */
1356: l_period_name := v_pn_period_name;
1357: END IF;
1358: CLOSE c_valid_period;
1359:
1360: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1361: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1357: END IF;
1358: CLOSE c_valid_period;
1359:
1360: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1361: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1365: fnd_message.set_token ('PERIOD', l_period_name);
1358: CLOSE c_valid_period;
1359:
1360: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1361: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1365: fnd_message.set_token ('PERIOD', l_period_name);
1366: pnp_debug_pkg.put_log_msg(fnd_message.get);
1360: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1361: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1365: fnd_message.set_token ('PERIOD', l_period_name);
1366: pnp_debug_pkg.put_log_msg(fnd_message.get);
1367:
1368: /* if pay term changed, re init, create accounting EVENT */
1361: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1365: fnd_message.set_token ('PERIOD', l_period_name);
1366: pnp_debug_pkg.put_log_msg(fnd_message.get);
1367:
1368: /* if pay term changed, re init, create accounting EVENT */
1369: IF l_term_id <> v_pn_payment_term_id THEN
1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1365: fnd_message.set_token ('PERIOD', l_period_name);
1366: pnp_debug_pkg.put_log_msg(fnd_message.get);
1367:
1368: /* if pay term changed, re init, create accounting EVENT */
1369: IF l_term_id <> v_pn_payment_term_id THEN
1370:
1527: l_diff_acc_amt := l_total_rev_acc_amt - l_item_accounted_amt;
1528: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
1529: END IF;
1530:
1531: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
1532: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1533: pnp_debug_pkg.put_log_msg(fnd_message.get);
1534:
1535: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
1528: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
1529: END IF;
1530:
1531: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
1532: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1533: pnp_debug_pkg.put_log_msg(fnd_message.get);
1534:
1535: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
1536: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1529: END IF;
1530:
1531: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
1532: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1533: pnp_debug_pkg.put_log_msg(fnd_message.get);
1534:
1535: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
1536: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1537: p_application_id => 101,
1531: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
1532: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1533: pnp_debug_pkg.put_log_msg(fnd_message.get);
1534:
1535: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
1536: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1537: p_application_id => 101,
1538: p_id_flex_code => 'GL#',
1539: p_id_flex_num => l_chart_of_id,
1532: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1533: pnp_debug_pkg.put_log_msg(fnd_message.get);
1534:
1535: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
1536: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1537: p_application_id => 101,
1538: p_id_flex_code => 'GL#',
1539: p_id_flex_num => l_chart_of_id,
1540: p_qualifier => 'ALL',
1538: p_id_flex_code => 'GL#',
1539: p_id_flex_num => l_chart_of_id,
1540: p_qualifier => 'ALL',
1541: p_ccid => rev_acnt_tab(i).account_id));
1542: pnp_debug_pkg.put_log_msg(fnd_message.get);
1543:
1544: pnp_debug_pkg.log('Inserting into lines for Revenue');
1545:
1546: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1641: l_diff_acc_amt := l_total_rev_acc_amt - l_item_accounted_amt;
1642: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
1643: END IF;
1644:
1645: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
1646: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1647: pnp_debug_pkg.put_log_msg(fnd_message.get);
1648:
1649: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
1642: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
1643: END IF;
1644:
1645: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
1646: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1647: pnp_debug_pkg.put_log_msg(fnd_message.get);
1648:
1649: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
1650: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1643: END IF;
1644:
1645: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
1646: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1647: pnp_debug_pkg.put_log_msg(fnd_message.get);
1648:
1649: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
1650: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1651: p_application_id => 101,
1645: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
1646: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1647: pnp_debug_pkg.put_log_msg(fnd_message.get);
1648:
1649: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
1650: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1651: p_application_id => 101,
1652: p_id_flex_code => 'GL#',
1653: p_id_flex_num => l_chart_of_id,
1646: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1647: pnp_debug_pkg.put_log_msg(fnd_message.get);
1648:
1649: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
1650: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1651: p_application_id => 101,
1652: p_id_flex_code => 'GL#',
1653: p_id_flex_num => l_chart_of_id,
1654: p_qualifier => 'ALL',
1652: p_id_flex_code => 'GL#',
1653: p_id_flex_num => l_chart_of_id,
1654: p_qualifier => 'ALL',
1655: p_ccid => acc_acnt_tab(i).account_id));
1656: pnp_debug_pkg.put_log_msg(fnd_message.get);
1657:
1658: pnp_debug_pkg.log('Inserting into lines for Accrued Asset');
1659: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1660:
1765: CLOSE c_term;
1766:
1767: pnp_debug_pkg.put_log_msg('
1768: ================================================================================');
1769: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
1770: fnd_message.set_token ('NUM', to_char(s_count));
1771: pnp_debug_pkg.put_log_msg(fnd_message.get);
1772: pnp_debug_pkg.put_log_msg('
1773: ================================================================================');
1766:
1767: pnp_debug_pkg.put_log_msg('
1768: ================================================================================');
1769: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
1770: fnd_message.set_token ('NUM', to_char(s_count));
1771: pnp_debug_pkg.put_log_msg(fnd_message.get);
1772: pnp_debug_pkg.put_log_msg('
1773: ================================================================================');
1774:
1767: pnp_debug_pkg.put_log_msg('
1768: ================================================================================');
1769: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
1770: fnd_message.set_token ('NUM', to_char(s_count));
1771: pnp_debug_pkg.put_log_msg(fnd_message.get);
1772: pnp_debug_pkg.put_log_msg('
1773: ================================================================================');
1774:
1775: END CREATE_AR_ACC;
2028: OPEN get_send_flag(v_pn_lease_id);
2029: FETCH get_send_flag INTO l_send_flag;
2030: CLOSE get_send_flag;
2031: l_lease_id := v_pn_lease_id;
2032: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2033: fnd_message.set_token ('NUM', l_lease_id);
2034: fnd_message.set_token ('FLAG', l_send_flag);
2035: pnp_debug_pkg.put_log_msg(fnd_message.get);
2036:
2029: FETCH get_send_flag INTO l_send_flag;
2030: CLOSE get_send_flag;
2031: l_lease_id := v_pn_lease_id;
2032: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2033: fnd_message.set_token ('NUM', l_lease_id);
2034: fnd_message.set_token ('FLAG', l_send_flag);
2035: pnp_debug_pkg.put_log_msg(fnd_message.get);
2036:
2037: END IF;
2030: CLOSE get_send_flag;
2031: l_lease_id := v_pn_lease_id;
2032: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2033: fnd_message.set_token ('NUM', l_lease_id);
2034: fnd_message.set_token ('FLAG', l_send_flag);
2035: pnp_debug_pkg.put_log_msg(fnd_message.get);
2036:
2037: END IF;
2038:
2031: l_lease_id := v_pn_lease_id;
2032: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2033: fnd_message.set_token ('NUM', l_lease_id);
2034: fnd_message.set_token ('FLAG', l_send_flag);
2035: pnp_debug_pkg.put_log_msg(fnd_message.get);
2036:
2037: END IF;
2038:
2039: /* Do processing only if send_flag is Yes */
2041:
2042:
2043: pnp_debug_pkg.put_log_msg('
2044: ================================================================================');
2045: fnd_message.set_name ('PN','PN_LEASE_ID');
2046: fnd_message.set_token ('ID', v_pn_lease_id);
2047: l_message := fnd_message.get;
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2042:
2043: pnp_debug_pkg.put_log_msg('
2044: ================================================================================');
2045: fnd_message.set_name ('PN','PN_LEASE_ID');
2046: fnd_message.set_token ('ID', v_pn_lease_id);
2047: l_message := fnd_message.get;
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2043: pnp_debug_pkg.put_log_msg('
2044: ================================================================================');
2045: fnd_message.set_name ('PN','PN_LEASE_ID');
2046: fnd_message.set_token ('ID', v_pn_lease_id);
2047: l_message := fnd_message.get;
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2044: ================================================================================');
2045: fnd_message.set_name ('PN','PN_LEASE_ID');
2046: fnd_message.set_token ('ID', v_pn_lease_id);
2047: l_message := fnd_message.get;
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2045: fnd_message.set_name ('PN','PN_LEASE_ID');
2046: fnd_message.set_token ('ID', v_pn_lease_id);
2047: l_message := fnd_message.get;
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2053: l_message := l_message||' - '||fnd_message.get;
2046: fnd_message.set_token ('ID', v_pn_lease_id);
2047: l_message := fnd_message.get;
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2053: l_message := l_message||' - '||fnd_message.get;
2054: pnp_debug_pkg.put_log_msg(l_message);
2047: l_message := fnd_message.get;
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2053: l_message := l_message||' - '||fnd_message.get;
2054: pnp_debug_pkg.put_log_msg(l_message);
2055: pnp_debug_pkg.put_log_msg('
2048: fnd_message.set_name ('PN','PN_ITEM_ID');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2053: l_message := l_message||' - '||fnd_message.get;
2054: pnp_debug_pkg.put_log_msg(l_message);
2055: pnp_debug_pkg.put_log_msg('
2056: ================================================================================');
2049: fnd_message.set_token ('ID', v_pn_payment_item_id);
2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2053: l_message := l_message||' - '||fnd_message.get;
2054: pnp_debug_pkg.put_log_msg(l_message);
2055: pnp_debug_pkg.put_log_msg('
2056: ================================================================================');
2057:
2065: := PNP_UTIL_FUNC.check_conversion_type
2066: ( l_func_curr_code
2067: ,pn_mo_cache_utils.get_current_org_id);
2068:
2069: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2070: fnd_message.set_token ('CT', l_conv_rate_type);
2071: pnp_debug_pkg.put_log_msg(fnd_message.get);
2072:
2073:
2066: ( l_func_curr_code
2067: ,pn_mo_cache_utils.get_current_org_id);
2068:
2069: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2070: fnd_message.set_token ('CT', l_conv_rate_type);
2071: pnp_debug_pkg.put_log_msg(fnd_message.get);
2072:
2073:
2074: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2067: ,pn_mo_cache_utils.get_current_org_id);
2068:
2069: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2070: fnd_message.set_token ('CT', l_conv_rate_type);
2071: pnp_debug_pkg.put_log_msg(fnd_message.get);
2072:
2073:
2074: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2075: fnd_message.set_token ('CR', v_pn_rate);
2070: fnd_message.set_token ('CT', l_conv_rate_type);
2071: pnp_debug_pkg.put_log_msg(fnd_message.get);
2072:
2073:
2074: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2075: fnd_message.set_token ('CR', v_pn_rate);
2076: pnp_debug_pkg.put_log_msg(fnd_message.get);
2077:
2078:
2071: pnp_debug_pkg.put_log_msg(fnd_message.get);
2072:
2073:
2074: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2075: fnd_message.set_token ('CR', v_pn_rate);
2076: pnp_debug_pkg.put_log_msg(fnd_message.get);
2077:
2078:
2079: /* if the accounted amount is null, then, GET IT!
2072:
2073:
2074: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2075: fnd_message.set_token ('CR', v_pn_rate);
2076: pnp_debug_pkg.put_log_msg(fnd_message.get);
2077:
2078:
2079: /* if the accounted amount is null, then, GET IT!
2080: Ensure we populate accounted_CR/DR in the AE Lines */
2111: CLOSE C_VALID_PERIOD;
2112:
2113:
2114:
2115: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2116: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2112:
2113:
2114:
2115: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2116: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2120: fnd_message.set_token ('PERIOD', l_period_name);
2113:
2114:
2115: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2116: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2120: fnd_message.set_token ('PERIOD', l_period_name);
2121: pnp_debug_pkg.put_log_msg(fnd_message.get);
2115: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2116: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2120: fnd_message.set_token ('PERIOD', l_period_name);
2121: pnp_debug_pkg.put_log_msg(fnd_message.get);
2122:
2123: IF l_term_id <> v_pn_payment_term_id THEN
2116: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2120: fnd_message.set_token ('PERIOD', l_period_name);
2121: pnp_debug_pkg.put_log_msg(fnd_message.get);
2122:
2123: IF l_term_id <> v_pn_payment_term_id THEN
2124:
2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2120: fnd_message.set_token ('PERIOD', l_period_name);
2121: pnp_debug_pkg.put_log_msg(fnd_message.get);
2122:
2123: IF l_term_id <> v_pn_payment_term_id THEN
2124:
2125: l_term_id := v_pn_payment_term_id ;
2286: l_diff_acc_amt := l_total_exp_acc_amt - l_item_accounted_amt;
2287: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2288: END IF;
2289:
2290: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2291: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2292: pnp_debug_pkg.put_log_msg(fnd_message.get);
2293:
2294: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2287: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2288: END IF;
2289:
2290: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2291: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2292: pnp_debug_pkg.put_log_msg(fnd_message.get);
2293:
2294: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2295: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2288: END IF;
2289:
2290: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2291: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2292: pnp_debug_pkg.put_log_msg(fnd_message.get);
2293:
2294: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2295: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2296: p_application_id => 101,
2290: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2291: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2292: pnp_debug_pkg.put_log_msg(fnd_message.get);
2293:
2294: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2295: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2296: p_application_id => 101,
2297: p_id_flex_code => 'GL#',
2298: p_id_flex_num => l_chart_of_id,
2291: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2292: pnp_debug_pkg.put_log_msg(fnd_message.get);
2293:
2294: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2295: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2296: p_application_id => 101,
2297: p_id_flex_code => 'GL#',
2298: p_id_flex_num => l_chart_of_id,
2299: p_qualifier => 'ALL',
2298: p_id_flex_num => l_chart_of_id,
2299: p_qualifier => 'ALL',
2300: p_ccid => exp_acnt_tab(i).account_id));
2301:
2302: pnp_debug_pkg.put_log_msg(fnd_message.get);
2303:
2304: pnp_debug_pkg.log('Inserting into lines for Expense');
2305:
2306: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2400: l_diff_acc_amt := l_total_exp_acc_amt - l_item_accounted_amt;
2401: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2402: END IF;
2403:
2404: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2405: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2401: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2402: END IF;
2403:
2404: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2405: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2409: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2402: END IF;
2403:
2404: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2405: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2409: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2410: p_application_id => 101,
2404: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2405: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2409: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2410: p_application_id => 101,
2411: p_id_flex_code => 'GL#',
2412: p_id_flex_num => l_chart_of_id,
2405: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2409: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2410: p_application_id => 101,
2411: p_id_flex_code => 'GL#',
2412: p_id_flex_num => l_chart_of_id,
2413: p_qualifier => 'ALL',
2412: p_id_flex_num => l_chart_of_id,
2413: p_qualifier => 'ALL',
2414: p_ccid => acc_acnt_tab(i).account_id));
2415:
2416: pnp_debug_pkg.put_log_msg(fnd_message.get);
2417:
2418: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');
2419: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2420:
2525: CLOSE c_term;
2526:
2527: pnp_debug_pkg.put_log_msg('
2528: ================================================================================');
2529: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2530: fnd_message.set_token ('NUM', to_char(s_count));
2531: pnp_debug_pkg.put_log_msg(fnd_message.get);
2532: pnp_debug_pkg.put_log_msg('
2533: ================================================================================');
2526:
2527: pnp_debug_pkg.put_log_msg('
2528: ================================================================================');
2529: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2530: fnd_message.set_token ('NUM', to_char(s_count));
2531: pnp_debug_pkg.put_log_msg(fnd_message.get);
2532: pnp_debug_pkg.put_log_msg('
2533: ================================================================================');
2534: END CREATE_AP_ACC;
2527: pnp_debug_pkg.put_log_msg('
2528: ================================================================================');
2529: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2530: fnd_message.set_token ('NUM', to_char(s_count));
2531: pnp_debug_pkg.put_log_msg(fnd_message.get);
2532: pnp_debug_pkg.put_log_msg('
2533: ================================================================================');
2534: END CREATE_AP_ACC;
2535: