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 PNP_DEBUG_PKG

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 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 1213: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.UPDATE_ROW (+)');

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

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

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

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

1474: )
1475: IS
1476: BEGIN
1477:
1478: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (+)');
1479:
1480: DELETE FROM pn_payment_terms_all
1481: WHERE payment_term_id = x_payment_term_id;
1482:

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

1483: IF (SQL%NOTFOUND) THEN
1484: RAISE NO_DATA_FOUND;
1485: END IF;
1486:
1487: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (-)');
1488: END DELETE_ROW;
1489:
1490: -------------------------------------------------------------------------------
1491: -- PROCDURE : UPDATE_VENDOR_AND_CUST

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

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

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

1533: WHERE payment_item_id = eachItem.payment_item_id;
1534:
1535: END LOOP;
1536:
1537: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (-)');
1538: END UPDATE_VENDOR_AND_CUST;
1539:
1540: -------------------------------------------------------------------------------
1541: -- PROCEDURE : CHECK_APPROVED_SCHEDULE_EXISTS

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

1577: AND pps.schedule_date BETWEEN l_startDate AND l_endDate
1578: );
1579:
1580: BEGIN
1581: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.CHECK_APPROVED_SCHEDULE_EXISTS (+)');
1582:
1583: SELECT TRUNC(x_start_date, 'MM')
1584: ,LAST_DAY(x_end_date)
1585: INTO l_startDate

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

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

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

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

Line 1762: pnp_debug_pkg.debug('Get Amt; SchStrDt: '||l_sch_str_dt||', SchEndDt: '||l_sch_end_dt

1758: TO_CHAR(l_prorate_rule),
1759: l_act_amt,
1760: l_est_amt
1761: );
1762: pnp_debug_pkg.debug('Get Amt; SchStrDt: '||l_sch_str_dt||', SchEndDt: '||l_sch_end_dt
1763: ||', ActAmt: '||l_act_amt||', EstAmt: '||l_est_amt);
1764:
1765: l_first_last := 'Y';
1766:

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

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

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

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

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

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

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

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

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

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

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

1917: FROM pn_payment_terms_history
1918: WHERE payment_term_id = p_term_id;
1919: BEGIN
1920:
1921: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');
1922: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);
1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);

Line 1922: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);

1918: WHERE payment_term_id = p_term_id;
1919: BEGIN
1920:
1921: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');
1922: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);
1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);
1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);

Line 1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);

1919: BEGIN
1920:
1921: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');
1922: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);
1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);
1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1927: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);

Line 1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);

1920:
1921: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');
1922: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);
1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);
1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1927: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1928:

Line 1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);

1921: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');
1922: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);
1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);
1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1927: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1928:
1929: l_dist_change_id := NULL;

Line 1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);

1922: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);
1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);
1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1927: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1928:
1929: l_dist_change_id := NULL;
1930: l_prev_term_hist_id := NULL;

Line 1927: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);

1923: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_dist_changed :'||p_dist_changed);
1924: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_hist_dist_tab.count :'||p_hist_dist_tab.count);
1925: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_change_mode :'||p_change_mode);
1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1927: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1928:
1929: l_dist_change_id := NULL;
1930: l_prev_term_hist_id := NULL;
1931: l_new_term_id := NULL;

Line 1983: pnp_debug_pkg.debug('create_hist_corr_upd : p_dist_changed :'||p_dist_changed);

1979: NVL(term_rec.salesrep_id, -9999) <> NVL(tlinfo.salesrep_id, -9999)) OR
1980: NVL(p_dist_changed, 0) > 0
1981: THEN
1982:
1983: pnp_debug_pkg.debug('create_hist_corr_upd : p_dist_changed :'||p_dist_changed);
1984: pnp_debug_pkg.debug('create_hist_corr_upd : term_altered_flag :'||tlinfo.term_altered_flag);
1985:
1986: IF NVL(p_dist_changed, 0) >= 0 THEN
1987:

Line 1984: pnp_debug_pkg.debug('create_hist_corr_upd : term_altered_flag :'||tlinfo.term_altered_flag);

1980: NVL(p_dist_changed, 0) > 0
1981: THEN
1982:
1983: pnp_debug_pkg.debug('create_hist_corr_upd : p_dist_changed :'||p_dist_changed);
1984: pnp_debug_pkg.debug('create_hist_corr_upd : term_altered_flag :'||tlinfo.term_altered_flag);
1985:
1986: IF NVL(p_dist_changed, 0) >= 0 THEN
1987:
1988: IF NVL(p_hist_dist_tab.count,0) <> 0 AND

Line 1995: pnp_debug_pkg.debug('create_hist_corr_upd : l_dist_change_id :'||l_dist_change_id);

1991: SELECT pn_distributions_history_s1.NEXTVAL
1992: INTO l_dist_change_id
1993: FROM DUAL;
1994:
1995: pnp_debug_pkg.debug('create_hist_corr_upd : l_dist_change_id :'||l_dist_change_id);
1996:
1997: FOR i in 1..p_hist_dist_tab.count LOOP
1998:
1999: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Dist. Hist. for very first time');

Line 1999: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Dist. Hist. for very first time');

1995: pnp_debug_pkg.debug('create_hist_corr_upd : l_dist_change_id :'||l_dist_change_id);
1996:
1997: FOR i in 1..p_hist_dist_tab.count LOOP
1998:
1999: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Dist. Hist. for very first time');
2000:
2001: INSERT INTO pn_distributions_history
2002: (
2003: DISTRIBUTION_HISTORY_ID

Line 2064: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Term Hist. for very first time');

2060: ,p_hist_dist_tab(i).ATTRIBUTE15
2061: );
2062: END LOOP;
2063:
2064: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Term Hist. for very first time');
2065:
2066: INSERT INTO pn_payment_terms_history
2067: (
2068: TERM_HISTORY_ID

Line 2276: pnp_debug_pkg.debug('create_hist_corr_upd : Updating Term Altered Flag in pn_payment_terms_all');

2272: ,tlinfo.AREA_TYPE_CODE
2273: ,tlinfo.AREA
2274: ,NULL);
2275:
2276: pnp_debug_pkg.debug('create_hist_corr_upd : Updating Term Altered Flag in pn_payment_terms_all');
2277:
2278: UPDATE pn_payment_terms_all
2279: SET term_altered_flag = 'Y'
2280: WHERE payment_term_id = p_term_id;

Line 2290: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id : '||l_dist_change_id);

2286: SELECT pn_distributions_history_s1.NEXTVAL
2287: INTO l_dist_change_id
2288: FROM DUAL;
2289:
2290: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id : '||l_dist_change_id);
2291:
2292: FOR dist_rec IN get_dist_cur(p_term_id) LOOP
2293:
2294: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist.');

Line 2294: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist.');

2290: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id : '||l_dist_change_id);
2291:
2292: FOR dist_rec IN get_dist_cur(p_term_id) LOOP
2293:
2294: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist.');
2295:
2296: INSERT INTO pn_distributions_history
2297: (
2298: DISTRIBUTION_HISTORY_ID

Line 2365: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_dist_change_id : '||l_dist_change_id);

2361: OPEN get_max_dist_change_id_cur(p_term_id);
2362: FETCH get_max_dist_change_id_cur INTO l_dist_change_id;
2363: CLOSE get_max_dist_change_id_cur;
2364:
2365: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_dist_change_id : '||l_dist_change_id);
2366:
2367: OPEN get_max_term_hist_id_cur(p_term_id);
2368: FETCH get_max_term_hist_id_cur INTO l_prev_term_hist_id;
2369: CLOSE get_max_term_hist_id_cur;

Line 2371: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_term_hist_id : '||l_prev_term_hist_id);

2367: OPEN get_max_term_hist_id_cur(p_term_id);
2368: FETCH get_max_term_hist_id_cur INTO l_prev_term_hist_id;
2369: CLOSE get_max_term_hist_id_cur;
2370:
2371: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_term_hist_id : '||l_prev_term_hist_id);
2372:
2373: IF p_change_mode = 'CORRECT' THEN
2374:
2375: IF (term_rec.start_date > tlinfo.start_date AND

Line 2409: pnp_debug_pkg.debug('create_hist_corr_upd : l_adj_type_code :'||l_adj_type_code);

2405: ELSE
2406: l_adj_type_code := 'ADJ-MUL';
2407: END IF;
2408:
2409: pnp_debug_pkg.debug('create_hist_corr_upd : l_adj_type_code :'||l_adj_type_code);
2410: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2411:
2412: INSERT INTO pn_payment_terms_history
2413: (TERM_HISTORY_ID

Line 2410: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');

2406: l_adj_type_code := 'ADJ-MUL';
2407: END IF;
2408:
2409: pnp_debug_pkg.debug('create_hist_corr_upd : l_adj_type_code :'||l_adj_type_code);
2410: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2411:
2412: INSERT INTO pn_payment_terms_history
2413: (TERM_HISTORY_ID
2414: ,LAST_UPDATE_DATE

Line 2624: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_str_dt : '||p_eff_str_dt);

2620: END IF;
2621:
2622: IF p_change_mode = 'UPDATE' THEN
2623:
2624: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_str_dt : '||p_eff_str_dt);
2625: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_end_dt : '||p_eff_end_dt);
2626: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_str_dt : '||term_rec.start_date);
2627: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_end_dt : '||term_rec.end_date);
2628:

Line 2625: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_end_dt : '||p_eff_end_dt);

2621:
2622: IF p_change_mode = 'UPDATE' THEN
2623:
2624: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_str_dt : '||p_eff_str_dt);
2625: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_end_dt : '||p_eff_end_dt);
2626: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_str_dt : '||term_rec.start_date);
2627: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_end_dt : '||term_rec.end_date);
2628:
2629: IF (p_eff_str_dt > term_rec.start_date AND

Line 2626: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_str_dt : '||term_rec.start_date);

2622: IF p_change_mode = 'UPDATE' THEN
2623:
2624: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_str_dt : '||p_eff_str_dt);
2625: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_end_dt : '||p_eff_end_dt);
2626: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_str_dt : '||term_rec.start_date);
2627: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_end_dt : '||term_rec.end_date);
2628:
2629: IF (p_eff_str_dt > term_rec.start_date AND
2630: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN

Line 2627: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_end_dt : '||term_rec.end_date);

2623:
2624: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_str_dt : '||p_eff_str_dt);
2625: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_end_dt : '||p_eff_end_dt);
2626: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_str_dt : '||term_rec.start_date);
2627: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_end_dt : '||term_rec.end_date);
2628:
2629: IF (p_eff_str_dt > term_rec.start_date AND
2630: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2631:

Line 2639: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);

2635:
2636: l_adj_type_code := NULL;
2637: l_term_comments := NULL;
2638:
2639: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2640: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Updating term with new Term Id');
2641:
2642: UPDATE pn_payment_terms_all
2643: SET start_date = p_eff_str_dt,

Line 2640: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Updating term with new Term Id');

2636: l_adj_type_code := NULL;
2637: l_term_comments := NULL;
2638:
2639: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2640: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Updating term with new Term Id');
2641:
2642: UPDATE pn_payment_terms_all
2643: SET start_date = p_eff_str_dt,
2644: end_date = NVL(p_eff_end_dt,term_rec.end_date),

Line 2654: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);

2650: SELECT pn_distributions_history_s1.NEXTVAL
2651: INTO l_dist_change_id
2652: FROM DUAL;
2653:
2654: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);
2655:
2656: FOR dist_rec IN get_dist_cur(p_term_id) LOOP
2657:
2658: l_new_dist_id := NULL;

Line 2663: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_dist_id : '||l_new_dist_id);

2659: SELECT pn_distributions_s.nextval
2660: INTO l_new_dist_id
2661: FROM DUAL;
2662:
2663: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_dist_id : '||l_new_dist_id);
2664:
2665: UPDATE pn_distributions_all
2666: SET distribution_id = l_new_dist_id,
2667: payment_term_id = l_new_term_id

Line 2670: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist.');

2666: SET distribution_id = l_new_dist_id,
2667: payment_term_id = l_new_term_id
2668: WHERE distribution_id = dist_rec.distribution_id;
2669:
2670: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist.');
2671:
2672: INSERT INTO pn_distributions_history
2673: (DISTRIBUTION_HISTORY_ID
2674: ,LAST_UPDATE_DATE

Line 2736: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Updating term with Eff. End Date');

2732:
2733: ELSIF (p_eff_str_dt = term_rec.start_date AND
2734: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2735:
2736: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Updating term with Eff. End Date');
2737:
2738: UPDATE pn_payment_terms_all
2739: SET end_date = NVL(p_eff_end_dt, term_rec.end_date),
2740: term_altered_flag = 'Y',

Line 2748: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);

2744: l_new_term_id := tlinfo.payment_term_id;
2745: l_adj_type_code := 'ADJ-PCON';
2746: l_term_comments := term_rec.term_comments;
2747:
2748: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2749:
2750: END IF;
2751:
2752: IF (p_eff_str_dt >= term_rec.start_date AND

Line 2755: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);

2751:
2752: IF (p_eff_str_dt >= term_rec.start_date AND
2753: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2754:
2755: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2756: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);
2757: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2758:
2759: INSERT INTO pn_payment_terms_history

Line 2756: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);

2752: IF (p_eff_str_dt >= term_rec.start_date AND
2753: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2754:
2755: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2756: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);
2757: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2758:
2759: INSERT INTO pn_payment_terms_history
2760: (TERM_HISTORY_ID

Line 2757: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');

2753: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2754:
2755: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2756: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);
2757: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2758:
2759: INSERT INTO pn_payment_terms_history
2760: (TERM_HISTORY_ID
2761: ,LAST_UPDATE_DATE

Line 2970: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Setting value of counter n');

2966: ,l_term_comments);
2967:
2968: END IF;
2969:
2970: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Setting value of counter n');
2971:
2972: IF p_eff_str_dt <> term_rec.start_date THEN
2973: IF NVL(p_eff_end_dt, term_rec.end_date) = term_rec.end_date THEN
2974: n := 1;

Line 2982: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Check counter value n :'||n);

2978: ELSIF p_eff_str_dt = term_rec.start_date THEN
2979: n := 1;
2980: END IF;
2981:
2982: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Check counter value n :'||n);
2983:
2984: FOR i in 1..n LOOP
2985:
2986: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- In Term Loop for i :'||i);

Line 2986: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- In Term Loop for i :'||i);

2982: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Check counter value n :'||n);
2983:
2984: FOR i in 1..n LOOP
2985:
2986: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- In Term Loop for i :'||i);
2987:
2988: IF p_eff_str_dt <> term_rec.start_date AND
2989: i = 1 THEN
2990:

Line 3025: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);

3021: l_changed_flag := 'N';
3022:
3023: END IF;
3024:
3025: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);
3026: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3027: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3028: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3029:

Line 3026: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);

3022:
3023: END IF;
3024:
3025: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);
3026: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3027: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3028: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3029:
3030: INSERT INTO pn_payment_terms_all

Line 3027: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);

3023: END IF;
3024:
3025: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);
3026: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3027: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3028: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3029:
3030: INSERT INTO pn_payment_terms_all
3031: (PAYMENT_TERM_ID

Line 3028: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');

3024:
3025: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);
3026: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3027: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3028: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3029:
3030: INSERT INTO pn_payment_terms_all
3031: (PAYMENT_TERM_ID
3032: ,LAST_UPDATE_DATE

Line 3239: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- In Dist. Loop for j :'||j);

3235: l_insert_dist_hist := 'N';
3236:
3237: FOR j in 1..p_hist_dist_tab.count LOOP
3238:
3239: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- In Dist. Loop for j :'||j);
3240:
3241: IF p_eff_str_dt <> term_rec.start_date AND
3242: i = 1 THEN
3243:

Line 3260: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);

3256: l_insert_dist_hist := 'Y';
3257:
3258: END IF;
3259:
3260: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3261: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3262: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3263:
3264: INSERT INTO pn_distributions_all

Line 3261: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);

3257:
3258: END IF;
3259:
3260: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3261: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3262: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3263:
3264: INSERT INTO pn_distributions_all
3265: (distribution_id

Line 3262: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');

3258: END IF;
3259:
3260: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3261: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3262: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3263:
3264: INSERT INTO pn_distributions_all
3265: (distribution_id
3266: ,account_id

Line 3327: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist. table.');

3323: ,p_hist_dist_tab(j).org_id);
3324:
3325: IF l_insert_dist_hist = 'Y' THEN
3326:
3327: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist. table.');
3328:
3329: INSERT INTO pn_distributions_history
3330: (DISTRIBUTION_HISTORY_ID
3331: ,LAST_UPDATE_DATE

Line 3396: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_dist_change_id : '||l_dist_change_id);

3392: OPEN get_max_dist_change_id_cur(p_term_id);
3393: FETCH get_max_dist_change_id_cur INTO l_dist_change_id;
3394: CLOSE get_max_dist_change_id_cur;
3395:
3396: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_dist_change_id : '||l_dist_change_id);
3397: END IF;
3398: END IF;
3399:
3400: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist. table.');

Line 3400: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist. table.');

3396: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_dist_change_id : '||l_dist_change_id);
3397: END IF;
3398: END IF;
3399:
3400: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist. table.');
3401:
3402: INSERT INTO pn_payment_terms_history
3403: (TERM_HISTORY_ID
3404: ,LAST_UPDATE_DATE

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

3610: END LOOP;
3611: END IF;
3612: END IF;
3613:
3614: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (-)');
3615:
3616: END create_hist_corr_upd;
3617:
3618: --------------------------------------------------------------------------------

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

3765: ,x_changed_flag IN VARCHAR2)
3766: IS
3767: BEGIN
3768:
3769: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.MODIFY_ROW (+)');
3770:
3771: UPDATE pn_payment_terms_all
3772: SET changed_flag = x_changed_flag
3773: WHERE payment_term_id = NVL(x_payment_term_id ,payment_term_id )

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

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