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.PNT_PAYMENT_TERMS_PKG dependencies on PNT_PAYMENT_TERMS_PKG

Line 1: PACKAGE BODY pnt_payment_terms_pkg AS

1: PACKAGE BODY pnt_payment_terms_pkg AS
2: -- $Header: PNTPYTRB.pls 120.16.12010000.5 2010/02/02 09:51:00 jsundara ship $
3:
4:
5: -------------------------------------------------------------------

Line 33: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (+)');

29: ,X_ESTIMATED_AMOUNT IN NUMBER
30: )
31: IS
32: BEGIN
33: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (+)');
34: IF ((X_ACTUAL_AMOUNT IS NULL) AND
35: (X_ESTIMATED_AMOUNT IS NULL))
36: THEN
37: fnd_message.set_name ('PN','PN_PAYMENT_AMOUNT_NULL');

Line 41: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (-) RetStat: '||x_return_status);

37: fnd_message.set_name ('PN','PN_PAYMENT_AMOUNT_NULL');
38: x_return_status := 'E';
39: END IF;
40:
41: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (-) RetStat: '||x_return_status);
42: END CHECK_PAYMENT_AMOUNTS;
43:
44: --------------------------------------------------------------------------------
45: -- PROCDURE : INSERT_ROW

Line 206: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.INSERT_ROW (+)');

202: AND GROSS_FLAG = 'Y';
203:
204:
205: BEGIN
206: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.INSERT_ROW (+)');
207:
208: -- Check IF both Estimated AND actual amount are NULL
209: l_return_status := NULL;
210: PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (

Line 210: PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (

206: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.INSERT_ROW (+)');
207:
208: -- Check IF both Estimated AND actual amount are NULL
209: l_return_status := NULL;
210: PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (
211: l_RETURN_STATUS
212: ,X_ACTUAL_AMOUNT
213: ,X_ESTIMATED_AMOUNT);
214: IF (l_return_status IS NOT NULL) THEN

Line 493: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.INSERT_ROW (-)');

489: RAISE NO_DATA_FOUND;
490: END IF;
491: CLOSE c;
492:
493: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.INSERT_ROW (-)');
494: END insert_row;
495:
496: -------------------------------------------------------------------------------
497: -- PROCDURE : LOCK_ROW

Line 613: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.LOCK_ROW (+)');

609:
610: --tlinfo c1%rowtype;
611:
612: BEGIN
613: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.LOCK_ROW (+)');
614:
615: OPEN c1;
616: FETCH c1 INTO tlinfo;
617: IF (c1%NOTFOUND) THEN

Line 1072: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.LOCK_ROW (-)');

1068: OR ((tlinfo.opex_type IS NULL) AND (x_opex_type IS NULL))) THEN
1069: pn_var_rent_pkg.lock_row_exception('RECUR_BB_CALC_DATE',tlinfo.opex_type);
1070: END IF;
1071:
1072: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.LOCK_ROW (-)');
1073:
1074: END LOCK_ROW;
1075:
1076: -------------------------------------------------------------------------------=

Line 1215: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.UPDATE_ROW (+)');

1211: l_update_nbp_flag VARCHAR2(1);
1212:
1213: BEGIN
1214:
1215: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.UPDATE_ROW (+)');
1216:
1217: -- Check IF both Estimated AND actual amount are NULL
1218: l_context := 'checking est AND actual amt';
1219: l_return_status := NULL;

Line 1220: PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (

1216:
1217: -- Check IF both Estimated AND actual amount are NULL
1218: l_context := 'checking est AND actual amt';
1219: l_return_status := NULL;
1220: PNT_PAYMENT_TERMS_PKG.CHECK_PAYMENT_AMOUNTS (
1221: l_RETURN_STATUS
1222: ,X_ACTUAL_AMOUNT
1223: ,X_ESTIMATED_AMOUNT
1224: );

Line 1245: -- PNT_PAYMENT_TERMS_PKG.CHECK_APPROVED_SCHEDULE_EXISTS

1241: -----------------------------------------------------------------------------
1242: -- Bug Fix : 1668495.
1243: -- Removed the call to the
1244: -- following PROCEDURE
1245: -- PNT_PAYMENT_TERMS_PKG.CHECK_APPROVED_SCHEDULE_EXISTS
1246: -- form the UPDATE TABLE HANDLER
1247: -- to allow the user to change the
1248: -- Vendor Information , Customer Information
1249: -- AND also the GL Account even when the

Line 1305: PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (

1301: END IF;
1302:
1303: l_context := 'updating vendor AND customer info';
1304:
1305: PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (
1306: X_PAYMENT_TERM_ID
1307: ,X_VENDOR_ID
1308: ,X_VENDOR_SITE_ID
1309: ,X_LAST_UPDATE_DATE

Line 1459: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.UPDATE_ROW (-)');

1455: RAISE NO_DATA_FOUND;
1456: END IF;
1457:
1458:
1459: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.UPDATE_ROW (-)');
1460:
1461: EXCEPTION
1462: WHEN OTHERS THEN
1463: RAISE_APPLICATION_ERROR(-20001,'Error while ' || l_context || to_char(sqlcode));

Line 1482: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (+)');

1478: )
1479: IS
1480: BEGIN
1481:
1482: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (+)');
1483:
1484: DELETE FROM pn_payment_terms_all
1485: WHERE payment_term_id = x_payment_term_id;
1486:

Line 1491: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (-)');

1487: IF (SQL%NOTFOUND) THEN
1488: RAISE NO_DATA_FOUND;
1489: END IF;
1490:
1491: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (-)');
1492: END DELETE_ROW;
1493:
1494: -------------------------------------------------------------------------------
1495: -- PROCDURE : UPDATE_VENDOR_AND_CUST

Line 1524: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (+)');

1520: AND ppi.transferred_to_ar_flag IS NULL
1521: FOR UPDATE OF ppi.payment_item_id NOWAIT;
1522:
1523: BEGIN
1524: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (+)');
1525: -- UPDATE each item with the new vendor AND vendor site
1526: FOR eachItem IN c1 LOOP
1527:
1528: UPDATE pn_payment_items_all

Line 1541: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (-)');

1537: WHERE payment_item_id = eachItem.payment_item_id;
1538:
1539: END LOOP;
1540:
1541: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (-)');
1542: END UPDATE_VENDOR_AND_CUST;
1543:
1544: -------------------------------------------------------------------------------
1545: -- PROCEDURE : CHECK_APPROVED_SCHEDULE_EXISTS

Line 1585: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_APPROVED_SCHEDULE_EXISTS (+)');

1581: AND pps.schedule_date BETWEEN l_startDate AND l_endDate
1582: );
1583:
1584: BEGIN
1585: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_APPROVED_SCHEDULE_EXISTS (+)');
1586:
1587: SELECT TRUNC(x_start_date, 'MM')
1588: ,LAST_DAY(x_end_date)
1589: INTO l_startDate

Line 1608: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_APPROVED_SCHEDULE_EXISTS (-) RetStat: '||x_return_status);

1604: fnd_message.set_token('LEASE_NUMBER', l_leaseNumber);
1605: fnd_message.set_token('START_DATE', l_startDate);
1606: fnd_message.set_token('END_DATE', l_endDate);
1607:
1608: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_APPROVED_SCHEDULE_EXISTS (-) RetStat: '||x_return_status);
1609: END Check_Approved_Schedule_Exists;
1610:
1611: --------------------------------------------------------------------------------
1612: -- PROCEDURE : UPDATE_PNT_ITEMS_AMT

Line 1675: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_AMT (+) TermId: '

1671: l_min_acct_unit NUMBER;
1672: l_first BOOLEAN;
1673: BEGIN
1674:
1675: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_AMT (+) TermId: '
1676: ||p_pnt_term_id||', OldEstAmt: '||p_old_est_amt
1677: ||', NewEstAmt: '||p_new_est_amt||', Freq: '||p_freq_code);
1678: l_context:= 'Updating for OneTime term';
1679:

Line 1807: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_AMT (-)');

1803: END LOOP;
1804:
1805: END IF; -- p_freq_code = 'OT'
1806:
1807: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_AMT (-)');
1808: EXCEPTION
1809: WHEN OTHERS THEN
1810: RAISE_APPLICATION_ERROR(-20001,'Error while ' || l_context || TO_CHAR(sqlcode));
1811: app_exception.Raise_Exception;

Line 1813: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_AMT (-)');

1809: WHEN OTHERS THEN
1810: RAISE_APPLICATION_ERROR(-20001,'Error while ' || l_context || TO_CHAR(sqlcode));
1811: app_exception.Raise_Exception;
1812:
1813: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_AMT (-)');
1814: END UPDATE_PNT_ITEMS_AMT;
1815:
1816: -------------------------------------------------------------------------------
1817: -- PROCEDURE : UPDATE_PNT_ITEMS_RATE

Line 1845: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_RATE (+)');

1841: AND ppi.export_to_ar_flag IS NULL;
1842:
1843: BEGIN
1844:
1845: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_RATE (+)');
1846: l_context := 'opening payment rate cursor';
1847:
1848: FOR pnt_rec IN pnt_cursor LOOP
1849:

Line 1857: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_RATE (-)');

1853: WHERE payment_item_id = pnt_rec.payment_item_id;
1854:
1855: END LOOP;
1856:
1857: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_RATE (-)');
1858: EXCEPTION
1859: WHEN OTHERS THEN
1860: RAISE_APPLICATION_ERROR(-20001,'Error while ' || l_context || TO_CHAR(sqlcode));
1861: app_exception.Raise_Exception;

Line 1862: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_RATE (-)');

1858: EXCEPTION
1859: WHEN OTHERS THEN
1860: RAISE_APPLICATION_ERROR(-20001,'Error while ' || l_context || TO_CHAR(sqlcode));
1861: app_exception.Raise_Exception;
1862: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_PNT_ITEMS_RATE (-)');
1863: END UPDATE_PNT_ITEMS_RATE;
1864:
1865: -------------------------------------------------------------------------------
1866: -- PROCEDURE : create_hist_corr_upd

Line 1925: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');

1921: FROM pn_payment_terms_history
1922: WHERE payment_term_id = p_term_id;
1923: BEGIN
1924:
1925: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');
1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);
1927: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1928: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1929: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);

Line 3618: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (-)');

3614: END LOOP;
3615: END IF;
3616: END IF;
3617:
3618: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (-)');
3619:
3620: END create_hist_corr_upd;
3621:
3622: --------------------------------------------------------------------------------

Line 3773: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.MODIFY_ROW (+)');

3769: ,x_changed_flag IN VARCHAR2)
3770: IS
3771: BEGIN
3772:
3773: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.MODIFY_ROW (+)');
3774:
3775: UPDATE pn_payment_terms_all
3776: SET changed_flag = x_changed_flag
3777: WHERE payment_term_id = NVL(x_payment_term_id ,payment_term_id )

Line 3780: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.MODIFY_ROW (-)');

3776: SET changed_flag = x_changed_flag
3777: WHERE payment_term_id = NVL(x_payment_term_id ,payment_term_id )
3778: AND var_rent_inv_id = x_var_rent_inv_id;
3779:
3780: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.MODIFY_ROW (-)');
3781:
3782: EXCEPTION
3783: WHEN others THEN
3784: NULL;

Line 3789: END PNT_PAYMENT_TERMS_PKG;

3785: END MODIFY_ROW;
3786:
3787:
3788:
3789: END PNT_PAYMENT_TERMS_PKG;