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 FND_LOG

Line 76: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

72: So the same logic is not coded here
73: */
74:
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(+)');

Line 78: FND_LOG.STRING(g_level_procedure,

74:
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:

Line 94: FND_LOG.STRING(g_level_procedure,

90:
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:

Line 102: FND_LOG.STRING(g_level_unexpected,

98:
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;

Line 121: FND_LOG.STRING(g_level_procedure,

117: BEGIN
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:

Line 212: FND_LOG.STRING(g_level_procedure,

208: );
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:

Line 220: FND_LOG.STRING(g_level_unexpected,

216:
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;

Line 243: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

239:
240: BEGIN
241:
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(+)');

Line 245: FND_LOG.STRING(g_level_procedure,

241:
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:

Line 278: FND_LOG.STRING(g_level_statement,

274: --In case of LTE/O2C, the tax lines imoprted are detail tax lines and
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;

Line 318: FND_LOG.STRING(g_level_statement,

314: -- does not prevent user from importing tax lines when LTE is being used.
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;

Line 375: FND_LOG.STRING(g_level_statement,

371:
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;

Line 463: FND_LOG.STRING(g_level_statement,

459: -- If the line is a memo line, then populate Transaction Business Category and
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');

Line 645: FND_LOG.STRING(g_level_procedure,

641:
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:

Line 653: FND_LOG.STRING(g_level_unexpected,

649:
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;

Line 679: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

675:
676: BEGIN
677:
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(+)');

Line 681: FND_LOG.STRING(g_level_procedure,

677:
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:

Line 695: FND_LOG.STRING(g_level_unexpected,

691: IF zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index) is NULL then
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;

Line 715: FND_LOG.STRING(g_level_statement,

711:
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');

Line 736: FND_LOG.STRING(g_level_statement,

732: CLOSE c_delimiter;
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);

Line 756: FND_LOG.STRING(g_level_statement,

752: AND inventory_item_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
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:

Line 771: FND_LOG.STRING(g_level_statement,

767: If zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) is NULL then
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;

Line 813: FND_LOG.STRING(g_level_exception,

809: End If;
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;

Line 860: FND_LOG.STRING(g_level_statement,

856: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index),
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;

Line 869: FND_LOG.STRING(g_level_exception,

865:
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;

Line 882: FND_LOG.STRING(g_level_procedure,

878: END IF;
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:

Line 890: FND_LOG.STRING(g_level_unexpected,

886:
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;

Line 906: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

902:
903: BEGIN
904:
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(+)');

Line 908: FND_LOG.STRING(g_level_procedure,

904:
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:

Line 2255: FND_LOG.STRING(g_level_unexpected,

2251:
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;

Line 2267: g_level_statement := FND_LOG.LEVEL_STATEMENT;

2263:
2264: --Constructor
2265: BEGIN
2266:
2267: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2268: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2269: g_level_event := FND_LOG.LEVEL_EVENT;
2270: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2271: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

Line 2268: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;

2264: --Constructor
2265: BEGIN
2266:
2267: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2268: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2269: g_level_event := FND_LOG.LEVEL_EVENT;
2270: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2271: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2272: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );

Line 2269: g_level_event := FND_LOG.LEVEL_EVENT;

2265: BEGIN
2266:
2267: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2268: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2269: g_level_event := FND_LOG.LEVEL_EVENT;
2270: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2271: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2272: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );
2273: l_regime_not_effective :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFFECTIVE' );

Line 2270: g_level_exception := FND_LOG.LEVEL_EXCEPTION;

2266:
2267: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2268: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2269: g_level_event := FND_LOG.LEVEL_EVENT;
2270: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2271: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2272: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );
2273: l_regime_not_effective :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFFECTIVE' );
2274: l_tax_not_exists :=fnd_message.get_string('ZX','ZX_TAX_NOT_EXIST' );

Line 2271: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

2267: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2268: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2269: g_level_event := FND_LOG.LEVEL_EVENT;
2270: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2271: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2272: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );
2273: l_regime_not_effective :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFFECTIVE' );
2274: l_tax_not_exists :=fnd_message.get_string('ZX','ZX_TAX_NOT_EXIST' );
2275: l_tax_not_live :=fnd_message.get_string('ZX','ZX_TAX_NOT_LIVE' );