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

231: l_success NUMBER;
232:
233: BEGIN
234:
235: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (+)');
236:
237: IF P_START_DATE IS NULL THEN
238: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
239: ELSE

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

299: WHERE payment_term_id = term_ID_tbl(i);
300:
301: END IF;
302:
303: pnp_debug_pkg.log('Before cursor c_term open');
304:
305: item_id_tbl.DELETE;
306: schedule_id_tbl.DELETE;
307: event_id_tbl.DELETE;

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

349: l_success := l_success + 1;
350:
351: IF l_index_item > 1000 THEN
352:
353: pnp_debug_pkg.log('Updating payment items');
354:
355: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
356: UPDATE pn_payment_items_all
357: SET transferred_to_ap_flag = 'Y',

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

360: last_update_login = l_last_update_login,
361: last_update_date = l_last_update_date
362: WHERE payment_item_id = item_id_tbl(i);
363:
364: pnp_debug_pkg.log('Updating Payment schedules ');
365:
366: IF schedule_id_tbl.COUNT > 0 THEN
367:
368: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

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

392:
393: IF l_failed = 1 THEN
394: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
395: fnd_message.set_token ('ER_LNO', ' ');
396: pnp_debug_pkg.put_log_msg(fnd_message.get);
397: END IF;
398:
399: fnd_message.set_name ('PN','PN_ITEM_ID');
400: fnd_message.set_token ('ID', acct_rec.payment_item_id);

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

397: END IF;
398:
399: fnd_message.set_name ('PN','PN_ITEM_ID');
400: fnd_message.set_token ('ID', acct_rec.payment_item_id);
401: pnp_debug_pkg.put_log_msg(fnd_message.get);
402: END;
403: END LOOP;
404:
405: pnp_debug_pkg.log('Updating remaining payment items');

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

401: pnp_debug_pkg.put_log_msg(fnd_message.get);
402: END;
403: END LOOP;
404:
405: pnp_debug_pkg.log('Updating remaining payment items');
406:
407: IF item_id_tbl.COUNT > 0 THEN
408:
409: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST

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

416: WHERE payment_item_id = item_id_tbl(i);
417:
418: END IF;
419:
420: pnp_debug_pkg.log('Updating remaining Payment schedules');
421:
422: IF schedule_id_tbl.COUNT > 0 THEN
423:
424: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

Line 435: pnp_debug_pkg.put_log_msg('

431: WHERE Payment_Schedule_Id = schedule_id_tbl(i);
432:
433: END IF;
434:
435: pnp_debug_pkg.put_log_msg('
436: ================================================================================');
437: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
438: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

435: pnp_debug_pkg.put_log_msg('
436: ================================================================================');
437: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
438: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

439: pnp_debug_pkg.put_log_msg(fnd_message.get);
440:
441: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
442: fnd_message.set_token ('SUC_LNO', to_char(l_success));
443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
447: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

443: pnp_debug_pkg.put_log_msg(fnd_message.get);
444:
445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
447: pnp_debug_pkg.put_log_msg(fnd_message.get);
448:
449: pnp_debug_pkg.put_log_msg('
450: ================================================================================');
451:

Line 449: pnp_debug_pkg.put_log_msg('

445: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
446: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
447: pnp_debug_pkg.put_log_msg(fnd_message.get);
448:
449: pnp_debug_pkg.put_log_msg('
450: ================================================================================');
451:
452: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (-)');
453:

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

448:
449: pnp_debug_pkg.put_log_msg('
450: ================================================================================');
451:
452: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (-)');
453:
454: END CREATE_AP_ACC_R12;
455:
456: -------------------------------------------------------------------------------

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

507: l_success NUMBER;
508:
509: BEGIN
510:
511: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (+)');
512:
513: IF P_START_DATE IS NULL THEN
514: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
515: ELSE

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

570: WHERE payment_term_id = term_ID_tbl(i);
571:
572: END IF;
573:
574: pnp_debug_pkg.log('Before cursor c_term open');
575:
576: item_id_tbl.DELETE;
577: schedule_id_tbl.DELETE;
578: event_id_tbl.DELETE;

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

618: l_success := l_success + 1;
619:
620: IF l_index_item = 1000 THEN
621:
622: pnp_debug_pkg.log('Updating payment items');
623:
624: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
625: UPDATE pn_payment_items_all
626: SET transferred_to_ar_flag = 'Y' ,

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

629: last_update_login = l_last_update_login,
630: last_update_date = l_last_update_date
631: WHERE payment_item_id = item_id_tbl(i);
632:
633: pnp_debug_pkg.log('Updating Payment schedules');
634:
635: IF schedule_id_tbl.COUNT > 0 THEN
636:
637: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

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

661:
662: IF l_failed = 1 THEN
663: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
664: fnd_message.set_token ('ER_LNO', ' ');
665: pnp_debug_pkg.put_log_msg(fnd_message.get);
666: END IF;
667:
668: fnd_message.set_name ('PN','PN_ITEM_ID');
669: fnd_message.set_token ('ID', acct_rec.payment_item_id);

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

666: END IF;
667:
668: fnd_message.set_name ('PN','PN_ITEM_ID');
669: fnd_message.set_token ('ID', acct_rec.payment_item_id);
670: pnp_debug_pkg.put_log_msg(fnd_message.get);
671:
672: END;
673: END LOOP;
674:

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

671:
672: END;
673: END LOOP;
674:
675: pnp_debug_pkg.log('Updating remaining payment items');
676:
677: IF item_id_tbl.COUNT > 0 THEN
678:
679: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST

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

686: WHERE payment_item_id = item_id_tbl(i);
687:
688: END IF;
689:
690: pnp_debug_pkg.log('Updating remaining Payment schedules');
691:
692: IF schedule_id_tbl.COUNT > 0 THEN
693:
694: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST

Line 705: pnp_debug_pkg.put_log_msg('

701: WHERE Payment_Schedule_Id = schedule_id_tbl(i);
702:
703: END IF;
704:
705: pnp_debug_pkg.put_log_msg('
706: ================================================================================');
707: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
708: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

705: pnp_debug_pkg.put_log_msg('
706: ================================================================================');
707: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
708: fnd_message.set_token ('FAIL_LNO', to_char(l_failed));
709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

709: pnp_debug_pkg.put_log_msg(fnd_message.get);
710:
711: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
712: fnd_message.set_token ('SUC_LNO', to_char(l_success));
713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
717: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

713: pnp_debug_pkg.put_log_msg(fnd_message.get);
714:
715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
717: pnp_debug_pkg.put_log_msg(fnd_message.get);
718:
719: pnp_debug_pkg.put_log_msg('
720: ================================================================================');
721:

Line 719: pnp_debug_pkg.put_log_msg('

715: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
716: fnd_message.set_token ('PR_LNO', to_char(l_failed + l_success));
717: pnp_debug_pkg.put_log_msg(fnd_message.get);
718:
719: pnp_debug_pkg.put_log_msg('
720: ================================================================================');
721:
722: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (-)');
723:

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

718:
719: pnp_debug_pkg.put_log_msg('
720: ================================================================================');
721:
722: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (-)');
723:
724: END CREATE_AR_ACC_R12;
725:
726: -------------------------------------------------------------------------------

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

797: fnd_message.set_token ('IMP_FLAG', p_submit_journal_import);
798: fnd_message.set_token ('ACCNT_FLAG', p_validate_account);
799: fnd_message.set_token ('ORG_ID', p_org_id);
800: fnd_message.set_token ('TYPE', p_selection_type);
801: pnp_debug_pkg.put_log_msg(fnd_message.get);
802:
803: IF pn_r12_util_pkg.is_r12 THEN
804: NULL;
805: ELSE

Line 819: pnp_debug_pkg.log('Default GL period Name = '|| p_default_period);

815: END IF;
816: CLOSE c_default_gl_period;
817: END IF;
818:
819: pnp_debug_pkg.log('Default GL period Name = '|| p_default_period);
820:
821: IF p_journal_category ='PM REVENUE' THEN
822:
823: IF pn_r12_util_pkg.is_r12 THEN

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

931: OPEN c_min_max_date ;
932: FETCH c_min_max_date INTO l_from_date ,l_to_date;
933: CLOSE c_min_max_date;
934:
935: pnp_debug_pkg.log('From Date to xla Procedure = '||To_char(l_from_date,'MM/DD/YYYY'));
936: pnp_debug_pkg.log('To Date to xla Procedure = '||To_char(l_to_date,'MM/DD/YYYY'));
937:
938: /* Call GL transfer only for valied date range */
939:

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

932: FETCH c_min_max_date INTO l_from_date ,l_to_date;
933: CLOSE c_min_max_date;
934:
935: pnp_debug_pkg.log('From Date to xla Procedure = '||To_char(l_from_date,'MM/DD/YYYY'));
936: pnp_debug_pkg.log('To Date to xla Procedure = '||To_char(l_to_date,'MM/DD/YYYY'));
937:
938: /* Call GL transfer only for valied date range */
939:
940: IF NOT(l_from_date is null AND l_to_date is null) THEN

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

988: l_accounted_amt NUMBER;
989:
990: BEGIN
991:
992: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (+)');
993:
994: IF p_conv_date > SYSDATE THEN
995: l_conv_date := SYSDATE;
996: ELSE

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

1008: actual_amount => NVL(p_amount,0),
1009: p_called_from => 'NOTPNTAUPMT');
1010: END IF;
1011:
1012: pnp_debug_pkg.log('Accounted Amount = '||l_accounted_amt);
1013: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (-)');
1014:
1015: RETURN l_accounted_amt;
1016:

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

1009: p_called_from => 'NOTPNTAUPMT');
1010: END IF;
1011:
1012: pnp_debug_pkg.log('Accounted Amount = '||l_accounted_amt);
1013: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (-)');
1014:
1015: RETURN l_accounted_amt;
1016:
1017: EXCEPTION

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

1214: l_diff_acc_amt NUMBER;
1215:
1216: BEGIN
1217:
1218: pnp_debug_pkg.log('at start of the Procedure CREATE_AR_ACC');
1219:
1220: if p_start_date is null then
1221: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
1222: else

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

1240: else
1241: l_high_lease_id := p_high_lease_id;
1242: end if;
1243:
1244: pnp_debug_pkg.log('Before cursor c_term open');
1245:
1246: OPEN c_term ;
1247:
1248: LOOP

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

1278:
1279: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
1280: fnd_message.set_token ('NUM', l_lease_id);
1281: fnd_message.set_token ('FLAG', l_send_flag);
1282: pnp_debug_pkg.put_log_msg(fnd_message.get);
1283:
1284: END IF;
1285:
1286: /* Do processing only if send_flag is Yes */

Line 1289: pnp_debug_pkg.put_log_msg('

1285:
1286: /* Do processing only if send_flag is Yes */
1287: IF (nvl(l_send_flag,'Y') = 'Y') THEN
1288:
1289: pnp_debug_pkg.put_log_msg('
1290: ================================================================================');
1291: fnd_message.set_name ('PN','PN_LEASE_ID');
1292: fnd_message.set_token ('ID', v_pn_lease_id);
1293: l_message := fnd_message.get;

Line 1300: pnp_debug_pkg.put_log_msg(l_message);

1296: l_message := l_message||' - '||fnd_message.get;
1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1299: l_message := l_message||' - '||fnd_message.get;
1300: pnp_debug_pkg.put_log_msg(l_message);
1301: pnp_debug_pkg.put_log_msg('
1302: ================================================================================');
1303:
1304: /* Check for Conversion Type and Conversion Rate for Currency Code */

Line 1301: pnp_debug_pkg.put_log_msg('

1297: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
1298: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
1299: l_message := l_message||' - '||fnd_message.get;
1300: pnp_debug_pkg.put_log_msg(l_message);
1301: pnp_debug_pkg.put_log_msg('
1302: ================================================================================');
1303:
1304: /* Check for Conversion Type and Conversion Rate for Currency Code */
1305:

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

1313: ,pn_mo_cache_utils.get_current_org_id);
1314:
1315: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1316: fnd_message.set_token ('CT', l_conv_rate_type);
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1320: fnd_message.set_token ('CR', v_pn_rate);
1321: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

1317: pnp_debug_pkg.put_log_msg(fnd_message.get);
1318:
1319: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
1320: fnd_message.set_token ('CR', v_pn_rate);
1321: pnp_debug_pkg.put_log_msg(fnd_message.get);
1322:
1323:
1324: /* if the accounted amount is null, then, GET IT!
1325: Ensure we populate accounted_CR/DR in the AE Lines */

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

1358: CLOSE c_valid_period;
1359:
1360: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
1361: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1365: fnd_message.set_token ('PERIOD', l_period_name);
1366: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

1362: pnp_debug_pkg.put_log_msg(fnd_message.get);
1363:
1364: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
1365: fnd_message.set_token ('PERIOD', l_period_name);
1366: pnp_debug_pkg.put_log_msg(fnd_message.get);
1367:
1368: /* if pay term changed, re init, create accounting EVENT */
1369: IF l_term_id <> v_pn_payment_term_id THEN
1370:

Line 1398: pnp_debug_pkg.log('Before event insert');

1394: WHERE source_table = 'PN_PAYMENT_TERMS'
1395: AND SOURCE_ID = v_pn_payment_term_id
1396: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1397:
1398: pnp_debug_pkg.log('Before event insert');
1399:
1400: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
1401: (
1402: ACCOUNTING_EVENT_ID ,

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

1441: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
1442:
1443: END IF; /* if pay term changed, re init, create accounting EVENT */
1444:
1445: pnp_debug_pkg.log('Before header insert');
1446:
1447: OPEN c_lease_num(v_pn_lease_id);
1448: FETCH c_lease_num INTO v_pn_lease_num;
1449: CLOSE c_lease_num;

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

1529: END IF;
1530:
1531: fnd_message.set_name ('PN','PN_CRACC_CRD_AMT');
1532: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1533: pnp_debug_pkg.put_log_msg(fnd_message.get);
1534:
1535: fnd_message.set_name ('PN','PN_CRACC_REC_ACC ');
1536: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1537: p_application_id => 101,

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

1538: p_id_flex_code => 'GL#',
1539: p_id_flex_num => l_chart_of_id,
1540: p_qualifier => 'ALL',
1541: p_ccid => rev_acnt_tab(i).account_id));
1542: pnp_debug_pkg.put_log_msg(fnd_message.get);
1543:
1544: pnp_debug_pkg.log('Inserting into lines for Revenue');
1545:
1546: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873

Line 1544: pnp_debug_pkg.log('Inserting into lines for Revenue');

1540: p_qualifier => 'ALL',
1541: p_ccid => rev_acnt_tab(i).account_id));
1542: pnp_debug_pkg.put_log_msg(fnd_message.get);
1543:
1544: pnp_debug_pkg.log('Inserting into lines for Revenue');
1545:
1546: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1547: l_rev_number := l_rev_number + 1;
1548:

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

1606: FND_GLOBAL.conc_program_id,
1607: FND_GLOBAL.conc_request_id
1608: );
1609:
1610: pnp_debug_pkg.log('Inserted into lines for Revenue');
1611:
1612: END LOOP; /* for each REVENUE account, create AE line */
1613:
1614: l_amt := 0;

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

1643: END IF;
1644:
1645: fnd_message.set_name ('PN','PN_CRACC_DB_ASS_AMT');
1646: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
1647: pnp_debug_pkg.put_log_msg(fnd_message.get);
1648:
1649: fnd_message.set_name ('PN','PN_CRACC_ASST_ACC ');
1650: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
1651: p_application_id => 101,

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

1652: p_id_flex_code => 'GL#',
1653: p_id_flex_num => l_chart_of_id,
1654: p_qualifier => 'ALL',
1655: p_ccid => acc_acnt_tab(i).account_id));
1656: pnp_debug_pkg.put_log_msg(fnd_message.get);
1657:
1658: pnp_debug_pkg.log('Inserting into lines for Accrued Asset');
1659: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1660:

Line 1658: pnp_debug_pkg.log('Inserting into lines for Accrued Asset');

1654: p_qualifier => 'ALL',
1655: p_ccid => acc_acnt_tab(i).account_id));
1656: pnp_debug_pkg.put_log_msg(fnd_message.get);
1657:
1658: pnp_debug_pkg.log('Inserting into lines for Accrued Asset');
1659: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1660:
1661: l_unearn_number := l_unearn_number + 1;
1662:

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

1719: FND_GLOBAL.conc_program_id,
1720: FND_GLOBAL.conc_request_id
1721: );
1722:
1723: pnp_debug_pkg.log('Inserted into lines for Accrued Asset');
1724:
1725: END LOOP; /* for each UNEARN account, create AE line */
1726:
1727: l_context := 'Updating Payment Items';

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

1724:
1725: END LOOP; /* for each UNEARN account, create AE line */
1726:
1727: l_context := 'Updating Payment Items';
1728: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
1729: to_char(v_pn_payment_item_id) );
1730:
1731: UPDATE pn_payment_items_all
1732: SET transferred_to_ar_flag = 'Y' ,

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

1742: AND v_cash_actual_amount = 0 ) THEN
1743:
1744: l_Prior_Payment_Schedule_Id := V_PN_Payment_Schedule_Id;
1745: l_context := 'Updating Payment Schedules';
1746: pnp_debug_pkg.log('Updating billing schedules for billing sch id : ' ||
1747: to_char(V_PN_Payment_Schedule_Id) );
1748:
1749: UPDATE PN_Payment_Schedules_all
1750: SET Transferred_By_User_Id = l_last_updated_by,

Line 1767: pnp_debug_pkg.put_log_msg('

1763: END LOOP;
1764:
1765: CLOSE c_term;
1766:
1767: pnp_debug_pkg.put_log_msg('
1768: ================================================================================');
1769: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
1770: fnd_message.set_token ('NUM', to_char(s_count));
1771: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

1767: pnp_debug_pkg.put_log_msg('
1768: ================================================================================');
1769: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
1770: fnd_message.set_token ('NUM', to_char(s_count));
1771: pnp_debug_pkg.put_log_msg(fnd_message.get);
1772: pnp_debug_pkg.put_log_msg('
1773: ================================================================================');
1774:
1775: END CREATE_AR_ACC;

Line 1772: pnp_debug_pkg.put_log_msg('

1768: ================================================================================');
1769: fnd_message.set_name ('PN','PN_CRACC_TOTAL_ITEMS_PRCSD');
1770: fnd_message.set_token ('NUM', to_char(s_count));
1771: pnp_debug_pkg.put_log_msg(fnd_message.get);
1772: pnp_debug_pkg.put_log_msg('
1773: ================================================================================');
1774:
1775: END CREATE_AR_ACC;
1776:

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

1968: l_diff_acc_amt NUMBER;
1969:
1970: BEGIN
1971:
1972: pnp_debug_pkg.log('at start of the Procedure CREATE_AP_ACC');
1973:
1974: IF P_START_DATE IS NULL THEN
1975: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
1976: ELSE

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

1994: ELSE
1995: l_high_lease_id := p_high_lease_id;
1996: END IF;
1997:
1998: pnp_debug_pkg.log('Before cursor c_term open');
1999:
2000: OPEN C_TERM ;
2001: LOOP
2002:

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

2031: l_lease_id := v_pn_lease_id;
2032: fnd_message.set_name ('PN','PN_CRACC_LEASE_SEND');
2033: fnd_message.set_token ('NUM', l_lease_id);
2034: fnd_message.set_token ('FLAG', l_send_flag);
2035: pnp_debug_pkg.put_log_msg(fnd_message.get);
2036:
2037: END IF;
2038:
2039: /* Do processing only if send_flag is Yes */

Line 2043: pnp_debug_pkg.put_log_msg('

2039: /* Do processing only if send_flag is Yes */
2040: IF (nvl(l_send_flag,'Y') = 'Y') THEN
2041:
2042:
2043: pnp_debug_pkg.put_log_msg('
2044: ================================================================================');
2045: fnd_message.set_name ('PN','PN_LEASE_ID');
2046: fnd_message.set_token ('ID', v_pn_lease_id);
2047: l_message := fnd_message.get;

Line 2054: pnp_debug_pkg.put_log_msg(l_message);

2050: l_message := l_message||' - '||fnd_message.get;
2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2053: l_message := l_message||' - '||fnd_message.get;
2054: pnp_debug_pkg.put_log_msg(l_message);
2055: pnp_debug_pkg.put_log_msg('
2056: ================================================================================');
2057:
2058:

Line 2055: pnp_debug_pkg.put_log_msg('

2051: fnd_message.set_name ('PN','PN_SCHEDULED_DATE');
2052: fnd_message.set_token ('DATE', to_char(v_schedule_date,'mm/dd/yyyy'));
2053: l_message := l_message||' - '||fnd_message.get;
2054: pnp_debug_pkg.put_log_msg(l_message);
2055: pnp_debug_pkg.put_log_msg('
2056: ================================================================================');
2057:
2058:
2059: /* Check for Conversion Type and Conversion Rate for Currency Code */

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

2067: ,pn_mo_cache_utils.get_current_org_id);
2068:
2069: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2070: fnd_message.set_token ('CT', l_conv_rate_type);
2071: pnp_debug_pkg.put_log_msg(fnd_message.get);
2072:
2073:
2074: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2075: fnd_message.set_token ('CR', v_pn_rate);

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

2072:
2073:
2074: fnd_message.set_name ('PN','PN_CRACC_CV_RATE');
2075: fnd_message.set_token ('CR', v_pn_rate);
2076: pnp_debug_pkg.put_log_msg(fnd_message.get);
2077:
2078:
2079: /* if the accounted amount is null, then, GET IT!
2080: Ensure we populate accounted_CR/DR in the AE Lines */

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

2113:
2114:
2115: fnd_message.set_name ('PN','PN_CRACC_ACC_DATE');
2116: fnd_message.set_token ('DATE', to_char(l_start_date,'mm/dd/yyyy'));
2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2120: fnd_message.set_token ('PERIOD', l_period_name);
2121: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2117: pnp_debug_pkg.put_log_msg(fnd_message.get);
2118:
2119: fnd_message.set_name ('PN','PN_CRACC_ACC_PRD');
2120: fnd_message.set_token ('PERIOD', l_period_name);
2121: pnp_debug_pkg.put_log_msg(fnd_message.get);
2122:
2123: IF l_term_id <> v_pn_payment_term_id THEN
2124:
2125: l_term_id := v_pn_payment_term_id ;

Line 2152: pnp_debug_pkg.log('Before event insert');

2148: WHERE source_table = 'PN_PAYMENT_TERMS'
2149: AND SOURCE_ID = v_pn_payment_term_id
2150: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2151:
2152: pnp_debug_pkg.log('Before event insert');
2153:
2154:
2155: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2156:

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

2199: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
2200:
2201: END IF;
2202:
2203: pnp_debug_pkg.log('Before header insert');
2204:
2205:
2206: OPEN c_lease_num(v_pn_lease_id);
2207: FETCH c_lease_num INTO v_pn_lease_num;

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

2288: END IF;
2289:
2290: fnd_message.set_name ('PN','PN_CRACC_DBT_AMT');
2291: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2292: pnp_debug_pkg.put_log_msg(fnd_message.get);
2293:
2294: fnd_message.set_name ('PN','PN_CRACC_EXP_ACC ');
2295: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2296: p_application_id => 101,

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

2298: p_id_flex_num => l_chart_of_id,
2299: p_qualifier => 'ALL',
2300: p_ccid => exp_acnt_tab(i).account_id));
2301:
2302: pnp_debug_pkg.put_log_msg(fnd_message.get);
2303:
2304: pnp_debug_pkg.log('Inserting into lines for Expense');
2305:
2306: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873

Line 2304: pnp_debug_pkg.log('Inserting into lines for Expense');

2300: p_ccid => exp_acnt_tab(i).account_id));
2301:
2302: pnp_debug_pkg.put_log_msg(fnd_message.get);
2303:
2304: pnp_debug_pkg.log('Inserting into lines for Expense');
2305:
2306: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2307: l_exp_number := l_exp_number +1;
2308:

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

2366: FND_GLOBAL.conc_program_id,
2367: FND_GLOBAL.conc_request_id
2368: );
2369:
2370: pnp_debug_pkg.log('Inserted into lines for Expense');
2371:
2372: END LOOP;
2373:
2374: l_amt := 0;

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

2402: END IF;
2403:
2404: fnd_message.set_name ('PN','PN_CRACC_CR_LIA_AMT');
2405: fnd_message.set_token ('AMT', to_char(round(l_amt,l_precision)));
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: fnd_message.set_name ('PN','PN_CRACC_LIA_ACC ');
2409: fnd_message.set_token ('ACC', FA_RX_FLEX_PKG.get_value(
2410: p_application_id => 101,

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

2412: p_id_flex_num => l_chart_of_id,
2413: p_qualifier => 'ALL',
2414: p_ccid => acc_acnt_tab(i).account_id));
2415:
2416: pnp_debug_pkg.put_log_msg(fnd_message.get);
2417:
2418: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');
2419: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2420:

Line 2418: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');

2414: p_ccid => acc_acnt_tab(i).account_id));
2415:
2416: pnp_debug_pkg.put_log_msg(fnd_message.get);
2417:
2418: pnp_debug_pkg.log('Inserting into lines for Accrued Liability');
2419: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2420:
2421:
2422: l_acc_number := l_acc_number +1;

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

2481: FND_GLOBAL.conc_program_id,
2482: FND_GLOBAL.conc_request_id
2483: );
2484:
2485: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');
2486:
2487: END LOOP;
2488:
2489: l_context := 'Updating Payment Items';

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

2486:
2487: END LOOP;
2488:
2489: l_context := 'Updating Payment Items';
2490: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2491: to_char(v_pn_payment_item_id) );
2492:
2493: UPDATE pn_payment_items_all
2494: SET transferred_to_ap_flag = 'Y' ,

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

2503: l_Prior_Payment_Schedule_Id := V_PN_Payment_Schedule_Id;
2504:
2505: l_context := 'Updating Payment Schedules';
2506:
2507: pnp_debug_pkg.log('Updating Payment schedules for Payment sch id : ' ||
2508: to_char(V_PN_Payment_Schedule_Id) );
2509:
2510: UPDATE PN_Payment_Schedules_all
2511: SET Transferred_By_User_Id = l_last_updated_by,

Line 2527: pnp_debug_pkg.put_log_msg('

2523: END LOOP;
2524:
2525: CLOSE c_term;
2526:
2527: pnp_debug_pkg.put_log_msg('
2528: ================================================================================');
2529: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2530: fnd_message.set_token ('NUM', to_char(s_count));
2531: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2527: pnp_debug_pkg.put_log_msg('
2528: ================================================================================');
2529: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2530: fnd_message.set_token ('NUM', to_char(s_count));
2531: pnp_debug_pkg.put_log_msg(fnd_message.get);
2532: pnp_debug_pkg.put_log_msg('
2533: ================================================================================');
2534: END CREATE_AP_ACC;
2535:

Line 2532: pnp_debug_pkg.put_log_msg('

2528: ================================================================================');
2529: fnd_message.set_name ('PN','PN_CRACC_TOTAL_PAY_ITEMS_PRCSD');
2530: fnd_message.set_token ('NUM', to_char(s_count));
2531: pnp_debug_pkg.put_log_msg(fnd_message.get);
2532: pnp_debug_pkg.put_log_msg('
2533: ================================================================================');
2534: END CREATE_AP_ACC;
2535:
2536: END PN_CREATE_ACC;