eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_CREATE_ACC dependencies on PNP_DEBUG_PKG

Line 219: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (+)');

215: AND period_set_name = l_period_set_name
216: AND period_type = l_user_period_type
217: AND NVL(ADJUSTMENT_PERIOD_FLAG, 'N') = 'N';
218: BEGIN
219: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (+)');
220: l_ledger_id := p_ledger_id;
221: IF l_ledger_id IS NULL
222: THEN
223: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

Line 226: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info l_ledger_id ' || l_ledger_id);

222: THEN
223: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
224: END IF;
225:
226: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info l_ledger_id ' || l_ledger_id);
227:
228: OPEN prd_set_csr(l_ledger_id);
229: FETCH prd_set_csr INTO l_period_set_name, l_user_period_type;
230: CLOSE prd_set_csr;

Line 235: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (-)');

231:
232: OPEN prd_name_csr (l_period_set_name, l_user_period_type);
233: FETCH prd_name_csr INTO p_period_name, p_start_date, p_end_date;
234: CLOSE prd_name_csr;
235: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (-)');
236:
237: EXCEPTION
238: WHEN OTHERS THEN
239: NULL;

Line 261: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (+)');

257: AND ledger_id = l_ledger_id
258: AND period_name = p_period_name;
259:
260: BEGIN
261: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (+)');
262: l_ledger_id := p_ledger_id;
263: IF l_ledger_id IS NULL
264: THEN
265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

Line 268: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status p_period_name '|| p_period_name);

264: THEN
265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
266: END IF;
267:
268: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status p_period_name '|| p_period_name);
269: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_ledger_id '|| l_ledger_id);
270:
271: OPEN sts_csr (l_ledger_id);
272: FETCH sts_csr INTO l_period_status;

Line 269: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_ledger_id '|| l_ledger_id);

265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
266: END IF;
267:
268: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status p_period_name '|| p_period_name);
269: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_ledger_id '|| l_ledger_id);
270:
271: OPEN sts_csr (l_ledger_id);
272: FETCH sts_csr INTO l_period_status;
273: CLOSE sts_csr;

Line 275: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_period_status '|| l_period_status);

271: OPEN sts_csr (l_ledger_id);
272: FETCH sts_csr INTO l_period_status;
273: CLOSE sts_csr;
274:
275: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_period_status '|| l_period_status);
276: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (-)');
277: RETURN l_period_status;
278:
279: EXCEPTION

Line 276: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (-)');

272: FETCH sts_csr INTO l_period_status;
273: CLOSE sts_csr;
274:
275: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_period_status '|| l_period_status);
276: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (-)');
277: RETURN l_period_status;
278:
279: EXCEPTION
280: WHEN OTHERS THEN

Line 324: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date (+)');

320: l_period_status gl_period_statuses.closing_status%TYPE;
321: l_ledger_id NUMBER;
322:
323: BEGIN
324: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date (+)');
325: l_ledger_id := p_ledger_id;
326: IF l_ledger_id IS NULL
327: THEN
328: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

Line 349: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date Returuning Null(-)');

345: FETCH aft_csr INTO l_dummy_date;
346: CLOSE aft_csr;
347:
348: IF (l_dummy_date IS NULL) THEN
349: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date Returuning Null(-)');
350: RETURN NULL;
351: END IF;
352:
353: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date l_dummy_date '|| l_dummy_date);

Line 353: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date l_dummy_date '|| l_dummy_date);

349: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date Returuning Null(-)');
350: RETURN NULL;
351: END IF;
352:
353: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date l_dummy_date '|| l_dummy_date);
354: RETURN l_dummy_date;
355:
356: END get_valid_gl_date;
357:

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 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 480: pnp_debug_pkg.log('Inserting into lines for Expense');

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:
483: INSERT INTO pn_payment_item_dist_all(payment_item_id,
484: code_combination_id,

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 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 561: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');

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:
564:
565: l_acc_number := l_acc_number +1;

Line 598: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');

594: FND_GLOBAL.prog_appl_id,
595: FND_GLOBAL.conc_program_id,
596: FND_GLOBAL.conc_request_id);
597:
598: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');
599:
600: END LOOP;
601:
602: END distribute_amount;

Line 659: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (+)');

655: l_success NUMBER;
656:
657: BEGIN
658:
659: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (+)');
660:
661: IF P_START_DATE IS NULL THEN
662: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
663: ELSE

Line 727: pnp_debug_pkg.log('Before cursor c_term open');

723: WHERE payment_term_id = term_ID_tbl(i);
724:
725: END IF;
726:
727: pnp_debug_pkg.log('Before cursor c_term open');
728:
729: item_id_tbl.DELETE;
730: schedule_id_tbl.DELETE;
731: event_id_tbl.DELETE;

Line 753: pnp_debug_pkg.log('acct_rec.due_date '|| acct_rec.due_date);

749:
750: BEGIN
751:
752: l_due_date := NULL;
753: pnp_debug_pkg.log('acct_rec.due_date '|| acct_rec.due_date);
754: l_due_date := get_valid_gl_date(acct_rec.due_date); -- Added for bug#9712825
755: pnp_debug_pkg.log('l_due_date '|| l_due_date);
756:
757: IF l_due_date IS NULL THEN

Line 755: pnp_debug_pkg.log('l_due_date '|| l_due_date);

751:
752: l_due_date := NULL;
753: pnp_debug_pkg.log('acct_rec.due_date '|| acct_rec.due_date);
754: l_due_date := get_valid_gl_date(acct_rec.due_date); -- Added for bug#9712825
755: pnp_debug_pkg.log('l_due_date '|| l_due_date);
756:
757: IF l_due_date IS NULL THEN
758:
759: pnp_debug_pkg.log('payment_item_id ' || acct_rec.payment_item_id || ' is skipped as current or future GL Period is not open for : ' || acct_rec.due_date);

Line 759: pnp_debug_pkg.log('payment_item_id ' || acct_rec.payment_item_id || ' is skipped as current or future GL Period is not open for : ' || acct_rec.due_date);

755: pnp_debug_pkg.log('l_due_date '|| l_due_date);
756:
757: IF l_due_date IS NULL THEN
758:
759: pnp_debug_pkg.log('payment_item_id ' || acct_rec.payment_item_id || ' is skipped as current or future GL Period is not open for : ' || acct_rec.due_date);
760:
761: ELSE
762:
763: pn_xla_event_pkg.create_xla_event(

Line 798: pnp_debug_pkg.log('Updating payment items');

794: l_success := l_success + 1;
795:
796: IF l_index_item > 1000 THEN
797:
798: pnp_debug_pkg.log('Updating payment items');
799:
800: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
801: UPDATE pn_payment_items_all
802: SET transferred_to_ap_flag = 'Y',

Line 809: pnp_debug_pkg.log('Updating Payment schedules ');

805: last_update_login = l_last_update_login,
806: last_update_date = l_last_update_date
807: WHERE payment_item_id = item_id_tbl(i);
808:
809: pnp_debug_pkg.log('Updating Payment schedules ');
810:
811: IF schedule_id_tbl.COUNT > 0 THEN
812:
813: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

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 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 851: pnp_debug_pkg.log('Updating remaining payment items');

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');
852:
853: IF item_id_tbl.COUNT > 0 THEN
854:
855: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST

Line 866: pnp_debug_pkg.log('Updating remaining Payment schedules');

862: WHERE payment_item_id = item_id_tbl(i);
863:
864: END IF;
865:
866: pnp_debug_pkg.log('Updating remaining Payment schedules');
867:
868: IF schedule_id_tbl.COUNT > 0 THEN
869:
870: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

Line 881: pnp_debug_pkg.put_log_msg('

877: WHERE Payment_Schedule_Id = schedule_id_tbl(i);
878:
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);

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 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 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 895: pnp_debug_pkg.put_log_msg('

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:
898: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (-)');
899:

Line 898: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (-)');

894:
895: pnp_debug_pkg.put_log_msg('
896: ================================================================================');
897:
898: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (-)');
899:
900: END CREATE_AP_ACC_R12;
901:
902: -------------------------------------------------------------------------------

Line 958: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (+)');

954: l_success NUMBER;
955:
956: BEGIN
957:
958: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (+)');
959:
960: IF P_START_DATE IS NULL THEN
961: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
962: ELSE

Line 1021: pnp_debug_pkg.log('Before cursor c_term open');

1017: WHERE payment_term_id = term_ID_tbl(i);
1018:
1019: END IF;
1020:
1021: pnp_debug_pkg.log('Before cursor c_term open');
1022:
1023: item_id_tbl.DELETE;
1024: schedule_id_tbl.DELETE;
1025: event_id_tbl.DELETE;

Line 1045: pnp_debug_pkg.log('acct_rec.due_date '|| acct_rec.due_date);

1041: p_customer_id => p_customer_id)
1042: LOOP
1043: BEGIN
1044: l_due_date := NULL;
1045: pnp_debug_pkg.log('acct_rec.due_date '|| acct_rec.due_date);
1046: l_due_date := get_valid_gl_date(acct_rec.due_date); -- Added for bug#9712825
1047: pnp_debug_pkg.log('l_due_date '|| l_due_date);
1048:
1049: IF l_due_date IS NULL THEN

Line 1047: pnp_debug_pkg.log('l_due_date '|| l_due_date);

1043: BEGIN
1044: l_due_date := NULL;
1045: pnp_debug_pkg.log('acct_rec.due_date '|| acct_rec.due_date);
1046: l_due_date := get_valid_gl_date(acct_rec.due_date); -- Added for bug#9712825
1047: pnp_debug_pkg.log('l_due_date '|| l_due_date);
1048:
1049: IF l_due_date IS NULL THEN
1050: pnp_debug_pkg.log('payment_item_id ' || acct_rec.payment_item_id || ' is skipped as current or future GL Period is not open for : ' || acct_rec.due_date);
1051:

Line 1050: pnp_debug_pkg.log('payment_item_id ' || acct_rec.payment_item_id || ' is skipped as current or future GL Period is not open for : ' || acct_rec.due_date);

1046: l_due_date := get_valid_gl_date(acct_rec.due_date); -- Added for bug#9712825
1047: pnp_debug_pkg.log('l_due_date '|| l_due_date);
1048:
1049: IF l_due_date IS NULL THEN
1050: pnp_debug_pkg.log('payment_item_id ' || acct_rec.payment_item_id || ' is skipped as current or future GL Period is not open for : ' || acct_rec.due_date);
1051:
1052: ELSE
1053:
1054:

Line 1090: pnp_debug_pkg.log('Updating payment items');

1086: l_success := l_success + 1;
1087:
1088: IF l_index_item = 1000 THEN
1089:
1090: pnp_debug_pkg.log('Updating payment items');
1091:
1092: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
1093: UPDATE pn_payment_items_all
1094: SET transferred_to_ar_flag = 'Y' ,

Line 1101: pnp_debug_pkg.log('Updating Payment schedules');

1097: last_update_login = l_last_update_login,
1098: last_update_date = l_last_update_date
1099: WHERE payment_item_id = item_id_tbl(i);
1100:
1101: pnp_debug_pkg.log('Updating Payment schedules');
1102:
1103: IF schedule_id_tbl.COUNT > 0 THEN
1104:
1105: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

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 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 1143: pnp_debug_pkg.log('Updating remaining payment items');

1139:
1140: END;
1141: END LOOP;
1142:
1143: pnp_debug_pkg.log('Updating remaining payment items');
1144:
1145: IF item_id_tbl.COUNT > 0 THEN
1146:
1147: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST

Line 1158: pnp_debug_pkg.log('Updating remaining Payment schedules');

1154: WHERE payment_item_id = item_id_tbl(i);
1155:
1156: END IF;
1157:
1158: pnp_debug_pkg.log('Updating remaining Payment schedules');
1159:
1160: IF schedule_id_tbl.COUNT > 0 THEN
1161:
1162: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

Line 1173: pnp_debug_pkg.put_log_msg('

1169: WHERE Payment_Schedule_Id = schedule_id_tbl(i);
1170:
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);

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 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 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 1187: pnp_debug_pkg.put_log_msg('

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:
1190: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (-)');
1191:

Line 1190: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (-)');

1186:
1187: pnp_debug_pkg.put_log_msg('
1188: ================================================================================');
1189:
1190: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (-)');
1191:
1192: END CREATE_AR_ACC_R12;
1193:
1194: -------------------------------------------------------------------------------

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 1287: pnp_debug_pkg.log('Default GL period Name = '|| p_default_period);

1283: END IF;
1284: CLOSE c_default_gl_period;
1285: END IF;
1286:
1287: pnp_debug_pkg.log('Default GL period Name = '|| p_default_period);
1288:
1289: IF p_journal_category ='PM REVENUE' THEN
1290:
1291: IF pn_r12_util_pkg.is_r12 THEN

Line 1403: pnp_debug_pkg.log('From Date to xla Procedure = '||To_char(l_from_date,'MM/DD/YYYY'));

1399: OPEN c_min_max_date ;
1400: FETCH c_min_max_date INTO l_from_date ,l_to_date;
1401: CLOSE c_min_max_date;
1402:
1403: pnp_debug_pkg.log('From Date to xla Procedure = '||To_char(l_from_date,'MM/DD/YYYY'));
1404: pnp_debug_pkg.log('To Date to xla Procedure = '||To_char(l_to_date,'MM/DD/YYYY'));
1405:
1406: /* Call GL transfer only for valied date range */
1407:

Line 1404: pnp_debug_pkg.log('To Date to xla Procedure = '||To_char(l_to_date,'MM/DD/YYYY'));

1400: FETCH c_min_max_date INTO l_from_date ,l_to_date;
1401: CLOSE c_min_max_date;
1402:
1403: pnp_debug_pkg.log('From Date to xla Procedure = '||To_char(l_from_date,'MM/DD/YYYY'));
1404: pnp_debug_pkg.log('To Date to xla Procedure = '||To_char(l_to_date,'MM/DD/YYYY'));
1405:
1406: /* Call GL transfer only for valied date range */
1407:
1408: IF NOT(l_from_date is null AND l_to_date is null) THEN

Line 1460: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (+)');

1456: l_accounted_amt NUMBER;
1457:
1458: BEGIN
1459:
1460: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (+)');
1461:
1462: IF p_conv_date > SYSDATE THEN
1463: l_conv_date := SYSDATE;
1464: ELSE

Line 1480: pnp_debug_pkg.log('Accounted Amount = '||l_accounted_amt);

1476: actual_amount => NVL(p_amount,0),
1477: p_called_from => 'NOTPNTAUPMT');
1478: END IF;
1479:
1480: pnp_debug_pkg.log('Accounted Amount = '||l_accounted_amt);
1481: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (-)');
1482:
1483: RETURN l_accounted_amt;
1484:

Line 1481: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (-)');

1477: p_called_from => 'NOTPNTAUPMT');
1478: END IF;
1479:
1480: pnp_debug_pkg.log('Accounted Amount = '||l_accounted_amt);
1481: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (-)');
1482:
1483: RETURN l_accounted_amt;
1484:
1485: EXCEPTION

Line 1686: pnp_debug_pkg.log('at start of the Procedure CREATE_AR_ACC');

1682: l_diff_acc_amt NUMBER;
1683:
1684: BEGIN
1685:
1686: pnp_debug_pkg.log('at start of the Procedure CREATE_AR_ACC');
1687:
1688: if p_start_date is null then
1689: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
1690: else

Line 1712: pnp_debug_pkg.log('Before cursor c_term open');

1708: else
1709: l_high_lease_id := p_high_lease_id;
1710: end if;
1711:
1712: pnp_debug_pkg.log('Before cursor c_term open');
1713:
1714: OPEN c_term ;
1715:
1716: LOOP

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 1757: pnp_debug_pkg.put_log_msg('

1753:
1754: /* Do processing only if send_flag is Yes */
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;

Line 1768: pnp_debug_pkg.put_log_msg(l_message);

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:
1772: /* Check for Conversion Type and Conversion Rate for Currency Code */

Line 1769: pnp_debug_pkg.put_log_msg('

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:
1772: /* Check for Conversion Type and Conversion Rate for Currency Code */
1773:

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 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 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 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 1866: pnp_debug_pkg.log('Before event insert');

1862: WHERE source_table = 'PN_PAYMENT_TERMS'
1863: AND SOURCE_ID = v_pn_payment_term_id
1864: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1865:
1866: pnp_debug_pkg.log('Before event insert');
1867:
1868: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
1869: (
1870: ACCOUNTING_EVENT_ID ,

Line 1913: pnp_debug_pkg.log('Before header insert');

1909: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
1910:
1911: END IF; /* if pay term changed, re init, create accounting EVENT */
1912:
1913: pnp_debug_pkg.log('Before header insert');
1914:
1915: OPEN c_lease_num(v_pn_lease_id);
1916: FETCH c_lease_num INTO v_pn_lease_num;
1917: CLOSE c_lease_num;

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 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 2012: pnp_debug_pkg.log('Inserting into lines for Revenue');

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
2015: l_rev_number := l_rev_number + 1;
2016:

Line 2078: pnp_debug_pkg.log('Inserted into lines for Revenue');

2074: FND_GLOBAL.conc_program_id,
2075: FND_GLOBAL.conc_request_id
2076: );
2077:
2078: pnp_debug_pkg.log('Inserted into lines for Revenue');
2079:
2080: END LOOP; /* for each REVENUE account, create AE line */
2081:
2082: l_amt := 0;

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 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 2126: pnp_debug_pkg.log('Inserting into lines for Accrued Asset');

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:
2129: l_unearn_number := l_unearn_number + 1;
2130:

Line 2191: pnp_debug_pkg.log('Inserted into lines for Accrued Asset');

2187: FND_GLOBAL.conc_program_id,
2188: FND_GLOBAL.conc_request_id
2189: );
2190:
2191: pnp_debug_pkg.log('Inserted into lines for Accrued Asset');
2192:
2193: END LOOP; /* for each UNEARN account, create AE line */
2194:
2195: l_context := 'Updating Payment Items';

Line 2196: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||

2192:
2193: END LOOP; /* for each UNEARN account, create AE line */
2194:
2195: l_context := 'Updating Payment Items';
2196: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2197: to_char(v_pn_payment_item_id) );
2198:
2199: UPDATE pn_payment_items_all
2200: SET transferred_to_ar_flag = 'Y' ,

Line 2214: pnp_debug_pkg.log('Updating billing schedules for billing sch id : ' ||

2210: AND v_cash_actual_amount = 0 ) THEN
2211:
2212: l_Prior_Payment_Schedule_Id := V_PN_Payment_Schedule_Id;
2213: l_context := 'Updating Payment Schedules';
2214: pnp_debug_pkg.log('Updating billing schedules for billing sch id : ' ||
2215: to_char(V_PN_Payment_Schedule_Id) );
2216:
2217: UPDATE PN_Payment_Schedules_all
2218: SET Transferred_By_User_Id = l_last_updated_by,

Line 2235: pnp_debug_pkg.put_log_msg('

2231: END LOOP;
2232:
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);

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 2240: 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;
2244:

Line 2440: pnp_debug_pkg.log('at start of the Procedure CREATE_AP_ACC');

2436: l_diff_acc_amt NUMBER;
2437:
2438: BEGIN
2439:
2440: pnp_debug_pkg.log('at start of the Procedure CREATE_AP_ACC');
2441:
2442: IF P_START_DATE IS NULL THEN
2443: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
2444: ELSE

Line 2466: pnp_debug_pkg.log('Before cursor c_term open');

2462: ELSE
2463: l_high_lease_id := p_high_lease_id;
2464: END IF;
2465:
2466: pnp_debug_pkg.log('Before cursor c_term open');
2467:
2468: OPEN C_TERM ;
2469: LOOP
2470:

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 2511: pnp_debug_pkg.put_log_msg('

2507: /* Do processing only if send_flag is Yes */
2508: IF (nvl(l_send_flag,'Y') = 'Y') THEN
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;

Line 2522: pnp_debug_pkg.put_log_msg(l_message);

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:
2526:

Line 2523: pnp_debug_pkg.put_log_msg('

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:
2526:
2527: /* Check for Conversion Type and Conversion Rate for Currency Code */

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 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 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 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 2620: pnp_debug_pkg.log('Before event insert');

2616: WHERE source_table = 'PN_PAYMENT_TERMS'
2617: AND SOURCE_ID = v_pn_payment_term_id
2618: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2619:
2620: pnp_debug_pkg.log('Before event insert');
2621:
2622:
2623: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2624:

Line 2671: pnp_debug_pkg.log('Before header insert');

2667: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
2668:
2669: END IF;
2670:
2671: pnp_debug_pkg.log('Before header insert');
2672:
2673:
2674: OPEN c_lease_num(v_pn_lease_id);
2675: FETCH c_lease_num INTO v_pn_lease_num;

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 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 2772: pnp_debug_pkg.log('Inserting into lines for Expense');

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
2775: l_exp_number := l_exp_number +1;
2776:

Line 2838: pnp_debug_pkg.log('Inserted into lines for Expense');

2834: FND_GLOBAL.conc_program_id,
2835: FND_GLOBAL.conc_request_id
2836: );
2837:
2838: pnp_debug_pkg.log('Inserted into lines for Expense');
2839:
2840: END LOOP;
2841:
2842: l_amt := 0;

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 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 2886: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');

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:
2889:
2890: l_acc_number := l_acc_number +1;

Line 2953: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');

2949: FND_GLOBAL.conc_program_id,
2950: FND_GLOBAL.conc_request_id
2951: );
2952:
2953: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');
2954:
2955: END LOOP;
2956:
2957: l_context := 'Updating Payment Items';

Line 2958: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||

2954:
2955: END LOOP;
2956:
2957: l_context := 'Updating Payment Items';
2958: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2959: to_char(v_pn_payment_item_id) );
2960:
2961: UPDATE pn_payment_items_all
2962: SET transferred_to_ap_flag = 'Y' ,

Line 2975: pnp_debug_pkg.log('Updating Payment schedules for Payment sch id : ' ||

2971: l_Prior_Payment_Schedule_Id := V_PN_Payment_Schedule_Id;
2972:
2973: l_context := 'Updating Payment Schedules';
2974:
2975: pnp_debug_pkg.log('Updating Payment schedules for Payment sch id : ' ||
2976: to_char(V_PN_Payment_Schedule_Id) );
2977:
2978: UPDATE PN_Payment_Schedules_all
2979: SET Transferred_By_User_Id = l_last_updated_by,

Line 2995: pnp_debug_pkg.put_log_msg('

2991: END LOOP;
2992:
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);

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:

Line 3000: 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:
3004: