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_MATCHING_UTILS_PKG dependencies on AP_MATCHING_UTILS_PKG

Line 1: PACKAGE BODY AP_MATCHING_UTILS_PKG AS

1: PACKAGE BODY AP_MATCHING_UTILS_PKG AS
2: /* $Header: apmtutlb.pls 120.49.12020000.5 2013/01/17 09:20:01 rnimmaka ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_MATCHING_UTILS_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_MATCHING_UTILS_PKG';

1: PACKAGE BODY AP_MATCHING_UTILS_PKG AS
2: /* $Header: apmtutlb.pls 120.49.12020000.5 2013/01/17 09:20:01 rnimmaka ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_MATCHING_UTILS_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_MATCHING_UTILS_PKG.';

16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_MATCHING_UTILS_PKG.';
21:
22: Procedure Initialize (
23: P_invoice_id IN NUMBER,
24: P_quick_po_id IN NUMBER DEFAULT NULL, --5386827

Line 524: current_calling_sequence := 'AP_MATCHING_UTILS_PKG.Match_Invoice_Line <-'||p_calling_sequence;

520:
521: BEGIN
522:
523: l_api_name := 'Match_Invoice_Line';
524: current_calling_sequence := 'AP_MATCHING_UTILS_PKG.Match_Invoice_Line <-'||p_calling_sequence;
525: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
526: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Match_Invoice_Line(+)');
527: END IF;
528:

Line 526: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Match_Invoice_Line(+)');

522:
523: l_api_name := 'Match_Invoice_Line';
524: current_calling_sequence := 'AP_MATCHING_UTILS_PKG.Match_Invoice_Line <-'||p_calling_sequence;
525: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
526: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Match_Invoice_Line(+)');
527: END IF;
528:
529: l_debug_info := 'Open Cursor Invoice_Lines_Cur';
530: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1159: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Upgrade_Po_Shipment(+)');

1155: BEGIN
1156:
1157: l_api_name := 'AP_Upgrade_Po_Shipment';
1158: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1159: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Upgrade_Po_Shipment(+)');
1160: END IF;
1161:
1162:
1163: l_debug_info := 'Get Total Quantity/Amount Financed for this shipment across all invoices';

Line 1288: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Upgrade_Po_Shipment(-)');

1284:
1285: END IF;
1286:
1287: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1288: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Upgrade_Po_Shipment(-)');
1289: END IF;
1290:
1291: EXCEPTION WHEN OTHERS THEN
1292: NULL;

Line 1415: l_curr_calling_sequence := 'AP_MATCHING_UTILS_PKG.AP_Recoup_Invoice_Line <-'||p_calling_sequence;

1411: l_amount_recouped := 0;
1412: l_is_line_locked := 'UNLOCKED';
1413:
1414: l_api_name := 'AP_Recoup_Invoice_Line';
1415: l_curr_calling_sequence := 'AP_MATCHING_UTILS_PKG.AP_Recoup_Invoice_Line <-'||p_calling_sequence;
1416:
1417: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1418: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Recoup_Invoice_Line(+)');
1419: END IF;

Line 1418: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Recoup_Invoice_Line(+)');

1414: l_api_name := 'AP_Recoup_Invoice_Line';
1415: l_curr_calling_sequence := 'AP_MATCHING_UTILS_PKG.AP_Recoup_Invoice_Line <-'||p_calling_sequence;
1416:
1417: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1418: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Recoup_Invoice_Line(+)');
1419: END IF;
1420:
1421:
1422: OPEN C_INVOICE_INFO (P_INVOICE_ID);

Line 1626: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Recoup_Invoice_Line(-)');

1622:
1623: END IF;
1624:
1625: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1626: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Ap_Recoup_Invoice_Line(-)');
1627: END IF;
1628:
1629: RETURN(TRUE);
1630:

Line 1868: l_current_calling_sequence := 'AP_Matching_Utils_Pkg.Match_To_Rcv_Shipment_Line <-' ||p_calling_sequence;

1864: l_current_calling_sequence VARCHAR2(2000);
1865:
1866: BEGIN
1867:
1868: l_current_calling_sequence := 'AP_Matching_Utils_Pkg.Match_To_Rcv_Shipment_Line <-' ||p_calling_sequence;
1869:
1870: l_debug_info := 'Get Invoice and Invoice Line info';
1871:
1872: SELECT ail.rcv_shipment_line_id,

Line 1953: AP_MATCHING_UTILS_PKG.Get_Recpt_Dist_Qty_Billed (

1949: delivered_txn_qty => l_delivered_txn_qty,
1950: returned_txn_qty => l_returned_txn_qty,
1951: corrected_txn_qty => l_corrected_txn_qty);
1952:
1953: AP_MATCHING_UTILS_PKG.Get_Recpt_Dist_Qty_Billed (
1954: l_rcv_transaction_id,
1955: l_po_distribution_id,
1956: l_billed_txn_qty);
1957:

Line 2017: AP_MATCHING_UTILS_PKG.Get_Recpt_Dist_Amt_Billed (

2013: p_po_distribution_id => l_po_distribution_id,
2014: x_delivered_amt => l_amount_delivered,
2015: x_corrected_amt => l_amount_corrected);
2016:
2017: AP_MATCHING_UTILS_PKG.Get_Recpt_Dist_Amt_Billed (
2018: l_rcv_transaction_id,
2019: l_po_distribution_id,
2020: l_amount_billed);
2021:

Line 2096: AP_MATCHING_UTILS_PKG.Get_receipt_Quantities(

2092: l_total_match_quantity = 0 OR l_total_match_amount = 0);
2093:
2094: IF (l_matching_basis = 'QUANTITY') THEN
2095:
2096: AP_MATCHING_UTILS_PKG.Get_receipt_Quantities(
2097: l_rcv_transaction_id,
2098: l_ordered_qty,
2099: l_cancelled_qty,
2100: l_received_qty,

Line 2362: l_current_calling_sequence := 'AP_Matching_Utils_Pkg. Get_qty_amt <-' ;

2358:
2359:
2360: BEGIN
2361:
2362: l_current_calling_sequence := 'AP_Matching_Utils_Pkg. Get_qty_amt <-' ;
2363: l_total_ordered_qty := 0;
2364: l_total_cancelled_qty := 0;
2365: l_total_billed_qty := 0;
2366: l_total_delivered_qty := 0;

Line 2384: AP_MATCHING_UTILS_PKG.Get_receipt_Quantities(

2380: EXIT WHEN C_Rcv_Transactions%NOTFOUND;
2381:
2382: IF (l_matching_basis = 'QUANTITY') THEN
2383:
2384: AP_MATCHING_UTILS_PKG.Get_receipt_Quantities(
2385: l_rcv_transaction_id,
2386: l_ordered_qty,
2387: l_cancelled_qty,
2388: l_received_qty,

Line 2552: l_current_calling_sequence := 'AP_Matching_Utils_Pkg.Is_Proj_Exp_Item_Date_Valid <-' ; -- Bug 14069839.

2548: l_current_calling_sequence VARCHAR2(2000); -- Bug 14069839.
2549:
2550: BEGIN
2551:
2552: l_current_calling_sequence := 'AP_Matching_Utils_Pkg.Is_Proj_Exp_Item_Date_Valid <-' ; -- Bug 14069839.
2553:
2554: l_api_name := 'Is_Proj_Exp_Item_Date_Valid';
2555: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Validate_Po_Match_Exp_Item_Date');

Line 2556: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Validate_Po_Match_Exp_Item_Date');

2552: l_current_calling_sequence := 'AP_Matching_Utils_Pkg.Is_Proj_Exp_Item_Date_Valid <-' ; -- Bug 14069839.
2553:
2554: l_api_name := 'Is_Proj_Exp_Item_Date_Valid';
2555: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_UTILS_PKG.Validate_Po_Match_Exp_Item_Date');
2557: END IF;
2558:
2559: l_debug_info := 'Open Cursor po_dists_cursor';
2560: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2630: END AP_MATCHING_UTILS_PKG;

2626: APP_EXCEPTION.RAISE_EXCEPTION;
2627:
2628: END Is_Proj_Exp_Item_Date_Valid;
2629:
2630: END AP_MATCHING_UTILS_PKG;
2631: