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 FND_LOG

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

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;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8:
9: -- global variable to hold org_id of PA or AR

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

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;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8:
9: -- global variable to hold org_id of PA or AR
10: g_org_id NUMBER;

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

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8:
9: -- global variable to hold org_id of PA or AR
10: g_org_id NUMBER;
11:

Line 141: FND_LOG.STRING(g_level_statement,

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

Line 174: FND_LOG.STRING(g_level_statement,

170: l_tax_classification_code := l_tax_csr_rec.output_tax_code;
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',

Line 177: FND_LOG.STRING(g_level_statement,

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(-)');
180: END IF;
181:

Line 193: FND_LOG.STRING(g_level_unexpected,

189: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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

Line 260: FND_LOG.STRING(g_level_statement,

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

Line 275: FND_LOG.STRING(g_level_statement,

271: fetch tax_csr into l_output_tax_code;
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',

Line 278: FND_LOG.STRING(g_level_statement,

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(-)');
281: END IF;
282:

Line 294: FND_LOG.STRING(g_level_unexpected,

290: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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

Line 333: FND_LOG.STRING(g_level_statement,

329: l_output_tax_code zx_lines_det_factors.output_tax_classification_code%TYPE;
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:

Line 345: FND_LOG.STRING(g_level_statement,

341: fetch tax_csr into l_output_tax_code;
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',

Line 348: FND_LOG.STRING(g_level_statement,

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(-)');
351: END IF;
352:

Line 364: FND_LOG.STRING(g_level_unexpected,

360: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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

Line 417: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

413: ,p_internal_organization_id IN NUMBER) IS
414:
415: BEGIN
416:
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',

Line 420: FND_LOG.STRING(g_level_statement,

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

Line 444: FND_LOG.STRING(g_level_statement,

440: ,p_application_id => p_application_id
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:

Line 457: FND_LOG.STRING(g_level_unexpected,

453: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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 ;

Line 512: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

508: l_return_status VARCHAR2(80);
509: l_product VARCHAR2(2);
510:
511: 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',

Line 515: FND_LOG.STRING(g_level_statement,

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

Line 546: FND_LOG.STRING(g_level_statement,

542: OR sysinfo.pa_product_options_rec.def_option_hier_7_code IS NOT NULL)
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;

Line 561: FND_LOG.STRING(g_level_statement,

557: sysinfo.search_pa_hierarchy_tab(6) := sysinfo.pa_product_options_rec.def_option_hier_6_code;
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',

Line 564: FND_LOG.STRING(g_level_statement,

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()-' );
567: END IF;
568: return;

Line 588: FND_LOG.STRING(g_level_statement,

584: -- sysinfo.search_pa_hierarchy_tab(i) IS NOT NULL
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:

Line 599: FND_LOG.STRING(g_level_statement,

595: -- Get Customer level tax code
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:

Line 610: FND_LOG.STRING(g_level_statement,

606: p_trx_date);
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;

Line 689: FND_LOG.STRING(g_level_statement,

685: -- This API internally calls PA_CLIENT_EXTN_OUTPUT_TAX and it
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:

Line 747: FND_LOG.STRING(g_level_statement,

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

Line 760: FND_LOG.STRING(g_level_unexpected,

756: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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 ;

Line 978: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

974:
975: l_tax_enforce_account_flag zx_evnt_cls_options.enforce_tax_from_acct_flag%type;
976:
977: 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',

Line 981: FND_LOG.STRING(g_level_statement,

977: 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',

Line 984: FND_LOG.STRING(g_level_statement,

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,
988: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 987: FND_LOG.STRING(g_level_statement,

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));
990: FND_LOG.STRING(g_level_statement,
991: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 990: FND_LOG.STRING(g_level_statement,

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));
993: FND_LOG.STRING(g_level_statement,
994: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 993: FND_LOG.STRING(g_level_statement,

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));
996: FND_LOG.STRING(g_level_statement,
997: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 996: FND_LOG.STRING(g_level_statement,

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));
999: FND_LOG.STRING(g_level_statement,
1000: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 999: FND_LOG.STRING(g_level_statement,

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'));
1002: FND_LOG.STRING(g_level_statement,
1003: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1002: FND_LOG.STRING(g_level_statement,

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));
1005: FND_LOG.STRING(g_level_statement,
1006: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1005: FND_LOG.STRING(g_level_statement,

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));
1008: FND_LOG.STRING(g_level_statement,
1009: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1008: FND_LOG.STRING(g_level_statement,

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));
1011: FND_LOG.STRING(g_level_statement,
1012: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1011: FND_LOG.STRING(g_level_statement,

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));
1014: FND_LOG.STRING(g_level_statement,
1015: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1014: FND_LOG.STRING(g_level_statement,

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));
1017: FND_LOG.STRING(g_level_statement,
1018: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1017: FND_LOG.STRING(g_level_statement,

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);
1020: FND_LOG.STRING(g_level_statement,
1021: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1020: FND_LOG.STRING(g_level_statement,

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 );
1023: FND_LOG.STRING(g_level_statement,
1024: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1023: FND_LOG.STRING(g_level_statement,

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);
1026: FND_LOG.STRING(g_level_statement,
1027: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1026: FND_LOG.STRING(g_level_statement,

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 );
1029: FND_LOG.STRING(g_level_statement,
1030: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1029: FND_LOG.STRING(g_level_statement,

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));
1032: FND_LOG.STRING(g_level_statement,
1033: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',

Line 1032: FND_LOG.STRING(g_level_statement,

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));
1035: END IF;
1036:

Line 1067: FND_LOG.STRING(g_level_statement,

1063: p_trx_date,
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',

Line 1070: FND_LOG.STRING(g_level_statement,

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()-' );
1073: END IF;
1074: --

Line 1112: FND_LOG.STRING(g_level_statement,

1108: FETCH c_evnt_cls_options into l_tax_enforce_account_flag;
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:

Line 1121: FND_LOG.STRING(g_level_statement,

1117: sysinfo.tax_enforce_account_flag := 'N';
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:

Line 1136: FND_LOG.STRING(g_level_statement,

1132: EXCEPTION
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';

Line 1165: FND_LOG.STRING(g_level_statement,

1161: p_check_override_only=>'Y');
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',

Line 1168: FND_LOG.STRING(g_level_statement,

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()-' );
1171: END IF;
1172:

Line 1196: FND_LOG.STRING(g_level_statement,

1192: p_trx_date=>p_trx_date,
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',

Line 1199: FND_LOG.STRING(g_level_statement,

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()-' );
1202: END IF;
1203:

Line 1225: FND_LOG.STRING(g_level_statement,

1221: OR sysinfo.ar_product_options_rec.def_option_hier_6_code IS NOT NULL
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:

Line 1239: FND_LOG.STRING(g_level_statement,

1235: sysinfo.search_hierarchy_tab(6) := sysinfo.ar_product_options_rec.def_option_hier_6_code;
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',

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

Line 1269: FND_LOG.STRING(g_level_statement,

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

Line 1386: FND_LOG.STRING(g_level_statement,

1382: IF sysinfo.ar_product_options_rec.tax_classification_code is NOT NULL then
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:

Line 1402: FND_LOG.STRING(g_level_statement,

1398: into v_tax_classification_code;
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:

Line 1430: FND_LOG.STRING(g_level_statement,

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

Line 1446: FND_LOG.STRING(g_level_statement,

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

Line 1454: FND_LOG.STRING(g_level_unexpected,

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

Line 1465: FND_LOG.STRING(g_level_unexpected,

1461: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','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 ;

Line 1541: FND_LOG.STRING(g_level_procedure,

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

Line 1559: FND_LOG.STRING(g_level_procedure,

1555: CLOSE get_site_tax_info;
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,

Line 1563: FND_LOG.STRING(g_level_procedure,

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',
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',

Line 1566: FND_LOG.STRING(g_level_procedure,

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(-)');
1569: END IF;
1570:

Line 1582: FND_LOG.STRING(g_level_unexpected,

1578: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_site_tax- '|| l_error_buffer);
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:

Line 1670: FND_LOG.STRING(g_level_procedure,

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

Line 1702: FND_LOG.STRING(g_level_procedure,

1698: CLOSE sel_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,

Line 1706: FND_LOG.STRING(g_level_procedure,

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',
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',

Line 1709: FND_LOG.STRING(g_level_procedure,

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(-)');
1712: END IF;
1713:

Line 1725: FND_LOG.STRING(g_level_unexpected,

1721: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_customer_tax- '|| l_error_buffer);
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:

Line 1821: FND_LOG.STRING(g_level_statement,

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

Line 1863: FND_LOG.STRING(g_level_statement,

1859: END IF; -- Tax code not found and item_id passed?
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',

Line 1866: FND_LOG.STRING(g_level_statement,

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()-' );
1869: END IF;
1870:

Line 1881: FND_LOG.STRING(g_level_unexpected,

1877: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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

Line 1959: FND_LOG.STRING(g_level_statement,

1955:
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',

Line 1962: FND_LOG.STRING(g_level_statement,

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,
1966: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

Line 1965: FND_LOG.STRING(g_level_statement,

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);
1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

Line 1968: FND_LOG.STRING(g_level_statement,

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);
1971: FND_LOG.STRING(g_level_statement,
1972: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',

Line 1971: FND_LOG.STRING(g_level_statement,

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);
1974: END IF;
1975:

Line 1996: FND_LOG.STRING(g_level_statement,

1992: CLOSE sel_addr_country;
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:

Line 2015: FND_LOG.STRING(g_level_statement,

2011:
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',

Line 2018: FND_LOG.STRING(g_level_statement,

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()-' );
2021: END IF;
2022:

Line 2033: FND_LOG.STRING(g_level_unexpected,

2029: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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:

Line 2092: FND_LOG.STRING(g_level_statement,

2088: l_dummy CHAR;
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:

Line 2108: FND_LOG.STRING(g_level_statement,

2104: ,p_tax_classification_code => l_tax_classification_code
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',

Line 2111: FND_LOG.STRING(g_level_statement,

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);
2114: FND_LOG.STRING(g_level_statement,
2115: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax.END',

Line 2114: FND_LOG.STRING(g_level_statement,

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()-' );
2117: END IF;
2118:

Line 2129: FND_LOG.STRING(g_level_unexpected,

2125: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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 ;

Line 2192: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2188: statement varchar2(2000);
2189:
2190: BEGIN
2191:
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',

Line 2195: FND_LOG.STRING(g_level_statement,

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

Line 2259: FND_LOG.STRING(g_level_statement,

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

Line 2274: FND_LOG.STRING(g_level_statement,

2270: p_internal_organization_id,
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:

Line 2283: FND_LOG.STRING(g_level_statement,

2279: p_tax_classification_code := l_tax_classification_code;
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',

Line 2286: FND_LOG.STRING(g_level_statement,

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);
2289: FND_LOG.STRING(g_level_statement,
2290: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info.END',

Line 2289: FND_LOG.STRING(g_level_statement,

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()-' );
2292: END IF;
2293:

Line 2302: FND_LOG.STRING(g_level_unexpected,

2298: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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;

Line 2370: FND_LOG.STRING(g_level_statement,

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

Line 2438: FND_LOG.STRING(g_level_statement,

2434: pop_ar_system_param_info(p_internal_organization_id,
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:

Line 2455: FND_LOG.STRING(g_level_unexpected,

2451: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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;

Line 2521: FND_LOG.STRING(g_level_statement,

2517: -- Get System Info
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:

Line 2590: FND_LOG.STRING(g_level_statement,

2586: pop_ar_system_param_info(p_internal_organization_id,
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:

Line 2607: FND_LOG.STRING(g_level_unexpected,

2603: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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;

Line 2645: FND_LOG.STRING(g_level_statement,

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

Line 2662: FND_LOG.STRING(g_level_statement,

2658: INTO sysinfo.sysparam.default_country;
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',

Line 2665: FND_LOG.STRING(g_level_statement,

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()-');
2668: END IF;
2669:

Line 2682: FND_LOG.STRING(g_level_unexpected,

2678: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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;

Line 2716: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2712: l_sob_test gl_sets_of_books.set_of_books_id%type;
2713:
2714: BEGIN
2715:
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',

Line 2719: FND_LOG.STRING(g_level_statement,

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

Line 2740: FND_LOG.STRING(g_level_procedure,

2736: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', g_org_id);
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

Line 2766: FND_LOG.STRING(g_level_unexpected,

2762: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
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));

Line 2768: FND_LOG.STRING(g_level_unexpected,

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

Line 2776: FND_LOG.STRING(g_level_unexpected,

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

Line 2787: FND_LOG.STRING(g_level_statement,

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