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_EXP_TO_AP dependencies on PNP_DEBUG_PKG

Line 326: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (+)');

322: account_id NUMBER := NULL;
323:
324: BEGIN
325: -- ** uncomment the following for debugging **
326: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (+)');
327: -- PNP_DEBUG_PKG.log('p_payment_term_id: '||p_payment_term_id);
328: -- PNP_DEBUG_PKG.log('p_vendor_id: ' ||p_vendor_id);
329: -- PNP_DEBUG_PKG.log('p_vendor_site_id: ' ||p_vendor_site_id);
330:

Line 327: -- PNP_DEBUG_PKG.log('p_payment_term_id: '||p_payment_term_id);

323:
324: BEGIN
325: -- ** uncomment the following for debugging **
326: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (+)');
327: -- PNP_DEBUG_PKG.log('p_payment_term_id: '||p_payment_term_id);
328: -- PNP_DEBUG_PKG.log('p_vendor_id: ' ||p_vendor_id);
329: -- PNP_DEBUG_PKG.log('p_vendor_site_id: ' ||p_vendor_site_id);
330:
331: l_context := 'Getting account info for Payment term ID: '

Line 328: -- PNP_DEBUG_PKG.log('p_vendor_id: ' ||p_vendor_id);

324: BEGIN
325: -- ** uncomment the following for debugging **
326: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (+)');
327: -- PNP_DEBUG_PKG.log('p_payment_term_id: '||p_payment_term_id);
328: -- PNP_DEBUG_PKG.log('p_vendor_id: ' ||p_vendor_id);
329: -- PNP_DEBUG_PKG.log('p_vendor_site_id: ' ||p_vendor_site_id);
330:
331: l_context := 'Getting account info for Payment term ID: '
332: ||p_payment_term_id;

Line 329: -- PNP_DEBUG_PKG.log('p_vendor_site_id: ' ||p_vendor_site_id);

325: -- ** uncomment the following for debugging **
326: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (+)');
327: -- PNP_DEBUG_PKG.log('p_payment_term_id: '||p_payment_term_id);
328: -- PNP_DEBUG_PKG.log('p_vendor_id: ' ||p_vendor_id);
329: -- PNP_DEBUG_PKG.log('p_vendor_site_id: ' ||p_vendor_site_id);
330:
331: l_context := 'Getting account info for Payment term ID: '
332: ||p_payment_term_id;
333:

Line 345: -- PNP_DEBUG_PKG.log('account_id: '||account_id);

341: END LOOP;
342: END IF;
343:
344: -- ** uncomment the following for debugging **
345: -- PNP_DEBUG_PKG.log('account_id: '||account_id);
346: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (-)');
347:
348: RETURN account_id;
349:

Line 346: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (-)');

342: END IF;
343:
344: -- ** uncomment the following for debugging **
345: -- PNP_DEBUG_PKG.log('account_id: '||account_id);
346: -- PNP_DEBUG_PKG.log('pn_exp_to_ap.get_liability_acc (-)');
347:
348: RETURN account_id;
349:
350: EXCEPTION

Line 372: PNP_DEBUG_PKG.log('pn_exp_to_ap.populate_group_by_flags (+)');

368: --------------------------------------------------------------------------------
369: PROCEDURE populate_group_by_flags(p_grouping_rule_id IN NUMBER) IS
370:
371: BEGIN
372: PNP_DEBUG_PKG.log('pn_exp_to_ap.populate_group_by_flags (+)');
373: PNP_DEBUG_PKG.log('p_grouping_rule_id: '||p_grouping_rule_id);
374:
375: l_context := 'Populating group by flags for Grouping Rule ID: '
376: || p_grouping_rule_id;

Line 373: PNP_DEBUG_PKG.log('p_grouping_rule_id: '||p_grouping_rule_id);

369: PROCEDURE populate_group_by_flags(p_grouping_rule_id IN NUMBER) IS
370:
371: BEGIN
372: PNP_DEBUG_PKG.log('pn_exp_to_ap.populate_group_by_flags (+)');
373: PNP_DEBUG_PKG.log('p_grouping_rule_id: '||p_grouping_rule_id);
374:
375: l_context := 'Populating group by flags for Grouping Rule ID: '
376: || p_grouping_rule_id;
377:

Line 399: PNP_DEBUG_PKG.log('pn_exp_to_ap.populate_group_by_flags (-)');

395: END IF;
396:
397: END LOOP;
398:
399: PNP_DEBUG_PKG.log('pn_exp_to_ap.populate_group_by_flags (-)');
400:
401: EXCEPTION
402: WHEN others THEN
403: RAISE;

Line 423: PNP_DEBUG_PKG.log('pn_exp_to_ap.get_order_by_grpby (+)');

419: --------------------------------------------------------------------------------
420: PROCEDURE get_order_by_grpby IS
421:
422: BEGIN
423: PNP_DEBUG_PKG.log('pn_exp_to_ap.get_order_by_grpby (+)');
424:
425: l_context := 'Creating order by clause';
426:
427: IF l_grpby_INVOICENUM THEN

Line 443: PNP_DEBUG_PKG.log('pn_exp_to_ap.get_order_by_grpby (-)');

439: IF l_grpby_PAYTYPE THEN
440: l_order_by_clause_grpby := l_order_by_clause_grpby || ' , pt.payment_term_type_code ';
441: END IF;
442:
443: PNP_DEBUG_PKG.log('pn_exp_to_ap.get_order_by_grpby (-)');
444:
445: EXCEPTION
446: WHEN others THEN
447: RAISE;

Line 490: PNP_DEBUG_PKG.log('pn_exp_to_ap.bind_variables_to_cursor (+)');

486: p_cursor INTEGER) IS
487:
488: BEGIN
489:
490: PNP_DEBUG_PKG.log('pn_exp_to_ap.bind_variables_to_cursor (+)');
491:
492: dbms_sql.bind_variable
493: (p_cursor,'l_one',l_one );
494: dbms_sql.bind_variable

Line 584: PNP_DEBUG_PKG.log('pn_exp_to_ap.bind_variables_to_cursor (-)');

580: dbms_sql.bind_variable
581: (p_cursor,'l_grp_param',p_grp_param );
582: END IF;
583:
584: PNP_DEBUG_PKG.log('pn_exp_to_ap.bind_variables_to_cursor (-)');
585:
586:
587: EXCEPTION
588: WHEN FATAL_ERROR THEN

Line 707: PNP_DEBUG_PKG.log('pn_exp_to_ap.cache_exp_items (+)');

703:
704: l_index_2 NUMBER;
705:
706: BEGIN
707: PNP_DEBUG_PKG.log('pn_exp_to_ap.cache_exp_items (+)');
708:
709: l_context := 'Caching items for export to AP';
710:
711: -- init

Line 749: pnp_debug_pkg.log('Q_Payitem1:'||Q_Payitem1);

745:
746: l_cursor_2 := dbms_sql.open_cursor;
747: dbms_sql.parse(l_cursor_2, Q_Payitem1, dbms_sql.native);
748:
749: pnp_debug_pkg.log('Q_Payitem1:'||Q_Payitem1);
750:
751: bind_variables_to_cursor(p_lease_num_low,
752: p_lease_num_high,
753: p_sch_dt_low,

Line 934: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

930: IF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'Y' AND
931: (l_exp_cnt = 0 OR l_acc_cnt = 0) THEN
932:
933: fnd_message.set_name ('PN', 'PN_ALL_ACNT_DIST_MSG');
934: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
935: RAISE BAD_ITEM_EXCEPTION;
936:
937: ELSIF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'N' AND
938: l_exp_cnt = 0 THEN

Line 941: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

937: ELSIF NVL(exp_ap_cache(l_index).pn_normalize,'N') = 'N' AND
938: l_exp_cnt = 0 THEN
939:
940: fnd_message.set_name ('PN', 'PN_EXP_DIST_MSG');
941: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
942: RAISE BAD_ITEM_EXCEPTION;
943:
944: END IF;
945:

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

946: ELSIF UPPER(exp_ap_cache(l_index).conv_rate_type) = 'USER' AND
947: exp_ap_cache(l_index).conv_rate IS NULL THEN
948:
949: fnd_message.set_name ('PN', 'PN_CONV_RATE_REQD');
950: pnp_debug_pkg.put_log_msg(fnd_message.get);
951: RAISE BAD_ITEM_EXCEPTION;
952:
953: ELSIF l_grpby_INVOICENUM THEN
954: IF exp_ap_cache(l_index).pn_ap_invoice_num IS NOT NULL THEN

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

956: exp_ap_cache(l_index).pn_vendor_id,
957: exp_ap_cache(l_index).org_id)
958: LOOP
959: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');
960: pnp_debug_pkg.put_log_msg(fnd_message.get);
961: RAISE BAD_ITEM_EXCEPTION;
962: END LOOP;
963: FOR i IN c_inv_num_itf(exp_ap_cache(l_index).pn_ap_invoice_num,
964: exp_ap_cache(l_index).pn_vendor_id,

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

964: exp_ap_cache(l_index).pn_vendor_id,
965: exp_ap_cache(l_index).org_id)
966: LOOP
967: fnd_message.set_name ('PN', 'PN_INV_NUM_ALREADY_EXIST');
968: pnp_debug_pkg.put_log_msg(fnd_message.get);
969: RAISE BAD_ITEM_EXCEPTION;
970: END LOOP;
971: END IF;
972: END IF;

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

974: EXCEPTION
975: WHEN BAD_ITEM_EXCEPTION THEN
976: fnd_message.set_name ('PN','PN_EXPAP_ERR');
977: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
978: pnp_debug_pkg.put_log_msg(fnd_message.get);
979:
980: l_error_ctr := l_error_ctr + 1;
981:
982: exp_ap_cache.DELETE(l_index);

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

984:
985: WHEN OTHERS THEN
986: fnd_message.set_name ('PN','PN_EXPAP_ERR');
987: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
988: pnp_debug_pkg.put_log_msg(fnd_message.get);
989:
990: pnp_debug_pkg.put_log_msg(SQLERRM);
991: RAISE;
992: END;

Line 990: pnp_debug_pkg.put_log_msg(SQLERRM);

986: fnd_message.set_name ('PN','PN_EXPAP_ERR');
987: fnd_message.set_token ('ID',exp_ap_cache(l_index).pn_payment_item_id);
988: pnp_debug_pkg.put_log_msg(fnd_message.get);
989:
990: pnp_debug_pkg.put_log_msg(SQLERRM);
991: RAISE;
992: END;
993: END LOOP;
994:

Line 1001: PNP_DEBUG_PKG.log('pn_exp_to_ap.cache_exp_items (-)');

997: END IF;
998:
999: l_total_ctr := l_total_ctr + l_index - 1;
1000:
1001: PNP_DEBUG_PKG.log('pn_exp_to_ap.cache_exp_items (-)');
1002:
1003: EXCEPTION
1004: WHEN others THEN
1005: RAISE;

Line 1087: PNP_DEBUG_PKG.log('pn_exp_to_ap.group_and_export_items (+)');

1083: l_msg_exists BOOLEAN;
1084:
1085: BEGIN
1086:
1087: PNP_DEBUG_PKG.log('pn_exp_to_ap.group_and_export_items (+)');
1088:
1089: -- we already have the required items in the cache
1090:
1091: l_context := 'Exporting to AP with grouping';

Line 1098: pnp_debug_pkg.log('The number of items to be processed :' || l_count);

1094: l_next := 2;
1095: l_item_prcsed := 0;
1096: l_count := exp_ap_cache.COUNT;
1097:
1098: pnp_debug_pkg.log('The number of items to be processed :' || l_count);
1099:
1100: IF l_count < 1 THEN
1101: RETURN;
1102: END IF;

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

1301: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1302: fnd_message.set_token('INV_ID',l_invoice_id);
1303: fnd_message.set_token('INV_NUM',l_invoice_num);
1304: fnd_message.set_token('AMT',l_header_amount);
1305: pnp_debug_pkg.put_log_msg(fnd_message.get);
1306:
1307: PNP_DEBUG_PKG.put_log_msg(' ');
1308: -- now for the distributions
1309:

Line 1307: PNP_DEBUG_PKG.put_log_msg(' ');

1303: fnd_message.set_token('INV_NUM',l_invoice_num);
1304: fnd_message.set_token('AMT',l_header_amount);
1305: pnp_debug_pkg.put_log_msg(fnd_message.get);
1306:
1307: PNP_DEBUG_PKG.put_log_msg(' ');
1308: -- now for the distributions
1309:
1310: FOR item IN l_start .. l_next-1 LOOP
1311:

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

1461: fnd_message.set_token('NUM',l_invoice_num);
1462: fnd_message.set_token('ID',l_invoice_line_id);
1463: fnd_message.set_token('AMT',l_line_amount);
1464: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1465: pnp_debug_pkg.put_log_msg(fnd_message.get);
1466:
1467: END LOOP; -- for accrual_tab
1468:
1469: END IF; -- accrual entered if normalized

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

1550: fnd_message.set_token('NUM',l_invoice_num);
1551: fnd_message.set_token('ID',l_invoice_line_id);
1552: fnd_message.set_token('AMT',l_line_amount);
1553: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1554: pnp_debug_pkg.put_log_msg(fnd_message.get);
1555:
1556: END LOOP;
1557:
1558: END IF; -- expense a/c

Line 1576: pnp_debug_pkg.put_log_msg(errbuf);

1572:
1573: IF (SQL%NOTFOUND) then
1574: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');
1575: errbuf := fnd_message.get;
1576: pnp_debug_pkg.put_log_msg(errbuf);
1577: ROLLBACK;
1578: retcode := 2;
1579: RETURN;
1580: END IF;

Line 1598: pnp_debug_pkg.put_log_msg(errbuf);

1594:
1595: IF (SQL%NOTFOUND) then
1596: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');
1597: errbuf := fnd_message.get;
1598: pnp_debug_pkg.put_log_msg(errbuf);
1599: ROLLBACK;
1600: retcode := 2;
1601: RETURN;
1602: END IF;

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

1616: END LOOP;
1617: IF l_msg_exists THEN
1618: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');
1619: fnd_message.set_token('INV_NUM',l_invoice_num);
1620: pnp_debug_pkg.put_log_msg(fnd_message.get);
1621: ELSE
1622: pnp_debug_pkg.put_log_msg
1623: ('The system is unable to group and process items with invoice number '||
1624: l_invoice_num||

Line 1622: pnp_debug_pkg.put_log_msg

1618: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');
1619: fnd_message.set_token('INV_NUM',l_invoice_num);
1620: pnp_debug_pkg.put_log_msg(fnd_message.get);
1621: ELSE
1622: pnp_debug_pkg.put_log_msg
1623: ('The system is unable to group and process items with invoice number '||
1624: l_invoice_num||
1625: ' because some mandatory attributes do not match.');
1626: END IF;

Line 1633: pnp_debug_pkg.put_log_msg(errbuf);

1629: RAISE;
1630:
1631: WHEN OTHERS THEN
1632: errbuf := SQLERRM;
1633: pnp_debug_pkg.put_log_msg(errbuf);
1634: ROLLBACK;
1635: RAISE;
1636:
1637: END;

Line 1647: PNP_DEBUG_PKG.log('pn_exp_to_ap.group_and_export_items (-)');

1643: l_next := l_next + 1;
1644: END IF;
1645: END LOOP;
1646:
1647: PNP_DEBUG_PKG.log('pn_exp_to_ap.group_and_export_items (-)');
1648:
1649: EXCEPTION
1650: WHEN FATAL_ERROR THEN
1651: RAISE;

Line 1686: PNP_DEBUG_PKG.log('pn_exp_to_ap.export_items_nogrp (+)');

1682: l_header_amount NUMBER;
1683: l_line_amount NUMBER;
1684:
1685: BEGIN
1686: PNP_DEBUG_PKG.log('pn_exp_to_ap.export_items_nogrp (+)');
1687:
1688: /* we already have the required items in the cache */
1689:
1690: l_context := 'Exporting to AP with default functionality';

Line 1692: pnp_debug_pkg.log(' Exporting to AP with default functionality exp_ap_cache.COUNT:'||exp_ap_cache.COUNT);

1688: /* we already have the required items in the cache */
1689:
1690: l_context := 'Exporting to AP with default functionality';
1691:
1692: pnp_debug_pkg.log(' Exporting to AP with default functionality exp_ap_cache.COUNT:'||exp_ap_cache.COUNT);
1693:
1694: FOR item IN 1..exp_ap_cache.COUNT LOOP
1695:
1696: l_total_exp_amt := 0;

Line 1782: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');

1778: l_lineNumber := 0;
1779:
1780: l_context := 'Inserting into ap_invoices_interface ...';
1781:
1782: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');
1783:
1784: fnd_currency.get_info(exp_ap_cache(item).pn_export_currency_code,
1785: l_precision,
1786: l_ext_precision,

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

1848: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1849: fnd_message.set_token('INV_ID',l_invoice_id);
1850: fnd_message.set_token('INV_NUM',l_invoice_num);
1851: fnd_message.set_token('AMT',l_header_amount);
1852: pnp_debug_pkg.put_log_msg(fnd_message.get);
1853:
1854: PNP_DEBUG_PKG.put_log_msg(' ');
1855: /* Create a line for accrual amount if the term is normalized */
1856:

Line 1854: PNP_DEBUG_PKG.put_log_msg(' ');

1850: fnd_message.set_token('INV_NUM',l_invoice_num);
1851: fnd_message.set_token('AMT',l_header_amount);
1852: pnp_debug_pkg.put_log_msg(fnd_message.get);
1853:
1854: PNP_DEBUG_PKG.put_log_msg(' ');
1855: /* Create a line for accrual amount if the term is normalized */
1856:
1857: IF (nvl(exp_ap_cache(item).pn_normalize,'N') = 'Y' AND
1858: nvl(exp_ap_cache(item).pn_send_entries,'Y') = 'Y') THEN

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

1925: fnd_message.set_token('NUM',l_invoice_num);
1926: fnd_message.set_token('ID',l_invoice_line_id);
1927: fnd_message.set_token('AMT',l_line_amount);
1928: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1929: pnp_debug_pkg.put_log_msg(fnd_message.get);
1930:
1931: END LOOP; -- for accrual_tab
1932: END IF; -- accrual entered if normalized
1933:

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

2014: fnd_message.set_token('NUM',l_invoice_num);
2015: fnd_message.set_token('ID',l_invoice_line_id);
2016: fnd_message.set_token('AMT',l_line_amount);
2017: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
2018: pnp_debug_pkg.put_log_msg(fnd_message.get);
2019:
2020: END LOOP;
2021: END IF; -- expense a/c
2022:

Line 2068: PNP_DEBUG_PKG.log('pn_exp_to_ap.export_items_nogrp (-)');

2064:
2065: END IF;
2066: END LOOP; -- for item in
2067:
2068: PNP_DEBUG_PKG.log('pn_exp_to_ap.export_items_nogrp (-)');
2069: EXCEPTION
2070: WHEN others THEN
2071: RAISE;
2072:

Line 2200: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (+)');

2196: l_set_of_books_id NUMBER;
2197:
2198: BEGIN
2199:
2200: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (+)');
2201:
2202: l_context := 'Getting functional currency code';
2203:
2204: l_set_of_books_id :=

Line 2340: PNP_DEBUG_PKG.log(l_context);

2336:
2337: IF l_processing_level_ctr = 1 THEN
2338: -- item level
2339: l_context := 'Processing items with Grouping Rule at Item level (+)';
2340: PNP_DEBUG_PKG.log(l_context);
2341:
2342: FOR grp IN get_grp_rule_item LOOP
2343: -- get group rule id
2344: l_id := grp.grouping_rule_id;

Line 2358: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );

2354: l_order_by_clause ||
2355: l_order_by_clause_grpby ||
2356: ' , lia_account';
2357:
2358: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2359:
2360: -- get items
2361: cache_exp_items (
2362: p_lease_num_low ,

Line 2386: PNP_DEBUG_PKG.log(l_context);

2382: l_param_where_clause);
2383: END LOOP;
2384:
2385: l_context := 'Processing items with Grouping Rule at Item level (-)';
2386: PNP_DEBUG_PKG.log(l_context);
2387:
2388: ELSIF l_processing_level_ctr = 2 THEN
2389: -- term level
2390: l_context := 'Processing items with Grouping Rule at Term level (+)';

Line 2391: PNP_DEBUG_PKG.log(l_context);

2387:
2388: ELSIF l_processing_level_ctr = 2 THEN
2389: -- term level
2390: l_context := 'Processing items with Grouping Rule at Term level (+)';
2391: PNP_DEBUG_PKG.log(l_context);
2392:
2393: FOR grp IN get_grp_rule_term LOOP
2394: -- get group rule id
2395: l_id := grp.grouping_rule_id;

Line 2409: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );

2405: l_order_by_clause ||
2406: l_order_by_clause_grpby||
2407: ' , lia_account';
2408:
2409: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2410:
2411: cache_exp_items (
2412: p_lease_num_low ,
2413: p_lease_num_high,

Line 2436: PNP_DEBUG_PKG.log(l_context);

2432:
2433: END LOOP;
2434:
2435: l_context := 'Processing items with Grouping Rule at Term level (-)';
2436: PNP_DEBUG_PKG.log(l_context);
2437:
2438: ELSIF l_processing_level_ctr = 3 THEN
2439: -- lease level
2440: l_context := 'Processing items with Grouping Rule at Lease level (+)';

Line 2441: PNP_DEBUG_PKG.log(l_context);

2437:
2438: ELSIF l_processing_level_ctr = 3 THEN
2439: -- lease level
2440: l_context := 'Processing items with Grouping Rule at Lease level (+)';
2441: PNP_DEBUG_PKG.log(l_context);
2442:
2443: FOR grp IN get_grp_rule_lease LOOP
2444: -- get group rule id
2445: l_id := grp.grouping_rule_id;

Line 2459: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );

2455: l_order_by_clause||
2456: l_order_by_clause_grpby||
2457: ' , lia_account';
2458:
2459: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2460:
2461: cache_exp_items (
2462: p_lease_num_low ,
2463: p_lease_num_high,

Line 2486: PNP_DEBUG_PKG.log(l_context);

2482:
2483: END LOOP;
2484:
2485: l_context := 'Processing items with Grouping Rule at Lease level (-)';
2486: PNP_DEBUG_PKG.log(l_context);
2487:
2488: ELSIF l_processing_level_ctr = 4 THEN
2489: -- system option level
2490: l_context := 'Processing items with Grouping Rule at System Option level (+)';

Line 2491: PNP_DEBUG_PKG.log(l_context);

2487:
2488: ELSIF l_processing_level_ctr = 4 THEN
2489: -- system option level
2490: l_context := 'Processing items with Grouping Rule at System Option level (+)';
2491: PNP_DEBUG_PKG.log(l_context);
2492:
2493: l_id := -1;
2494:
2495: FOR rec IN get_system_grouping_rule_id(pn_mo_cache_utils.get_current_org_id) LOOP

Line 2502: PNP_DEBUG_PKG.log(l_context);

2498:
2499: IF l_system_grouping_rule_id IS NULL THEN
2500: -- no grouping rule at system level
2501: l_context := 'Default functionality. No grouping rule exists';
2502: PNP_DEBUG_PKG.log(l_context);
2503:
2504: l_system_grouping_rule_id := -1;
2505:
2506: Q_Payitem := l_Select_Clause ||

Line 2511: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );

2507: l_param_where_clause ||
2508: l_where_clause_sysop ||
2509: l_order_by_clause_default;
2510:
2511: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2512:
2513: cache_exp_items (
2514: p_lease_num_low ,
2515: p_lease_num_high,

Line 2548: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );

2544: l_order_by_clause ||
2545: l_order_by_clause_grpby||
2546: ' , lia_account';
2547:
2548: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2549:
2550: cache_exp_items (
2551: p_lease_num_low ,
2552: p_lease_num_high,

Line 2575: PNP_DEBUG_PKG.log(l_context);

2571:
2572: END IF; -- if NOTFOUND
2573:
2574: l_context := 'Processing items with Grouping Rule at System Option level (-)';
2575: PNP_DEBUG_PKG.log(l_context);
2576:
2577: END IF; -- if l_processing_level_ctr
2578: END LOOP; -- for l_processing_level_ctr
2579:

Line 2582: pnp_debug_pkg.put_log_msg('

2578: END LOOP; -- for l_processing_level_ctr
2579:
2580: COMMIT;
2581:
2582: pnp_debug_pkg.put_log_msg('
2583: ===========================================================================');
2584: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2586: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2582: pnp_debug_pkg.put_log_msg('
2583: ===========================================================================');
2584: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2585: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2586: pnp_debug_pkg.put_log_msg(fnd_message.get);
2587:
2588: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2589: fnd_message.set_token ('NUM',l_error_ctr);
2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);
2594: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2590: pnp_debug_pkg.put_log_msg(fnd_message.get);
2591:
2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);
2594: pnp_debug_pkg.put_log_msg(fnd_message.get);
2595:
2596: pnp_debug_pkg.put_log_msg('
2597: ===========================================================================');
2598: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');

Line 2596: pnp_debug_pkg.put_log_msg('

2592: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2593: fnd_message.set_token ('NUM',l_total_ctr);
2594: pnp_debug_pkg.put_log_msg(fnd_message.get);
2595:
2596: pnp_debug_pkg.put_log_msg('
2597: ===========================================================================');
2598: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');
2599:
2600: EXCEPTION

Line 2598: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');

2594: pnp_debug_pkg.put_log_msg(fnd_message.get);
2595:
2596: pnp_debug_pkg.put_log_msg('
2597: ===========================================================================');
2598: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');
2599:
2600: EXCEPTION
2601: WHEN FATAL_ERROR THEN
2602: /* we should never get here */

Line 2603: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));

2599:
2600: EXCEPTION
2601: WHEN FATAL_ERROR THEN
2602: /* we should never get here */
2603: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));
2604: errbuf :=
2605: 'A system error occured. A most likely cause is some other process is updating'
2606: ||'the AP interface tables. Please run the export program again';
2607: pnp_debug_pkg.put_log_msg(errbuf);

Line 2607: pnp_debug_pkg.put_log_msg(errbuf);

2603: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));
2604: errbuf :=
2605: 'A system error occured. A most likely cause is some other process is updating'
2606: ||'the AP interface tables. Please run the export program again';
2607: pnp_debug_pkg.put_log_msg(errbuf);
2608: retcode := 2;
2609: ROLLBACK;
2610:
2611: WHEN OTHERS THEN

Line 2613: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));

2609: ROLLBACK;
2610:
2611: WHEN OTHERS THEN
2612: -- fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_PROBLEM');
2613: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));
2614: errbuf := SQLERRM;
2615: retcode := 2;
2616: ROLLBACK;
2617: RAISE;