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_APPROVAL_MATCHED_PKG dependencies on AP_APPROVAL_MATCHED_PKG

Line 1: PACKAGE BODY AP_APPROVAL_MATCHED_PKG AS

1: PACKAGE BODY AP_APPROVAL_MATCHED_PKG AS
2: /* $Header: aprmtchb.pls 120.84.12020000.11 2013/03/07 14:55:02 cmaredup ship $ */
3: --bug 9242891
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_APPROVAL_MATCHED_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

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

1: PACKAGE BODY AP_APPROVAL_MATCHED_PKG AS
2: /* $Header: aprmtchb.pls 120.84.12020000.11 2013/03/07 14:55:02 cmaredup ship $ */
3: --bug 9242891
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_APPROVAL_MATCHED_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_APPROVAL_MATCHED_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_APPROVAL_MATCHED_PKG.';
21: --bug 9242891
22:
23: /*===========================================================================
24: | Private (Non Public) Procedure Specifications

Line 469: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

465: BEGIN
466:
467: l_api_name := 'Exec_Matched_Variance_Checks'; --Bug 9242891
468:
469: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
470: p_calling_sequence;
471: --bug 9242891
472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks(+)');

Line 473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks(+)');

469: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
470: p_calling_sequence;
471: --bug 9242891
472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks(+)');
474: END IF; --bug 9242891
475:
476: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
477: g_debug_mode := 'Y';

Line 1625: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

1621: l_debug_info VARCHAR2(2000);
1622:
1623: BEGIN
1624:
1625: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
1626: p_calling_sequence;
1627:
1628: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
1629: g_debug_mode := 'Y';

Line 1888: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

1884: l_debug_info VARCHAR2(2000);
1885:
1886: BEGIN
1887:
1888: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
1889: p_calling_sequence;
1890:
1891: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
1892: g_debug_mode := 'Y';

Line 2323: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

2319:
2320:
2321: BEGIN
2322:
2323: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
2324: p_calling_sequence;
2325:
2326: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
2327: g_debug_mode := 'Y';

Line 3771: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc ||'<-'||

3767: l_debug_loc VARCHAR2(30) := 'Get_PO_Closed_Code';
3768: l_curr_calling_sequence VARCHAR2(2000);
3769: BEGIN
3770:
3771: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc ||'<-'||
3772: p_calling_sequence;
3773:
3774: SELECT PLL.closed_code
3775: INTO p_po_closed_code

Line 3815: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

3811: l_debug_loc VARCHAR2(30) := 'Inv_Has_Holds_Other_Than';
3812: l_curr_calling_sequence VARCHAR2(2000);
3813: BEGIN
3814:
3815: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
3816: p_calling_sequence;
3817:
3818: SELECT 'Y'
3819: INTO l_holds_exist

Line 3867: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

3863: l_debug_loc VARCHAR2(30) := 'Inv_Has_Unreleased_Holds';
3864: l_curr_calling_sequence VARCHAR2(2000);
3865: BEGIN
3866:
3867: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
3868: p_calling_sequence;
3869:
3870: SELECT 'Y'
3871: INTO l_holds_exist

Line 3919: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

3915: l_curr_calling_sequence VARCHAR2(2000);
3916: BEGIN
3917:
3918:
3919: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
3920: p_calling_sequence;
3921:
3922: SELECT ROUND(SUM(nvl(PD.quantity_delivered, 0)), 5)
3923: INTO p_qty_delivered

Line 3962: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

3958: l_debug_loc VARCHAR2(30) := 'Update_Final_Match_Flag';
3959: l_curr_calling_sequence VARCHAR2(2000);
3960: BEGIN
3961:
3962: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
3963: p_calling_sequence;
3964:
3965: UPDATE ap_invoice_distributions AID
3966: SET final_match_flag = p_final_match_flag

Line 4199: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

4195: -- End Bug 3489536
4196:
4197: BEGIN
4198:
4199: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
4200: p_calling_sequence;
4201:
4202: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
4203: g_debug_mode := 'Y';

Line 4539: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

4535: l_debug_info VARCHAR2(100);
4536:
4537: BEGIN
4538:
4539: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
4540: p_calling_sequence;
4541:
4542: IF g_debug_mode = 'Y' THEN
4543: l_debug_info := 'Check if Rec Exception Exists';

Line 4686: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

4682: AND AIL.corrected_inv_id <> p_invoice_id;
4683:
4684: BEGIN
4685:
4686: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
4687: p_calling_sequence;
4688:
4689: ---------------------------------------------------------
4690: l_debug_info := 'Check if invoice is a price correction';

Line 5062: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5058: l_corrected_invoice_id NUMBER;
5059:
5060: BEGIN
5061:
5062: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5063: p_calling_sequence;
5064:
5065: Calc_Shipment_Qty_Billed(
5066: p_invoice_id,

Line 5155: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5151: l_curr_calling_sequence VARCHAR2(2000);
5152:
5153: BEGIN
5154:
5155: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5156: p_calling_sequence;
5157:
5158: /*-----------------------------------------------------------------+
5159: | The Meaning fo the following query conditions indicates:- |

Line 5303: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5299:
5300: BEGIN
5301:
5302: l_debug_loc := 'Calc_Total_Shipment_Qty_Billed';
5303: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5304: p_calling_sequence;
5305:
5306: Calc_Shipment_Amt_Billed(
5307: p_invoice_id,

Line 5394: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5390:
5391: BEGIN
5392:
5393: l_debug_loc := 'Calc_Shipment_Amt_Billed';
5394: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5395: p_calling_sequence;
5396:
5397: /*-----------------------------------------------------------------+
5398: | The Meaning fo the following query conditions indicates:- |

Line 5529: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5525: l_freight_total NUMBER; -- 3488259 (3110072)
5526:
5527: BEGIN
5528:
5529: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5530: p_calling_sequence;
5531: --------------------------------------------------------
5532: l_debug_info := 'Calculate Shipment Total for the invoice';
5533: --------------------------------------------------------

Line 5695: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5691: l_curr_calling_sequence VARCHAR2(2000);
5692:
5693: BEGIN
5694:
5695: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5696: p_calling_sequence;
5697: ------------------------------------------------------------------
5698: l_debug_info := 'Calculate Shipment Total amount for the invoice';
5699: --------------------------------------------------------------=---

Line 5835: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5831: l_curr_calling_sequence VARCHAR2(2000);
5832:
5833: BEGIN
5834:
5835: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5836: p_calling_sequence;
5837:
5838: -------------------------------------------------------------------------
5839: l_debug_info := 'Calculate ERV total for Shipment/receipt in the invoice';

Line 5940: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

5936: rcv_total NUMBER; /*Added for Bug:14726598*/
5937:
5938: BEGIN
5939:
5940: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
5941: p_calling_sequence;
5942:
5943: ----------------------------------------------------------------
5944: l_debug_info := 'Calculate Base Shipment Total for the invoice';

Line 6168: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

6164: l_curr_calling_sequence VARCHAR2(2000);
6165:
6166: BEGIN
6167:
6168: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
6169: p_calling_sequence;
6170: ------------------------------------------------------------------
6171: l_debug_info := 'Calculate base Shipment amount for the invoice';
6172: ------------------------------------------------------------------

Line 6303: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

6299: l_check VARCHAR2(100);
6300:
6301: BEGIN
6302:
6303: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
6304: p_calling_sequence;
6305:
6306: BEGIN
6307: -- bug8704810

Line 6366: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

6362: l_msg_data varchar2(2000);
6363:
6364: BEGIN
6365:
6366: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
6367: p_calling_sequence;
6368:
6369: Print_Debug(l_debug_loc, 'exec_pay_when_paid_check - begin for invoice_id : '|| p_invoice_id);
6370:

Line 6445: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||

6441: l_msg_data varchar2(2000);
6442:
6443: BEGIN
6444:
6445: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
6446: p_calling_sequence;
6447:
6448: Print_Debug(l_debug_loc,'exec_po_deliverable_check - begin for invoice_id : '|| p_invoice_id);
6449:

Line 6515: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'AP.PLSQL.AP_APPROVAL_MATCHED_PKG'||p_api_name,p_debug_info);

6511: AP_Debug_Pkg.Print('Y', p_debug_info );
6512: END IF;
6513:
6514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6515: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'AP.PLSQL.AP_APPROVAL_MATCHED_PKG'||p_api_name,p_debug_info);
6516: END IF;
6517:
6518: END Print_Debug;
6519:

Line 6579: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||

6575:
6576:
6577: BEGIN
6578:
6579: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||
6580: l_debug_loc||'<-'||p_calling_sequence;
6581: Print_Debug(l_debug_loc, 'exec_partial_funds_check - begin for invoice_id :
6582: '|| p_invoice_id);
6583:

Line 6734: END AP_APPROVAL_MATCHED_PKG;

6730: END exec_partial_funds_check;
6731: --end for CLM project - bug 9494400
6732:
6733:
6734: END AP_APPROVAL_MATCHED_PKG;