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

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

4: -- Declare Public Procedure
5: -- Initialize
6:
7: g_current_runtime_level NUMBER;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12:

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

5: -- Initialize
6:
7: g_current_runtime_level NUMBER;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12:
13: result boolean;

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

6:
7: g_current_runtime_level NUMBER;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12:
13: result boolean;
14: statement varchar2(2000);

Line 67: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

63: FROM gl_sets_of_books sob,
64: financials_system_parameters fsp
65: WHERE fsp.set_of_books_id = sob.set_of_books_id;
66: BEGIN
67: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68:
69: IF (g_level_statement >= g_current_runtime_level ) THEN
70: FND_LOG.STRING(g_level_statement,
71: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Initialize.BEGIN',

Line 70: FND_LOG.STRING(g_level_statement,

66: BEGIN
67: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68:
69: IF (g_level_statement >= g_current_runtime_level ) THEN
70: FND_LOG.STRING(g_level_statement,
71: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Initialize.BEGIN',
72: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: initialize(+)' );
73: END IF;
74:

Line 82: FND_LOG.STRING(g_level_statement,

78: fetch c_financial_params into l_set_of_books_id,l_chart_of_accounts_id;
79: close c_financial_params;
80:
81: IF (g_level_statement >= g_current_runtime_level ) THEN
82: FND_LOG.STRING(g_level_statement,
83: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.initialize',
84: 'set_of_books_id =='||to_char(l_set_of_books_id));
85:
86: FND_LOG.STRING(g_level_statement,

Line 86: FND_LOG.STRING(g_level_statement,

82: FND_LOG.STRING(g_level_statement,
83: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.initialize',
84: 'set_of_books_id =='||to_char(l_set_of_books_id));
85:
86: FND_LOG.STRING(g_level_statement,
87: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.initialize',
88: 'chart_of_accounts_id =='||to_char(l_chart_of_accounts_id));
89: END IF;
90:

Line 102: FND_LOG.STRING(g_level_statement,

98: sysinfo.po_info.org_id := NULL;
99: sysinfo.cc_info.org_id := NULL; -- Bug 6510307
100:
101: IF (g_level_statement >= g_current_runtime_level ) THEN
102: FND_LOG.STRING(g_level_statement,
103: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Initialize.END',
104: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: initialize(-)' );
105: END IF;
106:

Line 118: FND_LOG.STRING(g_level_unexpected,

114: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
115: FND_MSG_PUB.Add;
116:
117: IF (g_level_unexpected >= g_current_runtime_level ) THEN
118: FND_LOG.STRING(g_level_unexpected,
119: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.initialize',
120: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
121: END IF;
122: END Initialize;

Line 254: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

250: p_internal_organization_id IN NUMBER) IS
251:
252: BEGIN
253:
254: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
255:
256: IF (g_level_statement >= g_current_runtime_level ) THEN
257: FND_LOG.STRING(g_level_statement,
258: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',

Line 257: FND_LOG.STRING(g_level_statement,

253:
254: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
255:
256: IF (g_level_statement >= g_current_runtime_level ) THEN
257: FND_LOG.STRING(g_level_statement,
258: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
259:
260: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (+)');
261: END IF;

Line 298: FND_LOG.STRING(g_level_statement,

294: p_entity_code,
295: p_application_id,
296: p_internal_organization_id);
297: IF (g_level_statement >= g_current_runtime_level ) THEN
298: FND_LOG.STRING(g_level_statement,
299: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
300:
301: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (-)');
302: END IF;

Line 339: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

335: p_internal_organization_id IN NUMBER) IS
336:
337: BEGIN
338:
339: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
340:
341: IF (g_level_statement >= g_current_runtime_level ) THEN
342: FND_LOG.STRING(g_level_statement,
343: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',

Line 342: FND_LOG.STRING(g_level_statement,

338:
339: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
340:
341: IF (g_level_statement >= g_current_runtime_level ) THEN
342: FND_LOG.STRING(g_level_statement,
343: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
344:
345: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (+)');
346: FND_LOG.STRING(g_level_statement,

Line 346: FND_LOG.STRING(g_level_statement,

342: FND_LOG.STRING(g_level_statement,
343: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
344:
345: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (+)');
346: FND_LOG.STRING(g_level_statement,
347: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
348:
349: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: overloaded version 1');
350:

Line 388: FND_LOG.STRING(g_level_statement,

384: p_entity_code,
385: p_application_id,
386: p_internal_organization_id);
387: IF (g_level_statement >= g_current_runtime_level ) THEN
388: FND_LOG.STRING(g_level_statement,
389: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
390:
391: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (-)');
392: END IF;

Line 471: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

467: and enabled_flag = 'Y';
468:
469: BEGIN
470:
471: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
472:
473: IF (g_level_statement >= g_current_runtime_level ) THEN
474: FND_LOG.STRING(g_level_statement,
475: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',

Line 474: FND_LOG.STRING(g_level_statement,

470:
471: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
472:
473: IF (g_level_statement >= g_current_runtime_level ) THEN
474: FND_LOG.STRING(g_level_statement,
475: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
476: 'Get_Default_Tax_Classification(+) ');
477: -- FND_LOG.STRING(g_level_statement,
478: -- 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 477: -- FND_LOG.STRING(g_level_statement,

473: IF (g_level_statement >= g_current_runtime_level ) THEN
474: FND_LOG.STRING(g_level_statement,
475: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
476: 'Get_Default_Tax_Classification(+) ');
477: -- FND_LOG.STRING(g_level_statement,
478: -- 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
479: -- 'p_line_location_id == >'||to_char(p_line_location_id ));
480: FND_LOG.STRING(g_level_statement,
481: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 480: FND_LOG.STRING(g_level_statement,

476: 'Get_Default_Tax_Classification(+) ');
477: -- FND_LOG.STRING(g_level_statement,
478: -- 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
479: -- 'p_line_location_id == >'||to_char(p_line_location_id ));
480: FND_LOG.STRING(g_level_statement,
481: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
482: 'p_ref_doc_application_id == >'||TO_CHAR(p_ref_doc_application_id));
483: FND_LOG.STRING(g_level_statement,
484: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 483: FND_LOG.STRING(g_level_statement,

479: -- 'p_line_location_id == >'||to_char(p_line_location_id ));
480: FND_LOG.STRING(g_level_statement,
481: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
482: 'p_ref_doc_application_id == >'||TO_CHAR(p_ref_doc_application_id));
483: FND_LOG.STRING(g_level_statement,
484: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
485: 'p_ref_doc_entity_code == >'||p_ref_doc_entity_code);
486: FND_LOG.STRING(g_level_statement,
487: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 486: FND_LOG.STRING(g_level_statement,

482: 'p_ref_doc_application_id == >'||TO_CHAR(p_ref_doc_application_id));
483: FND_LOG.STRING(g_level_statement,
484: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
485: 'p_ref_doc_entity_code == >'||p_ref_doc_entity_code);
486: FND_LOG.STRING(g_level_statement,
487: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
488: 'p_ref_doc_event_class_code == >'||p_ref_doc_event_class_code);
489: FND_LOG.STRING(g_level_statement,
490: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 489: FND_LOG.STRING(g_level_statement,

485: 'p_ref_doc_entity_code == >'||p_ref_doc_entity_code);
486: FND_LOG.STRING(g_level_statement,
487: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
488: 'p_ref_doc_event_class_code == >'||p_ref_doc_event_class_code);
489: FND_LOG.STRING(g_level_statement,
490: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
491: 'p_ref_doc_trx_id == >'||TO_CHAR(p_ref_doc_trx_id));
492: FND_LOG.STRING(g_level_statement,
493: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 492: FND_LOG.STRING(g_level_statement,

488: 'p_ref_doc_event_class_code == >'||p_ref_doc_event_class_code);
489: FND_LOG.STRING(g_level_statement,
490: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
491: 'p_ref_doc_trx_id == >'||TO_CHAR(p_ref_doc_trx_id));
492: FND_LOG.STRING(g_level_statement,
493: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
494: 'p_ref_doc_line_id == >'||TO_CHAR(p_ref_doc_line_id));
495: FND_LOG.STRING(g_level_statement,
496: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 495: FND_LOG.STRING(g_level_statement,

491: 'p_ref_doc_trx_id == >'||TO_CHAR(p_ref_doc_trx_id));
492: FND_LOG.STRING(g_level_statement,
493: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
494: 'p_ref_doc_line_id == >'||TO_CHAR(p_ref_doc_line_id));
495: FND_LOG.STRING(g_level_statement,
496: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
497: 'p_ref_doc_trx_level_type == >'||p_ref_doc_trx_level_type);
498: FND_LOG.STRING(g_level_statement,
499: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 498: FND_LOG.STRING(g_level_statement,

494: 'p_ref_doc_line_id == >'||TO_CHAR(p_ref_doc_line_id));
495: FND_LOG.STRING(g_level_statement,
496: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
497: 'p_ref_doc_trx_level_type == >'||p_ref_doc_trx_level_type);
498: FND_LOG.STRING(g_level_statement,
499: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
500: 'p_vendor_id == >' ||to_char(p_vendor_id ));
501: FND_LOG.STRING(g_level_statement,
502: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 501: FND_LOG.STRING(g_level_statement,

497: 'p_ref_doc_trx_level_type == >'||p_ref_doc_trx_level_type);
498: FND_LOG.STRING(g_level_statement,
499: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
500: 'p_vendor_id == >' ||to_char(p_vendor_id ));
501: FND_LOG.STRING(g_level_statement,
502: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
503: 'p_vendor_site_id == >' ||to_char(p_vendor_site_id ));
504: FND_LOG.STRING(g_level_statement,
505: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 504: FND_LOG.STRING(g_level_statement,

500: 'p_vendor_id == >' ||to_char(p_vendor_id ));
501: FND_LOG.STRING(g_level_statement,
502: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
503: 'p_vendor_site_id == >' ||to_char(p_vendor_site_id ));
504: FND_LOG.STRING(g_level_statement,
505: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
506: 'p_code_combination_id = >'||to_char(p_code_combination_id) );
507: FND_LOG.STRING(g_level_statement,
508: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 507: FND_LOG.STRING(g_level_statement,

503: 'p_vendor_site_id == >' ||to_char(p_vendor_site_id ));
504: FND_LOG.STRING(g_level_statement,
505: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
506: 'p_code_combination_id = >'||to_char(p_code_combination_id) );
507: FND_LOG.STRING(g_level_statement,
508: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
509: 'p_concatenated_segments== >'||p_concatenated_segments );
510: FND_LOG.STRING(g_level_statement,
511: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 510: FND_LOG.STRING(g_level_statement,

506: 'p_code_combination_id = >'||to_char(p_code_combination_id) );
507: FND_LOG.STRING(g_level_statement,
508: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
509: 'p_concatenated_segments== >'||p_concatenated_segments );
510: FND_LOG.STRING(g_level_statement,
511: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
512: 'p_templ_tax_classification_cd == >'||
513: p_templ_tax_classification_cd);
514: FND_LOG.STRING(g_level_statement,

Line 514: FND_LOG.STRING(g_level_statement,

510: FND_LOG.STRING(g_level_statement,
511: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
512: 'p_templ_tax_classification_cd == >'||
513: p_templ_tax_classification_cd);
514: FND_LOG.STRING(g_level_statement,
515: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
516: 'p_ship_to_location_id == >'||to_char(p_ship_to_location_id) );
517: FND_LOG.STRING(g_level_statement,
518: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 517: FND_LOG.STRING(g_level_statement,

513: p_templ_tax_classification_cd);
514: FND_LOG.STRING(g_level_statement,
515: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
516: 'p_ship_to_location_id == >'||to_char(p_ship_to_location_id) );
517: FND_LOG.STRING(g_level_statement,
518: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
519: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id) );
520: FND_LOG.STRING(g_level_statement,
521: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 520: FND_LOG.STRING(g_level_statement,

516: 'p_ship_to_location_id == >'||to_char(p_ship_to_location_id) );
517: FND_LOG.STRING(g_level_statement,
518: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
519: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id) );
520: FND_LOG.STRING(g_level_statement,
521: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
522: 'p_inventory_item_id == >'||to_char(p_inventory_item_id) );
523: FND_LOG.STRING(g_level_statement,
524: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 523: FND_LOG.STRING(g_level_statement,

519: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id) );
520: FND_LOG.STRING(g_level_statement,
521: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
522: 'p_inventory_item_id == >'||to_char(p_inventory_item_id) );
523: FND_LOG.STRING(g_level_statement,
524: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
525: 'p_item_org_id == >' ||to_char( p_item_org_id));
526: FND_LOG.STRING(g_level_statement,
527: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 526: FND_LOG.STRING(g_level_statement,

522: 'p_inventory_item_id == >'||to_char(p_inventory_item_id) );
523: FND_LOG.STRING(g_level_statement,
524: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
525: 'p_item_org_id == >' ||to_char( p_item_org_id));
526: FND_LOG.STRING(g_level_statement,
527: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
528: 'p_tax_classification_code == >' ||p_tax_classification_code);
529: FND_LOG.STRING(g_level_statement,
530: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 529: FND_LOG.STRING(g_level_statement,

525: 'p_item_org_id == >' ||to_char( p_item_org_id));
526: FND_LOG.STRING(g_level_statement,
527: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
528: 'p_tax_classification_code == >' ||p_tax_classification_code);
529: FND_LOG.STRING(g_level_statement,
530: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
531: 'p_allow_tax_code_override_flag ==>'|| p_allow_tax_code_override_flag);
532: FND_LOG.STRING(g_level_statement,
533: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 532: FND_LOG.STRING(g_level_statement,

528: 'p_tax_classification_code == >' ||p_tax_classification_code);
529: FND_LOG.STRING(g_level_statement,
530: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
531: 'p_allow_tax_code_override_flag ==>'|| p_allow_tax_code_override_flag);
532: FND_LOG.STRING(g_level_statement,
533: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
534: 'p_tax_user_override_flag ==>'||p_tax_user_override_flag);
535: FND_LOG.STRING(g_level_statement,
536: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 535: FND_LOG.STRING(g_level_statement,

531: 'p_allow_tax_code_override_flag ==>'|| p_allow_tax_code_override_flag);
532: FND_LOG.STRING(g_level_statement,
533: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
534: 'p_tax_user_override_flag ==>'||p_tax_user_override_flag);
535: FND_LOG.STRING(g_level_statement,
536: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
537: 'p_user_tax_name ==>'||p_user_tax_name);
538: FND_LOG.STRING(g_level_statement,
539: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 538: FND_LOG.STRING(g_level_statement,

534: 'p_tax_user_override_flag ==>'||p_tax_user_override_flag);
535: FND_LOG.STRING(g_level_statement,
536: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
537: 'p_user_tax_name ==>'||p_user_tax_name);
538: FND_LOG.STRING(g_level_statement,
539: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
540: 'p_legal_entity_id ==>'||TO_CHAR(p_legal_entity_id));
541:
542: FND_LOG.STRING(g_level_statement,

Line 542: FND_LOG.STRING(g_level_statement,

538: FND_LOG.STRING(g_level_statement,
539: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
540: 'p_legal_entity_id ==>'||TO_CHAR(p_legal_entity_id));
541:
542: FND_LOG.STRING(g_level_statement,
543: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
544: 'APPL_SHORT_NAME == >'||APPL_SHORT_NAME );
545: FND_LOG.STRING(g_level_statement,
546: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 545: FND_LOG.STRING(g_level_statement,

541:
542: FND_LOG.STRING(g_level_statement,
543: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
544: 'APPL_SHORT_NAME == >'||APPL_SHORT_NAME );
545: FND_LOG.STRING(g_level_statement,
546: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
547: 'FUNC_SHORT_NAME == >'||FUNC_SHORT_NAME );
548: FND_LOG.STRING(g_level_statement,
549: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 548: FND_LOG.STRING(g_level_statement,

544: 'APPL_SHORT_NAME == >'||APPL_SHORT_NAME );
545: FND_LOG.STRING(g_level_statement,
546: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
547: 'FUNC_SHORT_NAME == >'||FUNC_SHORT_NAME );
548: FND_LOG.STRING(g_level_statement,
549: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
550: 'p_calling_sequence == >'||p_calling_sequence );
551: FND_LOG.STRING(g_level_statement,
552: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 551: FND_LOG.STRING(g_level_statement,

547: 'FUNC_SHORT_NAME == >'||FUNC_SHORT_NAME );
548: FND_LOG.STRING(g_level_statement,
549: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
550: 'p_calling_sequence == >'||p_calling_sequence );
551: FND_LOG.STRING(g_level_statement,
552: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
553: 'p_event_class_code == >'||p_event_class_code );
554: FND_LOG.STRING(g_level_statement,
555: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 554: FND_LOG.STRING(g_level_statement,

550: 'p_calling_sequence == >'||p_calling_sequence );
551: FND_LOG.STRING(g_level_statement,
552: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
553: 'p_event_class_code == >'||p_event_class_code );
554: FND_LOG.STRING(g_level_statement,
555: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
556: 'p_entity_code == >'||p_entity_code );
557: FND_LOG.STRING(g_level_statement,
558: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 557: FND_LOG.STRING(g_level_statement,

553: 'p_event_class_code == >'||p_event_class_code );
554: FND_LOG.STRING(g_level_statement,
555: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
556: 'p_entity_code == >'||p_entity_code );
557: FND_LOG.STRING(g_level_statement,
558: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
559: 'p_application_id == >'||TO_CHAR(p_application_id));
560: FND_LOG.STRING(g_level_statement,
561: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 560: FND_LOG.STRING(g_level_statement,

556: 'p_entity_code == >'||p_entity_code );
557: FND_LOG.STRING(g_level_statement,
558: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
559: 'p_application_id == >'||TO_CHAR(p_application_id));
560: FND_LOG.STRING(g_level_statement,
561: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
562: 'p_internal_organization_id == >'||TO_CHAR(p_internal_organization_id));
563:
564: END IF;

Line 684: FND_LOG.STRING(g_level_statement,

680: END IF;
681: END IF;
682:
683: IF (g_level_statement >= g_current_runtime_level ) THEN
684: FND_LOG.STRING(g_level_statement,
685: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
686: 'l_tax_classification_code is found =='||l_tax_classification_code);
687: END IF;
688:

Line 694: FND_LOG.STRING(g_level_statement,

690: IF (APPL_SHORT_NAME = 'SQLAP') THEN
691: IF (search_ap_def_hier = TRUE) THEN
692:
693: IF (g_level_statement >= g_current_runtime_level ) THEN
694: FND_LOG.STRING(g_level_statement,
695: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
696: 'Getting Event Class Options');
697: END IF;
698:

Line 710: FND_LOG.STRING(g_level_statement,

706: l_enforce_tax_from_refdoc_flag;
707: close c_evnt_cls_options;
708:
709: IF (g_level_statement >= g_current_runtime_level ) THEN
710: FND_LOG.STRING(g_level_statement,
711: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
712: 'Entity Code:' || p_entity_code);
713: FND_LOG.STRING(g_level_statement,
714: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 713: FND_LOG.STRING(g_level_statement,

709: IF (g_level_statement >= g_current_runtime_level ) THEN
710: FND_LOG.STRING(g_level_statement,
711: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
712: 'Entity Code:' || p_entity_code);
713: FND_LOG.STRING(g_level_statement,
714: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
715: 'Event Class Code:' || p_event_class_code);
716: FND_LOG.STRING(g_level_statement,
717: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 716: FND_LOG.STRING(g_level_statement,

712: 'Entity Code:' || p_entity_code);
713: FND_LOG.STRING(g_level_statement,
714: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
715: 'Event Class Code:' || p_event_class_code);
716: FND_LOG.STRING(g_level_statement,
717: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
718: 'Enforce Tax From Account =='
719: || l_enforce_tax_from_acct_flag);
720:

Line 721: FND_LOG.STRING(g_level_statement,

717: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
718: 'Enforce Tax From Account =='
719: || l_enforce_tax_from_acct_flag);
720:
721: FND_LOG.STRING(g_level_statement,
722: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
723: 'Getting tax code for AP ');
724: END IF;
725:

Line 733: FND_LOG.STRING(g_level_statement,

729: -- no need to search any further, as this takes
730: -- precedence over the rest of the hierarchy.
731:
732: IF (g_level_statement >= g_current_runtime_level ) THEN
733: FND_LOG.STRING(g_level_statement,
734: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
735: 'Matching is enforced');
736: END IF;
737:

Line 750: FND_LOG.STRING(g_level_statement,

746: from po_line_locations
747: where line_location_id = p_line_location_id ;
748:
749: IF (g_level_statement >= g_current_runtime_level ) THEN
750: FND_LOG.STRING(g_level_statement,
751: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
752: ' l_shipment_taxable_flag is ' || l_shipment_taxable_flag );
753: END IF;
754: If (l_shipment_taxable_flag = 'Y' ) then

Line 756: FND_LOG.STRING(g_level_statement,

752: ' l_shipment_taxable_flag is ' || l_shipment_taxable_flag );
753: END IF;
754: If (l_shipment_taxable_flag = 'Y' ) then
755: IF (g_level_statement >= g_current_runtime_level ) THEN
756: FND_LOG.STRING(g_level_statement,
757: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
758: 'Calling get_po_shipment tax ' );
759: END IF;
760: l_tax_classification_code := get_input_tax_classif_code (p_line_location_id,

Line 789: FND_LOG.STRING(g_level_statement,

785: IF (l_tax_classification_code is not NULL) THEN
786: -- Tax found on PO shipment, do not search further
787: l_enforced_tax_found := TRUE;
788: IF (g_level_statement >= g_current_runtime_level ) THEN
789: FND_LOG.STRING(g_level_statement,
790: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
791: 'l_tax_classification_code =='||l_tax_classification_code );
792: END IF;
793: END IF;

Line 803: FND_LOG.STRING(g_level_statement,

799: -- precedence over the rest of the tax defaulting hierarchy
800: -- This includes both Input and Non-taxable accounts.
801:
802: IF (g_level_statement >= g_current_runtime_level ) THEN
803: FND_LOG.STRING(g_level_statement,
804: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
805: 'Tax from account is enforced');
806: FND_LOG.STRING(g_level_statement,
807: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 806: FND_LOG.STRING(g_level_statement,

802: IF (g_level_statement >= g_current_runtime_level ) THEN
803: FND_LOG.STRING(g_level_statement,
804: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
805: 'Tax from account is enforced');
806: FND_LOG.STRING(g_level_statement,
807: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
808: ' Calling get_account_tax ');
809: END IF;
810: get_account_tax (p_code_combination_id,

Line 818: FND_LOG.STRING(g_level_statement,

814: l_tax_classification_found,
815: l_curr_calling_sequence);
816: l_tax_classification_code := p_tax_classification_code;
817: IF (g_level_statement >= g_current_runtime_level ) THEN
818: FND_LOG.STRING(g_level_statement,
819: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
820: 'l_tax_classification_code =='||l_tax_classification_code);
821: END IF;
822: IF (p_allow_tax_code_override_flag = 'N') THEN

Line 850: FND_LOG.STRING(g_level_statement,

846: -- aptaxtab (i) is not NULL
847:
848: IF (aptaxtab (i) = 'REFERENCE_DOCUMENT') THEN
849: IF (g_level_statement >= g_current_runtime_level ) THEN
850: FND_LOG.STRING(g_level_statement,
851: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
852: 'Getting tax code from shipment');
853: FND_LOG.STRING(g_level_statement,
854: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 853: FND_LOG.STRING(g_level_statement,

849: IF (g_level_statement >= g_current_runtime_level ) THEN
850: FND_LOG.STRING(g_level_statement,
851: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
852: 'Getting tax code from shipment');
853: FND_LOG.STRING(g_level_statement,
854: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
855: 'Calling get_input_tax_classif_code ');
856: END IF;
857: l_tax_classification_code := get_input_tax_classif_code (

Line 869: FND_LOG.STRING(g_level_statement,

865:
866: IF (l_tax_classification_code is not NULL) THEN
867: l_tax_classification_found := TRUE;
868: IF (g_level_statement >= g_current_runtime_level ) THEN
869: FND_LOG.STRING(g_level_statement,
870: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
871: 'l_tax_classification_code =='
872: ||l_tax_classification_code);
873: END IF;

Line 880: FND_LOG.STRING(g_level_statement,

876: END IF;
877:
878: IF (aptaxtab (i) = 'SHIP_FROM_PARTY_SITE') THEN
879: IF (g_level_statement >= g_current_runtime_level ) THEN
880: FND_LOG.STRING(g_level_statement,
881: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
882: 'Getting tax code from supplier site');
883: END IF;
884: l_tax_classification_code := get_site_tax (

Line 890: FND_LOG.STRING(g_level_statement,

886: l_curr_calling_sequence);
887: IF (l_tax_classification_code is not NULL) THEN
888: l_tax_classification_found := TRUE;
889: IF (g_level_statement >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_statement,
891: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
892: 'l_tax_classification_code =='
893: ||l_tax_classification_code);
894: END IF;

Line 901: FND_LOG.STRING(g_level_statement,

897: END IF;
898:
899: IF (aptaxtab (i) = 'SHIP_FROM_PARTY') THEN
900: IF (g_level_statement >= g_current_runtime_level ) THEN
901: FND_LOG.STRING(g_level_statement,
902: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
903: 'Getting tax code from supplier');
904: END IF;
905: l_tax_classification_code := get_vendor_tax (

Line 911: FND_LOG.STRING(g_level_statement,

907: l_curr_calling_sequence);
908: IF (l_tax_classification_code is not NULL) THEN
909: l_tax_classification_found := TRUE;
910: IF (g_level_statement >= g_current_runtime_level ) THEN
911: FND_LOG.STRING(g_level_statement,
912: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
913: 'l_tax_classification_code =='
914: ||l_tax_classification_code);
915: END IF;

Line 922: FND_LOG.STRING(g_level_statement,

918: END IF;
919:
920: IF (aptaxtab (i) = 'NATURAL_ACCOUNT') THEN
921: IF (g_level_statement >= g_current_runtime_level ) THEN
922: FND_LOG.STRING(g_level_statement,
923: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
924: 'Getting tax code from account');
925: END IF;
926: get_account_tax (p_code_combination_id,

Line 934: FND_LOG.STRING(g_level_statement,

930: l_tax_classification_found,
931: l_curr_calling_sequence);
932: l_tax_classification_code := p_tax_classification_code;
933: IF (g_level_statement >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_statement,
935: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
936: 'l_tax_classification_code =='
937: ||l_tax_classification_code);
938: END IF;

Line 941: FND_LOG.STRING(g_level_statement,

937: ||l_tax_classification_code);
938: END IF;
939: IF (l_tax_classification_found = TRUE) THEN
940: IF (g_level_statement >= g_current_runtime_level ) THEN
941: FND_LOG.STRING(g_level_statement,
942: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
943: 'l_tax_classification_code is Found =='
944: ||l_tax_classification_code);
945: END IF;

Line 952: FND_LOG.STRING(g_level_statement,

948: END IF;
949:
950: IF (aptaxtab (i) = 'FINANCIAL_OPTIONS') THEN
951: IF (g_level_statement >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_statement,
953: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
954: 'Getting tax code from financial system parameters');
955: FND_LOG.STRING(g_level_statement,
956: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 955: FND_LOG.STRING(g_level_statement,

951: IF (g_level_statement >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_statement,
953: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
954: 'Getting tax code from financial system parameters');
955: FND_LOG.STRING(g_level_statement,
956: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
957: 'sysinfo.vat_code =='
958: ||sysinfo.ap_info.tax_classification_code );
959: END IF;

Line 964: FND_LOG.STRING(g_level_statement,

960: l_tax_classification_code := sysinfo.ap_info.tax_classification_code;
961: IF (l_tax_classification_code is not NULL) THEN
962: l_tax_classification_found := TRUE;
963: IF (g_level_statement >= g_current_runtime_level ) THEN
964: FND_LOG.STRING(g_level_statement,
965: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
966: 'l_tax_classification_code =='
967: ||l_tax_classification_code);
968: END IF;

Line 975: FND_LOG.STRING(g_level_statement,

971: END IF;
972:
973: IF (aptaxtab (i) = 'TEMPLATE') THEN
974: IF (g_level_statement >= g_current_runtime_level ) THEN
975: FND_LOG.STRING(g_level_statement,
976: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
977: 'Getting tax code from template');
978: END IF;
979: -- If the API has been called from a form or process

Line 998: FND_LOG.STRING(g_level_statement,

994: func_short_name = 'AP_INSERT_FROM_DSET') THEN
995: l_tax_classification_code := p_templ_tax_classification_cd;
996: l_tax_classification_found := TRUE;
997: IF (g_level_statement >= g_current_runtime_level ) THEN
998: FND_LOG.STRING(g_level_statement,
999: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1000: 'l_tax_classification_code =='
1001: ||l_tax_classification_code);
1002: END IF;

Line 1015: FND_LOG.STRING(g_level_statement,

1011: -- APPL_SHORT_NAME is PO
1012: IF (search_po_def_hier = TRUE) THEN
1013:
1014: IF (g_level_statement >= g_current_runtime_level ) THEN
1015: FND_LOG.STRING(g_level_statement,
1016: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1017: 'Getting tax code for PO');
1018: END IF;
1019:

Line 1036: FND_LOG.STRING(g_level_statement,

1032: ELSE
1033: -- potaxtab (i) is not NULL
1034: IF (potaxtab (i) = 'SHIP_TO_LOCATION') THEN
1035: IF (g_level_statement >= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_statement,
1037: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1038: ' Calling get_ship_to_location_tax ');
1039: END IF;
1040:

Line 1049: FND_LOG.STRING(g_level_statement,

1045: l_curr_calling_sequence);
1046: IF (l_tax_classification_code is not NULL) THEN
1047: l_tax_classification_found := TRUE;
1048: IF (g_level_statement >= g_current_runtime_level ) THEN
1049: FND_LOG.STRING(g_level_statement,
1050: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1051: 'l_tax_classification_code =='
1052: ||l_tax_classification_code);
1053: END IF;

Line 1060: FND_LOG.STRING(g_level_statement,

1056: END IF;
1057:
1058: IF (potaxtab (i) = 'ITEM') THEN
1059: IF (g_level_statement >= g_current_runtime_level ) THEN
1060: FND_LOG.STRING(g_level_statement,
1061: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1062: 'Getting tax code from item');
1063: FND_LOG.STRING(g_level_statement,
1064: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1063: FND_LOG.STRING(g_level_statement,

1059: IF (g_level_statement >= g_current_runtime_level ) THEN
1060: FND_LOG.STRING(g_level_statement,
1061: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1062: 'Getting tax code from item');
1063: FND_LOG.STRING(g_level_statement,
1064: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1065: 'Calling get_item_tax ');
1066: END IF;
1067: l_tax_classification_code := get_item_tax (p_inventory_item_id,

Line 1084: FND_LOG.STRING(g_level_statement,

1080: --If the item's taxable flag is not set to 'Y',
1081: --the tax code defaulting PKG should not look further to the next hierarchy
1082: --even a null tax code is returned.
1083: IF (g_level_statement >= g_current_runtime_level ) THEN
1084: FND_LOG.STRING(g_level_statement,
1085: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1086: 'l_item_taxable_flag = ' || l_item_taxable_flag );
1087: END IF;
1088:

Line 1092: FND_LOG.STRING(g_level_statement,

1088:
1089: IF (l_item_taxable_flag = 'N' or l_tax_classification_code is not null) THEN
1090: l_tax_classification_found := TRUE;
1091: IF (g_level_statement >= g_current_runtime_level ) THEN
1092: FND_LOG.STRING(g_level_statement,
1093: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1094: 'l_tax_classification_code =='||l_tax_classification_code);
1095: END IF;
1096: exit Po_Tax_Loop;

Line 1102: FND_LOG.STRING(g_level_statement,

1098: END IF;
1099:
1100: IF (potaxtab (i) = 'SHIP_FROM_PARTY_SITE') THEN
1101: IF (g_level_statement >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_statement,
1103: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1104: 'Getting tax code from supplier site');
1105: FND_LOG.STRING(g_level_statement,
1106: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1105: FND_LOG.STRING(g_level_statement,

1101: IF (g_level_statement >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_statement,
1103: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1104: 'Getting tax code from supplier site');
1105: FND_LOG.STRING(g_level_statement,
1106: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1107: 'Calling get_site_tax ');
1108: END IF;
1109: l_tax_classification_code := get_site_tax (

Line 1115: FND_LOG.STRING(g_level_statement,

1111: l_curr_calling_sequence);
1112: IF (l_tax_classification_code is not NULL) THEN
1113: l_tax_classification_found := TRUE;
1114: IF (g_level_statement >= g_current_runtime_level ) THEN
1115: FND_LOG.STRING(g_level_statement,
1116: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1117: 'l_tax_classification_code =='||l_tax_classification_code);
1118: END IF;
1119: exit Po_Tax_Loop;

Line 1125: FND_LOG.STRING(g_level_statement,

1121: END IF;
1122:
1123: IF (potaxtab (i) = 'SHIP_FROM_PARTY') THEN
1124: IF (g_level_statement >= g_current_runtime_level ) THEN
1125: FND_LOG.STRING(g_level_statement,
1126: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1127: 'Getting tax code from supplier');
1128: FND_LOG.STRING(g_level_statement,
1129: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1128: FND_LOG.STRING(g_level_statement,

1124: IF (g_level_statement >= g_current_runtime_level ) THEN
1125: FND_LOG.STRING(g_level_statement,
1126: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1127: 'Getting tax code from supplier');
1128: FND_LOG.STRING(g_level_statement,
1129: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1130: 'Calling get_vendor_tax ');
1131: END IF;
1132: l_tax_classification_code := get_vendor_tax (

Line 1138: FND_LOG.STRING(g_level_statement,

1134: l_curr_calling_sequence);
1135: IF (l_tax_classification_code is not NULL) THEN
1136: l_tax_classification_found := TRUE;
1137: IF (g_level_statement >= g_current_runtime_level ) THEN
1138: FND_LOG.STRING(g_level_statement,
1139: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1140: 'l_tax_classification_code =='||l_tax_classification_code);
1141: END IF;
1142: exit Po_Tax_Loop;

Line 1148: FND_LOG.STRING(g_level_statement,

1144: END IF;
1145:
1146: IF (potaxtab (i) = 'FINANCIAL_OPTIONS') THEN
1147: IF (g_level_statement >= g_current_runtime_level ) THEN
1148: FND_LOG.STRING(g_level_statement,
1149: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1150: 'Getting tax code from financial system parameters');
1151: FND_LOG.STRING(g_level_statement,
1152: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1151: FND_LOG.STRING(g_level_statement,

1147: IF (g_level_statement >= g_current_runtime_level ) THEN
1148: FND_LOG.STRING(g_level_statement,
1149: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1150: 'Getting tax code from financial system parameters');
1151: FND_LOG.STRING(g_level_statement,
1152: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1153: 'sysinfo.po_info.tax_classification_code =='
1154: ||sysinfo.po_info.tax_classification_code);
1155: END IF;

Line 1160: FND_LOG.STRING(g_level_statement,

1156: l_tax_classification_code := sysinfo.po_info.tax_classification_code;
1157: IF (l_tax_classification_code is not NULL) THEN
1158: l_tax_classification_found := TRUE;
1159: IF (g_level_statement >= g_current_runtime_level ) THEN
1160: FND_LOG.STRING(g_level_statement,
1161: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1162: 'l_tax_classification_code =='||l_tax_classification_code);
1163: END IF;
1164: exit Po_Tax_Loop;

Line 1176: FND_LOG.STRING(g_level_statement,

1172:
1173: IF (search_cc_def_hier = TRUE) THEN
1174:
1175: IF (g_level_statement >= g_current_runtime_level ) THEN
1176: FND_LOG.STRING(g_level_statement,
1177: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1178: 'Getting tax code for CC');
1179: END IF;
1180:

Line 1197: FND_LOG.STRING(g_level_statement,

1193: ELSE
1194: -- cctaxtab (i) is not NULL
1195: IF (cctaxtab (i) = 'SHIP_FROM_PARTY_SITE') THEN
1196: IF (g_level_statement >= g_current_runtime_level ) THEN
1197: FND_LOG.STRING(g_level_statement,
1198: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1199: 'Getting tax code from supplier site');
1200: END IF;
1201: l_tax_classification_code := get_site_tax (

Line 1207: FND_LOG.STRING(g_level_statement,

1203: l_curr_calling_sequence);
1204: IF (l_tax_classification_code is not NULL) THEN
1205: l_tax_classification_found := TRUE;
1206: IF (g_level_statement >= g_current_runtime_level ) THEN
1207: FND_LOG.STRING(g_level_statement,
1208: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1209: 'l_tax_classification_code =='
1210: ||l_tax_classification_code);
1211: END IF;

Line 1218: FND_LOG.STRING(g_level_statement,

1214: END IF;
1215:
1216: IF (cctaxtab (i) = 'SHIP_FROM_PARTY') THEN
1217: IF (g_level_statement >= g_current_runtime_level ) THEN
1218: FND_LOG.STRING(g_level_statement,
1219: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1220: 'Getting tax code from supplier');
1221: END IF;
1222: l_tax_classification_code := get_vendor_tax (

Line 1228: FND_LOG.STRING(g_level_statement,

1224: l_curr_calling_sequence);
1225: IF (l_tax_classification_code is not NULL) THEN
1226: l_tax_classification_found := TRUE;
1227: IF (g_level_statement >= g_current_runtime_level ) THEN
1228: FND_LOG.STRING(g_level_statement,
1229: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1230: 'l_tax_classification_code =='
1231: ||l_tax_classification_code);
1232: END IF;

Line 1239: FND_LOG.STRING(g_level_statement,

1235: END IF;
1236:
1237: IF (cctaxtab (i) = 'FINANCIAL_OPTIONS') THEN
1238: IF (g_level_statement >= g_current_runtime_level ) THEN
1239: FND_LOG.STRING(g_level_statement,
1240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1241: 'Getting tax code from financial system parameters');
1242: FND_LOG.STRING(g_level_statement,
1243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1242: FND_LOG.STRING(g_level_statement,

1238: IF (g_level_statement >= g_current_runtime_level ) THEN
1239: FND_LOG.STRING(g_level_statement,
1240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1241: 'Getting tax code from financial system parameters');
1242: FND_LOG.STRING(g_level_statement,
1243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1244: 'sysinfo.vat_code =='
1245: ||sysinfo.cc_info.tax_classification_code );
1246: END IF;

Line 1251: FND_LOG.STRING(g_level_statement,

1247: l_tax_classification_code := sysinfo.cc_info.tax_classification_code;
1248: IF (l_tax_classification_code is not NULL) THEN
1249: l_tax_classification_found := TRUE;
1250: IF (g_level_statement >= g_current_runtime_level ) THEN
1251: FND_LOG.STRING(g_level_statement,
1252: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1253: 'l_tax_classification_code =='
1254: ||l_tax_classification_code);
1255: END IF;

Line 1267: FND_LOG.STRING(g_level_statement,

1263: END IF; -- appl_short_name
1264: END IF; -- tax_code_found
1265:
1266: IF (g_level_statement >= g_current_runtime_level ) THEN
1267: FND_LOG.STRING(g_level_statement,
1268: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1269: 'After Po_Tax_Loop ,l_tax_classification_code =='
1270: ||l_tax_classification_code);
1271: END IF;

Line 1275: FND_LOG.STRING(g_level_statement,

1271: END IF;
1272:
1273: IF (nvl (p_tax_user_override_flag, 'N') <> 'Y') THEN
1274: IF (g_level_statement >= g_current_runtime_level ) THEN
1275: FND_LOG.STRING(g_level_statement,
1276: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1277: 'p_tax_user_override_flag =='||p_tax_user_override_flag);
1278: FND_LOG.STRING(g_level_statement,
1279: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1278: FND_LOG.STRING(g_level_statement,

1274: IF (g_level_statement >= g_current_runtime_level ) THEN
1275: FND_LOG.STRING(g_level_statement,
1276: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1277: 'p_tax_user_override_flag =='||p_tax_user_override_flag);
1278: FND_LOG.STRING(g_level_statement,
1279: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1280: 'l_tax_classification_code =='||l_tax_classification_code);
1281: END IF;
1282: IF (l_tax_classification_code is not null) THEN

Line 1287: FND_LOG.STRING(g_level_statement,

1283: p_tax_classification_code := l_tax_classification_code;
1284: END IF;
1285: END IF;
1286: IF (g_level_statement >= g_current_runtime_level ) THEN
1287: FND_LOG.STRING(g_level_statement,
1288: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1289: 'p_tax_classification_code =='||p_tax_classification_code);
1290: FND_LOG.STRING(g_level_statement,
1291: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',

Line 1290: FND_LOG.STRING(g_level_statement,

1286: IF (g_level_statement >= g_current_runtime_level ) THEN
1287: FND_LOG.STRING(g_level_statement,
1288: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1289: 'p_tax_classification_code =='||p_tax_classification_code);
1290: FND_LOG.STRING(g_level_statement,
1291: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1292: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (-)');
1293: END IF;
1294:

Line 1298: FND_LOG.STRING(g_level_unexpected,

1294:
1295: EXCEPTION
1296: WHEN NO_DATA_FOUND THEN
1297: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1298: FND_LOG.STRING(g_level_unexpected,
1299: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1300: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
1301: END IF;
1302: IF (l_tax_classification_found = FALSE ) THEN

Line 1308: FND_LOG.STRING(g_level_unexpected,

1304: END IF;
1305: WHEN OTHERS THEN
1306: IF (SQLCODE <> -20001) THEN
1307: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1308: FND_LOG.STRING(g_level_unexpected,
1309: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1310: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
1311: END IF;
1312: IF (appl_short_name = 'SQLAP') THEN

Line 1415: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1411: p_internal_organization_id IN NUMBER) IS
1412:
1413: BEGIN
1414:
1415: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1416:
1417: IF (g_level_statement >= g_current_runtime_level ) THEN
1418: FND_LOG.STRING(g_level_statement,
1419: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',

Line 1418: FND_LOG.STRING(g_level_statement,

1414:
1415: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1416:
1417: IF (g_level_statement >= g_current_runtime_level ) THEN
1418: FND_LOG.STRING(g_level_statement,
1419: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
1420:
1421: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (+)');
1422: FND_LOG.STRING(g_level_statement,

Line 1422: FND_LOG.STRING(g_level_statement,

1418: FND_LOG.STRING(g_level_statement,
1419: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
1420:
1421: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (+)');
1422: FND_LOG.STRING(g_level_statement,
1423: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1424:
1425: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: overloaded version 2');
1426:

Line 1462: FND_LOG.STRING(g_level_statement,

1458: p_entity_code,
1459: p_application_id,
1460: p_internal_organization_id);
1461: IF (g_level_statement >= g_current_runtime_level ) THEN
1462: FND_LOG.STRING(g_level_statement,
1463: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1464:
1465: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification (-)');
1466: END IF;

Line 1545: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1541: AND trx_level_type = c_ref_doc_trx_level_type;
1542:
1543: BEGIN
1544:
1545: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1546:
1547: IF (g_level_statement >= g_current_runtime_level ) THEN
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code.BEGIN',

Line 1548: FND_LOG.STRING(g_level_statement,

1544:
1545: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1546:
1547: IF (g_level_statement >= g_current_runtime_level ) THEN
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code.BEGIN',
1550: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_input_tax_classif_code (+)');
1551: FND_LOG.STRING(g_level_statement,
1552: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code',

Line 1551: FND_LOG.STRING(g_level_statement,

1547: IF (g_level_statement >= g_current_runtime_level ) THEN
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code.BEGIN',
1550: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_input_tax_classif_code (+)');
1551: FND_LOG.STRING(g_level_statement,
1552: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code',
1553:
1554: 'p_calling_sequence == >'||p_calling_sequence);
1555: END IF;

Line 1573: FND_LOG.STRING(g_level_statement,

1569: FETCH sel_input_tax_cls_cd INTO l_tax_classification_code;
1570: CLOSE sel_input_tax_cls_cd;
1571:
1572: IF (g_level_statement >= g_current_runtime_level ) THEN
1573: FND_LOG.STRING(g_level_statement,
1574: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code',
1575:
1576: 'l_tax_classification_code =='||l_tax_classification_code);
1577: FND_LOG.STRING(g_level_statement,

Line 1577: FND_LOG.STRING(g_level_statement,

1573: FND_LOG.STRING(g_level_statement,
1574: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code',
1575:
1576: 'l_tax_classification_code =='||l_tax_classification_code);
1577: FND_LOG.STRING(g_level_statement,
1578: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code.END',
1579: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_input_tax_classif_code (-)');
1580: END IF;
1581:

Line 1591: FND_LOG.STRING(g_level_unexpected,

1587: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'get_input_tax_classif_code- '||
1588: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1589: FND_MSG_PUB.Add;
1590: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1591: FND_LOG.STRING(g_level_unexpected,
1592: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_input_tax_classif_code',
1593: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1594: END IF;
1595: IF (sel_input_tax_cls_cd%ISOPEN ) THEN

Line 1660: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1656: AND tc.org_id in (sysinfo.org_id,-99);
1657:
1658: BEGIN
1659:
1660: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1661:
1662: IF (g_level_statement >= g_current_runtime_level ) THEN
1663: FND_LOG.STRING(g_level_statement,
1664: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.BEGIN',

Line 1663: FND_LOG.STRING(g_level_statement,

1659:
1660: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1661:
1662: IF (g_level_statement >= g_current_runtime_level ) THEN
1663: FND_LOG.STRING(g_level_statement,
1664: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.BEGIN',
1665: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_site_tax (+)');
1666: FND_LOG.STRING(g_level_statement,
1667: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',

Line 1666: FND_LOG.STRING(g_level_statement,

1662: IF (g_level_statement >= g_current_runtime_level ) THEN
1663: FND_LOG.STRING(g_level_statement,
1664: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.BEGIN',
1665: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_site_tax (+)');
1666: FND_LOG.STRING(g_level_statement,
1667: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1668: 'p_vendor_site_id == >'||to_char(p_vendor_site_id));
1669: FND_LOG.STRING(g_level_statement,
1670: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',

Line 1669: FND_LOG.STRING(g_level_statement,

1665: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_site_tax (+)');
1666: FND_LOG.STRING(g_level_statement,
1667: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1668: 'p_vendor_site_id == >'||to_char(p_vendor_site_id));
1669: FND_LOG.STRING(g_level_statement,
1670: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1671: 'p_calling_sequence == >'||p_calling_sequence);
1672: END IF;
1673: debug_loc := 'Get_Site_Tax';

Line 1676: FND_LOG.STRING(g_level_statement,

1672: END IF;
1673: debug_loc := 'Get_Site_Tax';
1674: l_curr_calling_sequence := 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG.'||debug_loc||'<-'||p_calling_sequence;
1675: IF (g_level_statement >= g_current_runtime_level ) THEN
1676: FND_LOG.STRING(g_level_statement,
1677: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1678: 'p_calling_sequence =='||p_calling_sequence);
1679: END IF;
1680:

Line 1717: FND_LOG.STRING(g_level_statement,

1713: CLOSE sel_site_tax_ptp;
1714: END IF;
1715:
1716: IF (g_level_statement >= g_current_runtime_level ) THEN
1717: FND_LOG.STRING(g_level_statement,
1718: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.G
1719: et_Vendor_Tax',
1720: 'l_party_site_id == >'||to_char(l_party_site_id));
1721: FND_LOG.STRING(g_level_statement,

Line 1721: FND_LOG.STRING(g_level_statement,

1717: FND_LOG.STRING(g_level_statement,
1718: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.G
1719: et_Vendor_Tax',
1720: 'l_party_site_id == >'||to_char(l_party_site_id));
1721: FND_LOG.STRING(g_level_statement,
1722: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1723: 'l_tax_classification_code =='||l_tax_classification_code);
1724: FND_LOG.STRING(g_level_statement,
1725: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.END',

Line 1724: FND_LOG.STRING(g_level_statement,

1720: 'l_party_site_id == >'||to_char(l_party_site_id));
1721: FND_LOG.STRING(g_level_statement,
1722: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1723: 'l_tax_classification_code =='||l_tax_classification_code);
1724: FND_LOG.STRING(g_level_statement,
1725: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.END',
1726: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_site_tax (-)');
1727: END IF;
1728:

Line 1738: FND_LOG.STRING(g_level_unexpected,

1734: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_site_tax- '||
1735: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1736: FND_MSG_PUB.Add;
1737: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1738: FND_LOG.STRING(g_level_unexpected,
1739: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1740: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1741: END IF;
1742: IF (sel_site_tax_sup_site%ISOPEN ) THEN

Line 1810: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1806: AND nvl(tc.enabled_flag,'Y') = 'Y'
1807: AND tc.org_id in (sysinfo.org_id,-99);
1808:
1809: BEGIN
1810: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1811:
1812: IF (g_level_statement >= g_current_runtime_level ) THEN
1813: FND_LOG.STRING(g_level_statement,
1814: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_vendor_tax.BEGIN',

Line 1813: FND_LOG.STRING(g_level_statement,

1809: BEGIN
1810: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1811:
1812: IF (g_level_statement >= g_current_runtime_level ) THEN
1813: FND_LOG.STRING(g_level_statement,
1814: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_vendor_tax.BEGIN',
1815: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Vendor_Tax (+)');
1816: FND_LOG.STRING(g_level_statement,
1817: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',

Line 1816: FND_LOG.STRING(g_level_statement,

1812: IF (g_level_statement >= g_current_runtime_level ) THEN
1813: FND_LOG.STRING(g_level_statement,
1814: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_vendor_tax.BEGIN',
1815: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Vendor_Tax (+)');
1816: FND_LOG.STRING(g_level_statement,
1817: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1818: 'p_vendor_id == >'||to_char(p_vendor_id));
1819: FND_LOG.STRING(g_level_statement,
1820: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',

Line 1819: FND_LOG.STRING(g_level_statement,

1815: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Vendor_Tax (+)');
1816: FND_LOG.STRING(g_level_statement,
1817: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1818: 'p_vendor_id == >'||to_char(p_vendor_id));
1819: FND_LOG.STRING(g_level_statement,
1820: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1821: 'p_calling_sequence == >'||p_calling_sequence);
1822: END IF;
1823: debug_loc := 'Get_Vendor_Tax';

Line 1826: FND_LOG.STRING(g_level_statement,

1822: END IF;
1823: debug_loc := 'Get_Vendor_Tax';
1824: l_curr_calling_sequence := 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG.'||debug_loc||'<-'||p_calling_sequence;
1825: IF (g_level_statement >= g_current_runtime_level ) THEN
1826: FND_LOG.STRING(g_level_statement,
1827: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1828: 'l_curr_calling_sequence =='||l_curr_calling_sequence );
1829: END IF;
1830:

Line 1867: FND_LOG.STRING(g_level_statement,

1863: CLOSE sel_vendor_tax_ptp;
1864: END IF;
1865:
1866: IF (g_level_statement >= g_current_runtime_level ) THEN
1867: FND_LOG.STRING(g_level_statement,
1868: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1869: 'l_party_id == >'||to_char(l_party_id));
1870: FND_LOG.STRING(g_level_statement,
1871: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',

Line 1870: FND_LOG.STRING(g_level_statement,

1866: IF (g_level_statement >= g_current_runtime_level ) THEN
1867: FND_LOG.STRING(g_level_statement,
1868: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1869: 'l_party_id == >'||to_char(l_party_id));
1870: FND_LOG.STRING(g_level_statement,
1871: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1872: 'From get_vendor_tax ,l_tax_classification_code =='
1873: ||l_tax_classification_code);
1874: FND_LOG.STRING(g_level_statement,

Line 1874: FND_LOG.STRING(g_level_statement,

1870: FND_LOG.STRING(g_level_statement,
1871: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1872: 'From get_vendor_tax ,l_tax_classification_code =='
1873: ||l_tax_classification_code);
1874: FND_LOG.STRING(g_level_statement,
1875: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax.END',
1876: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Vendor_Tax (-)');
1877: END IF;
1878:

Line 1888: FND_LOG.STRING(g_level_unexpected,

1884: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Vendor_Tax- '||
1885: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1886: FND_MSG_PUB.Add;
1887: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1888: FND_LOG.STRING(g_level_unexpected,
1889: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Vendor_Tax',
1890: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1891: END IF;
1892: IF (sel_vendor_tax_sup%ISOPEN) THEN

Line 1976: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1972: AND tc.org_id in (sysinfo.org_id,-99);
1973:
1974: BEGIN
1975:
1976: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1977:
1978: IF (g_level_statement >= g_current_runtime_level ) THEN
1979: FND_LOG.STRING(g_level_statement,
1980: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.BEGIN',

Line 1979: FND_LOG.STRING(g_level_statement,

1975:
1976: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1977:
1978: IF (g_level_statement >= g_current_runtime_level ) THEN
1979: FND_LOG.STRING(g_level_statement,
1980: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.BEGIN',
1981: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Ship_To_Location_Tax (+)');
1982: END IF;
1983: debug_loc := 'Get_Ship_To_Location_Tax';

Line 1986: FND_LOG.STRING(g_level_statement,

1982: END IF;
1983: debug_loc := 'Get_Ship_To_Location_Tax';
1984: l_curr_calling_sequence := 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG.'||debug_loc||'<-'||p_calling_sequence;
1985: IF (g_level_statement >= g_current_runtime_level ) THEN
1986: FND_LOG.STRING(g_level_statement,
1987: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
1988: 'Getting tax classification code from ship-to location');
1989: FND_LOG.STRING(g_level_statement,
1990: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',

Line 1989: FND_LOG.STRING(g_level_statement,

1985: IF (g_level_statement >= g_current_runtime_level ) THEN
1986: FND_LOG.STRING(g_level_statement,
1987: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
1988: 'Getting tax classification code from ship-to location');
1989: FND_LOG.STRING(g_level_statement,
1990: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
1991: 'p_ship_to_loc_id == > '||to_char(p_ship_to_loc_id ));
1992: FND_LOG.STRING(g_level_statement,
1993: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',

Line 1992: FND_LOG.STRING(g_level_statement,

1988: 'Getting tax classification code from ship-to location');
1989: FND_LOG.STRING(g_level_statement,
1990: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
1991: 'p_ship_to_loc_id == > '||to_char(p_ship_to_loc_id ));
1992: FND_LOG.STRING(g_level_statement,
1993: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
1994: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id ));
1995: FND_LOG.STRING(g_level_statement,
1996: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',

Line 1995: FND_LOG.STRING(g_level_statement,

1991: 'p_ship_to_loc_id == > '||to_char(p_ship_to_loc_id ));
1992: FND_LOG.STRING(g_level_statement,
1993: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
1994: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id ));
1995: FND_LOG.STRING(g_level_statement,
1996: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
1997: 'p_calling_sequence == > '|| p_calling_sequence );
1998: END IF;
1999:

Line 2018: FND_LOG.STRING(g_level_statement,

2014: p_ptp_id => l_ptp_id, -- ptp id
2015: p_return_status => l_return_status);
2016:
2017: IF (g_level_statement >= g_current_runtime_level ) THEN
2018: FND_LOG.STRING(g_level_statement,
2019: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
2020: 'l_ptp_id = ' || TO_CHAR(l_ptp_id));
2021: FND_LOG.STRING(g_level_statement,
2022: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',

Line 2021: FND_LOG.STRING(g_level_statement,

2017: IF (g_level_statement >= g_current_runtime_level ) THEN
2018: FND_LOG.STRING(g_level_statement,
2019: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
2020: 'l_ptp_id = ' || TO_CHAR(l_ptp_id));
2021: FND_LOG.STRING(g_level_statement,
2022: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
2023: 'l_return_status = ' || l_return_status);
2024: END IF;
2025:

Line 2042: FND_LOG.STRING(g_level_statement,

2038: CLOSE get_ship_to_tax;
2039: END IF;
2040:
2041: IF (g_level_statement >= g_current_runtime_level ) THEN
2042: FND_LOG.STRING(g_level_statement,
2043: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
2044: 'l_tax_classification_code =='||l_tax_classification_code );
2045: FND_LOG.STRING(g_level_statement,
2046: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.END',

Line 2045: FND_LOG.STRING(g_level_statement,

2041: IF (g_level_statement >= g_current_runtime_level ) THEN
2042: FND_LOG.STRING(g_level_statement,
2043: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
2044: 'l_tax_classification_code =='||l_tax_classification_code );
2045: FND_LOG.STRING(g_level_statement,
2046: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.END',
2047: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Ship_To_Location_Tax (-)');
2048: END IF;
2049:

Line 2059: FND_LOG.STRING(g_level_unexpected,

2055: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Ship_To_Location_Tax- '||
2056: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2057: FND_MSG_PUB.Add;
2058: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2059: FND_LOG.STRING(g_level_unexpected,
2060: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_ship_to_location_tax',
2061: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2062: END IF;
2063: IF (sel_ship_to_loc_tax%ISOPEN) THEN

Line 2086: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2082: l_tax_classification_code VARCHAR2(30);
2083:
2084: BEGIN
2085:
2086: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2087:
2088: IF (g_level_statement >= g_current_runtime_level ) THEN
2089: FND_LOG.STRING(g_level_statement,
2090: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.BEGIN',

Line 2089: FND_LOG.STRING(g_level_statement,

2085:
2086: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2087:
2088: IF (g_level_statement >= g_current_runtime_level ) THEN
2089: FND_LOG.STRING(g_level_statement,
2090: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.BEGIN',
2091: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Ship_To_Location_Tax (+)');
2092: FND_LOG.STRING(g_level_statement,
2093: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',

Line 2092: FND_LOG.STRING(g_level_statement,

2088: IF (g_level_statement >= g_current_runtime_level ) THEN
2089: FND_LOG.STRING(g_level_statement,
2090: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.BEGIN',
2091: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Ship_To_Location_Tax (+)');
2092: FND_LOG.STRING(g_level_statement,
2093: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax',
2094: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Ship_To_Location_Tax overloaded version');
2095:
2096: END IF;

Line 2108: FND_LOG.STRING(g_level_statement,

2104: p_calling_sequence);
2105:
2106:
2107: IF (g_level_statement >= g_current_runtime_level ) THEN
2108: FND_LOG.STRING(g_level_statement,
2109: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Ship_To_Location_Tax.END',
2110: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Ship_To_Location_Tax (-)');
2111: END IF;
2112:

Line 2194: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2190: and enabled_flag = 'Y';
2191:
2192: BEGIN
2193:
2194: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2195:
2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc.BEGIN',

Line 2197: FND_LOG.STRING(g_level_statement,

2193:
2194: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2195:
2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc.BEGIN',
2199: 'get_def_tax_classif_from_acc(+) ');
2200: FND_LOG.STRING(g_level_statement,
2201: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2200: FND_LOG.STRING(g_level_statement,

2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc.BEGIN',
2199: 'get_def_tax_classif_from_acc(+) ');
2200: FND_LOG.STRING(g_level_statement,
2201: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2202: 'p_ref_doc_application_id == >'||TO_CHAR(p_ref_doc_application_id));
2203: FND_LOG.STRING(g_level_statement,
2204: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2203: FND_LOG.STRING(g_level_statement,

2199: 'get_def_tax_classif_from_acc(+) ');
2200: FND_LOG.STRING(g_level_statement,
2201: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2202: 'p_ref_doc_application_id == >'||TO_CHAR(p_ref_doc_application_id));
2203: FND_LOG.STRING(g_level_statement,
2204: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2205: 'p_ref_doc_entity_code == >'||p_ref_doc_entity_code);
2206: FND_LOG.STRING(g_level_statement,
2207: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2206: FND_LOG.STRING(g_level_statement,

2202: 'p_ref_doc_application_id == >'||TO_CHAR(p_ref_doc_application_id));
2203: FND_LOG.STRING(g_level_statement,
2204: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2205: 'p_ref_doc_entity_code == >'||p_ref_doc_entity_code);
2206: FND_LOG.STRING(g_level_statement,
2207: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2208: 'p_ref_doc_event_class_code == >'||p_ref_doc_event_class_code);
2209: FND_LOG.STRING(g_level_statement,
2210: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2209: FND_LOG.STRING(g_level_statement,

2205: 'p_ref_doc_entity_code == >'||p_ref_doc_entity_code);
2206: FND_LOG.STRING(g_level_statement,
2207: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2208: 'p_ref_doc_event_class_code == >'||p_ref_doc_event_class_code);
2209: FND_LOG.STRING(g_level_statement,
2210: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2211: 'p_ref_doc_trx_id == >'||TO_CHAR(p_ref_doc_trx_id));
2212: FND_LOG.STRING(g_level_statement,
2213: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2212: FND_LOG.STRING(g_level_statement,

2208: 'p_ref_doc_event_class_code == >'||p_ref_doc_event_class_code);
2209: FND_LOG.STRING(g_level_statement,
2210: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2211: 'p_ref_doc_trx_id == >'||TO_CHAR(p_ref_doc_trx_id));
2212: FND_LOG.STRING(g_level_statement,
2213: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2214: 'p_ref_doc_line_id == >'||TO_CHAR(p_ref_doc_line_id));
2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2215: FND_LOG.STRING(g_level_statement,

2211: 'p_ref_doc_trx_id == >'||TO_CHAR(p_ref_doc_trx_id));
2212: FND_LOG.STRING(g_level_statement,
2213: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2214: 'p_ref_doc_line_id == >'||TO_CHAR(p_ref_doc_line_id));
2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2217: 'p_ref_doc_trx_level_type == >'||p_ref_doc_trx_level_type);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2218: FND_LOG.STRING(g_level_statement,

2214: 'p_ref_doc_line_id == >'||TO_CHAR(p_ref_doc_line_id));
2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2217: 'p_ref_doc_trx_level_type == >'||p_ref_doc_trx_level_type);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2220: 'p_vendor_id == >' ||to_char(p_vendor_id ));
2221: FND_LOG.STRING(g_level_statement,
2222: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2221: FND_LOG.STRING(g_level_statement,

2217: 'p_ref_doc_trx_level_type == >'||p_ref_doc_trx_level_type);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2220: 'p_vendor_id == >' ||to_char(p_vendor_id ));
2221: FND_LOG.STRING(g_level_statement,
2222: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2223: 'p_vendor_site_id == >' ||to_char(p_vendor_site_id ));
2224: FND_LOG.STRING(g_level_statement,
2225: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2224: FND_LOG.STRING(g_level_statement,

2220: 'p_vendor_id == >' ||to_char(p_vendor_id ));
2221: FND_LOG.STRING(g_level_statement,
2222: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2223: 'p_vendor_site_id == >' ||to_char(p_vendor_site_id ));
2224: FND_LOG.STRING(g_level_statement,
2225: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2226: 'p_code_combination_id = >'||to_char(p_code_combination_id) );
2227: FND_LOG.STRING(g_level_statement,
2228: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2227: FND_LOG.STRING(g_level_statement,

2223: 'p_vendor_site_id == >' ||to_char(p_vendor_site_id ));
2224: FND_LOG.STRING(g_level_statement,
2225: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2226: 'p_code_combination_id = >'||to_char(p_code_combination_id) );
2227: FND_LOG.STRING(g_level_statement,
2228: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2229: 'p_concatenated_segments== >'||p_concatenated_segments );
2230: FND_LOG.STRING(g_level_statement,
2231: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2230: FND_LOG.STRING(g_level_statement,

2226: 'p_code_combination_id = >'||to_char(p_code_combination_id) );
2227: FND_LOG.STRING(g_level_statement,
2228: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2229: 'p_concatenated_segments== >'||p_concatenated_segments );
2230: FND_LOG.STRING(g_level_statement,
2231: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2232: 'p_templ_tax_classification_cd == >'||p_templ_tax_classification_cd);
2233: FND_LOG.STRING(g_level_statement,
2234: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2233: FND_LOG.STRING(g_level_statement,

2229: 'p_concatenated_segments== >'||p_concatenated_segments );
2230: FND_LOG.STRING(g_level_statement,
2231: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2232: 'p_templ_tax_classification_cd == >'||p_templ_tax_classification_cd);
2233: FND_LOG.STRING(g_level_statement,
2234: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2235: 'p_ship_to_location_id == >'||to_char(p_ship_to_location_id) );
2236: FND_LOG.STRING(g_level_statement,
2237: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2236: FND_LOG.STRING(g_level_statement,

2232: 'p_templ_tax_classification_cd == >'||p_templ_tax_classification_cd);
2233: FND_LOG.STRING(g_level_statement,
2234: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2235: 'p_ship_to_location_id == >'||to_char(p_ship_to_location_id) );
2236: FND_LOG.STRING(g_level_statement,
2237: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2238: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id) );
2239: FND_LOG.STRING(g_level_statement,
2240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2239: FND_LOG.STRING(g_level_statement,

2235: 'p_ship_to_location_id == >'||to_char(p_ship_to_location_id) );
2236: FND_LOG.STRING(g_level_statement,
2237: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2238: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id) );
2239: FND_LOG.STRING(g_level_statement,
2240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2241: 'p_inventory_item_id == >'||to_char(p_inventory_item_id) );
2242: FND_LOG.STRING(g_level_statement,
2243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2242: FND_LOG.STRING(g_level_statement,

2238: 'p_ship_to_loc_org_id == >'||to_char(p_ship_to_loc_org_id) );
2239: FND_LOG.STRING(g_level_statement,
2240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2241: 'p_inventory_item_id == >'||to_char(p_inventory_item_id) );
2242: FND_LOG.STRING(g_level_statement,
2243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2244: 'p_item_org_id == >' ||to_char( p_item_org_id));
2245: FND_LOG.STRING(g_level_statement,
2246: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2245: FND_LOG.STRING(g_level_statement,

2241: 'p_inventory_item_id == >'||to_char(p_inventory_item_id) );
2242: FND_LOG.STRING(g_level_statement,
2243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2244: 'p_item_org_id == >' ||to_char( p_item_org_id));
2245: FND_LOG.STRING(g_level_statement,
2246: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2247: 'p_tax_classification_code == >' ||p_tax_classification_code);
2248: FND_LOG.STRING(g_level_statement,
2249: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2248: FND_LOG.STRING(g_level_statement,

2244: 'p_item_org_id == >' ||to_char( p_item_org_id));
2245: FND_LOG.STRING(g_level_statement,
2246: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2247: 'p_tax_classification_code == >' ||p_tax_classification_code);
2248: FND_LOG.STRING(g_level_statement,
2249: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2250: 'p_allow_tax_code_override_flag ==>'|| p_allow_tax_code_override_flag);
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2251: FND_LOG.STRING(g_level_statement,

2247: 'p_tax_classification_code == >' ||p_tax_classification_code);
2248: FND_LOG.STRING(g_level_statement,
2249: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2250: 'p_allow_tax_code_override_flag ==>'|| p_allow_tax_code_override_flag);
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2253: 'p_tax_user_override_flag ==>'||p_tax_user_override_flag);
2254: FND_LOG.STRING(g_level_statement,
2255: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2254: FND_LOG.STRING(g_level_statement,

2250: 'p_allow_tax_code_override_flag ==>'|| p_allow_tax_code_override_flag);
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2253: 'p_tax_user_override_flag ==>'||p_tax_user_override_flag);
2254: FND_LOG.STRING(g_level_statement,
2255: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2256: 'p_user_tax_name ==>'||p_user_tax_name);
2257: FND_LOG.STRING(g_level_statement,
2258: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2257: FND_LOG.STRING(g_level_statement,

2253: 'p_tax_user_override_flag ==>'||p_tax_user_override_flag);
2254: FND_LOG.STRING(g_level_statement,
2255: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2256: 'p_user_tax_name ==>'||p_user_tax_name);
2257: FND_LOG.STRING(g_level_statement,
2258: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2259: 'p_legal_entity_id ==>'||TO_CHAR(p_legal_entity_id));
2260: FND_LOG.STRING(g_level_statement,
2261: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2260: FND_LOG.STRING(g_level_statement,

2256: 'p_user_tax_name ==>'||p_user_tax_name);
2257: FND_LOG.STRING(g_level_statement,
2258: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2259: 'p_legal_entity_id ==>'||TO_CHAR(p_legal_entity_id));
2260: FND_LOG.STRING(g_level_statement,
2261: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2262: 'APPL_SHORT_NAME == >'||APPL_SHORT_NAME );
2263: FND_LOG.STRING(g_level_statement,
2264: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2263: FND_LOG.STRING(g_level_statement,

2259: 'p_legal_entity_id ==>'||TO_CHAR(p_legal_entity_id));
2260: FND_LOG.STRING(g_level_statement,
2261: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2262: 'APPL_SHORT_NAME == >'||APPL_SHORT_NAME );
2263: FND_LOG.STRING(g_level_statement,
2264: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2265: 'FUNC_SHORT_NAME == >'||FUNC_SHORT_NAME );
2266: FND_LOG.STRING(g_level_statement,
2267: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2266: FND_LOG.STRING(g_level_statement,

2262: 'APPL_SHORT_NAME == >'||APPL_SHORT_NAME );
2263: FND_LOG.STRING(g_level_statement,
2264: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2265: 'FUNC_SHORT_NAME == >'||FUNC_SHORT_NAME );
2266: FND_LOG.STRING(g_level_statement,
2267: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2268: 'p_calling_sequence == >'||p_calling_sequence );
2269: FND_LOG.STRING(g_level_statement,
2270: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2269: FND_LOG.STRING(g_level_statement,

2265: 'FUNC_SHORT_NAME == >'||FUNC_SHORT_NAME );
2266: FND_LOG.STRING(g_level_statement,
2267: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2268: 'p_calling_sequence == >'||p_calling_sequence );
2269: FND_LOG.STRING(g_level_statement,
2270: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2271: 'p_event_class_code == >'||p_event_class_code );
2272: FND_LOG.STRING(g_level_statement,
2273: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2272: FND_LOG.STRING(g_level_statement,

2268: 'p_calling_sequence == >'||p_calling_sequence );
2269: FND_LOG.STRING(g_level_statement,
2270: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2271: 'p_event_class_code == >'||p_event_class_code );
2272: FND_LOG.STRING(g_level_statement,
2273: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2274: 'p_entity_code == >'||p_entity_code );
2275: FND_LOG.STRING(g_level_statement,
2276: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2275: FND_LOG.STRING(g_level_statement,

2271: 'p_event_class_code == >'||p_event_class_code );
2272: FND_LOG.STRING(g_level_statement,
2273: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2274: 'p_entity_code == >'||p_entity_code );
2275: FND_LOG.STRING(g_level_statement,
2276: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2277: 'p_application_id == >'||TO_CHAR(p_application_id));
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2278: FND_LOG.STRING(g_level_statement,

2274: 'p_entity_code == >'||p_entity_code );
2275: FND_LOG.STRING(g_level_statement,
2276: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2277: 'p_application_id == >'||TO_CHAR(p_application_id));
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2280: 'p_internal_organization_id == >'||TO_CHAR(p_internal_organization_id));
2281:
2282: END IF;

Line 2343: FND_LOG.STRING(g_level_statement,

2339: p_default_hierarchy := FALSE;
2340: END IF;
2341:
2342: IF (g_level_statement >= g_current_runtime_level ) THEN
2343: FND_LOG.STRING(g_level_statement,
2344: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2345: 'l_tax_classification_code is found =='||l_tax_classification_code);
2346: END IF;
2347:

Line 2352: FND_LOG.STRING(g_level_statement,

2348: IF (l_tax_classification_found = FALSE) THEN
2349: IF (APPL_SHORT_NAME = 'SQLAP') THEN
2350: IF (search_ap_def_hier = TRUE) THEN
2351: IF (g_level_statement >= g_current_runtime_level ) THEN
2352: FND_LOG.STRING(g_level_statement,
2353: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2354: 'Getting Event Class Options');
2355: END IF;
2356: open c_evnt_cls_options (p_internal_organization_id,

Line 2365: FND_LOG.STRING(g_level_statement,

2361: l_enforce_tax_from_refdoc_flag;
2362: close c_evnt_cls_options;
2363:
2364: IF (g_level_statement >= g_current_runtime_level ) THEN
2365: FND_LOG.STRING(g_level_statement,
2366: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2367: 'Entity Code:' || p_entity_code);
2368: FND_LOG.STRING(g_level_statement,
2369: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2368: FND_LOG.STRING(g_level_statement,

2364: IF (g_level_statement >= g_current_runtime_level ) THEN
2365: FND_LOG.STRING(g_level_statement,
2366: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2367: 'Entity Code:' || p_entity_code);
2368: FND_LOG.STRING(g_level_statement,
2369: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2370: 'Event Class Code:' || p_event_class_code);
2371: FND_LOG.STRING(g_level_statement,
2372: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2371: FND_LOG.STRING(g_level_statement,

2367: 'Entity Code:' || p_entity_code);
2368: FND_LOG.STRING(g_level_statement,
2369: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2370: 'Event Class Code:' || p_event_class_code);
2371: FND_LOG.STRING(g_level_statement,
2372: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2373: 'Enforce Tax From Account ==' || l_enforce_tax_from_acct_flag);
2374: FND_LOG.STRING(g_level_statement,
2375: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2374: FND_LOG.STRING(g_level_statement,

2370: 'Event Class Code:' || p_event_class_code);
2371: FND_LOG.STRING(g_level_statement,
2372: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2373: 'Enforce Tax From Account ==' || l_enforce_tax_from_acct_flag);
2374: FND_LOG.STRING(g_level_statement,
2375: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2376: 'Getting tax code for AP ');
2377: END IF;
2378:

Line 2399: FND_LOG.STRING(g_level_statement,

2395: -- Tax found on PO shipment, do not search further
2396: l_enforced_tax_found := TRUE;
2397: p_default_hierarchy := FALSE;
2398: IF (g_level_statement >= g_current_runtime_level ) THEN
2399: FND_LOG.STRING(g_level_statement,
2400: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2401: 'l_tax_classification_code =='||l_tax_classification_code );
2402: END IF;
2403: END IF;

Line 2413: FND_LOG.STRING(g_level_statement,

2409: -- precedence over the rest of the tax defaulting hierarchy
2410: -- This includes both Input and Non-taxable accounts.
2411:
2412: IF (g_level_statement >= g_current_runtime_level ) THEN
2413: FND_LOG.STRING(g_level_statement,
2414: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2415: 'Tax from account is enforced');
2416: FND_LOG.STRING(g_level_statement,
2417: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2416: FND_LOG.STRING(g_level_statement,

2412: IF (g_level_statement >= g_current_runtime_level ) THEN
2413: FND_LOG.STRING(g_level_statement,
2414: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2415: 'Tax from account is enforced');
2416: FND_LOG.STRING(g_level_statement,
2417: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2418: ' Calling get_account_tax ');
2419: END IF;
2420: get_account_tax (p_code_combination_id,

Line 2428: FND_LOG.STRING(g_level_statement,

2424: l_tax_classification_found,
2425: l_curr_calling_sequence);
2426: l_tax_classification_code := p_tax_classification_code;
2427: IF (g_level_statement >= g_current_runtime_level ) THEN
2428: FND_LOG.STRING(g_level_statement,
2429: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2430: 'l_tax_classification_code =='||l_tax_classification_code);
2431: END IF;
2432: IF (p_allow_tax_code_override_flag = 'N') THEN

Line 2475: FND_LOG.STRING(g_level_statement,

2471: -- aptaxtab (i) is not NULL
2472:
2473: IF (aptaxtab (i) = 'REFERENCE_DOCUMENT') THEN
2474: IF (g_level_statement >= g_current_runtime_level ) THEN
2475: FND_LOG.STRING(g_level_statement,
2476: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2477: 'Getting tax code from shipment');
2478: FND_LOG.STRING(g_level_statement,
2479: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2478: FND_LOG.STRING(g_level_statement,

2474: IF (g_level_statement >= g_current_runtime_level ) THEN
2475: FND_LOG.STRING(g_level_statement,
2476: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2477: 'Getting tax code from shipment');
2478: FND_LOG.STRING(g_level_statement,
2479: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2480: 'Calling get_input_tax_classif_code ');
2481: END IF;
2482: l_tax_classification_code := get_input_tax_classif_code (

Line 2495: FND_LOG.STRING(g_level_statement,

2491: IF (l_tax_classification_code IS NOT NULL) THEN
2492: l_tax_classification_found := TRUE;
2493: p_default_hierarchy := FALSE;
2494: IF (g_level_statement >= g_current_runtime_level ) THEN
2495: FND_LOG.STRING(g_level_statement,
2496: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2497: 'l_tax_classification_code ==' ||l_tax_classification_code);
2498: END IF;
2499: exit Ap_Tax_Loop;

Line 2505: FND_LOG.STRING(g_level_statement,

2501: END IF;
2502:
2503: IF (aptaxtab (i) = 'SHIP_FROM_PARTY_SITE') THEN
2504: IF (g_level_statement >= g_current_runtime_level ) THEN
2505: FND_LOG.STRING(g_level_statement,
2506: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2507: 'Getting tax code from supplier site');
2508: END IF;
2509: l_tax_classification_code := get_site_tax (

Line 2516: FND_LOG.STRING(g_level_statement,

2512: IF (l_tax_classification_code IS NOT NULL) THEN
2513: l_tax_classification_found := TRUE;
2514: p_default_hierarchy := FALSE;
2515: IF (g_level_statement >= g_current_runtime_level ) THEN
2516: FND_LOG.STRING(g_level_statement,
2517: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2518: 'l_tax_classification_code ==' ||l_tax_classification_code);
2519: END IF;
2520: exit Ap_Tax_Loop;

Line 2526: FND_LOG.STRING(g_level_statement,

2522: END IF;
2523:
2524: IF (aptaxtab (i) = 'SHIP_FROM_PARTY') THEN
2525: IF (g_level_statement >= g_current_runtime_level ) THEN
2526: FND_LOG.STRING(g_level_statement,
2527: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2528: 'Getting tax code from supplier');
2529: END IF;
2530: l_tax_classification_code := get_vendor_tax (

Line 2537: FND_LOG.STRING(g_level_statement,

2533: IF (l_tax_classification_code IS NOT NULL) THEN
2534: l_tax_classification_found := TRUE;
2535: p_default_hierarchy := FALSE;
2536: IF (g_level_statement >= g_current_runtime_level ) THEN
2537: FND_LOG.STRING(g_level_statement,
2538: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2539: 'l_tax_classification_code ==' ||l_tax_classification_code);
2540: END IF;
2541: exit Ap_Tax_Loop;

Line 2547: FND_LOG.STRING(g_level_statement,

2543: END IF;
2544:
2545: IF (aptaxtab (i) = 'NATURAL_ACCOUNT') THEN
2546: IF (g_level_statement >= g_current_runtime_level ) THEN
2547: FND_LOG.STRING(g_level_statement,
2548: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2549: 'Getting tax code from account');
2550: END IF;
2551: get_account_tax (p_code_combination_id,

Line 2559: FND_LOG.STRING(g_level_statement,

2555: l_tax_classification_found,
2556: l_curr_calling_sequence);
2557: l_tax_classification_code := p_tax_classification_code;
2558: IF (g_level_statement >= g_current_runtime_level ) THEN
2559: FND_LOG.STRING(g_level_statement,
2560: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2561: 'l_tax_classification_code ==' ||l_tax_classification_code);
2562: END IF;
2563: IF (l_tax_classification_found = TRUE) THEN

Line 2566: FND_LOG.STRING(g_level_statement,

2562: END IF;
2563: IF (l_tax_classification_found = TRUE) THEN
2564: p_default_hierarchy := TRUE;
2565: IF (g_level_statement >= g_current_runtime_level ) THEN
2566: FND_LOG.STRING(g_level_statement,
2567: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2568: 'l_tax_classification_code is Found ==' ||l_tax_classification_code);
2569: END IF;
2570: exit Ap_Tax_Loop;

Line 2576: FND_LOG.STRING(g_level_statement,

2572: END IF;
2573:
2574: IF (aptaxtab (i) = 'FINANCIAL_OPTIONS') THEN
2575: IF (g_level_statement >= g_current_runtime_level ) THEN
2576: FND_LOG.STRING(g_level_statement,
2577: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2578: 'Getting tax code from financial system parameters');
2579: FND_LOG.STRING(g_level_statement,
2580: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2579: FND_LOG.STRING(g_level_statement,

2575: IF (g_level_statement >= g_current_runtime_level ) THEN
2576: FND_LOG.STRING(g_level_statement,
2577: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2578: 'Getting tax code from financial system parameters');
2579: FND_LOG.STRING(g_level_statement,
2580: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2581: 'sysinfo.vat_code ==' ||sysinfo.ap_info.tax_classification_code );
2582: END IF;
2583: l_tax_classification_code := sysinfo.ap_info.tax_classification_code;

Line 2588: FND_LOG.STRING(g_level_statement,

2584: IF (l_tax_classification_code IS NOT NULL) THEN
2585: l_tax_classification_found := TRUE;
2586: p_default_hierarchy := FALSE;
2587: IF (g_level_statement >= g_current_runtime_level ) THEN
2588: FND_LOG.STRING(g_level_statement,
2589: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2590: 'l_tax_classification_code ==' ||l_tax_classification_code);
2591: END IF;
2592: exit Ap_Tax_Loop;

Line 2598: FND_LOG.STRING(g_level_statement,

2594: END IF;
2595:
2596: IF (aptaxtab (i) = 'TEMPLATE') THEN
2597: IF (g_level_statement >= g_current_runtime_level ) THEN
2598: FND_LOG.STRING(g_level_statement,
2599: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2600: 'Getting tax code from template');
2601: END IF;
2602: -- If the API has been called from a form or process

Line 2621: FND_LOG.STRING(g_level_statement,

2617: l_tax_classification_code := p_templ_tax_classification_cd;
2618: l_tax_classification_found := TRUE;
2619: p_default_hierarchy := FALSE;
2620: IF (g_level_statement >= g_current_runtime_level ) THEN
2621: FND_LOG.STRING(g_level_statement,
2622: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2623: 'l_tax_classification_code ==' ||l_tax_classification_code);
2624: END IF;
2625: exit Ap_Tax_Loop;

Line 2637: FND_LOG.STRING(g_level_statement,

2633: END IF; -- tax_code_found
2634:
2635: IF (nvl (p_tax_user_override_flag, 'N') <> 'Y') THEN
2636: IF (g_level_statement >= g_current_runtime_level ) THEN
2637: FND_LOG.STRING(g_level_statement,
2638: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2639: 'p_tax_user_override_flag =='||p_tax_user_override_flag);
2640: FND_LOG.STRING(g_level_statement,
2641: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',

Line 2640: FND_LOG.STRING(g_level_statement,

2636: IF (g_level_statement >= g_current_runtime_level ) THEN
2637: FND_LOG.STRING(g_level_statement,
2638: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2639: 'p_tax_user_override_flag =='||p_tax_user_override_flag);
2640: FND_LOG.STRING(g_level_statement,
2641: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2642: 'l_tax_classification_code =='||l_tax_classification_code);
2643: END IF;
2644: END IF;

Line 2646: FND_LOG.STRING(g_level_statement,

2642: 'l_tax_classification_code =='||l_tax_classification_code);
2643: END IF;
2644: END IF;
2645: IF (g_level_statement >= g_current_runtime_level ) THEN
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2648: 'p_tax_classification_code =='||p_tax_classification_code);
2649: FND_LOG.STRING(g_level_statement,
2650: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc.END',

Line 2649: FND_LOG.STRING(g_level_statement,

2645: IF (g_level_statement >= g_current_runtime_level ) THEN
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2648: 'p_tax_classification_code =='||p_tax_classification_code);
2649: FND_LOG.STRING(g_level_statement,
2650: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc.END',
2651: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: get_def_tax_classif_from_acc (-)');
2652: END IF;
2653:

Line 2657: FND_LOG.STRING(g_level_unexpected,

2653:
2654: EXCEPTION
2655: WHEN NO_DATA_FOUND THEN
2656: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2657: FND_LOG.STRING(g_level_unexpected,
2658: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2659: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
2660: END IF;
2661: IF (l_tax_classification_found = FALSE ) THEN

Line 2667: FND_LOG.STRING(g_level_unexpected,

2663: END IF;
2664: WHEN OTHERS THEN
2665: IF (SQLCODE <> -20001) THEN
2666: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2667: FND_LOG.STRING(g_level_unexpected,
2668: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_def_tax_classif_from_acc',
2669: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
2670: END IF;
2671: IF (appl_short_name = 'SQLAP') THEN

Line 2747: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2743: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
2744: AND nvl(tc.enabled_flag,'Y') = 'Y';
2745:
2746: BEGIN
2747: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2748:
2749: IF (g_level_statement >= g_current_runtime_level ) THEN
2750: FND_LOG.STRING(g_level_statement,
2751: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax.BEGIN',

Line 2750: FND_LOG.STRING(g_level_statement,

2746: BEGIN
2747: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2748:
2749: IF (g_level_statement >= g_current_runtime_level ) THEN
2750: FND_LOG.STRING(g_level_statement,
2751: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax.BEGIN',
2752: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Item_Tax (+)');
2753: FND_LOG.STRING(g_level_statement,
2754: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',

Line 2753: FND_LOG.STRING(g_level_statement,

2749: IF (g_level_statement >= g_current_runtime_level ) THEN
2750: FND_LOG.STRING(g_level_statement,
2751: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax.BEGIN',
2752: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Item_Tax (+)');
2753: FND_LOG.STRING(g_level_statement,
2754: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2755: 'p_item_id == > '||to_char(p_item_id ));
2756: FND_LOG.STRING(g_level_statement,
2757: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',

Line 2756: FND_LOG.STRING(g_level_statement,

2752: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Item_Tax (+)');
2753: FND_LOG.STRING(g_level_statement,
2754: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2755: 'p_item_id == > '||to_char(p_item_id ));
2756: FND_LOG.STRING(g_level_statement,
2757: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2758: 'p_ship_to_loc_org_id == > '||to_char(p_ship_to_loc_org_id ));
2759: FND_LOG.STRING(g_level_statement,
2760: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',

Line 2759: FND_LOG.STRING(g_level_statement,

2755: 'p_item_id == > '||to_char(p_item_id ));
2756: FND_LOG.STRING(g_level_statement,
2757: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2758: 'p_ship_to_loc_org_id == > '||to_char(p_ship_to_loc_org_id ));
2759: FND_LOG.STRING(g_level_statement,
2760: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2761: 'p_item_org_id == > '||to_char(p_item_org_id ));
2762: FND_LOG.STRING(g_level_statement,
2763: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',

Line 2762: FND_LOG.STRING(g_level_statement,

2758: 'p_ship_to_loc_org_id == > '||to_char(p_ship_to_loc_org_id ));
2759: FND_LOG.STRING(g_level_statement,
2760: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2761: 'p_item_org_id == > '||to_char(p_item_org_id ));
2762: FND_LOG.STRING(g_level_statement,
2763: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2764: 'p_calling_sequence == >'||p_calling_sequence);
2765: END IF;
2766: debug_loc := 'Get_Item_Tax';

Line 2774: FND_LOG.STRING(g_level_statement,

2770: FETCH sel_item_tax INTO l_tax_classification_code;
2771: CLOSE sel_item_tax;
2772:
2773: IF (g_level_statement >= g_current_runtime_level ) THEN
2774: FND_LOG.STRING(g_level_statement,
2775: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2776: 'l_tax_classification_code =='||l_tax_classification_code);
2777: FND_LOG.STRING(g_level_statement,
2778: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax.END',

Line 2777: FND_LOG.STRING(g_level_statement,

2773: IF (g_level_statement >= g_current_runtime_level ) THEN
2774: FND_LOG.STRING(g_level_statement,
2775: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2776: 'l_tax_classification_code =='||l_tax_classification_code);
2777: FND_LOG.STRING(g_level_statement,
2778: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax.END',
2779: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Item_Tax (-)');
2780: END IF;
2781:

Line 2792: FND_LOG.STRING(g_level_unexpected,

2788: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2789: FND_MSG_PUB.Add;
2790:
2791: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2792: FND_LOG.STRING(g_level_unexpected,
2793: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Item_Tax',
2794: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2795: END IF;
2796: IF (sel_item_tax%ISOPEN) THEN

Line 2881: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2877:
2878:
2879: BEGIN
2880:
2881: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2882:
2883: IF (g_level_statement >= g_current_runtime_level ) THEN
2884: FND_LOG.STRING(g_level_statement,
2885: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax.BEGIN',

Line 2884: FND_LOG.STRING(g_level_statement,

2880:
2881: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2882:
2883: IF (g_level_statement >= g_current_runtime_level ) THEN
2884: FND_LOG.STRING(g_level_statement,
2885: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax.BEGIN',
2886: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Account_Tax (+)');
2887: FND_LOG.STRING(g_level_statement,
2888: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 2887: FND_LOG.STRING(g_level_statement,

2883: IF (g_level_statement >= g_current_runtime_level ) THEN
2884: FND_LOG.STRING(g_level_statement,
2885: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax.BEGIN',
2886: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Account_Tax (+)');
2887: FND_LOG.STRING(g_level_statement,
2888: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2889: 'p_code_combination_id ==>'||to_char(p_code_combination_id));
2890: FND_LOG.STRING(g_level_statement,
2891: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 2890: FND_LOG.STRING(g_level_statement,

2886: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Account_Tax (+)');
2887: FND_LOG.STRING(g_level_statement,
2888: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2889: 'p_code_combination_id ==>'||to_char(p_code_combination_id));
2890: FND_LOG.STRING(g_level_statement,
2891: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2892: 'p_concatenated_segments ==>'||p_concatenated_segments);
2893: FND_LOG.STRING(g_level_statement,
2894: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 2893: FND_LOG.STRING(g_level_statement,

2889: 'p_code_combination_id ==>'||to_char(p_code_combination_id));
2890: FND_LOG.STRING(g_level_statement,
2891: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2892: 'p_concatenated_segments ==>'||p_concatenated_segments);
2893: FND_LOG.STRING(g_level_statement,
2894: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2895: 'p_tax_classification_code ==>'|| p_tax_classification_code );
2896: FND_LOG.STRING(g_level_statement,
2897: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 2896: FND_LOG.STRING(g_level_statement,

2892: 'p_concatenated_segments ==>'||p_concatenated_segments);
2893: FND_LOG.STRING(g_level_statement,
2894: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2895: 'p_tax_classification_code ==>'|| p_tax_classification_code );
2896: FND_LOG.STRING(g_level_statement,
2897: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2898: 'p_allow_tax_code_override_flag ==>'||p_allow_tax_code_override_flag);
2899:
2900: FND_LOG.STRING(g_level_statement,

Line 2900: FND_LOG.STRING(g_level_statement,

2896: FND_LOG.STRING(g_level_statement,
2897: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2898: 'p_allow_tax_code_override_flag ==>'||p_allow_tax_code_override_flag);
2899:
2900: FND_LOG.STRING(g_level_statement,
2901: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2902: 'p_calling_sequence ==>'||p_calling_sequence );
2903: END IF;
2904:

Line 2911: FND_LOG.STRING(g_level_statement,

2907:
2908: IF (p_code_combination_id is not NULL and p_code_combination_id <> -1) THEN
2909: -- Get the column name that holds the account segment in GL_CODE_COMBINATIONS
2910: IF (g_level_statement >= g_current_runtime_level ) THEN
2911: FND_LOG.STRING(g_level_statement,
2912: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2913: 'Getting tax code using code combination ID');
2914: FND_LOG.STRING(g_level_statement,
2915: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 2914: FND_LOG.STRING(g_level_statement,

2910: IF (g_level_statement >= g_current_runtime_level ) THEN
2911: FND_LOG.STRING(g_level_statement,
2912: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2913: 'Getting tax code using code combination ID');
2914: FND_LOG.STRING(g_level_statement,
2915: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2916: 'p_code_combination_id is not Null =='||to_char(p_code_combination_id));
2917: END IF;
2918:

Line 2931: FND_LOG.STRING(g_level_statement,

2927: ' WHERE cc.code_combination_id = ' || p_code_combination_id;
2928:
2929: execute immediate statement into l_account_seg_value ;
2930: IF (g_level_statement >= g_current_runtime_level ) THEN
2931: FND_LOG.STRING(g_level_statement,
2932: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2933: 'l_account_seg_value =='||l_account_seg_value);
2934: END IF;
2935: ELSE

Line 2938: FND_LOG.STRING(g_level_statement,

2934: END IF;
2935: ELSE
2936: IF (p_concatenated_segments is not NULL) THEN
2937: IF (g_level_statement >= g_current_runtime_level ) THEN
2938: FND_LOG.STRING(g_level_statement,
2939: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2940: 'p_concatenated_segments is not Null =='||p_concatenated_segments);
2941: END IF;
2942: -- Get account segment from the concatenated string

Line 2944: FND_LOG.STRING(g_level_statement,

2940: 'p_concatenated_segments is not Null =='||p_concatenated_segments);
2941: END IF;
2942: -- Get account segment from the concatenated string
2943: IF (g_level_statement >= g_current_runtime_level ) THEN
2944: FND_LOG.STRING(g_level_statement,
2945: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2946: 'Getting tax code using concatenated segments');
2947: END IF;
2948: l_delimiter := fnd_flex_ext.get_delimiter ('SQLGL',

Line 2962: FND_LOG.STRING(g_level_statement,

2958: l_account_seg_num);
2959: l_account_seg_value := l_flexsegtab(l_account_seg_num);
2960:
2961: IF (g_level_statement >= g_current_runtime_level ) THEN
2962: FND_LOG.STRING(g_level_statement,
2963: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2964: 'l_account_seg_value =='|| l_account_seg_value);
2965: FND_LOG.STRING(g_level_statement,
2966: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 2965: FND_LOG.STRING(g_level_statement,

2961: IF (g_level_statement >= g_current_runtime_level ) THEN
2962: FND_LOG.STRING(g_level_statement,
2963: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2964: 'l_account_seg_value =='|| l_account_seg_value);
2965: FND_LOG.STRING(g_level_statement,
2966: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2967: 'l_delimiter =='||l_delimiter );
2968: FND_LOG.STRING(g_level_statement,
2969: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 2968: FND_LOG.STRING(g_level_statement,

2964: 'l_account_seg_value =='|| l_account_seg_value);
2965: FND_LOG.STRING(g_level_statement,
2966: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2967: 'l_delimiter =='||l_delimiter );
2968: FND_LOG.STRING(g_level_statement,
2969: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2970: 'l_result =='||to_char(l_result));
2971: END IF;
2972: END IF;

Line 2977: FND_LOG.STRING(g_level_statement,

2973: END IF;
2974:
2975: IF (l_account_seg_value is not NULL) THEN
2976: IF (g_level_statement >= g_current_runtime_level ) THEN
2977: FND_LOG.STRING(g_level_statement,
2978: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2979: 'l_account_seg_value is not null =='||l_account_seg_value);
2980: END IF;
2981: BEGIN

Line 3007: FND_LOG.STRING(g_level_statement,

3003: 'WHERE toa.account_segment_value = :l_account_seg_value ' ||
3004: 'AND ( toa.org_id = :l_bind_org_id or toa.org_id = -1 )' ||
3005: 'AND toa.tax_class = ''N'' ';
3006: IF (g_level_statement >= g_current_runtime_level ) THEN
3007: FND_LOG.STRING(g_level_statement,
3008: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3009: 'statement='||statement);
3010: FND_LOG.STRING(g_level_statement,
3011: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 3010: FND_LOG.STRING(g_level_statement,

3006: IF (g_level_statement >= g_current_runtime_level ) THEN
3007: FND_LOG.STRING(g_level_statement,
3008: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3009: 'statement='||statement);
3010: FND_LOG.STRING(g_level_statement,
3011: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3012: 'Executing Dynamic SQL statement ');
3013: END IF;
3014: execute immediate statement into p_allow_tax_code_override_flag,

Line 3024: FND_LOG.STRING(g_level_statement,

3020: sysinfo.org_id,
3021: l_account_seg_value,
3022: sysinfo.org_id;
3023: IF (g_level_statement >= g_current_runtime_level ) THEN
3024: FND_LOG.STRING(g_level_statement,
3025: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3026: 'statement =='||substr(statement,1,700));
3027: FND_LOG.STRING(g_level_statement,
3028: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 3027: FND_LOG.STRING(g_level_statement,

3023: IF (g_level_statement >= g_current_runtime_level ) THEN
3024: FND_LOG.STRING(g_level_statement,
3025: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3026: 'statement =='||substr(statement,1,700));
3027: FND_LOG.STRING(g_level_statement,
3028: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3029: 'sysinfo.org_id =='||to_char(sysinfo.org_id));
3030: FND_LOG.STRING(g_level_statement,
3031: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 3030: FND_LOG.STRING(g_level_statement,

3026: 'statement =='||substr(statement,1,700));
3027: FND_LOG.STRING(g_level_statement,
3028: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3029: 'sysinfo.org_id =='||to_char(sysinfo.org_id));
3030: FND_LOG.STRING(g_level_statement,
3031: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3032: 'p_allow_tax_code_override_flag =='||p_allow_tax_code_override_flag );
3033: FND_LOG.STRING(g_level_statement,
3034: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 3033: FND_LOG.STRING(g_level_statement,

3029: 'sysinfo.org_id =='||to_char(sysinfo.org_id));
3030: FND_LOG.STRING(g_level_statement,
3031: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3032: 'p_allow_tax_code_override_flag =='||p_allow_tax_code_override_flag );
3033: FND_LOG.STRING(g_level_statement,
3034: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3035: ' p_tax_classification_code =='|| p_tax_classification_code );
3036: FND_LOG.STRING(g_level_statement,
3037: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 3036: FND_LOG.STRING(g_level_statement,

3032: 'p_allow_tax_code_override_flag =='||p_allow_tax_code_override_flag );
3033: FND_LOG.STRING(g_level_statement,
3034: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3035: ' p_tax_classification_code =='|| p_tax_classification_code );
3036: FND_LOG.STRING(g_level_statement,
3037: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3038: 'l_tax_type_code =='||l_tax_type_code );
3039: FND_LOG.STRING(g_level_statement,
3040: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',

Line 3039: FND_LOG.STRING(g_level_statement,

3035: ' p_tax_classification_code =='|| p_tax_classification_code );
3036: FND_LOG.STRING(g_level_statement,
3037: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3038: 'l_tax_type_code =='||l_tax_type_code );
3039: FND_LOG.STRING(g_level_statement,
3040: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3041: 'l_account_seg_value =='||l_account_seg_value );
3042:
3043: FND_LOG.STRING(g_level_statement,

Line 3043: FND_LOG.STRING(g_level_statement,

3039: FND_LOG.STRING(g_level_statement,
3040: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3041: 'l_account_seg_value =='||l_account_seg_value );
3042:
3043: FND_LOG.STRING(g_level_statement,
3044: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax.END',
3045: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: Get_Account_Tax (-)');
3046: END IF;
3047:

Line 3051: FND_LOG.STRING(g_level_unexpected,

3047:
3048: EXCEPTION
3049: WHEN no_data_found THEN
3050: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3051: FND_LOG.STRING(g_level_unexpected,
3052: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
3053: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3054: END IF;
3055:

Line 3063: FND_LOG.STRING(g_level_unexpected,

3059: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3060: FND_MSG_PUB.Add;
3061:
3062: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3063: FND_LOG.STRING(g_level_unexpected,
3064: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_account_tax',
3065: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3066: END IF;
3067: RAISE;

Line 3147: FND_LOG.STRING(g_level_statement,

3143: AND event_class_mapping_id = c_event_class_mapping_id;
3144: BEGIN
3145:
3146: IF (g_level_statement >= g_current_runtime_level ) THEN
3147: FND_LOG.STRING(g_level_statement,
3148: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier.BEGIN',
3149: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_ap_def_option_hier(+)' );
3150: FND_LOG.STRING(g_level_statement,
3151: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3150: FND_LOG.STRING(g_level_statement,

3146: IF (g_level_statement >= g_current_runtime_level ) THEN
3147: FND_LOG.STRING(g_level_statement,
3148: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier.BEGIN',
3149: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_ap_def_option_hier(+)' );
3150: FND_LOG.STRING(g_level_statement,
3151: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3152: 'p_event_class_code : ' || p_event_class_code);
3153: FND_LOG.STRING(g_level_statement,
3154: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3153: FND_LOG.STRING(g_level_statement,

3149: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_ap_def_option_hier(+)' );
3150: FND_LOG.STRING(g_level_statement,
3151: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3152: 'p_event_class_code : ' || p_event_class_code);
3153: FND_LOG.STRING(g_level_statement,
3154: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3155: 'Getting default options ');
3156: END IF;
3157:

Line 3182: FND_LOG.STRING(g_level_statement,

3178:
3179: IF l_event_class_mapping_id IS NULL THEN
3180: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3181: IF (g_level_statement >= g_current_runtime_level ) THEN
3182: FND_LOG.STRING(g_level_statement,
3183: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3184: 'event_class_mapping_id not found for Internet expense');
3185: END IF;
3186: RETURN;

Line 3227: FND_LOG.STRING(g_level_statement,

3223: search_for_ap_tax := TRUE;
3224: END IF;
3225:
3226: IF (g_level_statement >= g_current_runtime_level ) THEN
3227: FND_LOG.STRING(g_level_statement,
3228: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3229: 'Use Tax Classification: '|| NVL(ap_info.use_tax_classification_flag,'N'));
3230: FND_LOG.STRING(g_level_statement,
3231: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3230: FND_LOG.STRING(g_level_statement,

3226: IF (g_level_statement >= g_current_runtime_level ) THEN
3227: FND_LOG.STRING(g_level_statement,
3228: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3229: 'Use Tax Classification: '|| NVL(ap_info.use_tax_classification_flag,'N'));
3230: FND_LOG.STRING(g_level_statement,
3231: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3232: 'Hierarchy Level 1: ' ||ap_info.def_option_hier_1_code );
3233: FND_LOG.STRING(g_level_statement,
3234: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3233: FND_LOG.STRING(g_level_statement,

3229: 'Use Tax Classification: '|| NVL(ap_info.use_tax_classification_flag,'N'));
3230: FND_LOG.STRING(g_level_statement,
3231: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3232: 'Hierarchy Level 1: ' ||ap_info.def_option_hier_1_code );
3233: FND_LOG.STRING(g_level_statement,
3234: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3235: 'Hierarchy Level 2: ' ||ap_info.def_option_hier_2_code );
3236: FND_LOG.STRING(g_level_statement,
3237: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3236: FND_LOG.STRING(g_level_statement,

3232: 'Hierarchy Level 1: ' ||ap_info.def_option_hier_1_code );
3233: FND_LOG.STRING(g_level_statement,
3234: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3235: 'Hierarchy Level 2: ' ||ap_info.def_option_hier_2_code );
3236: FND_LOG.STRING(g_level_statement,
3237: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3238: 'Hierarchy Level 3: ' ||ap_info.def_option_hier_3_code );
3239: FND_LOG.STRING(g_level_statement,
3240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3239: FND_LOG.STRING(g_level_statement,

3235: 'Hierarchy Level 2: ' ||ap_info.def_option_hier_2_code );
3236: FND_LOG.STRING(g_level_statement,
3237: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3238: 'Hierarchy Level 3: ' ||ap_info.def_option_hier_3_code );
3239: FND_LOG.STRING(g_level_statement,
3240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3241: 'Hierarchy Level 4: ' ||ap_info.def_option_hier_4_code );
3242: FND_LOG.STRING(g_level_statement,
3243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3242: FND_LOG.STRING(g_level_statement,

3238: 'Hierarchy Level 3: ' ||ap_info.def_option_hier_3_code );
3239: FND_LOG.STRING(g_level_statement,
3240: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3241: 'Hierarchy Level 4: ' ||ap_info.def_option_hier_4_code );
3242: FND_LOG.STRING(g_level_statement,
3243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3244: 'Hierarchy Level 5: ' ||ap_info.def_option_hier_5_code );
3245: FND_LOG.STRING(g_level_statement,
3246: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3245: FND_LOG.STRING(g_level_statement,

3241: 'Hierarchy Level 4: ' ||ap_info.def_option_hier_4_code );
3242: FND_LOG.STRING(g_level_statement,
3243: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3244: 'Hierarchy Level 5: ' ||ap_info.def_option_hier_5_code );
3245: FND_LOG.STRING(g_level_statement,
3246: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3247: 'Hierarchy Level 6: ' ||ap_info.def_option_hier_6_code );
3248: FND_LOG.STRING(g_level_statement,
3249: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',

Line 3248: FND_LOG.STRING(g_level_statement,

3244: 'Hierarchy Level 5: ' ||ap_info.def_option_hier_5_code );
3245: FND_LOG.STRING(g_level_statement,
3246: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3247: 'Hierarchy Level 6: ' ||ap_info.def_option_hier_6_code );
3248: FND_LOG.STRING(g_level_statement,
3249: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3250: 'Hierarchy Level 7: ' ||ap_info.def_option_hier_7_code );
3251:
3252: END IF;

Line 3267: FND_LOG.STRING(g_level_statement,

3263: OR sysinfo.ap_info.def_option_hier_6_code IS NOT NULL
3264: OR sysinfo.ap_info.def_option_hier_7_code IS NOT NULL) THEN
3265:
3266: IF (g_level_statement >= g_current_runtime_level ) THEN
3267: FND_LOG.STRING(g_level_statement,
3268: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3269: 'Initializing AP defaulting information');
3270: END IF;
3271:

Line 3286: FND_LOG.STRING(g_level_statement,

3282:
3283: END IF;
3284:
3285: IF (g_level_statement >= g_current_runtime_level ) THEN
3286: FND_LOG.STRING(g_level_statement,
3287: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier.END',
3288: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_ap_def_option_hier(-)' );
3289: END IF;
3290:

Line 3306: FND_LOG.STRING(g_level_unexpected,

3302: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3303: FND_MSG_PUB.Add;
3304:
3305: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3306: FND_LOG.STRING(g_level_unexpected,
3307: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_ap_def_option_hier',
3308: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3309: END IF;
3310:

Line 3355: FND_LOG.STRING(g_level_statement,

3351:
3352: BEGIN
3353:
3354: IF (g_level_statement >= g_current_runtime_level ) THEN
3355: FND_LOG.STRING(g_level_statement,
3356: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier.BEGIN',
3357: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_po_def_option_hier(+)' );
3358: END IF;
3359:

Line 3377: FND_LOG.STRING(g_level_statement,

3373: CLOSE get_status_flag_csr;
3374:
3375: IF nvl(status_flag,'N') in ('I','S') THEN
3376: IF (g_level_statement >= g_current_runtime_level ) THEN
3377: FND_LOG.STRING(g_level_statement,
3378: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3379: 'Getting PO default options');
3380: END IF;
3381:

Line 3404: FND_LOG.STRING(g_level_statement,

3400: search_for_po_tax := TRUE;
3401: END IF;
3402:
3403: IF (g_level_statement >= g_current_runtime_level ) THEN
3404: FND_LOG.STRING(g_level_statement,
3405: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3406: 'PO Use Tax Classification: '|| NVL(po_info.use_tax_classification_flag,'N'));
3407: FND_LOG.STRING(g_level_statement,
3408: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',

Line 3407: FND_LOG.STRING(g_level_statement,

3403: IF (g_level_statement >= g_current_runtime_level ) THEN
3404: FND_LOG.STRING(g_level_statement,
3405: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3406: 'PO Use Tax Classification: '|| NVL(po_info.use_tax_classification_flag,'N'));
3407: FND_LOG.STRING(g_level_statement,
3408: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3409: 'PO Hierarchy Level 1: ' ||po_info.def_option_hier_1_code );
3410: FND_LOG.STRING(g_level_statement,
3411: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',

Line 3410: FND_LOG.STRING(g_level_statement,

3406: 'PO Use Tax Classification: '|| NVL(po_info.use_tax_classification_flag,'N'));
3407: FND_LOG.STRING(g_level_statement,
3408: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3409: 'PO Hierarchy Level 1: ' ||po_info.def_option_hier_1_code );
3410: FND_LOG.STRING(g_level_statement,
3411: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3412: 'PO Hierarchy Level 2: ' ||po_info.def_option_hier_2_code );
3413: FND_LOG.STRING(g_level_statement,
3414: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',

Line 3413: FND_LOG.STRING(g_level_statement,

3409: 'PO Hierarchy Level 1: ' ||po_info.def_option_hier_1_code );
3410: FND_LOG.STRING(g_level_statement,
3411: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3412: 'PO Hierarchy Level 2: ' ||po_info.def_option_hier_2_code );
3413: FND_LOG.STRING(g_level_statement,
3414: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3415: 'PO Hierarchy Level 3: ' ||po_info.def_option_hier_3_code );
3416: FND_LOG.STRING(g_level_statement,
3417: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',

Line 3416: FND_LOG.STRING(g_level_statement,

3412: 'PO Hierarchy Level 2: ' ||po_info.def_option_hier_2_code );
3413: FND_LOG.STRING(g_level_statement,
3414: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3415: 'PO Hierarchy Level 3: ' ||po_info.def_option_hier_3_code );
3416: FND_LOG.STRING(g_level_statement,
3417: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3418: 'PO Hierarchy Level 4: ' ||po_info.def_option_hier_4_code );
3419: FND_LOG.STRING(g_level_statement,
3420: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',

Line 3419: FND_LOG.STRING(g_level_statement,

3415: 'PO Hierarchy Level 3: ' ||po_info.def_option_hier_3_code );
3416: FND_LOG.STRING(g_level_statement,
3417: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3418: 'PO Hierarchy Level 4: ' ||po_info.def_option_hier_4_code );
3419: FND_LOG.STRING(g_level_statement,
3420: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3421: 'PO Hierarchy Level 5: ' ||po_info.def_option_hier_5_code );
3422: FND_LOG.STRING(g_level_statement,
3423: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',

Line 3422: FND_LOG.STRING(g_level_statement,

3418: 'PO Hierarchy Level 4: ' ||po_info.def_option_hier_4_code );
3419: FND_LOG.STRING(g_level_statement,
3420: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3421: 'PO Hierarchy Level 5: ' ||po_info.def_option_hier_5_code );
3422: FND_LOG.STRING(g_level_statement,
3423: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3424: 'PO Hierarchy Level 6: ' ||po_info.def_option_hier_6_code );
3425: FND_LOG.STRING(g_level_statement,
3426: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',

Line 3425: FND_LOG.STRING(g_level_statement,

3421: 'PO Hierarchy Level 5: ' ||po_info.def_option_hier_5_code );
3422: FND_LOG.STRING(g_level_statement,
3423: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3424: 'PO Hierarchy Level 6: ' ||po_info.def_option_hier_6_code );
3425: FND_LOG.STRING(g_level_statement,
3426: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3427: 'PO Hierarchy Level 7: ' ||po_info.def_option_hier_7_code );
3428: END IF;
3429:

Line 3443: FND_LOG.STRING(g_level_statement,

3439: OR sysinfo.po_info.def_option_hier_6_code IS NOT NULL
3440: OR sysinfo.po_info.def_option_hier_7_code IS NOT NULL) THEN
3441:
3442: IF (g_level_statement >= g_current_runtime_level ) THEN
3443: FND_LOG.STRING(g_level_statement,
3444: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3445: 'Initializing PO information');
3446: END IF;
3447:

Line 3463: FND_LOG.STRING(g_level_statement,

3459:
3460: END IF;
3461:
3462: IF (g_level_statement >= g_current_runtime_level ) THEN
3463: FND_LOG.STRING(g_level_statement,
3464: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier.END',
3465: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_po_def_option_hier(-)' );
3466: END IF;
3467:

Line 3480: FND_LOG.STRING(g_level_unexpected,

3476: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3477: FND_MSG_PUB.Add;
3478:
3479: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3480: FND_LOG.STRING(g_level_unexpected,
3481: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_po_def_option_hier',
3482: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3483: END IF;
3484: END pop_po_def_option_hier;

Line 3522: FND_LOG.STRING(g_level_statement,

3518:
3519: BEGIN
3520:
3521: IF (g_level_statement >= g_current_runtime_level ) THEN
3522: FND_LOG.STRING(g_level_statement,
3523: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier.BEGIN',
3524: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_cc_def_option_hier(+)' );
3525: END IF;
3526:

Line 3535: FND_LOG.STRING(g_level_statement,

3531: search_for_cc_tax := FALSE;
3532: search_cc_def_hier := FALSE;
3533:
3534: IF (g_level_statement >= g_current_runtime_level ) THEN
3535: FND_LOG.STRING(g_level_statement,
3536: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3537: 'Getting CC default options');
3538: END IF;
3539:

Line 3559: FND_LOG.STRING(g_level_statement,

3555: search_for_cc_tax := TRUE;
3556: END IF;
3557:
3558: IF (g_level_statement >= g_current_runtime_level ) THEN
3559: FND_LOG.STRING(g_level_statement,
3560: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3561: 'CC Use Tax Classification: '|| NVL(cc_info.use_tax_classification_flag,'N'));
3562: FND_LOG.STRING(g_level_statement,
3563: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',

Line 3562: FND_LOG.STRING(g_level_statement,

3558: IF (g_level_statement >= g_current_runtime_level ) THEN
3559: FND_LOG.STRING(g_level_statement,
3560: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3561: 'CC Use Tax Classification: '|| NVL(cc_info.use_tax_classification_flag,'N'));
3562: FND_LOG.STRING(g_level_statement,
3563: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3564: 'CC Hierarchy Level 1: ' ||cc_info.def_option_hier_1_code );
3565: FND_LOG.STRING(g_level_statement,
3566: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',

Line 3565: FND_LOG.STRING(g_level_statement,

3561: 'CC Use Tax Classification: '|| NVL(cc_info.use_tax_classification_flag,'N'));
3562: FND_LOG.STRING(g_level_statement,
3563: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3564: 'CC Hierarchy Level 1: ' ||cc_info.def_option_hier_1_code );
3565: FND_LOG.STRING(g_level_statement,
3566: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3567: 'CC Hierarchy Level 2: ' ||cc_info.def_option_hier_2_code );
3568: FND_LOG.STRING(g_level_statement,
3569: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',

Line 3568: FND_LOG.STRING(g_level_statement,

3564: 'CC Hierarchy Level 1: ' ||cc_info.def_option_hier_1_code );
3565: FND_LOG.STRING(g_level_statement,
3566: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3567: 'CC Hierarchy Level 2: ' ||cc_info.def_option_hier_2_code );
3568: FND_LOG.STRING(g_level_statement,
3569: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3570: 'CC Hierarchy Level 3: ' ||cc_info.def_option_hier_3_code );
3571: FND_LOG.STRING(g_level_statement,
3572: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',

Line 3571: FND_LOG.STRING(g_level_statement,

3567: 'CC Hierarchy Level 2: ' ||cc_info.def_option_hier_2_code );
3568: FND_LOG.STRING(g_level_statement,
3569: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3570: 'CC Hierarchy Level 3: ' ||cc_info.def_option_hier_3_code );
3571: FND_LOG.STRING(g_level_statement,
3572: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3573: 'CC Hierarchy Level 4: ' ||cc_info.def_option_hier_4_code );
3574: FND_LOG.STRING(g_level_statement,
3575: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',

Line 3574: FND_LOG.STRING(g_level_statement,

3570: 'CC Hierarchy Level 3: ' ||cc_info.def_option_hier_3_code );
3571: FND_LOG.STRING(g_level_statement,
3572: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3573: 'CC Hierarchy Level 4: ' ||cc_info.def_option_hier_4_code );
3574: FND_LOG.STRING(g_level_statement,
3575: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3576: 'CC Hierarchy Level 5: ' ||cc_info.def_option_hier_5_code );
3577: FND_LOG.STRING(g_level_statement,
3578: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',

Line 3577: FND_LOG.STRING(g_level_statement,

3573: 'CC Hierarchy Level 4: ' ||cc_info.def_option_hier_4_code );
3574: FND_LOG.STRING(g_level_statement,
3575: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3576: 'CC Hierarchy Level 5: ' ||cc_info.def_option_hier_5_code );
3577: FND_LOG.STRING(g_level_statement,
3578: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3579: 'CC Hierarchy Level 6: ' ||cc_info.def_option_hier_6_code );
3580: FND_LOG.STRING(g_level_statement,
3581: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',

Line 3580: FND_LOG.STRING(g_level_statement,

3576: 'CC Hierarchy Level 5: ' ||cc_info.def_option_hier_5_code );
3577: FND_LOG.STRING(g_level_statement,
3578: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3579: 'CC Hierarchy Level 6: ' ||cc_info.def_option_hier_6_code );
3580: FND_LOG.STRING(g_level_statement,
3581: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3582: 'CC Hierarchy Level 7: ' ||cc_info.def_option_hier_7_code );
3583: END IF;
3584:

Line 3598: FND_LOG.STRING(g_level_statement,

3594: OR sysinfo.cc_info.def_option_hier_6_code IS NOT NULL
3595: OR sysinfo.cc_info.def_option_hier_7_code IS NOT NULL) THEN
3596:
3597: IF (g_level_statement >= g_current_runtime_level ) THEN
3598: FND_LOG.STRING(g_level_statement,
3599: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3600: 'Initializing CC information');
3601: END IF;
3602:

Line 3616: FND_LOG.STRING(g_level_statement,

3612: END IF;
3613: END IF;
3614:
3615: IF (g_level_statement >= g_current_runtime_level ) THEN
3616: FND_LOG.STRING(g_level_statement,
3617: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier.END',
3618: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: pop_cc_def_option_hier(-)' );
3619: END IF;
3620:

Line 3633: FND_LOG.STRING(g_level_unexpected,

3629: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3630: FND_MSG_PUB.Add;
3631:
3632: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3633: FND_LOG.STRING(g_level_unexpected,
3634: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.pop_cc_def_option_hier',
3635: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3636: END IF;
3637: END pop_cc_def_option_hier;

Line 3667: FND_LOG.STRING(g_level_statement,

3663:
3664: BEGIN
3665:
3666: IF (g_level_statement >= g_current_runtime_level ) THEN
3667: FND_LOG.STRING(g_level_statement,
3668: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.validate_tax_classif_code.BEGIN',
3669: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: validate_tax_classif_code(+)');
3670:
3671: FND_LOG.STRING(g_level_statement,

Line 3671: FND_LOG.STRING(g_level_statement,

3667: FND_LOG.STRING(g_level_statement,
3668: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.validate_tax_classif_code.BEGIN',
3669: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: validate_tax_classif_code(+)');
3670:
3671: FND_LOG.STRING(g_level_statement,
3672: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.validate_tax_classif_code',
3673: 'p_tax_classification_code =='
3674: ||p_tax_classification_code);
3675:

Line 3683: FND_LOG.STRING(g_level_statement,

3679: FETCH chk_tax_classification_code INTO p_count;
3680: CLOSE chk_tax_classification_code;
3681:
3682: IF (g_level_statement >= g_current_runtime_level ) THEN
3683: FND_LOG.STRING(g_level_statement,
3684: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.validate_tax_classif_code',
3685: 'p_count == >'||to_char(p_count));
3686: FND_LOG.STRING(g_level_statement,
3687: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.validate_tax_classif_code.END',

Line 3686: FND_LOG.STRING(g_level_statement,

3682: IF (g_level_statement >= g_current_runtime_level ) THEN
3683: FND_LOG.STRING(g_level_statement,
3684: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.validate_tax_classif_code',
3685: 'p_count == >'||to_char(p_count));
3686: FND_LOG.STRING(g_level_statement,
3687: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.validate_tax_classif_code.END',
3688: 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG: validate_tax_classif_code(-)');
3689: END IF;
3690: