eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on FND_LOG

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

1: PACKAGE BODY ZX_TRD_INTERNAL_SERVICES_PVT AS
2: /* $Header: zxmirecdmsrvpvtb.pls 120.132.12020000.8 2013/04/24 11:05:27 ssohal ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

2: /* $Header: zxmirecdmsrvpvtb.pls 120.132.12020000.8 2013/04/24 11:05:27 ssohal ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10:

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10:
11: TYPE index_amt_rec_type IS RECORD (

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

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10:
11: TYPE index_amt_rec_type IS RECORD (
12: tbl_index BINARY_INTEGER,

Line 9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10:
11: TYPE index_amt_rec_type IS RECORD (
12: tbl_index BINARY_INTEGER,
13: tbl_amt NUMBER);

Line 133: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

129: p_trx_line_dist_index);
130:
131: BEGIN
132:
133: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
134:
135: IF (g_level_procedure >= g_current_runtime_level ) THEN
136: FND_LOG.STRING(g_level_procedure,
137: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST.BEGIN',

Line 136: FND_LOG.STRING(g_level_procedure,

132:
133: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
134:
135: IF (g_level_procedure >= g_current_runtime_level ) THEN
136: FND_LOG.STRING(g_level_procedure,
137: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST.BEGIN',
138: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist(+)');
139: END IF;
140:

Line 148: FND_LOG.STRING(g_level_statement,

144: l_new_index := NULL;
145: l_total_count := 0;
146:
147: IF (g_level_statement >= g_current_runtime_level ) THEN
148: FND_LOG.STRING(g_level_statement,
149: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST',
150: 'p_rnd_begin_index = ' || p_rnd_begin_index||
151: 'p_rnd_end_index = ' || p_rnd_end_index);
152: END IF;

Line 166: FND_LOG.STRING(g_level_statement,

162:
163: l_total_count:= get_tax_distribution_cur%ROWCOUNT;
164:
165: IF (g_level_statement >= g_current_runtime_level ) THEN
166: FND_LOG.STRING(g_level_statement,
167: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST',
168: 'l_total_count = ' || l_total_count);
169: END IF;
170:

Line 184: FND_LOG.STRING(g_level_statement,

180: call recovery type applicability
181: */
182:
183: IF (g_level_statement >= g_current_runtime_level ) THEN
184: FND_LOG.STRING(g_level_statement,
185: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST',
186: 'first time calculation for this tax line and item dist');
187: END IF;
188:

Line 223: FND_LOG.STRING(g_level_statement,

219: p_error_buffer);
220:
221: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
222: IF (g_level_statement >= g_current_runtime_level ) THEN
223: FND_LOG.STRING(g_level_statement,
224: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
225: 'Incorrect return_status after calling ' ||
226: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref()'||p_return_status);
227: END IF;

Line 245: FND_LOG.STRING(g_level_statement,

241: p_error_buffer);
242:
243: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: IF (g_level_statement >= g_current_runtime_level ) THEN
245: FND_LOG.STRING(g_level_statement,
246: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
247: 'Incorrect return_status after calling ' ||
248: 'ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type()'||p_return_status);
249: END IF;

Line 269: FND_LOG.STRING(g_level_statement,

265: p_error_buffer);
266:
267: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
268: IF (g_level_statement >= g_current_runtime_level ) THEN
269: FND_LOG.STRING(g_level_statement,
270: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
271: 'Incorrect return_status after calling ' ||
272: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_tax_related_columns_sta()'||p_return_status);
273: END IF;

Line 290: FND_LOG.STRING(g_level_statement,

286: p_error_buffer);
287:
288: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: IF (g_level_statement >= g_current_runtime_level ) THEN
290: FND_LOG.STRING(g_level_statement,
291: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
292: 'Incorrect return_status after calling ' ||
293: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_tax_related_columns_var()'||p_return_status);
294: END IF;

Line 310: FND_LOG.STRING(g_level_statement,

306: p_error_buffer);
307:
308: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: IF (g_level_statement >= g_current_runtime_level ) THEN
310: FND_LOG.STRING(g_level_statement,
311: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
312: 'Incorrect return_status after calling ' ||
313: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns()'||p_return_status);
314: END IF;

Line 333: FND_LOG.STRING(g_level_statement,

329: p_return_status,
330: p_error_buffer);
331: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: IF (g_level_statement >= g_current_runtime_level ) THEN
333: FND_LOG.STRING(g_level_statement,
334: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
335: 'Incorrect return_status after calling ' ||
336: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate()'||p_return_status);
337: END IF;

Line 370: FND_LOG.STRING(g_level_statement,

366: THEN recovery rate determination need to be ran for D7 - D9.
367: */
368:
369: IF (g_level_statement >= g_current_runtime_level ) THEN
370: FND_LOG.STRING(g_level_statement,
371: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST',
372: 'tax dists have been determined before '||
373: 'p_rnd_begin_index = ' || p_rnd_begin_index||
374: 'p_rnd_end_index = ' || p_rnd_end_index);

Line 482: FND_LOG.STRING(g_level_statement,

478: p_error_buffer => p_error_buffer);
479:
480: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
481: IF (g_level_statement >= g_current_runtime_level ) THEN
482: FND_LOG.STRING(g_level_statement,
483: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
484: 'Incorrect return_status after calling ' ||
485: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()'||p_return_status);
486: END IF;

Line 555: FND_LOG.STRING(g_level_statement,

551: p_error_buffer);
552:
553: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
554: IF (g_level_statement >= g_current_runtime_level ) THEN
555: FND_LOG.STRING(g_level_statement,
556: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
557: 'Incorrect return_status after calling ' ||
558: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_tax_related_columns_var()'||p_return_status);
559: END IF;

Line 575: FND_LOG.STRING(g_level_statement,

571: p_error_buffer);
572:
573: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
574: IF (g_level_statement >= g_current_runtime_level ) THEN
575: FND_LOG.STRING(g_level_statement,
576: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
577: 'Incorrect return_status after calling ' ||
578: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns()'||p_return_status);
579: END IF;

Line 597: FND_LOG.STRING(g_level_statement,

593: p_return_status,
594: p_error_buffer);
595: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: IF (g_level_statement >= g_current_runtime_level ) THEN
597: FND_LOG.STRING(g_level_statement,
598: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
599: 'Incorrect return_status after calling ' ||
600: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate()'||p_return_status);
601: END IF;

Line 609: FND_LOG.STRING(g_level_procedure,

605:
606: END IF; -- no row found
607:
608: IF (g_level_procedure >= g_current_runtime_level ) THEN
609: FND_LOG.STRING(g_level_procedure,
610: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST.END',
611: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist (-)');
612: END IF;
613:

Line 620: FND_LOG.STRING(g_level_unexpected,

616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
618:
619: IF (g_level_unexpected >= g_current_runtime_level ) THEN
620: FND_LOG.STRING(g_level_unexpected,
621: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
622: p_error_buffer);
623: FND_LOG.STRING(g_level_unexpected,
624: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST.END',

Line 623: FND_LOG.STRING(g_level_unexpected,

619: IF (g_level_unexpected >= g_current_runtime_level ) THEN
620: FND_LOG.STRING(g_level_unexpected,
621: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
622: p_error_buffer);
623: FND_LOG.STRING(g_level_unexpected,
624: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST.END',
625: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist (-)');
626: END IF;
627:

Line 668: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

664:
665:
666: begin
667:
668: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
669: IF (g_level_procedure >= g_current_runtime_level ) THEN
670: FND_LOG.STRING(g_level_procedure,
671: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line.BEGIN',
672: 'ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line (+)');

Line 670: FND_LOG.STRING(g_level_procedure,

666: begin
667:
668: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
669: IF (g_level_procedure >= g_current_runtime_level ) THEN
670: FND_LOG.STRING(g_level_procedure,
671: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line.BEGIN',
672: 'ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line (+)');
673: END IF;
674:

Line 763: FND_LOG.STRING(g_level_procedure,

759:
760: p_rnd_end_index:= i-1;
761:
762: IF (g_level_procedure >= g_current_runtime_level ) THEN
763: FND_LOG.STRING(g_level_procedure,
764: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line.BEGIN',
765: 'ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line (-)');
766: END IF;
767:

Line 774: FND_LOG.STRING(g_level_unexpected,

770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
772:
773: IF (g_level_unexpected >= g_current_runtime_level ) THEN
774: FND_LOG.STRING(g_level_unexpected,
775: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line',
776: p_error_buffer);
777: FND_LOG.STRING(g_level_unexpected,
778: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line.END',

Line 777: FND_LOG.STRING(g_level_unexpected,

773: IF (g_level_unexpected >= g_current_runtime_level ) THEN
774: FND_LOG.STRING(g_level_unexpected,
775: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line',
776: p_error_buffer);
777: FND_LOG.STRING(g_level_unexpected,
778: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line.END',
779: 'ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line(-)');
780: END IF;
781:

Line 831: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

827: l_max_tax_dist_number NUMBER;
828:
829: BEGIN
830:
831: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
832:
833: IF (g_level_procedure >= g_current_runtime_level ) THEN
834: FND_LOG.STRING(g_level_procedure,
835: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.BEGIN',

Line 834: FND_LOG.STRING(g_level_procedure,

830:
831: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
832:
833: IF (g_level_procedure >= g_current_runtime_level ) THEN
834: FND_LOG.STRING(g_level_procedure,
835: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.BEGIN',
836: 'ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE(+)');
837: END IF;
838:

Line 880: FND_LOG.STRING(g_level_error,

876:
877: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
878: THEN
879: IF (g_level_error >= g_current_runtime_level ) THEN
880: FND_LOG.STRING(g_level_error,
881: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',
882: 'Incorrect return_status after calling ' ||
883: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied()');
884: FND_LOG.STRING(g_level_error,

Line 884: FND_LOG.STRING(g_level_error,

880: FND_LOG.STRING(g_level_error,
881: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',
882: 'Incorrect return_status after calling ' ||
883: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied()');
884: FND_LOG.STRING(g_level_error,
885: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type.END',
886: 'ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type(-)'||p_return_status);
887: END IF;
888: END IF;

Line 910: FND_LOG.STRING(g_level_error,

906:
907: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
908: THEN
909: IF (g_level_error >= g_current_runtime_level ) THEN
910: FND_LOG.STRING(g_level_error,
911: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',
912: 'Incorrect return_status after calling ' ||
913: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted()');
914: FND_LOG.STRING(g_level_error,

Line 914: FND_LOG.STRING(g_level_error,

910: FND_LOG.STRING(g_level_error,
911: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',
912: 'Incorrect return_status after calling ' ||
913: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted()');
914: FND_LOG.STRING(g_level_error,
915: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type.END',
916: 'ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type(-)'||p_return_status);
917: END IF;
918: END IF;

Line 955: FND_LOG.STRING(g_level_procedure,

951: IF get_tax_recovery_info_cur%NOTFOUND THEN
952: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953:
954: IF (g_level_procedure >= g_current_runtime_level ) THEN
955: FND_LOG.STRING(g_level_procedure,
956: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.END',
957: 'ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE(-)'||'error: can not find tax info for ' || l_tax_id);
958: END IF;
959: CLOSE get_tax_recovery_info_cur;

Line 1005: FND_LOG.STRING(g_level_statement,

1001:
1002: ELSE -- no recovery allowed
1003:
1004: IF (g_level_statement >= g_current_runtime_level ) THEN
1005: FND_LOG.STRING(g_level_statement,
1006: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE',
1007: 'No applicable recovery type found');
1008: END IF;
1009:

Line 1013: FND_LOG.STRING(g_level_statement,

1009:
1010: END IF;
1011: ELSE --provider calculated tax lines should be 100% non-recoverable.
1012: IF (g_level_statement >= g_current_runtime_level ) THEN
1013: FND_LOG.STRING(g_level_statement,
1014: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE',
1015: 'Provider calculated tax lines are 100% non-recoverable.');
1016: END IF;
1017:

Line 1026: FND_LOG.STRING(g_level_procedure,

1022: p_rec_nrec_dist_tbl(l_index).rec_nrec_tax_dist_number:= l_rec_nrec_tax_dist_number;
1023:
1024: IF (g_level_procedure >= g_current_runtime_level ) THEN
1025:
1026: FND_LOG.STRING(g_level_procedure,
1027: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.END',
1028: 'ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE(-)'||
1029: ' begin index = ' || p_rnd_end_index||
1030: ' end index = ' || p_rnd_end_index);

Line 1039: FND_LOG.STRING(g_level_unexpected,

1035: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1037:
1038: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1039: FND_LOG.STRING(g_level_unexpected,
1040: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE',
1041: p_error_buffer);
1042: FND_LOG.STRING(g_level_unexpected,
1043: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.END',

Line 1042: FND_LOG.STRING(g_level_unexpected,

1038: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1039: FND_LOG.STRING(g_level_unexpected,
1040: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE',
1041: p_error_buffer);
1042: FND_LOG.STRING(g_level_unexpected,
1043: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.END',
1044: 'ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE(-)');
1045: END IF;
1046:

Line 1061: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1057: p_error_buffer OUT NOCOPY VARCHAR2) IS
1058:
1059: BEGIN
1060:
1061: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1062:
1063: IF (g_level_procedure >= g_current_runtime_level ) THEN
1064: FND_LOG.STRING(g_level_procedure,
1065: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA.BEGIN',

Line 1064: FND_LOG.STRING(g_level_procedure,

1060:
1061: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1062:
1063: IF (g_level_procedure >= g_current_runtime_level ) THEN
1064: FND_LOG.STRING(g_level_procedure,
1065: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA.BEGIN',
1066: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA(+)');
1067: END IF;
1068:

Line 1253: FND_LOG.STRING(g_level_procedure,

1249:
1250: END LOOP; -- i in p_rnd_begin_index..p_rnd_end_index
1251:
1252: IF (g_level_procedure >= g_current_runtime_level ) THEN
1253: FND_LOG.STRING(g_level_procedure,
1254: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA.END',
1255: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA(-)');
1256: END IF;
1257:

Line 1264: FND_LOG.STRING(g_level_unexpected,

1260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1262:
1263: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1264: FND_LOG.STRING(g_level_unexpected,
1265: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA',
1266: p_error_buffer);
1267: FND_LOG.STRING(g_level_unexpected,
1268: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA.END',

Line 1267: FND_LOG.STRING(g_level_unexpected,

1263: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1264: FND_LOG.STRING(g_level_unexpected,
1265: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA',
1266: p_error_buffer);
1267: FND_LOG.STRING(g_level_unexpected,
1268: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA.END',
1269: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA(-)');
1270: END IF;
1271: END get_tax_related_columns_sta;

Line 1289: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1285: --l_period_name gl_period_statuses.period_name%TYPE := '';
1286:
1287: BEGIN
1288:
1289: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1290:
1291: IF (g_level_procedure >= g_current_runtime_level ) THEN
1292: FND_LOG.STRING(g_level_procedure,
1293: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.BEGIN',

Line 1292: FND_LOG.STRING(g_level_procedure,

1288:
1289: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1290:
1291: IF (g_level_procedure >= g_current_runtime_level ) THEN
1292: FND_LOG.STRING(g_level_procedure,
1293: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.BEGIN',
1294: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(+)');
1295: END IF;
1296: p_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 1305: FND_LOG.STRING(g_level_statement,

1301: IF NVL(p_rec_nrec_dist_tbl(i).reverse_flag, 'N') <> 'Y' AND
1302: NVL(p_rec_nrec_dist_tbl(i).freeze_flag, 'N') <> 'Y'
1303: THEN
1304: IF (g_level_statement >= g_current_runtime_level ) THEN
1305: FND_LOG.STRING(g_level_statement,
1306: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1307: 'Reverse flag and freeze flag are not Y');
1308: END IF;
1309:

Line 1343: FND_LOG.STRING(g_level_statement,

1339: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_dist_id := p_rec_nrec_dist_tbl(i).trx_line_dist_id;
1340: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1341:
1342: IF (g_level_statement >= g_current_runtime_level ) THEN
1343: FND_LOG.STRING(g_level_statement,
1344: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1345: 'No Open Period or future period found for the accounting date passed by Payables');
1346: FND_LOG.STRING(g_level_statement,
1347: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',

Line 1346: FND_LOG.STRING(g_level_statement,

1342: IF (g_level_statement >= g_current_runtime_level ) THEN
1343: FND_LOG.STRING(g_level_statement,
1344: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1345: 'No Open Period or future period found for the accounting date passed by Payables');
1346: FND_LOG.STRING(g_level_statement,
1347: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',
1348: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(-)');
1349: END IF;
1350: RETURN;

Line 1356: FND_LOG.STRING(g_level_statement,

1352:
1353: -- tax only line
1354: IF p_rec_nrec_dist_tbl(i).Tax_Only_Line_Flag = 'Y' THEN
1355: IF (g_level_statement >= g_current_runtime_level ) THEN
1356: FND_LOG.STRING(g_level_statement,
1357: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1358: 'Tax only line flag is Y');
1359: END IF;
1360:

Line 1365: FND_LOG.STRING(g_level_statement,

1361: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_TAX_AMT := p_detail_tax_line_tbl(p_tax_line_index).TAX_AMT;
1362: p_rec_nrec_dist_tbl(i).UNROUNDED_TAXABLE_AMT := p_detail_tax_line_tbl(p_tax_line_index).TAXABLE_AMT;
1363: ELSE
1364: IF (g_level_statement >= g_current_runtime_level ) THEN
1365: FND_LOG.STRING(g_level_statement,
1366: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1367: 'Tax only line flag is not Y');
1368: END IF;
1369:

Line 1372: FND_LOG.STRING(g_level_statement,

1368: END IF;
1369:
1370: IF p_detail_tax_line_tbl(p_tax_line_index).applied_from_event_class_code = 'PREPAYMENT INVOICES' THEN
1371: IF (g_level_statement >= g_current_runtime_level ) THEN
1372: FND_LOG.STRING(g_level_statement,
1373: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1374: 'Prepayment Invoice application');
1375: END IF;
1376: l_temp_line_amt := p_detail_tax_line_tbl(p_tax_line_index).line_amt -

Line 1472: FND_LOG.STRING(g_level_statement,

1468: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_dist_id := p_rec_nrec_dist_tbl(i).trx_line_dist_id;
1469: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1470:
1471: IF (g_level_statement >= g_current_runtime_level ) THEN
1472: FND_LOG.STRING(g_level_statement,
1473: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1474: 'No Open Period or future period found for the accounting date passed by Payables');
1475: FND_LOG.STRING(g_level_statement,
1476: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',

Line 1475: FND_LOG.STRING(g_level_statement,

1471: IF (g_level_statement >= g_current_runtime_level ) THEN
1472: FND_LOG.STRING(g_level_statement,
1473: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1474: 'No Open Period or future period found for the accounting date passed by Payables');
1475: FND_LOG.STRING(g_level_statement,
1476: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',
1477: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(-)');
1478: END IF;
1479: RETURN;

Line 1503: FND_LOG.STRING(g_level_statement,

1499: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_dist_id := p_rec_nrec_dist_tbl(i).trx_line_dist_id;
1500: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1501:
1502: IF (g_level_statement >= g_current_runtime_level ) THEN
1503: FND_LOG.STRING(g_level_statement,
1504: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1505: 'No Open Period or future period found for the accounting date passed by Payables');
1506: FND_LOG.STRING(g_level_statement,
1507: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',

Line 1506: FND_LOG.STRING(g_level_statement,

1502: IF (g_level_statement >= g_current_runtime_level ) THEN
1503: FND_LOG.STRING(g_level_statement,
1504: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1505: 'No Open Period or future period found for the accounting date passed by Payables');
1506: FND_LOG.STRING(g_level_statement,
1507: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',
1508: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(-)');
1509: END IF;
1510: RETURN;

Line 1523: FND_LOG.STRING(g_level_procedure,

1519:
1520: END LOOP;
1521:
1522: IF (g_level_procedure >= g_current_runtime_level ) THEN
1523: FND_LOG.STRING(g_level_procedure,
1524: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',
1525: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(-)');
1526: END IF;
1527:

Line 1534: FND_LOG.STRING(g_level_unexpected,

1530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1531: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1532:
1533: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1534: FND_LOG.STRING(g_level_unexpected,
1535: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1536: p_error_buffer);
1537: FND_LOG.STRING(g_level_unexpected,
1538: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',

Line 1537: FND_LOG.STRING(g_level_unexpected,

1533: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1534: FND_LOG.STRING(g_level_unexpected,
1535: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1536: p_error_buffer);
1537: FND_LOG.STRING(g_level_unexpected,
1538: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.END',
1539: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(-)');
1540: END IF;
1541:

Line 1731: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1727: ORDER BY tax_class NULLS LAST, content_owner_id DESC;
1728:
1729: BEGIN
1730:
1731: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1732:
1733: IF (g_level_procedure >= g_current_runtime_level ) THEN
1734: FND_LOG.STRING(g_level_procedure,
1735: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.BEGIN',

Line 1734: FND_LOG.STRING(g_level_procedure,

1730:
1731: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1732:
1733: IF (g_level_procedure >= g_current_runtime_level ) THEN
1734: FND_LOG.STRING(g_level_procedure,
1735: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.BEGIN',
1736: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(+)');
1737: END IF;
1738:

Line 1746: FND_LOG.STRING(g_level_statement,

1742: l_tax := p_detail_tax_line_tbl(p_tax_line_index).tax;
1743: l_tax_regime_code := p_detail_tax_line_tbl(p_tax_line_index).tax_regime_code;
1744:
1745: IF (g_level_statement >= g_current_runtime_level ) THEN
1746: FND_LOG.STRING(g_level_statement,
1747: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1748: 'Tax : '|| l_tax || ', Tax Regime code : '|| l_tax_regime_code);
1749: END IF;
1750:

Line 1763: FND_LOG.STRING(g_level_statement,

1759: -- populate the structure for the future usage.
1760: IF NOT g_tax_recovery_info_tbl.EXISTS(l_tax_id)
1761: THEN
1762: IF (g_level_statement >= g_current_runtime_level ) THEN
1763: FND_LOG.STRING(g_level_statement,
1764: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1765: 'Populating tax cache information ');
1766: END IF;
1767:

Line 1788: FND_LOG.STRING(g_level_statement,

1784:
1785: IF get_tax_rec_info_from_tax_csr%NOTFOUND THEN
1786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1787: IF (g_level_statement >= g_current_runtime_level ) THEN
1788: FND_LOG.STRING(g_level_statement,
1789: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1790: 'error: ' || 'no tax info can be found for '||l_tax_id);
1791: END IF;
1792: CLOSE get_tax_rec_info_from_tax_csr;

Line 1812: FND_LOG.STRING(g_level_statement,

1808: p_error_buffer => p_error_buffer);
1809: END IF;
1810:
1811: IF (g_level_statement >= g_current_runtime_level ) THEN
1812: FND_LOG.STRING(g_level_statement,
1813: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1814: 'Populated tax cache information ');
1815: END IF;
1816:

Line 1832: FND_LOG.STRING(g_level_procedure,

1828: THEN
1829:
1830: IF (g_level_procedure >= g_current_runtime_level ) THEN
1831:
1832: FND_LOG.STRING(g_level_procedure,
1833: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.END',
1834: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(-)'||
1835: 'tax recovery rate is copied from applied_from or adjusted_to document');
1836: END IF;

Line 1841: FND_LOG.STRING(g_level_statement,

1837: RETURN;
1838:
1839: END IF;
1840: IF (g_level_statement >= g_current_runtime_level ) THEN
1841: FND_LOG.STRING(g_level_statement,
1842: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1843: 'Adjusted doc, applied from doc information is null ');
1844: END IF;
1845:

Line 1865: FND_LOG.STRING(g_level_statement,

1861: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
1862: p_rnd_begin_index > p_rnd_end_index
1863: THEN
1864: IF (g_level_statement >= g_current_runtime_level ) THEN
1865: FND_LOG.STRING(g_level_statement,
1866: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1867: 'begin or end index is null, or begin index > end index');
1868: END IF;
1869: RETURN;

Line 1878: FND_LOG.STRING(g_level_statement,

1874: IF NVL(p_rec_nrec_dist_tbl(i).reverse_flag, 'N') <> 'Y' AND
1875: NVL(p_rec_nrec_dist_tbl(i).freeze_flag, 'N') <> 'Y'
1876: THEN
1877: IF (g_level_statement >= g_current_runtime_level ) THEN
1878: FND_LOG.STRING(g_level_statement,
1879: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1880: 'Reverse flag and freeze flag are not Y.');
1881: END IF;
1882:

Line 1886: FND_LOG.STRING(g_level_statement,

1882:
1883:
1884: IF NVL(p_rec_nrec_dist_tbl(i).recoverable_flag,'N') = 'N' THEN
1885: IF (g_level_statement >= g_current_runtime_level ) THEN
1886: FND_LOG.STRING(g_level_statement,
1887: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1888: 'Recoverable flag is N');
1889: END IF;
1890:

Line 1911: FND_LOG.STRING(g_level_statement,

1907: END IF;
1908:
1909: ELSE -- recoverable line
1910: IF (g_level_statement >= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_statement,
1912: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1913: 'Recoverable flag is Y');
1914: END IF;
1915:

Line 1938: FND_LOG.STRING(g_level_statement,

1934: l_total_rec_rate := l_total_rec_rate + p_rec_nrec_dist_tbl(i).rec_nrec_rate;
1935: l_rec_rate_code := p_rec_nrec_dist_tbl(i).recovery_rate_code;
1936:
1937: IF (g_level_statement >= g_current_runtime_level ) THEN
1938: FND_LOG.STRING(g_level_statement,
1939: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1940: 'Last Manual Entry : '||p_rec_nrec_dist_tbl(i).last_manual_entry);
1941: END IF;
1942:

Line 1944: FND_LOG.STRING(g_level_statement,

1940: 'Last Manual Entry : '||p_rec_nrec_dist_tbl(i).last_manual_entry);
1941: END IF;
1942:
1943: IF (g_level_statement >= g_current_runtime_level ) THEN
1944: FND_LOG.STRING(g_level_statement,
1945: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1946: 'B. TAX_DIST_ID : '|| to_char(p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id)||
1947: ', RECOVERY_RATE_CODE : '|| p_rec_nrec_dist_tbl(i).recovery_rate_code||
1948: ', RECOVERY_RATE_ID : '|| to_char(p_rec_nrec_dist_tbl(i).recovery_rate_id)||

Line 1971: FND_LOG.STRING(g_level_statement,

1967: END IF;
1968: END IF;
1969:
1970: IF (g_level_statement >= g_current_runtime_level ) THEN
1971: FND_LOG.STRING(g_level_statement,
1972: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1973: 'A. TAX_DIST_ID : '|| to_char(p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id)||
1974: ', RECOVERY_RATE_CODE : '|| p_rec_nrec_dist_tbl(i).recovery_rate_code||
1975: ', RECOVERY_RATE_ID : '|| to_char(p_rec_nrec_dist_tbl(i).recovery_rate_id)||

Line 1998: FND_LOG.STRING(g_level_statement,

1994:
1995: l_rec_rate_code := p_rec_nrec_dist_tbl(i).recovery_rate_code;
1996:
1997: IF (g_level_statement >= g_current_runtime_level ) THEN
1998: FND_LOG.STRING(g_level_statement,
1999: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2000: 'Enforce Tax Recovery Code from Reference Document.'||
2001: 'ENFORCE_TAX_FROM_REF_DOC_FLAG : '||
2002: NVL(p_event_class_rec.enforce_tax_from_ref_doc_flag,'N'));

Line 2004: FND_LOG.STRING(g_level_statement,

2000: 'Enforce Tax Recovery Code from Reference Document.'||
2001: 'ENFORCE_TAX_FROM_REF_DOC_FLAG : '||
2002: NVL(p_event_class_rec.enforce_tax_from_ref_doc_flag,'N'));
2003:
2004: FND_LOG.STRING(g_level_statement,
2005: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2006: 'Recovery Rate Code : '||l_rec_rate_code);
2007: END IF;
2008:

Line 2042: FND_LOG.STRING(g_level_statement,

2038: -- Bug 6813467 - Removed the check IF l_rec_rule_code IS NOT NULL, it should enter
2039: -- rules processing unconditionally. Rules Engine will process for the rec_rule_code
2040: -- that is passed and if not found then will process further.
2041: IF (g_level_statement >= g_current_runtime_level ) THEN
2042: FND_LOG.STRING(g_level_statement,
2043: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2044: 'l_rec_rule_code : '|| l_rec_rule_code);
2045: FND_LOG.STRING(g_level_statement,
2046: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2045: FND_LOG.STRING(g_level_statement,

2041: IF (g_level_statement >= g_current_runtime_level ) THEN
2042: FND_LOG.STRING(g_level_statement,
2043: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2044: 'l_rec_rule_code : '|| l_rec_rule_code);
2045: FND_LOG.STRING(g_level_statement,
2046: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2047: 'l_def_rec_rate_code : ' || l_def_rec_rate_code);
2048: FND_LOG.STRING(g_level_statement,
2049: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2048: FND_LOG.STRING(g_level_statement,

2044: 'l_rec_rule_code : '|| l_rec_rule_code);
2045: FND_LOG.STRING(g_level_statement,
2046: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2047: 'l_def_rec_rate_code : ' || l_def_rec_rate_code);
2048: FND_LOG.STRING(g_level_statement,
2049: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2050: 'l_def_rec_settlement_code : ' ||l_def_rec_settlement_code );
2051: FND_LOG.STRING(g_level_statement,
2052: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2051: FND_LOG.STRING(g_level_statement,

2047: 'l_def_rec_rate_code : ' || l_def_rec_rate_code);
2048: FND_LOG.STRING(g_level_statement,
2049: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2050: 'l_def_rec_settlement_code : ' ||l_def_rec_settlement_code );
2051: FND_LOG.STRING(g_level_statement,
2052: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2053: 'l_rec_type_code : ' || l_rec_type_code );
2054: FND_LOG.STRING(g_level_statement,
2055: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2054: FND_LOG.STRING(g_level_statement,

2050: 'l_def_rec_settlement_code : ' ||l_def_rec_settlement_code );
2051: FND_LOG.STRING(g_level_statement,
2052: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2053: 'l_rec_type_code : ' || l_rec_type_code );
2054: FND_LOG.STRING(g_level_statement,
2055: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2056: 'l_def_rec_rate_code : ' || l_def_rec_rate_code );
2057: END IF;
2058:

Line 2076: FND_LOG.STRING(g_level_statement,

2072:
2073: l_rec_rate_code:= l_zx_result_rec.alphanumeric_result;
2074: l_rec_rate_id:= l_zx_result_rec.numeric_result;
2075: IF (g_level_statement >= g_current_runtime_level ) THEN
2076: FND_LOG.STRING(g_level_statement,
2077: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2078: 'l_rec_rate_code : '||l_rec_rate_code );
2079: FND_LOG.STRING(g_level_statement,
2080: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2079: FND_LOG.STRING(g_level_statement,

2075: IF (g_level_statement >= g_current_runtime_level ) THEN
2076: FND_LOG.STRING(g_level_statement,
2077: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2078: 'l_rec_rate_code : '||l_rec_rate_code );
2079: FND_LOG.STRING(g_level_statement,
2080: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2081: 'l_rec_rate_id : ' || to_char(l_rec_rate_id));
2082:
2083: END IF;

Line 2110: FND_LOG.STRING(g_level_statement,

2106: -- is fetched in this case but not used
2107: --
2108: IF NVL(p_rec_nrec_dist_tbl(i).rec_rate_det_rule_flag, 'N') = 'N' THEN
2109: IF (g_level_statement >= g_current_runtime_level ) THEN
2110: FND_LOG.STRING(g_level_statement,
2111: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2112: 'rec_rate_det_rule_flag is N ');
2113: END IF;
2114:

Line 2125: FND_LOG.STRING(g_level_statement,

2121: END IF;
2122: -- bug 9759983
2123:
2124: IF (g_level_statement >= g_current_runtime_level ) THEN
2125: FND_LOG.STRING(g_level_statement,
2126: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2127: 'l_rec_rule_code : '|| l_rec_rule_code);
2128: FND_LOG.STRING(g_level_statement,
2129: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2128: FND_LOG.STRING(g_level_statement,

2124: IF (g_level_statement >= g_current_runtime_level ) THEN
2125: FND_LOG.STRING(g_level_statement,
2126: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2127: 'l_rec_rule_code : '|| l_rec_rule_code);
2128: FND_LOG.STRING(g_level_statement,
2129: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2130: 'l_def_rec_rate_code : ' || l_def_rec_rate_code);
2131: FND_LOG.STRING(g_level_statement,
2132: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2131: FND_LOG.STRING(g_level_statement,

2127: 'l_rec_rule_code : '|| l_rec_rule_code);
2128: FND_LOG.STRING(g_level_statement,
2129: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2130: 'l_def_rec_rate_code : ' || l_def_rec_rate_code);
2131: FND_LOG.STRING(g_level_statement,
2132: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2133: 'l_def_rec_settlement_code : ' ||l_def_rec_settlement_code );
2134: FND_LOG.STRING(g_level_statement,
2135: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2134: FND_LOG.STRING(g_level_statement,

2130: 'l_def_rec_rate_code : ' || l_def_rec_rate_code);
2131: FND_LOG.STRING(g_level_statement,
2132: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2133: 'l_def_rec_settlement_code : ' ||l_def_rec_settlement_code );
2134: FND_LOG.STRING(g_level_statement,
2135: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2136: 'l_def_rec_rate_code : ' || l_def_rec_rate_code );
2137: END IF;
2138:

Line 2234: FND_LOG.STRING(g_level_statement,

2230: ZX_API_PUB.add_msg(
2231: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
2232:
2233: IF (g_level_statement >= g_current_runtime_level ) THEN
2234: FND_LOG.STRING(g_level_statement,
2235: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2236: 'Cannot find default rec rate code');
2237: FND_LOG.STRING(g_level_statement,
2238: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2237: FND_LOG.STRING(g_level_statement,

2233: IF (g_level_statement >= g_current_runtime_level ) THEN
2234: FND_LOG.STRING(g_level_statement,
2235: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2236: 'Cannot find default rec rate code');
2237: FND_LOG.STRING(g_level_statement,
2238: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2239: 'p_return_status := ' || p_return_status);
2240: FND_LOG.STRING(g_level_statement,
2241: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.END',

Line 2240: FND_LOG.STRING(g_level_statement,

2236: 'Cannot find default rec rate code');
2237: FND_LOG.STRING(g_level_statement,
2238: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2239: 'p_return_status := ' || p_return_status);
2240: FND_LOG.STRING(g_level_statement,
2241: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.END',
2242: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(-)');
2243: END IF;
2244: RETURN;

Line 2251: FND_LOG.STRING(g_level_statement,

2247: END IF; -- default tax recovery rate code at recovery type level
2248: END IF; -- default tax recovery rate code for Tax Rate
2249:
2250: IF (g_level_statement >= g_current_runtime_level ) THEN
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2253: 'l_rec_rate_code = ' || l_rec_rate_code);
2254: END IF;
2255: END IF; -- p_event_class_rec.enforce_tax_from_ref_doc_flag

Line 2270: FND_LOG.STRING(g_level_statement,

2266: l_rec_rate := p_rec_nrec_dist_tbl(i).rec_nrec_rate;
2267: l_rec_rate_id := p_rec_nrec_dist_tbl(i).recovery_rate_id;
2268:
2269: IF (g_level_statement >= g_current_runtime_level ) THEN
2270: FND_LOG.STRING(g_level_statement,
2271: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2272: 'Assigned Recovery Rate Percentage and Recovery_Rate_Id '||
2273: 'for Zero Amount Reference Tax Line');
2274: FND_LOG.STRING(g_level_statement,

Line 2274: FND_LOG.STRING(g_level_statement,

2270: FND_LOG.STRING(g_level_statement,
2271: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2272: 'Assigned Recovery Rate Percentage and Recovery_Rate_Id '||
2273: 'for Zero Amount Reference Tax Line');
2274: FND_LOG.STRING(g_level_statement,
2275: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2276: 'Recovery_Rate : '||l_rec_rate ||', Recovery_Rate_Id : '||l_rec_rate_id);
2277: END IF;
2278:

Line 2282: FND_LOG.STRING(g_level_statement,

2278:
2279: -- Start : Added for Bug#14038095 --
2280: IF l_rec_rate_id IS NULL AND l_rec_rate_code = 'AD_HOC_RECOVERY' THEN
2281: IF (g_level_statement >= g_current_runtime_level ) THEN
2282: FND_LOG.STRING(g_level_statement,
2283: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2284: 'Recovery_Rate_Id from the PO is NULL for Recovery Rate Code AD_HOC_RECOVERY');
2285: FND_LOG.STRING(g_level_statement,
2286: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',

Line 2285: FND_LOG.STRING(g_level_statement,

2281: IF (g_level_statement >= g_current_runtime_level ) THEN
2282: FND_LOG.STRING(g_level_statement,
2283: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2284: 'Recovery_Rate_Id from the PO is NULL for Recovery Rate Code AD_HOC_RECOVERY');
2285: FND_LOG.STRING(g_level_statement,
2286: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2287: 'Getting Recovery_Rate_Id for Recovery Rate Code AD_HOC_RECOVERY...');
2288: END IF;
2289:

Line 2299: FND_LOG.STRING(g_level_statement,

2295: FETCH get_adhoc_rec_rate_id_csr INTO l_rec_rate_id;
2296: CLOSE get_adhoc_rec_rate_id_csr;
2297:
2298: IF (g_level_statement >= g_current_runtime_level ) THEN
2299: FND_LOG.STRING(g_level_statement,
2300: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2301: 'Recovery_Rate_Id for Recovery Rate Code AD_HOC_RECOVERY : '||l_rec_rate_id);
2302: END IF;
2303: END IF;

Line 2389: FND_LOG.STRING(g_level_statement,

2385: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
2386:
2387:
2388: IF (g_level_statement >= g_current_runtime_level ) THEN
2389: FND_LOG.STRING(g_level_statement,
2390: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2391: 'error: Recovery rate is not found.');
2392:
2393: FND_LOG.STRING(g_level_statement,

Line 2393: FND_LOG.STRING(g_level_statement,

2389: FND_LOG.STRING(g_level_statement,
2390: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2391: 'error: Recovery rate is not found.');
2392:
2393: FND_LOG.STRING(g_level_statement,
2394: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.END',
2395: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(-)');
2396: END IF;
2397: RETURN;

Line 2438: FND_LOG.STRING(g_level_statement,

2434: IF l_acct_source_tax_rate_id IS NOT NULL THEN
2435: p_rec_nrec_dist_tbl(i).account_source_tax_rate_id :=
2436: l_acct_source_tax_rate_id;
2437: IF (g_level_statement >= g_current_runtime_level ) THEN
2438: FND_LOG.STRING(g_level_statement,
2439: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2440: 'Tax accounts defined for recovery rate id '|| to_char(p_rec_nrec_dist_tbl(i).recovery_rate_id));
2441:
2442: END IF;

Line 2450: FND_LOG.STRING(g_level_statement,

2446: -- p_rec_nrec_dist_tbl(i).account_source_tax_rate_id :=
2447: -- p_detail_tax_line_tbl(p_tax_line_index).account_source_tax_rate_id;
2448: -- This ELSE part contains the fix for bug 6900725
2449: IF (g_level_statement >= g_current_runtime_level ) THEN
2450: FND_LOG.STRING(g_level_statement,
2451: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2452: 'Tax accounts not defined for recovery rate id '|| to_char(p_rec_nrec_dist_tbl(i).recovery_rate_id));
2453:
2454: END IF;

Line 2458: FND_LOG.STRING(g_level_statement,

2454: END IF;
2455:
2456: IF g_tax_recovery_info_tbl(l_tax_id).tax_account_source_tax IS NOT NULL THEN
2457: IF (g_level_statement >= g_current_runtime_level ) THEN
2458: FND_LOG.STRING(g_level_statement,
2459: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2460: 'Getting account source tax rate id from Tax Accounts Source Tax '|| g_tax_recovery_info_tbl(l_tax_id).tax_account_source_tax );
2461:
2462: END IF;

Line 2502: FND_LOG.STRING(g_level_statement,

2498: END IF;
2499: END LOOP;
2500: END IF;
2501: IF (g_level_statement >= g_current_runtime_level ) THEN
2502: FND_LOG.STRING(g_level_statement,
2503: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2504: 'Account source tax rate id for recovery rate '|| to_char(p_rec_nrec_dist_tbl(i).account_source_tax_rate_id));
2505:
2506: END IF;

Line 2523: FND_LOG.STRING(g_level_statement,

2519: p_rec_nrec_dist_tbl(i).account_source_tax_rate_id := p_detail_tax_line_tbl(p_tax_line_index).account_source_tax_rate_id;
2520:
2521: END IF;
2522: IF (g_level_statement >= g_current_runtime_level ) THEN
2523: FND_LOG.STRING(g_level_statement,
2524: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2525: 'Final Account source tax rate id '|| to_char(p_rec_nrec_dist_tbl(i).account_source_tax_rate_id));
2526:
2527: END IF;

Line 2585: FND_LOG.STRING(g_level_statement,

2581: END IF;
2582:
2583: END IF;
2584: IF (g_level_statement >= g_current_runtime_level ) THEN
2585: FND_LOG.STRING(g_level_statement,
2586: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2587: 'Account source tax rate id for non recoverable dist '||p_rec_nrec_dist_tbl(l_non_rec_index).account_source_tax_rate_id);
2588:
2589: END IF;

Line 2621: FND_LOG.STRING(g_level_statement,

2617: ZX_API_PUB.add_msg(
2618: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
2619:
2620: IF (g_level_statement >= g_current_runtime_level ) THEN
2621: FND_LOG.STRING(g_level_statement,
2622: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2623: 'Error: Total Recovery Rate is greater than 100');
2624: END IF;
2625: RETURN;

Line 2630: FND_LOG.STRING(g_level_statement,

2626:
2627: END IF;
2628:
2629: IF (g_level_statement >= g_current_runtime_level ) THEN
2630: FND_LOG.STRING(g_level_statement,
2631: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2632: 'p_rec_nrec_dist_tbl(' || l_non_rec_index ||
2633: ').rec_nrec_rate = '
2634: || p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate);

Line 2638: FND_LOG.STRING(g_level_procedure,

2634: || p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate);
2635: END IF;
2636:
2637: IF (g_level_procedure >= g_current_runtime_level ) THEN
2638: FND_LOG.STRING(g_level_procedure,
2639: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.END',
2640: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(-)');
2641: END IF;
2642:

Line 2649: FND_LOG.STRING(g_level_unexpected,

2645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2647:
2648: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2649: FND_LOG.STRING(g_level_unexpected,
2650: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2651: p_error_buffer);
2652: FND_LOG.STRING(g_level_unexpected,
2653: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.END',

Line 2652: FND_LOG.STRING(g_level_unexpected,

2648: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2649: FND_LOG.STRING(g_level_unexpected,
2650: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
2651: p_error_buffer);
2652: FND_LOG.STRING(g_level_unexpected,
2653: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.END',
2654: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(-)');
2655: END IF;
2656: END get_rec_rate;

Line 2669: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2665: p_error_buffer OUT NOCOPY VARCHAR2)
2666: IS
2667:
2668: BEGIN
2669: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2670: IF (g_level_procedure >= g_current_runtime_level ) THEN
2671: FND_LOG.STRING(g_level_procedure,
2672: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT.BEGIN',
2673: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT(+)');

Line 2671: FND_LOG.STRING(g_level_procedure,

2667:
2668: BEGIN
2669: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2670: IF (g_level_procedure >= g_current_runtime_level ) THEN
2671: FND_LOG.STRING(g_level_procedure,
2672: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT.BEGIN',
2673: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT(+)');
2674: END IF;
2675: p_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 2697: FND_LOG.STRING(g_level_procedure,

2693: END IF;
2694: END LOOP;
2695:
2696: IF (g_level_procedure >= g_current_runtime_level ) THEN
2697: FND_LOG.STRING(g_level_procedure,
2698: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT.END',
2699: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT(-)');
2700: END IF;
2701:

Line 2708: FND_LOG.STRING(g_level_unexpected,

2704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2705: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2706:
2707: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2708: FND_LOG.STRING(g_level_unexpected,
2709: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT',
2710: p_error_buffer);
2711: FND_LOG.STRING(g_level_unexpected,
2712: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT.END',

Line 2711: FND_LOG.STRING(g_level_unexpected,

2707: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2708: FND_LOG.STRING(g_level_unexpected,
2709: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT',
2710: p_error_buffer);
2711: FND_LOG.STRING(g_level_unexpected,
2712: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT.END',
2713: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT(-)');
2714: END IF;
2715:

Line 2742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2739: l_tax_id zx_taxes_b.tax_id%TYPE;
2740:
2741: BEGIN
2742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2743: IF (g_level_procedure >= g_current_runtime_level ) THEN
2744: FND_LOG.STRING(g_level_procedure,
2745: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.BEGIN',
2746: 'ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT(+)');

Line 2744: FND_LOG.STRING(g_level_procedure,

2740:
2741: BEGIN
2742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2743: IF (g_level_procedure >= g_current_runtime_level ) THEN
2744: FND_LOG.STRING(g_level_procedure,
2745: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.BEGIN',
2746: 'ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT(+)');
2747: END IF;
2748:

Line 2756: FND_LOG.STRING(g_level_statement,

2752: p_rnd_begin_index > p_rnd_end_index THEN
2753:
2754: --p_return_status:= FND_API.G_RET_STS_ERROR;
2755: IF (g_level_statement >= g_current_runtime_level ) THEN
2756: FND_LOG.STRING(g_level_statement,
2757: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2758: 'begin or end index is null, or begin index > end index');
2759: END IF;
2760: RETURN;

Line 2793: FND_LOG.STRING(g_level_error,

2789: p_error_buffer);
2790:
2791: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2792: IF (g_level_error >= g_current_runtime_level ) THEN
2793: FND_LOG.STRING(g_level_error,
2794: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_rec_nrec_amt',
2795: 'Incorrect return_status after calling ' ||
2796: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists()');
2797: FND_LOG.STRING(g_level_error,

Line 2797: FND_LOG.STRING(g_level_error,

2793: FND_LOG.STRING(g_level_error,
2794: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_rec_nrec_amt',
2795: 'Incorrect return_status after calling ' ||
2796: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists()');
2797: FND_LOG.STRING(g_level_error,
2798: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_rec_nrec_amt.END',
2799: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_rec_nrec_amt(-)'||p_return_status);
2800: END IF;
2801: RETURN;

Line 2821: FND_LOG.STRING(g_level_statement,

2817: p_error_buffer => p_error_buffer);
2818:
2819: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
2820: IF (g_level_statement >= g_current_runtime_level ) THEN
2821: FND_LOG.STRING(g_level_statement,
2822: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2823: 'Incorrect return_status after calling ' ||
2824: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts');
2825: FND_LOG.STRING(g_level_statement,

Line 2825: FND_LOG.STRING(g_level_statement,

2821: FND_LOG.STRING(g_level_statement,
2822: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2823: 'Incorrect return_status after calling ' ||
2824: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts');
2825: FND_LOG.STRING(g_level_statement,
2826: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2827: 'RETURN_STATUS = ' || p_return_status);
2828: FND_LOG.STRING(g_level_statement,
2829: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.END',

Line 2828: FND_LOG.STRING(g_level_statement,

2824: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts');
2825: FND_LOG.STRING(g_level_statement,
2826: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2827: 'RETURN_STATUS = ' || p_return_status);
2828: FND_LOG.STRING(g_level_statement,
2829: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.END',
2830: 'ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT(-)');
2831: END IF;
2832: RETURN;

Line 2855: FND_LOG.STRING(g_level_procedure,

2851: END IF; -- mrc_tax_dist_flag = 'N'
2852:
2853: IF (g_level_procedure >= g_current_runtime_level ) THEN
2854:
2855: FND_LOG.STRING(g_level_procedure,
2856: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.END',
2857: 'ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT(-)'||p_return_status);
2858: END IF;
2859:

Line 2866: FND_LOG.STRING(g_level_unexpected,

2862: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2863: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2864:
2865: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2866: FND_LOG.STRING(g_level_unexpected,
2867: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2868: p_error_buffer);
2869: FND_LOG.STRING(g_level_unexpected,
2870: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.END',

Line 2869: FND_LOG.STRING(g_level_unexpected,

2865: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2866: FND_LOG.STRING(g_level_unexpected,
2867: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2868: p_error_buffer);
2869: FND_LOG.STRING(g_level_unexpected,
2870: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.END',
2871: 'ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT(-)');
2872: END IF;
2873:

Line 2914: FND_LOG.STRING(g_level_procedure,

2910:
2911: BEGIN
2912:
2913: IF (g_level_procedure >= g_current_runtime_level ) THEN
2914: FND_LOG.STRING(g_level_procedure,
2915: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.BEGIN',
2916: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(+)');
2917: END IF;
2918:

Line 2926: FND_LOG.STRING(g_level_statement,

2922: p_rnd_begin_index > p_rnd_end_index THEN
2923:
2924: --p_return_status:= FND_API.G_RET_STS_ERROR;
2925: IF (g_level_statement >= g_current_runtime_level ) THEN
2926: FND_LOG.STRING(g_level_statement,
2927: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
2928: 'begin or end index is null, or begin index > end index');
2929: END IF;
2930: RETURN;

Line 2951: FND_LOG.STRING(g_level_statement,

2947: p_return_status => p_return_status,
2948: p_error_buffer => p_error_buffer);
2949:
2950: IF (g_level_statement >= g_current_runtime_level ) THEN
2951: FND_LOG.STRING(g_level_statement,
2952: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
2953: ' i = '||to_char(i) || ' round '|| p_rec_nrec_dist_tbl(i).unrounded_rec_nrec_tax_amt ||
2954: ' to '|| p_rec_nrec_dist_tbl(i).rec_nrec_tax_amt);
2955: END IF;

Line 2970: FND_LOG.STRING(g_level_error,

2966:
2967: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2968: THEN
2969: IF (g_level_error >= g_current_runtime_level ) THEN
2970: FND_LOG.STRING(g_level_error,
2971: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
2972: 'Incorrect return_status after calling ' ||
2973: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
2974: FND_LOG.STRING(g_level_error,

Line 2974: FND_LOG.STRING(g_level_error,

2970: FND_LOG.STRING(g_level_error,
2971: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
2972: 'Incorrect return_status after calling ' ||
2973: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
2974: FND_LOG.STRING(g_level_error,
2975: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
2976: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)'||p_return_status);
2977: END IF;
2978: RETURN;

Line 3074: FND_LOG.STRING(g_level_error,

3070:
3071: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3072: THEN
3073: IF (g_level_error >= g_current_runtime_level ) THEN
3074: FND_LOG.STRING(g_level_error,
3075: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3076: 'Incorrect return_status after calling ' ||
3077: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
3078: FND_LOG.STRING(g_level_error,

Line 3078: FND_LOG.STRING(g_level_error,

3074: FND_LOG.STRING(g_level_error,
3075: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3076: 'Incorrect return_status after calling ' ||
3077: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
3078: FND_LOG.STRING(g_level_error,
3079: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3080: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)'||p_return_status);
3081: END IF;
3082: RETURN;

Line 3126: FND_LOG.STRING(g_level_error,

3122:
3123: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3124: THEN
3125: IF (g_level_error >= g_current_runtime_level ) THEN
3126: FND_LOG.STRING(g_level_error,
3127: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3128: 'Incorrect return_status after calling ' ||
3129: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3130: FND_LOG.STRING(g_level_error,

Line 3130: FND_LOG.STRING(g_level_error,

3126: FND_LOG.STRING(g_level_error,
3127: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3128: 'Incorrect return_status after calling ' ||
3129: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3130: FND_LOG.STRING(g_level_error,
3131: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3132: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)'||p_return_status);
3133: END IF;
3134: RETURN;

Line 3153: FND_LOG.STRING(g_level_error,

3149:
3150: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3151: THEN
3152: IF (g_level_error >= g_current_runtime_level ) THEN
3153: FND_LOG.STRING(g_level_error,
3154: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3155: 'Incorrect return_status after calling ' ||
3156: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3157: FND_LOG.STRING(g_level_error,

Line 3157: FND_LOG.STRING(g_level_error,

3153: FND_LOG.STRING(g_level_error,
3154: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3155: 'Incorrect return_status after calling ' ||
3156: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3157: FND_LOG.STRING(g_level_error,
3158: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3159: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)'||p_return_status);
3160: END IF;
3161: RETURN;

Line 3185: FND_LOG.STRING(g_level_error,

3181:
3182: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3183: THEN
3184: IF (g_level_error >= g_current_runtime_level ) THEN
3185: FND_LOG.STRING(g_level_error,
3186: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3187: 'Incorrect return_status after calling ' ||
3188: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3189: FND_LOG.STRING(g_level_error,

Line 3189: FND_LOG.STRING(g_level_error,

3185: FND_LOG.STRING(g_level_error,
3186: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3187: 'Incorrect return_status after calling ' ||
3188: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3189: FND_LOG.STRING(g_level_error,
3190: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3191: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)'||p_return_status);
3192: END IF;
3193: RETURN;

Line 3212: FND_LOG.STRING(g_level_error,

3208:
3209: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3210: THEN
3211: IF (g_level_error >= g_current_runtime_level ) THEN
3212: FND_LOG.STRING(g_level_error,
3213: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3214: 'Incorrect return_status after calling ' ||
3215: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3216: FND_LOG.STRING(g_level_error,

Line 3216: FND_LOG.STRING(g_level_error,

3212: FND_LOG.STRING(g_level_error,
3213: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3214: 'Incorrect return_status after calling ' ||
3215: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3216: FND_LOG.STRING(g_level_error,
3217: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3218: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)');
3219: END IF;
3220: RETURN;

Line 3278: FND_LOG.STRING(g_level_error,

3274:
3275: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3276: THEN
3277: IF (g_level_error >= g_current_runtime_level ) THEN
3278: FND_LOG.STRING(g_level_error,
3279: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3280: 'Incorrect return_status after calling ' ||
3281: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3282: FND_LOG.STRING(g_level_error,

Line 3282: FND_LOG.STRING(g_level_error,

3278: FND_LOG.STRING(g_level_error,
3279: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3280: 'Incorrect return_status after calling ' ||
3281: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3282: FND_LOG.STRING(g_level_error,
3283: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3284: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)');
3285: END IF;
3286: RETURN;

Line 3307: FND_LOG.STRING(g_level_error,

3303:
3304: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
3305: THEN
3306: IF (g_level_error >= g_current_runtime_level ) THEN
3307: FND_LOG.STRING(g_level_error,
3308: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3309: 'Incorrect return_status after calling ' ||
3310: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3311: FND_LOG.STRING(g_level_error,

Line 3311: FND_LOG.STRING(g_level_error,

3307: FND_LOG.STRING(g_level_error,
3308: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3309: 'Incorrect return_status after calling ' ||
3310: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3311: FND_LOG.STRING(g_level_error,
3312: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3313: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)');
3314: END IF;
3315: RETURN;

Line 3340: FND_LOG.STRING(g_level_error,

3336:
3337: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3338: THEN
3339: IF (g_level_error >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_error,
3341: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3342: 'Incorrect return_status after calling ' ||
3343: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3344: FND_LOG.STRING(g_level_error,

Line 3344: FND_LOG.STRING(g_level_error,

3340: FND_LOG.STRING(g_level_error,
3341: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3342: 'Incorrect return_status after calling ' ||
3343: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3344: FND_LOG.STRING(g_level_error,
3345: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3346: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)');
3347: END IF;
3348: RETURN;

Line 3369: FND_LOG.STRING(g_level_error,

3365:
3366: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3367: THEN
3368: IF (g_level_error >= g_current_runtime_level ) THEN
3369: FND_LOG.STRING(g_level_error,
3370: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3371: 'Incorrect return_status after calling ' ||
3372: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3373: FND_LOG.STRING(g_level_error,

Line 3373: FND_LOG.STRING(g_level_error,

3369: FND_LOG.STRING(g_level_error,
3370: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3371: 'Incorrect return_status after calling ' ||
3372: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3373: FND_LOG.STRING(g_level_error,
3374: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3375: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)'||p_return_status);
3376: END IF;
3377: RETURN;

Line 3539: FND_LOG.STRING(g_level_procedure,

3535: END IF; -- p_tax_line_amt IS NOT NULL
3536:
3537: IF (g_level_procedure >= g_current_runtime_level ) THEN
3538:
3539: FND_LOG.STRING(g_level_procedure,
3540: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3541: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)'||p_return_status);
3542: END IF;
3543:

Line 3551: FND_LOG.STRING(g_level_unexpected,

3547: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3548: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3549:
3550: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3551: FND_LOG.STRING(g_level_unexpected,
3552: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3553: p_error_buffer);
3554: FND_LOG.STRING(g_level_unexpected,
3555: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',

Line 3554: FND_LOG.STRING(g_level_unexpected,

3550: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3551: FND_LOG.STRING(g_level_unexpected,
3552: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
3553: p_error_buffer);
3554: FND_LOG.STRING(g_level_unexpected,
3555: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.END',
3556: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(-)');
3557: END IF;
3558:

Line 3613: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3609:
3610:
3611: BEGIN
3612:
3613: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3614:
3615: IF (g_level_procedure >= g_current_runtime_level ) THEN
3616: FND_LOG.STRING(g_level_procedure,
3617: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.BEGIN',

Line 3616: FND_LOG.STRING(g_level_procedure,

3612:
3613: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3614:
3615: IF (g_level_procedure >= g_current_runtime_level ) THEN
3616: FND_LOG.STRING(g_level_procedure,
3617: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.BEGIN',
3618: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(+)');
3619: END IF;
3620:

Line 3628: FND_LOG.STRING(g_level_statement,

3624: p_rnd_begin_index > p_rnd_end_index THEN
3625:
3626: --p_return_status:= FND_API.G_RET_STS_ERROR;
3627: IF (g_level_statement >= g_current_runtime_level ) THEN
3628: FND_LOG.STRING(g_level_statement,
3629: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3630: 'begin or end index is null, or begin index > end index');
3631: END IF;
3632: RETURN;

Line 3656: FND_LOG.STRING(g_level_error,

3652:
3653: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).tax_currency_code IS NULL THEN
3654: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3655: IF (g_level_error >= g_current_runtime_level ) THEN
3656: FND_LOG.STRING(g_level_error,
3657: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3658: 'Tax currency code is NULL');
3659: FND_LOG.STRING(g_level_error,
3660: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 3659: FND_LOG.STRING(g_level_error,

3655: IF (g_level_error >= g_current_runtime_level ) THEN
3656: FND_LOG.STRING(g_level_error,
3657: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3658: 'Tax currency code is NULL');
3659: FND_LOG.STRING(g_level_error,
3660: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3661: 'p_return_status = ' || p_return_status);
3662: END IF;
3663: RETURN;

Line 3714: FND_LOG.STRING(g_level_error,

3710:
3711: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3712: THEN
3713: IF (g_level_error >= g_current_runtime_level ) THEN
3714: FND_LOG.STRING(g_level_error,
3715: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3716: 'Incorrect return_status after calling ' ||
3717: 'ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency()');
3718: FND_LOG.STRING(g_level_error,

Line 3718: FND_LOG.STRING(g_level_error,

3714: FND_LOG.STRING(g_level_error,
3715: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3716: 'Incorrect return_status after calling ' ||
3717: 'ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency()');
3718: FND_LOG.STRING(g_level_error,
3719: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3720: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
3721: END IF;
3722: RETURN;

Line 3739: FND_LOG.STRING(g_level_error,

3735:
3736: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3737: THEN
3738: IF (g_level_error >= g_current_runtime_level ) THEN
3739: FND_LOG.STRING(g_level_error,
3740: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3741: 'Incorrect return_status after calling ' ||
3742: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
3743: FND_LOG.STRING(g_level_error,

Line 3743: FND_LOG.STRING(g_level_error,

3739: FND_LOG.STRING(g_level_error,
3740: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3741: 'Incorrect return_status after calling ' ||
3742: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
3743: FND_LOG.STRING(g_level_error,
3744: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3745: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
3746: END IF;
3747: RETURN;

Line 3846: FND_LOG.STRING(g_level_error,

3842:
3843: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3844: THEN
3845: IF (g_level_error >= g_current_runtime_level ) THEN
3846: FND_LOG.STRING(g_level_error,
3847: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3848: 'Incorrect return_status after calling ' ||
3849: 'ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency()');
3850: FND_LOG.STRING(g_level_error,

Line 3850: FND_LOG.STRING(g_level_error,

3846: FND_LOG.STRING(g_level_error,
3847: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3848: 'Incorrect return_status after calling ' ||
3849: 'ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency()');
3850: FND_LOG.STRING(g_level_error,
3851: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3852: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
3853: END IF;
3854: RETURN;

Line 3880: FND_LOG.STRING(g_level_error,

3876:
3877: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3878: THEN
3879: IF (g_level_error >= g_current_runtime_level ) THEN
3880: FND_LOG.STRING(g_level_error,
3881: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3882: 'Incorrect return_status after calling ' ||
3883: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
3884: FND_LOG.STRING(g_level_error,

Line 3884: FND_LOG.STRING(g_level_error,

3880: FND_LOG.STRING(g_level_error,
3881: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3882: 'Incorrect return_status after calling ' ||
3883: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
3884: FND_LOG.STRING(g_level_error,
3885: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3886: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
3887: END IF;
3888: RETURN;

Line 3918: FND_LOG.STRING(g_level_error,

3914:
3915: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3916: THEN
3917: IF (g_level_error >= g_current_runtime_level ) THEN
3918: FND_LOG.STRING(g_level_error,
3919: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3920: 'Incorrect return_status after calling ' ||
3921: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3922: FND_LOG.STRING(g_level_error,

Line 3922: FND_LOG.STRING(g_level_error,

3918: FND_LOG.STRING(g_level_error,
3919: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3920: 'Incorrect return_status after calling ' ||
3921: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3922: FND_LOG.STRING(g_level_error,
3923: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3924: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
3925: END IF;
3926: RETURN;

Line 3945: FND_LOG.STRING(g_level_error,

3941:
3942: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3943: THEN
3944: IF (g_level_error >= g_current_runtime_level ) THEN
3945: FND_LOG.STRING(g_level_error,
3946: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3947: 'Incorrect return_status after calling ' ||
3948: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3949: FND_LOG.STRING(g_level_error,

Line 3949: FND_LOG.STRING(g_level_error,

3945: FND_LOG.STRING(g_level_error,
3946: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3947: 'Incorrect return_status after calling ' ||
3948: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
3949: FND_LOG.STRING(g_level_error,
3950: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3951: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
3952: END IF;
3953: RETURN;

Line 3977: FND_LOG.STRING(g_level_error,

3973:
3974: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3975: THEN
3976: IF (g_level_error >= g_current_runtime_level ) THEN
3977: FND_LOG.STRING(g_level_error,
3978: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3979: 'Incorrect return_status after calling ' ||
3980: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3981: FND_LOG.STRING(g_level_error,

Line 3981: FND_LOG.STRING(g_level_error,

3977: FND_LOG.STRING(g_level_error,
3978: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3979: 'Incorrect return_status after calling ' ||
3980: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
3981: FND_LOG.STRING(g_level_error,
3982: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3983: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
3984: END IF;
3985: RETURN;

Line 4004: FND_LOG.STRING(g_level_error,

4000:
4001: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4002: THEN
4003: IF (g_level_error >= g_current_runtime_level ) THEN
4004: FND_LOG.STRING(g_level_error,
4005: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4006: 'Incorrect return_status after calling ' ||
4007: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4008: FND_LOG.STRING(g_level_error,

Line 4008: FND_LOG.STRING(g_level_error,

4004: FND_LOG.STRING(g_level_error,
4005: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4006: 'Incorrect return_status after calling ' ||
4007: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4008: FND_LOG.STRING(g_level_error,
4009: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4010: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4011: END IF;
4012: RETURN;

Line 4046: FND_LOG.STRING(g_level_error,

4042:
4043: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4044: THEN
4045: IF (g_level_error >= g_current_runtime_level ) THEN
4046: FND_LOG.STRING(g_level_error,
4047: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4048: 'Incorrect return_status after calling ' ||
4049: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4050: FND_LOG.STRING(g_level_error,

Line 4050: FND_LOG.STRING(g_level_error,

4046: FND_LOG.STRING(g_level_error,
4047: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4048: 'Incorrect return_status after calling ' ||
4049: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4050: FND_LOG.STRING(g_level_error,
4051: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4052: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
4053: END IF;
4054: RETURN;

Line 4075: FND_LOG.STRING(g_level_error,

4071:
4072: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4073: THEN
4074: IF (g_level_error >= g_current_runtime_level ) THEN
4075: FND_LOG.STRING(g_level_error,
4076: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4077: 'Incorrect return_status after calling ' ||
4078: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4079: FND_LOG.STRING(g_level_error,

Line 4079: FND_LOG.STRING(g_level_error,

4075: FND_LOG.STRING(g_level_error,
4076: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4077: 'Incorrect return_status after calling ' ||
4078: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4079: FND_LOG.STRING(g_level_error,
4080: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4081: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4082: END IF;
4083: RETURN;

Line 4108: FND_LOG.STRING(g_level_error,

4104:
4105: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4106: THEN
4107: IF (g_level_error >= g_current_runtime_level ) THEN
4108: FND_LOG.STRING(g_level_error,
4109: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4110: 'Incorrect return_status after calling ' ||
4111: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4112: FND_LOG.STRING(g_level_error,

Line 4112: FND_LOG.STRING(g_level_error,

4108: FND_LOG.STRING(g_level_error,
4109: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4110: 'Incorrect return_status after calling ' ||
4111: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4112: FND_LOG.STRING(g_level_error,
4113: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4114: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4115: END IF;
4116: RETURN;

Line 4137: FND_LOG.STRING(g_level_error,

4133:
4134: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4135: THEN
4136: IF (g_level_error >= g_current_runtime_level ) THEN
4137: FND_LOG.STRING(g_level_error,
4138: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4139: 'Incorrect return_status after calling ' ||
4140: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4141: FND_LOG.STRING(g_level_error,

Line 4141: FND_LOG.STRING(g_level_error,

4137: FND_LOG.STRING(g_level_error,
4138: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4139: 'Incorrect return_status after calling ' ||
4140: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4141: FND_LOG.STRING(g_level_error,
4142: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4143: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4144: END IF;
4145: RETURN;

Line 4245: FND_LOG.STRING(g_level_error,

4241:
4242: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
4243: THEN
4244: IF (g_level_error >= g_current_runtime_level ) THEN
4245: FND_LOG.STRING(g_level_error,
4246: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4247: 'Incorrect return_status after calling ' ||
4248: 'ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency()');
4249: FND_LOG.STRING(g_level_error,

Line 4249: FND_LOG.STRING(g_level_error,

4245: FND_LOG.STRING(g_level_error,
4246: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4247: 'Incorrect return_status after calling ' ||
4248: 'ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency()');
4249: FND_LOG.STRING(g_level_error,
4250: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4251: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4252: END IF;
4253: RETURN;

Line 4270: FND_LOG.STRING(g_level_error,

4266:
4267: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
4268: THEN
4269: IF (g_level_error >= g_current_runtime_level ) THEN
4270: FND_LOG.STRING(g_level_error,
4271: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4272: 'Incorrect return_status after calling ' ||
4273: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
4274: FND_LOG.STRING(g_level_error,

Line 4274: FND_LOG.STRING(g_level_error,

4270: FND_LOG.STRING(g_level_error,
4271: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4272: 'Incorrect return_status after calling ' ||
4273: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
4274: FND_LOG.STRING(g_level_error,
4275: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4276: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4277: END IF;
4278: RETURN;

Line 4313: FND_LOG.STRING(g_level_error,

4309:
4310: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
4311: THEN
4312: IF (g_level_error >= g_current_runtime_level ) THEN
4313: FND_LOG.STRING(g_level_error,
4314: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4315: 'Incorrect return_status after calling ' ||
4316: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
4317: FND_LOG.STRING(g_level_error,

Line 4317: FND_LOG.STRING(g_level_error,

4313: FND_LOG.STRING(g_level_error,
4314: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4315: 'Incorrect return_status after calling ' ||
4316: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
4317: FND_LOG.STRING(g_level_error,
4318: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4319: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4320: END IF;
4321: RETURN;

Line 4358: FND_LOG.STRING(g_level_procedure,

4354: END LOOP;
4355:
4356: IF (g_level_procedure >= g_current_runtime_level ) THEN
4357:
4358: FND_LOG.STRING(g_level_procedure,
4359: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4360: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||
4361: 'Functional currency is the same as transaction currency, no conversion is performed');
4362: END IF;

Line 4555: FND_LOG.STRING(g_level_error,

4551:
4552: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4553: THEN
4554: IF (g_level_error >= g_current_runtime_level ) THEN
4555: FND_LOG.STRING(g_level_error,
4556: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4557: 'Incorrect return_status after calling ' ||
4558: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4559: FND_LOG.STRING(g_level_error,

Line 4559: FND_LOG.STRING(g_level_error,

4555: FND_LOG.STRING(g_level_error,
4556: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4557: 'Incorrect return_status after calling ' ||
4558: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4559: FND_LOG.STRING(g_level_error,
4560: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4561: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4562: END IF;
4563: RETURN;

Line 4602: FND_LOG.STRING(g_level_error,

4598:
4599: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4600: THEN
4601: IF (g_level_error >= g_current_runtime_level ) THEN
4602: FND_LOG.STRING(g_level_error,
4603: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4604: 'Incorrect return_status after calling ' ||
4605: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4606: FND_LOG.STRING(g_level_error,

Line 4606: FND_LOG.STRING(g_level_error,

4602: FND_LOG.STRING(g_level_error,
4603: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4604: 'Incorrect return_status after calling ' ||
4605: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4606: FND_LOG.STRING(g_level_error,
4607: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4608: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4609: END IF;
4610: RETURN;

Line 4629: FND_LOG.STRING(g_level_error,

4625:
4626: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4627: THEN
4628: IF (g_level_error >= g_current_runtime_level ) THEN
4629: FND_LOG.STRING(g_level_error,
4630: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4631: 'Incorrect return_status after calling ' ||
4632: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4633: FND_LOG.STRING(g_level_error,

Line 4633: FND_LOG.STRING(g_level_error,

4629: FND_LOG.STRING(g_level_error,
4630: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4631: 'Incorrect return_status after calling ' ||
4632: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4633: FND_LOG.STRING(g_level_error,
4634: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4635: 'RETURN_STATUS = ' || p_return_status);
4636: FND_LOG.STRING(g_level_error,
4637: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',

Line 4636: FND_LOG.STRING(g_level_error,

4632: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4633: FND_LOG.STRING(g_level_error,
4634: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4635: 'RETURN_STATUS = ' || p_return_status);
4636: FND_LOG.STRING(g_level_error,
4637: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4638: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
4639: END IF;
4640: RETURN;

Line 4673: FND_LOG.STRING(g_level_error,

4669:
4670: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4671: THEN
4672: IF (g_level_error >= g_current_runtime_level ) THEN
4673: FND_LOG.STRING(g_level_error,
4674: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4675: 'Incorrect return_status after calling ' ||
4676: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4677: FND_LOG.STRING(g_level_error,

Line 4677: FND_LOG.STRING(g_level_error,

4673: FND_LOG.STRING(g_level_error,
4674: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4675: 'Incorrect return_status after calling ' ||
4676: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4677: FND_LOG.STRING(g_level_error,
4678: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4679: 'RETURN_STATUS = ' || p_return_status);
4680: FND_LOG.STRING(g_level_error,
4681: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',

Line 4680: FND_LOG.STRING(g_level_error,

4676: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4677: FND_LOG.STRING(g_level_error,
4678: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4679: 'RETURN_STATUS = ' || p_return_status);
4680: FND_LOG.STRING(g_level_error,
4681: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4682: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
4683: END IF;
4684: RETURN;

Line 4703: FND_LOG.STRING(g_level_error,

4699:
4700: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4701: THEN
4702: IF (g_level_error >= g_current_runtime_level ) THEN
4703: FND_LOG.STRING(g_level_error,
4704: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4705: 'Incorrect return_status after calling ' ||
4706: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4707: FND_LOG.STRING(g_level_error,

Line 4707: FND_LOG.STRING(g_level_error,

4703: FND_LOG.STRING(g_level_error,
4704: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4705: 'Incorrect return_status after calling ' ||
4706: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4707: FND_LOG.STRING(g_level_error,
4708: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4709: 'RETURN_STATUS = ' || p_return_status);
4710: FND_LOG.STRING(g_level_error,
4711: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',

Line 4710: FND_LOG.STRING(g_level_error,

4706: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4707: FND_LOG.STRING(g_level_error,
4708: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4709: 'RETURN_STATUS = ' || p_return_status);
4710: FND_LOG.STRING(g_level_error,
4711: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4712: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
4713: END IF;
4714: RETURN;

Line 4740: FND_LOG.STRING(g_level_error,

4736:
4737: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4738: THEN
4739: IF (g_level_error >= g_current_runtime_level ) THEN
4740: FND_LOG.STRING(g_level_error,
4741: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4742: 'Incorrect return_status after calling ' ||
4743: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4744: FND_LOG.STRING(g_level_error,

Line 4744: FND_LOG.STRING(g_level_error,

4740: FND_LOG.STRING(g_level_error,
4741: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4742: 'Incorrect return_status after calling ' ||
4743: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4744: FND_LOG.STRING(g_level_error,
4745: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4746: 'RETURN_STATUS = ' || p_return_status);
4747: FND_LOG.STRING(g_level_error,
4748: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',

Line 4747: FND_LOG.STRING(g_level_error,

4743: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc()');
4744: FND_LOG.STRING(g_level_error,
4745: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4746: 'RETURN_STATUS = ' || p_return_status);
4747: FND_LOG.STRING(g_level_error,
4748: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4749: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
4750: END IF;
4751: RETURN;

Line 4770: FND_LOG.STRING(g_level_error,

4766:
4767: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4768: THEN
4769: IF (g_level_error >= g_current_runtime_level ) THEN
4770: FND_LOG.STRING(g_level_error,
4771: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4772: 'Incorrect return_status after calling ' ||
4773: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4774: FND_LOG.STRING(g_level_error,

Line 4774: FND_LOG.STRING(g_level_error,

4770: FND_LOG.STRING(g_level_error,
4771: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4772: 'Incorrect return_status after calling ' ||
4773: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4774: FND_LOG.STRING(g_level_error,
4775: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4776: 'RETURN_STATUS = ' || p_return_status);
4777: FND_LOG.STRING(g_level_error,
4778: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',

Line 4777: FND_LOG.STRING(g_level_error,

4773: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff()');
4774: FND_LOG.STRING(g_level_error,
4775: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4776: 'RETURN_STATUS = ' || p_return_status);
4777: FND_LOG.STRING(g_level_error,
4778: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4779: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
4780: END IF;
4781: RETURN;

Line 4825: FND_LOG.STRING(g_level_statement,

4821: l_tax_line_rnd_diff_funcl_curr;
4822:
4823:
4824: IF (g_level_statement >= g_current_runtime_level ) THEN
4825: FND_LOG.STRING(g_level_statement,
4826: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4827: 'Rounding Dif adjusted to the largest non-rec tax dist '||l_index);
4828: END IF;
4829:

Line 4844: FND_LOG.STRING(g_level_statement,

4840: p_rec_nrec_dist_tbl(l_index).func_curr_rounding_adjustment :=
4841: l_tax_line_rnd_diff_funcl_curr;
4842:
4843: IF (g_level_statement >= g_current_runtime_level ) THEN
4844: FND_LOG.STRING(g_level_statement,
4845: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4846: 'Rounding Dif adjusted to the largest rec tax dist '||l_index);
4847: END IF;
4848:

Line 4872: FND_LOG.STRING(g_level_statement,

4868: l_tax_line_rnd_diff_funcl_curr;
4869:
4870:
4871: IF (g_level_statement >= g_current_runtime_level ) THEN
4872: FND_LOG.STRING(g_level_statement,
4873: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4874: 'Rounding Dif adjusted to the largest rec tax dist '||l_index);
4875: END IF;
4876:

Line 4893: FND_LOG.STRING(g_level_statement,

4889: p_rec_nrec_dist_tbl(l_index).func_curr_rounding_adjustment :=
4890: l_tax_line_rnd_diff_funcl_curr;
4891:
4892: IF (g_level_statement >= g_current_runtime_level ) THEN
4893: FND_LOG.STRING(g_level_statement,
4894: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4895: 'Rounding Dif adjusted to the largest non-rec tax dist '||l_index);
4896: END IF;
4897:

Line 4926: FND_LOG.STRING(g_level_procedure,

4922:
4923: ELSE -- p_rec_nrec_dist_tbl(i).ledger_id IS NULL
4924: IF (g_level_procedure >= g_current_runtime_level ) THEN
4925:
4926: FND_LOG.STRING(g_level_procedure,
4927: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4928: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||
4929: ' null Ledger_id cannot perform conversion to functional currency');
4930: END IF;

Line 4937: FND_LOG.STRING(g_level_procedure,

4933: -- /****** END OF CONVERSION AND ROUNDING OF FUNCTIONAL CURRENCY ******/
4934:
4935: IF (g_level_procedure >= g_current_runtime_level ) THEN
4936:
4937: FND_LOG.STRING(g_level_procedure,
4938: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4939: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4940: END IF;
4941:

Line 4949: FND_LOG.STRING(g_level_unexpected,

4945: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4946: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4947:
4948: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4949: FND_LOG.STRING(g_level_unexpected,
4950: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4951: p_error_buffer);
4952: FND_LOG.STRING(g_level_unexpected,
4953: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',

Line 4952: FND_LOG.STRING(g_level_unexpected,

4948: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4949: FND_LOG.STRING(g_level_unexpected,
4950: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4951: p_error_buffer);
4952: FND_LOG.STRING(g_level_unexpected,
4953: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4954: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)');
4955: END IF;
4956:

Line 4973: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4969: l_remainder NUMBER;
4970:
4971: BEGIN
4972:
4973: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4974:
4975: IF (g_level_procedure >= g_current_runtime_level ) THEN
4976: FND_LOG.STRING(g_level_procedure,
4977: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff.BEGIN',

Line 4976: FND_LOG.STRING(g_level_procedure,

4972:
4973: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4974:
4975: IF (g_level_procedure >= g_current_runtime_level ) THEN
4976: FND_LOG.STRING(g_level_procedure,
4977: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff.BEGIN',
4978: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff(+)'||
4979: 'p_rounding_diff = ' || p_rounding_diff);
4980: END IF;

Line 4989: FND_LOG.STRING(g_level_procedure,

4985: --
4986: IF p_rounding_diff = 0 THEN
4987: IF (g_level_procedure >= g_current_runtime_level ) THEN
4988:
4989: FND_LOG.STRING(g_level_procedure,
4990: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff.END',
4991: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff(-)'||'no diff');
4992: END IF;
4993: RETURN;

Line 5027: FND_LOG.STRING(g_level_procedure,

5023: END IF; -- l_remainder <> 0
5024: ELSE -- p_index_amt_tbl.COUNT = 0
5025: IF (g_level_procedure >= g_current_runtime_level ) THEN
5026:
5027: FND_LOG.STRING(g_level_procedure,
5028: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff.END',
5029: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff(-)'||
5030: 'p_index_amt_tbl is empty');
5031: END IF;

Line 5037: FND_LOG.STRING(g_level_procedure,

5033: END IF; -- p_index_amt_tbl.COUNT > 0 OR NOT
5034: END IF; -- p_rounding_diff <> 0 OR NOT
5035:
5036: IF (g_level_procedure >= g_current_runtime_level ) THEN
5037: FND_LOG.STRING(g_level_procedure,
5038: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff.END',
5039: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff(-)'||
5040: p_return_status);
5041: END IF;

Line 5050: FND_LOG.STRING(g_level_unexpected,

5046: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5047: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5048:
5049: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5050: FND_LOG.STRING(g_level_unexpected,
5051: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff',
5052: p_error_buffer);
5053: FND_LOG.STRING(g_level_unexpected,
5054: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff.END',

Line 5053: FND_LOG.STRING(g_level_unexpected,

5049: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5050: FND_LOG.STRING(g_level_unexpected,
5051: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff',
5052: p_error_buffer);
5053: FND_LOG.STRING(g_level_unexpected,
5054: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff.END',
5055: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff(-)');
5056: END IF;
5057:

Line 5074: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5070: l_temp_num NUMBER;
5071:
5072: BEGIN
5073:
5074: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5075:
5076: IF (g_level_procedure >= g_current_runtime_level ) THEN
5077: FND_LOG.STRING(g_level_procedure,
5078: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc.BEGIN',

Line 5077: FND_LOG.STRING(g_level_procedure,

5073:
5074: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5075:
5076: IF (g_level_procedure >= g_current_runtime_level ) THEN
5077: FND_LOG.STRING(g_level_procedure,
5078: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc.BEGIN',
5079: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc(+)');
5080: END IF;
5081:

Line 5127: FND_LOG.STRING(g_level_procedure,

5123: END LOOP;
5124:
5125: IF (g_level_procedure >= g_current_runtime_level ) THEN
5126:
5127: FND_LOG.STRING(g_level_procedure,
5128: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc.END',
5129: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc(-)'||p_return_status);
5130: END IF;
5131:

Line 5139: FND_LOG.STRING(g_level_unexpected,

5135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5136: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5137:
5138: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5139: FND_LOG.STRING(g_level_unexpected,
5140: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc',
5141: p_error_buffer);
5142: FND_LOG.STRING(g_level_unexpected,
5143: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc.END',

Line 5142: FND_LOG.STRING(g_level_unexpected,

5138: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5139: FND_LOG.STRING(g_level_unexpected,
5140: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc',
5141: p_error_buffer);
5142: FND_LOG.STRING(g_level_unexpected,
5143: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc.END',
5144: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc(-)');
5145: END IF;
5146:

Line 5209: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5205: l_rec_nrec_tax_dist_number NUMBER;
5206:
5207: BEGIN
5208:
5209: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5210: IF (g_level_procedure >= g_current_runtime_level ) THEN
5211: FND_LOG.STRING(g_level_procedure,
5212: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied.BEGIN',
5213: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied(+)');

Line 5211: FND_LOG.STRING(g_level_procedure,

5207: BEGIN
5208:
5209: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5210: IF (g_level_procedure >= g_current_runtime_level ) THEN
5211: FND_LOG.STRING(g_level_procedure,
5212: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied.BEGIN',
5213: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied(+)');
5214: END IF;
5215:

Line 5227: FND_LOG.STRING(g_level_statement,

5223: p_return_status => p_return_status,
5224: p_error_buffer => p_error_buffer);
5225:
5226: IF (g_level_statement >= g_current_runtime_level ) THEN
5227: FND_LOG.STRING(g_level_statement,
5228: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5229: 'Fetching Tax Dists for: '||
5230: 'APPLIED_FROM_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)) ||', '||
5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||

Line 5243: FND_LOG.STRING(g_level_statement,

5239: );
5240: END IF;
5241:
5242: IF (g_level_statement >= g_current_runtime_level ) THEN
5243: FND_LOG.STRING(g_level_statement,
5244: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5245: 'Updating Tax_Apportionment_Line_Number in the tax distributions of Applied_From Doc...');
5246: END IF;
5247:

Line 5264: FND_LOG.STRING(g_level_statement,

5260: AND tax_apportionment_line_number IS NULL
5261: AND NVL(reverse_flag, 'N') <> 'Y';
5262:
5263: IF (g_level_statement >= g_current_runtime_level ) THEN
5264: FND_LOG.STRING(g_level_statement,
5265: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5266: ' Rows updated : '|| TO_CHAR(SQL%ROWCOUNT));
5267: END IF;
5268:

Line 5272: FND_LOG.STRING(g_level_statement,

5268:
5269: FOR tax_dist_rec in get_tax_dists_csr LOOP
5270:
5271: IF (g_level_statement >= g_current_runtime_level ) THEN
5272: FND_LOG.STRING(g_level_statement,
5273: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5274: 'Fetched Record: '||
5275: 'REC_NREC_TAX_DIST_ID : '|| TO_CHAR(tax_dist_rec.rec_nrec_tax_dist_id) ||', '||
5276: 'RECOVERY_RATE_CODE : '|| tax_dist_rec.Recovery_rate_code ||', '||

Line 5359: FND_LOG.STRING(g_level_procedure,

5355: END LOOP;
5356:
5357: IF (g_level_procedure >= g_current_runtime_level) THEN
5358:
5359: FND_LOG.STRING(g_level_procedure,
5360: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied.END',
5361: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied(-)'||p_return_status);
5362: END IF;
5363:

Line 5370: FND_LOG.STRING(g_level_unexpected,

5366: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5367: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5368:
5369: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5370: FND_LOG.STRING(g_level_unexpected,
5371: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5372: p_error_buffer);
5373: FND_LOG.STRING(g_level_unexpected,
5374: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied.END',

Line 5373: FND_LOG.STRING(g_level_unexpected,

5369: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5370: FND_LOG.STRING(g_level_unexpected,
5371: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5372: p_error_buffer);
5373: FND_LOG.STRING(g_level_unexpected,
5374: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied.END',
5375: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied(-)');
5376: END IF;
5377:

Line 5435: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5431: l_rec_nrec_tax_dist_number NUMBER;
5432:
5433: BEGIN
5434:
5435: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5436: IF (g_level_procedure >= g_current_runtime_level ) THEN
5437: FND_LOG.STRING(g_level_procedure,
5438: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted.BEGIN',
5439: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted(+)');

Line 5437: FND_LOG.STRING(g_level_procedure,

5433: BEGIN
5434:
5435: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5436: IF (g_level_procedure >= g_current_runtime_level ) THEN
5437: FND_LOG.STRING(g_level_procedure,
5438: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted.BEGIN',
5439: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted(+)');
5440: END IF;
5441:

Line 5454: FND_LOG.STRING(g_level_statement,

5450: p_return_status => p_return_status,
5451: p_error_buffer => p_error_buffer);
5452:
5453: IF (g_level_statement >= g_current_runtime_level ) THEN
5454: FND_LOG.STRING(g_level_statement,
5455: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5456: 'Fetching Tax Dists for: '||
5457: 'ADJUSTED_DOC_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)) ||', '||
5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||

Line 5470: FND_LOG.STRING(g_level_statement,

5466: );
5467: END IF;
5468:
5469: IF (g_level_statement >= g_current_runtime_level ) THEN
5470: FND_LOG.STRING(g_level_statement,
5471: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5472: 'Updating Tax_Apportionment_Line_Number in the tax distributions of Adjusted Doc...');
5473: END IF;
5474:

Line 5491: FND_LOG.STRING(g_level_statement,

5487: AND tax_apportionment_line_number IS NULL
5488: AND NVL(reverse_flag, 'N') <> 'Y';
5489:
5490: IF (g_level_statement >= g_current_runtime_level ) THEN
5491: FND_LOG.STRING(g_level_statement,
5492: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5493: ' Rows updated : '|| TO_CHAR(SQL%ROWCOUNT));
5494: END IF;
5495:

Line 5499: FND_LOG.STRING(g_level_statement,

5495:
5496: FOR tax_dist_rec in get_tax_dists_csr LOOP
5497:
5498: IF (g_level_statement >= g_current_runtime_level ) THEN
5499: FND_LOG.STRING(g_level_statement,
5500: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5501: 'Fetched Record: '||
5502: 'REC_NREC_TAX_DIST_ID : '|| TO_CHAR(tax_dist_rec.rec_nrec_tax_dist_id) ||', '||
5503: 'RECOVERY_RATE_CODE : '|| tax_dist_rec.Recovery_rate_code ||', '||

Line 5545: FND_LOG.STRING(g_level_procedure,

5541: END LOOP;
5542:
5543: IF (g_level_procedure >= g_current_runtime_level ) THEN
5544:
5545: FND_LOG.STRING(g_level_procedure,
5546: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted.END',
5547: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted(-)'||p_return_status);
5548: END IF;
5549:

Line 5556: FND_LOG.STRING(g_level_unexpected,

5552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5553: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5554:
5555: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5556: FND_LOG.STRING(g_level_unexpected,
5557: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5558: p_error_buffer);
5559: FND_LOG.STRING(g_level_unexpected,
5560: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted.END',

Line 5559: FND_LOG.STRING(g_level_unexpected,

5555: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5556: FND_LOG.STRING(g_level_unexpected,
5557: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5558: p_error_buffer);
5559: FND_LOG.STRING(g_level_unexpected,
5560: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted.END',
5561: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted(-)');
5562: END IF;
5563:

Line 5650: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5646: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
5647:
5648: BEGIN
5649:
5650: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5651: IF (g_level_procedure >= g_current_runtime_level ) THEN
5652: FND_LOG.STRING(g_level_procedure,
5653: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.BEGIN',
5654: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(+)');

Line 5652: FND_LOG.STRING(g_level_procedure,

5648: BEGIN
5649:
5650: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5651: IF (g_level_procedure >= g_current_runtime_level ) THEN
5652: FND_LOG.STRING(g_level_procedure,
5653: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.BEGIN',
5654: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(+)');
5655: END IF;
5656:

Line 5662: FND_LOG.STRING(g_level_procedure,

5658:
5659: p_rnd_end_index := p_rnd_begin_index -1;
5660:
5661: IF (g_level_procedure >= g_current_runtime_level ) THEN
5662: FND_LOG.STRING(g_level_procedure,
5663: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5664: 'Begin Index : '||TO_CHAR(p_rnd_begin_index)||', End Index : '||TO_CHAR(p_rnd_end_index));
5665: END IF;
5666:

Line 5709: FND_LOG.STRING(g_level_procedure,

5705:
5706: IF get_tax_recovery_info_cur%NOTFOUND THEN
5707: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5708: IF (g_level_procedure >= g_current_runtime_level ) THEN
5709: FND_LOG.STRING(g_level_procedure,
5710: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',
5711: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(-)'||'error: can not find tax info for ' || l_tax_id);
5712: END IF;
5713: CLOSE get_tax_recovery_info_cur;

Line 5726: FND_LOG.STRING(g_level_statement,

5722:
5723: END IF;
5724:
5725: IF (g_level_statement >= g_current_runtime_level ) THEN
5726: FND_LOG.STRING(g_level_statement,
5727: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5728: 'Allow Tax Recoverability for Tax '||l_tax||' is '||
5729: NVL(g_tax_recovery_info_tbl(l_tax_id).allow_recoverability_flag,'N'));
5730: END IF;

Line 5751: FND_LOG.STRING(g_level_statement,

5747: -- Populate only Non-Recoverable tax distribution from PO
5748: --
5749: IF NVL(tax_dist_rec.recoverable_flag,'N') = 'Y' THEN
5750: IF (g_level_statement >= g_current_runtime_level ) THEN
5751: FND_LOG.STRING(g_level_statement,
5752: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5753: 'Do not copy the recoverable tax distribution from PO');
5754: END IF;
5755: NULL;

Line 5762: FND_LOG.STRING(g_level_statement,

5758: l_rec_nrec_tax_dist_number := l_rec_nrec_tax_dist_number + 1;
5759: p_rnd_end_index := p_rnd_end_index + 1;
5760:
5761: IF (g_level_statement >= g_current_runtime_level ) THEN
5762: FND_LOG.STRING(g_level_statement,
5763: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5764: 'Copy only the non-recoverable tax distribution from PO at index '||
5765: TO_CHAR(p_rnd_end_index));
5766: END IF;

Line 5795: FND_LOG.STRING(g_level_statement,

5791: l_rec_nrec_tax_dist_number := l_rec_nrec_tax_dist_number + 1;
5792: p_rnd_end_index := p_rnd_end_index + 1;
5793:
5794: IF (g_level_statement >= g_current_runtime_level ) THEN
5795: FND_LOG.STRING(g_level_statement,
5796: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5797: 'Copy tax distribution from PO at index '||
5798: TO_CHAR(p_rnd_end_index));
5799: END IF;

Line 5824: FND_LOG.STRING(g_level_statement,

5820: IF l_po_dist_count <> p_rnd_end_index THEN -- Added this IF condition for Bug#14038095 --
5821: -- This means that new tax distribution record is added to plsql structure --
5822: --
5823: IF (g_level_statement >= g_current_runtime_level ) THEN
5824: FND_LOG.STRING(g_level_statement,
5825: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5826: 'Index : '||TO_CHAR(p_rnd_end_index) ||
5827: ', Ref_Doc_Tax_Dist_Id : '||TO_CHAR(tax_dist_rec.rec_nrec_tax_dist_id) ||
5828: ', Recoverable_Flag : '||tax_dist_rec.recoverable_flag ||

Line 5846: FND_LOG.STRING(g_level_statement,

5842: AND
5843: NVL(p_rec_nrec_dist_tbl(p_rnd_end_index).recoverable_flag,'N') = 'Y'
5844: THEN
5845: IF (g_level_statement >= g_current_runtime_level ) THEN
5846: FND_LOG.STRING(g_level_statement,
5847: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5848: 'Copy Rec_Nrec_Rate and Recovery_Rate_Id from PO for recoverable '||
5849: 'tax distribution of zero amount reference tax line');
5850: END IF;

Line 5866: FND_LOG.STRING(g_level_statement,

5862: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_rate :=
5863: tax_dist_rec.rec_nrec_rate;
5864:
5865: IF (g_level_statement >= g_current_runtime_level ) THEN
5866: FND_LOG.STRING(g_level_statement,
5867: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5868: 'User had overridden recovery rate on PO, so copy the PO '||
5869: 'recovery rate % to invoice tax distributions.');
5870: END IF;

Line 5884: FND_LOG.STRING(g_level_statement,

5880:
5881: IF l_rnd_begin_index = p_rnd_end_index THEN
5882:
5883: IF (g_level_statement >= g_current_runtime_level ) THEN
5884: FND_LOG.STRING(g_level_statement,
5885: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5886: 'Can not find tax distribution on PO, have to call the ' ||
5887: 'normal det_appl_rec_type() to determine recovery type.');
5888: END IF;

Line 5903: FND_LOG.STRING(g_level_error,

5899:
5900: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
5901: THEN
5902: IF (g_level_error >= g_current_runtime_level ) THEN
5903: FND_LOG.STRING(g_level_error,
5904: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5905: 'Incorrect return_status after calling ' ||
5906: 'ZX_TDS_UTILITIES_PKG.det_appl_rec_type()');
5907: FND_LOG.STRING(g_level_error,

Line 5907: FND_LOG.STRING(g_level_error,

5903: FND_LOG.STRING(g_level_error,
5904: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5905: 'Incorrect return_status after calling ' ||
5906: 'ZX_TDS_UTILITIES_PKG.det_appl_rec_type()');
5907: FND_LOG.STRING(g_level_error,
5908: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5909: 'RETURN_STATUS = ' || p_return_status);
5910: FND_LOG.STRING(g_level_error,
5911: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',

Line 5910: FND_LOG.STRING(g_level_error,

5906: 'ZX_TDS_UTILITIES_PKG.det_appl_rec_type()');
5907: FND_LOG.STRING(g_level_error,
5908: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5909: 'RETURN_STATUS = ' || p_return_status);
5910: FND_LOG.STRING(g_level_error,
5911: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',
5912: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(-)');
5913: END IF;
5914: RETURN;

Line 5919: FND_LOG.STRING(g_level_procedure,

5915: END IF;
5916: END IF;
5917:
5918: IF (g_level_procedure >= g_current_runtime_level) THEN
5919: FND_LOG.STRING(g_level_procedure,
5920: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5921: 'Begin Index : '||TO_CHAR(p_rnd_begin_index)||', End Index : '||TO_CHAR(p_rnd_end_index));
5922: FND_LOG.STRING(g_level_procedure,
5923: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',

Line 5922: FND_LOG.STRING(g_level_procedure,

5918: IF (g_level_procedure >= g_current_runtime_level) THEN
5919: FND_LOG.STRING(g_level_procedure,
5920: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5921: 'Begin Index : '||TO_CHAR(p_rnd_begin_index)||', End Index : '||TO_CHAR(p_rnd_end_index));
5922: FND_LOG.STRING(g_level_procedure,
5923: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',
5924: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(-)'||p_return_status);
5925: END IF;
5926:

Line 5933: FND_LOG.STRING(g_level_unexpected,

5929: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5930: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5931:
5932: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5933: FND_LOG.STRING(g_level_unexpected,
5934: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5935: p_error_buffer);
5936: FND_LOG.STRING(g_level_unexpected,
5937: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',

Line 5936: FND_LOG.STRING(g_level_unexpected,

5932: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5933: FND_LOG.STRING(g_level_unexpected,
5934: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5935: p_error_buffer);
5936: FND_LOG.STRING(g_level_unexpected,
5937: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',
5938: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(-)');
5939: END IF;
5940:

Line 5980: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5976: l_tax_id zx_taxes_b.tax_id%TYPE;
5977:
5978: BEGIN
5979:
5980: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5981:
5982: IF (g_level_procedure >= g_current_runtime_level ) THEN
5983: FND_LOG.STRING(g_level_procedure,
5984: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.BEGIN',

Line 5983: FND_LOG.STRING(g_level_procedure,

5979:
5980: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5981:
5982: IF (g_level_procedure >= g_current_runtime_level ) THEN
5983: FND_LOG.STRING(g_level_procedure,
5984: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.BEGIN',
5985: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts(+)');
5986: END IF;
5987:

Line 5995: FND_LOG.STRING(g_level_error,

5991: p_rnd_begin_index > p_rnd_end_index THEN
5992:
5993: --p_return_status:= FND_API.G_RET_STS_ERROR;
5994: IF (g_level_error >= g_current_runtime_level ) THEN
5995: FND_LOG.STRING(g_level_error,
5996: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',
5997: 'begin or end index is null, or begin index > end index');
5998: END IF;
5999: RETURN;

Line 6016: FND_LOG.STRING(g_level_error,

6012:
6013: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
6014: THEN
6015: IF (g_level_error >= g_current_runtime_level ) THEN
6016: FND_LOG.STRING(g_level_error,
6017: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6018: 'Incorrect return_status after calling ' ||
6019: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
6020: FND_LOG.STRING(g_level_error,

Line 6020: FND_LOG.STRING(g_level_error,

6016: FND_LOG.STRING(g_level_error,
6017: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6018: 'Incorrect return_status after calling ' ||
6019: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
6020: FND_LOG.STRING(g_level_error,
6021: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6022: 'RETURN_STATUS = ' || p_return_status);
6023: FND_LOG.STRING(g_level_error,
6024: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.END',

Line 6023: FND_LOG.STRING(g_level_error,

6019: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
6020: FND_LOG.STRING(g_level_error,
6021: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6022: 'RETURN_STATUS = ' || p_return_status);
6023: FND_LOG.STRING(g_level_error,
6024: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.END',
6025: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts(-)');
6026: END IF;
6027: RETURN;

Line 6074: FND_LOG.STRING(g_level_error,

6070:
6071: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
6072: THEN
6073: IF (g_level_error >= g_current_runtime_level ) THEN
6074: FND_LOG.STRING(g_level_error,
6075: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',
6076: 'Incorrect return_status after calling ' ||
6077: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
6078: FND_LOG.STRING(g_level_error,

Line 6078: FND_LOG.STRING(g_level_error,

6074: FND_LOG.STRING(g_level_error,
6075: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',
6076: 'Incorrect return_status after calling ' ||
6077: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
6078: FND_LOG.STRING(g_level_error,
6079: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',
6080: 'RETURN_STATUS = ' || p_return_status);
6081: FND_LOG.STRING(g_level_error,
6082: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.END',

Line 6081: FND_LOG.STRING(g_level_error,

6077: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
6078: FND_LOG.STRING(g_level_error,
6079: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',
6080: 'RETURN_STATUS = ' || p_return_status);
6081: FND_LOG.STRING(g_level_error,
6082: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.END',
6083: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts (-)');
6084: END IF;
6085: RETURN;

Line 6255: FND_LOG.STRING(g_level_procedure,

6251: END IF;
6252:
6253: IF (g_level_procedure >= g_current_runtime_level ) THEN
6254:
6255: FND_LOG.STRING(g_level_procedure,
6256: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.END',
6257: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts (-)'||p_return_status);
6258: END IF;
6259:

Line 6267: FND_LOG.STRING(g_level_unexpected,

6263: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6264: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6265:
6266: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6267: FND_LOG.STRING(g_level_unexpected,
6268: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6269: l_error_buffer);
6270: FND_LOG.STRING(g_level_unexpected,
6271: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.END',

Line 6270: FND_LOG.STRING(g_level_unexpected,

6266: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6267: FND_LOG.STRING(g_level_unexpected,
6268: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6269: l_error_buffer);
6270: FND_LOG.STRING(g_level_unexpected,
6271: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.END',
6272: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts (-)');
6273: END IF;
6274:

Line 6289: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6285:
6286: l_dist_id NUMBER;
6287:
6288: BEGIN
6289: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6290: IF (g_level_procedure >= g_current_runtime_level ) THEN
6291: FND_LOG.STRING(g_level_procedure,
6292: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns.BEGIN',
6293: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns(+)');

Line 6291: FND_LOG.STRING(g_level_procedure,

6287:
6288: BEGIN
6289: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6290: IF (g_level_procedure >= g_current_runtime_level ) THEN
6291: FND_LOG.STRING(g_level_procedure,
6292: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns.BEGIN',
6293: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns(+)');
6294: END IF;
6295:

Line 6303: FND_LOG.STRING(g_level_statement,

6299: p_rnd_begin_index > p_rnd_end_index THEN
6300:
6301: --p_return_status:= FND_API.G_RET_STS_ERROR;
6302: IF (g_level_statement >= g_current_runtime_level ) THEN
6303: FND_LOG.STRING(g_level_statement,
6304: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
6305: 'begin or end index is null, or begin index > end index');
6306: END IF;
6307: RETURN;

Line 6318: FND_LOG.STRING(g_level_statement,

6314: IF p_rec_nrec_dist_tbl(i).ref_doc_application_id IS NOT NULL THEN
6315:
6316: IF p_rec_nrec_dist_tbl(i).recoverable_flag = 'N' THEN
6317: IF (g_level_statement >= g_current_runtime_level ) THEN
6318: FND_LOG.STRING(g_level_statement,
6319: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
6320: 'recoverable_flag is N ');
6321: END IF;
6322:

Line 6331: FND_LOG.STRING(g_level_statement,

6327: IF NVL(p_rec_nrec_dist_tbl(i).reverse_flag, 'N') <> 'Y' AND
6328: NVL(p_rec_nrec_dist_tbl(i).freeze_flag, 'N') <> 'Y'
6329: THEN
6330: IF (g_level_statement >= g_current_runtime_level ) THEN
6331: FND_LOG.STRING(g_level_statement,
6332: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
6333: 'Reverse flag and Freeze flag are not Y ');
6334: END IF;
6335:

Line 6367: FND_LOG.STRING(g_level_statement,

6363: END IF;
6364: END IF; -- p_rec_nrec_dist_tbl(i).recoverable_flag = 'N'
6365: ELSE
6366: IF (g_level_statement >= g_current_runtime_level ) THEN
6367: FND_LOG.STRING(g_level_statement,
6368: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
6369: 'Ref doc application id is null');
6370: END IF;
6371:

Line 6377: FND_LOG.STRING(g_level_procedure,

6373: END LOOP; -- i IN p_rnd_begin_index .. p_rnd_end_index
6374:
6375: IF (g_level_procedure >= g_current_runtime_level ) THEN
6376:
6377: FND_LOG.STRING(g_level_procedure,
6378: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns.END',
6379: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns(-)'||p_return_status);
6380: END IF;
6381:

Line 6388: FND_LOG.STRING(g_level_unexpected,

6384: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6386:
6387: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6388: FND_LOG.STRING(g_level_unexpected,
6389: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
6390: p_error_buffer);
6391: FND_LOG.STRING(g_level_unexpected,
6392: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns.END',

Line 6391: FND_LOG.STRING(g_level_unexpected,

6387: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6388: FND_LOG.STRING(g_level_unexpected,
6389: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
6390: p_error_buffer);
6391: FND_LOG.STRING(g_level_unexpected,
6392: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns.END',
6393: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns(-)');
6394: END IF;
6395:

Line 6404: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6400: p_error_buffer OUT NOCOPY VARCHAR2) IS
6401:
6402: BEGIN
6403:
6404: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6405:
6406: IF (g_level_procedure >= g_current_runtime_level ) THEN
6407: FND_LOG.STRING(g_level_procedure,
6408: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.BEGIN',

Line 6407: FND_LOG.STRING(g_level_procedure,

6403:
6404: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6405:
6406: IF (g_level_procedure >= g_current_runtime_level ) THEN
6407: FND_LOG.STRING(g_level_procedure,
6408: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.BEGIN',
6409: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors(+)');
6410: END IF;
6411:

Line 6424: FND_LOG.STRING(g_level_procedure,

6420:
6421: IF ZX_TRD_SERVICES_PUB_PKG.g_retained_value is NOT NULL THEN
6422:
6423: IF (g_level_procedure >= g_current_runtime_level ) THEN
6424: FND_LOG.STRING(g_level_procedure,
6425: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6426: 'g_retained_value is not NULL - Retainage flow');
6427: END IF;
6428:

Line 6433: FND_LOG.STRING(g_level_procedure,

6429: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND
6430: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'S' THEN
6431:
6432: IF (g_level_procedure >= g_current_runtime_level ) THEN
6433: FND_LOG.STRING(g_level_procedure,
6434: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6435: 'Flow - Standard invoice with retainage line');
6436: END IF;
6437:

Line 6510: FND_LOG.STRING(g_level_procedure,

6506: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND
6507: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'R' THEN
6508:
6509: IF (g_level_procedure >= g_current_runtime_level ) THEN
6510: FND_LOG.STRING(g_level_procedure,
6511: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6512: 'Flow - retainage release invoice');
6513: END IF;
6514:

Line 6582: FND_LOG.STRING(g_level_procedure,

6578: END IF; -- g_ret_doc_type 'R'
6579:
6580: ELSE
6581: IF (g_level_procedure >= g_current_runtime_level ) THEN
6582: FND_LOG.STRING(g_level_procedure,
6583: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6584: 'No Retainage - Normal Flow');
6585: END IF;
6586:

Line 6664: FND_LOG.STRING(g_level_procedure,

6660:
6661: END IF; --ZX_TRD_SERVICES_PUB_PKG.g_retained_value
6662:
6663: IF (g_level_procedure >= g_current_runtime_level ) THEN
6664: FND_LOG.STRING(g_level_procedure,
6665: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.END',
6666: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors(-)'||p_return_status);
6667: END IF;
6668:

Line 6675: FND_LOG.STRING(g_level_unexpected,

6671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6672: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6673:
6674: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6675: FND_LOG.STRING(g_level_unexpected,
6676: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6677: p_error_buffer);
6678: FND_LOG.STRING(g_level_unexpected,
6679: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.END',

Line 6678: FND_LOG.STRING(g_level_unexpected,

6674: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6675: FND_LOG.STRING(g_level_unexpected,
6676: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6677: p_error_buffer);
6678: FND_LOG.STRING(g_level_unexpected,
6679: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.END',
6680: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors(-)');
6681: END IF;
6682:

Line 6726: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6722: l_end_index NUMBER;
6723:
6724: BEGIN
6725:
6726: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6727:
6728: IF (g_level_statement >= g_current_runtime_level ) THEN
6729: FND_LOG.STRING(g_level_statement,
6730: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists.BEGIN',

Line 6729: FND_LOG.STRING(g_level_statement,

6725:
6726: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6727:
6728: IF (g_level_statement >= g_current_runtime_level ) THEN
6729: FND_LOG.STRING(g_level_statement,
6730: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists.BEGIN',
6731: 'ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists(+)');
6732: END IF;
6733:

Line 6741: FND_LOG.STRING(g_level_statement,

6737: p_rnd_begin_index > p_rnd_end_index THEN
6738:
6739: --p_return_status := FND_API.G_RET_STS_ERROR;
6740: IF (g_level_statement >= g_current_runtime_level ) THEN
6741: FND_LOG.STRING(g_level_statement,
6742: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists',
6743: 'begin or end index is null, or begin index > end index');
6744: END IF;
6745: RETURN;

Line 6843: FND_LOG.STRING(g_level_statement,

6839: p_error_buffer);
6840:
6841: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6842: IF (g_level_statement >= g_current_runtime_level ) THEN
6843: FND_LOG.STRING(g_level_statement,
6844: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists',
6845: 'After calling ROUND_REC_NREC_AMT p_return_status = '
6846: || p_return_status);
6847: FND_LOG.STRING(g_level_statement,

Line 6847: FND_LOG.STRING(g_level_statement,

6843: FND_LOG.STRING(g_level_statement,
6844: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists',
6845: 'After calling ROUND_REC_NREC_AMT p_return_status = '
6846: || p_return_status);
6847: FND_LOG.STRING(g_level_statement,
6848: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists.END',
6849: 'ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists(-)');
6850: END IF;
6851: RETURN;

Line 6856: FND_LOG.STRING(g_level_procedure,

6852: END IF;
6853: END LOOP; -- mrc_line_rec IN get_mrc_tax_line_info_csr LOOP
6854:
6855: IF (g_level_procedure >= g_current_runtime_level ) THEN
6856: FND_LOG.STRING(g_level_procedure,
6857: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists.END',
6858: 'ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists(-)');
6859: END IF;
6860:

Line 6866: FND_LOG.STRING(g_level_unexpected,

6862: WHEN OTHERS THEN
6863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6864:
6865: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6866: FND_LOG.STRING(g_level_unexpected,
6867: 'ZX.PLSQL.ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines',
6868: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6869: FND_LOG.STRING(g_level_unexpected,
6870: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists.END',

Line 6869: FND_LOG.STRING(g_level_unexpected,

6865: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6866: FND_LOG.STRING(g_level_unexpected,
6867: 'ZX.PLSQL.ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines',
6868: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6869: FND_LOG.STRING(g_level_unexpected,
6870: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists.END',
6871: 'ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists(-)');
6872: END IF;
6873: END create_mrc_tax_dists;