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_VALIDATE_API_PKG dependencies on FND_LOG

Line 5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY Zx_Validate_Api_Pkg AS
2: /* $Header: zxapdefvalpkgb.pls 120.80.12010000.4 2009/02/05 14:44:37 tsen ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: zxapdefvalpkgb.pls 120.80.12010000.4 2009/02/05 14:44:37 tsen ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_first_pty_org_id NUMBER;

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_first_pty_org_id NUMBER;
11: l_le_id NUMBER;

Line 8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_first_pty_org_id NUMBER;
11: l_le_id NUMBER;
12: l_ou_id NUMBER;

Line 9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_first_pty_org_id NUMBER;
11: l_le_id NUMBER;
12: l_ou_id NUMBER;
13: l_regime_not_exists VARCHAR2(2000);

Line 154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

150:
151: BEGIN
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155:
156: IF (g_level_procedure >= g_current_runtime_level ) THEN
157: FND_LOG.STRING(g_level_procedure,
158: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 157: FND_LOG.STRING(g_level_procedure,

153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155:
156: IF (g_level_procedure >= g_current_runtime_level ) THEN
157: FND_LOG.STRING(g_level_procedure,
158: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
159: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
160: END IF;
161:

Line 171: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

167:
168: SELECT count(1) INTO l_count_link_gt FROM ZX_TRX_TAX_LINK_GT;
169:
170: IF ( g_level_statement >= g_current_runtime_level) THEN
171: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
172: 'Count of ZX_TRX_HEADERS_GT '||to_char(l_count_header));
173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
174: 'Count of ZX_TRANSACTION_LINES_GT '||to_char(l_count_lines));
175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

169:
170: IF ( g_level_statement >= g_current_runtime_level) THEN
171: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
172: 'Count of ZX_TRX_HEADERS_GT '||to_char(l_count_header));
173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
174: 'Count of ZX_TRANSACTION_LINES_GT '||to_char(l_count_lines));
175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Count of ZX_IMPORT_TAX_LINES_GT '||to_char(l_count_tax_lines));
177: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

171: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
172: 'Count of ZX_TRX_HEADERS_GT '||to_char(l_count_header));
173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
174: 'Count of ZX_TRANSACTION_LINES_GT '||to_char(l_count_lines));
175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Count of ZX_IMPORT_TAX_LINES_GT '||to_char(l_count_tax_lines));
177: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
178: 'Count of ZX_TRX_TAX_LINK_GT '||to_char(l_count_link_gt));
179: END IF;

Line 177: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
174: 'Count of ZX_TRANSACTION_LINES_GT '||to_char(l_count_lines));
175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Count of ZX_IMPORT_TAX_LINES_GT '||to_char(l_count_tax_lines));
177: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
178: 'Count of ZX_TRX_TAX_LINK_GT '||to_char(l_count_link_gt));
179: END IF;
180:
181: ---------------------------------------------------------------------------------

Line 202: FND_LOG.STRING(g_level_exception,

198: EXCEPTION
199:
200: WHEN NO_DATA_FOUND THEN
201: IF (g_level_exception >= g_current_runtime_level ) THEN
202: FND_LOG.STRING(g_level_exception,
203: 'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR:
204: First Party Org Id : Not able to fetch
205: OU and LE',
206: sqlerrm);

Line 215: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

211: END;
212:
213: IF ( g_level_statement >= g_current_runtime_level) THEN
214:
215: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
216: 'Call ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER() with OU: '||to_char(l_ou_id)||' and LE: '||to_char(l_le_id));
217: END IF;
218:
219: ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER(l_le_id,

Line 225: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

221: g_first_pty_org_id,
222: l_return_status);
223:
224: IF ( g_level_statement >= g_current_runtime_level) THEN
225: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
226: 'G_FIRST_PTY_ORG_ID: '||to_char(g_first_pty_org_id));
227: END IF;
228:
229: -- Need to verify if we need to raise a UNEXPECTED error if we fail to set first party

Line 235: FND_LOG.STRING(g_level_exception,

231: -- all transactions and do not proceed further => Changes yet to be implemented
232:
233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: IF (g_level_exception >= g_current_runtime_level ) THEN
235: FND_LOG.STRING(g_level_exception,
236: 'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR:
237: Get Tax Subscriber : Returned Error Status',
238: sqlerrm);
239: END IF;

Line 248: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

244: -- End logic for getting the first party org id
245: ------------------------------------------------------------------------------------
246:
247: IF ( g_level_event >= g_current_runtime_level) THEN
248: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
249: 'Validating Other Documents');
250: END IF;
251:
252: Validate_Other_Documents(x_return_status);

Line 255: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

251:
252: Validate_Other_Documents(x_return_status);
253:
254: IF ( g_level_event >= g_current_runtime_level) THEN
255: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
256: 'Executing On the Fly Migration If Needed');
257: END IF;
258:
259: zx_on_fly_trx_upgrade_pkg.upgrade_trx_on_fly_blk(x_return_status);

Line 272: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

268: rownum =1);
269:
270: --Bug # 4917256
271: IF ( g_level_event >= g_current_runtime_level) THEN
272: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
273: 'Before defaulting, validate either tax_rate_id or tax_rate_code is passed in the import tax lines GT table');
274: END IF;
275:
276: INSERT INTO

Line 308: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

304: WHERE
305: tax_rate_code IS NULL AND tax_rate_id IS NULL;
306:
307: IF ( g_level_event >= g_current_runtime_level) THEN
308: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
309: 'Defaulting Additional Tax Det Attrs and Tax Line Attrs');
310: END IF;
311:
312: Default_Tax_Attr(x_return_status);

Line 315: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

311:
312: Default_Tax_Attr(x_return_status);
313:
314: IF ( g_level_event >= g_current_runtime_level) THEN
315: FND_LOG.STRING(g_level_event,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
316: 'Validating Transaction and Imported tax line info');
317: END IF;
318:
319: Validate_Tax_Attr(x_return_status);

Line 341: FND_LOG.STRING(g_level_statement,

337: l_error_rec.interface_line_entity_code,
338: l_error_rec.interface_line_id;
339: EXIT WHEN check_eror%NOTFOUND ; -- Added exit conditon .
340:
341: FND_LOG.STRING(g_level_statement,
342: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
343: 'error application_id is '||l_error_rec.application_id);
344: FND_LOG.STRING(g_level_statement,
345: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 344: FND_LOG.STRING(g_level_statement,

340:
341: FND_LOG.STRING(g_level_statement,
342: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
343: 'error application_id is '||l_error_rec.application_id);
344: FND_LOG.STRING(g_level_statement,
345: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
346: 'error entity_code is '||l_error_rec.entity_code);
347: FND_LOG.STRING(g_level_statement,
348: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 347: FND_LOG.STRING(g_level_statement,

343: 'error application_id is '||l_error_rec.application_id);
344: FND_LOG.STRING(g_level_statement,
345: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
346: 'error entity_code is '||l_error_rec.entity_code);
347: FND_LOG.STRING(g_level_statement,
348: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
349: 'error event_class_code is '||l_error_rec.event_class_code);
350: FND_LOG.STRING(g_level_statement,
351: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 350: FND_LOG.STRING(g_level_statement,

346: 'error entity_code is '||l_error_rec.entity_code);
347: FND_LOG.STRING(g_level_statement,
348: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
349: 'error event_class_code is '||l_error_rec.event_class_code);
350: FND_LOG.STRING(g_level_statement,
351: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
352: 'error trx_id is '||l_error_rec.trx_id);
353: FND_LOG.STRING(g_level_statement,
354: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 353: FND_LOG.STRING(g_level_statement,

349: 'error event_class_code is '||l_error_rec.event_class_code);
350: FND_LOG.STRING(g_level_statement,
351: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
352: 'error trx_id is '||l_error_rec.trx_id);
353: FND_LOG.STRING(g_level_statement,
354: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
355: 'error trx_line_id is '||l_error_rec.trx_line_id);
356: FND_LOG.STRING(g_level_statement,
357: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 356: FND_LOG.STRING(g_level_statement,

352: 'error trx_id is '||l_error_rec.trx_id);
353: FND_LOG.STRING(g_level_statement,
354: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
355: 'error trx_line_id is '||l_error_rec.trx_line_id);
356: FND_LOG.STRING(g_level_statement,
357: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
358: 'error message_name is '||l_error_rec.message_name);
359: FND_LOG.STRING(g_level_statement,
360: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 359: FND_LOG.STRING(g_level_statement,

355: 'error trx_line_id is '||l_error_rec.trx_line_id);
356: FND_LOG.STRING(g_level_statement,
357: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
358: 'error message_name is '||l_error_rec.message_name);
359: FND_LOG.STRING(g_level_statement,
360: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
361: 'error trx_level_type is '||l_error_rec.trx_level_type);
362: FND_LOG.STRING(g_level_statement,
363: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 362: FND_LOG.STRING(g_level_statement,

358: 'error message_name is '||l_error_rec.message_name);
359: FND_LOG.STRING(g_level_statement,
360: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
361: 'error trx_level_type is '||l_error_rec.trx_level_type);
362: FND_LOG.STRING(g_level_statement,
363: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
364: 'error other_doc_application_id is '||l_error_rec.other_doc_application_id);
365: FND_LOG.STRING(g_level_statement,
366: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 365: FND_LOG.STRING(g_level_statement,

361: 'error trx_level_type is '||l_error_rec.trx_level_type);
362: FND_LOG.STRING(g_level_statement,
363: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
364: 'error other_doc_application_id is '||l_error_rec.other_doc_application_id);
365: FND_LOG.STRING(g_level_statement,
366: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
367: 'error other_doc_entity_code is '||l_error_rec.other_doc_entity_code);
368: FND_LOG.STRING(g_level_statement,
369: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 368: FND_LOG.STRING(g_level_statement,

364: 'error other_doc_application_id is '||l_error_rec.other_doc_application_id);
365: FND_LOG.STRING(g_level_statement,
366: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
367: 'error other_doc_entity_code is '||l_error_rec.other_doc_entity_code);
368: FND_LOG.STRING(g_level_statement,
369: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
370: 'error other_doc_event_class_code is '||l_error_rec.other_doc_event_class_code);
371: FND_LOG.STRING(g_level_statement,
372: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

Line 371: FND_LOG.STRING(g_level_statement,

367: 'error other_doc_entity_code is '||l_error_rec.other_doc_entity_code);
368: FND_LOG.STRING(g_level_statement,
369: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
370: 'error other_doc_event_class_code is '||l_error_rec.other_doc_event_class_code);
371: FND_LOG.STRING(g_level_statement,
372: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
373: 'error other_doc_trx_id is '||l_error_rec.other_doc_trx_id);
374:
375: END LOOP;

Line 382: FND_LOG.STRING(g_level_statement,

378:
379: ZX_GLOBAL_STRUCTURES_PKG.delete_trx_line_dist_tbl;
380:
381: IF (g_level_statement >= g_current_runtime_level ) THEN
382: FND_LOG.STRING(g_level_statement,
383: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
384: 'x_return_status from Validate_Tax_Attr is '||x_return_status);
385: END IF;
386: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 387: FND_LOG.STRING(g_level_procedure,

383: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
384: 'x_return_status from Validate_Tax_Attr is '||x_return_status);
385: END IF;
386: IF (g_level_procedure >= g_current_runtime_level ) THEN
387: FND_LOG.STRING(g_level_procedure,
388: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
389: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');
390: END IF;
391:

Line 395: FND_LOG.STRING(g_level_unexpected,

391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: IF (g_level_unexpected >= g_current_runtime_level ) THEN
395: FND_LOG.STRING(g_level_unexpected,
396: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
397: sqlerrm);
398: END IF;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 453: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

449:
450: BEGIN
451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
454: IF (g_level_procedure >= g_current_runtime_level ) THEN
455: FND_LOG.STRING(g_level_procedure,
456: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
457: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(+)');

Line 455: FND_LOG.STRING(g_level_procedure,

451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
454: IF (g_level_procedure >= g_current_runtime_level ) THEN
455: FND_LOG.STRING(g_level_procedure,
456: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
457: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(+)');
458: END IF;
459:

Line 463: FND_LOG.STRING(g_level_statement,

459:
460:
461: --Bug 5018766 : Default the tax_date , tax_determine_date and tax_point_date for all the trx_lines
462: IF (g_level_statement >= g_current_runtime_level ) THEN
463: FND_LOG.STRING(g_level_statement,
464: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
465: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:
466: Stamping the Dates onto zx_transaction_lines_gt');
467: END IF;

Line 511: FND_LOG.STRING(g_level_statement,

507:
508: --Defaulting for Taxation Country
509:
510: IF (g_level_statement >= g_current_runtime_level ) THEN
511: FND_LOG.STRING(g_level_statement,
512: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
513: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:
514: Defaulting for Taxation Country');
515: END IF;

Line 530: FND_LOG.STRING(g_level_statement,

526:
527: --Defaulting for Tax Regime Code and Tax Code
528:
529: IF (g_level_statement >= g_current_runtime_level ) THEN
530: FND_LOG.STRING(g_level_statement,
531: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
532: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:
533: Defaulting for Tax Regime Code and Tax Code');
534: END IF;

Line 777: FND_LOG.STRING(g_level_statement,

773: AND TaxLines.tax_rate_id IS NOT NULL
774: AND ( TaxLines.tax_regime_code IS NULL OR TaxLines.tax IS NULL );
775:
776: IF (g_level_statement >= g_current_runtime_level ) THEN
777: FND_LOG.STRING(g_level_statement,
778: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
779: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Status Code');
780: END IF;
781:

Line 916: FND_LOG.STRING(g_level_statement,

912: (tax_rate_code IS NOT NULL OR tax_rate_id IS NOT NULL);
913:
914:
915: IF (g_level_statement >= g_current_runtime_level ) THEN
916: FND_LOG.STRING(g_level_statement,
917: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
918: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for tax_provider_id in ZX_IMPORT_TAX_LINES_GT ');
919: END IF;
920:

Line 1006: FND_LOG.STRING(g_level_statement,

1002: /* Bug 4703541 : Defaulting for Tax Jurisdiction Code */
1003: /* Seperated the Defaulting for Tax Jurisdiction Code as tax_rate_code
1004: is defaulted based on the Jurisdiction Code */
1005: IF (g_level_statement >= g_current_runtime_level ) THEN
1006: FND_LOG.STRING(g_level_statement,
1007: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1008: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Jurisdiction Code ');
1009: END IF;
1010:

Line 1117: FND_LOG.STRING(g_level_statement,

1113: WHERE tax_jurisdiction_code is NULL AND
1114: (tax_rate_code IS NOT NULL OR tax_rate_id IS NOT NULL);
1115:
1116: IF (g_level_statement >= g_current_runtime_level ) THEN
1117: FND_LOG.STRING(g_level_statement,
1118: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1119: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Rate Code,
1120: Tax Rate Id, Percentage Rate ');
1121: END IF;

Line 1369: FND_LOG.STRING(g_level_statement,

1365: /*Defaulting for Transaction Business Category and Product Category
1366: Product Fiscal Classification and Assessable Value */
1367:
1368: IF (g_level_statement >= g_current_runtime_level ) THEN
1369: FND_LOG.STRING(g_level_statement,
1370: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1371: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:
1372: Defaulting for Transaction Business Category and Product Category,
1373: Product Fiscal Classification and Assessable Value');

Line 1377: FND_LOG.STRING(g_level_statement,

1373: Product Fiscal Classification and Assessable Value');
1374: END IF;
1375:
1376: IF (g_level_statement >= g_current_runtime_level ) THEN
1377: FND_LOG.STRING(g_level_statement,
1378: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1379: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR: Before Call to the private procedure
1380: to default the additional tax attributes ');
1381: END IF;

Line 1387: FND_LOG.STRING(g_level_statement,

1383: -- Call the private procedure to default the tax attributes.
1384: def_additional_tax_attribs;
1385:
1386: IF (g_level_statement >= g_current_runtime_level ) THEN
1387: FND_LOG.STRING(g_level_statement,
1388: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1389: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting tax amount if it is NULL
1390: and tax rate is specified ');
1391: END IF;

Line 1569: FND_LOG.STRING(g_level_statement,

1565: -- Bug#3910168
1566: -- Defaulting for tax classification code
1567:
1568: IF (g_level_statement >= g_current_runtime_level ) THEN
1569: FND_LOG.STRING(g_level_statement,
1570: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1571: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR: Defaulting for tax classification code -
1572: Call to pop_def_tax_classif_code');
1573: END IF;

Line 1578: FND_LOG.STRING(g_level_procedure,

1574:
1575: pop_def_tax_classif_code(x_return_status);
1576:
1577: IF (g_level_procedure >= g_current_runtime_level ) THEN
1578: FND_LOG.STRING(g_level_procedure,
1579: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR.END',
1580: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(-)');
1581: END IF;
1582:

Line 1586: FND_LOG.STRING(g_level_unexpected,

1582:
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1586: FND_LOG.STRING(g_level_unexpected,
1587: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1588: sqlerrm);
1589: END IF;
1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1892: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1888: FROM zx_trx_tax_link_gt;
1889:
1890: BEGIN
1891: x_return_status := FND_API.G_RET_STS_SUCCESS;
1892: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1893: IF (g_level_procedure >= g_current_runtime_level ) THEN
1894: FND_LOG.STRING(g_level_procedure,
1895: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',
1896: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');

Line 1894: FND_LOG.STRING(g_level_procedure,

1890: BEGIN
1891: x_return_status := FND_API.G_RET_STS_SUCCESS;
1892: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1893: IF (g_level_procedure >= g_current_runtime_level ) THEN
1894: FND_LOG.STRING(g_level_procedure,
1895: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',
1896: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');
1897: END IF;
1898:

Line 1901: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

1897: END IF;
1898:
1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
1900: IF ( g_level_event >= g_current_runtime_level) THEN
1901: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1902: 'Validations for zx_trx_headers_gt and zx_transaction_lines_gt');
1903: END IF;
1904:
1905: -- Select the key columns and write into fnd log for debug purpose

Line 1905: -- Select the key columns and write into fnd log for debug purpose

1901: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1902: 'Validations for zx_trx_headers_gt and zx_transaction_lines_gt');
1903: END IF;
1904:
1905: -- Select the key columns and write into fnd log for debug purpose
1906: IF ( g_level_statement >= g_current_runtime_level) THEN
1907: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1908: 'Before opening the cursor - get_header_and_line_info_csr');
1909:

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

1903: END IF;
1904:
1905: -- Select the key columns and write into fnd log for debug purpose
1906: IF ( g_level_statement >= g_current_runtime_level) THEN
1907: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1908: 'Before opening the cursor - get_header_and_line_info_csr');
1909:
1910: OPEN get_header_and_line_info_csr;
1911:

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

1908: 'Before opening the cursor - get_header_and_line_info_csr');
1909:
1910: OPEN get_header_and_line_info_csr;
1911:
1912: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1913: 'After opening the cursor - get_header_and_line_info_csr');
1914:
1915: LOOP
1916: FETCH get_header_and_line_info_csr BULK COLLECT INTO

Line 1931: FND_LOG.STRING(g_level_statement,

1927: -- EXIT WHEN get_header_and_line_info_csr%notfound;
1928:
1929: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
1930:
1931: FND_LOG.STRING(g_level_statement,
1932: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1933: 'number of rows fetched = ' || to_char(l_count));
1934:
1935: IF l_count > 0 THEN

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

1935: IF l_count > 0 THEN
1936:
1937: FOR i IN 1.. l_count LOOP
1938:
1939: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1940: 'Row Number = ' || to_char(i) );
1941:
1942: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1943: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );

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

1938:
1939: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1940: 'Row Number = ' || to_char(i) );
1941:
1942: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1943: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
1944:
1945: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1946: 'l_entity_code = ' || l_entity_code_tbl(i) );

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

1941:
1942: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1943: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
1944:
1945: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1946: 'l_entity_code = ' || l_entity_code_tbl(i) );
1947:
1948: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1949: 'l_event_class_code = ' || l_event_class_code_tbl(i) );

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

1944:
1945: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1946: 'l_entity_code = ' || l_entity_code_tbl(i) );
1947:
1948: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1949: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
1950:
1951: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1952: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );

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

1947:
1948: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1949: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
1950:
1951: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1952: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
1953:
1954: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1955: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );

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

1950:
1951: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1952: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
1953:
1954: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1955: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
1956:
1957: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1958: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );

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

1953:
1954: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1955: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
1956:
1957: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1958: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );
1959:
1960: END LOOP;
1961: ELSE

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

1977:
1978: END IF; -- End of debug checking
1979:
1980: IF ( g_level_statement >= g_current_runtime_level) THEN
1981: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1982: 'Before insertion into ZX_VALIDATION_ERRORS_GT - zx_trx_headers_gt and zx_transaction_lines_gt');
1983: END IF;
1984:
1985: /******************** Split the Header and Line Level Validations : Bug 4703541******/

Line 2380: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2376: and fnd_terr.territory_code(+) =
2377: header.default_taxation_country;
2378:
2379: -- Bug 4902521 : Added Message to check no. of rows inserted .
2380: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2381:
2382: IF ( g_level_statement >= g_current_runtime_level) THEN
2383: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2384: 'No. of Rows inserted for Header Realted Validations '|| to_char(sql%ROWCOUNT) );

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

2379: -- Bug 4902521 : Added Message to check no. of rows inserted .
2380: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2381:
2382: IF ( g_level_statement >= g_current_runtime_level) THEN
2383: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2384: 'No. of Rows inserted for Header Realted Validations '|| to_char(sql%ROWCOUNT) );
2385: END IF;
2386:
2387: /** 2. Validating for the Line Related Validations : zx_transaction_lines_gt **/

Line 2388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2384: 'No. of Rows inserted for Header Realted Validations '|| to_char(sql%ROWCOUNT) );
2385: END IF;
2386:
2387: /** 2. Validating for the Line Related Validations : zx_transaction_lines_gt **/
2388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2389: IF ( g_level_statement >= g_current_runtime_level) THEN
2390: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2391: 'Validating for the Line Related Validations : zx_transaction_lines_gt');
2392: END IF;

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

2386:
2387: /** 2. Validating for the Line Related Validations : zx_transaction_lines_gt **/
2388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2389: IF ( g_level_statement >= g_current_runtime_level) THEN
2390: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2391: 'Validating for the Line Related Validations : zx_transaction_lines_gt');
2392: END IF;
2393:
2394: INSERT ALL

Line 4189: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4185: --and rates.tax_rate_code(+) = NVL(lines_gt.output_tax_classification_code,
4186: -- lines_gt.input_tax_classification_code);
4187:
4188: -- Bug 4902521 : Added Message to check no. of rows inserted .
4189: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4190:
4191: IF ( g_level_statement >= g_current_runtime_level) THEN
4192: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4193: 'No. of Rows inserted for Line Related Validations : '|| to_char(sql%ROWCOUNT) );

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

4188: -- Bug 4902521 : Added Message to check no. of rows inserted .
4189: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4190:
4191: IF ( g_level_statement >= g_current_runtime_level) THEN
4192: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4193: 'No. of Rows inserted for Line Related Validations : '|| to_char(sql%ROWCOUNT) );
4194: END IF;
4195:
4196: /******************** End of Logic for Header/Line Validations *************************/

Line 4199: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4195:
4196: /******************** End of Logic for Header/Line Validations *************************/
4197:
4198: -- Validations for Imported tax Lines.
4199: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4200: IF ( g_level_event >= g_current_runtime_level) THEN
4201: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4202: 'Validations for Imported tax Lines.');
4203: END IF;

Line 4201: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

4197:
4198: -- Validations for Imported tax Lines.
4199: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4200: IF ( g_level_event >= g_current_runtime_level) THEN
4201: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4202: 'Validations for Imported tax Lines.');
4203: END IF;
4204:
4205: -- Select the key columns and write into fnd log for debug purpose

Line 4205: -- Select the key columns and write into fnd log for debug purpose

4201: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4202: 'Validations for Imported tax Lines.');
4203: END IF;
4204:
4205: -- Select the key columns and write into fnd log for debug purpose
4206: IF ( g_level_statement >= g_current_runtime_level) THEN
4207: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4208: 'Before opening the cursor - get_import_tax_line_info_csr');
4209:

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

4203: END IF;
4204:
4205: -- Select the key columns and write into fnd log for debug purpose
4206: IF ( g_level_statement >= g_current_runtime_level) THEN
4207: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4208: 'Before opening the cursor - get_import_tax_line_info_csr');
4209:
4210: OPEN get_import_tax_line_info_csr;
4211:

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

4208: 'Before opening the cursor - get_import_tax_line_info_csr');
4209:
4210: OPEN get_import_tax_line_info_csr;
4211:
4212: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4213: 'After opening the cursor - get_import_tax_line_info_csr');
4214:
4215: LOOP
4216: FETCH get_import_tax_line_info_csr BULK COLLECT INTO

Line 4231: FND_LOG.STRING(g_level_statement,

4227: -- EXIT WHEN get_import_tax_line_info_csr%notfound;
4228:
4229: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
4230:
4231: FND_LOG.STRING(g_level_statement,
4232: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4233: 'number of rows fetched = ' || to_char(l_count));
4234:
4235: IF l_count > 0 THEN

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

4235: IF l_count > 0 THEN
4236:
4237: FOR i IN 1.. l_count LOOP
4238:
4239: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4240: 'Row Number = ' || to_char(i) );
4241:
4242: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4243: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );

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

4238:
4239: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4240: 'Row Number = ' || to_char(i) );
4241:
4242: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4243: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
4244:
4245: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4246: 'l_entity_code = ' || l_entity_code_tbl(i) );

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

4241:
4242: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4243: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
4244:
4245: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4246: 'l_entity_code = ' || l_entity_code_tbl(i) );
4247:
4248: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4249: 'l_event_class_code = ' || l_event_class_code_tbl(i) );

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

4244:
4245: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4246: 'l_entity_code = ' || l_entity_code_tbl(i) );
4247:
4248: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4249: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
4250:
4251: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4252: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );

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

4247:
4248: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4249: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
4250:
4251: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4252: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
4253:
4254: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4255: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );

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

4250:
4251: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4252: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
4253:
4254: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4255: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
4256:
4257: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4258: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );

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

4253:
4254: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4255: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
4256:
4257: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4258: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );
4259:
4260: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4261: 'l_summary_tax_line_number = ' || to_char(l_summary_tax_line_number_tbl(i)) );

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

4256:
4257: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4258: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );
4259:
4260: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4261: 'l_summary_tax_line_number = ' || to_char(l_summary_tax_line_number_tbl(i)) );
4262:
4263:
4264: END LOOP;

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

4282:
4283: END IF; -- End of debug checking
4284:
4285: IF ( g_level_statement >= g_current_runtime_level) THEN
4286: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4287: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Imported Tax Lines Validations');
4288: END IF;
4289:
4290: IF ( g_level_statement >= g_current_runtime_level) THEN

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

4287: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Imported Tax Lines Validations');
4288: END IF;
4289:
4290: IF ( g_level_statement >= g_current_runtime_level) THEN
4291: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4292: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Regime,Tax,Status and Jurisdiction related Imported Tax Lines Validations');
4293: END IF;
4294:
4295: INSERT ALL

Line 5602: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5598: )
5599: )
5600: ) ;
5601:
5602: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5603:
5604: IF ( g_level_statement >= g_current_runtime_level) THEN
5605: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5606: 'No. of Rows inserted for Import Tax Line Validations : Regime,Tax,Status '|| to_char(sql%ROWCOUNT) );

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

5601:
5602: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5603:
5604: IF ( g_level_statement >= g_current_runtime_level) THEN
5605: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5606: 'No. of Rows inserted for Import Tax Line Validations : Regime,Tax,Status '|| to_char(sql%ROWCOUNT) );
5607: END IF;
5608:
5609: -- Bug 5018766

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

5896: AND A.SUMMARY_TAX_LINE_NUMBER = B.SUMMARY_TAX_LINE_NUMBER
5897: AND A.MESSAGE_NAME = B.MESSAGE_NAME );
5898:
5899: IF ( g_level_statement >= g_current_runtime_level) THEN
5900: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5901: 'Before insertion into ZX_VALIDATION_ERRORS_GT for RateCode related Imported Tax Lines Validations');
5902: END IF;
5903:
5904: INSERT ALL

Line 6278: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6274: AND rate.tax_rate_code = off_rate.offset_tax_rate_code(+)
6275: AND off_rate.tax_rate_code = temp_gt.tax_rate_code(+)
6276: );
6277:
6278: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6279:
6280: IF ( g_level_statement >= g_current_runtime_level) THEN
6281: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6282: 'No. of Rows inserted for Import Tax Line Validations : Rate Code '|| to_char(sql%ROWCOUNT) );

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

6277:
6278: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6279:
6280: IF ( g_level_statement >= g_current_runtime_level) THEN
6281: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6282: 'No. of Rows inserted for Import Tax Line Validations : Rate Code '|| to_char(sql%ROWCOUNT) );
6283: END IF;
6284:
6285: IF ( g_level_statement >= g_current_runtime_level) THEN

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

6282: 'No. of Rows inserted for Import Tax Line Validations : Rate Code '|| to_char(sql%ROWCOUNT) );
6283: END IF;
6284:
6285: IF ( g_level_statement >= g_current_runtime_level) THEN
6286: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6287: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Rate Imported Tax Lines Validations based on tax_rate_id');
6288: END IF;
6289:
6290: INSERT ALL

Line 6538: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6534: AND off_rate.tax_rate_code = temp_gt.tax_rate_code(+)
6535: );
6536:
6537: -- Bug 4902521 : Added Message to check no. of rows inserted .
6538: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6539:
6540: IF ( g_level_statement >= g_current_runtime_level) THEN
6541: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6542: 'No. of Rows inserted for Import Tax Line Validations : Rate ID '|| to_char(sql%ROWCOUNT) );

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

6537: -- Bug 4902521 : Added Message to check no. of rows inserted .
6538: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6539:
6540: IF ( g_level_statement >= g_current_runtime_level) THEN
6541: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6542: 'No. of Rows inserted for Import Tax Line Validations : Rate ID '|| to_char(sql%ROWCOUNT) );
6543: END IF;
6544:
6545: -- Validations for zx_trx_tax_link_gt link_gt

Line 6546: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6542: 'No. of Rows inserted for Import Tax Line Validations : Rate ID '|| to_char(sql%ROWCOUNT) );
6543: END IF;
6544:
6545: -- Validations for zx_trx_tax_link_gt link_gt
6546: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6547: IF ( g_level_event >= g_current_runtime_level) THEN
6548: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6549: 'Validations for zx_trx_tax_link_gt link_gt');
6550: END IF;

Line 6548: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

6544:
6545: -- Validations for zx_trx_tax_link_gt link_gt
6546: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6547: IF ( g_level_event >= g_current_runtime_level) THEN
6548: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6549: 'Validations for zx_trx_tax_link_gt link_gt');
6550: END IF;
6551:
6552: -- Select the key columns and write into fnd log for debug purpose

Line 6552: -- Select the key columns and write into fnd log for debug purpose

6548: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6549: 'Validations for zx_trx_tax_link_gt link_gt');
6550: END IF;
6551:
6552: -- Select the key columns and write into fnd log for debug purpose
6553: IF ( g_level_statement >= g_current_runtime_level) THEN
6554: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6555: 'Before opening the cursor - get_tax_link_gt_info_csr');
6556:

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

6550: END IF;
6551:
6552: -- Select the key columns and write into fnd log for debug purpose
6553: IF ( g_level_statement >= g_current_runtime_level) THEN
6554: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6555: 'Before opening the cursor - get_tax_link_gt_info_csr');
6556:
6557: OPEN get_tax_link_gt_info_csr;
6558: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

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

6554: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6555: 'Before opening the cursor - get_tax_link_gt_info_csr');
6556:
6557: OPEN get_tax_link_gt_info_csr;
6558: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6559: 'After opening the cursor - get_tax_link_gt_info_csr');
6560: LOOP
6561: FETCH get_tax_link_gt_info_csr BULK COLLECT INTO
6562: l_application_id_tbl,

Line 6576: FND_LOG.STRING(g_level_statement,

6572: -- EXIT WHEN get_tax_link_gt_info_csr%notfound;
6573:
6574: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
6575:
6576: FND_LOG.STRING(g_level_statement,
6577: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6578: 'number of rows fetched = ' || to_char(l_count));
6579:
6580: IF l_count > 0 THEN

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

6580: IF l_count > 0 THEN
6581:
6582: FOR i IN 1.. l_count LOOP
6583:
6584: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6585: 'Row Number = ' || to_char(i) );
6586:
6587: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6588: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );

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

6583:
6584: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6585: 'Row Number = ' || to_char(i) );
6586:
6587: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6588: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
6589:
6590: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6591: 'l_entity_code = ' || l_entity_code_tbl(i) );

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

6586:
6587: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6588: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
6589:
6590: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6591: 'l_entity_code = ' || l_entity_code_tbl(i) );
6592:
6593: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6594: 'l_event_class_code = ' || l_event_class_code_tbl(i) );

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

6589:
6590: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6591: 'l_entity_code = ' || l_entity_code_tbl(i) );
6592:
6593: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6594: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
6595:
6596: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6597: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );

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

6592:
6593: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6594: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
6595:
6596: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6597: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
6598:
6599: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6600: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );

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

6595:
6596: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6597: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
6598:
6599: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6600: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
6601:
6602: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6603: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );

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

6598:
6599: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6600: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
6601:
6602: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6603: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );
6604:
6605: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6606: 'l_summary_tax_line_number = ' || to_char(l_summary_tax_line_number_tbl(i)) );

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

6601:
6602: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6603: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );
6604:
6605: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6606: 'l_summary_tax_line_number = ' || to_char(l_summary_tax_line_number_tbl(i)) );
6607:
6608:
6609: END LOOP;

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

6627:
6628: END IF; -- End of debug checking
6629:
6630: IF ( g_level_statement >= g_current_runtime_level) THEN
6631: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6632: 'Before insertion into ZX_VALIDATION_ERRORS_GT - Validations for zx_trx_tax_link_gt link_gt');
6633: END IF;
6634:
6635:

Line 6729: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6725: END ZX_INVALID_SUMMARY_TAX_LINE_ID
6726: FROM zx_trx_tax_link_gt link_gt;
6727:
6728: -- Bug 4902521 : Added Message to check no. of rows inserted .
6729: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6730:
6731: IF ( g_level_statement >= g_current_runtime_level) THEN
6732: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6733: 'No. of Rows inserted for Link_gt Realted Validations '|| to_char(sql%ROWCOUNT) );

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

6728: -- Bug 4902521 : Added Message to check no. of rows inserted .
6729: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6730:
6731: IF ( g_level_statement >= g_current_runtime_level) THEN
6732: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6733: 'No. of Rows inserted for Link_gt Realted Validations '|| to_char(sql%ROWCOUNT) );
6734: END IF;
6735:
6736: -- Bug Fix # 4184091

Line 6742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6738: update zx_trx_headers_gt set validation_check_flag = 'N' where
6739: trx_id in (select trx_id from zx_validation_errors_gt);
6740:
6741: IF ( SQL%ROWCOUNT > 0 ) THEN
6742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6743: IF ( g_level_statement >= g_current_runtime_level) THEN
6744: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6745: 'Updated the validation_check_flag to N in zx_trx_headers_gt for '||to_char(SQL%ROWCOUNT)||' trx_ids ');
6746: END IF;

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

6740:
6741: IF ( SQL%ROWCOUNT > 0 ) THEN
6742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6743: IF ( g_level_statement >= g_current_runtime_level) THEN
6744: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6745: 'Updated the validation_check_flag to N in zx_trx_headers_gt for '||to_char(SQL%ROWCOUNT)||' trx_ids ');
6746: END IF;
6747: END IF ;
6748:

Line 6750: FND_LOG.STRING(g_level_procedure,

6746: END IF;
6747: END IF ;
6748:
6749: IF (g_level_procedure >= g_current_runtime_level ) THEN
6750: FND_LOG.STRING(g_level_procedure,
6751: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.END',
6752: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(-)');
6753: END IF;
6754:

Line 6759: FND_LOG.STRING(g_level_unexpected,

6755:
6756: EXCEPTION
6757: WHEN OTHERS THEN
6758: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6759: FND_LOG.STRING(g_level_unexpected,
6760: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6761: sqlerrm);
6762: END IF;
6763:

Line 6808: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6804: AND lines_gt.trx_id = header.trx_id;
6805:
6806: BEGIN
6807:
6808: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6809:
6810: IF (g_level_event >= g_current_runtime_level ) THEN
6811: FND_LOG.STRING(g_level_event,
6812: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.BEGIN',

Line 6811: FND_LOG.STRING(g_level_event,

6807:
6808: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6809:
6810: IF (g_level_event >= g_current_runtime_level ) THEN
6811: FND_LOG.STRING(g_level_event,
6812: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.BEGIN',
6813: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(+)');
6814: END IF;
6815:

Line 6816: -- Select the key columns and write into fnd log for debug purpose

6812: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.BEGIN',
6813: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(+)');
6814: END IF;
6815:
6816: -- Select the key columns and write into fnd log for debug purpose
6817: IF ( g_level_statement >= g_current_runtime_level) THEN
6818: FND_LOG.STRING(g_level_statement,
6819: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6820: 'Before opening the cursor - get_other_doc_info_csr');

Line 6818: FND_LOG.STRING(g_level_statement,

6814: END IF;
6815:
6816: -- Select the key columns and write into fnd log for debug purpose
6817: IF ( g_level_statement >= g_current_runtime_level) THEN
6818: FND_LOG.STRING(g_level_statement,
6819: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6820: 'Before opening the cursor - get_other_doc_info_csr');
6821:
6822: OPEN get_other_doc_info_csr;

Line 6823: FND_LOG.STRING(g_level_statement,

6819: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6820: 'Before opening the cursor - get_other_doc_info_csr');
6821:
6822: OPEN get_other_doc_info_csr;
6823: FND_LOG.STRING(g_level_statement,
6824: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6825: 'After opening the cursor - get_other_doc_info_csr');
6826:
6827: LOOP

Line 6843: FND_LOG.STRING(g_level_statement,

6839: -- EXIT WHEN get_other_doc_info_csr%notfound;
6840:
6841: l_count := nvl(l_trx_line_id_tbl.COUNT,0);
6842:
6843: FND_LOG.STRING(g_level_statement,
6844: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6845: 'number of rows fetched = ' || to_char(l_count));
6846:
6847: IF l_count > 0 THEN

Line 6851: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

6847: IF l_count > 0 THEN
6848:
6849: FOR i IN 1.. l_count LOOP
6850:
6851: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6852: 'Row Number = ' || to_char(i) );
6853:
6854: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6855: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );

Line 6854: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

6850:
6851: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6852: 'Row Number = ' || to_char(i) );
6853:
6854: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6855: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
6856:
6857: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6858: 'l_entity_code = ' || l_entity_code_tbl(i) );

Line 6857: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

6853:
6854: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6855: 'l_application_id = ' || to_char(l_application_id_tbl(i)) );
6856:
6857: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6858: 'l_entity_code = ' || l_entity_code_tbl(i) );
6859:
6860: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6861: 'l_event_class_code = ' || l_event_class_code_tbl(i) );

Line 6860: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

6856:
6857: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6858: 'l_entity_code = ' || l_entity_code_tbl(i) );
6859:
6860: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6861: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
6862:
6863: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6864: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );

Line 6863: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

6859:
6860: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6861: 'l_event_class_code = ' || l_event_class_code_tbl(i) );
6862:
6863: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6864: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
6865:
6866: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6867: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );

Line 6866: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

6862:
6863: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6864: 'l_trx_id = ' || to_char(l_trx_id_tbl(i)) );
6865:
6866: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6867: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
6868:
6869: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6870: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );

Line 6869: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

6865:
6866: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6867: 'l_trx_line_id = ' || to_char(l_trx_line_id_tbl(i)) );
6868:
6869: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6870: 'l_trx_level_type = ' || l_trx_level_type_tbl(i) );
6871:
6872: END LOOP;
6873: ELSE

Line 6892: FND_LOG.STRING(g_level_statement,

6888:
6889: END IF; -- End of debug checking
6890:
6891: IF (g_level_statement >= g_current_runtime_level ) THEN
6892: FND_LOG.STRING(g_level_statement,
6893: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6894: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Validate_Other_Documents');
6895: END IF;
6896:

Line 7319: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7315: AND lines_gt.entity_code = header.entity_code
7316: AND lines_gt.event_class_code = header.event_class_code
7317: AND lines_gt.trx_id = header.trx_id;
7318:
7319: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7320:
7321: IF ( g_level_statement >= g_current_runtime_level) THEN
7322: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
7323: 'No. of Rows inserted for Header Realted Validations '|| to_char(sql%ROWCOUNT) );

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

7318:
7319: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7320:
7321: IF ( g_level_statement >= g_current_runtime_level) THEN
7322: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
7323: 'No. of Rows inserted for Header Realted Validations '|| to_char(sql%ROWCOUNT) );
7324: END IF;
7325:
7326: IF ( g_level_event >= g_current_runtime_level) THEN

Line 7327: FND_LOG.STRING(g_level_event,

7323: 'No. of Rows inserted for Header Realted Validations '|| to_char(sql%ROWCOUNT) );
7324: END IF;
7325:
7326: IF ( g_level_event >= g_current_runtime_level) THEN
7327: FND_LOG.STRING(g_level_event,
7328: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.END',
7329: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(-)');
7330: END IF;
7331:

Line 7335: FND_LOG.STRING(g_level_unexpected,

7331:
7332: EXCEPTION
7333: WHEN OTHERS THEN
7334: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7335: FND_LOG.STRING(g_level_unexpected,
7336: 'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
7337: sqlerrm);
7338: END IF;
7339:

Line 7488: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7484: AND L.output_tax_classification_code IS NULL ;
7485:
7486: BEGIN
7487:
7488: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7489:
7490: IF (g_level_statement >= g_current_runtime_level ) THEN
7491: FND_LOG.STRING(g_level_statement,
7492: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code.BEGIN',

Line 7491: FND_LOG.STRING(g_level_statement,

7487:
7488: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7489:
7490: IF (g_level_statement >= g_current_runtime_level ) THEN
7491: FND_LOG.STRING(g_level_statement,
7492: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code.BEGIN',
7493: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(+)');
7494: END IF;
7495:

Line 7505: FND_LOG.STRING(g_level_statement,

7501:
7502: OPEN get_parm_info_for_def_tax_csr;
7503:
7504: IF (g_level_statement >= g_current_runtime_level ) THEN
7505: FND_LOG.STRING(g_level_statement,
7506: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
7507: 'After opening the cursor - get_parm_info_for_def_tax_csr');
7508: END IF;
7509:

Line 7561: FND_LOG.STRING(g_level_procedure,

7557:
7558: l_count := l_trx_line_id_tbl.COUNT;
7559:
7560: IF (g_level_procedure >= g_current_runtime_level ) THEN
7561: FND_LOG.STRING(g_level_procedure,
7562: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7563: 'number of rows fetched = ' || to_char(l_count));
7564: END IF;
7565:

Line 7638: FND_LOG.STRING(g_level_statement,

7634: --
7635: -- get default tax classification code
7636: --
7637: IF (g_level_statement >= g_current_runtime_level ) THEN
7638: FND_LOG.STRING(g_level_statement,
7639: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7640: 'Calling ZX_TAX_DEFAULT_PKG.get_default_tax_classification for record '||to_char(i));
7641: END IF;
7642: /* Bug 4919842 : Conditionally Call ZX_TAX_DEFAULT_PKG.get_default_tax_classification if both input

Line 7675: FND_LOG.STRING(g_level_statement,

7671: -- update zx_transaction_lines_gt with the default
7672: -- tax classification code found
7673: --
7674: IF (g_level_statement >= g_current_runtime_level ) THEN
7675: FND_LOG.STRING(g_level_statement,
7676: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7677: 'update zx_transaction_lines_gt with the default tax classification code found ');
7678: END IF;
7679:

Line 7694: FND_LOG.STRING(g_level_procedure,

7690: AND trx_line_id = l_trx_line_id_tbl(i)
7691: AND trx_level_type = l_trx_level_type_tbl(i);
7692:
7693: IF (g_level_procedure >= g_current_runtime_level ) THEN
7694: FND_LOG.STRING(g_level_procedure,
7695: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7696: 'fetch next set of records for defaulting ....');
7697: END IF;
7698: ELSE

Line 7713: FND_LOG.STRING(g_level_procedure,

7709: RETURN;
7710: END IF;
7711:
7712: IF (g_level_procedure >= g_current_runtime_level ) THEN
7713: FND_LOG.STRING(g_level_procedure,
7714: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7715: 'x_return_status = ' || x_return_status);
7716: FND_LOG.STRING(g_level_procedure,
7717: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

Line 7716: FND_LOG.STRING(g_level_procedure,

7712: IF (g_level_procedure >= g_current_runtime_level ) THEN
7713: FND_LOG.STRING(g_level_procedure,
7714: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7715: 'x_return_status = ' || x_return_status);
7716: FND_LOG.STRING(g_level_procedure,
7717: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7718: 'l_error_buffer = ' || l_error_buffer);
7719: FND_LOG.STRING(g_level_procedure,
7720: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code.END',

Line 7719: FND_LOG.STRING(g_level_procedure,

7715: 'x_return_status = ' || x_return_status);
7716: FND_LOG.STRING(g_level_procedure,
7717: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7718: 'l_error_buffer = ' || l_error_buffer);
7719: FND_LOG.STRING(g_level_procedure,
7720: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code.END',
7721: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(-)');
7722: END IF;
7723:

Line 7736: FND_LOG.STRING(g_level_unexpected,

7732: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','pop_def_tax_classif_code- '|| l_error_buffer);
7733: FND_MSG_PUB.Add;
7734:
7735: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7736: FND_LOG.STRING(g_level_unexpected,
7737: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7738: l_error_buffer);
7739: END IF;
7740:

Line 8187: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8183:
8184:
8185: BEGIN
8186:
8187: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8188:
8189: IF (g_level_event >= g_current_runtime_level ) THEN
8190: FND_LOG.STRING(g_level_event,
8191: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.BEGIN',

Line 8190: FND_LOG.STRING(g_level_event,

8186:
8187: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8188:
8189: IF (g_level_event >= g_current_runtime_level ) THEN
8190: FND_LOG.STRING(g_level_event,
8191: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.BEGIN',
8192: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(+)');
8193: END IF;
8194:

Line 8199: FND_LOG.STRING(g_level_statement,

8195: /** Bug 4703541 :
8196: Change Made : Replace global_structure_rec with ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl
8197: as this is being directly referred in ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS **/
8198: IF (g_level_statement >= g_current_runtime_level ) THEN
8199: FND_LOG.STRING(g_level_statement,
8200: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8201: 'Before opening the cursor - gtt_to_glb_strctr_csr');
8202: END IF;
8203:

Line 8208: FND_LOG.STRING(g_level_statement,

8204: x_return_status := FND_API.G_RET_STS_SUCCESS;
8205: OPEN gtt_to_glb_strctr_csr;
8206:
8207: IF (g_level_statement >= g_current_runtime_level ) THEN
8208: FND_LOG.STRING(g_level_statement,
8209: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8210: 'After opening the cursor - gtt_to_glb_strctr_csr');
8211: END IF;
8212:

Line 8613: FND_LOG.STRING(G_LEVEL_EVENT,

8609: l_event_class_rec.RNDG_BILL_FROM_PARTY_SITE_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(i) ;
8610:
8611:
8612: IF ( G_LEVEL_EVENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8613: FND_LOG.STRING(G_LEVEL_EVENT,
8614: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8615: 'Validating Transaction: '||
8616: to_char(l_event_class_rec.trx_id)||
8617: ' of Application: '||

Line 8631: FND_LOG.STRING(g_level_procedure,

8627: );
8628:
8629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8630: IF (g_level_procedure >= g_current_runtime_level ) THEN
8631: FND_LOG.STRING(g_level_procedure,
8632: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8633: 'x_return_status = ' || x_return_status);
8634: FND_LOG.STRING(g_level_procedure,
8635: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

Line 8634: FND_LOG.STRING(g_level_procedure,

8630: IF (g_level_procedure >= g_current_runtime_level ) THEN
8631: FND_LOG.STRING(g_level_procedure,
8632: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8633: 'x_return_status = ' || x_return_status);
8634: FND_LOG.STRING(g_level_procedure,
8635: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8636: 'l_error_buffer = ' || l_error_buffer);
8637: FND_LOG.STRING(g_level_procedure,
8638: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

Line 8637: FND_LOG.STRING(g_level_procedure,

8633: 'x_return_status = ' || x_return_status);
8634: FND_LOG.STRING(g_level_procedure,
8635: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8636: 'l_error_buffer = ' || l_error_buffer);
8637: FND_LOG.STRING(g_level_procedure,
8638: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
8639: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
8640: END IF;
8641:

Line 8649: FND_LOG.STRING(g_level_statement,

8645: END IF;
8646:
8647:
8648: IF (g_level_statement >= g_current_runtime_level ) THEN
8649: FND_LOG.STRING(g_level_statement,
8650: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8651: 'Before Calling ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS for record '||to_char(i));
8652: END IF;
8653:

Line 8664: FND_LOG.STRING(g_level_statement,

8660: x_return_status
8661: );
8662:
8663: IF (g_level_statement >= g_current_runtime_level ) THEN
8664: FND_LOG.STRING(g_level_statement,
8665: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8666: 'Before Calling ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS for record '||to_char(i));
8667: END IF;
8668:

Line 8679: FND_LOG.STRING(g_level_procedure,

8675: );
8676:
8677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8678: IF (g_level_procedure >= g_current_runtime_level ) THEN
8679: FND_LOG.STRING(g_level_procedure,
8680: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8681: 'x_return_status = ' || x_return_status);
8682: FND_LOG.STRING(g_level_procedure,
8683: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

Line 8682: FND_LOG.STRING(g_level_procedure,

8678: IF (g_level_procedure >= g_current_runtime_level ) THEN
8679: FND_LOG.STRING(g_level_procedure,
8680: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8681: 'x_return_status = ' || x_return_status);
8682: FND_LOG.STRING(g_level_procedure,
8683: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8684: 'l_error_buffer = ' || l_error_buffer);
8685: FND_LOG.STRING(g_level_procedure,
8686: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

Line 8685: FND_LOG.STRING(g_level_procedure,

8681: 'x_return_status = ' || x_return_status);
8682: FND_LOG.STRING(g_level_procedure,
8683: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8684: 'l_error_buffer = ' || l_error_buffer);
8685: FND_LOG.STRING(g_level_procedure,
8686: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
8687: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
8688: END IF;
8689:

Line 8699: FND_LOG.STRING(g_level_statement,

8695: -- update zx_transaction_lines_gt with the default
8696: -- tax attributes found
8697:
8698: IF (g_level_statement >= g_current_runtime_level ) THEN
8699: FND_LOG.STRING(g_level_statement,
8700: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8701: 'updating zx_transaction_lines_gt with tax attributes found');
8702: END IF;
8703:

Line 8750: FND_LOG.STRING(g_level_event,

8746: END LOOP;
8747: CLOSE gtt_to_glb_strctr_csr;
8748:
8749: IF (g_level_event >= g_current_runtime_level ) THEN
8750: FND_LOG.STRING(g_level_event,
8751: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',
8752: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');
8753: END IF;
8754:

Line 8768: FND_LOG.STRING(g_level_unexpected,

8764: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','def_additional_tax_attribs- '|| l_error_buffer);
8765: FND_MSG_PUB.Add;
8766:
8767: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8768: FND_LOG.STRING(g_level_unexpected,
8769: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8770: l_error_buffer);
8771: END IF;
8772: