APPS.AP_AIL_TABLE_HANDLER_PKG dependencies on AP_AIL_TABLE_HANDLER_PKG

Line 1: PACKAGE BODY AP_AIL_TABLE_HANDLER_PKG as

1: PACKAGE BODY AP_AIL_TABLE_HANDLER_PKG as
2: /* $Header: apilnthb.pls 120.14.12020000.2 2013/02/07 10:30:46 harsanan ship $ */
3:
4: -------------------------------------------------------------------
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_AIL_TABLE_HANDLER_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_AIL_TABLE_HANDLER_PKG';

1: PACKAGE BODY AP_AIL_TABLE_HANDLER_PKG as
2: /* $Header: apilnthb.pls 120.14.12020000.2 2013/02/07 10:30:46 harsanan ship $ */
3:
4: -------------------------------------------------------------------
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_AIL_TABLE_HANDLER_PKG';
6: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
7: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
8: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
9: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 21: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_AIL_TABLE_HANDLER_PKG.';

17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_AIL_TABLE_HANDLER_PKG.';
22:
23: PROCEDURE CHECK_UNIQUE (
24: P_ROWID VARCHAR2,
25: P_INVOICE_ID NUMBER,

Line 36: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE<-'

32:
33: BEGIN
34: -- Update the calling sequence
35:
36: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE<-'
37: ||p_Calling_Sequence;
38:
39: debug_info := 'Select from ap_invoice_lines_all';
40:

Line 252: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row<-'

248:
249: BEGIN
250: -- Update the calling sequence
251:
252: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row<-'
253: ||p_Calling_Sequence;
254:
255: -- Check for uniqueness of the distribution line number
256:

Line 257: AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(

253: ||p_Calling_Sequence;
254:
255: -- Check for uniqueness of the distribution line number
256:
257: AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(
258: p_Rowid,
259: p_Invoice_Id,
260: p_Line_Number,
261: 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row');

Line 261: 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row');

257: AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(
258: p_Rowid,
259: p_Invoice_Id,
260: p_Line_Number,
261: 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row');
262:
263: -- Figure out NOCOPY the dist_match_type (not passed from invoice w/b)
264:
265: IF (p_rcv_transaction_id IS NOT NULL AND

Line 1692: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Update_Row<-'

1688: debug_info VARCHAR2(100);
1689: BEGIN
1690: -- Update the calling sequence
1691:
1692: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Update_Row<-'
1693: ||p_Calling_Sequence;
1694:
1695: -- Check for uniqueness of the distribution line number
1696:

Line 1697: AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(

1693: ||p_Calling_Sequence;
1694:
1695: -- Check for uniqueness of the distribution line number
1696:
1697: AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(
1698: p_Rowid,
1699: p_Invoice_Id,
1700: p_Line_Number,
1701: 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');

Line 1701: 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');

1697: AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(
1698: p_Rowid,
1699: p_Invoice_Id,
1700: p_Line_Number,
1701: 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');
1702:
1703: debug_info := 'Update ap_invoice_lines_all';
1704:
1705: UPDATE AP_INVOICE_LINES_ALL

Line 1913: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Delete_Row<-' ||

1909: l_api_name CONSTANT VARCHAR2(200) := 'Delete_Row';
1910: BEGIN
1911: -- Update the calling sequence
1912:
1913: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Delete_Row<-' ||
1914: p_Calling_Sequence;
1915:
1916: debug_info := 'Delete from child entity ap_invoice_distributions_all';
1917: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1974: END AP_AIL_TABLE_HANDLER_PKG;

1970: APP_EXCEPTION.RAISE_EXCEPTION;
1971:
1972: END Delete_Row;
1973:
1974: END AP_AIL_TABLE_HANDLER_PKG;