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.25.12020000.2 2012/12/20 07:21:26 ssohal ship $ */
3:
4: procedure validate_pfc_tbc (x_return_status OUT NOCOPY VARCHAR2);
5:

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

84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
86: IF (g_level_procedure >= g_current_runtime_level ) THEN
87: FND_LOG.STRING(g_level_procedure,
88: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
89: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
90: END IF;
91:
92: OPEN c_delimiter;

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

85: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
86: IF (g_level_procedure >= g_current_runtime_level ) THEN
87: FND_LOG.STRING(g_level_procedure,
88: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
89: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
90: END IF;
91:
92: OPEN c_delimiter;
93: FETCH c_delimiter INTO g_delimiter;

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

102: EXCEPTION
103: WHEN NO_DATA_FOUND THEN
104: IF (g_level_exception >= g_current_runtime_level ) THEN
105: FND_LOG.STRING(g_level_exception,
106: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
107: 'First Party Org Id : Not able to fetch OU and LE');
108: END IF;
109: app_exception.raise_exception;
110: END;

Line 113: FND_LOG.STRING(g_level_statement,'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

109: app_exception.raise_exception;
110: END;
111:
112: IF ( g_level_statement >= g_current_runtime_level) THEN
113: FND_LOG.STRING(g_level_statement,'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
114: 'Call ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER() with OU: '||TO_CHAR(l_ou_id)||' and LE: '||TO_CHAR(l_le_id));
115: END IF;
116:
117: ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER(l_le_id,

Line 123: FND_LOG.STRING(g_level_statement,'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

119: g_first_pty_org_id,
120: l_return_status);
121:
122: IF ( g_level_statement >= g_current_runtime_level) THEN
123: FND_LOG.STRING(g_level_statement,'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
124: 'G_FIRST_PTY_ORG_ID: '||TO_CHAR(g_first_pty_org_id));
125: END IF;
126:
127: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

126:
127: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
128: IF (g_level_exception >= g_current_runtime_level ) THEN
129: FND_LOG.STRING(g_level_exception,
130: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
131: 'Get Tax Subscriber : Returned Error Status');
132: END IF;
133: END IF;
134: -- End : Code added to get the First-Party-Org-Id -- Bug#7530930

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

165:
166: IF l_err_count > 0 THEN
167: IF (g_level_procedure >= g_current_runtime_level ) THEN
168: FND_LOG.STRING(g_level_procedure,
169: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
170: 'Error Message Count : '||l_err_count);
171: END IF;
172: FOR rec IN (SELECT trx_id, message_text FROM ZX_VALIDATION_ERRORS_GT) LOOP
173: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

171: END IF;
172: FOR rec IN (SELECT trx_id, message_text FROM ZX_VALIDATION_ERRORS_GT) LOOP
173: IF (g_level_procedure >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_procedure,
175: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Trx_ID : '||rec.trx_id||', Error : '||rec.message_text);
177: END IF;
178: END LOOP;
179: END IF;

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

179: END IF;
180:
181: IF (g_level_procedure >= g_current_runtime_level ) THEN
182: FND_LOG.STRING(g_level_procedure,
183: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
184: 'RETURN_STATUS : '||x_return_status);
185: FND_LOG.STRING(g_level_procedure,
186: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
187: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');

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

182: FND_LOG.STRING(g_level_procedure,
183: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
184: 'RETURN_STATUS : '||x_return_status);
185: FND_LOG.STRING(g_level_procedure,
186: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
187: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');
188: END IF;
189:
190: EXCEPTION

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

183: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
184: 'RETURN_STATUS : '||x_return_status);
185: FND_LOG.STRING(g_level_procedure,
186: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
187: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');
188: END IF;
189:
190: EXCEPTION
191: WHEN OTHERS THEN

Line 194: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

190: EXCEPTION
191: WHEN OTHERS THEN
192: IF (g_level_unexpected >= g_current_runtime_level ) THEN
193: FND_LOG.STRING(g_level_unexpected,
194: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
195: sqlerrm);
196: END IF;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: app_exception.raise_exception;

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

217:
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: IF (g_level_procedure >= g_current_runtime_level ) THEN
220: FND_LOG.STRING(g_level_procedure,
221: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
222: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(+)');
223: END IF;
224:
225: OPEN c_delimiter_prod_cat;

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

218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: IF (g_level_procedure >= g_current_runtime_level ) THEN
220: FND_LOG.STRING(g_level_procedure,
221: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
222: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(+)');
223: END IF;
224:
225: OPEN c_delimiter_prod_cat;
226: FETCH c_delimiter_prod_cat INTO l_delimiter_prod_cat;

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

270: and tc.org_id = asp.org_id);
271:
272: IF (g_level_procedure >= g_current_runtime_level ) THEN
273: FND_LOG.STRING(g_level_procedure,
274: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
275: 'Transaction Business Category Validation Errors: '|| To_Char(SQL%ROWCOUNT) );
276: END IF;
277:
278: INSERT ALL

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

325: );
326:
327: IF (g_level_procedure >= g_current_runtime_level ) THEN
328: FND_LOG.STRING(g_level_procedure,
329: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
330: 'Product Fiscal Classification Validation Errors: '|| To_Char(SQL%ROWCOUNT) );
331: END IF;
332:
333: INSERT ALL

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

381: );
382:
383: IF (g_level_procedure >= g_current_runtime_level ) THEN
384: FND_LOG.STRING(g_level_procedure,
385: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
386: 'Product Category Validation Errors: '|| To_Char(SQL%ROWCOUNT) );
387: END IF;
388:
389: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

387: END IF;
388:
389: IF (g_level_procedure >= g_current_runtime_level ) THEN
390: FND_LOG.STRING(g_level_procedure,
391: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
392: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(-)');
393: END IF;
394:
395: EXCEPTION

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

388:
389: IF (g_level_procedure >= g_current_runtime_level ) THEN
390: FND_LOG.STRING(g_level_procedure,
391: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
392: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC(-)');
393: END IF;
394:
395: EXCEPTION
396: WHEN OTHERS THEN

Line 399: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',

395: EXCEPTION
396: WHEN OTHERS THEN
397: IF (g_level_unexpected >= g_current_runtime_level ) THEN
398: FND_LOG.STRING(g_level_unexpected,
399: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_PFC_TBC',
400: sqlerrm);
401: END IF;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: app_exception.raise_exception;

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

416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
418: IF (g_level_procedure >= g_current_runtime_level ) THEN
419: FND_LOG.STRING(g_level_procedure,
420: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
421: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
422: END IF;
423:
424: -- Defaulting the taxation country

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

417: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
418: IF (g_level_procedure >= g_current_runtime_level ) THEN
419: FND_LOG.STRING(g_level_procedure,
420: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
421: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
422: END IF;
423:
424: -- Defaulting the taxation country
425: -- Bugfix 3971179

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

445: --will always have trx_line_id information
446:
447: IF (g_level_statement >= g_current_runtime_level ) THEN
448: FND_LOG.STRING(g_level_statement,
449: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
450: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Regime Code and Tax');
451: END IF;
452:
453: -- Defaulting the Tax_regime_code and Tax if tax_rate_code is passed

Line 450: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Regime Code and Tax');

446:
447: IF (g_level_statement >= g_current_runtime_level ) THEN
448: FND_LOG.STRING(g_level_statement,
449: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
450: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Regime Code and Tax');
451: END IF;
452:
453: -- Defaulting the Tax_regime_code and Tax if tax_rate_code is passed
454: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

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

480: INSERT(tax) VALUES(NULL);
481:
482: IF (g_level_statement >= g_current_runtime_level ) THEN
483: FND_LOG.STRING(g_level_statement,
484: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
485: 'DML performed on rows(1):'||SQL%ROWCOUNT);
486: END IF;
487:
488: -- Defaulting the Tax_regime_code and Tax if tax_rate_id is passed

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

516: INSERT(tax) VALUES(NULL);
517:
518: IF (g_level_statement >= g_current_runtime_level ) THEN
519: FND_LOG.STRING(g_level_statement,
520: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
521: 'DML performed on rows(2):'||SQL%ROWCOUNT);
522: END IF;
523:
524: --Defaulting for Tax Status Code on imported tax lines

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

523:
524: --Defaulting for Tax Status Code on imported tax lines
525: IF (g_level_statement >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_statement,
527: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
528: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Status Code');
529: END IF;
530:
531: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

Line 528: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Status Code');

524: --Defaulting for Tax Status Code on imported tax lines
525: IF (g_level_statement >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_statement,
527: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
528: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Status Code');
529: END IF;
530:
531: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt
532: USING (SELECT Rates.tax_status_code tax_status_code,

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

557: INSERT(tax) VALUES(NULL);
558:
559: IF (g_level_statement >= g_current_runtime_level ) THEN
560: FND_LOG.STRING(g_level_statement,
561: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
562: 'DML performed on rows:'||SQL%ROWCOUNT);
563: END IF;
564:
565: -- Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate on imported tax lines

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

564:
565: -- Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate on imported tax lines
566: IF (g_level_statement >= g_current_runtime_level ) THEN
567: FND_LOG.STRING(g_level_statement,
568: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
569: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate');
570: END IF;
571:
572: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt

Line 569: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate');

565: -- Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate on imported tax lines
566: IF (g_level_statement >= g_current_runtime_level ) THEN
567: FND_LOG.STRING(g_level_statement,
568: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
569: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR: Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate');
570: END IF;
571:
572: MERGE INTO ZX_IMPORT_TAX_LINES_GT TaxLines_gt
573: USING (SELECT Rates.tax_code,

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

604: INSERT(tax) VALUES(NULL);
605:
606: IF (g_level_statement >= g_current_runtime_level ) THEN
607: FND_LOG.STRING(g_level_statement,
608: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
609: 'DML performed on rows:'||SQL%ROWCOUNT);
610: END IF;
611:
612: -- Default tax amount if it is NULL and tax rate is specified

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

659: -- Product Category from ar_memo_lines.
660:
661: IF (g_level_statement >= g_current_runtime_level ) THEN
662: FND_LOG.STRING(g_level_statement,
663: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
664: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
665: Defaulting for Transaction Business Category and Product Category,
666: Product Fiscal Classification');
667: END IF;

Line 664: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:

660:
661: IF (g_level_statement >= g_current_runtime_level ) THEN
662: FND_LOG.STRING(g_level_statement,
663: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
664: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
665: Defaulting for Transaction Business Category and Product Category,
666: Product Fiscal Classification');
667: END IF;
668:

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

837: END IF;
838:
839: IF (g_level_procedure >= g_current_runtime_level ) THEN
840: FND_LOG.STRING(g_level_procedure,
841: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
842: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
843: END IF;
844:
845: EXCEPTION

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

838:
839: IF (g_level_procedure >= g_current_runtime_level ) THEN
840: FND_LOG.STRING(g_level_procedure,
841: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
842: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
843: END IF;
844:
845: EXCEPTION
846: WHEN OTHERS THEN

Line 849: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

845: EXCEPTION
846: WHEN OTHERS THEN
847: IF (g_level_unexpected >= g_current_runtime_level ) THEN
848: FND_LOG.STRING(g_level_unexpected,
849: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
850: sqlerrm);
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: app_exception.raise_exception;

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

873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
875: IF (g_level_procedure >= g_current_runtime_level ) THEN
876: FND_LOG.STRING(g_level_procedure,
877: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
878: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
879: END IF;
880:
881: -- Defaulting the taxation country

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

874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
875: IF (g_level_procedure >= g_current_runtime_level ) THEN
876: FND_LOG.STRING(g_level_procedure,
877: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
878: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(+)');
879: END IF;
880:
881: -- Defaulting the taxation country
882: /* -- Commented out the logic that raises error when default taxation country is not available.

Line 891: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

887: -- Check with TSRM that default_taxation_country is always populated;
888:
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: 'Default taxation country is not available');
893: END IF;
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: app_exception.raise_exception;

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

907: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);
908:
909: IF (g_level_statement >= g_current_runtime_level ) THEN
910: FND_LOG.STRING(g_level_statement,
911: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
912: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
913: Defaulting for Transaction Business Category and Product Category,
914: Product Fiscal Classification');
915: END IF;

Line 912: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:

908:
909: IF (g_level_statement >= g_current_runtime_level ) THEN
910: FND_LOG.STRING(g_level_statement,
911: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
912: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR:
913: Defaulting for Transaction Business Category and Product Category,
914: Product Fiscal Classification');
915: END IF;
916:

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

928: END IF;
929:
930: IF (g_level_statement >= g_current_runtime_level ) THEN
931: FND_LOG.STRING(g_level_statement,
932: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
933: 'Transaction Business Category is NULL. Defaulting Transaction Business Category'||
934: ' Tax Event Class Code = '||zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)||
935: ' Delimiter = '||g_delimiter);
936: END IF;

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

949:
950:
951: IF (g_level_statement >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_statement,
953: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
954: 'After defaulting: l_trx_business_category = '||l_trx_business_category);
955: END IF;
956:
957: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=

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

964:
965:
966: IF (g_level_statement >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_statement,
968: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
969: 'Country code: '||
970: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index));
971: END IF;
972:

Line 1010: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

1006: Exception
1007: when no_data_found then
1008: IF (g_level_exception >= g_current_runtime_level ) THEN
1009: FND_LOG.STRING(g_level_exception,
1010: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1011: 'Unable to default Product Fiscal Classification which is mandatory for LTE');
1012: END IF;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: -- app_exception.raise_exception;

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

1054: l_product_category);
1055:
1056: IF (g_level_statement >= g_current_runtime_level ) THEN
1057: FND_LOG.STRING(g_level_statement,
1058: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1059: ' l_trx_business_category = '||l_trx_business_category||
1060: ' l_product_category = '||l_product_category);
1061: END IF;
1062:

Line 1067: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

1063: Exception
1064: when no_data_found then
1065: IF (g_level_exception >= g_current_runtime_level ) THEN
1066: FND_LOG.STRING(g_level_exception,
1067: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1068: 'Unable to default Product Fiscal Classification ot Trx Business Category'||
1069: ' which is mandatory for LTE');
1070: END IF;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1076:
1077:
1078: IF (g_level_procedure >= g_current_runtime_level ) THEN
1079: FND_LOG.STRING(g_level_procedure,
1080: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1081: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
1082: END IF;
1083:
1084: EXCEPTION

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

1077:
1078: IF (g_level_procedure >= g_current_runtime_level ) THEN
1079: FND_LOG.STRING(g_level_procedure,
1080: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1081: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(-)');
1082: END IF;
1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN

Line 1088: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1087: FND_LOG.STRING(g_level_unexpected,
1088: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1089: sqlerrm);
1090: END IF;
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: app_exception.raise_exception;

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

1102: x_return_status := FND_API.G_RET_STS_SUCCESS;
1103: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1104: IF (g_level_procedure >= g_current_runtime_level ) THEN
1105: FND_LOG.STRING(g_level_procedure,
1106: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
1107: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR(+)');
1108: END IF;
1109:
1110: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

1103: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1104: IF (g_level_procedure >= g_current_runtime_level ) THEN
1105: FND_LOG.STRING(g_level_procedure,
1106: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
1107: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR(+)');
1108: END IF;
1109:
1110: IF (g_level_procedure >= g_current_runtime_level ) THEN
1111: FND_LOG.STRING(g_level_procedure,

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

1108: END IF;
1109:
1110: IF (g_level_procedure >= g_current_runtime_level ) THEN
1111: FND_LOG.STRING(g_level_procedure,
1112: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
1113: 'Running Line Level Validations...');
1114: END IF;
1115:
1116: INSERT ALL

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

1796: and header.event_class_code = evntmap.event_class_code(+);
1797:
1798: IF (g_level_procedure >= g_current_runtime_level ) THEN
1799: FND_LOG.STRING(g_level_procedure,
1800: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
1801: 'Line Level Validation Errors : '|| To_Char(SQL%ROWCOUNT) );
1802: END IF;
1803:
1804: -- Run Tax Line Level Validation for manual tax lines (if any)

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

1805: IF nvl(g_tax_lines_count,0) > 0 THEN
1806:
1807: IF (g_level_procedure >= g_current_runtime_level ) THEN
1808: FND_LOG.STRING(g_level_procedure,
1809: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
1810: 'Running Manual Tax Line Level Validations...');
1811: END IF;
1812:
1813: INSERT ALL

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

2245: );
2246:
2247: IF (g_level_procedure >= g_current_runtime_level ) THEN
2248: FND_LOG.STRING(g_level_procedure,
2249: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
2250: 'Regime, Tax and Status Validation Errors : '|| To_Char(SQL%ROWCOUNT) );
2251: END IF;
2252:
2253: INSERT ALL

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

2492: );
2493:
2494: IF (g_level_procedure >= g_current_runtime_level ) THEN
2495: FND_LOG.STRING(g_level_procedure,
2496: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
2497: 'Tax Rate Validation Errors : '|| To_Char(SQL%ROWCOUNT) );
2498: END IF;
2499:
2500: INSERT ALL

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

2689: );
2690:
2691: IF (g_level_procedure >= g_current_runtime_level ) THEN
2692: FND_LOG.STRING(g_level_procedure,
2693: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
2694: 'Tax Allocation Validation Errors : '|| To_Char(SQL%ROWCOUNT) );
2695: END IF;
2696:
2697: END IF; -- IF g_tax_lines_count > 0

Line 2704: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',

2700: EXCEPTION
2701: WHEN OTHERS THEN
2702: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2703: FND_LOG.STRING(g_level_unexpected,
2704: 'JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
2705: sqlerrm);
2706: END IF;
2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2708: app_exception.raise_exception;

Line 2758: END jl_zz_tax_validate_pkg;

2754: l_indended_use_na_for_lte :=fnd_message.get_string('ZX','ZX_INTENDED_USE_NA_FOR_LTE' );
2755: l_product_type_na_for_lte :=fnd_message.get_string('ZX','ZX_PRODUCT_TYPE_NA_FOR_LTE' );
2756: l_tax_jur_code_na_for_lte :=fnd_message.get_string('ZX','ZX_TAX_JUR_CODE_NA_FOR_LTE' );
2757:
2758: END jl_zz_tax_validate_pkg;