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 ZX_DEFAULT_AUTOMATION_PKG

Line 1: PACKAGE BODY ZX_DEFAULT_AUTOMATION_PKG AS

1: PACKAGE BODY ZX_DEFAULT_AUTOMATION_PKG AS
2: /* $Header: zxdidefautopvtb.pls 120.43.12020000.4 2013/04/25 08:56:43 smuthusa ship $ */
3:
4: /* Declare constants */
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_DEFAULT_AUTOMATION_PKG';

2: /* $Header: zxdidefautopvtb.pls 120.43.12020000.4 2013/04/25 08:56:43 smuthusa ship $ */
3:
4: /* Declare constants */
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_DEFAULT_AUTOMATION_PKG';
7: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_DFLT_AUTO_PKG.';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

Line 62: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',

58: l_intrcmp_src_event_class_code VARCHAR2(30);
59: BEGIN
60: IF (g_level_procedure >= g_current_runtime_level ) THEN
61: FND_LOG.STRING(g_level_procedure,
62: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
63: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(+)');
64: END IF;
65:
66: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 63: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(+)');

59: BEGIN
60: IF (g_level_procedure >= g_current_runtime_level ) THEN
61: FND_LOG.STRING(g_level_procedure,
62: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
63: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(+)');
64: END IF;
65:
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: x_default := 'N';

Line 71: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

67: x_default := 'N';
68:
69: IF (g_level_statement >= g_current_runtime_level ) THEN
70: FND_LOG.STRING(g_level_statement,
71: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
72: 'default_taxation_country(' || p_trx_line_index || ') = '
73: || ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(p_trx_line_index) || '$' ||
74: 'DOCUMENT_SUB_TYPE = '
75: || ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(p_trx_line_index) || '$' ||

Line 219: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

215: );
216: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
218: FND_LOG.STRING(G_LEVEL_STATEMENT,
219: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
220: ' RETURN_STATUS = ' || x_return_status);
221: END IF;
222: RETURN;
223: END IF;

Line 303: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

299: --Bug 14265312, Retain user_upd_det_factors_flag if the profile to retain manual tax from REQ to PO is Y
300: IF NVL(FND_PROFILE.value('PO_RETAIN_MANUALLY_UPDATED_PR_TAX_ON_PO'), 'N') = 'Y' THEN
301: IF (g_level_procedure >= g_current_runtime_level ) THEN
302: FND_LOG.STRING(g_level_procedure,
303: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
304: 'Retain manual tax from requisition to purchase order: Yes ');
305: END IF;
306:
307: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_upd_det_factors_flag(p_trx_line_index) := l_det_tax_attr_tbl(l_source_line_key).USER_OVERRIDE_TAX_FLAG;

Line 323: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

319: END IF;
320:
321: IF (g_level_statement >= g_current_runtime_level ) THEN
322: FND_LOG.STRING(g_level_statement,
323: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
324: 'default_taxation_country(' || p_trx_line_index || ') = '
325: || ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(p_trx_line_index) || '$' ||
326: 'DOCUMENT_SUB_TYPE = '
327: || ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(p_trx_line_index) || '$' ||

Line 359: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

355: END IF;
356:
357: IF (g_level_procedure >= g_current_runtime_level ) THEN
358: FND_LOG.STRING(g_level_procedure,
359: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
360: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(-)');
361: END IF;
362:
363: END DEFAULT_FROM_SOURCE_DOC;

Line 360: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(-)');

356:
357: IF (g_level_procedure >= g_current_runtime_level ) THEN
358: FND_LOG.STRING(g_level_procedure,
359: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
360: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(-)');
361: END IF;
362:
363: END DEFAULT_FROM_SOURCE_DOC;
364:

Line 409: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',

405: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
406:
407: IF (g_level_procedure >= g_current_runtime_level ) THEN
408: FND_LOG.STRING(g_level_procedure,
409: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
410: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(+)'||
411: ' taxation_country = ' || p_taxation_country||
412: ' document_sub_type = ' || p_document_sub_type);
413: END IF;

Line 410: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(+)'||

406:
407: IF (g_level_procedure >= g_current_runtime_level ) THEN
408: FND_LOG.STRING(g_level_procedure,
409: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
410: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(+)'||
411: ' taxation_country = ' || p_taxation_country||
412: ' document_sub_type = ' || p_document_sub_type);
413: END IF;
414:

Line 468: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

464:
465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
466: IF (g_level_error >= g_current_runtime_level ) THEN
467: FND_LOG.STRING(g_level_error,
468: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
469: 'Incorrect return_status after calling ' ||
470: 'ZX_TCM_EXT_SERVICES_PUB.GET_DEFAULT_COUNTRY_CODE');
471: FND_LOG.STRING(g_level_error,
472: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

Line 472: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

468: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
469: 'Incorrect return_status after calling ' ||
470: 'ZX_TCM_EXT_SERVICES_PUB.GET_DEFAULT_COUNTRY_CODE');
471: FND_LOG.STRING(g_level_error,
472: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
473: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
474: END IF;
475:
476: RETURN;

Line 473: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);

469: 'Incorrect return_status after calling ' ||
470: 'ZX_TCM_EXT_SERVICES_PUB.GET_DEFAULT_COUNTRY_CODE');
471: FND_LOG.STRING(g_level_error,
472: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
473: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
474: END IF;
475:
476: RETURN;
477:

Line 484: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

480: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(p_trx_line_index) := l_country_code;
481:
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: 'l_country_code = ' || l_country_code);
486: END IF;
487:
488: ELSE

Line 503: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

499: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSESSABLE_VALUE(p_trx_line_index) IS NOT NULL) THEN
500:
501: IF (g_level_statement >= g_current_runtime_level ) THEN
502: FND_LOG.STRING(g_level_statement,
503: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
504: 'One of the defaulting tax attributes are not null. So defaulting logic is not required.' ||
505: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS()');
506: FND_LOG.STRING(g_level_statement,
507: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

Line 505: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS()');

501: IF (g_level_statement >= g_current_runtime_level ) THEN
502: FND_LOG.STRING(g_level_statement,
503: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
504: 'One of the defaulting tax attributes are not null. So defaulting logic is not required.' ||
505: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS()');
506: FND_LOG.STRING(g_level_statement,
507: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
508: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');
509: END IF;

Line 507: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

503: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
504: 'One of the defaulting tax attributes are not null. So defaulting logic is not required.' ||
505: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS()');
506: FND_LOG.STRING(g_level_statement,
507: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
508: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');
509: END IF;
510:
511: RETURN;

Line 508: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');

504: 'One of the defaulting tax attributes are not null. So defaulting logic is not required.' ||
505: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS()');
506: FND_LOG.STRING(g_level_statement,
507: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
508: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');
509: END IF;
510:
511: RETURN;
512: END IF;

Line 541: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

537:
538: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
539: IF (g_level_error >= g_current_runtime_level ) THEN
540: FND_LOG.STRING(g_level_error,
541: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
542: 'Incorrect return_status after calling ' ||
543: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for document_sub_type');
544: FND_LOG.STRING(g_level_error,
545: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

Line 545: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

541: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
542: 'Incorrect return_status after calling ' ||
543: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for document_sub_type');
544: FND_LOG.STRING(g_level_error,
545: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
546: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
547: END IF;
548: RETURN;
549: END IF;

Line 546: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);

542: 'Incorrect return_status after calling ' ||
543: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for document_sub_type');
544: FND_LOG.STRING(g_level_error,
545: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
546: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
547: END IF;
548: RETURN;
549: END IF;
550:

Line 560: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

556: -- EXCEPTION
557: -- WHEN NO_DATA_FOUND THEN
558: -- IF (g_level_event >= g_current_runtime_level ) THEN
559: -- FND_LOG.STRING(g_level_event,
560: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
561: -- 'No document_sub_type Found. ');
562: -- END IF;
563: -- l_document_sub_type := NULL;
564: -- WHEN TOO_MANY_ROWS THEN

Line 567: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

563: -- l_document_sub_type := NULL;
564: -- WHEN TOO_MANY_ROWS THEN
565: -- IF (g_level_event >= g_current_runtime_level ) THEN
566: -- FND_LOG.STRING(g_level_event,
567: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
568: -- 'No document_sub_type defaulted. ');
569: -- END IF;
570: -- l_document_sub_type := NULL;
571: -- WHEN OTHERS THEN

Line 574: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

570: -- l_document_sub_type := NULL;
571: -- WHEN OTHERS THEN
572: -- IF (g_level_event >= g_current_runtime_level ) THEN
573: -- FND_LOG.STRING(g_level_event,
574: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
575: -- sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
576: -- FND_LOG.STRING(g_level_event,
577: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
578: -- 'Other Exception: This exception will not stop the program.');

Line 577: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

573: -- FND_LOG.STRING(g_level_event,
574: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
575: -- sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
576: -- FND_LOG.STRING(g_level_event,
577: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
578: -- 'Other Exception: This exception will not stop the program.');
579: -- END IF;
580: -- END;
581:

Line 586: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

582: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(p_trx_line_index) := l_document_sub_type;
583:
584: IF (g_level_statement >= g_current_runtime_level ) THEN
585: FND_LOG.STRING(g_level_statement,
586: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
587: 'l_document_sub_type = ' || l_document_sub_type);
588: END IF;
589: END IF;
590:

Line 601: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

597:
598: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
599: IF (g_level_error >= g_current_runtime_level ) THEN
600: FND_LOG.STRING(g_level_error,
601: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
602: 'Incorrect return_status after calling ' ||
603: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
604: FND_LOG.STRING(g_level_error,
605: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

Line 605: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

601: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
602: 'Incorrect return_status after calling ' ||
603: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
604: FND_LOG.STRING(g_level_error,
605: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
606: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
607: END IF;
608: RETURN;
609: END IF;

Line 606: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);

602: 'Incorrect return_status after calling ' ||
603: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
604: FND_LOG.STRING(g_level_error,
605: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
606: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
607: END IF;
608: RETURN;
609: END IF;
610: ELSE -- if tax method is ETAX then

Line 622: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

618: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.product_org_id(p_trx_line_index));
619: END IF;
620: IF (g_level_statement >= g_current_runtime_level ) THEN
621: FND_LOG.STRING(g_level_statement,
622: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
623: 'l_inventory_org_id = ' || NVL(l_inventory_org_id,-99));
624: END IF;
625: ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS
626: (p_api_version => 1.0,

Line 652: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

648:
649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
650: IF (g_level_error >= g_current_runtime_level ) THEN
651: FND_LOG.STRING(g_level_error,
652: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
653: 'Incorrect return_status after calling ' ||
654: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
655: FND_LOG.STRING(g_level_error,
656: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

Line 656: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

652: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
653: 'Incorrect return_status after calling ' ||
654: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
655: FND_LOG.STRING(g_level_error,
656: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
657: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
658: END IF;
659: RETURN;
660: END IF;

Line 657: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);

653: 'Incorrect return_status after calling ' ||
654: 'ZX_API_PUB.GET_DEFAULT_TAX_DET_ATTRIBS');
655: FND_LOG.STRING(g_level_error,
656: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
657: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
658: END IF;
659: RETURN;
660: END IF;
661:

Line 692: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

688: --
689: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
690: -- IF (g_level_statement >= g_current_runtime_level ) THEN
691: -- FND_LOG.STRING(g_level_statement,
692: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
693: -- 'Incorrect return_status after calling ' ||
694: -- 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for user_defined');
695: -- FND_LOG.STRING(g_level_statement,
696: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

Line 696: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

692: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
693: -- 'Incorrect return_status after calling ' ||
694: -- 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for user_defined');
695: -- FND_LOG.STRING(g_level_statement,
696: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
697: -- 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
698: -- END IF;
699: -- RETURN;
700: -- END IF;

Line 697: -- 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);

693: -- 'Incorrect return_status after calling ' ||
694: -- 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code for user_defined');
695: -- FND_LOG.STRING(g_level_statement,
696: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
697: -- 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
698: -- END IF;
699: -- RETURN;
700: -- END IF;
701: --

Line 704: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

700: -- END IF;
701: --
702: -- IF (g_level_statement >= g_current_runtime_level ) THEN
703: -- FND_LOG.STRING(g_level_statement,
704: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
705: -- 'l_user_defined_fisc_class= ' || l_user_defined_fisc_class);
706: -- END IF;
707: --
708: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(

Line 717: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

713:
714: IF (g_level_procedure >= g_current_runtime_level ) THEN
715:
716: FND_LOG.STRING(g_level_procedure,
717: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
718: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
719: END IF;
720:
721: EXCEPTION

Line 718: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);

714: IF (g_level_procedure >= g_current_runtime_level ) THEN
715:
716: FND_LOG.STRING(g_level_procedure,
717: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
718: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)'||x_return_status);
719: END IF;
720:
721: EXCEPTION
722:

Line 741: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

737: END IF;
738:
739: IF (g_level_unexpected >= g_current_runtime_level ) THEN
740: FND_LOG.STRING(g_level_unexpected,
741: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
742: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
743: FND_LOG.STRING(g_level_unexpected,
744: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
745: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');

Line 744: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',

740: FND_LOG.STRING(g_level_unexpected,
741: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
742: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
743: FND_LOG.STRING(g_level_unexpected,
744: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
745: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');
746: END IF;
747:
748: END DEFAULT_TAX_DET_FACTORS;

Line 745: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');

741: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
742: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
743: FND_LOG.STRING(g_level_unexpected,
744: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.END',
745: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS(-)');
746: END IF;
747:
748: END DEFAULT_TAX_DET_FACTORS;
749:

Line 789: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',

785: EXCEPTION
786: WHEN NO_DATA_FOUND THEN
787: IF (g_level_statement >= g_current_runtime_level ) THEN
788: FND_LOG.STRING(g_level_statement,
789: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
790: 'No Record Found for tax_invoice_number and tax_invoice_date.');
791: END IF;
792: WHEN OTHERS THEN
793: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 795: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',

791: END IF;
792: WHEN OTHERS THEN
793: IF (g_level_unexpected >= g_current_runtime_level ) THEN
794: FND_LOG.STRING(g_level_unexpected,
795: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
796: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
797: END IF;
798: END;
799:

Line 852: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',

848: END IF;
849:
850: IF (g_level_unexpected >= g_current_runtime_level ) THEN
851: FND_LOG.STRING(g_level_unexpected,
852: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
853: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
854: FND_LOG.STRING(g_level_unexpected,
855: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS.END',
856: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS(-)');

Line 855: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS.END',

851: FND_LOG.STRING(g_level_unexpected,
852: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
853: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
854: FND_LOG.STRING(g_level_unexpected,
855: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS.END',
856: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS(-)');
857: END IF;
858:
859:

Line 856: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS(-)');

852: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS',
853: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
854: FND_LOG.STRING(g_level_unexpected,
855: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS.END',
856: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS(-)');
857: END IF;
858:
859:
860: END DEFAULT_TAX_REPORTING_ATTRIBS;

Line 969: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION',

965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
966:
967: IF (g_level_error >= g_current_runtime_level ) THEN
968: FND_LOG.STRING(g_level_error,
969: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION',
970: 'Incorrect return_status after calling ' ||
971: 'ZX_TAX_DEFAULT_PKG.get_default_tax_classification');
972: FND_LOG.STRING(g_level_error,
973: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION.END',

Line 973: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION.END',

969: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION',
970: 'Incorrect return_status after calling ' ||
971: 'ZX_TAX_DEFAULT_PKG.get_default_tax_classification');
972: FND_LOG.STRING(g_level_error,
973: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION.END',
974: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION(-)');
975: END IF;
976:
977: RETURN;

Line 974: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION(-)');

970: 'Incorrect return_status after calling ' ||
971: 'ZX_TAX_DEFAULT_PKG.get_default_tax_classification');
972: FND_LOG.STRING(g_level_error,
973: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION.END',
974: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION(-)');
975: END IF;
976:
977: RETURN;
978:

Line 1085: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.BEGIN',

1081: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1082:
1083: IF (g_level_procedure >= g_current_runtime_level ) THEN
1084: FND_LOG.STRING(g_level_procedure,
1085: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.BEGIN',
1086: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(+)');
1087: END IF;
1088:
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1086: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(+)');

1082:
1083: IF (g_level_procedure >= g_current_runtime_level ) THEN
1084: FND_LOG.STRING(g_level_procedure,
1085: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.BEGIN',
1086: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(+)');
1087: END IF;
1088:
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:

Line 1122: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',

1118:
1119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1120: IF (g_level_statement >= g_current_runtime_level ) THEN
1121: FND_LOG.STRING(g_level_statement,
1122: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
1123: 'Incorrect return_status after calling ' ||
1124: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code()');
1125: FND_LOG.STRING(g_level_statement,
1126: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',

Line 1126: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',

1122: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
1123: 'Incorrect return_status after calling ' ||
1124: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code()');
1125: FND_LOG.STRING(g_level_statement,
1126: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
1127: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)');
1128: END IF;
1129: RETURN;
1130: END IF;

Line 1127: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)');

1123: 'Incorrect return_status after calling ' ||
1124: 'ZX_TCM_EXT_SERVICES_PUB.get_default_classif_code()');
1125: FND_LOG.STRING(g_level_statement,
1126: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
1127: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)');
1128: END IF;
1129: RETURN;
1130: END IF;
1131: END IF;

Line 1136: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',

1132:
1133: IF (g_level_procedure >= g_current_runtime_level ) THEN
1134:
1135: FND_LOG.STRING(g_level_procedure,
1136: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
1137: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)'||
1138: 'x_intended_use := ' || x_intended_use||
1139: 'RETURN_STATUS = ' || x_return_status);
1140: END IF;

Line 1137: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)'||

1133: IF (g_level_procedure >= g_current_runtime_level ) THEN
1134:
1135: FND_LOG.STRING(g_level_procedure,
1136: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
1137: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)'||
1138: 'x_intended_use := ' || x_intended_use||
1139: 'RETURN_STATUS = ' || x_return_status);
1140: END IF;
1141:

Line 1153: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',

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

Line 1156: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',

1152: FND_LOG.STRING(g_level_unexpected,
1153: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
1154: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1155: FND_LOG.STRING(g_level_unexpected,
1156: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.END',
1157: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)');
1158: END IF;
1159:
1160: END redefault_intended_use;

Line 1157: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(-)');

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

Line 1183: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.BEGIN',

1179: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1180:
1181: IF (g_level_procedure >= g_current_runtime_level ) THEN
1182: FND_LOG.STRING(g_level_procedure,
1183: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.BEGIN',
1184: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(+)');
1185: END IF;
1186:
1187: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1184: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(+)');

1180:
1181: IF (g_level_procedure >= g_current_runtime_level ) THEN
1182: FND_LOG.STRING(g_level_procedure,
1183: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.BEGIN',
1184: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(+)');
1185: END IF;
1186:
1187: x_return_status := FND_API.G_RET_STS_SUCCESS;
1188:

Line 1213: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',

1209:
1210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1211: IF (g_level_error >= g_current_runtime_level ) THEN
1212: FND_LOG.STRING(g_level_error,
1213: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1214: 'Incorrect return_status after calling ' ||
1215: 'ZX_TCM_EXT_SERVICES_PUB.get_default_product_classif()');
1216: FND_LOG.STRING(g_level_error,
1217: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',

Line 1217: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',

1213: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1214: 'Incorrect return_status after calling ' ||
1215: 'ZX_TCM_EXT_SERVICES_PUB.get_default_product_classif()');
1216: FND_LOG.STRING(g_level_error,
1217: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1218: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||x_return_status);
1219: END IF;
1220: RETURN;
1221: END IF;

Line 1218: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||x_return_status);

1214: 'Incorrect return_status after calling ' ||
1215: 'ZX_TCM_EXT_SERVICES_PUB.get_default_product_classif()');
1216: FND_LOG.STRING(g_level_error,
1217: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1218: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||x_return_status);
1219: END IF;
1220: RETURN;
1221: END IF;
1222: ELSIF l_tax_method = 'LTE' THEN

Line 1250: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',

1246: EXCEPTION
1247: WHEN NO_DATA_FOUND THEN
1248: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1249: FND_LOG.STRING(g_level_unexpected,
1250: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1251: 'Unable to default Product Fiscal Classification which is mandatory for LTE');
1252: END IF;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:

Line 1285: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',

1281:
1282: IF (g_level_procedure >= g_current_runtime_level ) THEN
1283:
1284: FND_LOG.STRING(g_level_procedure,
1285: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1286: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||
1287: 'x_prod_fisc_class_code := ' || x_prod_fisc_class_code||
1288: 'RETURN_STATUS = ' || x_return_status);
1289: END IF;

Line 1286: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||

1282: IF (g_level_procedure >= g_current_runtime_level ) THEN
1283:
1284: FND_LOG.STRING(g_level_procedure,
1285: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1286: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)'||
1287: 'x_prod_fisc_class_code := ' || x_prod_fisc_class_code||
1288: 'RETURN_STATUS = ' || x_return_status);
1289: END IF;
1290:

Line 1302: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',

1298: FND_MSG_PUB.Add;
1299:
1300: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1301: FND_LOG.STRING(g_level_unexpected,
1302: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1303: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1304: FND_LOG.STRING(g_level_unexpected,
1305: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1306: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)');

Line 1305: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',

1301: FND_LOG.STRING(g_level_unexpected,
1302: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1303: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1304: FND_LOG.STRING(g_level_unexpected,
1305: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1306: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)');
1307: END IF;
1308:
1309: END redefault_prod_fisc_class_code;

Line 1306: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)');

1302: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1303: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1304: FND_LOG.STRING(g_level_unexpected,
1305: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.END',
1306: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(-)');
1307: END IF;
1308:
1309: END redefault_prod_fisc_class_code;
1310:

Line 1333: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.BEGIN',

1329: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1330:
1331: IF (g_level_procedure >= g_current_runtime_level ) THEN
1332: FND_LOG.STRING(g_level_procedure,
1333: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.BEGIN',
1334: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(+)');
1335: END IF;
1336:
1337: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1334: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(+)');

1330:
1331: IF (g_level_procedure >= g_current_runtime_level ) THEN
1332: FND_LOG.STRING(g_level_procedure,
1333: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.BEGIN',
1334: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(+)');
1335: END IF;
1336:
1337: x_return_status := FND_API.G_RET_STS_SUCCESS;
1338:

Line 1347: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',

1343:
1344: IF (g_level_procedure >= g_current_runtime_level ) THEN
1345:
1346: FND_LOG.STRING(g_level_procedure,
1347: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',
1348: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)'||
1349: ' assessable value: '||x_assessable_value);
1350: END IF;
1351:

Line 1348: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)'||

1344: IF (g_level_procedure >= g_current_runtime_level ) THEN
1345:
1346: FND_LOG.STRING(g_level_procedure,
1347: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',
1348: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)'||
1349: ' assessable value: '||x_assessable_value);
1350: END IF;
1351:
1352: EXCEPTION

Line 1363: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value',

1359: FND_MSG_PUB.Add;
1360:
1361: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1362: FND_LOG.STRING(g_level_unexpected,
1363: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value',
1364: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1365: FND_LOG.STRING(g_level_unexpected,
1366: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',
1367: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)');

Line 1366: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',

1362: FND_LOG.STRING(g_level_unexpected,
1363: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value',
1364: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1365: FND_LOG.STRING(g_level_unexpected,
1366: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',
1367: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)');
1368: END IF;
1369:
1370: END redefault_assessable_value;

Line 1367: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)');

1363: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value',
1364: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1365: FND_LOG.STRING(g_level_unexpected,
1366: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.END',
1367: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(-)');
1368: END IF;
1369:
1370: END redefault_assessable_value;
1371:

Line 1401: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.BEGIN',

1397: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1398:
1399: IF (g_level_procedure >= g_current_runtime_level ) THEN
1400: FND_LOG.STRING(g_level_procedure,
1401: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.BEGIN',
1402: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(+)');
1403: END IF;
1404:
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1402: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(+)');

1398:
1399: IF (g_level_procedure >= g_current_runtime_level ) THEN
1400: FND_LOG.STRING(g_level_procedure,
1401: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.BEGIN',
1402: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(+)');
1403: END IF;
1404:
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406:

Line 1424: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1420:
1421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1422: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1423: FND_LOG.STRING(g_level_unexpected,
1424: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1425: 'Incorrect return_status after calling ' ||
1426: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
1427: FND_LOG.STRING(g_level_unexpected,
1428: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

Line 1428: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1424: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1425: 'Incorrect return_status after calling ' ||
1426: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
1427: FND_LOG.STRING(g_level_unexpected,
1428: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1429: 'RETURN_STATUS = ' || x_return_status);
1430: FND_LOG.STRING(g_level_unexpected,
1431: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1432: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');

Line 1431: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',

1427: FND_LOG.STRING(g_level_unexpected,
1428: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1429: 'RETURN_STATUS = ' || x_return_status);
1430: FND_LOG.STRING(g_level_unexpected,
1431: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1432: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1433: END IF;
1434: RETURN;
1435: END IF;

Line 1432: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');

1428: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1429: 'RETURN_STATUS = ' || x_return_status);
1430: FND_LOG.STRING(g_level_unexpected,
1431: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1432: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1433: END IF;
1434: RETURN;
1435: END IF;
1436:

Line 1449: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1445: EXCEPTION
1446: WHEN NO_DATA_FOUND THEN
1447: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1448: FND_LOG.STRING(g_level_unexpected,
1449: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1450: 'Invalid Tax Code Id: No Record Found');
1451: END IF;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261;
1453: END;

Line 1465: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1461:
1462: ELSE
1463: IF (g_level_statement >= g_current_runtime_level ) THEN
1464: FND_LOG.STRING(g_level_statement,
1465: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1466: 'No Valid Tax Classification Code Found for Tax Code Id: ' ||
1467: l_tax_code_id);
1468: END IF;
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

Line 1487: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1483:
1484: IF NOT l_fnd_return THEN
1485: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1486: FND_LOG.STRING(g_level_unexpected,
1487: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1488: 'Got error after calling FND_INSTALLATION.get');
1489: FND_LOG.STRING(g_level_unexpected,
1490: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1491: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');

Line 1490: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',

1486: FND_LOG.STRING(g_level_unexpected,
1487: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1488: 'Got error after calling FND_INSTALLATION.get');
1489: FND_LOG.STRING(g_level_unexpected,
1490: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1491: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1492: END IF;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1494: RETURN;

Line 1491: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');

1487: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1488: 'Got error after calling FND_INSTALLATION.get');
1489: FND_LOG.STRING(g_level_unexpected,
1490: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1491: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1492: END IF;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1494: RETURN;
1495: END IF;

Line 1502: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1498: p_trx_line_index) IS NOT NULL THEN
1499:
1500: IF g_level_statement >= G_CURRENT_RUNTIME_LEVEL THEN
1501: FND_LOG.STRING(g_level_statement,
1502: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1503: 'Default Product Fisiclassification Code or Product Category');
1504: END IF;
1505:
1506: IF l_country_code = 'BR' THEN

Line 1537: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1533: EXCEPTION
1534: WHEN NO_DATA_FOUND THEN
1535: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1536: FND_LOG.STRING(g_level_unexpected,
1537: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1538: 'Not MTL Item Found');
1539: END IF;
1540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1541: END;

Line 1564: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1560: THEN
1561:
1562: IF ( g_level_statement >= G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING(g_level_statement,
1564: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1565: 'Default Transaction Business _category for Brazil');
1566: END IF;
1567:
1568: IF l_country_code = 'BR' THEN

Line 1584: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN
1582: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1583: FND_LOG.STRING(g_level_unexpected,
1584: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1585: 'Not MTL Item Found');
1586: END IF;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1588: END;

Line 1595: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',

1591:
1592: IF (g_level_procedure >= g_current_runtime_level ) THEN
1593:
1594: FND_LOG.STRING(g_level_procedure,
1595: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1596: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)'||x_return_status);
1597: END IF;
1598:
1599: EXCEPTION

Line 1596: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)'||x_return_status);

1592: IF (g_level_procedure >= g_current_runtime_level ) THEN
1593:
1594: FND_LOG.STRING(g_level_procedure,
1595: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1596: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)'||x_return_status);
1597: END IF;
1598:
1599: EXCEPTION
1600: WHEN OTHERS THEN

Line 1619: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',

1615: END IF;
1616:
1617: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1618: FND_LOG.STRING(g_level_unexpected,
1619: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1620: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1621: FND_LOG.STRING(g_level_unexpected,
1622: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1623: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');

Line 1622: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',

1618: FND_LOG.STRING(g_level_unexpected,
1619: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1620: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1621: FND_LOG.STRING(g_level_unexpected,
1622: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1623: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1624: END IF;
1625:
1626: END default_tax_attributes_for_po;

Line 1623: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');

1619: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1620: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1621: FND_LOG.STRING(g_level_unexpected,
1622: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1623: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1624: END IF;
1625:
1626: END default_tax_attributes_for_po;
1627:

Line 1674: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',

1670: WHEN NO_DATA_FOUND THEN
1671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1672: IF (g_level_statement >= g_current_runtime_level ) THEN
1673: FND_LOG.STRING(g_level_statement,
1674: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1675: 'No COUNTRY_CODE Found For LTE.');
1676: END IF;
1677: WHEN OTHERS THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1681: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',

1677: WHEN OTHERS THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1680: FND_LOG.STRING(g_level_unexpected,
1681: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1682: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1683: END IF;
1684: END;
1685:

Line 1697: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',

1693: WHEN NO_DATA_FOUND THEN
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: IF (g_level_statement >= g_current_runtime_level ) THEN
1696: FND_LOG.STRING(g_level_statement,
1697: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1698: 'No COUNTRY_CODE Found for EBTax. ');
1699: END IF;
1700: WHEN OTHERS THEN
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1704: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',

1700: WHEN OTHERS THEN
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1703: FND_LOG.STRING(g_level_unexpected,
1704: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1705: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1706: END IF;
1707: END;
1708:

Line 1715: END ZX_DEFAULT_AUTOMATION_PKG;

1711: x_country_code:= l_country_code;
1712:
1713: END GET_DEFAULT_COUNTRY_CODE;
1714:
1715: END ZX_DEFAULT_AUTOMATION_PKG;