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_INVOICES_UTILITY_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 1: PACKAGE BODY AP_INVOICES_UTILITY_PKG AS

1: PACKAGE BODY AP_INVOICES_UTILITY_PKG AS
2: /* $Header: apinvutb.pls 120.79.12020000.6 2013/03/11 05:52:40 harsanan ship $ */
3:
4: /* bug 10425573 start*/
5: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 400: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE<-'||

396: debug_info VARCHAR2(100);
397:
398: BEGIN
399:
400: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE<-'||
401: X_calling_sequence;
402:
403: debug_info := 'Count for same vendor_id,party_site_id and invoice_num'; /*Bug9105666*/
404:

Line 870: l_retained_amt := ABS(AP_INVOICES_UTILITY_PKG.Get_retained_Total(

866: OR NVL(ail.invoice_includes_prepay_flag,'N') = 'Y');
867:
868: --Start 9503673
869: IF l_net_of_retainage_flag = 'Y' THEN
870: l_retained_amt := ABS(AP_INVOICES_UTILITY_PKG.Get_retained_Total(
871: l_invoice_id,l_org_id));
872: END IF;
873: --End 9503673
874:

Line 934: if (AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(l_invoice_id) = 0) then

930: if (NVL(l_payment_status_flag , 'N') <> 'Y') then --bug6598052
931: invoice_approval_status := 'UNPAID';
932: else
933: -- This prepayment is paid
934: if (AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(l_invoice_id) = 0) then
935: invoice_approval_status := 'FULL';
936: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN
937: invoice_approval_status := 'PERMANENT';
938: else

Line 936: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN

932: else
933: -- This prepayment is paid
934: if (AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(l_invoice_id) = 0) then
935: invoice_approval_status := 'FULL';
936: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN
937: invoice_approval_status := 'PERMANENT';
938: else
939: invoice_approval_status := 'AVAILABLE';
940: end if; -- end of check AP_INVOICES_UTILITY_PKG call

Line 940: end if; -- end of check AP_INVOICES_UTILITY_PKG call

936: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN
937: invoice_approval_status := 'PERMANENT';
938: else
939: invoice_approval_status := 'AVAILABLE';
940: end if; -- end of check AP_INVOICES_UTILITY_PKG call
941: end if; -- end of check l_payment_status_flag
942: elsif (invoice_approval_status = 'NEVER APPROVED') then
943: -- This prepayment in unapproved
944: invoice_approval_status := 'UNAPPROVED';

Line 1468: AND AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(ai.invoice_id) > 0;

1464: ai.org_id = l_org_id)
1465: OR l_org_id IS NULL)
1466: AND invoice_type_lookup_code = 'PREPAYMENT'
1467: AND earliest_settlement_date IS NOT NULL
1468: AND AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(ai.invoice_id) > 0;
1469:
1470: RETURN(prepay_count);
1471:
1472: END get_total_prepays;

Line 1526: AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(i.invoice_id);

1522: loop
1523: if(i.earliest_settlement_date<=(sysdate)) then
1524: l_prepay_amount_remaining:=0;
1525: l_prepay_amount_remaining:=
1526: AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(i.invoice_id);
1527: if(l_prepay_amount_remaining>0) then
1528: prepay_count:=prepay_count+1;
1529: end if;
1530: end if;

Line 1838: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||

1834: debug_info VARCHAR2(100);
1835:
1836: BEGIN
1837:
1838: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||
1839: P_calling_sequence;
1840:
1841: debug_info := 'Call AP IBY API';
1842:

Line 1854: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');

1850: x_vendor_site_id => p_vendor_site_id,
1851: x_payment_function => NULL,
1852: x_org_id => NULL,
1853: x_currency_code => NULL,
1854: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');
1855:
1856: IF l_ext_bank_acct_id IS NOT NULL THEN
1857: RETURN True;
1858: ELSE

Line 1905: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||

1901: debug_info VARCHAR2(100);
1902:
1903: BEGIN
1904:
1905: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||
1906: P_calling_sequence;
1907:
1908: debug_info := 'Call AP IBY API';
1909:

Line 1921: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');

1917: x_vendor_site_id => p_vendor_site_id,
1918: x_payment_function => NULL,
1919: x_org_id => NULL,
1920: x_currency_code => NULL,
1921: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');
1922:
1923: IF l_ext_bank_acct_id IS NOT NULL THEN
1924: RETURN True;
1925: ELSE

Line 2093: IF ( sign (AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied(

2089: IS
2090: l_flag varchar2(1) := 'N';
2091: BEGIN
2092:
2093: IF ( sign (AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied(
2094: P_invoice_id)) = 1 ) THEN
2095: l_flag := 'Y';
2096: ELSE
2097: l_flag := null;

Line 2814: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Round_Base_Amt ' ||

2810: AND ASP.org_id = AI.org_id;
2811:
2812: BEGIN
2813:
2814: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Round_Base_Amt ' ||
2815: X_calling_sequence;
2816:
2817: -------------------------------------------------------------
2818: debug_info := 'Round_Base_Amt - Open cursor invoice_cursor';

Line 3044: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_PQ_Corrections';

3040: debug_info VARCHAR2(240);
3041: l_return_var BOOLEAN := FALSE;
3042:
3043: BEGIN
3044: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_PQ_Corrections';
3045:
3046: -------------------------------------------------------------
3047: debug_info := 'Inv_With_PQ_Corrections - Open cursor';
3048: -------------------------------------------------------------

Line 3131: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_Prepayments';

3127: debug_info VARCHAR2(240);
3128: l_return_var BOOLEAN := FALSE;
3129:
3130: BEGIN
3131: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_Prepayments';
3132:
3133: -------------------------------------------------------------
3134: debug_info := 'Inv_With_Prepayments - Open cursor';
3135: -------------------------------------------------------------

Line 3218: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Invoice_Includes_Awt';

3214: debug_info VARCHAR2(240);
3215: l_return_var BOOLEAN := FALSE;
3216:
3217: BEGIN
3218: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Invoice_Includes_Awt';
3219:
3220: -------------------------------------------------------------
3221: debug_info := 'Invoice_Includes_Awt - Open cursor';
3222: -------------------------------------------------------------

Line 3305: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_Matched_Finally_Closed_Po';

3301: debug_info VARCHAR2(240);
3302: l_return_var BOOLEAN := FALSE;
3303:
3304: BEGIN
3305: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_Matched_Finally_Closed_Po';
3306:
3307: ------------------------------------------------------------
3308: debug_info := 'Open cursor to verify if the invoice is '||
3309: 'matched to a finally closed PO';

Line 3904: current_calling_sequence := 'AP_INVOICES_Utility_PKG.CHECK_GDF_VALID<-'||

3900: l_api_name CONSTANT VARCHAR2(200) := 'CHECK_GDF_VALID';
3901: l_debug_info VARCHAR2(1000);
3902:
3903: BEGIN
3904: current_calling_sequence := 'AP_INVOICES_Utility_PKG.CHECK_GDF_VALID<-'||
3905: P_calling_sequence;
3906:
3907: P_hold_reject_exists_flag := 'N';
3908: P_return_code := NULL;

Line 3915: IF (AP_INVOICES_UTILITY_PKG.FV_ENABLED) THEN

3911: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3912: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3913: END IF;
3914:
3915: IF (AP_INVOICES_UTILITY_PKG.FV_ENABLED) THEN
3916:
3917: IF(P_calling_mode = 'INV_IMP')THEN
3918: SELECT
3919: (CASE

Line 3986: END AP_INVOICES_UTILITY_PKG;

3982: END CHECK_GDF_VALID;
3983:
3984: --End Bug#13464635
3985:
3986: END AP_INVOICES_UTILITY_PKG;
3987: