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.

[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on FND_LOG

Line 85: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

81: /* It is assumed that TSRM will set the security context before calling this API
82: So the same logic is not coded here
83: */
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(+)');

Line 87: FND_LOG.STRING(g_level_procedure,

83: */
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:

Line 105: FND_LOG.STRING(g_level_exception,

101: WHERE rownum = 1;
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;

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 129: FND_LOG.STRING(g_level_exception,

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

Line 154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

150: SET validation_check_flag = 'N'
151: WHERE trx_id IN (SELECT DISTINCT trx_id FROM zx_validation_errors_gt);
152:
153: IF ( SQL%ROWCOUNT > 0 ) THEN
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155: IF (g_level_statement >= g_current_runtime_level) THEN
156: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
157: 'Updated the validation_check_flag to N in Zx_Trx_Headers_GT for '||to_char(SQL%ROWCOUNT)||' trx(s).');
158: END IF;

Line 156: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

152:
153: IF ( SQL%ROWCOUNT > 0 ) THEN
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155: IF (g_level_statement >= g_current_runtime_level) THEN
156: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
157: 'Updated the validation_check_flag to N in Zx_Trx_Headers_GT for '||to_char(SQL%ROWCOUNT)||' trx(s).');
158: END IF;
159: END IF ;
160:

Line 168: FND_LOG.STRING(g_level_procedure,

164: FROM zx_validation_errors_gt;
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

Line 174: FND_LOG.STRING(g_level_procedure,

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

Line 182: FND_LOG.STRING(g_level_procedure,

178: END LOOP;
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',

Line 185: FND_LOG.STRING(g_level_procedure,

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(-)');
188: END IF;
189:

Line 193: FND_LOG.STRING(g_level_unexpected,

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

Line 220: FND_LOG.STRING(g_level_procedure,

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

Line 273: FND_LOG.STRING(g_level_procedure,

269: and tac.org_id = asp.org_id
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:

Line 328: FND_LOG.STRING(g_level_procedure,

324: and NVL(lk.END_DATE_ACTIVE,header.trx_date) >= header.trx_date
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:

Line 384: FND_LOG.STRING(g_level_procedure,

380: and NVL(lk.end_date_active,header.trx_date) >= header.trx_date
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:

Line 390: FND_LOG.STRING(g_level_procedure,

386: 'Product Category Validation Errors: '|| To_Char(SQL%ROWCOUNT) );
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:

Line 398: FND_LOG.STRING(g_level_unexpected,

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

Line 417: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

413:
414: BEGIN
415:
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(+)');

Line 419: FND_LOG.STRING(g_level_procedure,

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

Line 448: FND_LOG.STRING(g_level_statement,

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

Line 483: FND_LOG.STRING(g_level_statement,

479: WHEN NOT MATCHED THEN
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:

Line 519: FND_LOG.STRING(g_level_statement,

515: WHEN NOT MATCHED THEN
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:

Line 526: FND_LOG.STRING(g_level_statement,

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

Line 560: FND_LOG.STRING(g_level_statement,

556: WHEN NOT MATCHED THEN
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:

Line 567: FND_LOG.STRING(g_level_statement,

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

Line 607: FND_LOG.STRING(g_level_statement,

603: WHEN NOT MATCHED THEN
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:

Line 662: FND_LOG.STRING(g_level_statement,

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

Line 840: FND_LOG.STRING(g_level_procedure,

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

Line 848: FND_LOG.STRING(g_level_unexpected,

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

Line 874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

870:
871: BEGIN
872:
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(+)');

Line 876: FND_LOG.STRING(g_level_procedure,

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

Line 890: FND_LOG.STRING(g_level_unexpected,

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

Line 910: FND_LOG.STRING(g_level_statement,

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

Line 931: FND_LOG.STRING(g_level_statement,

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

Line 952: FND_LOG.STRING(g_level_statement,

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

Line 967: FND_LOG.STRING(g_level_statement,

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

Line 1009: FND_LOG.STRING(g_level_exception,

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

Line 1057: FND_LOG.STRING(g_level_statement,

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

Line 1066: FND_LOG.STRING(g_level_exception,

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

Line 1079: FND_LOG.STRING(g_level_procedure,

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

Line 1087: FND_LOG.STRING(g_level_unexpected,

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

Line 1103: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1099:
1100: BEGIN
1101:
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(+)');

Line 1105: FND_LOG.STRING(g_level_procedure,

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

Line 1111: FND_LOG.STRING(g_level_procedure,

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,
1112: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.VALIDATE_TAX_ATTR',
1113: 'Running Line Level Validations...');
1114: END IF;
1115:

Line 1799: FND_LOG.STRING(g_level_procedure,

1795: and header.entity_code = evntmap.entity_code (+)
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:

Line 1808: FND_LOG.STRING(g_level_procedure,

1804: -- Run Tax Line Level Validation for manual tax lines (if any)
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:

Line 2248: FND_LOG.STRING(g_level_procedure,

2244: )
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:

Line 2495: FND_LOG.STRING(g_level_procedure,

2491: )
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:

Line 2692: FND_LOG.STRING(g_level_procedure,

2688: )
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:

Line 2703: FND_LOG.STRING(g_level_unexpected,

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

Line 2715: g_level_statement := FND_LOG.LEVEL_STATEMENT;

2711:
2712: --Constructor
2713: BEGIN
2714:
2715: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2716: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2717: g_level_event := FND_LOG.LEVEL_EVENT;
2718: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2719: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

Line 2716: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;

2712: --Constructor
2713: BEGIN
2714:
2715: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2716: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2717: g_level_event := FND_LOG.LEVEL_EVENT;
2718: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2719: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2720: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );

Line 2717: g_level_event := FND_LOG.LEVEL_EVENT;

2713: BEGIN
2714:
2715: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2716: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2717: g_level_event := FND_LOG.LEVEL_EVENT;
2718: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2719: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2720: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );
2721: l_regime_not_effective :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFFECTIVE' );

Line 2718: g_level_exception := FND_LOG.LEVEL_EXCEPTION;

2714:
2715: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2716: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2717: g_level_event := FND_LOG.LEVEL_EVENT;
2718: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2719: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2720: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );
2721: l_regime_not_effective :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFFECTIVE' );
2722: l_regime_not_eff_in_subscr :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFF_IN_SUBSCR' );

Line 2719: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

2715: g_level_statement := FND_LOG.LEVEL_STATEMENT;
2716: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
2717: g_level_event := FND_LOG.LEVEL_EVENT;
2718: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
2719: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
2720: l_regime_not_exists :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EXIST' );
2721: l_regime_not_effective :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFFECTIVE' );
2722: l_regime_not_eff_in_subscr :=fnd_message.get_string('ZX','ZX_REGIME_NOT_EFF_IN_SUBSCR' );
2723: l_tax_not_exists :=fnd_message.get_string('ZX','ZX_TAX_NOT_EXIST' );