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 ZX_VALIDATE_API_PKG

Line 1: PACKAGE BODY Zx_Validate_Api_Pkg AS

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;

Line 158: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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:
162: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;

Line 159: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');

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:
162: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
163:

Line 342: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
346: 'error entity_code is '||l_error_rec.entity_code);

Line 345: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
349: 'error event_class_code is '||l_error_rec.event_class_code);

Line 348: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
352: 'error trx_id is '||l_error_rec.trx_id);

Line 351: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
355: 'error trx_line_id is '||l_error_rec.trx_line_id);

Line 354: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
358: 'error message_name is '||l_error_rec.message_name);

Line 357: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
361: 'error trx_level_type is '||l_error_rec.trx_level_type);

Line 360: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
364: 'error other_doc_application_id is '||l_error_rec.other_doc_application_id);

Line 363: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
367: 'error other_doc_entity_code is '||l_error_rec.other_doc_entity_code);

Line 366: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
370: 'error other_doc_event_class_code is '||l_error_rec.other_doc_event_class_code);

Line 369: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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',
373: 'error other_doc_trx_id is '||l_error_rec.other_doc_trx_id);

Line 372: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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

Line 383: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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
387: FND_LOG.STRING(g_level_procedure,

Line 388: '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:
392: EXCEPTION

Line 389: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(-)');

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:
392: EXCEPTION
393: WHEN OTHERS THEN

Line 396: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',

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;
400: app_exception.raise_exception;

Line 456: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 457: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(+)');

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:
460:
461: --Bug 5018766 : Default the tax_date , tax_determine_date and tax_point_date for all the trx_lines

Line 464: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 465: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:

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;
468:
469: OPEN c_lines;

Line 512: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 513: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:

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;
516:
517: UPDATE ZX_TRX_HEADERS_GT Header

Line 531: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 532: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:

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;
535:
536: /* Default Logic based on Rate Code and Rate Id are seperated

Line 778: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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:
782: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 779: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Status Code');

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:
782: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
783: SET tax_status_code =

Line 917: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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:
921: --Defaulting for tax Provider Id

Line 918: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for tax_provider_id in ZX_IMPORT_TAX_LINES_GT ');

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:
921: --Defaulting for tax Provider Id
922: Update ZX_IMPORT_TAX_LINES_GT TaxLines

Line 1007: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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:
1011: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

Line 1008: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Jurisdiction 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:
1011: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1012: SET tax_jurisdiction_code =

Line 1118: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 1119: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Rate Code,

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;
1122:
1123:

Line 1370: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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');
1374: END IF;

Line 1371: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:

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');
1374: END IF;
1375:

Line 1378: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 1379: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR: Before Call to the private procedure

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;
1382:
1383: -- Call the private procedure to default the tax attributes.

Line 1388: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 1389: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting tax amount if it is NULL

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;
1392:
1393: --- CR 3275391 Default tax amount if it is NULL and tax rate is specified ----

Line 1570: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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

Line 1571: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR: 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;
1574:
1575: pop_def_tax_classif_code(x_return_status);

Line 1579: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR.END',

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:
1583: EXCEPTION

Line 1580: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR(-)');

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:
1583: EXCEPTION
1584: WHEN OTHERS THEN

Line 1587: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

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;
1591: app_exception.raise_exception;

Line 1895: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.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:
1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT

Line 1896: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');

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:
1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
1900: IF ( g_level_event >= g_current_runtime_level) THEN

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 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 1932: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

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

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 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 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 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 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 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 4232: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

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

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 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 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 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 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 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 6577: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

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

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 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 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 6751: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.END',

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

Line 6752: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(-)');

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:
6755:
6756: EXCEPTION

Line 6760: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

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:
6764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6812: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.BEGIN',

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:
6816: -- Select the key columns and write into fnd log for debug purpose

Line 6813: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(+)');

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:
6816: -- Select the key columns and write into fnd log for debug purpose
6817: IF ( g_level_statement >= g_current_runtime_level) THEN

Line 6819: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

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;
6823: FND_LOG.STRING(g_level_statement,

Line 6824: '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
6828: FETCH get_other_doc_info_csr BULK COLLECT INTO

Line 6844: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

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

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 6893: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

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:
6897: INSERT ALL

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 7328: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents.END',

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:
7332: EXCEPTION

Line 7329: 'ZX_VALIDATE_API_PKG: Validate_Other_Documents(-)');

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:
7332: EXCEPTION
7333: WHEN OTHERS THEN

Line 7336: 'ZX_VALIDATE_API_PKG.Validate_Other_Documents',

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:
7340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7492: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code.BEGIN',

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

Line 7493: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(+)');

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:
7496: --
7497: -- init error buffer and return status

Line 7506: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',

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:
7510: LOOP

Line 7562: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

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:
7566: IF l_count > 0 THEN

Line 7639: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

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
7643: AND output tax classification codes are passed as null */

Line 7676: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

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:
7680: FORALL i IN 1 .. l_count

Line 7695: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

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

Line 7714: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

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',
7718: 'l_error_buffer = ' || l_error_buffer);

Line 7717: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

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',
7721: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(-)');

Line 7720: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code.END',

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:
7724: EXCEPTION

Line 7721: 'ZX_VALIDATE_API_PKG: pop_def_tax_classif_code(-)');

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:
7724: EXCEPTION
7725: WHEN OTHERS THEN

Line 7737: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',

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:
7741: END pop_def_tax_classif_code;

Line 8191: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.BEGIN',

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:
8195: /** Bug 4703541 :

Line 8192: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(+)');

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:
8195: /** Bug 4703541 :
8196: Change Made : Replace global_structure_rec with ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl

Line 8200: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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:
8204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8209: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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:
8213: LOOP

Line 8614: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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: '||
8618: to_char(l_event_class_rec.application_id) ||

Line 8632: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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',
8636: 'l_error_buffer = ' || l_error_buffer);

Line 8635: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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',
8639: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

Line 8638: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

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:
8642: RETURN;

Line 8639: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

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:
8642: RETURN;
8643:

Line 8650: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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:
8654: ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS

Line 8665: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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:
8669: ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_REPORTING_ATTRIBS

Line 8680: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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',
8684: 'l_error_buffer = ' || l_error_buffer);

Line 8683: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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',
8687: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

Line 8686: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

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:
8690: RETURN;

Line 8687: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

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:
8690: RETURN;
8691:

Line 8700: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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:
8704: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.last,0)

Line 8751: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs.END',

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:
8755: EXCEPTION

Line 8752: 'ZX_VALIDATE_API_PKG: def_additional_tax_attribs(-)');

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:
8755: EXCEPTION
8756:

Line 8769: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',

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:
8773: END def_additional_tax_attribs;

Line 8870: END Zx_Validate_Api_Pkg;

8866: l_tax_rate_id_code_missing :=fnd_message.get_string('ZX','ZX_TAX_RATE_ID_CODE_MISSING' ); -- 4917256
8867: l_imp_tax_rate_amt_mismatch :=fnd_message.get_string('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
8868:
8869:
8870: END Zx_Validate_Api_Pkg;