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.JL_ZZ_TAX_VALIDATE_PKG dependencies on JL_ZZ_TAX_VALIDATE_PKG

Line 1: package BODY jl_zz_tax_validate_pkg as

1: package BODY jl_zz_tax_validate_pkg as
2: /* $Header: jlzzdefvalpkgb.pls 120.19.12010000.2 2008/08/04 12:51:43 vgadde ship $ */
3:
4: procedure validate_pfc_tbc (x_return_status OUT NOCOPY VARCHAR2);
5:

Line 79: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77: IF (g_level_procedure >= g_current_runtime_level ) THEN
78: FND_LOG.STRING(g_level_procedure,
79: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
80: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
81: END IF;
82:
83: OPEN c_delimiter;

Line 80: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');

76: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77: IF (g_level_procedure >= g_current_runtime_level ) THEN
78: FND_LOG.STRING(g_level_procedure,
79: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
80: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
81: END IF;
82:
83: OPEN c_delimiter;
84: FETCH c_delimiter INTO g_delimiter;

Line 95: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

91: validate_tax_attr (x_return_status);
92:
93: IF (g_level_procedure >= g_current_runtime_level ) THEN
94: FND_LOG.STRING(g_level_procedure,
95: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
96: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');
97: END IF;
98:
99: EXCEPTION

Line 96: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');

92:
93: IF (g_level_procedure >= g_current_runtime_level ) THEN
94: FND_LOG.STRING(g_level_procedure,
95: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
96: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');
97: END IF;
98:
99: EXCEPTION
100: WHEN OTHERS THEN

Line 103: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

99: EXCEPTION
100: WHEN OTHERS THEN
101: IF (g_level_unexpected >= g_current_runtime_level ) THEN
102: FND_LOG.STRING(g_level_unexpected,
103: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
104: sqlerrm);
105: END IF;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: app_exception.raise_exception;

Line 122: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',

118:
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: IF (g_level_procedure >= g_current_runtime_level ) THEN
121: FND_LOG.STRING(g_level_procedure,
122: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
123: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(+)');
124: END IF;
125:
126: INSERT ALL

Line 123: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(+)');

119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: IF (g_level_procedure >= g_current_runtime_level ) THEN
121: FND_LOG.STRING(g_level_procedure,
122: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
123: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(+)');
124: END IF;
125:
126: INSERT ALL
127: INTO ZX_VALIDATION_ERRORS_GT(

Line 213: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',

209:
210:
211: IF (g_level_procedure >= g_current_runtime_level ) THEN
212: FND_LOG.STRING(g_level_procedure,
213: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
214: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(-)');
215: END IF;
216:
217: EXCEPTION

Line 214: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(-)');

210:
211: IF (g_level_procedure >= g_current_runtime_level ) THEN
212: FND_LOG.STRING(g_level_procedure,
213: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
214: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(-)');
215: END IF;
216:
217: EXCEPTION
218: WHEN OTHERS THEN

Line 221: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',

217: EXCEPTION
218: WHEN OTHERS THEN
219: IF (g_level_unexpected >= g_current_runtime_level ) THEN
220: FND_LOG.STRING(g_level_unexpected,
221: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
222: sqlerrm);
223: END IF;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: app_exception.raise_exception;

Line 246: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
244: IF (g_level_procedure >= g_current_runtime_level ) THEN
245: FND_LOG.STRING(g_level_procedure,
246: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
247: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
248: END IF;
249:
250: -- Defaulting the taxation country

Line 247: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');

243: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
244: IF (g_level_procedure >= g_current_runtime_level ) THEN
245: FND_LOG.STRING(g_level_procedure,
246: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
247: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
248: END IF;
249:
250: -- Defaulting the taxation country
251: -- Bugfix 3971179

Line 279: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

275: --will always have trx_line_id information
276:
277: IF (g_level_statement >= g_current_runtime_level ) THEN
278: FND_LOG.STRING(g_level_statement,
279: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
280: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
281: Defaulting for Tax Regime Code and Tax');
282: END IF;
283:

Line 280: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:

276:
277: IF (g_level_statement >= g_current_runtime_level ) THEN
278: FND_LOG.STRING(g_level_statement,
279: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
280: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
281: Defaulting for Tax Regime Code and Tax');
282: END IF;
283:
284:

Line 319: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

315: -- In that case, the tax lines are imported as they are, without any validation.
316:
317: IF (g_level_statement >= g_current_runtime_level ) THEN
318: FND_LOG.STRING(g_level_statement,
319: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
320: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
321: Defaulting for Tax Status Code');
322: END IF;
323:

Line 320: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:

316:
317: IF (g_level_statement >= g_current_runtime_level ) THEN
318: FND_LOG.STRING(g_level_statement,
319: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
320: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
321: Defaulting for Tax Status Code');
322: END IF;
323:
324: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines

Line 376: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

372: /* Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate on imported tax lines*/
373:
374: IF (g_level_statement >= g_current_runtime_level ) THEN
375: FND_LOG.STRING(g_level_statement,
376: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
377: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
378: Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate');
379: END IF;
380:

Line 377: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:

373:
374: IF (g_level_statement >= g_current_runtime_level ) THEN
375: FND_LOG.STRING(g_level_statement,
376: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
377: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
378: Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate');
379: END IF;
380:
381: -- The assumption here is that for a given tax_regime_code, Tax, tax_status_code,

Line 464: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

460: -- Product Category from ar_memo_lines.
461:
462: IF (g_level_statement >= g_current_runtime_level ) THEN
463: FND_LOG.STRING(g_level_statement,
464: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
465: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
466: Defaulting for Transaction Business Category and Product Category,
467: Product Fiscal Classification');
468: END IF;

Line 465: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:

461:
462: IF (g_level_statement >= g_current_runtime_level ) THEN
463: FND_LOG.STRING(g_level_statement,
464: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
465: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
466: Defaulting for Transaction Business Category and Product Category,
467: Product Fiscal Classification');
468: END IF;
469:

Line 646: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

642: END IF;
643:
644: IF (g_level_procedure >= g_current_runtime_level ) THEN
645: FND_LOG.STRING(g_level_procedure,
646: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
647: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
648: END IF;
649:
650: EXCEPTION

Line 647: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');

643:
644: IF (g_level_procedure >= g_current_runtime_level ) THEN
645: FND_LOG.STRING(g_level_procedure,
646: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
647: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
648: END IF;
649:
650: EXCEPTION
651: WHEN OTHERS THEN

Line 654: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

650: EXCEPTION
651: WHEN OTHERS THEN
652: IF (g_level_unexpected >= g_current_runtime_level ) THEN
653: FND_LOG.STRING(g_level_unexpected,
654: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
655: sqlerrm);
656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: app_exception.raise_exception;

Line 682: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
680: IF (g_level_procedure >= g_current_runtime_level ) THEN
681: FND_LOG.STRING(g_level_procedure,
682: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
683: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
684: END IF;
685:
686: -- Defaulting the taxation country

Line 683: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');

679: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
680: IF (g_level_procedure >= g_current_runtime_level ) THEN
681: FND_LOG.STRING(g_level_procedure,
682: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
683: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
684: END IF;
685:
686: -- Defaulting the taxation country
687: /* -- Commented out the logic that raises error when default taxation country is not available.

Line 696: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

692: -- Check with TSRM that default_taxation_country is always populated;
693:
694: IF (g_level_unexpected >= g_current_runtime_level ) THEN
695: FND_LOG.STRING(g_level_unexpected,
696: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
697: 'Default taxation country is not available');
698: END IF;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: app_exception.raise_exception;

Line 716: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

712: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);
713:
714: IF (g_level_statement >= g_current_runtime_level ) THEN
715: FND_LOG.STRING(g_level_statement,
716: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
717: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
718: Defaulting for Transaction Business Category and Product Category,
719: Product Fiscal Classification');
720: END IF;

Line 717: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:

713:
714: IF (g_level_statement >= g_current_runtime_level ) THEN
715: FND_LOG.STRING(g_level_statement,
716: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
717: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
718: Defaulting for Transaction Business Category and Product Category,
719: Product Fiscal Classification');
720: END IF;
721:

Line 737: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

733: END IF;
734:
735: IF (g_level_statement >= g_current_runtime_level ) THEN
736: FND_LOG.STRING(g_level_statement,
737: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
738: 'Transaction Business Category is NULL. Defaulting Transaction Business Category'||
739: ' Tax Event Class Code = '||zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)||
740: ' Delimiter = '||g_delimiter);
741: END IF;

Line 757: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

753:
754:
755: IF (g_level_statement >= g_current_runtime_level ) THEN
756: FND_LOG.STRING(g_level_statement,
757: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
758: 'After defaulting: l_trx_business_category = '||l_trx_business_category);
759: END IF;
760:
761: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=

Line 772: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

768:
769:
770: IF (g_level_statement >= g_current_runtime_level ) THEN
771: FND_LOG.STRING(g_level_statement,
772: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
773: 'Country code: '||
774: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index));
775: END IF;
776:

Line 814: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

810: Exception
811: when no_data_found then
812: IF (g_level_exception >= g_current_runtime_level ) THEN
813: FND_LOG.STRING(g_level_exception,
814: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
815: 'Unable to default Product Fiscal Classification which is mandatory for LTE');
816: END IF;
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: -- app_exception.raise_exception;

Line 861: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

857: l_product_category);
858:
859: IF (g_level_statement >= g_current_runtime_level ) THEN
860: FND_LOG.STRING(g_level_statement,
861: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
862: ' l_trx_business_category = '||l_trx_business_category||
863: ' l_product_category = '||l_product_category);
864: END IF;
865:

Line 870: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

866: Exception
867: when no_data_found then
868: IF (g_level_exception >= g_current_runtime_level ) THEN
869: FND_LOG.STRING(g_level_exception,
870: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
871: 'Unable to default Product Fiscal Classification ot Trx Business Category'||
872: ' which is mandatory for LTE');
873: END IF;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 883: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

879:
880:
881: IF (g_level_procedure >= g_current_runtime_level ) THEN
882: FND_LOG.STRING(g_level_procedure,
883: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
884: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
885: END IF;
886:
887: EXCEPTION

Line 884: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');

880:
881: IF (g_level_procedure >= g_current_runtime_level ) THEN
882: FND_LOG.STRING(g_level_procedure,
883: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
884: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
885: END IF;
886:
887: EXCEPTION
888: WHEN OTHERS THEN

Line 891: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

887: EXCEPTION
888: WHEN OTHERS THEN
889: IF (g_level_unexpected >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_unexpected,
891: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
892: sqlerrm);
893: END IF;
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: app_exception.raise_exception;

Line 909: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',

905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
907: IF (g_level_procedure >= g_current_runtime_level ) THEN
908: FND_LOG.STRING(g_level_procedure,
909: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
910: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR(+)');
911: END IF;
912:
913: INSERT ALL

Line 910: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR(+)');

906: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
907: IF (g_level_procedure >= g_current_runtime_level ) THEN
908: FND_LOG.STRING(g_level_procedure,
909: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
910: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR(+)');
911: END IF;
912:
913: INSERT ALL
914: WHEN (REGIME_NOT_EXISTS = 'Y') THEN

Line 2256: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',

2252: EXCEPTION
2253: WHEN OTHERS THEN
2254: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2255: FND_LOG.STRING(g_level_unexpected,
2256: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
2257: sqlerrm);
2258: END IF;
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2260: app_exception.raise_exception;

Line 2308: END jl_zz_tax_validate_pkg;

2304: l_indended_use_na_for_lte :=fnd_message.get_string('ZX','ZX_INTENDED_USE_NA_FOR_LTE' );
2305: l_product_type_na_for_lte :=fnd_message.get_string('ZX','ZX_PRODUCT_TYPE_NA_FOR_LTE' );
2306: l_tax_jur_code_na_for_lte :=fnd_message.get_string('ZX','ZX_TAX_JUR_CODE_NA_FOR_LTE' );
2307:
2308: END jl_zz_tax_validate_pkg;