DBA Data[Home] [Help]

APPS.AP_CUSTOM_INT_INV_PKG dependencies on FND_LOG

Line 7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3:
4: /*==========================================================================
5: Customize the Interest Calculation
6: *=====================================================================*/
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 8: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

4: /*==========================================================================
5: Customize the Interest Calculation
6: *=====================================================================*/
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

5: Customize the Interest Calculation
6: *=====================================================================*/
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

6: *=====================================================================*/
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
14: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'AP.PLSQL.AP_CUSTOM_INT_INV_PKG.';

Line 11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
14: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'AP.PLSQL.AP_CUSTOM_INT_INV_PKG.';
15:

Line 12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

8: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
14: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'AP.PLSQL.AP_CUSTOM_INT_INV_PKG.';
15:
16: PROCEDURE ap_custom_calculate_interest(

Line 13: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

9: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
14: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'AP.PLSQL.AP_CUSTOM_INT_INV_PKG.';
15:
16: PROCEDURE ap_custom_calculate_interest(
17:

Line 60: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

56: BEGIN
57:
58: debug_info := 'Start of ap_custom_calculate_interest';
59: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
60: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
61: END IF;
62:
63: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', l_country_code);
64:

Line 76: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

72:
73: debug_info := 'apcci Invoice_id: '||to_char(p_invoice_id) ||
74: ' Org_id: '|| l_org_id;
75: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
76: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
77: END IF;
78:
79: IF (FV_INSTALL.ENABLED (l_org_id)) THEN
80:

Line 94: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

90: P_interest_amount );
91:
92: debug_info := 'apcci FV Int Amt '||to_char(P_interest_amount);
93: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
94: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
95: END IF;
96:
97: ELSIF l_country_code = 'BR' then
98:

Line 121: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

117: AND payment_num = p_payment_num;
118:
119: debug_info := 'apcci Int Type '||l_interest_type;
120: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
121: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
122: END IF;
123:
124: debug_info := 'apcci Int Rate Amt '||to_char(l_interest_rate_amount);
125: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 126: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

122: END IF;
123:
124: debug_info := 'apcci Int Rate Amt '||to_char(l_interest_rate_amount);
125: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
126: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
127: END IF;
128:
129: l_interest_rate_amount := nvl(l_interest_rate_amount,0);
130: l_interest_period := nvl(l_interest_period,0);

Line 182: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

178: and object_type = 'PACKAGE BODY';
179:
180: debug_info := 'apcci calling JL_BR_INTEREST_HANDLING ';
181: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
182: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
183: END IF;
184:
185: c := dbms_sql.open_cursor; --bug8652516: Added X_Org_id
186: statement := 'BEGIN

Line 238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN P_INTEREST_AMOUNT := NULL;
236: debug_info := 'sqlcode: '|| sqlcode||' sqlerrm: '||sqlerrm;
237: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
239: END IF;
240: WHEN OTHERS THEN P_INTEREST_AMOUNT := NULL;
241: debug_info := 'sqlcode: '|| sqlcode||' sqlerrm: '||sqlerrm;
242: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 243: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

239: END IF;
240: WHEN OTHERS THEN P_INTEREST_AMOUNT := NULL;
241: debug_info := 'sqlcode: '|| sqlcode||' sqlerrm: '||sqlerrm;
242: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
244: END IF;
245: END;
246:
247: ELSE

Line 255: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

251: END IF;
252:
253: debug_info := 'apcci Int AMT 2 '||to_char(p_interest_amount);
254: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
255: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
256: END IF;
257:
258: END ap_custom_calculate_interest;
259: