DBA Data[Home] [Help]

APPS.PN_EXP_TO_AP dependencies on PN_EXP_TO_AP

Line 1: PACKAGE BODY pn_exp_to_ap AS

1: PACKAGE BODY pn_exp_to_ap AS
2: -- $Header: PNTXPMTB.pls 120.16.12020000.2 2012/06/29 08:52:03 ppenumar ship $
3:
4: -------------------------------------------------------------------
5: -- For loading PN's Invoice Info into AP's Interface Tables

Line 57: pn_exp_to_ap.get_liability_acc(pi.payment_term_id,

53: pi.rate,
54: pi.ap_invoice_num,
55: pt.payment_purpose_code,
56: pt.payment_term_type_code,
57: pn_exp_to_ap.get_liability_acc(pi.payment_term_id,
58: pi.vendor_id,
59: pi.vendor_site_id) as lia_account,
60: pt.legal_entity_id as legal_entity_id,
61: decode(UPPER(PNP_UTIL_FUNC.check_conversion_type('''||l_func_curr_code||''',pn_mo_cache_utils.get_current_org_id))

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 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 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 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 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 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 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 2621: END PN_EXP_TO_AP;

2617: RAISE;
2618:
2619: END EXP_TO_AP;
2620:
2621: END PN_EXP_TO_AP;