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.ZX_GL_TAX_OPTIONS_PKG dependencies on FND_LOG

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

4:
5: -- Logging Infra
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_GL_TAX_OPTIONS_PKG';
7: G_CURRENT_RUNTIME_LEVEL NUMBER;
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: -- Logging Infra
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_GL_TAX_OPTIONS_PKG';
7: G_CURRENT_RUNTIME_LEVEL NUMBER;
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: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_GL_TAX_OPTIONS_PKG';
7: G_CURRENT_RUNTIME_LEVEL NUMBER;
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(60) := 'ZX.PLSQL.ZX_GL_TAX_OPTIONS_PKG.';

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

7: G_CURRENT_RUNTIME_LEVEL NUMBER;
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(60) := 'ZX.PLSQL.ZX_GL_TAX_OPTIONS_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(60) := 'ZX.PLSQL.ZX_GL_TAX_OPTIONS_PKG.';
15:
16: -- ***** PUBLIC PROCEDURES *****

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(60) := 'ZX.PLSQL.ZX_GL_TAX_OPTIONS_PKG.';
15:
16: -- ***** PUBLIC PROCEDURES *****
17: /*===========================================================================+

Line 172: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

168: -- Logging Infra
169: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEFAULT_VALUES';
170: l_api_version CONSTANT NUMBER := 1.0;
171: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_DEFAULT_VALUES';
172: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
173: -- Logging Infra
174: l_set_security_context_flag VARCHAR2(1);
175:
176: BEGIN

Line 179: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

175:
176: BEGIN
177:
178: -- Logging Infra: Setting up runtime level
179: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
180:
181: -- Logging Infra: Procedure level
182: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
183: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 183: FND_LOG.STRING(G_LEVEL_PROCEDURE,

179: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
180:
181: -- Logging Infra: Procedure level
182: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
183: FND_LOG.STRING(G_LEVEL_PROCEDURE,
184: G_MODULE_NAME || l_procedure_name,
185: 'get_default_values(+)');
186: END IF;
187: -- Logging Infra: Break point input parameters

Line 195: FND_LOG.STRING(G_LEVEL_STATEMENT,

191: ', org_id=' || p_org_id ||
192: ', account_segment=' || p_account_segment ||
193: ', account_type=' || p_account_type ||
194: ', trx_date=' || p_trx_date;
195: FND_LOG.STRING(G_LEVEL_STATEMENT,
196: G_MODULE_NAME || l_procedure_name,
197: l_log_msg);
198: END IF;
199:

Line 219: FND_LOG.STRING(G_LEVEL_PROCEDURE,

215:
216: IF l_set_security_context_flag = 'Y' Then
217: -- Logging Infra: Procedure level
218: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
219: FND_LOG.STRING(G_LEVEL_PROCEDURE,
220: G_MODULE_NAME || l_procedure_name,
221: 'Setting Security Context');
222: END IF;
223:

Line 229: FND_LOG.STRING(G_LEVEL_STATEMENT,

225:
226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: -- Logging Infra: Statement level
228: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
229: FND_LOG.STRING(G_LEVEL_STATEMENT,
230: G_MODULE_NAME || l_procedure_name,
231: 'Error Setting Security Context');
232: END IF;
233: Return;

Line 239: FND_LOG.STRING(G_LEVEL_PROCEDURE,

235: END IF;
236:
237: -- Logging Infra: Procedure level
238: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
239: FND_LOG.STRING(G_LEVEL_PROCEDURE,
240: G_MODULE_NAME || l_procedure_name,
241: 'Fetching default tax rate info');
242: END IF;
243:

Line 250: FND_LOG.STRING(G_LEVEL_STATEMENT,

246: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
247: l_log_msg := 'B: CUR: acct_rate_cur: tax_class=' || l_tax_class_tmp ||
248: ', ledger_id=' || p_ledger_id ||
249: ', account_segment=' || p_account_segment;
250: FND_LOG.STRING(G_LEVEL_STATEMENT,
251: G_MODULE_NAME || l_procedure_name,
252: l_log_msg);
253: END IF;
254:

Line 280: FND_LOG.STRING(G_LEVEL_STATEMENT,

276: ', tax_status_code=' || x_default_tax_status_code ||
277: ', tax_rate_code=' || x_default_tax_rate_code ||
278: ', tax_rate_id=' || x_default_tax_rate_id ||
279: ', tax_class=' || l_tax_class;
280: FND_LOG.STRING(G_LEVEL_STATEMENT,
281: G_MODULE_NAME || l_procedure_name,
282: l_log_msg);
283: END IF;
284:

Line 291: FND_LOG.STRING(G_LEVEL_STATEMENT,

287:
288: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
289: l_log_msg := 'B: CUR: acct_rate_sob_cur: tax_class=' || l_tax_class_tmp ||
290: ', ledger_id=' || p_ledger_id;
291: FND_LOG.STRING(G_LEVEL_STATEMENT,
292: G_MODULE_NAME || l_procedure_name,
293: l_log_msg);
294: END IF;
295:

Line 315: FND_LOG.STRING(G_LEVEL_STATEMENT,

311: ', tax_status_code=' || x_default_tax_status_code ||
312: ', tax_rate_code=' || x_default_tax_rate_code ||
313: ', tax_rate_id=' || x_default_tax_rate_id ||
314: ', tax_class=' || l_tax_class;
315: FND_LOG.STRING(G_LEVEL_STATEMENT,
316: G_MODULE_NAME || l_procedure_name,
317: l_log_msg);
318: END IF;
319: END IF;

Line 326: FND_LOG.STRING(G_LEVEL_PROCEDURE,

322: IF l_set_security_context_flag = 'Y' Then
323:
324: -- Logging Infra: Procedure level
325: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
326: FND_LOG.STRING(G_LEVEL_PROCEDURE,
327: G_MODULE_NAME || l_procedure_name,
328: 'Resetting First Party Org context to NULL');
329: END IF;
330:

Line 349: FND_LOG.STRING(G_LEVEL_PROCEDURE,

345: END IF;
346:
347: -- Logging Infra: Procedure level
348: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
349: FND_LOG.STRING(G_LEVEL_PROCEDURE,
350: G_MODULE_NAME || l_procedure_name,
351: 'Fetching default rounding rule');
352: END IF;
353:

Line 366: FND_LOG.STRING(G_LEVEL_STATEMENT,

362:
363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
364: -- Logging Infra: Statement level
365: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
366: FND_LOG.STRING(G_LEVEL_STATEMENT,
367: G_MODULE_NAME || l_procedure_name,
368: 'Error from API to default rounding rule');
369: END IF;
370: Return;

Line 375: FND_LOG.STRING(G_LEVEL_PROCEDURE,

371: END IF;
372:
373: -- Logging Infra: Procedure level
374: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
375: FND_LOG.STRING(G_LEVEL_PROCEDURE,
376: G_MODULE_NAME || l_procedure_name,
377: 'Fetching default tax include flag');
378: END IF;
379:

Line 393: FND_LOG.STRING(G_LEVEL_STATEMENT,

389:
390: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
391: -- Logging Infra: Statement level
392: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
393: FND_LOG.STRING(G_LEVEL_STATEMENT,
394: G_MODULE_NAME || l_procedure_name,
395: 'Error from API to default tax include flag');
396: END IF;
397: Return;

Line 405: FND_LOG.STRING(G_LEVEL_STATEMENT,

401: IF x_default_rounding_code IS NULL THEN
402: -- Logging Infra: Break point acct_rate_sob_cur
403: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
404: l_log_msg := 'B: tax_regime_code/rounding_rule_code IS NULL';
405: FND_LOG.STRING(G_LEVEL_STATEMENT,
406: G_MODULE_NAME || l_procedure_name,
407: l_log_msg);
408: END IF;
409: l_return_status := FND_API.G_RET_STS_ERROR;

Line 416: FND_LOG.STRING(G_LEVEL_STATEMENT,

412: ELSE
413: -- ledger level information (rounding_rule_code) has been derived
414: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
415: l_log_msg := 'B: tax_regime_code IS NULL but rounding_rule_code IS NOT NULL';
416: FND_LOG.STRING(G_LEVEL_STATEMENT,
417: G_MODULE_NAME || l_procedure_name,
418: l_log_msg);
419: END IF;
420: END IF;

Line 430: FND_LOG.STRING(G_LEVEL_STATEMENT,

426: x_return_status := FND_API.G_RET_STS_ERROR;
427: x_msg_out := 'ZX_GL_RATE_ID_NULL';
428: -- Logging Infra: Statement level
429: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
430: FND_LOG.STRING(G_LEVEL_STATEMENT,
431: G_MODULE_NAME || l_procedure_name,
432: x_msg_out);
433: END IF;
434: Return;

Line 448: FND_LOG.STRING(G_LEVEL_STATEMENT,

444: ', tax_rate_code=' || x_default_tax_rate_code ||
445: ', rounding_rule_code=' || x_default_rounding_code ||
446: ', incl_tax_flag=' || x_default_incl_tax_flag ||
447: ', tax_rate_id=' || x_default_tax_rate_id;
448: FND_LOG.STRING(G_LEVEL_STATEMENT,
449: G_MODULE_NAME || l_procedure_name,
450: l_log_msg);
451: END IF;
452: -- Logging Infra: Procedure level

Line 454: FND_LOG.STRING(G_LEVEL_PROCEDURE,

450: l_log_msg);
451: END IF;
452: -- Logging Infra: Procedure level
453: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
454: FND_LOG.STRING(G_LEVEL_PROCEDURE,
455: G_MODULE_NAME,
456: 'get_default_value(-)');
457: END IF;
458:

Line 465: FND_LOG.STRING(G_LEVEL_STATEMENT,

461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: x_msg_out := TO_CHAR(SQLCODE);
463: -- Logging Infra:
464: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING(G_LEVEL_STATEMENT,
466: G_MODULE_NAME || l_procedure_name,
467: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
468: END IF;
469: app_exception.raise_exception;

Line 551: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

547: -- Logging Infra
548: l_api_name CONSTANT VARCHAR2(30) := 'GET_TAX_RATE_AND_ACCOUNT';
549: l_api_version CONSTANT NUMBER := 1.0;
550: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_TAX_RATE_AND_ACCOUNT';
551: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
552: -- Logging Infra
553:
554: BEGIN
555: -- Logging Infra: Setting up runtime level

Line 556: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

552: -- Logging Infra
553:
554: BEGIN
555: -- Logging Infra: Setting up runtime level
556: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
557:
558: -- Logging Infra: Procedure level
559: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
560: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 560: FND_LOG.STRING(G_LEVEL_PROCEDURE,

556: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
557:
558: -- Logging Infra: Procedure level
559: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
560: FND_LOG.STRING(G_LEVEL_PROCEDURE,
561: G_MODULE_NAME || l_procedure_name,
562: 'get_tax_rate_and_account(+)');
563: END IF;
564: -- Logging Infra: Break point input parameters

Line 569: FND_LOG.STRING(G_LEVEL_STATEMENT,

565: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
566: l_log_msg := 'B: IN: api_version=' || p_api_version ||
567: ', tax_type_code=' || p_tax_type_code ||
568: ', tax_rate_id=' || p_tax_rate_id;
569: FND_LOG.STRING(G_LEVEL_STATEMENT,
570: G_MODULE_NAME || l_procedure_name,
571: l_log_msg);
572: END IF;
573:

Line 591: FND_LOG.STRING(G_LEVEL_STATEMENT,

587: -- Logging Infra: Break point get_pct_rate_ccid_cur
588: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
589: l_log_msg := 'B: CUR: get_pct_rate_ccid_cur: pct_rate=' || l_pct_rate ||
590: ', tax_account_ccid=' || l_tax_account_ccid;
591: FND_LOG.STRING(G_LEVEL_STATEMENT,
592: G_MODULE_NAME || l_procedure_name,
593: l_log_msg);
594: END IF;
595:

Line 606: FND_LOG.STRING(G_LEVEL_STATEMENT,

602: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
603: l_log_msg := 'B: OUT: tax_rate_pct=' || l_pct_rate ||
604: ', tax_account_ccid=' || l_tax_account_ccid ||
605: ', return_status=' || l_return_status;
606: FND_LOG.STRING(G_LEVEL_STATEMENT,
607: G_MODULE_NAME || l_procedure_name,
608: l_log_msg);
609: END IF;
610: -- Logging Infra: Procedure level

Line 612: FND_LOG.STRING(G_LEVEL_PROCEDURE,

608: l_log_msg);
609: END IF;
610: -- Logging Infra: Procedure level
611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
612: FND_LOG.STRING(G_LEVEL_PROCEDURE,
613: G_MODULE_NAME || l_procedure_name,
614: 'get_tax_rate_and_account(-)');
615: END IF;
616:

Line 623: FND_LOG.STRING(G_LEVEL_STATEMENT,

619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: x_msg_out := TO_CHAR(SQLCODE);
621: -- Logging Infra:
622: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(G_LEVEL_STATEMENT,
624: G_MODULE_NAME || l_procedure_name,
625: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
626: END IF;
627: app_exception.raise_exception;

Line 695: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

691: -- Logging Infra
692: l_api_name CONSTANT VARCHAR2(30) := 'GET_TAX_CCID';
693: l_api_version CONSTANT NUMBER := 1.0;
694: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_TAX_CCID';
695: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
696: -- Logging Infra
697:
698: BEGIN
699: -- Logging Infra: Setting up runtime level

Line 700: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

696: -- Logging Infra
697:
698: BEGIN
699: -- Logging Infra: Setting up runtime level
700: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
701:
702: -- Logging Infra: Procedure level
703: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
704: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 704: FND_LOG.STRING(G_LEVEL_PROCEDURE,

700: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
701:
702: -- Logging Infra: Procedure level
703: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
704: FND_LOG.STRING(G_LEVEL_PROCEDURE,
705: G_MODULE_NAME || l_procedure_name,
706: 'get_tax_ccid(+)');
707: END IF;
708:

Line 715: FND_LOG.STRING(G_LEVEL_STATEMENT,

711: l_log_msg := 'B: IN: api_version=' || p_api_version ||
712: ', tax_rate_id=' || p_tax_rate_id ||
713: ', org_id=' || p_org_id ||
714: ', ledger_id=' || p_ledger_id;
715: FND_LOG.STRING(G_LEVEL_STATEMENT,
716: G_MODULE_NAME || l_procedure_name,
717: l_log_msg);
718: END IF;
719:

Line 739: FND_LOG.STRING(G_LEVEL_STATEMENT,

735: -- Logging Infra: Break point output parameters
736: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
737: l_log_msg := 'B: OUT: tax_account_ccid=' || x_tax_account_ccid ||
738: ', return_status=' || x_return_status;
739: FND_LOG.STRING(G_LEVEL_STATEMENT,
740: G_MODULE_NAME || l_procedure_name,
741: l_log_msg);
742: END IF;
743:

Line 746: FND_LOG.STRING(G_LEVEL_PROCEDURE,

742: END IF;
743:
744: -- Logging Infra: Procedure level
745: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
746: FND_LOG.STRING(G_LEVEL_PROCEDURE,
747: G_MODULE_NAME || l_procedure_name,
748: 'get_tax_ccid(-)');
749: END IF;
750:

Line 757: FND_LOG.STRING(G_LEVEL_STATEMENT,

753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: x_msg_out := TO_CHAR(SQLCODE);
755: -- Logging Infra:
756: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.STRING(G_LEVEL_STATEMENT,
758: G_MODULE_NAME || l_procedure_name,
759: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
760: END IF;
761: app_exception.raise_exception;

Line 879: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

875: -- Logging Infra
876: l_api_name CONSTANT VARCHAR2(30) := 'GET_TAX_RATE_ID';
877: l_api_version CONSTANT NUMBER := 1.0;
878: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_TAX_RATE_ID';
879: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
880: -- Logging Infra
881: l_set_security_context_flag VARCHAR2(1);
882:
883: BEGIN

Line 885: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

881: l_set_security_context_flag VARCHAR2(1);
882:
883: BEGIN
884: -- Logging Infra: Setting up runtime level
885: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
886:
887: -- Logging Infra: Procedure level
888: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
889: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 889: FND_LOG.STRING(G_LEVEL_PROCEDURE,

885: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
886:
887: -- Logging Infra: Procedure level
888: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
889: FND_LOG.STRING(G_LEVEL_PROCEDURE,
890: G_MODULE_NAME || l_procedure_name,
891: 'get_tax_rate_id(+)');
892: END IF;
893: -- Logging Infra: Break point input parameters

Line 900: FND_LOG.STRING(G_LEVEL_STATEMENT,

896: ', org_id=' || p_org_id ||
897: ', tax_rate_code=' || p_tax_rate_code ||
898: ', trx_date=' || p_trx_date ||
899: ', tax_type_code=' || p_tax_type_code;
900: FND_LOG.STRING(G_LEVEL_STATEMENT,
901: G_MODULE_NAME || l_procedure_name,
902: l_log_msg);
903: END IF;
904:

Line 913: FND_LOG.STRING(G_LEVEL_STATEMENT,

909: x_return_status := FND_API.G_RET_STS_ERROR;
910: x_msg_out := 'ZX_GL_INVALID_TAX_RATE_CODE';
911: -- Logging Infra:
912: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.STRING(G_LEVEL_STATEMENT,
914: G_MODULE_NAME || l_procedure_name,
915: 'p_tax_rate_code is STD_AR_INPUT');
916: END IF;
917: Return;

Line 931: FND_LOG.STRING(G_LEVEL_PROCEDURE,

927: IF l_set_security_context_flag = 'Y' Then
928:
929: -- Logging Infra: Procedure level
930: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
931: FND_LOG.STRING(G_LEVEL_PROCEDURE,
932: G_MODULE_NAME || l_procedure_name,
933: 'Setting Security Context');
934: END IF;
935:

Line 941: FND_LOG.STRING(G_LEVEL_STATEMENT,

937:
938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
939: -- Logging Infra: Statement level
940: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
941: FND_LOG.STRING(G_LEVEL_STATEMENT,
942: G_MODULE_NAME || l_procedure_name,
943: 'Error Setting Security Context');
944: END IF;
945: Return;

Line 952: FND_LOG.STRING(G_LEVEL_PROCEDURE,

948: END IF; -- l_set_security_context_flag
949:
950: -- Logging Infra: Procedure level
951: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
952: FND_LOG.STRING(G_LEVEL_PROCEDURE,
953: G_MODULE_NAME || l_procedure_name,
954: 'Fetching Tax Rate Id');
955: END IF;
956:

Line 976: FND_LOG.STRING(G_LEVEL_STATEMENT,

972: -- Logging Infra: Break point rate_id_for_null_type_cur
973: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
974: l_log_msg := 'B: CUR: rate_id_for_null_type: tax_rate_id=' || l_tax_rate_id ||
975: ', tax_type_code=' || p_tax_type_code;
976: FND_LOG.STRING(G_LEVEL_STATEMENT,
977: G_MODULE_NAME || l_procedure_name,
978: l_log_msg);
979: END IF;
980: ELSIF p_tax_type_code IN ('I', 'O') THEN

Line 998: FND_LOG.STRING(G_LEVEL_STATEMENT,

994: -- Logging Infra: Break point rate_id_for_mig_cur
995: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
996: l_log_msg := 'B: CUR: rate_id_for_mig_cur: tax_rate_id=' || l_tax_rate_id ||
997: ', tax_type_code=' || p_tax_type_code;
998: FND_LOG.STRING(G_LEVEL_STATEMENT,
999: G_MODULE_NAME || l_procedure_name,
1000: l_log_msg);
1001: END IF;
1002:

Line 1012: FND_LOG.STRING(G_LEVEL_STATEMENT,

1008: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1009: l_log_msg := 'B: OUT: tax_type_code=' || l_tax_type_code ||
1010: ', tax_rate_id=' || l_tax_rate_id ||
1011: ', return_status=' || x_return_status;
1012: FND_LOG.STRING(G_LEVEL_STATEMENT,
1013: G_MODULE_NAME || l_procedure_name,
1014: l_log_msg);
1015: END IF;
1016:

Line 1019: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1015: END IF;
1016:
1017: -- Logging Infra: Procedure level
1018: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1019: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1020: G_MODULE_NAME || l_procedure_name,
1021: 'Resetting First Party Org context to NULL');
1022: END IF;
1023:

Line 1032: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1028: END IF;
1029:
1030: -- Logging Infra: Procedure level
1031: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1032: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1033: G_MODULE_NAME || l_procedure_name,
1034: 'get_tax_rate_id(-)');
1035: END IF;
1036: EXCEPTION

Line 1041: FND_LOG.STRING(G_LEVEL_STATEMENT,

1037: WHEN OTHERS THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: x_msg_out := TO_CHAR(SQLCODE);
1040: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.STRING(G_LEVEL_STATEMENT,
1042: G_MODULE_NAME || l_procedure_name,
1043: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
1044: END IF;
1045: app_exception.raise_exception;

Line 1151: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1147: -- Logging Infra
1148: l_api_name CONSTANT VARCHAR2(30) := 'GET_TAX_RATE_CODE';
1149: l_api_version CONSTANT NUMBER := 1.0;
1150: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_TAX_RATE_CODE';
1151: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1152: -- Logging Infra
1153:
1154: BEGIN
1155: -- Logging Infra: Setting up runtime level

Line 1156: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1152: -- Logging Infra
1153:
1154: BEGIN
1155: -- Logging Infra: Setting up runtime level
1156: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1157:
1158: -- Logging Infra: Procedure level
1159: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1160: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1160: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1156: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1157:
1158: -- Logging Infra: Procedure level
1159: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1160: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1161: G_MODULE_NAME || l_procedure_name,
1162: 'get_tax_rate_code(+)');
1163: END IF;
1164: -- Logging Infra: Break point input parameters

Line 1169: FND_LOG.STRING(G_LEVEL_STATEMENT,

1165: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1166: l_log_msg := 'B: IN: api_version=' || p_api_version ||
1167: ', tax_type_code=' || p_tax_type_code ||
1168: ', tax_rate_id=' || p_tax_rate_id;
1169: FND_LOG.STRING(G_LEVEL_STATEMENT,
1170: G_MODULE_NAME || l_procedure_name,
1171: l_log_msg);
1172: END IF;
1173:

Line 1190: FND_LOG.STRING(G_LEVEL_STATEMENT,

1186:
1187: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1188: l_log_msg := 'B: CUR: get_source_rate_code_cur: tax_rate_code=' ||
1189: l_tax_rate_code;
1190: FND_LOG.STRING(G_LEVEL_STATEMENT,
1191: G_MODULE_NAME || l_procedure_name,
1192: l_log_msg);
1193: FND_LOG.STRING(G_LEVEL_STATEMENT,
1194: G_MODULE_NAME || l_procedure_name,

Line 1193: FND_LOG.STRING(G_LEVEL_STATEMENT,

1189: l_tax_rate_code;
1190: FND_LOG.STRING(G_LEVEL_STATEMENT,
1191: G_MODULE_NAME || l_procedure_name,
1192: l_log_msg);
1193: FND_LOG.STRING(G_LEVEL_STATEMENT,
1194: G_MODULE_NAME || l_procedure_name,
1195: 'l_source_indicator : ' || l_source_indicator);
1196:
1197: END IF;

Line 1210: FND_LOG.STRING(G_LEVEL_STATEMENT,

1206: x_msg_out := 'ZX_GL_INVALID_PARAM';
1207: -- Logging Infra:
1208: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1209: l_log_msg := 'B: Unexpected tax_type_code';
1210: FND_LOG.STRING(G_LEVEL_STATEMENT,
1211: G_MODULE_NAME || l_procedure_name,
1212: l_log_msg);
1213: END IF;
1214: Return;

Line 1229: FND_LOG.STRING(G_LEVEL_STATEMENT,

1225:
1226: -- Logging Infra: Break point get_tax_rate_code_cur
1227: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1228: l_log_msg := 'B: CUR: get_tax_rate_code_cur: tax_rate_code=' || l_tax_rate_code;
1229: FND_LOG.STRING(G_LEVEL_STATEMENT,
1230: G_MODULE_NAME || l_procedure_name,
1231: l_log_msg);
1232:
1233: END IF;

Line 1242: FND_LOG.STRING(G_LEVEL_STATEMENT,

1238: -- Logging Infra: Break point output parameters
1239: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1240: l_log_msg := 'B: OUT: tax_rate_code=' || l_tax_rate_code ||
1241: ', return_status=' || l_return_status;
1242: FND_LOG.STRING(G_LEVEL_STATEMENT,
1243: G_MODULE_NAME || l_procedure_name,
1244: l_log_msg);
1245: END IF;
1246:

Line 1249: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1245: END IF;
1246:
1247: -- Logging Infra: Procedure level
1248: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1249: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1250: G_MODULE_NAME || l_procedure_name,
1251: 'get_tax_rate_and_account(-)');
1252: END IF;
1253:

Line 1260: FND_LOG.STRING(G_LEVEL_STATEMENT,

1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: x_msg_out := TO_CHAR(SQLCODE);
1258: -- Logging Infra:
1259: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1260: FND_LOG.STRING(G_LEVEL_STATEMENT,
1261: G_MODULE_NAME || l_procedure_name,
1262: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
1263: END IF;
1264: app_exception.raise_exception;

Line 1328: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1324: -- Logging Infrastructure
1325: l_api_name CONSTANT VARCHAR2(30) := 'GET_ROUNDING_RULE_CODE';
1326: l_api_version CONSTANT NUMBER := 1.0;
1327: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_ROUNDING_RULE_CODE';
1328: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1329: -- Logging Infrastructure
1330: l_set_security_context_flag VARCHAR2(1);
1331:
1332: BEGIN

Line 1335: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1331:
1332: BEGIN
1333:
1334: -- Logging Infra: Setting up runtime level
1335: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1336:
1337: -- Logging Infra: Procedure level
1338: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1339: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1339: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1335: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1336:
1337: -- Logging Infra: Procedure level
1338: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1339: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1340: G_MODULE_NAME || l_procedure_name,
1341: 'get_rounding_rule_code(+)');
1342: END IF;
1343:

Line 1351: FND_LOG.STRING(G_LEVEL_STATEMENT,

1347: ', ledger_id=' || p_ledger_id ||
1348: ', org_id=' || p_org_id ||
1349: ', le_id=' || p_le_id ||
1350: ', tax_class=' || p_tax_class;
1351: FND_LOG.STRING(G_LEVEL_STATEMENT,
1352: G_MODULE_NAME || l_procedure_name,
1353: l_log_msg);
1354: END IF;
1355:

Line 1368: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1364: IF l_set_security_context_flag = 'Y' Then
1365:
1366: -- Logging Infra: Procedure level
1367: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1368: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1369: G_MODULE_NAME || l_procedure_name,
1370: 'Setting Security Context');
1371: END IF;
1372:

Line 1378: FND_LOG.STRING(G_LEVEL_STATEMENT,

1374:
1375: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1376: -- Logging Infra: Statement level
1377: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1378: FND_LOG.STRING(G_LEVEL_STATEMENT,
1379: G_MODULE_NAME || l_procedure_name,
1380: 'Error Setting Security Context');
1381: END IF;
1382: Return;

Line 1388: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1384: END IF; -- l_set_security_context_flag
1385:
1386: -- Logging Infra: Procedure level
1387: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1388: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1389: G_MODULE_NAME || l_procedure_name,
1390: 'Fetching rounding rule code');
1391: END IF;
1392:

Line 1416: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1412: IF l_set_security_context_flag = 'Y' Then
1413:
1414: -- Logging Infra: Procedure level
1415: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1416: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1417: G_MODULE_NAME || l_procedure_name,
1418: 'Resetting First Party Org context to NULL');
1419: END IF;
1420:

Line 1428: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1424: END IF;
1425:
1426: -- Logging Infra: Procedure level
1427: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1428: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1429: G_MODULE_NAME || l_procedure_name,
1430: 'get_rounding_rule_code(-)');
1431: END IF;
1432:

Line 1439: FND_LOG.STRING(G_LEVEL_STATEMENT,

1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436: x_msg_out := TO_CHAR(SQLCODE);
1437: -- Logging Infra:
1438: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(G_LEVEL_STATEMENT,
1440: G_MODULE_NAME || l_procedure_name,
1441: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
1442: END IF;
1443: app_exception.raise_exception;

Line 1506: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1502: -- Logging Infrastructure
1503: l_api_name CONSTANT VARCHAR2(30) := 'GET_PRECISION_MAU';
1504: l_api_version CONSTANT NUMBER := 1.0;
1505: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_PRECISION_MAU';
1506: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1507: -- Logging Infrastructure
1508: l_set_security_context_flag VARCHAR2(1);
1509:
1510: BEGIN

Line 1513: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1509:
1510: BEGIN
1511:
1512: -- Logging Infra: Setting up runtime level
1513: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1514:
1515: -- Logging Infra: Procedure level
1516: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1517: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1517: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1513: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1514:
1515: -- Logging Infra: Procedure level
1516: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1517: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1518: G_MODULE_NAME || l_procedure_name,
1519: 'get_precision_mau(+)');
1520: END IF;
1521:

Line 1528: FND_LOG.STRING(G_LEVEL_STATEMENT,

1524: l_log_msg := 'B: IN: api_version=' || p_api_version ||
1525: ', ledger_id=' || p_ledger_id ||
1526: ', org_id=' || p_org_id ||
1527: ', le_id=' || p_le_id;
1528: FND_LOG.STRING(G_LEVEL_STATEMENT,
1529: G_MODULE_NAME || l_procedure_name,
1530: l_log_msg);
1531: END IF;
1532:

Line 1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534:
1535: -- Logging Infra: Procedure level
1536: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1538: G_MODULE_NAME || l_procedure_name,
1539: 'Setting Security Context');
1540: END IF;
1541:

Line 1559: FND_LOG.STRING(G_LEVEL_STATEMENT,

1555:
1556: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1557: -- Logging Infra: Statement level
1558: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1559: FND_LOG.STRING(G_LEVEL_STATEMENT,
1560: G_MODULE_NAME || l_procedure_name,
1561: 'Error Setting Security Context');
1562: END IF;
1563: Return;

Line 1569: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1565: END IF; -- l_set_security_context_flag
1566:
1567: -- Logging Infra: Procedure level
1568: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1569: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1570: G_MODULE_NAME || l_procedure_name,
1571: 'Fetching precision and mau');
1572: END IF;
1573:

Line 1588: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1584: CLOSE precision_mau_cur;
1585:
1586: -- Logging Infra: Procedure level
1587: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1588: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1589: G_MODULE_NAME || l_procedure_name,
1590: 'Resetting First Party Org context to NULL');
1591: END IF;
1592:

Line 1607: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1603: END IF;
1604:
1605: -- Logging Infra: Procedure level
1606: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1607: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1608: G_MODULE_NAME || l_procedure_name,
1609: 'get_precision_mau(-)');
1610: END IF;
1611:

Line 1618: FND_LOG.STRING(G_LEVEL_STATEMENT,

1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: x_msg_out := TO_CHAR(SQLCODE);
1616: -- Logging Infra:
1617: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.STRING(G_LEVEL_STATEMENT,
1619: G_MODULE_NAME || l_procedure_name,
1620: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
1621: END IF;
1622: app_exception.raise_exception;

Line 1669: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1665: -- Logging Infrastructure
1666: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEFAULT_TAX_INCLUDE_FLAG';
1667: l_api_version CONSTANT NUMBER := 1.0;
1668: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_DEFAULT_TAX_INCLUDE_FLAG';
1669: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1670: -- Logging Infrastructure
1671: l_set_security_context_flag VARCHAR2(1);
1672:
1673: BEGIN

Line 1676: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1672:
1673: BEGIN
1674:
1675: -- Logging Infra: Setting up runtime level
1676: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1677:
1678: -- Logging Infra: Procedure level
1679: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1680: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1680: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1676: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1677:
1678: -- Logging Infra: Procedure level
1679: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1680: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1681: G_MODULE_NAME || l_procedure_name,
1682: 'get_default_tax_include_flag(+)');
1683: END IF;
1684:

Line 1693: FND_LOG.STRING(G_LEVEL_STATEMENT,

1689: ', org_id=' || p_org_id ||
1690: ', le_id=' || p_le_id ||
1691: ', account_value=' || p_account_value ||
1692: ', tax_type_code=' || p_tax_type_code;
1693: FND_LOG.STRING(G_LEVEL_STATEMENT,
1694: G_MODULE_NAME || l_procedure_name,
1695: l_log_msg);
1696: END IF;
1697:

Line 1710: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1706: IF l_set_security_context_flag = 'Y' Then
1707:
1708: -- Logging Infra: Procedure level
1709: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1710: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1711: G_MODULE_NAME || l_procedure_name,
1712: 'Setting Security Context');
1713: END IF;
1714:

Line 1720: FND_LOG.STRING(G_LEVEL_STATEMENT,

1716:
1717: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1718: -- Logging Infra: Statement level
1719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,
1721: G_MODULE_NAME || l_procedure_name,
1722: 'Error Setting Security Context');
1723: END IF;
1724: Return;

Line 1730: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1726: END IF; -- l_set_security_context_flag
1727:
1728: -- Logging Infra: Procedure level
1729: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1730: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1731: G_MODULE_NAME || l_procedure_name,
1732: 'Fetching amount includes tax flag');
1733: END IF;
1734:

Line 1779: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1775: IF l_set_security_context_flag = 'Y' Then
1776:
1777: -- Logging Infra: Procedure level
1778: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1779: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1780: G_MODULE_NAME || l_procedure_name,
1781: 'Resetting First Party Org context to NULL');
1782: END IF;
1783:

Line 1791: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1787: END IF;
1788:
1789: -- Logging Infra: Procedure level
1790: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1791: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1792: G_MODULE_NAME || l_procedure_name,
1793: 'get_default_tax_include_flag(-)');
1794: END IF;
1795:

Line 1802: FND_LOG.STRING(G_LEVEL_STATEMENT,

1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1799: x_msg_out := TO_CHAR(SQLCODE);
1800: -- Logging Infra:
1801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1802: FND_LOG.STRING(G_LEVEL_STATEMENT,
1803: G_MODULE_NAME || l_procedure_name,
1804: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
1805: END IF;
1806: app_exception.raise_exception;

Line 1824: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1820: -- Logging Infrastructure
1821: l_api_name CONSTANT VARCHAR2(30) := 'GET_LEDGER_CONTROLS';
1822: l_api_version CONSTANT NUMBER := 1.0;
1823: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_LEDGER_CONTROLS';
1824: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1825: -- Logging Infrastructure
1826: l_set_security_context_flag VARCHAR2(1);
1827:
1828: BEGIN

Line 1831: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1827:
1828: BEGIN
1829:
1830: -- Logging Infra: Setting up runtime level
1831: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1832:
1833: -- Logging Infra: Procedure level
1834: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1835: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1835: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1831: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1832:
1833: -- Logging Infra: Procedure level
1834: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1835: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1836: G_MODULE_NAME || l_procedure_name,
1837: 'get_ledger_controls(+)');
1838: END IF;
1839:

Line 1846: FND_LOG.STRING(G_LEVEL_STATEMENT,

1842: l_log_msg := 'B: IN: api_version=' || p_api_version ||
1843: ', ledger_id=' || p_ledger_id ||
1844: ', org_id=' || p_org_id ||
1845: ', le_id=' || p_le_id;
1846: FND_LOG.STRING(G_LEVEL_STATEMENT,
1847: G_MODULE_NAME || l_procedure_name,
1848: l_log_msg);
1849: END IF;
1850:

Line 1863: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1859: IF l_set_security_context_flag = 'Y' Then
1860:
1861: -- Logging Infra: Procedure level
1862: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1863: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1864: G_MODULE_NAME || l_procedure_name,
1865: 'Setting Security Context');
1866: END IF;
1867:

Line 1873: FND_LOG.STRING(G_LEVEL_STATEMENT,

1869:
1870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1871: -- Logging Infra: Statement level
1872: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1873: FND_LOG.STRING(G_LEVEL_STATEMENT,
1874: G_MODULE_NAME || l_procedure_name,
1875: 'Error Setting Security Context');
1876: END IF;
1877: Return;

Line 1883: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1879: END IF; -- l_set_security_context_flag
1880:
1881: -- Logging Infra: Procedure level
1882: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1883: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1884: G_MODULE_NAME || l_procedure_name,
1885: 'Fetching calc level code and tax mau');
1886: END IF;
1887:

Line 1900: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1896:
1897: IF l_set_security_context_flag = 'Y' Then
1898: -- Logging Infra: Procedure level
1899: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1900: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1901: G_MODULE_NAME || l_procedure_name,
1902: 'Resetting First Party Org context to NULL');
1903: END IF;
1904:

Line 1912: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1908: END IF;
1909:
1910: -- Logging Infra: Procedure level
1911: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1912: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1913: G_MODULE_NAME || l_procedure_name,
1914: 'get_ledger_controls(-)');
1915: END IF;
1916:

Line 1923: FND_LOG.STRING(G_LEVEL_STATEMENT,

1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: x_msg_out := 'ZX_GL_LEDGER_CONTROLS_NOTFOUND';
1921: -- Logging Infra:
1922: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1923: FND_LOG.STRING(G_LEVEL_STATEMENT,
1924: G_MODULE_NAME || l_procedure_name,
1925: 'NO_DATA_FOUND');
1926: END IF;
1927: WHEN OTHERS THEN

Line 1932: FND_LOG.STRING(G_LEVEL_STATEMENT,

1928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: x_msg_out := TO_CHAR(SQLCODE);
1930: -- Logging Infra:
1931: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1932: FND_LOG.STRING(G_LEVEL_STATEMENT,
1933: G_MODULE_NAME || l_procedure_name,
1934: TO_CHAR(SQLCODE) || ': ' || SQLERRM);
1935: END IF;
1936: app_exception.raise_exception;