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.POR_TAX_PVT dependencies on FND_LOG

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

3:
4:
5: -- Logging Static Variables
6: G_CURRENT_RUNTIME_LEVEL NUMBER;
7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

4:
5: -- Logging Static Variables
6: G_CURRENT_RUNTIME_LEVEL NUMBER;
7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

5: -- Logging Static Variables
6: G_CURRENT_RUNTIME_LEVEL NUMBER;
7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_TAX_PVT';

Line 10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

6: G_CURRENT_RUNTIME_LEVEL NUMBER;
7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_TAX_PVT';
14:

Line 11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_TAX_PVT';
14:
15:

Line 12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_TAX_PVT';
14:
15:
16: PROCEDURE calculate_tax (p_tax_head_tbl IN POR_TAX_HEADER_OBJ_TBL_TYPE,

Line 48: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

44: WHERE hzps.party_site_id = ship_from_party_site_id;
45:
46: -- Logging Infra
47: l_procedure_name CONSTANT VARCHAR2(30) := 'calculate_tax';
48: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
49:
50: --Bug 7412966 : Changed the code to calculate the rec and non-rec tax in functional currency
51: CURSOR c_get_tax IS
52: SELECT trx_line_dist_id,

Line 62: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

58: BEGIN
59: l_progress := 0;
60:
61: -- Logging Infra: Setting up runtime level
62: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
63:
64: -- Logging Infra: Procedure level
65: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
66: l_log_msg := '<-------------------->';

Line 67: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

63:
64: -- Logging Infra: Procedure level
65: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
66: l_log_msg := '<-------------------->';
67: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
68: l_log_msg := l_procedure_name||'(+)';
69: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
70: END IF;
71:

Line 69: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

65: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
66: l_log_msg := '<-------------------->';
67: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
68: l_log_msg := l_procedure_name||'(+)';
69: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
70: END IF;
71:
72: -- delete from ZX_TRX_HEADERS_GT
73: DELETE ZX_TRX_HEADERS_GT;

Line 80: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

76:
77: -- Logging Infra: Statement level
78: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
79: l_log_msg := 'Deleted ZX_TRX_HEADERS_GT';
80: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
81: END IF;
82:
83: -- get legal entity id
84: l_legal_entity_id := XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_tax_head_tbl(1).org_id);

Line 89: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

85:
86: -- Logging Infra: Statement level
87: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
88: l_log_msg := 'XLE Legal Entity=' || l_legal_entity_id;
89: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
90: END IF;
91:
92: l_progress := 200;
93:

Line 129: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

125:
126: -- Logging Infra: Statement level
127: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
128: l_log_msg := 'Inserted into ZX_TRX_HEADERS_GT';
129: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
130: END IF;
131:
132: -- delete from ZX_TRANSACTION_LINES_GT
133: DELETE ZX_TRANSACTION_LINES_GT;

Line 140: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

136:
137: -- Logging Infra: Statement level
138: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
139: l_log_msg := 'Deleted from ZX_TRANSACTION_LINES_GT';
140: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
141: END IF;
142:
143: -- insert into ZX Lines global temp table
144: i := 1;

Line 165: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

161: END IF;
162:
163: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
164: l_log_msg := 'ship_from_location_id: ' || ship_from_location_id;
165: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
166: END IF;
167:
168: INSERT INTO ZX_TRANSACTION_LINES_GT( application_id,
169: entity_code,

Line 264: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

260:
261: -- Logging Infra: Statement level
262: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
263: l_log_msg := 'Inserted record into ZX_TRANSACTION_LINES_GT.';
264: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
265: l_log_msg := '>>> LineId=' || p_tax_line_tbl(i).trx_line_id || '; OverrideFlag=' || p_tax_line_tbl(i).user_override_flag;
266: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
267: END IF;
268:

Line 266: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

262: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
263: l_log_msg := 'Inserted record into ZX_TRANSACTION_LINES_GT.';
264: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
265: l_log_msg := '>>> LineId=' || p_tax_line_tbl(i).trx_line_id || '; OverrideFlag=' || p_tax_line_tbl(i).user_override_flag;
266: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
267: END IF;
268:
269: i := i + 1;
270: EXIT WHEN (i > tbl_sz);

Line 283: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

279:
280: -- Logging Infra: Statement level
281: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
282: l_log_msg := 'Deleted ZX_ITM_DISTRIBUTIONS_GT';
283: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
284: END IF;
285:
286: -- insert into ZX Distributions global temp table
287: i := 1;

Line 341: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

337:
338: -- Logging Infra: Statement level
339: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
340: l_log_msg := 'Inserted record into ZX_ITM_DISTRIBUTIONS_GT. DistId=' || p_tax_dist_tbl(i).trx_line_dist_id;
341: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
342: END IF;
343:
344: i := i + 1;
345: EXIT WHEN (i > tbl_sz);

Line 353: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

349:
350: -- Logging Infra: Statement level
351: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
352: l_log_msg := 'ZX calculate_tax(+)';
353: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
354: END IF;
355:
356: -- Now calculate the tax
357: zx_api_pub.calculate_tax(p_api_version => 1.0,

Line 368: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

364:
365: -- Logging Infra: Statement level
366: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
367: l_log_msg := 'ZX calculate_tax returned status=' || l_return_status;
368: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
369: l_log_msg := 'ZX calculate_tax(-)';
370: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
371: END IF;
372:

Line 370: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

366: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
367: l_log_msg := 'ZX calculate_tax returned status=' || l_return_status;
368: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
369: l_log_msg := 'ZX calculate_tax(-)';
370: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
371: END IF;
372:
373: l_progress := 800;
374:

Line 385: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

381:
382: -- Logging Infra: Statement level
383: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
384: l_log_msg := 'ZX determine_recovery(+)';
385: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
386: END IF;
387:
388: -- Now determine the recovery
389: zx_api_pub.determine_recovery(p_api_version => 1.0,

Line 400: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

396:
397: -- Logging Infra: Statement level
398: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
399: l_log_msg := 'ZX determine_recovery returned status=' || l_return_status;
400: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
401: l_log_msg := 'ZX determine_recovery(-)';
402: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
403: END IF;
404:

Line 402: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

398: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
399: l_log_msg := 'ZX determine_recovery returned status=' || l_return_status;
400: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
401: l_log_msg := 'ZX determine_recovery(-)';
402: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
403: END IF;
404:
405: l_progress := 900;
406:

Line 437: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

433:
434: -- Logging Infra: Statement level
435: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
436: l_log_msg := 'Tax=' || l_dist_id || ':' || l_recov_tax || ':' || l_non_recov_tax;
437: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
438: END IF;
439:
440: i := i+1;
441: END LOOP;

Line 450: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

446: -- Logging Infra: Statement level
447: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
448: i := i-1;
449: l_log_msg := 'Found tax for ' || i || ' distributions.';
450: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
451: END IF;
452: END IF;
453:
454: -- Logging Infra: Procedure level

Line 457: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

453:
454: -- Logging Infra: Procedure level
455: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
456: l_log_msg := l_procedure_name||'(-)';
457: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
458: l_log_msg := '<-------------------->';
459: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
460: END IF;
461:

Line 459: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

455: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
456: l_log_msg := l_procedure_name||'(-)';
457: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
458: l_log_msg := '<-------------------->';
459: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
460: END IF;
461:
462: EXCEPTION
463: WHEN OTHERS THEN

Line 524: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

520: WHERE hzps.party_site_id = ship_from_party_site_id;
521:
522: -- Logging Infra
523: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_tax_attributes';
524: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
525:
526: CURSOR c_tax_head IS
527: SELECT default_taxation_country,
528: document_sub_type

Line 549: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

545:
546: l_progress := 0;
547:
548: -- Logging Infra: Setting up runtime level
549: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
550:
551: -- Logging Infra: Procedure level
552: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
553: l_log_msg := '<-------------------->';

Line 554: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

550:
551: -- Logging Infra: Procedure level
552: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
553: l_log_msg := '<-------------------->';
554: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
555: l_log_msg := l_procedure_name||'(+)';
556: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
557: END IF;
558:

Line 556: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

552: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
553: l_log_msg := '<-------------------->';
554: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
555: l_log_msg := l_procedure_name||'(+)';
556: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
557: END IF;
558:
559: -- get legal entity id
560: l_legal_entity_id := XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_tax_head_tbl(1).org_id);

Line 565: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

561:
562: -- Logging Infra: Statement level
563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
564: l_log_msg := 'XLE Legal Entity=' || l_legal_entity_id;
565: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
566: END IF;
567:
568: l_progress := 100;
569:

Line 587: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

583:
584: -- Logging Infra: Statement level
585: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
586: l_log_msg := 'Input lines table size=' || tbl_sz;
587: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
588: END IF;
589:
590: LOOP
591:

Line 596: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

592: IF (i=1) THEN
593: -- Logging Infra: Statement level
594: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
595: l_log_msg := 'Inserting into ZX_TRX_HEADERS_GT';
596: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
597: END IF;
598:
599: -- insert into ZX Headers global temp table
600: INSERT INTO ZX_TRX_HEADERS_GT (internal_organization_id,

Line 634: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

630:
631: -- Logging Infra: Statement level
632: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
633: l_log_msg := 'Inserting into ZX_TRANSACTION_LINES_GT';
634: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
635: l_log_msg := '--> Defaulting attribute is ship_to_loc_org_id=' || p_tax_line_tbl(i).product_org_id;
636: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
637: END IF;
638:

Line 636: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

632: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
633: l_log_msg := 'Inserting into ZX_TRANSACTION_LINES_GT';
634: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
635: l_log_msg := '--> Defaulting attribute is ship_to_loc_org_id=' || p_tax_line_tbl(i).product_org_id;
636: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
637: END IF;
638:
639: IF (l_ship_from_party_site_id = p_tax_line_tbl(i).ship_from_party_site_id) THEN
640: ship_from_location_id := l_ship_from_location_id;

Line 655: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

651: END IF;
652:
653: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
654: l_log_msg := 'ship_from_location_id: ' || ship_from_location_id;
655: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
656: END IF;
657:
658: INSERT INTO ZX_TRANSACTION_LINES_GT(application_id,
659: entity_code,

Line 761: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

757:
758: -- Logging Infra: Statement level
759: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
760: l_log_msg := 'ZX get_default_tax_det_attribs(+)';
761: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
762: END IF;
763:
764: -- Now get the default tax attibutes
765: zx_api_pub.get_default_tax_det_attribs(p_api_version => 1.0,

Line 778: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

774:
775: -- Logging Infra: Statement level
776: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
777: l_log_msg := 'ZX get_default_tax_det_attribs returned status=' || l_return_status;
778: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
779: l_log_msg := 'ZX get_default_tax_det_attribs(-)';
780: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
781: END IF;
782:

Line 780: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

776: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
777: l_log_msg := 'ZX get_default_tax_det_attribs returned status=' || l_return_status;
778: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
779: l_log_msg := 'ZX get_default_tax_det_attribs(-)';
780: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
781: END IF;
782:
783: x_msg_count := l_msg_count;
784: x_msg_data := l_msg_data;

Line 797: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

793:
794: -- Logging Infra: Statement level
795: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
796: l_log_msg := 'DEFAULT: tax_country=' || x_tax_country;
797: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
798: l_log_msg := 'DEFAULT: doc_subtype=' || x_doc_subtype;
799: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
800: END IF;
801:

Line 799: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

795: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
796: l_log_msg := 'DEFAULT: tax_country=' || x_tax_country;
797: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
798: l_log_msg := 'DEFAULT: doc_subtype=' || x_doc_subtype;
799: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
800: END IF;
801:
802: -- Query the tax line attributes from the global temp table
803: i := 1;

Line 822: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

818:
819: -- Logging Infra: Statement level
820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
821: l_log_msg := 'DEFAULT: req line id=' || l_line_id;
822: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
823: l_log_msg := 'DEFAULT: business_cat=' || l_trx_business_cat;
824: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
825: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
826: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 824: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
821: l_log_msg := 'DEFAULT: req line id=' || l_line_id;
822: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
823: l_log_msg := 'DEFAULT: business_cat=' || l_trx_business_cat;
824: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
825: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
826: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
827: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
828: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 826: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

822: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
823: l_log_msg := 'DEFAULT: business_cat=' || l_trx_business_cat;
824: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
825: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
826: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
827: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
828: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
829: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
830: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 828: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

824: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
825: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
826: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
827: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
828: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
829: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
830: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
831: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
832: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 830: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

826: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
827: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
828: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
829: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
830: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
831: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
832: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
833: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
834: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 832: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

828: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
829: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
830: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
831: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
832: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
833: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
834: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
835: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
836: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 834: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

830: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
831: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
832: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
833: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
834: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
835: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
836: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
837: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
838: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 836: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

832: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
833: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
834: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
835: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
836: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
837: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
838: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
839: l_log_msg := 'DEFAULT: override_flag=' || l_user_override_flag;
840: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 838: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

834: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
835: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
836: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
837: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
838: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
839: l_log_msg := 'DEFAULT: override_flag=' || l_user_override_flag;
840: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
841: END IF;
842:

Line 840: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

836: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
837: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
838: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
839: l_log_msg := 'DEFAULT: override_flag=' || l_user_override_flag;
840: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
841: END IF;
842:
843: IF (i=1) THEN
844: -- Initialize the tables

Line 887: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

883:
884: -- Logging Infra: Procedure level
885: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
886: l_log_msg := l_procedure_name||'(-)';
887: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
888: l_log_msg := '<-------------------->';
889: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
890: END IF;
891:

Line 889: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

885: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
886: l_log_msg := l_procedure_name||'(-)';
887: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
888: l_log_msg := '<-------------------->';
889: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
890: END IF;
891:
892: EXCEPTION
893: WHEN OTHERS THEN

Line 919: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

915: l_progress PLS_INTEGER;
916:
917: -- Logging Infra
918: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_all_tax_lines';
919: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
920:
921: BEGIN
922:
923: l_progress := 0;

Line 926: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

922:
923: l_progress := 0;
924:
925: -- Logging Infra: Setting up runtime level
926: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
927:
928: -- Logging Infra: Procedure level
929: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
930: l_log_msg := '<-------------------->';

Line 931: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

927:
928: -- Logging Infra: Procedure level
929: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
930: l_log_msg := '<-------------------->';
931: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
932: l_log_msg := l_procedure_name||'(+)';
933: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
934: END IF;
935:

Line 933: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

929: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
930: l_log_msg := '<-------------------->';
931: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
932: l_log_msg := l_procedure_name||'(+)';
933: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
934: END IF;
935:
936: -- populate l_transaction_rec
937: l_transaction_rec.internal_organization_id := p_org_id;

Line 947: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

943:
944: -- Logging Infra: Statement level
945: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
946: l_log_msg := 'Deleting record for trx_id=' || p_trx_id;
947: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
948: l_log_msg := 'ZX global_document_update(+)';
949: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
950: END IF;
951:

Line 949: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

945: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
946: l_log_msg := 'Deleting record for trx_id=' || p_trx_id;
947: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
948: l_log_msg := 'ZX global_document_update(+)';
949: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
950: END IF;
951:
952: -- this will delete all tax attribute records for this requisition
953: zx_api_pub.global_document_update(p_api_version => 1.0,

Line 967: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

963:
964: -- Logging Infra: Statement level
965: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
966: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
967: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
968: l_log_msg := 'ZX global_document_update(-)';
969: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
970: END IF;
971:

Line 969: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

965: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
966: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
967: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
968: l_log_msg := 'ZX global_document_update(-)';
969: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
970: END IF;
971:
972: x_msg_count := l_msg_count;
973: x_msg_data := l_msg_data;

Line 979: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

975:
976: -- Logging Infra: Procedure level
977: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
978: l_log_msg := l_procedure_name||'(-)';
979: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
980: l_log_msg := '<-------------------->';
981: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
982: END IF;
983:

Line 981: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

977: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
978: l_log_msg := l_procedure_name||'(-)';
979: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
980: l_log_msg := '<-------------------->';
981: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
982: END IF;
983:
984: COMMIT;
985:

Line 1029: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1025: WHERE hzps.party_site_id = ship_from_party_site_id;
1026:
1027: -- Logging Infra
1028: l_procedure_name CONSTANT VARCHAR2(30) := 'insert_line_det_attr';
1029: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1030:
1031: BEGIN
1032:
1033: l_progress := 0;

Line 1036: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1032:
1033: l_progress := 0;
1034:
1035: -- Logging Infra: Setting up runtime level
1036: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1037:
1038: -- Logging Infra: Procedure level
1039: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1040: l_log_msg := '<-------------------->';

Line 1041: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1037:
1038: -- Logging Infra: Procedure level
1039: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1040: l_log_msg := '<-------------------->';
1041: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1042: l_log_msg := l_procedure_name||'(+)';
1043: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1044: END IF;
1045:

Line 1043: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1039: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1040: l_log_msg := '<-------------------->';
1041: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1042: l_log_msg := l_procedure_name||'(+)';
1043: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1044: END IF;
1045:
1046: -- get legal entity id
1047: l_legal_entity_id := XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_tax_info_tbl(1).org_id);

Line 1052: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1048:
1049: -- Logging Infra: Statement level
1050: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1051: l_log_msg := 'XLE Legal Entity=' || l_legal_entity_id;
1052: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1053: END IF;
1054:
1055: l_progress := 50;
1056:

Line 1068: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1064:
1065: -- Logging Infra: Statement level
1066: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1067: l_log_msg := 'Deleting record for trx_id=' || p_tax_info_tbl(1).trx_id;
1068: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1069: l_log_msg := 'ZX global_document_update(+)';
1070: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1071: END IF;
1072:

Line 1070: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1066: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1067: l_log_msg := 'Deleting record for trx_id=' || p_tax_info_tbl(1).trx_id;
1068: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1069: l_log_msg := 'ZX global_document_update(+)';
1070: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1071: END IF;
1072:
1073: -- this will delete all tax attribute records for this requisition
1074: zx_api_pub.global_document_update(p_api_version => 1.0,

Line 1088: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1084:
1085: -- Logging Infra: Statement level
1086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1087: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
1088: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1089: l_log_msg := 'ZX global_document_update(-)';
1090: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1091: END IF;
1092:

Line 1090: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1087: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
1088: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1089: l_log_msg := 'ZX global_document_update(-)';
1090: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1091: END IF;
1092:
1093: x_msg_count := l_msg_count;
1094: x_msg_data := l_msg_data;

Line 1120: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1116: END IF;
1117:
1118: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1119: l_log_msg := 'ship_from_location_id: ' || ship_from_location_id;
1120: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1121: END IF;
1122:
1123: -- EBTax initialization procedure
1124: ZX_GLOBAL_STRUCTURES_PKG.INIT_TRX_LINE_DIST_TBL(i);

Line 1245: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1241:
1242: -- Logging Infra: Statement level
1243: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1244: l_log_msg := 'Inserted record into ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl for trx_line_id=' || p_tax_info_tbl(1).trx_line_id;
1245: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1246: END IF;
1247:
1248: i := i + 1;
1249: EXIT WHEN (i > tbl_sz);

Line 1265: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1261:
1262: -- Logging Infra: Statement level
1263: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1264: l_log_msg := 'ZX insert_line_det_factors(+)';
1265: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1266: END IF;
1267:
1268: -- this will insert the tax determining factors into the EBTax tables
1269: zx_api_pub.insert_line_det_factors(p_api_version => 1.0,

Line 1282: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1278:
1279: -- Logging Infra: Statement level
1280: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1281: l_log_msg := 'ZX insert_line_det_factors returned status=' || l_return_status;
1282: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1283: l_log_msg := 'ZX insert_line_det_factors(-)';
1284: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1285: END IF;
1286:

Line 1284: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1280: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1281: l_log_msg := 'ZX insert_line_det_factors returned status=' || l_return_status;
1282: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1283: l_log_msg := 'ZX insert_line_det_factors(-)';
1284: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1285: END IF;
1286:
1287: x_msg_count := x_msg_count + l_msg_count;
1288: x_msg_data := x_msg_data || ':' || l_msg_data;

Line 1294: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1290:
1291: -- Logging Infra: Procedure level
1292: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1293: l_log_msg := l_procedure_name||'(-)';
1294: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1295: l_log_msg := '<-------------------->';
1296: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1297: END IF;
1298:

Line 1296: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

1292: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1293: l_log_msg := l_procedure_name||'(-)';
1294: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1295: l_log_msg := '<-------------------->';
1296: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1297: END IF;
1298:
1299: COMMIT;
1300:

Line 1330: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1326: l_progress PLS_INTEGER;
1327:
1328: -- Logging Infra
1329: l_procedure_name CONSTANT VARCHAR2(30) := 'copy_tax_attributes';
1330: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1331:
1332: BEGIN
1333:
1334: l_progress := 0;

Line 1337: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1333:
1334: l_progress := 0;
1335:
1336: -- Logging Infra: Setting up runtime level
1337: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1338:
1339: -- Logging Infra: Procedure level
1340: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1341: l_log_msg := '<-------------------->';

Line 1342: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1338:
1339: -- Logging Infra: Procedure level
1340: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1341: l_log_msg := '<-------------------->';
1342: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1343: l_log_msg := l_procedure_name||'(+)';
1344: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1345: END IF;
1346:

Line 1344: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1340: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1341: l_log_msg := '<-------------------->';
1342: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1343: l_log_msg := l_procedure_name||'(+)';
1344: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1345: END IF;
1346:
1347: -- get legal entity id
1348: l_legal_entity_id := XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_tax_copy_tbl(1).org_id);

Line 1353: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1349:
1350: -- Logging Infra: Statement level
1351: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1352: l_log_msg := 'XLE Legal Entity=' || l_legal_entity_id;
1353: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1354: END IF;
1355:
1356: l_progress := 50;
1357:

Line 1412: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1408:
1409: -- Logging Infra: Procedure level
1410: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1411: l_log_msg := 'Inserted record into ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl';
1412: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1413: l_log_msg := '--> source id=' || p_tax_copy_tbl(i).source_trx_id || ':' || p_tax_copy_tbl(i).source_line_id;
1414: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1415: l_log_msg := '--> dest id=' || p_tax_copy_tbl(i).trx_id || ':' || p_tax_copy_tbl(i).trx_line_id;
1416: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 1414: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1410: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1411: l_log_msg := 'Inserted record into ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl';
1412: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1413: l_log_msg := '--> source id=' || p_tax_copy_tbl(i).source_trx_id || ':' || p_tax_copy_tbl(i).source_line_id;
1414: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1415: l_log_msg := '--> dest id=' || p_tax_copy_tbl(i).trx_id || ':' || p_tax_copy_tbl(i).trx_line_id;
1416: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1417: END IF;
1418:

Line 1416: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

1412: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1413: l_log_msg := '--> source id=' || p_tax_copy_tbl(i).source_trx_id || ':' || p_tax_copy_tbl(i).source_line_id;
1414: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1415: l_log_msg := '--> dest id=' || p_tax_copy_tbl(i).trx_id || ':' || p_tax_copy_tbl(i).trx_line_id;
1416: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1417: END IF;
1418:
1419: i := i + 1;
1420: EXIT WHEN (i > tbl_sz);

Line 1443: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

1439:
1440: -- Logging Infra: Procedure level
1441: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1442: l_log_msg := l_procedure_name||'(-)';
1443: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1444: l_log_msg := '<-------------------->';
1445: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1446: END IF;
1447:

Line 1445: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1441: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1442: l_log_msg := l_procedure_name||'(-)';
1443: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1444: l_log_msg := '<-------------------->';
1445: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1446: END IF;
1447:
1448: COMMIT;
1449: