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.JAI_AR_TRX_HEADERS_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_HEADERS_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_HEADERS_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_HEADERS_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_HEADERS_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_HEADERS_PKG';
21: FUNCTION check_reg_dealer(pn_customer_id NUMBER, pn_site_use_id NUMBER)

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_HEADERS_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_HEADERS_PKG';
21: FUNCTION check_reg_dealer(pn_customer_id NUMBER, pn_site_use_id NUMBER)
22: return boolean

Line 118: FND_LOG.STRING(G_LEVEL_PROCEDURE,

114: WHERE set_of_books_id = c_sob;
115: V_CURR CURR%ROWTYPE;
116: BEGIN
117: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.STRING(G_LEVEL_PROCEDURE,
119: G_MODULE_NAME || lv_api_name,
120: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
121: END IF;
122:

Line 140: FND_LOG.STRING(G_LEVEL_PROCEDURE,

136: INTO v_trans_type;
137: CLOSE transaction_type_cur;
138:
139: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
140: FND_LOG.STRING(G_LEVEL_PROCEDURE,
141: G_MODULE_NAME || lv_api_name,
142: 'v_trans_type = ' || v_trans_type);
143: END IF;
144:

Line 164: FND_LOG.STRING(G_LEVEL_PROCEDURE,

160: 'pr_new.LAST_UPDATED_BY = ' ||
161: pr_new.LAST_UPDATED_BY ||
162: 'pr_new.LAST_UPDATE_LOGIN = ' ||
163: pr_new.LAST_UPDATE_LOGIN;
164: FND_LOG.STRING(G_LEVEL_PROCEDURE,
165: G_MODULE_NAME || lv_api_name,
166: lv_debug_info);
167: END IF;
168:

Line 279: FND_LOG.STRING(G_LEVEL_PROCEDURE,

275: ', pr_new.LAST_UPDATED_BY = ' ||
276: pr_new.LAST_UPDATED_BY ||
277: ', pr_new.LEGAL_ENTITY_ID ' ||
278: pr_new.LEGAL_ENTITY_ID;
279: FND_LOG.STRING(G_LEVEL_PROCEDURE,
280: G_MODULE_NAME || lv_api_name,
281: lv_debug_info);
282: END IF;
283:

Line 337: FND_LOG.STRING(G_LEVEL_PROCEDURE,

333: pr_new.SHIP_TO_SITE_USE_ID);
334: END IF;
335:
336: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING(G_LEVEL_PROCEDURE,
338: G_MODULE_NAME || lv_api_name,
339: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
340: END IF;
341: EXCEPTION

Line 347: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

343: Pv_return_code := jai_constants.unexpected_error;
344: Pv_return_message := 'Encountered an error in JAI_AR_TRX_HEADERS_PKG.POPULATE_AR_TRXS. ' ||
345: substr(SQLERRM, 1, 1900);
346: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
347: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
348: G_MODULE_NAME || lv_api_name,
349: SUBSTR('Encountered an error in JAI_AR_TRX_HEADERS_PKG.POPULATE_AR_TRXS. ' ||
350: SQLERRM,
351: 1,

Line 497: FND_LOG.STRING(G_LEVEL_PROCEDURE,

493: WHERE trx_number = p_recurred_from_trx_number
494: AND NVL(batch_source_id, 0) = p_batch_source_id;
495: BEGIN
496: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(G_LEVEL_PROCEDURE,
498: G_MODULE_NAME || lv_api_name,
499: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
500: END IF;
501:

Line 765: FND_LOG.STRING(G_LEVEL_PROCEDURE,

761: WHERE customer_trx_id = v_header_id;
762: v_header_tax_amount := 0;
763:
764: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
765: FND_LOG.STRING(G_LEVEL_PROCEDURE,
766: G_MODULE_NAME || lv_api_name,
767: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
768: END IF;
769: EXCEPTION

Line 775: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

771: Pv_return_code := jai_constants.unexpected_error;
772: Pv_return_message := 'Encountered an error in JAI_AR_TRX_HEADERS_PKG.POPULATE_COPIED_TRANSACTIONS. ' ||
773: substr(SQLERRM, 1, 1900);
774: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
775: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
776: G_MODULE_NAME || lv_api_name,
777: SUBSTR('Encountered an error in JAI_AR_TRX_HEADERS_PKG.POPULATE_COPIED_TRANSACTIONS. ' ||
778: SQLERRM,
779: 1,

Line 814: FND_LOG.STRING(G_LEVEL_PROCEDURE,

810: lv_return_code VARCHAR2(100);
811: le_error EXCEPTION;
812: BEGIN
813: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
814: FND_LOG.STRING(G_LEVEL_PROCEDURE,
815: G_MODULE_NAME || lv_api_name,
816: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
817: END IF;
818: pv_return_code := jai_constants.successful;

Line 898: FND_LOG.STRING(G_LEVEL_PROCEDURE,

894: Set Trx_Number = pr_new.Trx_Number
895: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
896: END IF;
897: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING(G_LEVEL_PROCEDURE,
899: G_MODULE_NAME || lv_api_name,
900: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
901: END IF;
902: EXCEPTION

Line 1036: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1032: LV_PROCESS_FLAG VARCHAR2(2);
1033: LV_PROCESS_MESSAGE VARCHAR2(1998);
1034: BEGIN
1035: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1036: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1037: G_MODULE_NAME || lv_api_name,
1038: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1039: END IF;
1040: pv_return_code := jai_constants.successful;

Line 1319: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1315: END IF;
1316: END IF;
1317: END LOOP;
1318: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1319: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1320: G_MODULE_NAME || lv_api_name,
1321: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1322: END IF;
1323: EXCEPTION

Line 1339: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1335: lv_api_name CONSTANT VARCHAR2(100) := 'DELETE_AR_TRXS';
1336: lv_debug_info VARCHAR2(4000);
1337: BEGIN
1338: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1339: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1340: G_MODULE_NAME || lv_api_name,
1341: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1342: END IF;
1343: DELETE JAI_AR_TRXS WHERE customer_trx_id = pr_old.customer_trx_id;

Line 1348: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1344:
1345: pv_return_message := '';
1346: pv_return_code := jai_constants.successful;
1347: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1349: G_MODULE_NAME || lv_api_name,
1350: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1351: END IF;
1352: EXCEPTION

Line 1513: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1509: End;
1510:
1511: BEGIN
1512: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1513: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1514: G_MODULE_NAME || lv_api_name,
1515: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1516: END IF;
1517: pv_return_code := jai_constants.successful;

Line 1550: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1546: if v_vat_taxes_exist = 1 then
1547: Generate_Tax_Invoice_no(v_organization_id, v_loc_id);
1548: end if;
1549: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1550: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1551: G_MODULE_NAME || lv_api_name,
1552: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1553: END IF;
1554: EXCEPTION

Line 1646: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1642: lv_return_code VARCHAR2(100);
1643: le_error EXCEPTION;
1644: BEGIN
1645: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1647: G_MODULE_NAME || lv_api_name,
1648: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1649: END IF;
1650: pv_return_code := jai_constants.successful;

Line 1776: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1772: end if;
1773: ---------------------------------------------------------
1774: --Added by Zhiwei for JAI Trigger elimination end
1775: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1776: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1777: G_MODULE_NAME || lv_api_name,
1778: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1779: END IF;
1780: EXCEPTION

Line 2216: FND_LOG.STRING(G_LEVEL_PROCEDURE,

2212: le_error EXCEPTION;
2213:
2214: BEGIN
2215: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2216: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2217: G_MODULE_NAME || lv_api_name,
2218: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
2219: END IF;
2220: pv_return_code := jai_constants.successful;

Line 3284: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3280: CLOSE cur_vat_taxes_exist;
3281:
3282: END IF;
3283: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3284: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3285: G_MODULE_NAME || lv_api_name,
3286: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
3287: END IF;
3288: EXCEPTION

Line 3315: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3311: WHERE CUSTOMER_TRX_ID = V_HEADER_ID;
3312:
3313: BEGIN
3314: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3315: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3316: G_MODULE_NAME || lv_api_name,
3317: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
3318: END IF;
3319: V_HEADER_ID := PR_NEW.CUSTOMER_TRX_ID;

Line 3350: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3346: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN
3347: RETURN;
3348: END IF;
3349: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3350: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3351: G_MODULE_NAME || lv_api_name,
3352: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
3353: END IF;
3354: EXCEPTION