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 1301: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

Line 1303: PNP_DEBUG_PKG.put_log_msg(' ');

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

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

1455: fnd_message.set_token('NUM',l_invoice_num);
1456: fnd_message.set_token('ID',l_invoice_line_id);
1457: fnd_message.set_token('AMT',l_line_amount);
1458: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1459: pnp_debug_pkg.put_log_msg(fnd_message.get);
1460:
1461: END LOOP; -- for accrual_tab
1462:
1463: END IF; -- accrual entered if normalized

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

1542: fnd_message.set_token('NUM',l_invoice_num);
1543: fnd_message.set_token('ID',l_invoice_line_id);
1544: fnd_message.set_token('AMT',l_line_amount);
1545: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1546: pnp_debug_pkg.put_log_msg(fnd_message.get);
1547:
1548: END LOOP;
1549:
1550: END IF; -- expense a/c

Line 1568: pnp_debug_pkg.put_log_msg(errbuf);

1564:
1565: IF (SQL%NOTFOUND) then
1566: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_FLAG_NOT_SET');
1567: errbuf := fnd_message.get;
1568: pnp_debug_pkg.put_log_msg(errbuf);
1569: ROLLBACK;
1570: retcode := 2;
1571: RETURN;
1572: END IF;

Line 1590: pnp_debug_pkg.put_log_msg(errbuf);

1586:
1587: IF (SQL%NOTFOUND) then
1588: fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_INFO_NOT_SET');
1589: errbuf := fnd_message.get;
1590: pnp_debug_pkg.put_log_msg(errbuf);
1591: ROLLBACK;
1592: retcode := 2;
1593: RETURN;
1594: END IF;

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

1608: END LOOP;
1609: IF l_msg_exists THEN
1610: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');
1611: fnd_message.set_token('INV_NUM',l_invoice_num);
1612: pnp_debug_pkg.put_log_msg(fnd_message.get);
1613: ELSE
1614: pnp_debug_pkg.put_log_msg
1615: ('The system is unable to group and process items with invoice number '||
1616: l_invoice_num||

Line 1614: pnp_debug_pkg.put_log_msg

1610: fnd_message.set_name('PN', 'PN_CANNOT_GRP_ON_INV');
1611: fnd_message.set_token('INV_NUM',l_invoice_num);
1612: pnp_debug_pkg.put_log_msg(fnd_message.get);
1613: ELSE
1614: pnp_debug_pkg.put_log_msg
1615: ('The system is unable to group and process items with invoice number '||
1616: l_invoice_num||
1617: ' because some mandatory attributes do not match.');
1618: END IF;

Line 1625: pnp_debug_pkg.put_log_msg(errbuf);

1621: RAISE;
1622:
1623: WHEN OTHERS THEN
1624: errbuf := SQLERRM;
1625: pnp_debug_pkg.put_log_msg(errbuf);
1626: ROLLBACK;
1627: RAISE;
1628:
1629: END;

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

1635: l_next := l_next + 1;
1636: END IF;
1637: END LOOP;
1638:
1639: PNP_DEBUG_PKG.log('pn_exp_to_ap.group_and_export_items (-)');
1640:
1641: EXCEPTION
1642: WHEN FATAL_ERROR THEN
1643: RAISE;

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

1674: l_header_amount NUMBER;
1675: l_line_amount NUMBER;
1676:
1677: BEGIN
1678: PNP_DEBUG_PKG.log('pn_exp_to_ap.export_items_nogrp (+)');
1679:
1680: /* we already have the required items in the cache */
1681:
1682: l_context := 'Exporting to AP with default functionality';

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

1680: /* we already have the required items in the cache */
1681:
1682: l_context := 'Exporting to AP with default functionality';
1683:
1684: pnp_debug_pkg.log(' Exporting to AP with default functionality exp_ap_cache.COUNT:'||exp_ap_cache.COUNT);
1685:
1686: FOR item IN 1..exp_ap_cache.COUNT LOOP
1687:
1688: l_total_exp_amt := 0;

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

1770: l_lineNumber := 0;
1771:
1772: l_context := 'Inserting into ap_invoices_interface ...';
1773:
1774: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');
1775:
1776: fnd_currency.get_info(exp_ap_cache(item).pn_export_currency_code,
1777: l_precision,
1778: l_ext_precision,

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

1836: fnd_message.set_name('PN','PN_EXPAP_HEAD_PARAM');
1837: fnd_message.set_token('INV_ID',l_invoice_id);
1838: fnd_message.set_token('INV_NUM',l_invoice_num);
1839: fnd_message.set_token('AMT',l_header_amount);
1840: pnp_debug_pkg.put_log_msg(fnd_message.get);
1841:
1842: PNP_DEBUG_PKG.put_log_msg(' ');
1843: /* Create a line for accrual amount if the term is normalized */
1844:

Line 1842: PNP_DEBUG_PKG.put_log_msg(' ');

1838: fnd_message.set_token('INV_NUM',l_invoice_num);
1839: fnd_message.set_token('AMT',l_header_amount);
1840: pnp_debug_pkg.put_log_msg(fnd_message.get);
1841:
1842: PNP_DEBUG_PKG.put_log_msg(' ');
1843: /* Create a line for accrual amount if the term is normalized */
1844:
1845: IF (nvl(exp_ap_cache(item).pn_normalize,'N') = 'Y' AND
1846: nvl(exp_ap_cache(item).pn_send_entries,'Y') = 'Y') THEN

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

1911: fnd_message.set_token('NUM',l_invoice_num);
1912: fnd_message.set_token('ID',l_invoice_line_id);
1913: fnd_message.set_token('AMT',l_line_amount);
1914: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
1915: pnp_debug_pkg.put_log_msg(fnd_message.get);
1916:
1917: END LOOP; -- for accrual_tab
1918: END IF; -- accrual entered if normalized
1919:

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

1998: fnd_message.set_token('NUM',l_invoice_num);
1999: fnd_message.set_token('ID',l_invoice_line_id);
2000: fnd_message.set_token('AMT',l_line_amount);
2001: fnd_message.set_token('PAY_ID',exp_ap_cache(item).pn_payment_item_id);
2002: pnp_debug_pkg.put_log_msg(fnd_message.get);
2003:
2004: END LOOP;
2005: END IF; -- expense a/c
2006:

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

2048:
2049: END IF;
2050: END LOOP; -- for item in
2051:
2052: PNP_DEBUG_PKG.log('pn_exp_to_ap.export_items_nogrp (-)');
2053: EXCEPTION
2054: WHEN others THEN
2055: RAISE;
2056:

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

2180: l_set_of_books_id NUMBER;
2181:
2182: BEGIN
2183:
2184: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (+)');
2185:
2186: l_context := 'Getting functional currency code';
2187:
2188: l_set_of_books_id :=

Line 2324: PNP_DEBUG_PKG.log(l_context);

2320:
2321: IF l_processing_level_ctr = 1 THEN
2322: -- item level
2323: l_context := 'Processing items with Grouping Rule at Item level (+)';
2324: PNP_DEBUG_PKG.log(l_context);
2325:
2326: FOR grp IN get_grp_rule_item LOOP
2327: -- get group rule id
2328: l_id := grp.grouping_rule_id;

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

2338: l_order_by_clause ||
2339: l_order_by_clause_grpby ||
2340: ' , lia_account';
2341:
2342: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2343:
2344: -- get items
2345: cache_exp_items (
2346: p_lease_num_low ,

Line 2370: PNP_DEBUG_PKG.log(l_context);

2366: l_param_where_clause);
2367: END LOOP;
2368:
2369: l_context := 'Processing items with Grouping Rule at Item level (-)';
2370: PNP_DEBUG_PKG.log(l_context);
2371:
2372: ELSIF l_processing_level_ctr = 2 THEN
2373: -- term level
2374: l_context := 'Processing items with Grouping Rule at Term level (+)';

Line 2375: PNP_DEBUG_PKG.log(l_context);

2371:
2372: ELSIF l_processing_level_ctr = 2 THEN
2373: -- term level
2374: l_context := 'Processing items with Grouping Rule at Term level (+)';
2375: PNP_DEBUG_PKG.log(l_context);
2376:
2377: FOR grp IN get_grp_rule_term LOOP
2378: -- get group rule id
2379: l_id := grp.grouping_rule_id;

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

2389: l_order_by_clause ||
2390: l_order_by_clause_grpby||
2391: ' , lia_account';
2392:
2393: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2394:
2395: cache_exp_items (
2396: p_lease_num_low ,
2397: p_lease_num_high,

Line 2420: PNP_DEBUG_PKG.log(l_context);

2416:
2417: END LOOP;
2418:
2419: l_context := 'Processing items with Grouping Rule at Term level (-)';
2420: PNP_DEBUG_PKG.log(l_context);
2421:
2422: ELSIF l_processing_level_ctr = 3 THEN
2423: -- lease level
2424: l_context := 'Processing items with Grouping Rule at Lease level (+)';

Line 2425: PNP_DEBUG_PKG.log(l_context);

2421:
2422: ELSIF l_processing_level_ctr = 3 THEN
2423: -- lease level
2424: l_context := 'Processing items with Grouping Rule at Lease level (+)';
2425: PNP_DEBUG_PKG.log(l_context);
2426:
2427: FOR grp IN get_grp_rule_lease LOOP
2428: -- get group rule id
2429: l_id := grp.grouping_rule_id;

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

2439: l_order_by_clause||
2440: l_order_by_clause_grpby||
2441: ' , lia_account';
2442:
2443: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2444:
2445: cache_exp_items (
2446: p_lease_num_low ,
2447: p_lease_num_high,

Line 2470: PNP_DEBUG_PKG.log(l_context);

2466:
2467: END LOOP;
2468:
2469: l_context := 'Processing items with Grouping Rule at Lease level (-)';
2470: PNP_DEBUG_PKG.log(l_context);
2471:
2472: ELSIF l_processing_level_ctr = 4 THEN
2473: -- system option level
2474: l_context := 'Processing items with Grouping Rule at System Option level (+)';

Line 2475: PNP_DEBUG_PKG.log(l_context);

2471:
2472: ELSIF l_processing_level_ctr = 4 THEN
2473: -- system option level
2474: l_context := 'Processing items with Grouping Rule at System Option level (+)';
2475: PNP_DEBUG_PKG.log(l_context);
2476:
2477: l_id := -1;
2478:
2479: FOR rec IN get_system_grouping_rule_id(pn_mo_cache_utils.get_current_org_id) LOOP

Line 2486: PNP_DEBUG_PKG.log(l_context);

2482:
2483: IF l_system_grouping_rule_id IS NULL THEN
2484: -- no grouping rule at system level
2485: l_context := 'Default functionality. No grouping rule exists';
2486: PNP_DEBUG_PKG.log(l_context);
2487:
2488: l_system_grouping_rule_id := -1;
2489:
2490: Q_Payitem := l_Select_Clause ||

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

2491: l_param_where_clause ||
2492: l_where_clause_sysop ||
2493: l_order_by_clause_default;
2494:
2495: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2496:
2497: cache_exp_items (
2498: p_lease_num_low ,
2499: p_lease_num_high,

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

2528: l_order_by_clause ||
2529: l_order_by_clause_grpby||
2530: ' , lia_account';
2531:
2532: PNP_DEBUG_PKG.log(' Q_Payitem : '|| Q_Payitem );
2533:
2534: cache_exp_items (
2535: p_lease_num_low ,
2536: p_lease_num_high,

Line 2559: PNP_DEBUG_PKG.log(l_context);

2555:
2556: END IF; -- if NOTFOUND
2557:
2558: l_context := 'Processing items with Grouping Rule at System Option level (-)';
2559: PNP_DEBUG_PKG.log(l_context);
2560:
2561: END IF; -- if l_processing_level_ctr
2562: END LOOP; -- for l_processing_level_ctr
2563:

Line 2566: pnp_debug_pkg.put_log_msg('

2562: END LOOP; -- for l_processing_level_ctr
2563:
2564: COMMIT;
2565:
2566: pnp_debug_pkg.put_log_msg('
2567: ===========================================================================');
2568: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2569: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2570: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2566: pnp_debug_pkg.put_log_msg('
2567: ===========================================================================');
2568: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_SUC');
2569: fnd_message.set_token ('NUM',(l_total_ctr - l_error_ctr));
2570: pnp_debug_pkg.put_log_msg(fnd_message.get);
2571:
2572: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2573: fnd_message.set_token ('NUM',l_error_ctr);
2574: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2570: pnp_debug_pkg.put_log_msg(fnd_message.get);
2571:
2572: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_FAIL');
2573: fnd_message.set_token ('NUM',l_error_ctr);
2574: pnp_debug_pkg.put_log_msg(fnd_message.get);
2575:
2576: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2577: fnd_message.set_token ('NUM',l_total_ctr);
2578: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2574: pnp_debug_pkg.put_log_msg(fnd_message.get);
2575:
2576: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2577: fnd_message.set_token ('NUM',l_total_ctr);
2578: pnp_debug_pkg.put_log_msg(fnd_message.get);
2579:
2580: pnp_debug_pkg.put_log_msg('
2581: ===========================================================================');
2582: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');

Line 2580: pnp_debug_pkg.put_log_msg('

2576: fnd_message.set_name ('PN','PN_EXPAP_PAY_PROC_TOT');
2577: fnd_message.set_token ('NUM',l_total_ctr);
2578: pnp_debug_pkg.put_log_msg(fnd_message.get);
2579:
2580: pnp_debug_pkg.put_log_msg('
2581: ===========================================================================');
2582: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');
2583:
2584: EXCEPTION

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

2578: pnp_debug_pkg.put_log_msg(fnd_message.get);
2579:
2580: pnp_debug_pkg.put_log_msg('
2581: ===========================================================================');
2582: PNP_DEBUG_PKG.log('pn_exp_to_ap.exp_to_ap (-)');
2583:
2584: EXCEPTION
2585: WHEN FATAL_ERROR THEN
2586: /* we should never get here */

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

2583:
2584: EXCEPTION
2585: WHEN FATAL_ERROR THEN
2586: /* we should never get here */
2587: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));
2588: errbuf :=
2589: 'A system error occured. A most likely cause is some other process is updating'
2590: ||'the AP interface tables. Please run the export program again';
2591: pnp_debug_pkg.put_log_msg(errbuf);

Line 2591: pnp_debug_pkg.put_log_msg(errbuf);

2587: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));
2588: errbuf :=
2589: 'A system error occured. A most likely cause is some other process is updating'
2590: ||'the AP interface tables. Please run the export program again';
2591: pnp_debug_pkg.put_log_msg(errbuf);
2592: retcode := 2;
2593: ROLLBACK;
2594:
2595: WHEN OTHERS THEN

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

2593: ROLLBACK;
2594:
2595: WHEN OTHERS THEN
2596: -- fnd_message.set_name('PN', 'PN_TRANSFER_TO_AP_PROBLEM');
2597: pnp_debug_pkg.LOG(SUBSTR(l_context,1,244));
2598: errbuf := SQLERRM;
2599: retcode := 2;
2600: ROLLBACK;
2601: RAISE;