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_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_AR_TAX_CLASSIFICATN_DEF_PKG

Line 1: package body ZX_AR_TAX_CLASSIFICATN_DEF_PKG as

1: package body ZX_AR_TAX_CLASSIFICATN_DEF_PKG as
2: /* $Header: zxartxclsdefpkgb.pls 120.28.12010000.2 2009/02/02 12:55:31 rajessub ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 142: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax.BEGIN',

138: BEGIN
139:
140: IF (g_level_statement >= g_current_runtime_level ) THEN
141: FND_LOG.STRING(g_level_statement,
142: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax.BEGIN',
143: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_project_tax(+)');
144: END IF;
145:
146: l_tax_classification_code := NULL;

Line 143: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_project_tax(+)');

139:
140: IF (g_level_statement >= g_current_runtime_level ) THEN
141: FND_LOG.STRING(g_level_statement,
142: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax.BEGIN',
143: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_project_tax(+)');
144: END IF;
145:
146: l_tax_classification_code := NULL;
147:

Line 175: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax',

171: end if;
172:
173: IF (g_level_statement >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_statement,
175: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax',
176: 'tax_classificaton_code => '||l_tax_classification_code);
177: FND_LOG.STRING(g_level_statement,
178: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax.END',
179: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_project_tax(-)');

Line 178: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax.END',

174: FND_LOG.STRING(g_level_statement,
175: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax',
176: 'tax_classificaton_code => '||l_tax_classification_code);
177: FND_LOG.STRING(g_level_statement,
178: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax.END',
179: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_project_tax(-)');
180: END IF;
181:
182:

Line 179: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_project_tax(-)');

175: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax',
176: 'tax_classificaton_code => '||l_tax_classification_code);
177: FND_LOG.STRING(g_level_statement,
178: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax.END',
179: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_project_tax(-)');
180: END IF;
181:
182:
183: return l_tax_classification_code;

Line 194: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax',

190: FND_MSG_PUB.Add;
191:
192: IF (g_level_unexpected >= g_current_runtime_level ) THEN
193: FND_LOG.STRING(g_level_unexpected,
194: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax',
195: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
196: END IF;
197: if tax_csr%isopen then
198: close tax_csr;

Line 261: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax.BEGIN',

257: BEGIN
258:
259: IF (g_level_statement >= g_current_runtime_level ) THEN
260: FND_LOG.STRING(g_level_statement,
261: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax.BEGIN',
262: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_expenditure_tax(+)');
263: END IF;
264:
265: --

Line 262: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_expenditure_tax(+)');

258:
259: IF (g_level_statement >= g_current_runtime_level ) THEN
260: FND_LOG.STRING(g_level_statement,
261: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax.BEGIN',
262: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_expenditure_tax(+)');
263: END IF;
264:
265: --
266: -- Bug#5331994- add trx_date

Line 276: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax',

272: close tax_csr;
273:
274: IF (g_level_statement >= g_current_runtime_level ) THEN
275: FND_LOG.STRING(g_level_statement,
276: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax',
277: 'tax_code => '||l_output_tax_code);
278: FND_LOG.STRING(g_level_statement,
279: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax.END',
280: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_expenditure_tax(-)');

Line 279: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax.END',

275: FND_LOG.STRING(g_level_statement,
276: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax',
277: 'tax_code => '||l_output_tax_code);
278: FND_LOG.STRING(g_level_statement,
279: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax.END',
280: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_expenditure_tax(-)');
281: END IF;
282:
283:

Line 280: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_expenditure_tax(-)');

276: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax',
277: 'tax_code => '||l_output_tax_code);
278: FND_LOG.STRING(g_level_statement,
279: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax.END',
280: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_expenditure_tax(-)');
281: END IF;
282:
283:
284: return l_output_tax_code;

Line 295: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax',

291: FND_MSG_PUB.Add;
292:
293: IF (g_level_unexpected >= g_current_runtime_level ) THEN
294: FND_LOG.STRING(g_level_unexpected,
295: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax',
296: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
297: END IF;
298: if tax_csr%isopen then
299: close tax_csr;

Line 334: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax.BEGIN',

330: BEGIN
331:
332: IF (g_level_statement >= g_current_runtime_level ) THEN
333: FND_LOG.STRING(g_level_statement,
334: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax.BEGIN',
335: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_event_tax(+)');
336: END IF;
337:
338: l_output_tax_code := NULL;

Line 335: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_event_tax(+)');

331:
332: IF (g_level_statement >= g_current_runtime_level ) THEN
333: FND_LOG.STRING(g_level_statement,
334: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax.BEGIN',
335: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_event_tax(+)');
336: END IF;
337:
338: l_output_tax_code := NULL;
339:

Line 346: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax',

342: close tax_csr;
343:
344: IF (g_level_statement >= g_current_runtime_level ) THEN
345: FND_LOG.STRING(g_level_statement,
346: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax',
347: 'tax_code => '||l_output_tax_code);
348: FND_LOG.STRING(g_level_statement,
349: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax.END',
350: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_event_tax(-)');

Line 349: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax.END',

345: FND_LOG.STRING(g_level_statement,
346: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax',
347: 'tax_code => '||l_output_tax_code);
348: FND_LOG.STRING(g_level_statement,
349: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax.END',
350: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_event_tax(-)');
351: END IF;
352:
353:

Line 350: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_event_tax(-)');

346: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax',
347: 'tax_code => '||l_output_tax_code);
348: FND_LOG.STRING(g_level_statement,
349: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax.END',
350: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_event_tax(-)');
351: END IF;
352:
353:
354: return l_output_tax_code;

Line 365: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax',

361: FND_MSG_PUB.Add;
362:
363: IF (g_level_unexpected >= g_current_runtime_level ) THEN
364: FND_LOG.STRING(g_level_unexpected,
365: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax',
366: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
367: END IF;
368: if tax_csr%isopen then
369: close tax_csr;

Line 421: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.BEGIN',

417: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
418:
419: IF (g_level_statement >= g_current_runtime_level ) THEN
420: FND_LOG.STRING(g_level_statement,
421: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.BEGIN',
422: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(+)');
423: END IF;
424:
425: get_pa_default_classification

Line 422: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(+)');

418:
419: IF (g_level_statement >= g_current_runtime_level ) THEN
420: FND_LOG.STRING(g_level_statement,
421: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.BEGIN',
422: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(+)');
423: END IF;
424:
425: get_pa_default_classification
426: (p_project_id => p_project_id

Line 445: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',

441: ,p_internal_organization_id => p_internal_organization_id);
442:
443: IF (g_level_statement >= g_current_runtime_level ) THEN
444: FND_LOG.STRING(g_level_statement,
445: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',
446: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(-)');
447: END IF;
448:
449: EXCEPTION

Line 446: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(-)');

442:
443: IF (g_level_statement >= g_current_runtime_level ) THEN
444: FND_LOG.STRING(g_level_statement,
445: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',
446: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(-)');
447: END IF;
448:
449: EXCEPTION
450: WHEN OTHERS THEN

Line 458: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

454: FND_MSG_PUB.Add;
455:
456: IF (g_level_unexpected >= g_current_runtime_level ) THEN
457: FND_LOG.STRING(g_level_unexpected,
458: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
459: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
460: END IF;
461: RAISE ;
462: END get_pa_default_classification;

Line 516: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.BEGIN',

512: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
513:
514: IF (g_level_statement >= g_current_runtime_level ) THEN
515: FND_LOG.STRING(g_level_statement,
516: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.BEGIN',
517: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(+)');
518: END IF;
519:
520: l_party_flag := 'N';

Line 517: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(+)');

513:
514: IF (g_level_statement >= g_current_runtime_level ) THEN
515: FND_LOG.STRING(g_level_statement,
516: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.BEGIN',
517: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(+)');
518: END IF;
519:
520: l_party_flag := 'N';
521: l_site_use_id := nvl(p_ship_to_site_use_id, p_bill_to_site_use_id);

Line 547: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

543: AND NVL(sysinfo.pa_product_options_rec.use_tax_classification_flag,'N') = 'Y' THEN
544:
545: IF (g_level_statement >= g_current_runtime_level ) THEN
546: FND_LOG.STRING(g_level_statement,
547: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
548:
549: 'Initializing PA defaulting information');
550: END IF;
551:

Line 562: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

558: sysinfo.search_pa_hierarchy_tab(7) := sysinfo.pa_product_options_rec.def_option_hier_7_code;
559: ELSE
560: IF (g_level_statement >= g_current_runtime_level ) THEN
561: FND_LOG.STRING(g_level_statement,
562: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
563: 'Defaulting of Tax Classification is not enabled or defaulting options are not set');
564: FND_LOG.STRING(g_level_statement,
565: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',
566: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification()-' );

Line 565: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',

561: FND_LOG.STRING(g_level_statement,
562: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
563: 'Defaulting of Tax Classification is not enabled or defaulting options are not set');
564: FND_LOG.STRING(g_level_statement,
565: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',
566: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification()-' );
567: END IF;
568: return;
569: END IF;

Line 566: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification()-' );

562: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
563: 'Defaulting of Tax Classification is not enabled or defaulting options are not set');
564: FND_LOG.STRING(g_level_statement,
565: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',
566: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification()-' );
567: END IF;
568: return;
569: END IF;
570:

Line 589: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

585:
586: l_default_level := rtrim(sysinfo.search_pa_hierarchy_tab(i));
587: IF (g_level_statement >= g_current_runtime_level ) THEN
588: FND_LOG.STRING(g_level_statement,
589: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
590: '-- Search level = '||l_default_level);
591: END IF;
592:
593: IF (l_default_level = TAX_DEFAULT_CUSTOMER) THEN

Line 600: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

596: --
597: -- Bill_to_site_use_id
598: IF (g_level_statement >= g_current_runtime_level ) THEN
599: FND_LOG.STRING(g_level_statement,
600: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
601: 'get the customer level tax code using ship to information ...');
602: END IF;
603:
604: l_tax_classification_code := get_customer_tax(p_ship_to_site_use_id,

Line 611: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

607: -- Ship_to_site_use_id
608: IF l_tax_classification_code IS NULL THEN
609: IF (g_level_statement >= g_current_runtime_level ) THEN
610: FND_LOG.STRING(g_level_statement,
611: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
612: 'Cannot find tax code using ship to information. '||
613: 'Using bill to information instead');
614: END IF;
615:

Line 690: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

686: -- needs to be changed for this parameter
687:
688: IF (g_level_statement >= g_current_runtime_level ) THEN
689: FND_LOG.STRING(g_level_statement,
690: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
691: 'Calling PA_TAX_CLIENT_EXTN_DRV.get_tax_code');
692: END IF;
693:
694: PA_TAX_CLIENT_EXTN_DRV.get_tax_code(

Line 748: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',

744: END LOOP;
745:
746: IF (g_level_statement >= g_current_runtime_level ) THEN
747: FND_LOG.STRING(g_level_statement,
748: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',
749: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(-)');
750: END IF;
751:
752: EXCEPTION

Line 749: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(-)');

745:
746: IF (g_level_statement >= g_current_runtime_level ) THEN
747: FND_LOG.STRING(g_level_statement,
748: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification.END',
749: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_pa_default_classification(-)');
750: END IF;
751:
752: EXCEPTION
753: WHEN OTHERS THEN

Line 761: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',

757: FND_MSG_PUB.Add;
758:
759: IF (g_level_unexpected >= g_current_runtime_level ) THEN
760: FND_LOG.STRING(g_level_unexpected,
761: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
762: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
763: END IF;
764: RAISE ;
765: END get_pa_default_classification;

Line 982: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',

978: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
979:
980: IF (g_level_statement >= g_current_runtime_level ) THEN
981: FND_LOG.STRING(g_level_statement,
982: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
983: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification(+)');
984: FND_LOG.STRING(g_level_statement,
985: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
986: 'p_ship_to_site_use_id: '||to_char(p_ship_to_site_use_id));

Line 983: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification(+)');

979:
980: IF (g_level_statement >= g_current_runtime_level ) THEN
981: FND_LOG.STRING(g_level_statement,
982: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
983: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification(+)');
984: FND_LOG.STRING(g_level_statement,
985: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
986: 'p_ship_to_site_use_id: '||to_char(p_ship_to_site_use_id));
987: FND_LOG.STRING(g_level_statement,

Line 985: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

981: FND_LOG.STRING(g_level_statement,
982: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.BEGIN',
983: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification(+)');
984: FND_LOG.STRING(g_level_statement,
985: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
986: 'p_ship_to_site_use_id: '||to_char(p_ship_to_site_use_id));
987: FND_LOG.STRING(g_level_statement,
988: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
989: 'p_bill_to_site_use_id: '||to_char(p_bill_to_site_use_id));

Line 988: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

984: FND_LOG.STRING(g_level_statement,
985: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
986: 'p_ship_to_site_use_id: '||to_char(p_ship_to_site_use_id));
987: FND_LOG.STRING(g_level_statement,
988: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
989: 'p_bill_to_site_use_id: '||to_char(p_bill_to_site_use_id));
990: FND_LOG.STRING(g_level_statement,
991: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
992: 'p_inventory_item_id: '||to_char(p_inventory_item_id));

Line 991: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

987: FND_LOG.STRING(g_level_statement,
988: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
989: 'p_bill_to_site_use_id: '||to_char(p_bill_to_site_use_id));
990: FND_LOG.STRING(g_level_statement,
991: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
992: 'p_inventory_item_id: '||to_char(p_inventory_item_id));
993: FND_LOG.STRING(g_level_statement,
994: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
995: 'p_organization_id: '||to_char(p_organization_id));

Line 994: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

990: FND_LOG.STRING(g_level_statement,
991: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
992: 'p_inventory_item_id: '||to_char(p_inventory_item_id));
993: FND_LOG.STRING(g_level_statement,
994: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
995: 'p_organization_id: '||to_char(p_organization_id));
996: FND_LOG.STRING(g_level_statement,
997: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
998: 'p_set_of_books_id: '||to_char(p_set_of_books_id));

Line 997: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

993: FND_LOG.STRING(g_level_statement,
994: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
995: 'p_organization_id: '||to_char(p_organization_id));
996: FND_LOG.STRING(g_level_statement,
997: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
998: 'p_set_of_books_id: '||to_char(p_set_of_books_id));
999: FND_LOG.STRING(g_level_statement,
1000: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1001: 'p_trx_date: '||to_char(p_trx_date,'DD-MON-YYYY'));

Line 1000: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

996: FND_LOG.STRING(g_level_statement,
997: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
998: 'p_set_of_books_id: '||to_char(p_set_of_books_id));
999: FND_LOG.STRING(g_level_statement,
1000: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1001: 'p_trx_date: '||to_char(p_trx_date,'DD-MON-YYYY'));
1002: FND_LOG.STRING(g_level_statement,
1003: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1004: 'p_trx_type_id: '||to_char(p_trx_type_id));

Line 1003: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

999: FND_LOG.STRING(g_level_statement,
1000: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1001: 'p_trx_date: '||to_char(p_trx_date,'DD-MON-YYYY'));
1002: FND_LOG.STRING(g_level_statement,
1003: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1004: 'p_trx_type_id: '||to_char(p_trx_type_id));
1005: FND_LOG.STRING(g_level_statement,
1006: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1007: 'p_cust_trx_id: '||to_char(p_cust_trx_id));

Line 1006: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1002: FND_LOG.STRING(g_level_statement,
1003: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1004: 'p_trx_type_id: '||to_char(p_trx_type_id));
1005: FND_LOG.STRING(g_level_statement,
1006: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1007: 'p_cust_trx_id: '||to_char(p_cust_trx_id));
1008: FND_LOG.STRING(g_level_statement,
1009: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1010: 'p_cust_trx_line_id: '||to_char(p_cust_trx_line_id));

Line 1009: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1005: FND_LOG.STRING(g_level_statement,
1006: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1007: 'p_cust_trx_id: '||to_char(p_cust_trx_id));
1008: FND_LOG.STRING(g_level_statement,
1009: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1010: 'p_cust_trx_line_id: '||to_char(p_cust_trx_line_id));
1011: FND_LOG.STRING(g_level_statement,
1012: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1013: 'p_customer_id: '||to_char(p_customer_id));

Line 1012: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1008: FND_LOG.STRING(g_level_statement,
1009: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1010: 'p_cust_trx_line_id: '||to_char(p_cust_trx_line_id));
1011: FND_LOG.STRING(g_level_statement,
1012: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1013: 'p_customer_id: '||to_char(p_customer_id));
1014: FND_LOG.STRING(g_level_statement,
1015: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1016: 'p_memo_line_id: '||to_char(p_memo_line_id));

Line 1015: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1011: FND_LOG.STRING(g_level_statement,
1012: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1013: 'p_customer_id: '||to_char(p_customer_id));
1014: FND_LOG.STRING(g_level_statement,
1015: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1016: 'p_memo_line_id: '||to_char(p_memo_line_id));
1017: FND_LOG.STRING(g_level_statement,
1018: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1019: 'APPL_SHORT_NAME: '||APPL_SHORT_NAME);

Line 1018: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1014: FND_LOG.STRING(g_level_statement,
1015: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1016: 'p_memo_line_id: '||to_char(p_memo_line_id));
1017: FND_LOG.STRING(g_level_statement,
1018: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1019: 'APPL_SHORT_NAME: '||APPL_SHORT_NAME);
1020: FND_LOG.STRING(g_level_statement,
1021: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1022: 'FUNC_SHORT_NAME: '||FUNC_SHORT_NAME );

Line 1021: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1017: FND_LOG.STRING(g_level_statement,
1018: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1019: 'APPL_SHORT_NAME: '||APPL_SHORT_NAME);
1020: FND_LOG.STRING(g_level_statement,
1021: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1022: 'FUNC_SHORT_NAME: '||FUNC_SHORT_NAME );
1023: FND_LOG.STRING(g_level_statement,
1024: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1025: 'p_party_flag: '||p_party_flag);

Line 1024: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1020: FND_LOG.STRING(g_level_statement,
1021: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1022: 'FUNC_SHORT_NAME: '||FUNC_SHORT_NAME );
1023: FND_LOG.STRING(g_level_statement,
1024: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1025: 'p_party_flag: '||p_party_flag);
1026: FND_LOG.STRING(g_level_statement,
1027: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1028: 'p_party_location_id: '||p_party_location_id );

Line 1027: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1023: FND_LOG.STRING(g_level_statement,
1024: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1025: 'p_party_flag: '||p_party_flag);
1026: FND_LOG.STRING(g_level_statement,
1027: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1028: 'p_party_location_id: '||p_party_location_id );
1029: FND_LOG.STRING(g_level_statement,
1030: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1031: 'p_application_id == >'||TO_CHAR(p_application_id));

Line 1030: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1026: FND_LOG.STRING(g_level_statement,
1027: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1028: 'p_party_location_id: '||p_party_location_id );
1029: FND_LOG.STRING(g_level_statement,
1030: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1031: 'p_application_id == >'||TO_CHAR(p_application_id));
1032: FND_LOG.STRING(g_level_statement,
1033: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1034: 'p_internal_organization_id == >'||TO_CHAR(p_internal_organization_id));

Line 1033: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1029: FND_LOG.STRING(g_level_statement,
1030: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1031: 'p_application_id == >'||TO_CHAR(p_application_id));
1032: FND_LOG.STRING(g_level_statement,
1033: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1034: 'p_internal_organization_id == >'||TO_CHAR(p_internal_organization_id));
1035: END IF;
1036:
1037: v_tax_classification_code := NULL;

Line 1068: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1064: p_trx_type_id);
1065:
1066: IF (g_level_statement >= g_current_runtime_level ) THEN
1067: FND_LOG.STRING(g_level_statement,
1068: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1069: 'Tax_method is LATIN and Tax code is '|| v_tax_classification_code);
1070: FND_LOG.STRING(g_level_statement,
1071: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1072: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

Line 1071: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',

1067: FND_LOG.STRING(g_level_statement,
1068: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1069: 'Tax_method is LATIN and Tax code is '|| v_tax_classification_code);
1070: FND_LOG.STRING(g_level_statement,
1071: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1072: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1073: END IF;
1074: --
1075: -- Bug#5024478- return output to caller

Line 1072: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

1068: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1069: 'Tax_method is LATIN and Tax code is '|| v_tax_classification_code);
1070: FND_LOG.STRING(g_level_statement,
1071: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1072: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1073: END IF;
1074: --
1075: -- Bug#5024478- return output to caller
1076: --

Line 1113: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1109:
1110: if c_evnt_cls_options%NOTFOUND then
1111: IF (g_level_statement >= g_current_runtime_level ) THEN
1112: FND_LOG.STRING(g_level_statement,
1113: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1114: 'c_evnt_cls_options cursor not found !! Setting sysinfo.tax_enforce_account_flag to N');
1115: END IF;
1116:
1117: sysinfo.tax_enforce_account_flag := 'N';

Line 1122: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1118: end if;
1119:
1120: IF (g_level_statement >= g_current_runtime_level ) THEN
1121: FND_LOG.STRING(g_level_statement,
1122: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1123: 'c_evnt_cls_options.tax_enforce_account_flag = '||l_tax_enforce_account_flag);
1124: END IF;
1125:
1126: sysinfo.tax_enforce_account_flag := l_tax_enforce_account_flag;

Line 1137: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1133: when others then
1134:
1135: IF (g_level_statement >= g_current_runtime_level ) THEN
1136: FND_LOG.STRING(g_level_statement,
1137: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1138: 'Exception: '||SQLCODE||' ; '||SQLERRM||' Setting sysinfo.tax_enforce_account_flag to N');
1139: END IF;
1140: sysinfo.tax_enforce_account_flag := 'N';
1141: if c_evnt_cls_options%ISOPEN then

Line 1166: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1162:
1163: IF v_tax_classification_code IS NOT NULL THEN
1164: IF (g_level_statement >= g_current_runtime_level ) THEN
1165: FND_LOG.STRING(g_level_statement,
1166: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1167: 'Tax Classification code is '|| v_tax_classification_code);
1168: FND_LOG.STRING(g_level_statement,
1169: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1170: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

Line 1169: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',

1165: FND_LOG.STRING(g_level_statement,
1166: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1167: 'Tax Classification code is '|| v_tax_classification_code);
1168: FND_LOG.STRING(g_level_statement,
1169: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1170: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1171: END IF;
1172:
1173: p_tax_classification_code := v_tax_classification_code;

Line 1170: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

1166: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1167: 'Tax Classification code is '|| v_tax_classification_code);
1168: FND_LOG.STRING(g_level_statement,
1169: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1170: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1171: END IF;
1172:
1173: p_tax_classification_code := v_tax_classification_code;
1174: RETURN;

Line 1197: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1193: p_check_override_only=>'Y');
1194: IF v_tax_classification_code IS NOT NULL THEN
1195: IF (g_level_statement >= g_current_runtime_level ) THEN
1196: FND_LOG.STRING(g_level_statement,
1197: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1198: 'Tax Classification code is '|| v_tax_classification_code);
1199: FND_LOG.STRING(g_level_statement,
1200: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1201: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

Line 1200: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',

1196: FND_LOG.STRING(g_level_statement,
1197: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1198: 'Tax Classification code is '|| v_tax_classification_code);
1199: FND_LOG.STRING(g_level_statement,
1200: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1201: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1202: END IF;
1203:
1204: p_tax_classification_code := v_tax_classification_code;

Line 1201: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

1197: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1198: 'Tax Classification code is '|| v_tax_classification_code);
1199: FND_LOG.STRING(g_level_statement,
1200: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1201: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1202: END IF;
1203:
1204: p_tax_classification_code := v_tax_classification_code;
1205: RETURN;

Line 1226: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1222: OR sysinfo.ar_product_options_rec.def_option_hier_7_code IS NOT NULL) THEN
1223:
1224: IF (g_level_statement >= g_current_runtime_level ) THEN
1225: FND_LOG.STRING(g_level_statement,
1226: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1227: 'Initializing AR defaulting information');
1228: END IF;
1229:
1230: sysinfo.search_hierarchy_tab(1) := sysinfo.ar_product_options_rec.def_option_hier_1_code;

Line 1240: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1236: sysinfo.search_hierarchy_tab(7) := sysinfo.ar_product_options_rec.def_option_hier_7_code;
1237: ELSE
1238: IF (g_level_statement >= g_current_runtime_level ) THEN
1239: FND_LOG.STRING(g_level_statement,
1240: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1241: 'Defaulting of Tax Classification is not enabled or defaulting options are not set');
1242: FND_LOG.STRING(g_level_statement,
1243: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1244: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

Line 1243: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',

1239: FND_LOG.STRING(g_level_statement,
1240: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1241: 'Defaulting of Tax Classification is not enabled or defaulting options are not set');
1242: FND_LOG.STRING(g_level_statement,
1243: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1244: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1245: END IF;
1246: return;
1247: END IF;

Line 1244: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

1240: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1241: 'Defaulting of Tax Classification is not enabled or defaulting options are not set');
1242: FND_LOG.STRING(g_level_statement,
1243: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1244: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1245: END IF;
1246: return;
1247: END IF;
1248:

Line 1270: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1266:
1267: l_default_level := rtrim(sysinfo.search_hierarchy_tab(i));
1268: IF (g_level_statement >= g_current_runtime_level ) THEN
1269: FND_LOG.STRING(g_level_statement,
1270: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1271: '-- Search level = '||l_default_level);
1272: END IF;
1273: --crm
1274: IF (nvl(p_party_flag, 'N') = 'N') AND

Line 1387: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1383:
1384:
1385: IF (g_level_statement >= g_current_runtime_level ) THEN
1386: FND_LOG.STRING(g_level_statement,
1387: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1388: 'defaulting tax classification from system ');
1389: END IF;
1390:
1391: -- check if this tax calssification code is valid for the current

Line 1403: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1399: close c_chk_tax_classif_code;
1400:
1401: IF (g_level_statement >= g_current_runtime_level ) THEN
1402: FND_LOG.STRING(g_level_statement,
1403: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1404: 'Tax classification defaulted from system is: v_tax_classification_code');
1405: END IF;
1406:
1407:

Line 1431: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1427: p_tax_classification_code := v_tax_classification_code;
1428:
1429: IF (g_level_statement >= g_current_runtime_level ) THEN
1430: FND_LOG.STRING(g_level_statement,
1431: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1432: 'default_tax_classification: '||v_tax_classification_code);
1433: END IF;
1434:
1435: /* Bug#4406011

Line 1447: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',

1443: */
1444:
1445: IF (g_level_statement >= g_current_runtime_level ) THEN
1446: FND_LOG.STRING(g_level_statement,
1447: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1448: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1449: END IF;
1450:
1451: EXCEPTION

Line 1448: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );

1444:
1445: IF (g_level_statement >= g_current_runtime_level ) THEN
1446: FND_LOG.STRING(g_level_statement,
1447: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification.END',
1448: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_default_tax_classification()-' );
1449: END IF;
1450:
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN

Line 1455: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN
1453: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1454: FND_LOG.STRING(g_level_unexpected,
1455: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1456: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1457: END IF;
1458: RAISE;
1459: WHEN OTHERS THEN

Line 1466: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

1462: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1463: FND_MSG_PUB.Add;
1464: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1465: FND_LOG.STRING(g_level_unexpected,
1466: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1467: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1468: END IF;
1469: RAISE ;
1470: END get_default_tax_classification;

Line 1542: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.BEGIN',

1538: BEGIN
1539:
1540: IF (g_level_procedure >= g_current_runtime_level ) THEN
1541: FND_LOG.STRING(g_level_procedure,
1542: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.BEGIN',
1543: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_site_tax(+)');
1544: END IF;
1545:
1546: l_tax_classification_code := NULL;

Line 1543: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_site_tax(+)');

1539:
1540: IF (g_level_procedure >= g_current_runtime_level ) THEN
1541: FND_LOG.STRING(g_level_procedure,
1542: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.BEGIN',
1543: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_site_tax(+)');
1544: END IF;
1545:
1546: l_tax_classification_code := NULL;
1547:

Line 1560: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',

1556:
1557:
1558: IF (g_level_procedure >= g_current_runtime_level ) THEN
1559: FND_LOG.STRING(g_level_procedure,
1560: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1561: 'tax_classification_code = ' ||
1562: l_tax_classification_code);
1563: FND_LOG.STRING(g_level_procedure,
1564: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',

Line 1564: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',

1560: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1561: 'tax_classification_code = ' ||
1562: l_tax_classification_code);
1563: FND_LOG.STRING(g_level_procedure,
1564: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1565: 'l_return_status = ' || l_return_status);
1566: FND_LOG.STRING(g_level_procedure,
1567: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.END',
1568: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_site_tax(-)');

Line 1567: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.END',

1563: FND_LOG.STRING(g_level_procedure,
1564: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1565: 'l_return_status = ' || l_return_status);
1566: FND_LOG.STRING(g_level_procedure,
1567: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.END',
1568: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_site_tax(-)');
1569: END IF;
1570:
1571: RETURN l_tax_classification_code;

Line 1568: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_site_tax(-)');

1564: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1565: 'l_return_status = ' || l_return_status);
1566: FND_LOG.STRING(g_level_procedure,
1567: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax.END',
1568: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_site_tax(-)');
1569: END IF;
1570:
1571: RETURN l_tax_classification_code;
1572:

Line 1583: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',

1579: FND_MSG_PUB.Add;
1580:
1581: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1582: FND_LOG.STRING(g_level_unexpected,
1583: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1584: l_error_buffer);
1585: END IF;
1586:
1587:

Line 1671: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax.BEGIN',

1667: BEGIN
1668:
1669: IF (g_level_procedure >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_procedure,
1671: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax.BEGIN',
1672: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_customer_tax(+)');
1673: END IF;
1674:
1675: l_tax_classification_code := NULL;

Line 1672: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_customer_tax(+)');

1668:
1669: IF (g_level_procedure >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_procedure,
1671: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax.BEGIN',
1672: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_customer_tax(+)');
1673: END IF;
1674:
1675: l_tax_classification_code := NULL;
1676:

Line 1703: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',

1699: END IF;
1700:
1701: IF (g_level_procedure >= g_current_runtime_level ) THEN
1702: FND_LOG.STRING(g_level_procedure,
1703: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',
1704: 'tax_classification_code = ' ||
1705: l_tax_classification_code);
1706: FND_LOG.STRING(g_level_procedure,
1707: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',

Line 1707: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',

1703: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',
1704: 'tax_classification_code = ' ||
1705: l_tax_classification_code);
1706: FND_LOG.STRING(g_level_procedure,
1707: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',
1708: 'l_return_status = ' || l_return_status);
1709: FND_LOG.STRING(g_level_procedure,
1710: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax.END',
1711: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_customer_tax(-)');

Line 1710: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax.END',

1706: FND_LOG.STRING(g_level_procedure,
1707: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',
1708: 'l_return_status = ' || l_return_status);
1709: FND_LOG.STRING(g_level_procedure,
1710: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax.END',
1711: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_customer_tax(-)');
1712: END IF;
1713:
1714: RETURN l_tax_classification_code;

Line 1711: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_customer_tax(-)');

1707: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',
1708: 'l_return_status = ' || l_return_status);
1709: FND_LOG.STRING(g_level_procedure,
1710: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax.END',
1711: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_customer_tax(-)');
1712: END IF;
1713:
1714: RETURN l_tax_classification_code;
1715:

Line 1726: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',

1722: FND_MSG_PUB.Add;
1723:
1724: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1725: FND_LOG.STRING(g_level_unexpected,
1726: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',
1727: l_error_buffer);
1728: END IF;
1729:
1730: RAISE ;

Line 1822: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax.BEGIN',

1818: BEGIN
1819:
1820: IF (g_level_statement >= g_current_runtime_level ) THEN
1821: FND_LOG.STRING(g_level_statement,
1822: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax.BEGIN',
1823: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_item_tax()+' );
1824: END IF;
1825:
1826: -- IF ( sysinfo.sysparam.tax_use_prod_exc_rate_flag = 'Y' ) THEN

Line 1823: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_item_tax()+' );

1819:
1820: IF (g_level_statement >= g_current_runtime_level ) THEN
1821: FND_LOG.STRING(g_level_statement,
1822: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax.BEGIN',
1823: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_item_tax()+' );
1824: END IF;
1825:
1826: -- IF ( sysinfo.sysparam.tax_use_prod_exc_rate_flag = 'Y' ) THEN
1827: --

Line 1864: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax',

1860: -- END IF;
1861:
1862: IF (g_level_statement >= g_current_runtime_level ) THEN
1863: FND_LOG.STRING(g_level_statement,
1864: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax',
1865: '>>> O : Tax_classification_code = '||l_tax_classification_code);
1866: FND_LOG.STRING(g_level_statement,
1867: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax.END',
1868: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_item_tax()-' );

Line 1867: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax.END',

1863: FND_LOG.STRING(g_level_statement,
1864: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax',
1865: '>>> O : Tax_classification_code = '||l_tax_classification_code);
1866: FND_LOG.STRING(g_level_statement,
1867: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax.END',
1868: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_item_tax()-' );
1869: END IF;
1870:
1871: RETURN (l_tax_classification_code);

Line 1868: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_item_tax()-' );

1864: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax',
1865: '>>> O : Tax_classification_code = '||l_tax_classification_code);
1866: FND_LOG.STRING(g_level_statement,
1867: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax.END',
1868: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_item_tax()-' );
1869: END IF;
1870:
1871: RETURN (l_tax_classification_code);
1872:

Line 1882: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax',

1878: FND_MSG_PUB.Add;
1879:
1880: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1881: FND_LOG.STRING(g_level_unexpected,
1882: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax',
1883: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1884: END IF;
1885: IF (sel_memo_line_tax%ISOPEN) THEN
1886: CLOSE sel_memo_line_tax;

Line 1960: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.BEGIN',

1956: BEGIN
1957:
1958: IF (g_level_statement >= g_current_runtime_level ) THEN
1959: FND_LOG.STRING(g_level_statement,
1960: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.BEGIN',
1961: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()+' );
1962: FND_LOG.STRING(g_level_statement,
1963: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1964: 'p_site_use_id: '||to_char(p_site_use_id));

Line 1961: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()+' );

1957:
1958: IF (g_level_statement >= g_current_runtime_level ) THEN
1959: FND_LOG.STRING(g_level_statement,
1960: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.BEGIN',
1961: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()+' );
1962: FND_LOG.STRING(g_level_statement,
1963: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1964: 'p_site_use_id: '||to_char(p_site_use_id));
1965: FND_LOG.STRING(g_level_statement,

Line 1963: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

1959: FND_LOG.STRING(g_level_statement,
1960: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.BEGIN',
1961: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()+' );
1962: FND_LOG.STRING(g_level_statement,
1963: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1964: 'p_site_use_id: '||to_char(p_site_use_id));
1965: FND_LOG.STRING(g_level_statement,
1966: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1967: 'p_party_flag: '||p_party_flag);

Line 1966: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

1962: FND_LOG.STRING(g_level_statement,
1963: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1964: 'p_site_use_id: '||to_char(p_site_use_id));
1965: FND_LOG.STRING(g_level_statement,
1966: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1967: 'p_party_flag: '||p_party_flag);
1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1970: 'p_party_location_id: '||p_party_location_id);

Line 1969: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

1965: FND_LOG.STRING(g_level_statement,
1966: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1967: 'p_party_flag: '||p_party_flag);
1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1970: 'p_party_location_id: '||p_party_location_id);
1971: FND_LOG.STRING(g_level_statement,
1972: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1973: 'p_product: '||p_product);

Line 1972: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1970: 'p_party_location_id: '||p_party_location_id);
1971: FND_LOG.STRING(g_level_statement,
1972: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1973: 'p_product: '||p_product);
1974: END IF;
1975:
1976: l_tax_classification_code := NULL;

Line 1997: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

1993: END IF;
1994:
1995: IF (g_level_statement >= g_current_runtime_level ) THEN
1996: FND_LOG.STRING(g_level_statement,
1997: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
1998: 'Country code is : '||l_country);
1999: END IF;
2000:
2001: --

Line 2016: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

2012: END IF; -- Tax method is 'Sales Tax'?
2013:
2014: IF (g_level_statement >= g_current_runtime_level ) THEN
2015: FND_LOG.STRING(g_level_statement,
2016: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
2017: '>>> O : Tax_classification_code = '||l_tax_classification_code);
2018: FND_LOG.STRING(g_level_statement,
2019: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.END',
2020: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()-' );

Line 2019: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.END',

2015: FND_LOG.STRING(g_level_statement,
2016: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
2017: '>>> O : Tax_classification_code = '||l_tax_classification_code);
2018: FND_LOG.STRING(g_level_statement,
2019: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.END',
2020: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()-' );
2021: END IF;
2022:
2023: RETURN (l_tax_classification_code);

Line 2020: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()-' );

2016: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
2017: '>>> O : Tax_classification_code = '||l_tax_classification_code);
2018: FND_LOG.STRING(g_level_statement,
2019: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax.END',
2020: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_location_tax()-' );
2021: END IF;
2022:
2023: RETURN (l_tax_classification_code);
2024:

Line 2034: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

2030: FND_MSG_PUB.Add;
2031:
2032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_unexpected,
2034: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
2035: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2036: END IF;
2037:
2038: RAISE ;

Line 2093: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.BEGIN',

2089:
2090: BEGIN
2091: IF (g_level_statement >= g_current_runtime_level ) THEN
2092: FND_LOG.STRING(g_level_statement,
2093: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.BEGIN',
2094: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_natural_acct_tax(+)');
2095: END IF;
2096:
2097:

Line 2094: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_natural_acct_tax(+)');

2090: BEGIN
2091: IF (g_level_statement >= g_current_runtime_level ) THEN
2092: FND_LOG.STRING(g_level_statement,
2093: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.BEGIN',
2094: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_natural_acct_tax(+)');
2095: END IF;
2096:
2097:
2098: -- Get tax code from GL

Line 2109: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',

2105: ,p_override_flag => l_dummy );
2106:
2107: IF (g_level_statement >= g_current_runtime_level ) THEN
2108: FND_LOG.STRING(g_level_statement,
2109: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2110: '>>> O : Tax_classification_code = '||l_tax_classification_code);
2111: FND_LOG.STRING(g_level_statement,
2112: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2113: '>>> O : Override_flag = '||l_dummy);

Line 2112: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',

2108: FND_LOG.STRING(g_level_statement,
2109: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2110: '>>> O : Tax_classification_code = '||l_tax_classification_code);
2111: FND_LOG.STRING(g_level_statement,
2112: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2113: '>>> O : Override_flag = '||l_dummy);
2114: FND_LOG.STRING(g_level_statement,
2115: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.END',
2116: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_natural_acct_tax()-' );

Line 2115: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.END',

2111: FND_LOG.STRING(g_level_statement,
2112: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2113: '>>> O : Override_flag = '||l_dummy);
2114: FND_LOG.STRING(g_level_statement,
2115: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.END',
2116: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_natural_acct_tax()-' );
2117: END IF;
2118:
2119: RETURN l_tax_classification_code;

Line 2116: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_natural_acct_tax()-' );

2112: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2113: '>>> O : Override_flag = '||l_dummy);
2114: FND_LOG.STRING(g_level_statement,
2115: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.END',
2116: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_natural_acct_tax()-' );
2117: END IF;
2118:
2119: RETURN l_tax_classification_code;
2120:

Line 2130: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',

2126: FND_MSG_PUB.Add;
2127:
2128: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2129: FND_LOG.STRING(g_level_unexpected,
2130: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2131: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2132: END IF;
2133: RAISE ;
2134:

Line 2166: | ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax() |

2162: | and is valid for the set_of_books_id and trx_date. |
2163: | Override_flag: Y, If the GL setup allows override of tax code, else N.|
2164: | |
2165: | CALLED FROM |
2166: | ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax() |
2167: | ARP_PROCESS_TAX.Validate_tax_info() |
2168: | |
2169: | HISTORY |
2170: | 25-Jul-97 Mahesh Sabapathy Created. |

Line 2196: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.BEGIN',

2192: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2193:
2194: IF (g_level_statement >= g_current_runtime_level ) THEN
2195: FND_LOG.STRING(g_level_statement,
2196: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.BEGIN',
2197: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_gl_tax_info()+' );
2198: END IF;
2199:
2200: l_override_flag := NULL;

Line 2197: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_gl_tax_info()+' );

2193:
2194: IF (g_level_statement >= g_current_runtime_level ) THEN
2195: FND_LOG.STRING(g_level_statement,
2196: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.BEGIN',
2197: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_gl_tax_info()+' );
2198: END IF;
2199:
2200: l_override_flag := NULL;
2201: l_tax_classification_code := NULL;

Line 2260: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',

2256: End;';
2257:
2258: IF (g_level_statement >= g_current_runtime_level ) THEN
2259: FND_LOG.STRING(g_level_statement,
2260: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2261: '-- statement = '||statement);
2262: END IF;
2263:
2264: -- BugFix 936377

Line 2275: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',

2271: p_check_override_only ;
2272:
2273: IF (g_level_statement >= g_current_runtime_level ) THEN
2274: FND_LOG.STRING(g_level_statement,
2275: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2276: 'l_tax_classification_code '||l_tax_classification_code);
2277: END IF;
2278:
2279: p_tax_classification_code := l_tax_classification_code;

Line 2284: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',

2280: p_override_flag := l_override_flag;
2281:
2282: IF (g_level_statement >= g_current_runtime_level ) THEN
2283: FND_LOG.STRING(g_level_statement,
2284: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2285: '>>> O : Tax_classification_code = '||l_tax_classification_code);
2286: FND_LOG.STRING(g_level_statement,
2287: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2288: '>>> O : Override_flag = '||l_override_flag);

Line 2287: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',

2283: FND_LOG.STRING(g_level_statement,
2284: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2285: '>>> O : Tax_classification_code = '||l_tax_classification_code);
2286: FND_LOG.STRING(g_level_statement,
2287: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2288: '>>> O : Override_flag = '||l_override_flag);
2289: FND_LOG.STRING(g_level_statement,
2290: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.END',
2291: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_gl_tax_info()-' );

Line 2290: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.END',

2286: FND_LOG.STRING(g_level_statement,
2287: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2288: '>>> O : Override_flag = '||l_override_flag);
2289: FND_LOG.STRING(g_level_statement,
2290: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.END',
2291: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_gl_tax_info()-' );
2292: END IF;
2293:
2294: EXCEPTION

Line 2291: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_gl_tax_info()-' );

2287: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2288: '>>> O : Override_flag = '||l_override_flag);
2289: FND_LOG.STRING(g_level_statement,
2290: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.END',
2291: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: get_gl_tax_info()-' );
2292: END IF;
2293:
2294: EXCEPTION
2295: WHEN OTHERS THEN

Line 2303: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',

2299: FND_MSG_PUB.Add;
2300:
2301: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2302: FND_LOG.STRING(g_level_unexpected,
2303: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2304: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2305: END IF;
2306: RAISE;
2307:

Line 2371: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info.BEGIN',

2367: -- Get tax default Info
2368: --
2369: IF (g_level_statement >= g_current_runtime_level ) THEN
2370: FND_LOG.STRING(g_level_statement,
2371: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info.BEGIN',
2372: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_tax_info()+');
2373: END IF;
2374:
2375: -- init return status

Line 2372: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_tax_info()+');

2368: --
2369: IF (g_level_statement >= g_current_runtime_level ) THEN
2370: FND_LOG.STRING(g_level_statement,
2371: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info.BEGIN',
2372: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_tax_info()+');
2373: END IF;
2374:
2375: -- init return status
2376: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2439: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info.END',

2435: p_return_status);
2436:
2437: IF (g_level_statement >= g_current_runtime_level ) THEN
2438: FND_LOG.STRING(g_level_statement,
2439: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info.END',
2440: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_tax_info()-');
2441: END IF;
2442:
2443: EXCEPTION

Line 2440: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_tax_info()-');

2436:
2437: IF (g_level_statement >= g_current_runtime_level ) THEN
2438: FND_LOG.STRING(g_level_statement,
2439: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info.END',
2440: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_tax_info()-');
2441: END IF;
2442:
2443: EXCEPTION
2444: WHEN OTHERS THEN

Line 2456: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info',

2452: FND_MSG_PUB.Add;
2453:
2454: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2455: FND_LOG.STRING(g_level_unexpected,
2456: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info',
2457: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2458: END IF;
2459: END pop_ar_tax_info;
2460:

Line 2522: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info.BEGIN',

2518: --
2519:
2520: IF (g_level_statement >= g_current_runtime_level ) THEN
2521: FND_LOG.STRING(g_level_statement,
2522: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info.BEGIN',
2523: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_pa_tax_info()+');
2524: END IF;
2525:
2526: -- init return status

Line 2523: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_pa_tax_info()+');

2519:
2520: IF (g_level_statement >= g_current_runtime_level ) THEN
2521: FND_LOG.STRING(g_level_statement,
2522: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info.BEGIN',
2523: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_pa_tax_info()+');
2524: END IF;
2525:
2526: -- init return status
2527: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2591: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info.END',

2587: p_return_status);
2588:
2589: IF (g_level_statement >= g_current_runtime_level ) THEN
2590: FND_LOG.STRING(g_level_statement,
2591: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info.END',
2592: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_pa_tax_info()-');
2593: END IF;
2594:
2595: EXCEPTION

Line 2592: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_pa_tax_info()-');

2588:
2589: IF (g_level_statement >= g_current_runtime_level ) THEN
2590: FND_LOG.STRING(g_level_statement,
2591: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info.END',
2592: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_pa_tax_info()-');
2593: END IF;
2594:
2595: EXCEPTION
2596: WHEN OTHERS THEN

Line 2608: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info',

2604: FND_MSG_PUB.Add;
2605:
2606: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2607: FND_LOG.STRING(g_level_unexpected,
2608: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info',
2609: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2610: END IF;
2611: END pop_pa_tax_info;
2612:

Line 2646: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info.BEGIN',

2642: -- Get default country Info
2643: --
2644: IF (g_level_statement >= g_current_runtime_level ) THEN
2645: FND_LOG.STRING(g_level_statement,
2646: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info.BEGIN',
2647: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_system_param_info()+');
2648: END IF;
2649:
2650: -- init return status

Line 2647: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_system_param_info()+');

2643: --
2644: IF (g_level_statement >= g_current_runtime_level ) THEN
2645: FND_LOG.STRING(g_level_statement,
2646: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info.BEGIN',
2647: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_system_param_info()+');
2648: END IF;
2649:
2650: -- init return status
2651: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2663: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info',

2659: CLOSE c_ar_system_param;
2660:
2661: IF (g_level_statement >= g_current_runtime_level ) THEN
2662: FND_LOG.STRING(g_level_statement,
2663: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info',
2664: 'default country: ' || sysinfo.sysparam.default_country);
2665: FND_LOG.STRING(g_level_statement,
2666: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info.END',
2667: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_system_param_info()-');

Line 2666: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info.END',

2662: FND_LOG.STRING(g_level_statement,
2663: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info',
2664: 'default country: ' || sysinfo.sysparam.default_country);
2665: FND_LOG.STRING(g_level_statement,
2666: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info.END',
2667: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_system_param_info()-');
2668: END IF;
2669:
2670: EXCEPTION

Line 2667: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_system_param_info()-');

2663: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info',
2664: 'default country: ' || sysinfo.sysparam.default_country);
2665: FND_LOG.STRING(g_level_statement,
2666: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info.END',
2667: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: pop_ar_system_param_info()-');
2668: END IF;
2669:
2670: EXCEPTION
2671: WHEN OTHERS THEN

Line 2683: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info',

2679: FND_MSG_PUB.Add;
2680:
2681: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2682: FND_LOG.STRING(g_level_unexpected,
2683: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info',
2684: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2685: END IF;
2686: END pop_ar_system_param_info;
2687:

Line 2720: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.Initialize.BEGIN',

2716: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2717:
2718: IF (g_level_statement >= g_current_runtime_level ) THEN
2719: FND_LOG.STRING(g_level_statement,
2720: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.Initialize.BEGIN',
2721: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: Initialize()+');
2722: END IF;
2723:
2724: sysinfo.pa_product_options_rec.ORG_ID := NULL;

Line 2721: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: Initialize()+');

2717:
2718: IF (g_level_statement >= g_current_runtime_level ) THEN
2719: FND_LOG.STRING(g_level_statement,
2720: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.Initialize.BEGIN',
2721: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: Initialize()+');
2722: END IF;
2723:
2724: sysinfo.pa_product_options_rec.ORG_ID := NULL;
2725: sysinfo.ar_product_options_rec.ORG_ID := NULL;

Line 2741: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',

2737:
2738: if l_master_org_id is NULL then
2739: IF (g_level_procedure >= g_current_runtime_level ) THEN
2740: FND_LOG.STRING(g_level_procedure,
2741: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
2742: 'Error Getting OE MASTER_ORGANIZATION ID using mo_global.get_current_org_id');
2743: END IF;
2744: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551
2745: APP_EXCEPTION.raise_exception;

Line 2761: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize- '||

2757: EXCEPTION
2758: WHEN OTHERS THEN
2759: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2760: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
2761: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize- '||
2762: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2763: FND_MSG_PUB.Add;
2764:
2765: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 2767: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize', 'Error Getting GL Natural Account Segment');

2763: FND_MSG_PUB.Add;
2764:
2765: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2766: FND_LOG.STRING(g_level_unexpected,
2767: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize', 'Error Getting GL Natural Account Segment');
2768: FND_LOG.STRING(g_level_unexpected,
2769: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
2770: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2771: END IF;

Line 2769: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',

2765: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2766: FND_LOG.STRING(g_level_unexpected,
2767: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize', 'Error Getting GL Natural Account Segment');
2768: FND_LOG.STRING(g_level_unexpected,
2769: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
2770: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2771: END IF;
2772:
2773: /******* Bug#4655710

Line 2777: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',

2773: /******* Bug#4655710
2774: WHEN OTHERS THEN
2775: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2776: FND_LOG.STRING(g_level_unexpected,
2777: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
2778: 'Error Getting GL Natural Account Segment');
2779: END IF;
2780:
2781: RAISE;

Line 2788: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize.END',

2784: END;
2785:
2786: IF (g_level_statement >= g_current_runtime_level ) THEN
2787: FND_LOG.STRING(g_level_statement,
2788: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize.END',
2789: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: Initialize()-');
2790: END IF;
2791:
2792: END initialize;

Line 2789: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: Initialize()-');

2785:
2786: IF (g_level_statement >= g_current_runtime_level ) THEN
2787: FND_LOG.STRING(g_level_statement,
2788: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize.END',
2789: 'ZX_AR_TAX_CLASSIFICATN_DEF_PKG: Initialize()-');
2790: END IF;
2791:
2792: END initialize;
2793:

Line 2815: END ZX_AR_TAX_CLASSIFICATN_DEF_PKG;

2811: BEGIN
2812:
2813: initialize;
2814:
2815: END ZX_AR_TAX_CLASSIFICATN_DEF_PKG;
2816: