DBA Data[Home] [Help]

APPS.JAI_AR_TRX_LINES_PKG dependencies on FND_LOG

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

8: 1. 13-June-2012 qinglei 14040855 115.1 Created the initial version
9:
10: --------------------------------------------------------------------------------------------------------------*/
11:
12: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

9:
10: --------------------------------------------------------------------------------------------------------------*/
11:
12: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

10: --------------------------------------------------------------------------------------------------------------*/
11:
12: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

11:
12: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TRX_LINES_PKG.';

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

12: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TRX_LINES_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_LINES_PKG';

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

13: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TRX_LINES_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_LINES_PKG';
21:

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

14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TRX_LINES_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_LINES_PKG';
21:
22: PROCEDURE POPULATE_JAI_AR_LINES(pr_new t_rec%TYPE,

Line 139: FND_LOG.STRING(G_LEVEL_PROCEDURE,

135: FROM JAI_AR_TRXS
136: WHERE customer_trx_id = v_header_id;
137: BEGIN
138: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING(G_LEVEL_PROCEDURE,
140: G_MODULE_NAME || lv_api_name,
141: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
142: END IF;
143:

Line 380: FND_LOG.STRING(G_LEVEL_PROCEDURE,

376: END IF;
377: END LOOP;
378: END IF;
379: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(G_LEVEL_PROCEDURE,
381: G_MODULE_NAME || lv_api_name,
382: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
383: END IF;
384: EXCEPTION

Line 390: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

386: Pv_return_code := jai_constants.unexpected_error;
387: Pv_return_message := 'Encountered an error in ' || G_PACKAGE_NAME || '.' ||
388: lv_api_name || ' ' || substr(sqlerrm, 1, 1900);
389: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
390: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
391: G_MODULE_NAME || lv_api_name,
392: SUBSTR('Encountered an error in ' || G_PACKAGE_NAME || '.' ||
393: lv_api_name || ' ' || sqlerrm,
394: 1,

Line 591: FND_LOG.STRING(G_LEVEL_PROCEDURE,

587: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
588: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type;
589: BEGIN
590: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
591: FND_LOG.STRING(G_LEVEL_PROCEDURE,
592: G_MODULE_NAME || lv_api_name,
593: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
594: END IF;
595:

Line 957: FND_LOG.STRING(G_LEVEL_PROCEDURE,

953: END IF;
954: END IF;
955:
956: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
957: FND_LOG.STRING(G_LEVEL_PROCEDURE,
958: G_MODULE_NAME || lv_api_name,
959: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
960: END IF;
961: EXCEPTION

Line 970: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

966: sqlerrm,
967: 1,
968: 1996);
969: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
970: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
971: G_MODULE_NAME || lv_api_name,
972: SUBSTR('Encountered an error in ' || G_PACKAGE_NAME || '.' ||
973: lv_api_name || ' ' || sqlerrm,
974: 1,

Line 1164: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1160: (a.org_id is null and pr_new.org_id is null));
1161: BEGIN
1162:
1163: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1164: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1165: G_MODULE_NAME || lv_api_name,
1166: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1167: END IF;
1168:

Line 1363: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1359: RAISE le_error;
1360: END IF;
1361: END IF;
1362: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1363: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1364: G_MODULE_NAME || lv_api_name,
1365: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1366: END IF;
1367: EXCEPTION

Line 1521: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1517: ld_trx_date DATE;
1518: BEGIN
1519:
1520: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1521: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1522: G_MODULE_NAME || lv_api_name,
1523: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1524: END IF;
1525:

Line 1761: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1757: RAISE le_error;
1758: END IF;
1759: END IF;
1760: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1761: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1762: G_MODULE_NAME || lv_api_name,
1763: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1764: END IF;
1765: EXCEPTION

Line 1814: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1810:
1811: BEGIN
1812:
1813: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1814: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1815: G_MODULE_NAME || lv_api_name,
1816: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1817: END IF;
1818: pv_return_code := jai_constants.successful;

Line 1865: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1861: DELETE JAI_AR_TRX_LINES
1862: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
1863: AND CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
1864: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1866: G_MODULE_NAME || lv_api_name,
1867: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1868: END IF;
1869: EXCEPTION