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.AP_ISP_UTILITIES_PKG dependencies on AP_ISP_UTILITIES_PKG

Line 1: PACKAGE BODY AP_ISP_UTILITIES_PKG AS

1: PACKAGE BODY AP_ISP_UTILITIES_PKG AS
2: /* $Header: apisputb.pls 120.27.12010000.3 2009/01/23 10:03:35 manjayar ship $ */
3:
4: --added the below FND_LOG related variables, in order
5: --to enable LOGGING for this package.

Line 13: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_ISP_UTILITIES_PKG.';

9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_ISP_UTILITIES_PKG.';
14:
15: g_inv_sysdate CONSTANT DATE := TRUNC(SYSDATE);
16:
17:

Line 564: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.CANCEL_SINGLE_INVOICE<-' ||

560: l_api_name VARCHAR2(50);
561: l_org_id NUMBER;
562:
563: BEGIN
564: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.CANCEL_SINGLE_INVOICE<-' ||
565: P_calling_sequence;
566:
567: l_api_name := 'cancel_single_invoice';
568: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.CANCEL_SINGLE_INVOICE(+)');

565: P_calling_sequence;
566:
567: l_api_name := 'cancel_single_invoice';
568: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.CANCEL_SINGLE_INVOICE(+)');
570: END IF;
571:
572: l_debug_info := 'calling ap_cancel_pkg.ap_cancel_single_invoice()...';
573: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 682: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.discard_inv_line <- ' ||

678: l_result NUMBER;
679:
680: BEGIN
681:
682: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.discard_inv_line <- ' ||
683: p_calling_sequence;
684:
685: l_api_name := 'discard_inv_line';
686: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 687: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.discard_inv_line(+)');

683: p_calling_sequence;
684:
685: l_api_name := 'discard_inv_line';
686: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.discard_inv_line(+)');
688: END IF;
689:
690: l_debug_info := 'get invoice line info...';
691: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 796: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.invoke_ap_workflow <- ' ||

792: l_invoice_description VARCHAR2(240);
793: l_supplier_role VARCHAR2(320);
794: BEGIN
795:
796: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.invoke_ap_workflow <- ' ||
797: p_calling_sequence;
798:
799: l_api_name := 'invoke_ap_workflow';
800: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 801: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.invoke_ap_workflow(+)');

797: p_calling_sequence;
798:
799: l_api_name := 'invoke_ap_workflow';
800: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.invoke_ap_workflow(+)');
802: END IF;
803:
804: --
805: -- Creating a workflow process

Line 953: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.override_tax <- ' ||

949: l_result BOOLEAN;
950:
951: BEGIN
952:
953: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.override_tax <- ' ||
954: p_calling_sequence;
955:
956: l_api_name := 'override_tax';
957: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 958: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.override_tax(+)');

954: p_calling_sequence;
955:
956: l_api_name := 'override_tax';
957: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
958: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.override_tax(+)');
959: END IF;
960:
961: l_debug_info := 'calling AP_ETAX_SERVICES_PKG.Override_Tax: '
962: ||' P_invoice_id = ' || p_invoice_id

Line 1031: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_payment_terms <- ' ||

1027: l_terms_date DATE;
1028:
1029: BEGIN
1030:
1031: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_payment_terms <- ' ||
1032: p_calling_sequence;
1033:
1034: l_api_name := 'populate_payment_terms';
1035: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1036: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.populate_payment_terms(+)');

1032: p_calling_sequence;
1033:
1034: l_api_name := 'populate_payment_terms';
1035: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1036: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.populate_payment_terms(+)');
1037: END IF;
1038:
1039: get_payment_terms (p_invoice_id => p_invoice_id,
1040: p_terms_id => l_terms_id,

Line 1099: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_doc_sequence<- ' ||

1095: l_api_name VARCHAR2(50);
1096:
1097: BEGIN
1098:
1099: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_doc_sequence<- ' ||
1100: p_calling_sequence;
1101:
1102: l_api_name := 'populate_doc_sequence';
1103: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1104: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.populate_doc_sequence(+)');

1100: p_calling_sequence;
1101:
1102: l_api_name := 'populate_doc_sequence';
1103: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1104: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.populate_doc_sequence(+)');
1105: END IF;
1106:
1107: get_doc_sequence(
1108: p_invoice_id => p_invoice_id,

Line 1187: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header(+)');

1183:
1184: l_api_name := 'update_invoice_header';
1185:
1186: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1187: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header(+)');
1188: END IF;
1189:
1190: l_debug_info := 'Step 1. update invoice amount: invoice_id = ';
1191: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1376: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.create_distributions';

1372: WHERE AI.invoice_id = p_invoice_id
1373: AND AI.vendor_id = PV.vendor_id
1374: AND AI.vendor_site_id = PVS.vendor_site_id;
1375: BEGIN
1376: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.create_distributions';
1377:
1378: SELECT base_currency_code
1379: INTO l_base_currency_code
1380: FROM ap_system_parameters_all asp, ap_invoices_all ai

Line 1516: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header2(+)');

1512:
1513: l_api_name := 'update_invoice_header2';
1514:
1515: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1516: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header2(+)');
1517: END IF;
1518:
1519: -- Bug 6859035. Accounting date and period name are not getting
1520: -- stamped properly in invoice header and lines. In all the cases

Line 1649: IF (AP_ISP_UTILITIES_PKG.get_po_number_switcher(p_invoice_id) = 'UNMATCHED') THEN

1645: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1647: END IF;
1648:
1649: IF (AP_ISP_UTILITIES_PKG.get_po_number_switcher(p_invoice_id) = 'UNMATCHED') THEN
1650: SELECT asu.distribution_set_id
1651: INTO l_dist_set_id
1652: FROM ap_supplier_sites_all asu,
1653: ap_invoices_all ai

Line 1730: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.match_invoice_lines<- ' ||

1726: l_api_name VARCHAR2(50);
1727:
1728: BEGIN
1729:
1730: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.match_invoice_lines<- ' ||
1731: p_calling_sequence;
1732:
1733:
1734:

Line 1737: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.match_invoice_lines(+)');

1733:
1734:
1735: l_api_name := 'match_invoice_lines';
1736: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.match_invoice_lines(+)');
1738: END IF;
1739:
1740:
1741: OPEN invoice_lines_cur;

Line 1841: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.get_sec_attr_value <- ' ||

1837: l_api_name VARCHAR2(50);
1838:
1839: BEGIN
1840:
1841: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.get_sec_attr_value <- ' ||
1842: p_calling_sequence;
1843:
1844: l_api_name := 'get_sec_attr_value';
1845: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1847: l_api_name,'AP_ISP_UTILITIES_PKG.get_sec_attr_value(+)');

1843:
1844: l_api_name := 'get_sec_attr_value';
1845: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1846: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
1847: l_api_name,'AP_ISP_UTILITIES_PKG.get_sec_attr_value(+)');
1848: END IF;
1849:
1850: -- we are assuming the attr_code is ICX_SUPPLIER_ORG_ID
1851: -- still pass it to allow reusability

Line 2510: P_Calling_Sequence => 'AP_ISP_UTILITIES_PKG.DISCARD_AND_REMATCH');

2506: ap_matching_utils_pkg.Match_Invoice_Line(
2507: P_Invoice_Id => p_invoice_id,
2508: P_Invoice_Line_Number => l_line_rec.line_number,
2509: P_Overbill_Flag => 'N',
2510: P_Calling_Sequence => 'AP_ISP_UTILITIES_PKG.DISCARD_AND_REMATCH');
2511:
2512:
2513: end discard_and_rematch;
2514:

Line 2745: END AP_ISP_UTILITIES_PKG;

2741: END IF;
2742: --
2743: END;
2744:
2745: END AP_ISP_UTILITIES_PKG;