APPS.PN_CREATE_ACC dependencies on FND_MESSAGE

Line 466: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');

462: l_diff_acc_amt := l_total_exp_acc_amt - p_accounted_amount;
463: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
464: END IF;
465:
466: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
467: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
468: pnp_debug_pkg.put_log_msg(fnd_message.get);
469:
470: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');

Line 467: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));

463: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
464: END IF;
465:
466: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
467: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
468: pnp_debug_pkg.put_log_msg(fnd_message.get);
469:
470: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
471: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

Line 468: pnp_debug_pkg.put_log_msg(fnd_message.get);

464: END IF;
465:
466: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
467: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
468: pnp_debug_pkg.put_log_msg(fnd_message.get);
469:
470: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
471: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
472: p_application_id => 101,

Line 470: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');

466: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
467: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
468: pnp_debug_pkg.put_log_msg(fnd_message.get);
469:
470: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
471: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
472: p_application_id => 101,
473: p_id_flex_code => 'GL#',
474: p_id_flex_num => l_chart_of_id,

Line 471: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

467: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
468: pnp_debug_pkg.put_log_msg(fnd_message.get);
469:
470: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
471: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
472: p_application_id => 101,
473: p_id_flex_code => 'GL#',
474: p_id_flex_num => l_chart_of_id,
475: p_qualifier => 'ALL',

Line 478: pnp_debug_pkg.put_log_msg(fnd_message.get);

474: p_id_flex_num => l_chart_of_id,
475: p_qualifier => 'ALL',
476: p_ccid => exp_acnt_tab(i).account_id));
477:
478: pnp_debug_pkg.put_log_msg(fnd_message.get);
479:
480: pnp_debug_pkg.log('Inserting into lines for Expense');
481:
482:

Line 547: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');

543: l_diff_acc_amt := l_total_exp_acc_amt - p_accounted_amount;
544: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
545: END IF;
546:
547: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
548: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
549: pnp_debug_pkg.put_log_msg(fnd_message.get);
550:
551: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');

Line 548: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));

544: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
545: END IF;
546:
547: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
548: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
549: pnp_debug_pkg.put_log_msg(fnd_message.get);
550:
551: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
552: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

Line 549: pnp_debug_pkg.put_log_msg(fnd_message.get);

545: END IF;
546:
547: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
548: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
549: pnp_debug_pkg.put_log_msg(fnd_message.get);
550:
551: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
552: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
553: p_application_id => 101,

Line 551: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');

547: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
548: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
549: pnp_debug_pkg.put_log_msg(fnd_message.get);
550:
551: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
552: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
553: p_application_id => 101,
554: p_id_flex_code => 'GL#',
555: p_id_flex_num => l_chart_of_id,

Line 552: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

548: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
549: pnp_debug_pkg.put_log_msg(fnd_message.get);
550:
551: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
552: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
553: p_application_id => 101,
554: p_id_flex_code => 'GL#',
555: p_id_flex_num => l_chart_of_id,
556: p_qualifier => 'ALL',

Line 559: pnp_debug_pkg.put_log_msg(fnd_message.get);

555: p_id_flex_num => l_chart_of_id,
556: p_qualifier => 'ALL',
557: p_ccid => acc_acnt_tab(i).account_id));
558:
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');
562:
563:

Line 840: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');

836: WHEN OTHERS THEN
837: l_failed := l_failed + 1;
838:
839: IF l_failed = 1 THEN
840: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
841: fnd_message.set_token ('ER_LNO', ' ');
842: pnp_debug_pkg.put_log_msg(fnd_message.get);
843: END IF;
844:

Line 841: fnd_message.set_token ('ER_LNO', ' ');

837: l_failed := l_failed + 1;
838:
839: IF l_failed = 1 THEN
840: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
841: fnd_message.set_token ('ER_LNO', ' ');
842: pnp_debug_pkg.put_log_msg(fnd_message.get);
843: END IF;
844:
845: fnd_message.set_name ('PN','PN_ITEM_ID');

Line 842: pnp_debug_pkg.put_log_msg(fnd_message.get);

838:
839: IF l_failed = 1 THEN
840: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
841: fnd_message.set_token ('ER_LNO', ' ');
842: pnp_debug_pkg.put_log_msg(fnd_message.get);
843: END IF;
844:
845: fnd_message.set_name ('PN','PN_ITEM_ID');
846: fnd_message.set_token ('ID', acct_rec.payment_item_id);

Line 845: fnd_message.set_name ('PN','PN_ITEM_ID');

841: fnd_message.set_token ('ER_LNO', ' ');
842: pnp_debug_pkg.put_log_msg(fnd_message.get);
843: END IF;
844:
845: fnd_message.set_name ('PN','PN_ITEM_ID');
846: fnd_message.set_token ('ID', acct_rec.payment_item_id);
847: pnp_debug_pkg.put_log_msg(fnd_message.get);
848: END;
849: END LOOP;

Line 846: fnd_message.set_token ('ID', acct_rec.payment_item_id);

842: pnp_debug_pkg.put_log_msg(fnd_message.get);
843: END IF;
844:
845: fnd_message.set_name ('PN','PN_ITEM_ID');
846: fnd_message.set_token ('ID', acct_rec.payment_item_id);
847: pnp_debug_pkg.put_log_msg(fnd_message.get);
848: END;
849: END LOOP;
850:

Line 847: pnp_debug_pkg.put_log_msg(fnd_message.get);

843: END IF;
844:
845: fnd_message.set_name ('PN','PN_ITEM_ID');
846: fnd_message.set_token ('ID', acct_rec.payment_item_id);
847: pnp_debug_pkg.put_log_msg(fnd_message.get);
848: END;
849: END LOOP;
850:
851: pnp_debug_pkg.log('Updating remaining payment items');

Line 883: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');

879: END IF;
880:
881: pnp_debug_pkg.put_log_msg('
882: ================================================================================');
883: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
884: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
885: pnp_debug_pkg.put_log_msg(fnd_message.get);
886:
887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');

Line 884: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));

880:
881: pnp_debug_pkg.put_log_msg('
882: ================================================================================');
883: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
884: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
885: pnp_debug_pkg.put_log_msg(fnd_message.get);
886:
887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
888: fnd_message.set_token ('SUC_LNO', to_char(l_success));

Line 885: pnp_debug_pkg.put_log_msg(fnd_message.get);

881: pnp_debug_pkg.put_log_msg('
882: ================================================================================');
883: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
884: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
885: pnp_debug_pkg.put_log_msg(fnd_message.get);
886:
887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
888: fnd_message.set_token ('SUC_LNO', to_char(l_success));
889: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');

883: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
884: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
885: pnp_debug_pkg.put_log_msg(fnd_message.get);
886:
887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
888: fnd_message.set_token ('SUC_LNO', to_char(l_success));
889: pnp_debug_pkg.put_log_msg(fnd_message.get);
890:
891: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');

Line 888: fnd_message.set_token ('SUC_LNO', to_char(l_success));

884: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
885: pnp_debug_pkg.put_log_msg(fnd_message.get);
886:
887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
888: fnd_message.set_token ('SUC_LNO', to_char(l_success));
889: pnp_debug_pkg.put_log_msg(fnd_message.get);
890:
891: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
892: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));

Line 889: pnp_debug_pkg.put_log_msg(fnd_message.get);

885: pnp_debug_pkg.put_log_msg(fnd_message.get);
886:
887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
888: fnd_message.set_token ('SUC_LNO', to_char(l_success));
889: pnp_debug_pkg.put_log_msg(fnd_message.get);
890:
891: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
892: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
893: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 891: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');

887: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
888: fnd_message.set_token ('SUC_LNO', to_char(l_success));
889: pnp_debug_pkg.put_log_msg(fnd_message.get);
890:
891: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
892: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
893: pnp_debug_pkg.put_log_msg(fnd_message.get);
894:
895: pnp_debug_pkg.put_log_msg('

Line 892: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));

888: fnd_message.set_token ('SUC_LNO', to_char(l_success));
889: pnp_debug_pkg.put_log_msg(fnd_message.get);
890:
891: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
892: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
893: pnp_debug_pkg.put_log_msg(fnd_message.get);
894:
895: pnp_debug_pkg.put_log_msg('
896: ================================================================================');

Line 893: pnp_debug_pkg.put_log_msg(fnd_message.get);

889: pnp_debug_pkg.put_log_msg(fnd_message.get);
890:
891: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
892: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
893: pnp_debug_pkg.put_log_msg(fnd_message.get);
894:
895: pnp_debug_pkg.put_log_msg('
896: ================================================================================');
897:

Line 1131: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');

1127: WHEN OTHERS THEN
1128: l_failed := l_failed + 1;
1129:
1130: IF l_failed = 1 THEN
1131: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
1132: fnd_message.set_token ('ER_LNO', ' ');
1133: pnp_debug_pkg.put_log_msg(fnd_message.get);
1134: END IF;
1135:

Line 1132: fnd_message.set_token ('ER_LNO', ' ');

1128: l_failed := l_failed + 1;
1129:
1130: IF l_failed = 1 THEN
1131: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
1132: fnd_message.set_token ('ER_LNO', ' ');
1133: pnp_debug_pkg.put_log_msg(fnd_message.get);
1134: END IF;
1135:
1136: fnd_message.set_name ('PN','PN_ITEM_ID');

Line 1133: pnp_debug_pkg.put_log_msg(fnd_message.get);

1129:
1130: IF l_failed = 1 THEN
1131: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
1132: fnd_message.set_token ('ER_LNO', ' ');
1133: pnp_debug_pkg.put_log_msg(fnd_message.get);
1134: END IF;
1135:
1136: fnd_message.set_name ('PN','PN_ITEM_ID');
1137: fnd_message.set_token ('ID', acct_rec.payment_item_id);

Line 1136: fnd_message.set_name ('PN','PN_ITEM_ID');

1132: fnd_message.set_token ('ER_LNO', ' ');
1133: pnp_debug_pkg.put_log_msg(fnd_message.get);
1134: END IF;
1135:
1136: fnd_message.set_name ('PN','PN_ITEM_ID');
1137: fnd_message.set_token ('ID', acct_rec.payment_item_id);
1138: pnp_debug_pkg.put_log_msg(fnd_message.get);
1139:
1140: END;

Line 1137: fnd_message.set_token ('ID', acct_rec.payment_item_id);

1133: pnp_debug_pkg.put_log_msg(fnd_message.get);
1134: END IF;
1135:
1136: fnd_message.set_name ('PN','PN_ITEM_ID');
1137: fnd_message.set_token ('ID', acct_rec.payment_item_id);
1138: pnp_debug_pkg.put_log_msg(fnd_message.get);
1139:
1140: END;
1141: END LOOP;

Line 1138: pnp_debug_pkg.put_log_msg(fnd_message.get);

1134: END IF;
1135:
1136: fnd_message.set_name ('PN','PN_ITEM_ID');
1137: fnd_message.set_token ('ID', acct_rec.payment_item_id);
1138: pnp_debug_pkg.put_log_msg(fnd_message.get);
1139:
1140: END;
1141: END LOOP;
1142:

Line 1175: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');

1171: END IF;
1172:
1173: pnp_debug_pkg.put_log_msg('
1174: ================================================================================');
1175: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
1176: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
1177: pnp_debug_pkg.put_log_msg(fnd_message.get);
1178:
1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');

Line 1176: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));

1172:
1173: pnp_debug_pkg.put_log_msg('
1174: ================================================================================');
1175: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
1176: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
1177: pnp_debug_pkg.put_log_msg(fnd_message.get);
1178:
1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));

Line 1177: pnp_debug_pkg.put_log_msg(fnd_message.get);

1173: pnp_debug_pkg.put_log_msg('
1174: ================================================================================');
1175: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
1176: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
1177: pnp_debug_pkg.put_log_msg(fnd_message.get);
1178:
1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');

1175: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
1176: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
1177: pnp_debug_pkg.put_log_msg(fnd_message.get);
1178:
1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182:
1183: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');

Line 1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));

1176: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
1177: pnp_debug_pkg.put_log_msg(fnd_message.get);
1178:
1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182:
1183: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
1184: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));

Line 1181: pnp_debug_pkg.put_log_msg(fnd_message.get);

1177: pnp_debug_pkg.put_log_msg(fnd_message.get);
1178:
1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182:
1183: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
1184: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
1185: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1183: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');

1179: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182:
1183: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
1184: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
1185: pnp_debug_pkg.put_log_msg(fnd_message.get);
1186:
1187: pnp_debug_pkg.put_log_msg('

Line 1184: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));

1180: fnd_message.set_token ('SUC_LNO', to_char(l_success));
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182:
1183: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
1184: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
1185: pnp_debug_pkg.put_log_msg(fnd_message.get);
1186:
1187: pnp_debug_pkg.put_log_msg('
1188: ================================================================================');

Line 1185: pnp_debug_pkg.put_log_msg(fnd_message.get);

1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182:
1183: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
1184: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
1185: pnp_debug_pkg.put_log_msg(fnd_message.get);
1186:
1187: pnp_debug_pkg.put_log_msg('
1188: ================================================================================');
1189:

Line 1253: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');

1249: AND pnl.gl_sl_link_id IS NULL ;
1250:
1251: BEGIN
1252: --Print all input parameters
1253: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);

Line 1254: fnd_message.set_token ('JC', P_journal_category);

1250:
1251: BEGIN
1252: --Print all input parameters
1253: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));

Line 1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);

1251: BEGIN
1252: --Print all input parameters
1253: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));

Line 1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));

1252: --Print all input parameters
1253: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);

Line 1257: fnd_message.set_token ('NAME', p_period_name);

1253: fnd_message.set_name ('PN','PN_CRACC_INP_PARAMS');
1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);

Line 1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));

1254: fnd_message.set_token ('JC', P_journal_category);
1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);

Line 1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));

1255: fnd_message.set_token ('BATCH_NAME', p_batch_name);
1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);

Line 1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);

1256: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_default_gl_date),'mm/dd/yyyy'));
1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);

Line 1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);

1257: fnd_message.set_token ('NAME', p_period_name);
1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);

Line 1262: fnd_message.set_token ('VEND_ID', p_vendor_id);

1258: fnd_message.set_token ('ST_DATE', to_char(fnd_date.canonical_to_date(p_start_date),'mm/dd/yyyy'));
1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);

Line 1263: fnd_message.set_token ('CUST_ID', p_customer_id);

1259: fnd_message.set_token ('END_DATE',to_char(fnd_date.canonical_to_date(p_end_date),'mm/dd/yyyy'));
1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
1267: fnd_message.set_token ('ORG_ID', p_org_id);

Line 1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);

1260: fnd_message.set_token ('NUM_LOW', p_low_lease_id);
1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
1267: fnd_message.set_token ('ORG_ID', p_org_id);
1268: fnd_message.set_token ('TYPE', p_selection_type);

Line 1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);

1261: fnd_message.set_token ('NUM_HIGH', p_high_lease_id);
1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
1267: fnd_message.set_token ('ORG_ID', p_org_id);
1268: fnd_message.set_token ('TYPE', p_selection_type);
1269: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);

1262: fnd_message.set_token ('VEND_ID', p_vendor_id);
1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
1267: fnd_message.set_token ('ORG_ID', p_org_id);
1268: fnd_message.set_token ('TYPE', p_selection_type);
1269: pnp_debug_pkg.put_log_msg(fnd_message.get);
1270:

Line 1267: fnd_message.set_token ('ORG_ID', p_org_id);

1263: fnd_message.set_token ('CUST_ID', p_customer_id);
1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
1267: fnd_message.set_token ('ORG_ID', p_org_id);
1268: fnd_message.set_token ('TYPE', p_selection_type);
1269: pnp_debug_pkg.put_log_msg(fnd_message.get);
1270:
1271: IF pn_r12_util_pkg.is_r12 THEN

Line 1268: fnd_message.set_token ('TYPE', p_selection_type);

1264: fnd_message.set_token ('MODE', p_gl_transfer_mode);
1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
1267: fnd_message.set_token ('ORG_ID', p_org_id);
1268: fnd_message.set_token ('TYPE', p_selection_type);
1269: pnp_debug_pkg.put_log_msg(fnd_message.get);
1270:
1271: IF pn_r12_util_pkg.is_r12 THEN
1272: NULL;

Line 1269: pnp_debug_pkg.put_log_msg(fnd_message.get);

1265: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
1266: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
1267: fnd_message.set_token ('ORG_ID', p_org_id);
1268: fnd_message.set_token ('TYPE', p_selection_type);
1269: pnp_debug_pkg.put_log_msg(fnd_message.get);
1270:
1271: IF pn_r12_util_pkg.is_r12 THEN
1272: NULL;
1273: ELSE

Line 1278: fnd_message.set_name('PN','PN_GL_PERIOD_NOT_OPEN');

1274: OPEN c_default_gl_period;
1275: FETCH c_default_gl_period INTO p_default_period;
1276: IF c_default_gl_period%NOTFOUND THEN
1277: CLOSE c_default_gl_period;
1278: fnd_message.set_name('PN','PN_GL_PERIOD_NOT_OPEN');
1279: errbuf := fnd_message.get;
1280: Retcode := 2;
1281: ROLLBACK;
1282: RETURN;

Line 1279: errbuf := fnd_message.get;

1275: FETCH c_default_gl_period INTO p_default_period;
1276: IF c_default_gl_period%NOTFOUND THEN
1277: CLOSE c_default_gl_period;
1278: fnd_message.set_name('PN','PN_GL_PERIOD_NOT_OPEN');
1279: errbuf := fnd_message.get;
1280: Retcode := 2;
1281: ROLLBACK;
1282: RETURN;
1283: END IF;

Line 1747: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');

1743: FETCH get_send_flag INTO l_send_flag;
1744: CLOSE get_send_flag;
1745: l_lease_id := v_pn_lease_id;
1746:
1747: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1748: fnd_message.set_token ('NUM', l_lease_id);
1749: fnd_message.set_token ('FLAG', l_send_flag);
1750: pnp_debug_pkg.put_log_msg(fnd_message.get);
1751:

Line 1748: fnd_message.set_token ('NUM', l_lease_id);

1744: CLOSE get_send_flag;
1745: l_lease_id := v_pn_lease_id;
1746:
1747: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1748: fnd_message.set_token ('NUM', l_lease_id);
1749: fnd_message.set_token ('FLAG', l_send_flag);
1750: pnp_debug_pkg.put_log_msg(fnd_message.get);
1751:
1752: END IF;

Line 1749: fnd_message.set_token ('FLAG', l_send_flag);

1745: l_lease_id := v_pn_lease_id;
1746:
1747: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1748: fnd_message.set_token ('NUM', l_lease_id);
1749: fnd_message.set_token ('FLAG', l_send_flag);
1750: pnp_debug_pkg.put_log_msg(fnd_message.get);
1751:
1752: END IF;
1753:

Line 1750: pnp_debug_pkg.put_log_msg(fnd_message.get);

1746:
1747: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1748: fnd_message.set_token ('NUM', l_lease_id);
1749: fnd_message.set_token ('FLAG', l_send_flag);
1750: pnp_debug_pkg.put_log_msg(fnd_message.get);
1751:
1752: END IF;
1753:
1754: /* Do processing only if send_flag is Yes */

Line 1759: fnd_message.set_name ('PN','PN_LEASE_ID');

1755: IF (nvl(l_send_flag,'Y') = 'Y') THEN
1756:
1757: pnp_debug_pkg.put_log_msg('
1758: ================================================================================');
1759: fnd_message.set_name ('PN','PN_LEASE_ID');
1760: fnd_message.set_token ('ID', v_pn_lease_id);
1761: l_message := fnd_message.get;
1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);

Line 1760: fnd_message.set_token ('ID', v_pn_lease_id);

1756:
1757: pnp_debug_pkg.put_log_msg('
1758: ================================================================================');
1759: fnd_message.set_name ('PN','PN_LEASE_ID');
1760: fnd_message.set_token ('ID', v_pn_lease_id);
1761: l_message := fnd_message.get;
1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;

Line 1761: l_message := fnd_message.get;

1757: pnp_debug_pkg.put_log_msg('
1758: ================================================================================');
1759: fnd_message.set_name ('PN','PN_LEASE_ID');
1760: fnd_message.set_token ('ID', v_pn_lease_id);
1761: l_message := fnd_message.get;
1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;
1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');

Line 1762: fnd_message.set_name ('PN','PN_ITEM_ID');

1758: ================================================================================');
1759: fnd_message.set_name ('PN','PN_LEASE_ID');
1760: fnd_message.set_token ('ID', v_pn_lease_id);
1761: l_message := fnd_message.get;
1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;
1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1766: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));

Line 1763: fnd_message.set_token ('ID', v_pn_payment_item_id);

1759: fnd_message.set_name ('PN','PN_LEASE_ID');
1760: fnd_message.set_token ('ID', v_pn_lease_id);
1761: l_message := fnd_message.get;
1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;
1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1766: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1767: l_message := l_message||' - '||fnd_message.get;

Line 1764: l_message := l_message||' - '||fnd_message.get;

1760: fnd_message.set_token ('ID', v_pn_lease_id);
1761: l_message := fnd_message.get;
1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;
1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1766: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1767: l_message := l_message||' - '||fnd_message.get;
1768: pnp_debug_pkg.put_log_msg(l_message);

Line 1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');

1761: l_message := fnd_message.get;
1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;
1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1766: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1767: l_message := l_message||' - '||fnd_message.get;
1768: pnp_debug_pkg.put_log_msg(l_message);
1769: pnp_debug_pkg.put_log_msg('

Line 1766: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));

1762: fnd_message.set_name ('PN','PN_ITEM_ID');
1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;
1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1766: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1767: l_message := l_message||' - '||fnd_message.get;
1768: pnp_debug_pkg.put_log_msg(l_message);
1769: pnp_debug_pkg.put_log_msg('
1770: ================================================================================');

Line 1767: l_message := l_message||' - '||fnd_message.get;

1763: fnd_message.set_token ('ID', v_pn_payment_item_id);
1764: l_message := l_message||' - '||fnd_message.get;
1765: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1766: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1767: l_message := l_message||' - '||fnd_message.get;
1768: pnp_debug_pkg.put_log_msg(l_message);
1769: pnp_debug_pkg.put_log_msg('
1770: ================================================================================');
1771:

Line 1783: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');

1779: := PNP_UTIL_FUNC.check_conversion_type
1780: ( l_func_curr_code
1781: ,pn_mo_cache_utils.get_current_org_id);
1782:
1783: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1784: fnd_message.set_token ('CT', l_conv_rate_type);
1785: pnp_debug_pkg.put_log_msg(fnd_message.get);
1786:
1787: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');

Line 1784: fnd_message.set_token ('CT', l_conv_rate_type);

1780: ( l_func_curr_code
1781: ,pn_mo_cache_utils.get_current_org_id);
1782:
1783: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1784: fnd_message.set_token ('CT', l_conv_rate_type);
1785: pnp_debug_pkg.put_log_msg(fnd_message.get);
1786:
1787: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1788: fnd_message.set_token ('CR', v_pn_rate);

Line 1785: pnp_debug_pkg.put_log_msg(fnd_message.get);

1781: ,pn_mo_cache_utils.get_current_org_id);
1782:
1783: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1784: fnd_message.set_token ('CT', l_conv_rate_type);
1785: pnp_debug_pkg.put_log_msg(fnd_message.get);
1786:
1787: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1788: fnd_message.set_token ('CR', v_pn_rate);
1789: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1787: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');

1783: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1784: fnd_message.set_token ('CT', l_conv_rate_type);
1785: pnp_debug_pkg.put_log_msg(fnd_message.get);
1786:
1787: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1788: fnd_message.set_token ('CR', v_pn_rate);
1789: pnp_debug_pkg.put_log_msg(fnd_message.get);
1790:
1791:

Line 1788: fnd_message.set_token ('CR', v_pn_rate);

1784: fnd_message.set_token ('CT', l_conv_rate_type);
1785: pnp_debug_pkg.put_log_msg(fnd_message.get);
1786:
1787: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1788: fnd_message.set_token ('CR', v_pn_rate);
1789: pnp_debug_pkg.put_log_msg(fnd_message.get);
1790:
1791:
1792: /* if the accounted amount is null, then, GET IT!

Line 1789: pnp_debug_pkg.put_log_msg(fnd_message.get);

1785: pnp_debug_pkg.put_log_msg(fnd_message.get);
1786:
1787: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1788: fnd_message.set_token ('CR', v_pn_rate);
1789: pnp_debug_pkg.put_log_msg(fnd_message.get);
1790:
1791:
1792: /* if the accounted amount is null, then, GET IT!
1793: Ensure we populate accounted_CR/DR in the AE Lines */

Line 1828: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');

1824: l_period_name := v_pn_period_name;
1825: END IF;
1826: CLOSE c_valid_period;
1827:
1828: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1829: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1830: pnp_debug_pkg.put_log_msg(fnd_message.get);
1831:
1832: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');

Line 1829: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));

1825: END IF;
1826: CLOSE c_valid_period;
1827:
1828: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1829: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1830: pnp_debug_pkg.put_log_msg(fnd_message.get);
1831:
1832: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1833: fnd_message.set_token ('PERIOD', l_period_name);

Line 1830: pnp_debug_pkg.put_log_msg(fnd_message.get);

1826: CLOSE c_valid_period;
1827:
1828: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1829: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1830: pnp_debug_pkg.put_log_msg(fnd_message.get);
1831:
1832: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1833: fnd_message.set_token ('PERIOD', l_period_name);
1834: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1832: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');

1828: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1829: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1830: pnp_debug_pkg.put_log_msg(fnd_message.get);
1831:
1832: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1833: fnd_message.set_token ('PERIOD', l_period_name);
1834: pnp_debug_pkg.put_log_msg(fnd_message.get);
1835:
1836: /* if pay term changed, re init, create accounting EVENT */

Line 1833: fnd_message.set_token ('PERIOD', l_period_name);

1829: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1830: pnp_debug_pkg.put_log_msg(fnd_message.get);
1831:
1832: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1833: fnd_message.set_token ('PERIOD', l_period_name);
1834: pnp_debug_pkg.put_log_msg(fnd_message.get);
1835:
1836: /* if pay term changed, re init, create accounting EVENT */
1837: IF l_term_id <> v_pn_payment_term_id THEN

Line 1834: pnp_debug_pkg.put_log_msg(fnd_message.get);

1830: pnp_debug_pkg.put_log_msg(fnd_message.get);
1831:
1832: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1833: fnd_message.set_token ('PERIOD', l_period_name);
1834: pnp_debug_pkg.put_log_msg(fnd_message.get);
1835:
1836: /* if pay term changed, re init, create accounting EVENT */
1837: IF l_term_id <> v_pn_payment_term_id THEN
1838:

Line 1999: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');

1995: l_diff_acc_amt := l_total_rev_acc_amt - l_item_accounted_amt;
1996: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
1997: END IF;
1998:
1999: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
2000: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2001: pnp_debug_pkg.put_log_msg(fnd_message.get);
2002:
2003: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');

Line 2000: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));

1996: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
1997: END IF;
1998:
1999: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
2000: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2001: pnp_debug_pkg.put_log_msg(fnd_message.get);
2002:
2003: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
2004: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

Line 2001: pnp_debug_pkg.put_log_msg(fnd_message.get);

1997: END IF;
1998:
1999: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
2000: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2001: pnp_debug_pkg.put_log_msg(fnd_message.get);
2002:
2003: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
2004: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2005: p_application_id => 101,

Line 2003: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');

1999: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
2000: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2001: pnp_debug_pkg.put_log_msg(fnd_message.get);
2002:
2003: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
2004: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2005: p_application_id => 101,
2006: p_id_flex_code => 'GL#',
2007: p_id_flex_num => l_chart_of_id,

Line 2004: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

2000: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2001: pnp_debug_pkg.put_log_msg(fnd_message.get);
2002:
2003: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
2004: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2005: p_application_id => 101,
2006: p_id_flex_code => 'GL#',
2007: p_id_flex_num => l_chart_of_id,
2008: p_qualifier => 'ALL',

Line 2010: pnp_debug_pkg.put_log_msg(fnd_message.get);

2006: p_id_flex_code => 'GL#',
2007: p_id_flex_num => l_chart_of_id,
2008: p_qualifier => 'ALL',
2009: p_ccid => rev_acnt_tab(i).account_id));
2010: pnp_debug_pkg.put_log_msg(fnd_message.get);
2011:
2012: pnp_debug_pkg.log('Inserting into lines for Revenue');
2013:
2014: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873

Line 2113: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');

2109: l_diff_acc_amt := l_total_rev_acc_amt - l_item_accounted_amt;
2110: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2111: END IF;
2112:
2113: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
2114: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2115: pnp_debug_pkg.put_log_msg(fnd_message.get);
2116:
2117: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');

Line 2114: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));

2110: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2111: END IF;
2112:
2113: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
2114: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2115: pnp_debug_pkg.put_log_msg(fnd_message.get);
2116:
2117: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
2118: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

Line 2115: pnp_debug_pkg.put_log_msg(fnd_message.get);

2111: END IF;
2112:
2113: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
2114: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2115: pnp_debug_pkg.put_log_msg(fnd_message.get);
2116:
2117: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
2118: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2119: p_application_id => 101,

Line 2117: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');

2113: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
2114: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2115: pnp_debug_pkg.put_log_msg(fnd_message.get);
2116:
2117: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
2118: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2119: p_application_id => 101,
2120: p_id_flex_code => 'GL#',
2121: p_id_flex_num => l_chart_of_id,

Line 2118: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

2114: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2115: pnp_debug_pkg.put_log_msg(fnd_message.get);
2116:
2117: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
2118: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2119: p_application_id => 101,
2120: p_id_flex_code => 'GL#',
2121: p_id_flex_num => l_chart_of_id,
2122: p_qualifier => 'ALL',

Line 2124: pnp_debug_pkg.put_log_msg(fnd_message.get);

2120: p_id_flex_code => 'GL#',
2121: p_id_flex_num => l_chart_of_id,
2122: p_qualifier => 'ALL',
2123: p_ccid => acc_acnt_tab(i).account_id));
2124: pnp_debug_pkg.put_log_msg(fnd_message.get);
2125:
2126: pnp_debug_pkg.log('Inserting into lines for Accrued Asset');
2127: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2128:

Line 2237: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');

2233: CLOSE c_term;
2234:
2235: pnp_debug_pkg.put_log_msg('
2236: ================================================================================');
2237: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
2238: fnd_message.set_token ('NUM', to_char(s_count));
2239: pnp_debug_pkg.put_log_msg(fnd_message.get);
2240: pnp_debug_pkg.put_log_msg('
2241: ================================================================================');

Line 2238: fnd_message.set_token ('NUM', to_char(s_count));

2234:
2235: pnp_debug_pkg.put_log_msg('
2236: ================================================================================');
2237: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
2238: fnd_message.set_token ('NUM', to_char(s_count));
2239: pnp_debug_pkg.put_log_msg(fnd_message.get);
2240: pnp_debug_pkg.put_log_msg('
2241: ================================================================================');
2242:

Line 2239: pnp_debug_pkg.put_log_msg(fnd_message.get);

2235: pnp_debug_pkg.put_log_msg('
2236: ================================================================================');
2237: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
2238: fnd_message.set_token ('NUM', to_char(s_count));
2239: pnp_debug_pkg.put_log_msg(fnd_message.get);
2240: pnp_debug_pkg.put_log_msg('
2241: ================================================================================');
2242:
2243: END CREATE_AR_ACC;

Line 2500: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');

2496: OPEN get_send_flag(v_pn_lease_id);
2497: FETCH get_send_flag INTO l_send_flag;
2498: CLOSE get_send_flag;
2499: l_lease_id := v_pn_lease_id;
2500: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2501: fnd_message.set_token ('NUM', l_lease_id);
2502: fnd_message.set_token ('FLAG', l_send_flag);
2503: pnp_debug_pkg.put_log_msg(fnd_message.get);
2504:

Line 2501: fnd_message.set_token ('NUM', l_lease_id);

2497: FETCH get_send_flag INTO l_send_flag;
2498: CLOSE get_send_flag;
2499: l_lease_id := v_pn_lease_id;
2500: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2501: fnd_message.set_token ('NUM', l_lease_id);
2502: fnd_message.set_token ('FLAG', l_send_flag);
2503: pnp_debug_pkg.put_log_msg(fnd_message.get);
2504:
2505: END IF;

Line 2502: fnd_message.set_token ('FLAG', l_send_flag);

2498: CLOSE get_send_flag;
2499: l_lease_id := v_pn_lease_id;
2500: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2501: fnd_message.set_token ('NUM', l_lease_id);
2502: fnd_message.set_token ('FLAG', l_send_flag);
2503: pnp_debug_pkg.put_log_msg(fnd_message.get);
2504:
2505: END IF;
2506:

Line 2503: pnp_debug_pkg.put_log_msg(fnd_message.get);

2499: l_lease_id := v_pn_lease_id;
2500: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2501: fnd_message.set_token ('NUM', l_lease_id);
2502: fnd_message.set_token ('FLAG', l_send_flag);
2503: pnp_debug_pkg.put_log_msg(fnd_message.get);
2504:
2505: END IF;
2506:
2507: /* Do processing only if send_flag is Yes */

Line 2513: fnd_message.set_name ('PN','PN_LEASE_ID');

2509:
2510:
2511: pnp_debug_pkg.put_log_msg('
2512: ================================================================================');
2513: fnd_message.set_name ('PN','PN_LEASE_ID');
2514: fnd_message.set_token ('ID', v_pn_lease_id);
2515: l_message := fnd_message.get;
2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);

Line 2514: fnd_message.set_token ('ID', v_pn_lease_id);

2510:
2511: pnp_debug_pkg.put_log_msg('
2512: ================================================================================');
2513: fnd_message.set_name ('PN','PN_LEASE_ID');
2514: fnd_message.set_token ('ID', v_pn_lease_id);
2515: l_message := fnd_message.get;
2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;

Line 2515: l_message := fnd_message.get;

2511: pnp_debug_pkg.put_log_msg('
2512: ================================================================================');
2513: fnd_message.set_name ('PN','PN_LEASE_ID');
2514: fnd_message.set_token ('ID', v_pn_lease_id);
2515: l_message := fnd_message.get;
2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;
2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');

Line 2516: fnd_message.set_name ('PN','PN_ITEM_ID');

2512: ================================================================================');
2513: fnd_message.set_name ('PN','PN_LEASE_ID');
2514: fnd_message.set_token ('ID', v_pn_lease_id);
2515: l_message := fnd_message.get;
2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;
2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2520: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));

Line 2517: fnd_message.set_token ('ID', v_pn_payment_item_id);

2513: fnd_message.set_name ('PN','PN_LEASE_ID');
2514: fnd_message.set_token ('ID', v_pn_lease_id);
2515: l_message := fnd_message.get;
2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;
2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2520: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2521: l_message := l_message||' - '||fnd_message.get;

Line 2518: l_message := l_message||' - '||fnd_message.get;

2514: fnd_message.set_token ('ID', v_pn_lease_id);
2515: l_message := fnd_message.get;
2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;
2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2520: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2521: l_message := l_message||' - '||fnd_message.get;
2522: pnp_debug_pkg.put_log_msg(l_message);

Line 2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');

2515: l_message := fnd_message.get;
2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;
2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2520: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2521: l_message := l_message||' - '||fnd_message.get;
2522: pnp_debug_pkg.put_log_msg(l_message);
2523: pnp_debug_pkg.put_log_msg('

Line 2520: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));

2516: fnd_message.set_name ('PN','PN_ITEM_ID');
2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;
2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2520: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2521: l_message := l_message||' - '||fnd_message.get;
2522: pnp_debug_pkg.put_log_msg(l_message);
2523: pnp_debug_pkg.put_log_msg('
2524: ================================================================================');

Line 2521: l_message := l_message||' - '||fnd_message.get;

2517: fnd_message.set_token ('ID', v_pn_payment_item_id);
2518: l_message := l_message||' - '||fnd_message.get;
2519: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2520: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2521: l_message := l_message||' - '||fnd_message.get;
2522: pnp_debug_pkg.put_log_msg(l_message);
2523: pnp_debug_pkg.put_log_msg('
2524: ================================================================================');
2525:

Line 2537: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');

2533: := PNP_UTIL_FUNC.check_conversion_type
2534: ( l_func_curr_code
2535: ,pn_mo_cache_utils.get_current_org_id);
2536:
2537: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2538: fnd_message.set_token ('CT', l_conv_rate_type);
2539: pnp_debug_pkg.put_log_msg(fnd_message.get);
2540:
2541:

Line 2538: fnd_message.set_token ('CT', l_conv_rate_type);

2534: ( l_func_curr_code
2535: ,pn_mo_cache_utils.get_current_org_id);
2536:
2537: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2538: fnd_message.set_token ('CT', l_conv_rate_type);
2539: pnp_debug_pkg.put_log_msg(fnd_message.get);
2540:
2541:
2542: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');

Line 2539: pnp_debug_pkg.put_log_msg(fnd_message.get);

2535: ,pn_mo_cache_utils.get_current_org_id);
2536:
2537: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2538: fnd_message.set_token ('CT', l_conv_rate_type);
2539: pnp_debug_pkg.put_log_msg(fnd_message.get);
2540:
2541:
2542: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2543: fnd_message.set_token ('CR', v_pn_rate);

Line 2542: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');

2538: fnd_message.set_token ('CT', l_conv_rate_type);
2539: pnp_debug_pkg.put_log_msg(fnd_message.get);
2540:
2541:
2542: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2543: fnd_message.set_token ('CR', v_pn_rate);
2544: pnp_debug_pkg.put_log_msg(fnd_message.get);
2545:
2546:

Line 2543: fnd_message.set_token ('CR', v_pn_rate);

2539: pnp_debug_pkg.put_log_msg(fnd_message.get);
2540:
2541:
2542: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2543: fnd_message.set_token ('CR', v_pn_rate);
2544: pnp_debug_pkg.put_log_msg(fnd_message.get);
2545:
2546:
2547: /* if the accounted amount is null, then, GET IT!

Line 2544: pnp_debug_pkg.put_log_msg(fnd_message.get);

2540:
2541:
2542: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2543: fnd_message.set_token ('CR', v_pn_rate);
2544: pnp_debug_pkg.put_log_msg(fnd_message.get);
2545:
2546:
2547: /* if the accounted amount is null, then, GET IT!
2548: Ensure we populate accounted_CR/DR in the AE Lines */

Line 2583: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');

2579: CLOSE C_VALID_PERIOD;
2580:
2581:
2582:
2583: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2584: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2585: pnp_debug_pkg.put_log_msg(fnd_message.get);
2586:
2587: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');

Line 2584: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));

2580:
2581:
2582:
2583: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2584: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2585: pnp_debug_pkg.put_log_msg(fnd_message.get);
2586:
2587: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2588: fnd_message.set_token ('PERIOD', l_period_name);

Line 2585: pnp_debug_pkg.put_log_msg(fnd_message.get);

2581:
2582:
2583: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2584: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2585: pnp_debug_pkg.put_log_msg(fnd_message.get);
2586:
2587: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2588: fnd_message.set_token ('PERIOD', l_period_name);
2589: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2587: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');

2583: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2584: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2585: pnp_debug_pkg.put_log_msg(fnd_message.get);
2586:
2587: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2588: fnd_message.set_token ('PERIOD', l_period_name);
2589: pnp_debug_pkg.put_log_msg(fnd_message.get);
2590:
2591: IF l_term_id <> v_pn_payment_term_id THEN

Line 2588: fnd_message.set_token ('PERIOD', l_period_name);

2584: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2585: pnp_debug_pkg.put_log_msg(fnd_message.get);
2586:
2587: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2588: fnd_message.set_token ('PERIOD', l_period_name);
2589: pnp_debug_pkg.put_log_msg(fnd_message.get);
2590:
2591: IF l_term_id <> v_pn_payment_term_id THEN
2592:

Line 2589: pnp_debug_pkg.put_log_msg(fnd_message.get);

2585: pnp_debug_pkg.put_log_msg(fnd_message.get);
2586:
2587: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2588: fnd_message.set_token ('PERIOD', l_period_name);
2589: pnp_debug_pkg.put_log_msg(fnd_message.get);
2590:
2591: IF l_term_id <> v_pn_payment_term_id THEN
2592:
2593: l_term_id := v_pn_payment_term_id ;

Line 2758: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');

2754: l_diff_acc_amt := l_total_exp_acc_amt - l_item_accounted_amt;
2755: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2756: END IF;
2757:
2758: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2759: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2760: pnp_debug_pkg.put_log_msg(fnd_message.get);
2761:
2762: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');

Line 2759: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));

2755: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2756: END IF;
2757:
2758: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2759: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2760: pnp_debug_pkg.put_log_msg(fnd_message.get);
2761:
2762: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2763: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

Line 2760: pnp_debug_pkg.put_log_msg(fnd_message.get);

2756: END IF;
2757:
2758: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2759: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2760: pnp_debug_pkg.put_log_msg(fnd_message.get);
2761:
2762: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2763: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2764: p_application_id => 101,

Line 2762: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');

2758: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2759: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2760: pnp_debug_pkg.put_log_msg(fnd_message.get);
2761:
2762: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2763: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2764: p_application_id => 101,
2765: p_id_flex_code => 'GL#',
2766: p_id_flex_num => l_chart_of_id,

Line 2763: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

2759: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2760: pnp_debug_pkg.put_log_msg(fnd_message.get);
2761:
2762: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2763: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2764: p_application_id => 101,
2765: p_id_flex_code => 'GL#',
2766: p_id_flex_num => l_chart_of_id,
2767: p_qualifier => 'ALL',

Line 2770: pnp_debug_pkg.put_log_msg(fnd_message.get);

2766: p_id_flex_num => l_chart_of_id,
2767: p_qualifier => 'ALL',
2768: p_ccid => exp_acnt_tab(i).account_id));
2769:
2770: pnp_debug_pkg.put_log_msg(fnd_message.get);
2771:
2772: pnp_debug_pkg.log('Inserting into lines for Expense');
2773:
2774: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873

Line 2872: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');

2868: l_diff_acc_amt := l_total_exp_acc_amt - l_item_accounted_amt;
2869: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2870: END IF;
2871:
2872: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2873: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2874: pnp_debug_pkg.put_log_msg(fnd_message.get);
2875:
2876: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');

Line 2873: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));

2869: l_accounted_amt := l_accounted_amt - l_diff_acc_amt;
2870: END IF;
2871:
2872: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2873: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2874: pnp_debug_pkg.put_log_msg(fnd_message.get);
2875:
2876: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2877: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

Line 2874: pnp_debug_pkg.put_log_msg(fnd_message.get);

2870: END IF;
2871:
2872: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2873: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2874: pnp_debug_pkg.put_log_msg(fnd_message.get);
2875:
2876: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2877: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2878: p_application_id => 101,

Line 2876: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');

2872: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2873: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2874: pnp_debug_pkg.put_log_msg(fnd_message.get);
2875:
2876: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2877: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2878: p_application_id => 101,
2879: p_id_flex_code => 'GL#',
2880: p_id_flex_num => l_chart_of_id,

Line 2877: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(

2873: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2874: pnp_debug_pkg.put_log_msg(fnd_message.get);
2875:
2876: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2877: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2878: p_application_id => 101,
2879: p_id_flex_code => 'GL#',
2880: p_id_flex_num => l_chart_of_id,
2881: p_qualifier => 'ALL',

Line 2884: pnp_debug_pkg.put_log_msg(fnd_message.get);

2880: p_id_flex_num => l_chart_of_id,
2881: p_qualifier => 'ALL',
2882: p_ccid => acc_acnt_tab(i).account_id));
2883:
2884: pnp_debug_pkg.put_log_msg(fnd_message.get);
2885:
2886: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');
2887: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2888:

Line 2997: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');

2993: CLOSE c_term;
2994:
2995: pnp_debug_pkg.put_log_msg('
2996: ================================================================================');
2997: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2998: fnd_message.set_token ('NUM', to_char(s_count));
2999: pnp_debug_pkg.put_log_msg(fnd_message.get);
3000: pnp_debug_pkg.put_log_msg('
3001: ================================================================================');

Line 2998: fnd_message.set_token ('NUM', to_char(s_count));

2994:
2995: pnp_debug_pkg.put_log_msg('
2996: ================================================================================');
2997: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2998: fnd_message.set_token ('NUM', to_char(s_count));
2999: pnp_debug_pkg.put_log_msg(fnd_message.get);
3000: pnp_debug_pkg.put_log_msg('
3001: ================================================================================');
3002: END CREATE_AP_ACC;

Line 2999: pnp_debug_pkg.put_log_msg(fnd_message.get);

2995: pnp_debug_pkg.put_log_msg('
2996: ================================================================================');
2997: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2998: fnd_message.set_token ('NUM', to_char(s_count));
2999: pnp_debug_pkg.put_log_msg(fnd_message.get);
3000: pnp_debug_pkg.put_log_msg('
3001: ================================================================================');
3002: END CREATE_AP_ACC;
3003: