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_RECONCILIATION_PKG dependencies on AP_RECONCILIATION_PKG

Line 1: PACKAGE BODY AP_RECONCILIATION_PKG as

1: PACKAGE BODY AP_RECONCILIATION_PKG as
2: /* $Header: apreconb.pls 120.35 2011/07/25 09:07:59 inanaiah ship $ */
3:
4: --============================================================================
5: -- POSSIBLE SCENARIOS ON HOW THIS API MAY BE CALLED:

Line 82: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECONCILIATION_PKG.';

78: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
79: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
80: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
82: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECONCILIATION_PKG.';
83:
84: /* *************************************************************************
85: * RECON_PAYMENT_HISTORY : Reconciliation API to clear or reconcile a *
86: * check. Transaction amount parameter though is not used for actual *

Line 129: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_HISTORY' ;

125: l_api_name CONSTANT VARCHAR2(1000) := 'Recon_Payment_History' ;
126: BEGIN
127:
128: current_calling_sequence := X_CALLING_SEQUENCE ||
129: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_HISTORY' ;
130:
131: -- Check if all required data is passed
132: ----------------------------------------------------------------
133: l_debug_info := 'Check for required info';

Line 166: AP_RECONCILIATION_PKG.Recon_Payment_Maturity

162: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
163: END IF;
164: ---------------------------------------------------------------
165:
166: AP_RECONCILIATION_PKG.Recon_Payment_Maturity
167: ( X_CHECK_ID,
168: X_ACCOUNTING_DATE,
169: X_TRANSACTION_TYPE,
170: X_TRANSACTION_AMOUNT,

Line 193: AP_RECONCILIATION_PKG.Recon_Payment_Clearing

189: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
191: END IF;
192: ---------------------------------------------------------------
193: AP_RECONCILIATION_PKG.Recon_Payment_Clearing
194: ( X_CHECKRUN_ID,
195: X_CHECK_ID,
196: X_ACCOUNTING_DATE,
197: X_CLEARED_DATE,

Line 226: AP_RECONCILIATION_PKG.Recon_Payment_Unclearing

222: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
224: END IF;
225: ---------------------------------------------------------------
226: AP_RECONCILIATION_PKG.Recon_Payment_Unclearing
227: ( X_CHECKRUN_ID,
228: X_CHECK_ID,
229: X_ACCOUNTING_DATE,
230: X_TRANSACTION_TYPE,

Line 299: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_MATURITY' ;

295: l_exchange_rate_type AP_CHECKS_ALL.EXCHANGE_RATE_TYPE%TYPE;
296: -- bug 9069767 ends
297: BEGIN
298: current_calling_sequence := X_CALLING_SEQUENCE ||
299: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_MATURITY' ;
300:
301: IF (x_transaction_type IN ('PAYMENT MATURITY', -- Bug3343314
302: 'PAYMENT MATURITY REVERSAL')) THEN -- Bug3343314
303:

Line 387: AP_RECONCILIATION_PKG.Insert_Payment_History

383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
384: END IF;
385: ---------------------------------------------------------------
386:
387: AP_RECONCILIATION_PKG.Insert_Payment_History
388: ( X_CHECK_ID => X_CHECK_ID,
389: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
390: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
391: X_TRX_BANK_AMOUNT => NULL,

Line 457: 'AP_RECONCILIATION_PKG.DELETE_PAYMENT_MATURITY' ;

453: l_api_name CONSTANT VARCHAR2(1000) := 'Delete_Payment_Maturity' ;
454:
455: BEGIN
456: current_calling_sequence := X_CALLING_SEQUENCE ||
457: 'AP_RECONCILIATION_PKG.DELETE_PAYMENT_MATURITY' ;
458: ----------------------------------------------------------------
459: l_debug_info := 'Deleting from Payment History table';
460: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
461: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 611: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_CLEARING' ;

607: ORDER BY nvl(c.amount,0);
608:
609: BEGIN
610: current_calling_sequence := X_CALLING_SEQUENCE ||
611: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_CLEARING' ;
612:
613:
614: --bugfix:5623562
615: --bug 5674397. Comment the following section

Line 962: AP_RECONCILIATION_PKG.Insert_Payment_History

958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
959: END IF;
960: ---------------------------------------------------------------
961:
962: AP_RECONCILIATION_PKG.Insert_Payment_History
963: ( X_CHECK_ID => l_check_id,
964: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
965: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
966: X_TRX_BANK_AMOUNT => l_trx_base_amount,

Line 1029: AP_RECONCILIATION_PKG.Insert_Payment_History

1025: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1026: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1027: END IF;
1028: ---------------------------------------------------------------
1029: AP_RECONCILIATION_PKG.Insert_Payment_History
1030: ( X_CHECK_ID => l_check_id,
1031: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1032: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1033: X_TRX_BANK_AMOUNT => l_check_amount

Line 1087: AP_RECONCILIATION_PKG.Insert_Payment_History

1083: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1084: END IF;
1085: ---------------------------------------------------------------
1086:
1087: AP_RECONCILIATION_PKG.Insert_Payment_History
1088: ( X_CHECK_ID => l_check_id,
1089: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1090: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1091: X_TRX_BANK_AMOUNT => l_check_amount

Line 1443: AP_RECONCILIATION_PKG.Insert_Payment_History

1439: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1440: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1441: END IF;
1442: ---------------------------------------------------------------
1443: AP_RECONCILIATION_PKG.Insert_Payment_History
1444: ( X_CHECK_ID => X_check_id,
1445: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1446: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1447: X_TRX_BANK_AMOUNT => l_trx_base_amount,

Line 1506: AP_RECONCILIATION_PKG.Insert_Payment_History

1502: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1503: END IF;
1504: ---------------------------------------------------------------
1505:
1506: AP_RECONCILIATION_PKG.Insert_Payment_History
1507: ( X_CHECK_ID => X_check_id,
1508: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1509: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1510: X_TRX_BANK_AMOUNT => l_check_amount

Line 1564: AP_RECONCILIATION_PKG.Insert_Payment_History

1560: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1561: END IF;
1562: ---------------------------------------------------------------
1563:
1564: AP_RECONCILIATION_PKG.Insert_Payment_History
1565: ( X_CHECK_ID => X_check_id,
1566: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1567: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1568: X_TRX_BANK_AMOUNT => l_check_amount

Line 1866: X_CALLING_SEQUENCE || 'AP_RECONCILIATION_PKG.recon_payment_unclearing';

1862:
1863: BEGIN
1864:
1865: current_calling_sequence :=
1866: X_CALLING_SEQUENCE || 'AP_RECONCILIATION_PKG.recon_payment_unclearing';
1867:
1868:
1869: IF (X_CHECKRUN_ID IS NOT NULL) THEN
1870:

Line 1940: AP_RECONCILIATION_PKG.insert_payment_history

1936: END IF;
1937: ---------------------------------------------------------------
1938:
1939:
1940: AP_RECONCILIATION_PKG.insert_payment_history
1941: (
1942: X_CHECK_ID => l_check_id,
1943: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1944: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,

Line 2094: AP_RECONCILIATION_PKG.Insert_Payment_History

2090: FROM ap_payment_history APHB
2091: WHERE APHB.check_id = APHA.check_id
2092: AND APHB.rev_pmt_hist_id = APHA.payment_history_id);
2093:
2094: AP_RECONCILIATION_PKG.Insert_Payment_History
2095: (
2096: X_CHECK_ID => X_check_id,
2097: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
2098: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,

Line 2228: 'AP_RECONCILIATION_PKG.insert_payment_history<-'||X_Calling_Sequence;

2224: BEGIN
2225: -- Update the calling sequence
2226: --
2227: current_calling_sequence :=
2228: 'AP_RECONCILIATION_PKG.insert_payment_history<-'||X_Calling_Sequence;
2229:
2230: -- Bug 3343314
2231: ---------------------------------------------------------------
2232: -- Create accounting event if event id is null

Line 2688: END AP_RECONCILIATION_PKG;

2684:
2685: END CASE_TYPE;
2686:
2687:
2688: END AP_RECONCILIATION_PKG;