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_DEFAULT_AUTOMATION_PKG dependencies on FND_LOG

Line 20: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

16:
17: l_error_buffer VARCHAR2(240);
18:
19: g_current_runtime_level NUMBER;
20: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
22: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 21: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

17: l_error_buffer VARCHAR2(240);
18:
19: g_current_runtime_level NUMBER;
20: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
22: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25:

Line 22: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

18:
19: g_current_runtime_level NUMBER;
20: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
22: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25:
26: TYPE DET_TAX_ATTR_REC IS RECORD

Line 23: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

19: g_current_runtime_level NUMBER;
20: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
22: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25:
26: TYPE DET_TAX_ATTR_REC IS RECORD
27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,

Line 24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

20: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
22: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25:
26: TYPE DET_TAX_ATTR_REC IS RECORD
27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,
28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,

Line 50: FND_LOG.STRING(g_level_procedure,

46:
47: l_source_line_key VARCHAR2(2000);
48: BEGIN
49: IF (g_level_procedure >= g_current_runtime_level ) THEN
50: FND_LOG.STRING(g_level_procedure,
51: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
52: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(+)');
53: END IF;
54:

Line 58: FND_LOG.STRING(g_level_statement,

54:
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: IF (g_level_statement >= g_current_runtime_level ) THEN
58: FND_LOG.STRING(g_level_statement,
59: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
60: 'default_taxation_country(' || p_trx_line_index || ') = '
61: || ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(p_trx_line_index) || '$' ||
62: 'DOCUMENT_SUB_TYPE = '

Line 143: FND_LOG.STRING(g_level_statement,

139: END IF;
140: END IF;
141:
142: IF (g_level_statement >= g_current_runtime_level ) THEN
143: FND_LOG.STRING(g_level_statement,
144: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
145: 'default_taxation_country(' || p_trx_line_index || ') = '
146: || ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(p_trx_line_index) || '$' ||
147: 'DOCUMENT_SUB_TYPE = '

Line 167: FND_LOG.STRING(g_level_procedure,

163: );
164: END IF;
165:
166: IF (g_level_procedure >= g_current_runtime_level ) THEN
167: FND_LOG.STRING(g_level_procedure,
168: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
169: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(-)');
170: END IF;
171:

Line 213: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

209: l_context_info_rec ZX_API_PUB.context_info_rec_type;
210:
211: BEGIN
212:
213: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
214:
215: IF (g_level_procedure >= g_current_runtime_level ) THEN
216: FND_LOG.STRING(g_level_procedure,
217: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',

Line 216: FND_LOG.STRING(g_level_procedure,

212:
213: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
214:
215: IF (g_level_procedure >= g_current_runtime_level ) THEN
216: FND_LOG.STRING(g_level_procedure,
217: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
218: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(+)'||
219: ' taxation_country = ' || p_taxation_country||
220: ' document_sub_type = ' || p_document_sub_type);

Line 271: FND_LOG.STRING(g_level_error,

267: x_return_status );
268:
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: IF (g_level_error >= g_current_runtime_level ) THEN
271: FND_LOG.STRING(g_level_error,
272: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
273: 'Incorrect return_status after calling ' ||
274: 'ZX_TCM_EXT_SERVICES_PUB.GET_DEFAULT_COUNTRY_CODE');
275: FND_LOG.STRING(g_level_error,

Line 275: FND_LOG.STRING(g_level_error,

271: FND_LOG.STRING(g_level_error,
272: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
273: 'Incorrect return_status after calling ' ||
274: 'ZX_TCM_EXT_SERVICES_PUB.GET_DEFAULT_COUNTRY_CODE');
275: FND_LOG.STRING(g_level_error,
276: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
277: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
278: END IF;
279:

Line 287: FND_LOG.STRING(g_level_statement,

283:
284: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(p_trx_line_index) := l_country_code;
285:
286: IF (g_level_statement >= g_current_runtime_level ) THEN
287: FND_LOG.STRING(g_level_statement,
288: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
289: 'l_country_code = ' || l_country_code);
290: END IF;
291:

Line 306: FND_LOG.STRING(g_level_statement,

302: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(p_trx_line_index) IS NOT NULL OR
303: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSESSABLE_VALUE(p_trx_line_index) IS NOT NULL) THEN
304:
305: IF (g_level_statement >= g_current_runtime_level ) THEN
306: FND_LOG.STRING(g_level_statement,
307: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
308: 'One of the defaulting tax attributes are not null. So defaulting logic is not required.' ||
309: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS()');
310: FND_LOG.STRING(g_level_statement,

Line 310: FND_LOG.STRING(g_level_statement,

306: FND_LOG.STRING(g_level_statement,
307: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
308: 'One of the defaulting tax attributes are not null. So defaulting logic is not required.' ||
309: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS()');
310: FND_LOG.STRING(g_level_statement,
311: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
312: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');
313: END IF;
314:

Line 344: FND_LOG.STRING(g_level_error,

340: p_return_status => x_return_status);
341:
342: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
343: IF (g_level_error >= g_current_runtime_level ) THEN
344: FND_LOG.STRING(g_level_error,
345: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
346: 'Incorrect return_status after calling ' ||
347: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for document_sub_type');
348: FND_LOG.STRING(g_level_error,

Line 348: FND_LOG.STRING(g_level_error,

344: FND_LOG.STRING(g_level_error,
345: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
346: 'Incorrect return_status after calling ' ||
347: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for document_sub_type');
348: FND_LOG.STRING(g_level_error,
349: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
350: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
351: END IF;
352: RETURN;

Line 363: -- FND_LOG.STRING(g_level_event,

359: -- AND (country_code = l_country_code OR country_code IS NULL);
360: -- EXCEPTION
361: -- WHEN NO_DATA_FOUND THEN
362: -- IF (g_level_event >= g_current_runtime_level ) THEN
363: -- FND_LOG.STRING(g_level_event,
364: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
365: -- 'No document_sub_type Found. ');
366: -- END IF;
367: -- l_document_sub_type := NULL;

Line 370: -- FND_LOG.STRING(g_level_event,

366: -- END IF;
367: -- l_document_sub_type := NULL;
368: -- WHEN TOO_MANY_ROWS THEN
369: -- IF (g_level_event >= g_current_runtime_level ) THEN
370: -- FND_LOG.STRING(g_level_event,
371: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
372: -- 'No document_sub_type defaulted. ');
373: -- END IF;
374: -- l_document_sub_type := NULL;

Line 377: -- FND_LOG.STRING(g_level_event,

373: -- END IF;
374: -- l_document_sub_type := NULL;
375: -- WHEN OTHERS THEN
376: -- IF (g_level_event >= g_current_runtime_level ) THEN
377: -- FND_LOG.STRING(g_level_event,
378: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
379: -- sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
380: -- FND_LOG.STRING(g_level_event,
381: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

Line 380: -- FND_LOG.STRING(g_level_event,

376: -- IF (g_level_event >= g_current_runtime_level ) THEN
377: -- FND_LOG.STRING(g_level_event,
378: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
379: -- sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
380: -- FND_LOG.STRING(g_level_event,
381: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
382: -- 'Other Exception: This exception will not stop the program.');
383: -- END IF;
384: -- END;

Line 389: FND_LOG.STRING(g_level_statement,

385:
386: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(p_trx_line_index) := l_document_sub_type;
387:
388: IF (g_level_statement >= g_current_runtime_level ) THEN
389: FND_LOG.STRING(g_level_statement,
390: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
391: 'l_document_sub_type = ' || l_document_sub_type);
392: END IF;
393: END IF;

Line 404: FND_LOG.STRING(g_level_error,

400: x_return_status => x_return_status);
401:
402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
403: IF (g_level_error >= g_current_runtime_level ) THEN
404: FND_LOG.STRING(g_level_error,
405: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
406: 'Incorrect return_status after calling ' ||
407: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
408: FND_LOG.STRING(g_level_error,

Line 408: FND_LOG.STRING(g_level_error,

404: FND_LOG.STRING(g_level_error,
405: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
406: 'Incorrect return_status after calling ' ||
407: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
408: FND_LOG.STRING(g_level_error,
409: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
410: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
411: END IF;
412: RETURN;

Line 443: FND_LOG.STRING(g_level_error,

439: );
440:
441: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
442: IF (g_level_error >= g_current_runtime_level ) THEN
443: FND_LOG.STRING(g_level_error,
444: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
445: 'Incorrect return_status after calling ' ||
446: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
447: FND_LOG.STRING(g_level_error,

Line 447: FND_LOG.STRING(g_level_error,

443: FND_LOG.STRING(g_level_error,
444: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
445: 'Incorrect return_status after calling ' ||
446: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
447: FND_LOG.STRING(g_level_error,
448: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
449: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
450: END IF;
451: RETURN;

Line 483: -- FND_LOG.STRING(g_level_statement,

479: -- p_return_status => x_return_status);
480: --
481: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
482: -- IF (g_level_statement >= g_current_runtime_level ) THEN
483: -- FND_LOG.STRING(g_level_statement,
484: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
485: -- 'Incorrect return_status after calling ' ||
486: -- 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for user_defined');
487: -- FND_LOG.STRING(g_level_statement,

Line 487: -- FND_LOG.STRING(g_level_statement,

483: -- FND_LOG.STRING(g_level_statement,
484: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
485: -- 'Incorrect return_status after calling ' ||
486: -- 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for user_defined');
487: -- FND_LOG.STRING(g_level_statement,
488: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
489: -- 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
490: -- END IF;
491: -- RETURN;

Line 495: -- FND_LOG.STRING(g_level_statement,

491: -- RETURN;
492: -- END IF;
493: --
494: -- IF (g_level_statement >= g_current_runtime_level ) THEN
495: -- FND_LOG.STRING(g_level_statement,
496: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
497: -- 'l_user_defined_fisc_class= ' || l_user_defined_fisc_class);
498: -- END IF;
499: --

Line 508: FND_LOG.STRING(g_level_procedure,

504: END IF; -- End of Tax method check
505:
506: IF (g_level_procedure >= g_current_runtime_level ) THEN
507:
508: FND_LOG.STRING(g_level_procedure,
509: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
510: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
511: END IF;
512:

Line 532: FND_LOG.STRING(g_level_unexpected,

528: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
529: END IF;
530:
531: IF (g_level_unexpected >= g_current_runtime_level ) THEN
532: FND_LOG.STRING(g_level_unexpected,
533: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
534: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
535: FND_LOG.STRING(g_level_unexpected,
536: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

Line 535: FND_LOG.STRING(g_level_unexpected,

531: IF (g_level_unexpected >= g_current_runtime_level ) THEN
532: FND_LOG.STRING(g_level_unexpected,
533: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
534: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
535: FND_LOG.STRING(g_level_unexpected,
536: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
537: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');
538: END IF;
539:

Line 566: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563: -- end bug#6503114
564:
565: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
567: END IF;
568:
569: BEGIN
570: SELECT nvl(global_attribute8,'0') global_attribute8,

Line 580: FND_LOG.STRING(g_level_statement,

576: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_trx_line_index), -99);
577: EXCEPTION
578: WHEN NO_DATA_FOUND THEN
579: IF (g_level_statement >= g_current_runtime_level ) THEN
580: FND_LOG.STRING(g_level_statement,
581: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
582: 'No Record Found for tax_invoice_number and tax_invoice_date.');
583: END IF;
584: WHEN OTHERS THEN

Line 586: FND_LOG.STRING(g_level_unexpected,

582: 'No Record Found for tax_invoice_number and tax_invoice_date.');
583: END IF;
584: WHEN OTHERS THEN
585: IF (g_level_unexpected >= g_current_runtime_level ) THEN
586: FND_LOG.STRING(g_level_unexpected,
587: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
588: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
589: END IF;
590: END;

Line 593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

589: END IF;
590: END;
591:
592: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
594: 'p_tax_invoice_number := ' || p_tax_invoice_number||
595: ' l_tax_invoice_number := ' || l_tax_invoice_number||
596: 'p_tax_invoice_date := ' || p_tax_invoice_date||
597: 'l_tax_invoice_date := ' || l_tax_invoice_date);

Line 621: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||l_api_name||'(-)');

617:
618: END IF;
619:
620: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
621: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||l_api_name||'(-)');
622: END IF;
623:
624: EXCEPTION
625:

Line 643: FND_LOG.STRING(g_level_unexpected,

639: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
640: END IF;
641:
642: IF (g_level_unexpected >= g_current_runtime_level ) THEN
643: FND_LOG.STRING(g_level_unexpected,
644: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
645: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
646: FND_LOG.STRING(g_level_unexpected,
647: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS.END',

Line 646: FND_LOG.STRING(g_level_unexpected,

642: IF (g_level_unexpected >= g_current_runtime_level ) THEN
643: FND_LOG.STRING(g_level_unexpected,
644: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
645: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
646: FND_LOG.STRING(g_level_unexpected,
647: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS.END',
648: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS(-)');
649: END IF;
650:

Line 670: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

666:
667: BEGIN
668:
669: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
670: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
671: END IF;
672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:

Line 760: FND_LOG.STRING(g_level_error,

756:
757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
758:
759: IF (g_level_error >= g_current_runtime_level ) THEN
760: FND_LOG.STRING(g_level_error,
761: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION',
762: 'Incorrect return_status after calling ' ||
763: 'ZX_TAX_DEFAULT_PKG.get_default_tax_classification');
764: FND_LOG.STRING(g_level_error,

Line 764: FND_LOG.STRING(g_level_error,

760: FND_LOG.STRING(g_level_error,
761: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION',
762: 'Incorrect return_status after calling ' ||
763: 'ZX_TAX_DEFAULT_PKG.get_default_tax_classification');
764: FND_LOG.STRING(g_level_error,
765: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION.END',
766: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION(-)');
767: END IF;
768:

Line 778: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||l_api_name||'(-)');

774:
775: END IF; -- End of PO Application check
776:
777: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
778: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||l_api_name||'(-)');
779: END IF;
780:
781: END DEFAULT_TAX_CLASSIFICATION;
782:

Line 802: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

798:
799: BEGIN
800:
801: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
802: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
803: END IF;
804:
805: DEFAULT_TAX_DET_FACTORS
806: (

Line 816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

812: );
813:
814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
815: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
817: 'after calling default_tax_det_factors RETURN_STATUS = ' || x_return_status);
818: END IF;
819: -- RETURN;
820: END IF;

Line 832: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

828: );
829:
830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
831: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
833: 'after calling default_tax_reporting_attribs RETURN_STATUS = ' || x_return_status);
834: END IF;
835: -- RETURN;
836: END IF;

Line 846: FND_LOG.STRING(G_LEVEL_error,G_MODULE_NAME||l_api_name,

842: );
843:
844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
845: IF ( G_LEVEL_error >= G_CURRENT_RUNTIME_LEVEL) THEN
846: FND_LOG.STRING(G_LEVEL_error,G_MODULE_NAME||l_api_name,
847: 'after calling default_tax_classification RETURN_STATUS = ' || x_return_status);
848: END IF;
849: -- RETURN;
850: END IF;

Line 873: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

869: l_zx_proudct_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
870:
871: BEGIN
872:
873: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
874:
875: IF (g_level_procedure >= g_current_runtime_level ) THEN
876: FND_LOG.STRING(g_level_procedure,
877: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.BEGIN',

Line 876: FND_LOG.STRING(g_level_procedure,

872:
873: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
874:
875: IF (g_level_procedure >= g_current_runtime_level ) THEN
876: FND_LOG.STRING(g_level_procedure,
877: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.BEGIN',
878: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(+)');
879: END IF;
880:

Line 913: FND_LOG.STRING(g_level_statement,

909: p_return_status => x_return_status);
910:
911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: IF (g_level_statement >= g_current_runtime_level ) THEN
913: FND_LOG.STRING(g_level_statement,
914: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
915: 'Incorrect return_status after calling ' ||
916: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code()');
917: FND_LOG.STRING(g_level_statement,

Line 917: FND_LOG.STRING(g_level_statement,

913: FND_LOG.STRING(g_level_statement,
914: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
915: 'Incorrect return_status after calling ' ||
916: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code()');
917: FND_LOG.STRING(g_level_statement,
918: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
919: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)');
920: END IF;
921: RETURN;

Line 927: FND_LOG.STRING(g_level_procedure,

923: END IF;
924:
925: IF (g_level_procedure >= g_current_runtime_level ) THEN
926:
927: FND_LOG.STRING(g_level_procedure,
928: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
929: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)'||
930: 'x_intended_use := ' || x_intended_use||
931: 'RETURN_STATUS = ' || x_return_status);

Line 944: FND_LOG.STRING(g_level_unexpected,

940: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
941: FND_MSG_PUB.Add;
942:
943: IF (g_level_unexpected >= g_current_runtime_level ) THEN
944: FND_LOG.STRING(g_level_unexpected,
945: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
946: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
947: FND_LOG.STRING(g_level_unexpected,
948: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',

Line 947: FND_LOG.STRING(g_level_unexpected,

943: IF (g_level_unexpected >= g_current_runtime_level ) THEN
944: FND_LOG.STRING(g_level_unexpected,
945: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
946: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
947: FND_LOG.STRING(g_level_unexpected,
948: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
949: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)');
950: END IF;
951:

Line 971: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

967: l_zx_proudct_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
968:
969: BEGIN
970:
971: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
972:
973: IF (g_level_procedure >= g_current_runtime_level ) THEN
974: FND_LOG.STRING(g_level_procedure,
975: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.BEGIN',

Line 974: FND_LOG.STRING(g_level_procedure,

970:
971: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
972:
973: IF (g_level_procedure >= g_current_runtime_level ) THEN
974: FND_LOG.STRING(g_level_procedure,
975: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.BEGIN',
976: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(+)');
977: END IF;
978:

Line 1004: FND_LOG.STRING(g_level_error,

1000: p_return_status => x_return_status);
1001:
1002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1003: IF (g_level_error >= g_current_runtime_level ) THEN
1004: FND_LOG.STRING(g_level_error,
1005: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1006: 'Incorrect return_status after calling ' ||
1007: 'ZX_TCM_EXT_SERVICES_PUB.get_default_product_classif()');
1008: FND_LOG.STRING(g_level_error,

Line 1008: FND_LOG.STRING(g_level_error,

1004: FND_LOG.STRING(g_level_error,
1005: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1006: 'Incorrect return_status after calling ' ||
1007: 'ZX_TCM_EXT_SERVICES_PUB.get_default_product_classif()');
1008: FND_LOG.STRING(g_level_error,
1009: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1010: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||x_return_status);
1011: END IF;
1012: RETURN;

Line 1041: FND_LOG.STRING(g_level_unexpected,

1037:
1038: EXCEPTION
1039: WHEN NO_DATA_FOUND THEN
1040: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1041: FND_LOG.STRING(g_level_unexpected,
1042: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1043: 'Unable to default Product Fiscal Classification which is mandatory for LTE');
1044: END IF;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1063: FND_LOG.STRING(g_level_unexpected,

1059:
1060: EXCEPTION
1061: WHEN NO_DATA_FOUND THEN
1062: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1063: FND_LOG.STRING(g_level_unexpected,
1064: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1065: 'Unable to default Product Fiscal Classification ot Trx Business Category'||
1066: ' which is mandatory for LTE');
1067: END IF;

Line 1076: FND_LOG.STRING(g_level_procedure,

1072:
1073:
1074: IF (g_level_procedure >= g_current_runtime_level ) THEN
1075:
1076: FND_LOG.STRING(g_level_procedure,
1077: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1078: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||
1079: 'x_prod_fisc_class_code := ' || x_prod_fisc_class_code||
1080: 'RETURN_STATUS = ' || x_return_status);

Line 1093: FND_LOG.STRING(g_level_unexpected,

1089: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1090: FND_MSG_PUB.Add;
1091:
1092: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1093: FND_LOG.STRING(g_level_unexpected,
1094: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1095: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1096: FND_LOG.STRING(g_level_unexpected,
1097: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',

Line 1096: FND_LOG.STRING(g_level_unexpected,

1092: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1093: FND_LOG.STRING(g_level_unexpected,
1094: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1095: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1096: FND_LOG.STRING(g_level_unexpected,
1097: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1098: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)');
1099: END IF;
1100:

Line 1121: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1117: l_error_buffer VARCHAR2(256);
1118:
1119: BEGIN
1120:
1121: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1122:
1123: IF (g_level_procedure >= g_current_runtime_level ) THEN
1124: FND_LOG.STRING(g_level_procedure,
1125: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.BEGIN',

Line 1124: FND_LOG.STRING(g_level_procedure,

1120:
1121: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1122:
1123: IF (g_level_procedure >= g_current_runtime_level ) THEN
1124: FND_LOG.STRING(g_level_procedure,
1125: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.BEGIN',
1126: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(+)');
1127: END IF;
1128:

Line 1138: FND_LOG.STRING(g_level_procedure,

1134: x_assessable_value := p_line_amt;
1135:
1136: IF (g_level_procedure >= g_current_runtime_level ) THEN
1137:
1138: FND_LOG.STRING(g_level_procedure,
1139: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',
1140: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)'||
1141: ' assessable value: '||x_assessable_value);
1142: END IF;

Line 1154: FND_LOG.STRING(g_level_unexpected,

1150: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1151: FND_MSG_PUB.Add;
1152:
1153: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1154: FND_LOG.STRING(g_level_unexpected,
1155: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value',
1156: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1157: FND_LOG.STRING(g_level_unexpected,
1158: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',

Line 1157: FND_LOG.STRING(g_level_unexpected,

1153: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1154: FND_LOG.STRING(g_level_unexpected,
1155: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value',
1156: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1157: FND_LOG.STRING(g_level_unexpected,
1158: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',
1159: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)');
1160: END IF;
1161:

Line 1189: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1185: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1186:
1187: BEGIN
1188:
1189: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1190:
1191: IF (g_level_procedure >= g_current_runtime_level ) THEN
1192: FND_LOG.STRING(g_level_procedure,
1193: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.BEGIN',

Line 1192: FND_LOG.STRING(g_level_procedure,

1188:
1189: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1190:
1191: IF (g_level_procedure >= g_current_runtime_level ) THEN
1192: FND_LOG.STRING(g_level_procedure,
1193: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.BEGIN',
1194: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(+)');
1195: END IF;
1196:

Line 1215: FND_LOG.STRING(g_level_unexpected,

1211: x_return_status);
1212:
1213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1214: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1215: FND_LOG.STRING(g_level_unexpected,
1216: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1217: 'Incorrect return_status after calling ' ||
1218: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
1219: FND_LOG.STRING(g_level_unexpected,

Line 1219: FND_LOG.STRING(g_level_unexpected,

1215: FND_LOG.STRING(g_level_unexpected,
1216: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1217: 'Incorrect return_status after calling ' ||
1218: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
1219: FND_LOG.STRING(g_level_unexpected,
1220: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1221: 'RETURN_STATUS = ' || x_return_status);
1222: FND_LOG.STRING(g_level_unexpected,
1223: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',

Line 1222: FND_LOG.STRING(g_level_unexpected,

1218: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
1219: FND_LOG.STRING(g_level_unexpected,
1220: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1221: 'RETURN_STATUS = ' || x_return_status);
1222: FND_LOG.STRING(g_level_unexpected,
1223: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1224: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1225: END IF;
1226: RETURN;

Line 1240: FND_LOG.STRING(g_level_unexpected,

1236:
1237: EXCEPTION
1238: WHEN NO_DATA_FOUND THEN
1239: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1240: FND_LOG.STRING(g_level_unexpected,
1241: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1242: 'Invalid Tax Code Id: No Record Found');
1243: END IF;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261;

Line 1256: FND_LOG.STRING(g_level_statement,

1252: p_trx_line_index) := l_tax_classification_code;
1253:
1254: ELSE
1255: IF (g_level_statement >= g_current_runtime_level ) THEN
1256: FND_LOG.STRING(g_level_statement,
1257: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1258: 'No Valid Tax Classification Code Found for Tax Code Id: ' ||
1259: l_tax_code_id);
1260: END IF;

Line 1278: FND_LOG.STRING(g_level_unexpected,

1274: l_fnd_return := FND_INSTALLATION.get(401, 401, l_inv_flag, l_inv_industry);
1275:
1276: IF NOT l_fnd_return THEN
1277: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1278: FND_LOG.STRING(g_level_unexpected,
1279: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1280: 'Got error after calling FND_INSTALLATION.get');
1281: FND_LOG.STRING(g_level_unexpected,
1282: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',

Line 1281: FND_LOG.STRING(g_level_unexpected,

1277: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1278: FND_LOG.STRING(g_level_unexpected,
1279: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1280: 'Got error after calling FND_INSTALLATION.get');
1281: FND_LOG.STRING(g_level_unexpected,
1282: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1283: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1284: END IF;
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

Line 1293: FND_LOG.STRING(g_level_statement,

1289: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.global_attribute1(
1290: p_trx_line_index) IS NOT NULL THEN
1291:
1292: IF g_level_statement >= G_CURRENT_RUNTIME_LEVEL THEN
1293: FND_LOG.STRING(g_level_statement,
1294: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1295: 'Default Product Fisiclassification Code or Product Category');
1296: END IF;
1297:

Line 1328: FND_LOG.STRING(g_level_unexpected,

1324:
1325: EXCEPTION
1326: WHEN NO_DATA_FOUND THEN
1327: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1328: FND_LOG.STRING(g_level_unexpected,
1329: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1330: 'Not MTL Item Found');
1331: END IF;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

Line 1355: FND_LOG.STRING(g_level_statement,

1351: p_trx_line_index) IS NOT NULL
1352: THEN
1353:
1354: IF ( g_level_statement >= G_CURRENT_RUNTIME_LEVEL) THEN
1355: FND_LOG.STRING(g_level_statement,
1356: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1357: 'Default Transaction Business _category for Brazil');
1358: END IF;
1359:

Line 1375: FND_LOG.STRING(g_level_unexpected,

1371:
1372: EXCEPTION
1373: WHEN NO_DATA_FOUND THEN
1374: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1375: FND_LOG.STRING(g_level_unexpected,
1376: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1377: 'Not MTL Item Found');
1378: END IF;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

Line 1386: FND_LOG.STRING(g_level_procedure,

1382: END IF;
1383:
1384: IF (g_level_procedure >= g_current_runtime_level ) THEN
1385:
1386: FND_LOG.STRING(g_level_procedure,
1387: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1388: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)'||x_return_status);
1389: END IF;
1390:

Line 1410: FND_LOG.STRING(g_level_unexpected,

1406: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
1407: END IF;
1408:
1409: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1410: FND_LOG.STRING(g_level_unexpected,
1411: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1412: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1413: FND_LOG.STRING(g_level_unexpected,
1414: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',

Line 1413: FND_LOG.STRING(g_level_unexpected,

1409: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1410: FND_LOG.STRING(g_level_unexpected,
1411: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1412: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1413: FND_LOG.STRING(g_level_unexpected,
1414: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1415: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1416: END IF;
1417:

Line 1439: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1435:
1436: BEGIN
1437:
1438: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1440: END IF;
1441:
1442: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1443: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1439: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1440: END IF;
1441:
1442: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1444: ' p_tax_method_code := ' || p_tax_method_code ||
1445: ' p_internal_org_id := ' || to_char(p_internal_org_id) ||
1446: ' p_legal_entity_id := ' || to_char(p_legal_entity_id) );
1447: END IF;

Line 1465: FND_LOG.STRING(g_level_statement,

1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: IF (g_level_statement >= g_current_runtime_level ) THEN
1465: FND_LOG.STRING(g_level_statement,
1466: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1467: 'No COUNTRY_CODE Found For LTE.');
1468: END IF;
1469: WHEN OTHERS THEN

Line 1472: FND_LOG.STRING(g_level_unexpected,

1468: END IF;
1469: WHEN OTHERS THEN
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1472: FND_LOG.STRING(g_level_unexpected,
1473: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1474: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1475: END IF;
1476: END;

Line 1488: FND_LOG.STRING(g_level_statement,

1484: EXCEPTION
1485: WHEN NO_DATA_FOUND THEN
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: IF (g_level_statement >= g_current_runtime_level ) THEN
1488: FND_LOG.STRING(g_level_statement,
1489: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1490: 'No COUNTRY_CODE Found for EBTax. ');
1491: END IF;
1492: WHEN OTHERS THEN

Line 1495: FND_LOG.STRING(g_level_unexpected,

1491: END IF;
1492: WHEN OTHERS THEN
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1495: FND_LOG.STRING(g_level_unexpected,
1496: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1497: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1498: END IF;
1499: END;