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.50.12020000.6 2013/05/20 07:19:20 rseeta 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 568: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.CANCEL_SINGLE_INVOICE<-' ||

564: l_api_name VARCHAR2(50);
565: l_org_id NUMBER;
566:
567: BEGIN
568: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.CANCEL_SINGLE_INVOICE<-' ||
569: P_calling_sequence;
570:
571: l_api_name := 'cancel_single_invoice';
572: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

682: l_result NUMBER;
683:
684: BEGIN
685:
686: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.discard_inv_line <- ' ||
687: p_calling_sequence;
688:
689: l_api_name := 'discard_inv_line';
690: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

796: l_invoice_description VARCHAR2(240);
797: l_supplier_role VARCHAR2(320);
798: BEGIN
799:
800: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.invoke_ap_workflow <- ' ||
801: p_calling_sequence;
802:
803: l_api_name := 'invoke_ap_workflow';
804: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

953: l_result BOOLEAN;
954:
955: BEGIN
956:
957: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.override_tax <- ' ||
958: p_calling_sequence;
959:
960: l_api_name := 'override_tax';
961: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

1031: l_terms_date DATE;
1032:
1033: BEGIN
1034:
1035: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_payment_terms <- ' ||
1036: p_calling_sequence;
1037:
1038: l_api_name := 'populate_payment_terms';
1039: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

1105: l_api_name VARCHAR2(50);
1106:
1107: BEGIN
1108:
1109: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_doc_sequence<- ' ||
1110: p_calling_sequence;
1111:
1112: l_api_name := 'populate_doc_sequence';
1113: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1110: p_calling_sequence;
1111:
1112: l_api_name := 'populate_doc_sequence';
1113: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.populate_doc_sequence(+)');
1115: END IF;
1116:
1117: get_doc_sequence(
1118: p_invoice_id => p_invoice_id,

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

1202: l_api_name := 'update_invoice_header';
1203:
1204:
1205: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header(+)');
1207: END IF;
1208:
1209: l_debug_info := 'Step 1. update invoice amount: invoice_id = ';
1210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1460: WHERE AI.invoice_id = p_invoice_id
1461: AND AI.vendor_id = PV.vendor_id
1462: AND AI.vendor_site_id = PVS.vendor_site_id;
1463: BEGIN
1464: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.create_distributions';
1465:
1466: SELECT base_currency_code
1467: INTO l_base_currency_code
1468: FROM ap_system_parameters_all asp, ap_invoices_all ai

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

1621:
1622: l_api_name := 'update_invoice_header2';
1623:
1624: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header2(+)');
1626: END IF;
1627:
1628: -- Bug 6859035. Accounting date and period name are not getting
1629: -- stamped properly in invoice header and lines. In all the cases

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

1924: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1926: END IF;
1927:
1928: IF (AP_ISP_UTILITIES_PKG.get_po_number_switcher(p_invoice_id) = 'UNMATCHED') THEN
1929: SELECT asu.distribution_set_id
1930: INTO l_dist_set_id
1931: FROM ap_supplier_sites_all asu,
1932: ap_invoices_all ai

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

2018: l_api_name VARCHAR2(50);
2019:
2020: BEGIN
2021:
2022: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.match_invoice_lines<- ' ||
2023: p_calling_sequence;
2024:
2025:
2026:

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

2025:
2026:
2027: l_api_name := 'match_invoice_lines';
2028: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2029: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.match_invoice_lines(+)');
2030: END IF;
2031:
2032:
2033: OPEN invoice_lines_cur;

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

2129: l_api_name VARCHAR2(50);
2130:
2131: BEGIN
2132:
2133: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.get_sec_attr_value <- ' ||
2134: p_calling_sequence;
2135:
2136: l_api_name := 'get_sec_attr_value';
2137: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2135:
2136: l_api_name := 'get_sec_attr_value';
2137: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2138: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
2139: l_api_name,'AP_ISP_UTILITIES_PKG.get_sec_attr_value(+)');
2140: END IF;
2141:
2142: -- we are assuming the attr_code is ICX_SUPPLIER_ORG_ID
2143: -- still pass it to allow reusability

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

2808: ap_matching_utils_pkg.Match_Invoice_Line(
2809: P_Invoice_Id => p_invoice_id,
2810: P_Invoice_Line_Number => l_line_rec.line_number,
2811: P_Overbill_Flag => 'N',
2812: P_Calling_Sequence => 'AP_ISP_UTILITIES_PKG.DISCARD_AND_REMATCH');
2813:
2814:
2815: end discard_and_rematch;
2816:

Line 2837: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_requester';

2833: row_count INTEGER;
2834: l_curr_calling_sequence VARCHAR2(100);
2835: l_debug_info VARCHAR2(100);
2836: BEGIN
2837: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.populate_requester';
2838: -- bug16484805, added conditions on first_name, last_name and email
2839: -- using bind variables directly to the SQL
2840: --
2841: /* Removed code changes of bug 16484805, 9074429 for bug Bug 16772090 */

Line 3171: p_invoice_id, NULL, 'AP_ISP_UTILITIES_PKG.stop_approval.stop_approval');

3167: NULL;
3168: END;
3169:
3170: DUMMY := ap_workflow_pkg.stop_approval(
3171: p_invoice_id, NULL, 'AP_ISP_UTILITIES_PKG.stop_approval.stop_approval');
3172:
3173: END;
3174:
3175: FUNCTION unsubmit_switcher(

Line 3338: END AP_ISP_UTILITIES_PKG;

3334: WHEN OTHERS THEN
3335: RETURN 'N';
3336: END;
3337:
3338: END AP_ISP_UTILITIES_PKG;