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 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 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 1766: pnp_debug_pkg.debug('Get Amt; SchStrDt: '||l_sch_str_dt||', SchEndDt: '||l_sch_end_dt

1762: TO_CHAR(l_prorate_rule),
1763: l_act_amt,
1764: l_est_amt
1765: );
1766: pnp_debug_pkg.debug('Get Amt; SchStrDt: '||l_sch_str_dt||', SchEndDt: '||l_sch_end_dt
1767: ||', ActAmt: '||l_act_amt||', EstAmt: '||l_est_amt);
1768:
1769: l_first_last := 'Y';
1770:

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 1926: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_term_id :'||p_term_id);

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);
1930: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);

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

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);
1930: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1931: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);

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

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);
1930: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1931: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1932:

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

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);
1930: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1931: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1932:
1933: l_dist_change_id := NULL;

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

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);
1930: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1931: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1932:
1933: l_dist_change_id := NULL;
1934: l_prev_term_hist_id := NULL;

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

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);
1930: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_str_dt :'||p_eff_str_dt);
1931: pnp_debug_pkg.debug('create_hist_corr_upd - IN : p_eff_end_dt :'||p_eff_end_dt);
1932:
1933: l_dist_change_id := NULL;
1934: l_prev_term_hist_id := NULL;
1935: l_new_term_id := NULL;

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

1983: NVL(term_rec.salesrep_id, -9999) <> NVL(tlinfo.salesrep_id, -9999)) OR
1984: NVL(p_dist_changed, 0) > 0
1985: THEN
1986:
1987: pnp_debug_pkg.debug('create_hist_corr_upd : p_dist_changed :'||p_dist_changed);
1988: pnp_debug_pkg.debug('create_hist_corr_upd : term_altered_flag :'||tlinfo.term_altered_flag);
1989:
1990: IF NVL(p_dist_changed, 0) >= 0 THEN
1991:

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

1984: NVL(p_dist_changed, 0) > 0
1985: THEN
1986:
1987: pnp_debug_pkg.debug('create_hist_corr_upd : p_dist_changed :'||p_dist_changed);
1988: pnp_debug_pkg.debug('create_hist_corr_upd : term_altered_flag :'||tlinfo.term_altered_flag);
1989:
1990: IF NVL(p_dist_changed, 0) >= 0 THEN
1991:
1992: IF NVL(p_hist_dist_tab.count,0) <> 0 AND

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

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

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

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

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

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

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

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

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

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

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

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

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

2365: OPEN get_max_dist_change_id_cur(p_term_id);
2366: FETCH get_max_dist_change_id_cur INTO l_dist_change_id;
2367: CLOSE get_max_dist_change_id_cur;
2368:
2369: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- get_max_dist_change_id : '||l_dist_change_id);
2370:
2371: OPEN get_max_term_hist_id_cur(p_term_id);
2372: FETCH get_max_term_hist_id_cur INTO l_prev_term_hist_id;
2373: CLOSE get_max_term_hist_id_cur;

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

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

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

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

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

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

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

2624: END IF;
2625:
2626: IF p_change_mode = 'UPDATE' THEN
2627:
2628: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_str_dt : '||p_eff_str_dt);
2629: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_end_dt : '||p_eff_end_dt);
2630: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_str_dt : '||term_rec.start_date);
2631: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_end_dt : '||term_rec.end_date);
2632:

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

2625:
2626: IF p_change_mode = 'UPDATE' THEN
2627:
2628: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_str_dt : '||p_eff_str_dt);
2629: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- p_eff_end_dt : '||p_eff_end_dt);
2630: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_str_dt : '||term_rec.start_date);
2631: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- term_end_dt : '||term_rec.end_date);
2632:
2633: IF (p_eff_str_dt > term_rec.start_date AND

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3025: l_changed_flag := 'N';
3026:
3027: END IF;
3028:
3029: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);
3030: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3031: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3032: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3033:

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

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

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

3027: END IF;
3028:
3029: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);
3030: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3031: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3032: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3033:
3034: INSERT INTO pn_payment_terms_all
3035: (PAYMENT_TERM_ID

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

3028:
3029: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_term_id : '||l_term_id);
3030: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3031: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3032: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3033:
3034: INSERT INTO pn_payment_terms_all
3035: (PAYMENT_TERM_ID
3036: ,LAST_UPDATE_DATE

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

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

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

3260: l_insert_dist_hist := 'Y';
3261:
3262: END IF;
3263:
3264: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3265: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3266: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3267:
3268: INSERT INTO pn_distributions_all

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

3261:
3262: END IF;
3263:
3264: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3265: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3266: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3267:
3268: INSERT INTO pn_distributions_all
3269: (distribution_id

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

3262: END IF;
3263:
3264: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_id : '||l_dist_id);
3265: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_insert_dist_hist: '||l_insert_dist_hist);
3266: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. table.');
3267:
3268: INSERT INTO pn_distributions_all
3269: (distribution_id
3270: ,account_id

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

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

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

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

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

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

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;