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: PROCEDURE calculate_tax (p_tax_head_tbl IN POR_TAX_HEADER_OBJ_TBL_TYPE,

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: PROCEDURE calculate_tax (p_tax_head_tbl IN POR_TAX_HEADER_OBJ_TBL_TYPE,
16: p_tax_line_tbl IN POR_TAX_LINE_OBJ_TBL_TYPE,

Line 42: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

38:
39:
40: -- Logging Infra
41: l_procedure_name CONSTANT VARCHAR2(30) := 'calculate_tax';
42: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
43:
44: --Bug 7412966 : Changed the code to calculate the rec and non-rec tax in functional currency
45: CURSOR c_get_tax IS
46: SELECT trx_line_dist_id,

Line 56: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

52: BEGIN
53: l_progress := 0;
54:
55: -- Logging Infra: Setting up runtime level
56: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
57:
58: -- Logging Infra: Procedure level
59: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
60: l_log_msg := '<-------------------->';

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

57:
58: -- Logging Infra: Procedure level
59: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
60: l_log_msg := '<-------------------->';
61: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
62: l_log_msg := l_procedure_name||'(+)';
63: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
64: END IF;
65:

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

59: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
60: l_log_msg := '<-------------------->';
61: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
62: l_log_msg := l_procedure_name||'(+)';
63: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
64: END IF;
65:
66: -- delete from ZX_TRX_HEADERS_GT
67: DELETE ZX_TRX_HEADERS_GT;

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

70:
71: -- Logging Infra: Statement level
72: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
73: l_log_msg := 'Deleted ZX_TRX_HEADERS_GT';
74: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
75: END IF;
76:
77: -- get legal entity id
78: l_legal_entity_id := XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_tax_head_tbl(1).org_id);

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

79:
80: -- Logging Infra: Statement level
81: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
82: l_log_msg := 'XLE Legal Entity=' || l_legal_entity_id;
83: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
84: END IF;
85:
86: l_progress := 200;
87:

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

119:
120: -- Logging Infra: Statement level
121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
122: l_log_msg := 'Inserted into ZX_TRX_HEADERS_GT';
123: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
124: END IF;
125:
126: -- delete from ZX_TRANSACTION_LINES_GT
127: DELETE ZX_TRANSACTION_LINES_GT;

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

130:
131: -- Logging Infra: Statement level
132: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
133: l_log_msg := 'Deleted from ZX_TRANSACTION_LINES_GT';
134: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
135: END IF;
136:
137: -- insert into ZX Lines global temp table
138: i := 1;

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

143: LOOP
144:
145: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
146: l_log_msg := 'Getting the Account_CCID for the Line ID >>> '|| p_tax_line_tbl(i).trx_line_id;
147: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
148: END IF;
149:
150: LOOP
151: IF (p_tax_line_tbl(i).trx_line_id=p_tax_dist_tbl(j).trx_line_id) THEN --- bug 12769270 changed condition from trx_id to trx_line_id

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

151: IF (p_tax_line_tbl(i).trx_line_id=p_tax_dist_tbl(j).trx_line_id) THEN --- bug 12769270 changed condition from trx_id to trx_line_id
152: acc_ccid := p_tax_dist_tbl(j).account_ccid;
153: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
154: l_log_msg := 'Account_CCID >>> '||acc_ccid||' for the Line ID >>> '|| p_tax_line_tbl(i).trx_line_id;
155: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
156: END IF;
157: EXIT;
158: END IF;
159: j := j+1;

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

266:
267: -- Logging Infra: Statement level
268: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
269: l_log_msg := 'Inserted record into ZX_TRANSACTION_LINES_GT.';
270: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
271: l_log_msg := '>>> LineId=' || p_tax_line_tbl(i).trx_line_id || '; OverrideFlag=' || p_tax_line_tbl(i).user_override_flag;
272: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
273: END IF;
274:

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

268: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
269: l_log_msg := 'Inserted record into ZX_TRANSACTION_LINES_GT.';
270: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
271: l_log_msg := '>>> LineId=' || p_tax_line_tbl(i).trx_line_id || '; OverrideFlag=' || p_tax_line_tbl(i).user_override_flag;
272: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
273: END IF;
274:
275: i := i + 1;
276: EXIT WHEN (i > tbl_sz_line);

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

285:
286: -- Logging Infra: Statement level
287: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
288: l_log_msg := 'Deleted ZX_ITM_DISTRIBUTIONS_GT';
289: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
290: END IF;
291:
292: -- insert into ZX Distributions global temp table
293: i := 1;

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

343:
344: -- Logging Infra: Statement level
345: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
346: l_log_msg := 'Inserted record into ZX_ITM_DISTRIBUTIONS_GT. DistId=' || p_tax_dist_tbl(i).trx_line_dist_id;
347: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
348: END IF;
349:
350: i := i + 1;
351: EXIT WHEN (i > tbl_sz_dist);

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

355:
356: -- Logging Infra: Statement level
357: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
358: l_log_msg := 'ZX calculate_tax(+)';
359: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
360: END IF;
361:
362: -- Now calculate the tax
363: zx_api_pub.calculate_tax(p_api_version => 1.0,

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

370:
371: -- Logging Infra: Statement level
372: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
373: l_log_msg := 'ZX calculate_tax returned status=' || l_return_status;
374: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
375: l_log_msg := 'ZX calculate_tax(-)';
376: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
377: END IF;
378:

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

372: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
373: l_log_msg := 'ZX calculate_tax returned status=' || l_return_status;
374: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
375: l_log_msg := 'ZX calculate_tax(-)';
376: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
377: END IF;
378:
379: l_progress := 800;
380:

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

387:
388: -- Logging Infra: Statement level
389: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
390: l_log_msg := 'ZX determine_recovery(+)';
391: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
392: END IF;
393:
394: -- Now determine the recovery
395: zx_api_pub.determine_recovery(p_api_version => 1.0,

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

402:
403: -- Logging Infra: Statement level
404: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
405: l_log_msg := 'ZX determine_recovery returned status=' || l_return_status;
406: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
407: l_log_msg := 'ZX determine_recovery(-)';
408: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
409: END IF;
410:

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

404: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
405: l_log_msg := 'ZX determine_recovery returned status=' || l_return_status;
406: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
407: l_log_msg := 'ZX determine_recovery(-)';
408: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
409: END IF;
410:
411: l_progress := 900;
412:

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

439:
440: -- Logging Infra: Statement level
441: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
442: l_log_msg := 'Tax=' || l_dist_id || ':' || l_recov_tax || ':' || l_non_recov_tax;
443: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
444: END IF;
445:
446: i := i+1;
447: END LOOP;

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

452: -- Logging Infra: Statement level
453: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
454: i := i-1;
455: l_log_msg := 'Found tax for ' || i || ' distributions.';
456: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
457: END IF;
458: END IF;
459:
460: -- Logging Infra: Procedure level

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

459:
460: -- Logging Infra: Procedure level
461: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
462: l_log_msg := l_procedure_name||'(-)';
463: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
464: l_log_msg := '<-------------------->';
465: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
466: END IF;
467:

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

461: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
462: l_log_msg := l_procedure_name||'(-)';
463: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
464: l_log_msg := '<-------------------->';
465: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
466: END IF;
467:
468: EXCEPTION
469: WHEN OTHERS THEN

Line 526: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 551: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

634: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
635: l_log_msg := 'Inserting into ZX_TRANSACTION_LINES_GT';
636: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
637: l_log_msg := '--> Defaulting attribute is ship_to_loc_org_id=' || p_tax_line_tbl(i).product_org_id;
638: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
639: END IF;
640:
641: --- bug 13024005 start
642:

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

776:
777: -- Logging Infra: Statement level
778: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
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: -- Now get the default tax attibutes
784: zx_api_pub.get_default_tax_det_attribs(p_api_version => 1.0,

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 := 'ZX get_default_tax_det_attribs returned status=' || l_return_status;
797: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
798: l_log_msg := 'ZX get_default_tax_det_attribs(-)';
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 := 'ZX get_default_tax_det_attribs returned status=' || l_return_status;
797: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
798: l_log_msg := 'ZX get_default_tax_det_attribs(-)';
799: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
800: END IF;
801:
802: x_msg_count := l_msg_count;
803: x_msg_data := l_msg_data;

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

812:
813: -- Logging Infra: Statement level
814: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
815: l_log_msg := 'DEFAULT: tax_country=' || x_tax_country;
816: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
817: l_log_msg := 'DEFAULT: doc_subtype=' || x_doc_subtype;
818: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
819: END IF;
820:

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

814: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
815: l_log_msg := 'DEFAULT: tax_country=' || x_tax_country;
816: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
817: l_log_msg := 'DEFAULT: doc_subtype=' || x_doc_subtype;
818: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
819: END IF;
820:
821: -- Query the tax line attributes from the global temp table
822: i := 1;

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

837:
838: -- Logging Infra: Statement level
839: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
840: l_log_msg := 'DEFAULT: req line id=' || l_line_id;
841: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
842: l_log_msg := 'DEFAULT: business_cat=' || l_trx_business_cat;
843: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
844: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
845: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

839: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
840: l_log_msg := 'DEFAULT: req line id=' || l_line_id;
841: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
842: l_log_msg := 'DEFAULT: business_cat=' || l_trx_business_cat;
843: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
844: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
845: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
846: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
847: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

841: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
842: l_log_msg := 'DEFAULT: business_cat=' || l_trx_business_cat;
843: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
844: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
845: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
846: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
847: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
848: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
849: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

843: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
844: l_log_msg := 'DEFAULT: intended_use=' || l_intended_use;
845: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
846: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
847: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
848: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
849: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
850: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
851: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

845: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
846: l_log_msg := 'DEFAULT: user_fisc_class=' || l_user_fiscal_class;
847: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
848: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
849: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
850: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
851: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
852: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
853: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

847: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
848: l_log_msg := 'DEFAULT: prod_fisc_class=' || l_prod_fiscal_class;
849: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
850: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
851: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
852: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
853: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
854: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
855: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

849: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
850: l_log_msg := 'DEFAULT: prod_category=' || l_product_category;
851: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
852: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
853: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
854: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
855: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
856: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
857: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

851: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
852: l_log_msg := 'DEFAULT: prod_type=' || l_product_type;
853: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
854: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
855: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
856: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
857: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
858: l_log_msg := 'DEFAULT: override_flag=' || l_user_override_flag;
859: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

853: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
854: l_log_msg := 'DEFAULT: assessable_value=' || l_assessable_value;
855: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
856: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
857: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
858: l_log_msg := 'DEFAULT: override_flag=' || l_user_override_flag;
859: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
860: END IF;
861:

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

855: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
856: l_log_msg := 'DEFAULT: tax_classification=' || l_tax_class_code;
857: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
858: l_log_msg := 'DEFAULT: override_flag=' || l_user_override_flag;
859: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
860: END IF;
861:
862: IF (i=1) THEN
863: -- Initialize the tables

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

902:
903: -- Logging Infra: Procedure level
904: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
905: l_log_msg := l_procedure_name||'(-)';
906: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
907: l_log_msg := '<-------------------->';
908: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
909: END IF;
910:

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

904: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
905: l_log_msg := l_procedure_name||'(-)';
906: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
907: l_log_msg := '<-------------------->';
908: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
909: END IF;
910:
911: EXCEPTION
912: WHEN OTHERS THEN

Line 938: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

934: l_progress PLS_INTEGER;
935:
936: -- Logging Infra
937: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_all_tax_lines';
938: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
939:
940: BEGIN
941:
942: l_progress := 0;

Line 945: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

941:
942: l_progress := 0;
943:
944: -- Logging Infra: Setting up runtime level
945: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
946:
947: -- Logging Infra: Procedure level
948: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
949: l_log_msg := '<-------------------->';

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

946:
947: -- Logging Infra: Procedure level
948: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
949: l_log_msg := '<-------------------->';
950: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
951: l_log_msg := l_procedure_name||'(+)';
952: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
953: END IF;
954:

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

948: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
949: l_log_msg := '<-------------------->';
950: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
951: l_log_msg := l_procedure_name||'(+)';
952: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
953: END IF;
954:
955: -- populate l_transaction_rec
956: l_transaction_rec.internal_organization_id := p_org_id;

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

962:
963: -- Logging Infra: Statement level
964: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
965: l_log_msg := 'Deleting record for trx_id=' || p_trx_id;
966: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
967: l_log_msg := 'ZX global_document_update(+)';
968: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
969: END IF;
970:

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

964: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
965: l_log_msg := 'Deleting record for trx_id=' || p_trx_id;
966: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
967: l_log_msg := 'ZX global_document_update(+)';
968: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
969: END IF;
970:
971: -- this will delete all tax attribute records for this requisition
972: zx_api_pub.global_document_update(p_api_version => 1.0,

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

982:
983: -- Logging Infra: Statement level
984: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
985: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
986: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
987: l_log_msg := 'ZX global_document_update(-)';
988: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
989: END IF;
990:

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

984: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
985: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
986: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
987: l_log_msg := 'ZX global_document_update(-)';
988: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
989: END IF;
990:
991: x_msg_count := l_msg_count;
992: x_msg_data := l_msg_data;

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

994:
995: -- Logging Infra: Procedure level
996: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
997: l_log_msg := l_procedure_name||'(-)';
998: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
999: l_log_msg := '<-------------------->';
1000: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1001: END IF;
1002:

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

996: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
997: l_log_msg := l_procedure_name||'(-)';
998: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
999: l_log_msg := '<-------------------->';
1000: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1001: END IF;
1002:
1003: COMMIT;
1004:

Line 1040: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1036: l_progress PLS_INTEGER;
1037:
1038: -- Logging Infra
1039: l_procedure_name CONSTANT VARCHAR2(30) := 'insert_line_det_attr';
1040: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1041:
1042: BEGIN
1043:
1044: l_progress := 0;

Line 1047: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1043:
1044: l_progress := 0;
1045:
1046: -- Logging Infra: Setting up runtime level
1047: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1048:
1049: -- Logging Infra: Procedure level
1050: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1051: l_log_msg := '<-------------------->';

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

1048:
1049: -- Logging Infra: Procedure level
1050: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1051: l_log_msg := '<-------------------->';
1052: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1053: l_log_msg := l_procedure_name||'(+)';
1054: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1055: END IF;
1056:

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

1050: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1051: l_log_msg := '<-------------------->';
1052: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1053: l_log_msg := l_procedure_name||'(+)';
1054: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
1055: END IF;
1056:
1057: -- get legal entity id
1058: l_legal_entity_id := XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_tax_info_tbl(1).org_id);

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

1059:
1060: -- Logging Infra: Statement level
1061: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1062: l_log_msg := 'XLE Legal Entity=' || l_legal_entity_id;
1063: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1064: END IF;
1065:
1066: l_progress := 50;
1067:

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

1075:
1076: -- Logging Infra: Statement level
1077: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1078: l_log_msg := 'Deleting record for trx_id=' || p_tax_info_tbl(1).trx_id;
1079: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1080: l_log_msg := 'ZX global_document_update(+)';
1081: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1082: END IF;
1083:

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

1077: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1078: l_log_msg := 'Deleting record for trx_id=' || p_tax_info_tbl(1).trx_id;
1079: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1080: l_log_msg := 'ZX global_document_update(+)';
1081: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1082: END IF;
1083:
1084: -- this will delete all tax attribute records for this requisition
1085: zx_api_pub.global_document_update(p_api_version => 1.0,

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

1095:
1096: -- Logging Infra: Statement level
1097: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1098: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
1099: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1100: l_log_msg := 'ZX global_document_update(-)';
1101: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1102: END IF;
1103:

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

1097: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1098: l_log_msg := 'ZX global_document_update returned status=' || l_return_status;
1099: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1100: l_log_msg := 'ZX global_document_update(-)';
1101: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1102: END IF;
1103:
1104: x_msg_count := l_msg_count;
1105: x_msg_data := l_msg_data;

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

1244:
1245: -- Logging Infra: Statement level
1246: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1247: 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;
1248: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1249: END IF;
1250:
1251: i := i + 1;
1252: EXIT WHEN (i > tbl_sz);

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

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

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

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

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

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

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

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

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

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

Line 1333: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 1340: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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