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_SERVICES_PUB_PKG dependencies on FND_LOG

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

90: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type,
91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: g_current_runtime_level NUMBER;
94: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
95: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
96: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
98: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: g_current_runtime_level NUMBER;
94: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
95: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
96: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
98: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:

Line 96: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

92:
93: g_current_runtime_level NUMBER;
94: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
95: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
96: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
98: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:
100: l_regime_not_effective varchar2(2000);

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

93: g_current_runtime_level NUMBER;
94: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
95: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
96: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
98: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:
100: l_regime_not_effective varchar2(2000);
101: l_tax_not_effective varchar2(2000);

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

94: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
95: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
96: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
98: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:
100: l_regime_not_effective varchar2(2000);
101: l_tax_not_effective varchar2(2000);
102: l_tax_status_not_effective varchar2(2000);

Line 303: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

299: char5_tbl NUMERIC_TBL_TYPE;
300:
301: BEGIN
302:
303: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
304:
305: IF (g_level_procedure >= g_current_runtime_level ) THEN
306: FND_LOG.STRING(g_level_procedure,
307: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.BEGIN',

Line 306: FND_LOG.STRING(g_level_procedure,

302:
303: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
304:
305: IF (g_level_procedure >= g_current_runtime_level ) THEN
306: FND_LOG.STRING(g_level_procedure,
307: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.BEGIN',
308: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(+) ');
309: END IF;
310:

Line 355: FND_LOG.STRING(g_level_statement,

351: p_event_class_rec);
352:
353: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
354: IF (g_level_statement >= g_current_runtime_level ) THEN
355: FND_LOG.STRING(g_level_statement,
356: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
357: 'After calling TRL, x_return_status = '|| x_return_status);
358: FND_LOG.STRING(g_level_statement,
359: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',

Line 358: FND_LOG.STRING(g_level_statement,

354: IF (g_level_statement >= g_current_runtime_level ) THEN
355: FND_LOG.STRING(g_level_statement,
356: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
357: 'After calling TRL, x_return_status = '|| x_return_status);
358: FND_LOG.STRING(g_level_statement,
359: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
360: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
361: END IF;
362: RETURN;

Line 376: FND_LOG.STRING(g_level_statement,

372: x_return_status);
373:
374: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
375: IF (g_level_statement >= g_current_runtime_level ) THEN
376: FND_LOG.STRING(g_level_statement,
377: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
378: 'After calling fetch tax lines, x_return_status = '
379: || x_return_status);
380: FND_LOG.STRING(g_level_statement,

Line 380: FND_LOG.STRING(g_level_statement,

376: FND_LOG.STRING(g_level_statement,
377: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
378: 'After calling fetch tax lines, x_return_status = '
379: || x_return_status);
380: FND_LOG.STRING(g_level_statement,
381: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
382: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
383: END IF;
384: RETURN;

Line 406: FND_LOG.STRING(g_level_statement,

402: l_rec_nrec_dist_tbl.delete;
403:
404: IF tax_line_counter = 0 THEN
405: IF (g_level_statement >= g_current_runtime_level ) THEN
406: FND_LOG.STRING(g_level_statement,
407: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
408: 'there is no tax lines that need to be processed ');
409:
410: FND_LOG.STRING(g_level_statement,

Line 410: FND_LOG.STRING(g_level_statement,

406: FND_LOG.STRING(g_level_statement,
407: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
408: 'there is no tax lines that need to be processed ');
409:
410: FND_LOG.STRING(g_level_statement,
411: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
412: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)'||x_return_status);
413: END IF;
414: RETURN;

Line 446: FND_LOG.STRING(g_level_statement,

442: x_return_status);
443:
444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
445: IF (g_level_statement >= g_current_runtime_level ) THEN
446: FND_LOG.STRING(g_level_statement,
447: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
448: 'After calling populate_trx_line_info, x_return_status = '
449: || x_return_status);
450: FND_LOG.STRING(g_level_statement,

Line 450: FND_LOG.STRING(g_level_statement,

446: FND_LOG.STRING(g_level_statement,
447: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
448: 'After calling populate_trx_line_info, x_return_status = '
449: || x_return_status);
450: FND_LOG.STRING(g_level_statement,
451: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
452: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
453: END IF;
454: RETURN;

Line 515: FND_LOG.STRING(g_level_statement,

511: adjusted_doc_dist_id_tbl(1) := NULL;
512: overriding_recovery_rate_tbl(1) := NULL;
513:
514: IF (g_level_statement >= g_current_runtime_level ) THEN
515: FND_LOG.STRING(g_level_statement,
516: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
517: 'trx_line_dist_id_tbl '
518: ||to_char(trx_line_dist_id_tbl(1)));
519: END IF;

Line 596: FND_LOG.STRING(g_level_statement,

592: p_error_buffer);
593:
594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: IF (g_level_statement >= g_current_runtime_level ) THEN
596: FND_LOG.STRING(g_level_statement,
597: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
598: 'After calling cancel_tax_line x_return_status = '
599: || x_return_status);
600: FND_LOG.STRING(g_level_statement,

Line 600: FND_LOG.STRING(g_level_statement,

596: FND_LOG.STRING(g_level_statement,
597: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
598: 'After calling cancel_tax_line x_return_status = '
599: || x_return_status);
600: FND_LOG.STRING(g_level_statement,
601: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
602: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
603: END IF;
604: RETURN;

Line 730: FND_LOG.STRING(g_level_statement,

726: p_error_buffer);
727:
728: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
729: IF (g_level_statement >= g_current_runtime_level ) THEN
730: FND_LOG.STRING(g_level_statement,
731: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
732: 'After calling calc_tax_dist x_return_status = '
733: || x_return_status);
734: FND_LOG.STRING(g_level_statement,

Line 734: FND_LOG.STRING(g_level_statement,

730: FND_LOG.STRING(g_level_statement,
731: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
732: 'After calling calc_tax_dist x_return_status = '
733: || x_return_status);
734: FND_LOG.STRING(g_level_statement,
735: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
736: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
737: END IF;
738: RETURN;

Line 755: FND_LOG.STRING(g_level_statement,

751: x_return_status);
752:
753: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
754: IF (g_level_statement >= g_current_runtime_level ) THEN
755: FND_LOG.STRING(g_level_statement,
756: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
757: 'After calling fetch_tax_distributions x_return_status = '
758: || x_return_status);
759: FND_LOG.STRING(g_level_statement,

Line 759: FND_LOG.STRING(g_level_statement,

755: FND_LOG.STRING(g_level_statement,
756: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
757: 'After calling fetch_tax_distributions x_return_status = '
758: || x_return_status);
759: FND_LOG.STRING(g_level_statement,
760: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
761: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
762: END IF;
763: RETURN;

Line 768: FND_LOG.STRING(g_level_statement,

764: END IF;
765: ELSE -- wrong l_action
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
767: IF (g_level_statement >= g_current_runtime_level ) THEN
768: FND_LOG.STRING(g_level_statement,
769: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
770: 'wrong dist level action code. l_action= '||l_action );
771: FND_LOG.STRING(g_level_statement,
772: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',

Line 771: FND_LOG.STRING(g_level_statement,

767: IF (g_level_statement >= g_current_runtime_level ) THEN
768: FND_LOG.STRING(g_level_statement,
769: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
770: 'wrong dist level action code. l_action= '||l_action );
771: FND_LOG.STRING(g_level_statement,
772: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
773: 'RETURN_STATUS = ' || x_return_status);
774: END IF;
775: RETURN;

Line 845: FND_LOG.STRING(g_level_statement,

841: l_rec_nrec_dist_begin_index := l_rec_nrec_dist_end_index + 1;
842: l_action := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_LEVEL_ACTION(1);
843:
844: IF (g_level_statement >= g_current_runtime_level ) THEN
845: FND_LOG.STRING(g_level_statement,
846: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
847: 'dist level action = ' || l_action);
848: END IF;
849:

Line 868: FND_LOG.STRING(g_level_statement,

864: p_error_buffer);
865:
866: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
867: IF (g_level_statement >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_statement,
869: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
870: 'After calling calc_tax_dist x_return_status = '
871: || x_return_status);
872: FND_LOG.STRING(g_level_statement,

Line 872: FND_LOG.STRING(g_level_statement,

868: FND_LOG.STRING(g_level_statement,
869: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
870: 'After calling calc_tax_dist x_return_status = '
871: || x_return_status);
872: FND_LOG.STRING(g_level_statement,
873: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
874: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
875: END IF;
876: RETURN;

Line 882: FND_LOG.STRING(g_level_statement,

878:
879: ELSE -- wrong l_action
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: IF (g_level_statement >= g_current_runtime_level ) THEN
882: FND_LOG.STRING(g_level_statement,
883: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
884: 'wrong dist level action code ' );
885:
886: END IF;

Line 907: FND_LOG.STRING(g_level_statement,

903: p_error_buffer);
904:
905: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
906: IF (g_level_statement >= g_current_runtime_level ) THEN
907: FND_LOG.STRING(g_level_statement,
908: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
909: 'After calling get_rec_nrec_dist_amt x_return_status = '
910: || x_return_status);
911: FND_LOG.STRING(g_level_statement,

Line 911: FND_LOG.STRING(g_level_statement,

907: FND_LOG.STRING(g_level_statement,
908: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
909: 'After calling get_rec_nrec_dist_amt x_return_status = '
910: || x_return_status);
911: FND_LOG.STRING(g_level_statement,
912: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
913: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
914: END IF;
915: RETURN;

Line 932: FND_LOG.STRING(g_level_statement,

928: p_error_buffer);
929:
930: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
931: IF (g_level_statement >= g_current_runtime_level ) THEN
932: FND_LOG.STRING(g_level_statement,
933: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
934: 'After calling ROUND_REC_NREC_AMT x_return_status = '
935: || x_return_status);
936: FND_LOG.STRING(g_level_statement,

Line 936: FND_LOG.STRING(g_level_statement,

932: FND_LOG.STRING(g_level_statement,
933: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
934: 'After calling ROUND_REC_NREC_AMT x_return_status = '
935: || x_return_status);
936: FND_LOG.STRING(g_level_statement,
937: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
938: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
939: END IF;
940: RETURN;

Line 959: -- FND_LOG.STRING(g_level_statement,

955: -- p_error_buffer);
956: --
957: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
958: -- IF (g_level_statement >= g_current_runtime_level ) THEN
959: -- FND_LOG.STRING(g_level_statement,
960: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
961: -- 'After calling create_mrc_tax_dists x_return_status = '
962: -- || x_return_status);
963: -- FND_LOG.STRING(g_level_statement,

Line 963: -- FND_LOG.STRING(g_level_statement,

959: -- FND_LOG.STRING(g_level_statement,
960: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
961: -- 'After calling create_mrc_tax_dists x_return_status = '
962: -- || x_return_status);
963: -- FND_LOG.STRING(g_level_statement,
964: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
965: -- 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
966: -- END IF;
967: -- RETURN;

Line 982: FND_LOG.STRING(g_level_statement,

978: x_return_status);
979:
980: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
981: IF (g_level_statement >= g_current_runtime_level ) THEN
982: FND_LOG.STRING(g_level_statement,
983: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
984: 'After calling insert_global_table x_return_status = '
985: || x_return_status);
986: FND_LOG.STRING(g_level_statement,

Line 986: FND_LOG.STRING(g_level_statement,

982: FND_LOG.STRING(g_level_statement,
983: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
984: 'After calling insert_global_table x_return_status = '
985: || x_return_status);
986: FND_LOG.STRING(g_level_statement,
987: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
988: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
989: END IF;
990: RETURN;

Line 1004: FND_LOG.STRING(g_level_statement,

1000: populate_mandatory_columns(l_rec_nrec_dist_tbl,x_return_status);
1001:
1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1003: IF (g_level_statement >= g_current_runtime_level ) THEN
1004: FND_LOG.STRING(g_level_statement,
1005: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1006: 'After calling populate_mandatory_columns x_return_status = '
1007: || x_return_status);
1008: FND_LOG.STRING(g_level_statement,

Line 1008: FND_LOG.STRING(g_level_statement,

1004: FND_LOG.STRING(g_level_statement,
1005: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1006: 'After calling populate_mandatory_columns x_return_status = '
1007: || x_return_status);
1008: FND_LOG.STRING(g_level_statement,
1009: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
1010: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
1011: END IF;
1012: RETURN;

Line 1028: FND_LOG.STRING(g_level_statement,

1024: x_return_status => x_return_status);
1025:
1026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: IF g_level_statement >= g_current_runtime_level THEN
1028: FND_LOG.STRING(g_level_statement,
1029: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1030: 'After calling delete_unnecessary_tax_dists, x_return_status = '
1031: || x_return_status);
1032: FND_LOG.STRING(g_level_statement,

Line 1032: FND_LOG.STRING(g_level_statement,

1028: FND_LOG.STRING(g_level_statement,
1029: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1030: 'After calling delete_unnecessary_tax_dists, x_return_status = '
1031: || x_return_status);
1032: FND_LOG.STRING(g_level_statement,
1033: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
1034: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
1035: END IF;
1036: RETURN;

Line 1043: FND_LOG.STRING(g_level_procedure,

1039:
1040:
1041: IF (g_level_procedure >= g_current_runtime_level ) THEN
1042:
1043: FND_LOG.STRING(g_level_procedure,
1044: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
1045: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)'||x_return_status);
1046: END IF;
1047:

Line 1054: FND_LOG.STRING(g_level_unexpected,

1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1052:
1053: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1054: FND_LOG.STRING(g_level_unexpected,
1055: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1056: p_error_buffer);
1057: FND_LOG.STRING(g_level_unexpected,
1058: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',

Line 1057: FND_LOG.STRING(g_level_unexpected,

1053: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1054: FND_LOG.STRING(g_level_unexpected,
1055: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1056: p_error_buffer);
1057: FND_LOG.STRING(g_level_unexpected,
1058: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.END',
1059: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)');
1060:
1061: END IF;

Line 1122: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1118: l_tax_line_amt_funcl_curr NUMBER;
1119:
1120: BEGIN
1121:
1122: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1123:
1124: IF (g_level_procedure >= g_current_runtime_level ) THEN
1125: FND_LOG.STRING(g_level_procedure,
1126: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.BEGIN',

Line 1125: FND_LOG.STRING(g_level_procedure,

1121:
1122: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1123:
1124: IF (g_level_procedure >= g_current_runtime_level ) THEN
1125: FND_LOG.STRING(g_level_procedure,
1126: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.BEGIN',
1127: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(+)');
1128: END IF;
1129:

Line 1214: FND_LOG.STRING(g_level_statement,

1210:
1211: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1212:
1213: IF (g_level_statement >= g_current_runtime_level ) THEN
1214: FND_LOG.STRING(g_level_statement,
1215: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1216: 'After calling ROUND_REC_NREC_AMT x_return_status = '
1217: || x_return_status);
1218: FND_LOG.STRING(g_level_statement,

Line 1218: FND_LOG.STRING(g_level_statement,

1214: FND_LOG.STRING(g_level_statement,
1215: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1216: 'After calling ROUND_REC_NREC_AMT x_return_status = '
1217: || x_return_status);
1218: FND_LOG.STRING(g_level_statement,
1219: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',
1220: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(-)');
1221: END IF;
1222: RETURN;

Line 1232: -- FND_LOG.STRING(g_level_statement,

1228: -- IF p_event_class_rec.enable_mrc_flag = 'Y' THEN
1229: -- -- create MRC tax distributions
1230: -- --
1231: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1232: -- FND_LOG.STRING(g_level_statement,
1233: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1234: -- 'create MRC tax distributions' );
1235: -- END IF;
1236: --

Line 1247: -- FND_LOG.STRING(g_level_statement,

1243: -- p_error_buffer);
1244: --
1245: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1246: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1247: -- FND_LOG.STRING(g_level_statement,
1248: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1249: -- 'After calling create_mrc_tax_dists x_return_status = '
1250: -- || x_return_status);
1251: -- FND_LOG.STRING(g_level_statement,

Line 1251: -- FND_LOG.STRING(g_level_statement,

1247: -- FND_LOG.STRING(g_level_statement,
1248: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1249: -- 'After calling create_mrc_tax_dists x_return_status = '
1250: -- || x_return_status);
1251: -- FND_LOG.STRING(g_level_statement,
1252: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',
1253: -- 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(-)');
1254: -- END IF;
1255: -- RETURN;

Line 1270: FND_LOG.STRING(g_level_statement,

1266:
1267: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1268:
1269: IF (g_level_statement >= g_current_runtime_level ) THEN
1270: FND_LOG.STRING(g_level_statement,
1271: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1272: 'After calling insert_global_table x_return_status = '
1273: || x_return_status);
1274: FND_LOG.STRING(g_level_statement,

Line 1274: FND_LOG.STRING(g_level_statement,

1270: FND_LOG.STRING(g_level_statement,
1271: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1272: 'After calling insert_global_table x_return_status = '
1273: || x_return_status);
1274: FND_LOG.STRING(g_level_statement,
1275: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',
1276: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(-)');
1277: END IF;
1278: RETURN;

Line 1294: FND_LOG.STRING(g_level_statement,

1290:
1291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1292:
1293: IF (g_level_statement >= g_current_runtime_level ) THEN
1294: FND_LOG.STRING(g_level_statement,
1295: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1296: 'After calling populate_mandatory_columns x_return_status = '
1297: || x_return_status);
1298: FND_LOG.STRING(g_level_statement,

Line 1298: FND_LOG.STRING(g_level_statement,

1294: FND_LOG.STRING(g_level_statement,
1295: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1296: 'After calling populate_mandatory_columns x_return_status = '
1297: || x_return_status);
1298: FND_LOG.STRING(g_level_statement,
1299: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',
1300: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(-)');
1301: END IF;
1302: RETURN;

Line 1322: FND_LOG.STRING(g_level_statement,

1318:
1319: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1320:
1321: IF (g_level_statement >= g_current_runtime_level ) THEN
1322: FND_LOG.STRING(g_level_statement,
1323: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1324: 'After calling calc_variance_factors ' ||
1325: 'x_return_status = ' || x_return_status);
1326: FND_LOG.STRING(g_level_statement,

Line 1326: FND_LOG.STRING(g_level_statement,

1322: FND_LOG.STRING(g_level_statement,
1323: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1324: 'After calling calc_variance_factors ' ||
1325: 'x_return_status = ' || x_return_status);
1326: FND_LOG.STRING(g_level_statement,
1327: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',
1328: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(-)');
1329: END IF;
1330: RETURN;

Line 1337: FND_LOG.STRING(g_level_procedure,

1333: END IF;
1334:
1335: IF (g_level_procedure >= g_current_runtime_level ) THEN
1336:
1337: FND_LOG.STRING(g_level_procedure,
1338: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',
1339: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(-)'||x_return_status);
1340: END IF;
1341:

Line 1348: FND_LOG.STRING(g_level_unexpected,

1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1346:
1347: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1348: FND_LOG.STRING(g_level_unexpected,
1349: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1350: p_error_buffer);
1351: FND_LOG.STRING(g_level_unexpected,
1352: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',

Line 1351: FND_LOG.STRING(g_level_unexpected,

1347: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1348: FND_LOG.STRING(g_level_unexpected,
1349: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1350: p_error_buffer);
1351: FND_LOG.STRING(g_level_unexpected,
1352: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.END',
1353: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(-)');
1354:
1355: END IF;

Line 1388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1384: WHERE rec_nrec_tax_dist_id IN (SELECT tax_dist_id FROM zx_tax_dist_id_gt);
1385:
1386: BEGIN
1387:
1388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1389:
1390: IF (g_level_procedure >= g_current_runtime_level ) THEN
1391: FND_LOG.STRING(g_level_procedure,
1392: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST.BEGIN',

Line 1391: FND_LOG.STRING(g_level_procedure,

1387:
1388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1389:
1390: IF (g_level_procedure >= g_current_runtime_level ) THEN
1391: FND_LOG.STRING(g_level_procedure,
1392: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST.BEGIN',
1393: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST(+)');
1394: END IF;
1395: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 1513: FND_LOG.STRING(g_level_procedure,

1509: CLOSE get_rec_nrec_dist_cur;
1510:
1511: IF (g_level_procedure >= g_current_runtime_level ) THEN
1512:
1513: FND_LOG.STRING(g_level_procedure,
1514: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST.END',
1515: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST(-)'||x_return_status);
1516: END IF;
1517:

Line 1524: FND_LOG.STRING(g_level_unexpected,

1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1522:
1523: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1524: FND_LOG.STRING(g_level_unexpected,
1525: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST',
1526: p_error_buffer);
1527: FND_LOG.STRING(g_level_unexpected,
1528: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST.END',

Line 1527: FND_LOG.STRING(g_level_unexpected,

1523: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1524: FND_LOG.STRING(g_level_unexpected,
1525: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST',
1526: p_error_buffer);
1527: FND_LOG.STRING(g_level_unexpected,
1528: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST.END',
1529: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST(-)');
1530:
1531: END IF;

Line 1568: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1564: l_tax_amount_range VARCHAR2(1);
1565:
1566: BEGIN
1567:
1568: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1569:
1570: IF (g_level_procedure >= g_current_runtime_level ) THEN
1571: FND_LOG.STRING(g_level_procedure,
1572: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX.BEGIN',

Line 1571: FND_LOG.STRING(g_level_procedure,

1567:
1568: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1569:
1570: IF (g_level_procedure >= g_current_runtime_level ) THEN
1571: FND_LOG.STRING(g_level_procedure,
1572: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX.BEGIN',
1573: 'ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX(+)');
1574: END IF;
1575:

Line 1600: FND_LOG.STRING(g_level_statement,

1596: x_hold_status(x_hold_status.count + 1) := ZX_TDS_CALC_SERVICES_PUB_PKG.G_TAX_VARIANCE_HOLD;
1597: l_tax_variance := 'Y';
1598:
1599: IF (g_level_statement >= g_current_runtime_level ) THEN
1600: FND_LOG.STRING(g_level_statement,
1601: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1602: 'hold code 1 : tax variance ');
1603: END IF;
1604: END IF;

Line 1611: FND_LOG.STRING(g_level_statement,

1607: x_hold_status(x_hold_status.count + 1) := ZX_TDS_CALC_SERVICES_PUB_PKG.G_TAX_AMT_RANGE_HOLD;
1608: l_tax_amount_range := 'Y';
1609:
1610: IF (g_level_statement >= g_current_runtime_level ) THEN
1611: FND_LOG.STRING(g_level_statement,
1612: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1613: 'hold code 2 : tax amount range');
1614: END IF;
1615: END IF;

Line 1622: FND_LOG.STRING(g_level_statement,

1618: x_hold_status(x_hold_status.count + 1) := ZX_TDS_CALC_SERVICES_PUB_PKG.G_TAX_VARIANCE_HOLD;
1619: l_tax_variance := 'Y';
1620:
1621: IF (g_level_statement >= g_current_runtime_level ) THEN
1622: FND_LOG.STRING(g_level_statement,
1623: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1624: 'hold code 3 : tax variance ');
1625: END IF;
1626: END IF;

Line 1632: FND_LOG.STRING(g_level_statement,

1628: x_hold_status(x_hold_status.count + 1) := ZX_TDS_CALC_SERVICES_PUB_PKG.G_TAX_AMT_RANGE_HOLD;
1629: l_tax_amount_range := 'Y';
1630:
1631: IF (g_level_statement >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_statement,
1633: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1634: 'hold code 3 : tax amount range');
1635: END IF;
1636: END IF;

Line 1894: FND_LOG.STRING(g_level_procedure,

1890:
1891:
1892: IF (g_level_procedure >= g_current_runtime_level ) THEN
1893:
1894: FND_LOG.STRING(g_level_procedure,
1895: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX.END',
1896: 'ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX(-)'||x_return_status);
1897: END IF;
1898:

Line 1908: FND_LOG.STRING(g_level_unexpected,

1904: CLOSE get_hold_status_csr;
1905: END IF;
1906:
1907: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1908: FND_LOG.STRING(g_level_unexpected,
1909: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1910: 'x_hold_status.tax_variance = '||l_tax_variance);
1911: FND_LOG.STRING(g_level_unexpected,
1912: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',

Line 1911: FND_LOG.STRING(g_level_unexpected,

1907: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1908: FND_LOG.STRING(g_level_unexpected,
1909: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1910: 'x_hold_status.tax_variance = '||l_tax_variance);
1911: FND_LOG.STRING(g_level_unexpected,
1912: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1913: 'x_hold_status.tax_amount_range = '||l_tax_amount_range);
1914: FND_LOG.STRING(g_level_unexpected,
1915: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',

Line 1914: FND_LOG.STRING(g_level_unexpected,

1910: 'x_hold_status.tax_variance = '||l_tax_variance);
1911: FND_LOG.STRING(g_level_unexpected,
1912: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1913: 'x_hold_status.tax_amount_range = '||l_tax_amount_range);
1914: FND_LOG.STRING(g_level_unexpected,
1915: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1916: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1917: FND_LOG.STRING(g_level_unexpected,
1918: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX.END',

Line 1917: FND_LOG.STRING(g_level_unexpected,

1913: 'x_hold_status.tax_amount_range = '||l_tax_amount_range);
1914: FND_LOG.STRING(g_level_unexpected,
1915: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX',
1916: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1917: FND_LOG.STRING(g_level_unexpected,
1918: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX.END',
1919: 'ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX(-)');
1920:
1921: END IF;

Line 1970: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1966: l_dist_count NUMBER;
1967:
1968: BEGIN
1969:
1970: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1971:
1972: IF (g_level_procedure >= g_current_runtime_level ) THEN
1973: FND_LOG.STRING(g_level_procedure,
1974: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS.BEGIN',

Line 1973: FND_LOG.STRING(g_level_procedure,

1969:
1970: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1971:
1972: IF (g_level_procedure >= g_current_runtime_level ) THEN
1973: FND_LOG.STRING(g_level_procedure,
1974: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS.BEGIN',
1975: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS(+)');
1976: END IF;
1977:

Line 2534: FND_LOG.STRING(g_level_procedure,

2530: -- SET REVERSE_FLAG = 'Y'
2531: -- WHERE REC_NREC_TAX_DIST_ID = l_rvrsed_tax_dist_id_tbl(i);
2532:
2533: IF (g_level_procedure >= g_current_runtime_level ) THEN
2534: FND_LOG.STRING(g_level_procedure,
2535: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS.END',
2536: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS(-)'||
2537: 'RETURN_STATUS = ' || x_return_status);
2538: END IF;

Line 2545: FND_LOG.STRING(g_level_unexpected,

2541: WHEN DUP_VAL_ON_INDEX THEN
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543:
2544: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2545: FND_LOG.STRING(g_level_unexpected,
2546: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',
2547: 'Tax Lines Distribution Record Already Exists');
2548: FND_LOG.STRING(g_level_unexpected,
2549: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',

Line 2548: FND_LOG.STRING(g_level_unexpected,

2544: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2545: FND_LOG.STRING(g_level_unexpected,
2546: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',
2547: 'Tax Lines Distribution Record Already Exists');
2548: FND_LOG.STRING(g_level_unexpected,
2549: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',
2550: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2551: END IF;
2552:

Line 2557: FND_LOG.STRING(g_level_unexpected,

2553: WHEN OTHERS THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2555:
2556: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2557: FND_LOG.STRING(g_level_unexpected,
2558: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',
2559: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2560: END IF;
2561:

Line 2563: FND_LOG.STRING(g_level_unexpected,

2559: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2560: END IF;
2561:
2562: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2563: FND_LOG.STRING(g_level_unexpected,
2564: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS.END',
2565: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS(-)');
2566: END IF;
2567:

Line 2678: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2674: -- - The Tax Liability Account should be derived using regular tax rate_id.
2675: -- the CCID to be returned in this case is the TAX_ACCOUNT_CCID.
2676:
2677:
2678: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2679:
2680: IF (g_level_procedure >= g_current_runtime_level ) THEN
2681:
2682: FND_LOG.STRING(g_level_procedure,

Line 2682: FND_LOG.STRING(g_level_procedure,

2678: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2679:
2680: IF (g_level_procedure >= g_current_runtime_level ) THEN
2681:
2682: FND_LOG.STRING(g_level_procedure,
2683: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID.BEGIN',
2684: 'ZX_TRD_SERVICES_PUB_PKG.GET_CCID(+)');
2685:
2686: END IF;

Line 2689: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Input Parameters:');

2685:
2686: END IF;
2687:
2688: IF (g_level_statement >= g_current_runtime_level ) THEN
2689: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Input Parameters:');
2690: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','GL Date:'||p_gl_date );
2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);
2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);

Line 2690: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','GL Date:'||p_gl_date );

2686: END IF;
2687:
2688: IF (g_level_statement >= g_current_runtime_level ) THEN
2689: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Input Parameters:');
2690: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','GL Date:'||p_gl_date );
2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);
2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);

Line 2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);

2687:
2688: IF (g_level_statement >= g_current_runtime_level ) THEN
2689: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Input Parameters:');
2690: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','GL Date:'||p_gl_date );
2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);
2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);

Line 2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);

2688: IF (g_level_statement >= g_current_runtime_level ) THEN
2689: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Input Parameters:');
2690: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','GL Date:'||p_gl_date );
2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);
2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);

Line 2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);

2689: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Input Parameters:');
2690: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','GL Date:'||p_gl_date );
2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);
2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);

Line 2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);

2690: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','GL Date:'||p_gl_date );
2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);
2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);

Line 2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);

2691: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Rate Id:'||p_tax_rate_id);
2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);
2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);

Line 2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);

2692: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recovery Rate Id:'||p_rec_rate_id);
2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);
2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);
2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);

Line 2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);

2693: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Self Assessed Flag:'||p_Self_Assessed_Flag);
2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);
2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);
2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);
2701: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);

Line 2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);

2694: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Recoverable Flag:'|| p_Recoverable_Flag);
2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);
2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);
2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);
2701: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);
2702: END IF;

Line 2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);

2695: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Org Id:'|| p_org_id);
2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);
2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);
2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);
2701: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);
2702: END IF;
2703:

Line 2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);

2696: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Ledger Id:'|| p_ledger_id);
2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);
2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);
2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);
2701: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);
2702: END IF;
2703:
2704: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2701: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);

2697: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax regime id:'||p_tax_regime_id);
2698: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Id:'|| p_tax_id);
2699: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Tax Status Id:'|| p_tax_status_id);
2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);
2701: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);
2702: END IF;
2703:
2704: x_return_status := FND_API.G_RET_STS_SUCCESS;
2705:

Line 2728: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2724: END IF;
2725: END IF;
2726:
2727: IF (g_level_statement >= g_current_runtime_level ) THEN
2728: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2729: 'Def_rec_settle_option_code: '|| l_def_rec_settle_option_code);
2730: END IF;
2731:
2732: IF p_account_source_tax_rate_id IS NOT NULL THEN

Line 2735: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2731:
2732: IF p_account_source_tax_rate_id IS NOT NULL THEN
2733: BEGIN
2734: IF (g_level_statement >= g_current_runtime_level ) THEN
2735: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2736: 'Getting account information using account source tax rate id:'||p_account_source_tax_rate_id);
2737: END IF;
2738:
2739: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_account_source_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN

Line 2741: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2737: END IF;
2738:
2739: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_account_source_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN
2740: IF (g_level_statement >= g_current_runtime_level ) THEN
2741: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2742: 'Getting from cache for p_account_sourece_tax_rate_id ');
2743: END IF;
2744:
2745: l_interim_tax_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_account_source_tax_rate_id)||'RATES'||to_char(p_org_id)).interim_tax_ccid;

Line 2751: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2747: l_nrec_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_account_source_tax_rate_id)||'RATES'||to_char(p_org_id)).non_rec_account_ccid;
2748:
2749: ELSE
2750: IF (g_level_statement >= g_current_runtime_level ) THEN
2751: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2752: 'Getting from database for p_account_sourece_tax_rate_id ');
2753: END IF;
2754:
2755: OPEN get_rec_nrec_ccid_cur(p_account_source_tax_rate_id, 'RATES',p_org_id);

Line 2767: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2763: END IF;
2764: EXCEPTION
2765: WHEN TOO_MANY_ROWS THEN
2766: IF (g_level_exception >= g_current_runtime_level ) THEN
2767: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2768: 'There are more than one set of accounts defined for this tax rate id: '||p_account_source_tax_rate_id||
2769: ' Please specify ledger in the input structure while calling get_ccid API.');
2770: END IF;
2771: IF get_rec_nrec_ccid_cur%ISOPEN THEN

Line 2776: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2772: CLOSE get_rec_nrec_ccid_cur;
2773: END IF;
2774: WHEN OTHERS THEN
2775: IF (g_level_exception >= g_current_runtime_level ) THEN
2776: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2777: 'EXCEPTION: OTHERS: '||SQLCODE||' ; '||SQLERRM);
2778: END IF;
2779: IF get_rec_nrec_ccid_cur%ISOPEN THEN
2780: CLOSE get_rec_nrec_ccid_cur;

Line 2795: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2791:
2792: IF l_ccid IS NULL THEN
2793: BEGIN
2794: IF (g_level_statement >= g_current_runtime_level ) THEN
2795: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2796: 'Getting account information using recovery rate id:'||p_rec_rate_id);
2797: END IF;
2798:
2799: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_rec_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN

Line 2801: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2797: END IF;
2798:
2799: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_rec_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN
2800: IF (g_level_statement >= g_current_runtime_level ) THEN
2801: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2802: 'Getting from cache for p_rec_rate_id ');
2803: END IF;
2804:
2805: l_interim_tax_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_rec_rate_id)||'RATES'||to_char(p_org_id)).interim_tax_ccid;

Line 2811: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2807: l_nrec_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_rec_rate_id)||'RATES'||to_char(p_org_id)).non_rec_account_ccid;
2808:
2809: ELSE
2810: IF (g_level_statement >= g_current_runtime_level ) THEN
2811: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2812: 'Getting from database for p_rec_rate_id ');
2813: END IF;
2814:
2815: OPEN get_rec_nrec_ccid_cur(p_rec_rate_id, 'RATES',p_org_id);

Line 2827: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2823: END IF;
2824: EXCEPTION
2825: WHEN TOO_MANY_ROWS THEN
2826: IF (g_level_exception >= g_current_runtime_level ) THEN
2827: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2828: 'There are more than one set of accounts defined for this tax rate id: '||p_rec_rate_id||
2829: ' Please specify ledger in the input structure while calling get_ccid API.');
2830: END IF;
2831: IF get_rec_nrec_ccid_cur%ISOPEN THEN

Line 2836: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2832: CLOSE get_rec_nrec_ccid_cur;
2833: END IF;
2834: WHEN OTHERS THEN
2835: IF (g_level_exception >= g_current_runtime_level ) THEN
2836: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2837: 'EXCEPTION: OTHERS: '||SQLCODE||' ; '||SQLERRM);
2838: END IF;
2839: IF get_rec_nrec_ccid_cur%ISOPEN THEN
2840: CLOSE get_rec_nrec_ccid_cur;

Line 2853: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2849:
2850: IF l_ccid IS NULL THEN
2851: BEGIN
2852: IF (g_level_statement >= g_current_runtime_level ) THEN
2853: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2854: 'Getting account information using tax rate id:'||p_tax_rate_id);
2855: END IF;
2856:
2857: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN

Line 2859: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2855: END IF;
2856:
2857: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN
2858: IF (g_level_statement >= g_current_runtime_level ) THEN
2859: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2860: 'Getting from cache for p_tax_rate_id ');
2861: END IF;
2862:
2863: l_interim_tax_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_tax_rate_id)||'RATES'||to_char(p_org_id)).interim_tax_ccid;

Line 2869: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2865: l_nrec_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_tax_rate_id)||'RATES'||to_char(p_org_id)).non_rec_account_ccid;
2866:
2867: ELSE
2868: IF (g_level_statement >= g_current_runtime_level ) THEN
2869: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2870: 'Getting from database for p_tax_rate_id ');
2871: END IF;
2872:
2873: OPEN get_rec_nrec_ccid_cur(p_tax_rate_id, 'RATES',p_org_id);

Line 2885: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2881: END IF;
2882: EXCEPTION
2883: WHEN TOO_MANY_ROWS THEN
2884: IF (g_level_exception >= g_current_runtime_level ) THEN
2885: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2886: 'There are more than one set of accounts defined for this tax rate id: '||p_tax_rate_id||
2887: ' Please specify ledger in the input structure while calling get_ccid API.');
2888: END IF;
2889: IF get_rec_nrec_ccid_cur%ISOPEN THEN

Line 2894: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2890: CLOSE get_rec_nrec_ccid_cur;
2891: END IF;
2892: WHEN OTHERS THEN
2893: IF (g_level_exception >= g_current_runtime_level ) THEN
2894: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2895: 'EXCEPTION: OTHERS: '||SQLCODE||' ; '||SQLERRM);
2896: END IF;
2897: IF get_rec_nrec_ccid_cur%ISOPEN THEN
2898: CLOSE get_rec_nrec_ccid_cur;

Line 2915: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2911: ELSIF p_Recoverable_Flag <> 'Y' THEN
2912: IF p_account_source_tax_rate_id IS NOT NULL THEN
2913: BEGIN
2914: IF (g_level_statement >= g_current_runtime_level ) THEN
2915: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2916: 'Getting account information using account source tax rate id:'||p_account_source_tax_rate_id);
2917: END IF;
2918:
2919: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_account_source_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN

Line 2921: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2917: END IF;
2918:
2919: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_account_source_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN
2920: IF (g_level_statement >= g_current_runtime_level ) THEN
2921: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2922: 'Getting from cache for p_account_source_tax_rate_id ');
2923: END IF;
2924:
2925: l_interim_tax_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_account_source_tax_rate_id)||'RATES'||to_char(p_org_id)).interim_tax_ccid;

Line 2931: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2927: l_nrec_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_account_source_tax_rate_id)||'RATES'||to_char(p_org_id)).non_rec_account_ccid;
2928:
2929: ELSE
2930: IF (g_level_statement >= g_current_runtime_level ) THEN
2931: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2932: 'Getting from database for p_account_source_tax_rate_id ');
2933: END IF;
2934:
2935: OPEN get_rec_nrec_ccid_cur(p_account_source_tax_rate_id, 'RATES',p_org_id);

Line 2947: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2943: END IF;
2944: EXCEPTION
2945: WHEN TOO_MANY_ROWS THEN
2946: IF (g_level_exception >= g_current_runtime_level ) THEN
2947: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2948: 'There are more than one set of accounts defined for this tax rate id: '||p_account_source_tax_rate_id||
2949: ' Please specify ledger in the input structure while calling get_ccid API.');
2950: END IF;
2951: IF get_rec_nrec_ccid_cur%ISOPEN THEN

Line 2956: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2952: CLOSE get_rec_nrec_ccid_cur;
2953: END IF;
2954: WHEN OTHERS THEN
2955: IF (g_level_exception >= g_current_runtime_level ) THEN
2956: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2957: 'EXCEPTION: OTHERS: '||SQLCODE||' ; '||SQLERRM);
2958: END IF;
2959: IF get_rec_nrec_ccid_cur%ISOPEN THEN
2960: CLOSE get_rec_nrec_ccid_cur;

Line 2970: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2966:
2967: IF l_ccid IS NULL THEN
2968: BEGIN
2969: IF (g_level_statement >= g_current_runtime_level ) THEN
2970: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2971: 'Getting account information using tax rate id:'||p_tax_rate_id);
2972: END IF;
2973:
2974: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN

Line 2976: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2972: END IF;
2973:
2974: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN
2975: IF (g_level_statement >= g_current_runtime_level ) THEN
2976: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2977: 'Getting from cache for p_tax_rate_id ');
2978: END IF;
2979:
2980: l_interim_tax_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_tax_rate_id)||'RATES'||to_char(p_org_id)).interim_tax_ccid;

Line 2986: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2982: l_nrec_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_tax_rate_id)||'RATES'||to_char(p_org_id)).non_rec_account_ccid;
2983:
2984: ELSE
2985: IF (g_level_statement >= g_current_runtime_level ) THEN
2986: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
2987: 'Getting from database for p_tax_rate_id ');
2988: END IF;
2989:
2990: OPEN get_rec_nrec_ccid_cur(p_tax_rate_id, 'RATES', p_org_id);

Line 3002: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

2998: END IF;
2999: EXCEPTION
3000: WHEN TOO_MANY_ROWS THEN
3001: IF (g_level_exception >= g_current_runtime_level ) THEN
3002: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3003: 'There are more than one set of accounts defined for this tax rate id: '||p_tax_rate_id||
3004: ' Please specify ledger in the input structure while calling get_ccid API.');
3005: END IF;
3006: IF get_rec_nrec_ccid_cur%ISOPEN THEN

Line 3011: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3007: CLOSE get_rec_nrec_ccid_cur;
3008: END IF;
3009: WHEN OTHERS THEN
3010: IF (g_level_exception >= g_current_runtime_level ) THEN
3011: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3012: 'EXCEPTION: OTHERS: '||SQLCODE||' ; '||SQLERRM);
3013: END IF;
3014: IF get_rec_nrec_ccid_cur%ISOPEN THEN
3015: CLOSE get_rec_nrec_ccid_cur;

Line 3024: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3020: END IF;
3021:
3022: IF l_ccid IS NULL THEN
3023: IF (g_level_statement >= g_current_runtime_level ) THEN
3024: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3025: 'Assigning the value of Revenue_Expense_CCID ');
3026: END IF;
3027: l_ccid := p_revenue_expense_ccid;
3028: END IF;

Line 3057: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3053: -- the CCID to be returned in this case is the TAX_ACCOUNT_CCID.
3054:
3055: BEGIN
3056: IF (g_level_statement >= g_current_runtime_level ) THEN
3057: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3058: 'Getting Liability account information using tax rate id:'||p_tax_rate_id);
3059: END IF;
3060:
3061: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN

Line 3063: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3059: END IF;
3060:
3061: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN
3062: IF (g_level_statement >= g_current_runtime_level ) THEN
3063: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3064: 'Getting from cache for p_tax_rate_id ');
3065: END IF;
3066:
3067: l_interim_tax_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_tax_rate_id)||'RATES'||to_char(p_org_id)).interim_tax_ccid;

Line 3074: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3070: l_nrec_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_tax_rate_id)||'RATES'||to_char(p_org_id)).non_rec_account_ccid;
3071:
3072: ELSE
3073: IF (g_level_statement >= g_current_runtime_level ) THEN
3074: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3075: 'Getting from database for p_tax_rate_id ');
3076: END IF;
3077:
3078: OPEN get_rec_nrec_ccid_cur(p_tax_rate_id, 'RATES',p_org_id);

Line 3091: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3087: END IF;
3088:
3089: IF l_tax_liab_ccid IS NULL AND p_Recoverable_Flag <> 'Y' THEN
3090: IF (g_level_statement >= g_current_runtime_level ) THEN
3091: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3092: 'Getting Liability account information using Account source tax rate id:'||p_account_source_tax_rate_id);
3093: END IF;
3094:
3095: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_account_source_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN

Line 3097: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3093: END IF;
3094:
3095: IF ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl.EXISTS(TO_CHAR(p_account_source_tax_rate_id)||'RATES'||TO_CHAR(p_org_id)) THEN
3096: IF (g_level_statement >= g_current_runtime_level ) THEN
3097: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3098: 'Getting from cache for p_account_source_tax_rate_id ');
3099: END IF;
3100:
3101: l_interim_tax_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_account_source_tax_rate_id)||'RATES'||to_char(p_org_id)).interim_tax_ccid;

Line 3108: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3104: l_nrec_ccid := ZX_GLOBAL_STRUCTURES_PKG.rec_nrec_ccid_tbl(to_char(p_account_source_tax_rate_id)||'RATES'||to_char(p_org_id)).non_rec_account_ccid;
3105:
3106: ELSE
3107: IF (g_level_statement >= g_current_runtime_level ) THEN
3108: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3109: 'Getting from database for p_account_source_tax_rate_id ');
3110: END IF;
3111:
3112: OPEN get_rec_nrec_ccid_cur(p_account_source_tax_rate_id, 'RATES',p_org_id);

Line 3126: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3122: END IF;
3123: EXCEPTION
3124: WHEN TOO_MANY_ROWS THEN
3125: IF (g_level_exception >= g_current_runtime_level ) THEN
3126: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3127: 'There are more than one set of accounts defined for this tax rate id: '||p_tax_rate_id||
3128: ' Please specify ledger in the input structure while calling get_ccid API.');
3129: END IF;
3130: IF get_rec_nrec_ccid_cur%ISOPEN THEN

Line 3135: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3131: CLOSE get_rec_nrec_ccid_cur;
3132: END IF;
3133: WHEN OTHERS THEN
3134: IF (g_level_exception >= g_current_runtime_level ) THEN
3135: FND_LOG.STRING(g_level_exception,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3136: 'EXCEPTION: OTHERS: '||SQLCODE||' ; '||SQLERRM);
3137: END IF;
3138: IF get_rec_nrec_ccid_cur%ISOPEN THEN
3139: CLOSE get_rec_nrec_ccid_cur;

Line 3193: FND_LOG.STRING(g_level_statement,

3189: FND_MESSAGE.SET_TOKEN('TAXRATE', l_rate_code);
3190: FND_MESSAGE.SET_TOKEN('SOURCE_TAXRATE', l_source_rate_code);
3191: FND_MSG_PUB.Add;
3192: IF (g_level_statement >= g_current_runtime_level ) THEN
3193: FND_LOG.STRING(g_level_statement,
3194: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3195: 'error: p_Recoverable_Flag is Y, but p_rec_nrec_ccid is null');
3196: END IF;
3197:

Line 3205: FND_LOG.STRING(g_level_statement,

3201: FND_MESSAGE.SET_TOKEN('TAXRATE', l_rate_code);
3202: FND_MESSAGE.SET_TOKEN('SOURCE_TAXRATE', l_source_rate_code);
3203: FND_MSG_PUB.Add;
3204: IF (g_level_statement >= g_current_runtime_level ) THEN
3205: FND_LOG.STRING(g_level_statement,
3206: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3207: 'error: p_Recoverable_Flag is N, but p_rec_nrec_ccid is null');
3208: END IF;
3209: END IF;

Line 3248: FND_LOG.STRING(g_level_statement,

3244: FND_MESSAGE.SET_TOKEN('TAXRATE', l_rate_code);
3245: FND_MESSAGE.SET_TOKEN('SOURCE_TAXRATE', l_source_rate_code);
3246: FND_MSG_PUB.Add;
3247: IF (g_level_statement >= g_current_runtime_level ) THEN
3248: FND_LOG.STRING(g_level_statement,
3249: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3250: 'error: p_Self_Assessed_Flag is Y, but p_tax_liab_ccid is null');
3251: END IF;
3252: END IF;

Line 3260: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3256: FETCH get_chart_of_account INTO l_chart_of_accounts_id;
3257: CLOSE get_chart_of_account;
3258:
3259: IF (g_level_statement >= g_current_runtime_level ) THEN
3260: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3261: 'Chart Of Accounts Id : '||l_chart_of_accounts_id);
3262: END IF;
3263:
3264: IF p_rec_nrec_ccid IS NOT NULL AND

Line 3269: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3265: l_chart_of_accounts_id IS NOT NULL
3266: THEN
3267:
3268: IF (g_level_statement >= g_current_runtime_level ) THEN
3269: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3270: 'Running security rules validation for Rec_Nrec_CCID : '||p_rec_nrec_ccid);
3271: END IF;
3272:
3273: IF NOT fnd_flex_keyval.validate_ccid

Line 3292: FND_LOG.STRING(g_level_statement,

3288: FND_MSG_PUB.Add;
3289: -- The account ACCOUNT derived for tax distribution violates the defined security rules --
3290: -- Please contact your Tax Manager --
3291: IF (g_level_statement >= g_current_runtime_level ) THEN
3292: FND_LOG.STRING(g_level_statement,
3293: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3294: 'error: Rec_Nrec_CCID violates the defined security rules');
3295: FND_LOG.STRING(g_level_statement,
3296: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

Line 3295: FND_LOG.STRING(g_level_statement,

3291: IF (g_level_statement >= g_current_runtime_level ) THEN
3292: FND_LOG.STRING(g_level_statement,
3293: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3294: 'error: Rec_Nrec_CCID violates the defined security rules');
3295: FND_LOG.STRING(g_level_statement,
3296: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3297: 'CCID: '||p_rec_nrec_ccid||', Account : '||l_account_string);
3298: END IF;
3299: END IF;

Line 3308: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

3304: l_chart_of_accounts_id IS NOT NULL
3305: THEN
3306:
3307: IF (g_level_statement >= g_current_runtime_level ) THEN
3308: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3309: 'Running security rules validation for Tax_Liab_CCID : '||p_tax_liab_ccid);
3310: END IF;
3311:
3312: IF NOT fnd_flex_keyval.validate_ccid

Line 3330: FND_LOG.STRING(g_level_statement,

3326: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_string);
3327: FND_MSG_PUB.Add;
3328:
3329: IF (g_level_statement >= g_current_runtime_level ) THEN
3330: FND_LOG.STRING(g_level_statement,
3331: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3332: 'error: Self Assessed Flag is Y and Tax_Liab_CCID violates the defined security rules');
3333: FND_LOG.STRING(g_level_statement,
3334: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

Line 3333: FND_LOG.STRING(g_level_statement,

3329: IF (g_level_statement >= g_current_runtime_level ) THEN
3330: FND_LOG.STRING(g_level_statement,
3331: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3332: 'error: Self Assessed Flag is Y and Tax_Liab_CCID violates the defined security rules');
3333: FND_LOG.STRING(g_level_statement,
3334: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3335: 'CCID: '||p_tax_liab_ccid||', Account : '||l_account_string);
3336: END IF;
3337: END IF;

Line 3342: FND_LOG.STRING(g_level_procedure,

3338: END IF;
3339: -- End : Bug#13948234 --
3340:
3341: IF (g_level_procedure >= g_current_runtime_level ) THEN
3342: FND_LOG.STRING(g_level_procedure,
3343: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID.END',
3344: 'ZX_TRD_SERVICES_PUB_PKG.GET_CCID(-)'||
3345: ' p_rec_nrec_ccid = '||p_rec_nrec_ccid||
3346: ' p_tax_liab_ccid = '||p_tax_liab_ccid||

Line 3355: FND_LOG.STRING(g_level_unexpected,

3351: WHEN OTHERS THEN
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353:
3354: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3355: FND_LOG.STRING(g_level_unexpected,
3356: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',
3357: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3358: END IF;
3359:

Line 3361: FND_LOG.STRING(g_level_unexpected,

3357: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3358: END IF;
3359:
3360: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3361: FND_LOG.STRING(g_level_unexpected,
3362: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID.END',
3363: 'ZX_TRD_SERVICES_PUB_PKG.GET_CCID(-)');
3364: END IF;
3365:

Line 3456: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3452: l_location_segment_id NUMBER;
3453:
3454: BEGIN
3455:
3456: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3457:
3458: IF (g_level_procedure >= g_current_runtime_level ) THEN
3459:
3460: FND_LOG.STRING(g_level_procedure,

Line 3460: FND_LOG.STRING(g_level_procedure,

3456: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3457:
3458: IF (g_level_procedure >= g_current_runtime_level ) THEN
3459:
3460: FND_LOG.STRING(g_level_procedure,
3461: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3462: 'ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID(+)');
3463:
3464: END IF;

Line 3468: FND_LOG.STRING(g_level_statement,

3464: END IF;
3465:
3466: IF (g_level_statement >= g_current_runtime_level ) THEN
3467:
3468: FND_LOG.STRING(g_level_statement,
3469: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3470: 'Input Parameters:');
3471: FND_LOG.STRING(g_level_statement,
3472: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',

Line 3471: FND_LOG.STRING(g_level_statement,

3467:
3468: FND_LOG.STRING(g_level_statement,
3469: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3470: 'Input Parameters:');
3471: FND_LOG.STRING(g_level_statement,
3472: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3473: 'GL Date:'||p_gl_date );
3474: FND_LOG.STRING(g_level_statement,
3475: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',

Line 3474: FND_LOG.STRING(g_level_statement,

3470: 'Input Parameters:');
3471: FND_LOG.STRING(g_level_statement,
3472: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3473: 'GL Date:'||p_gl_date );
3474: FND_LOG.STRING(g_level_statement,
3475: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3476: 'Tax Rate Id:'||p_tax_rate_id);
3477: FND_LOG.STRING(g_level_statement,
3478: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',

Line 3477: FND_LOG.STRING(g_level_statement,

3473: 'GL Date:'||p_gl_date );
3474: FND_LOG.STRING(g_level_statement,
3475: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3476: 'Tax Rate Id:'||p_tax_rate_id);
3477: FND_LOG.STRING(g_level_statement,
3478: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3479: 'Location Segment Id:'||p_location_segment_id);
3480: FND_LOG.STRING(g_level_statement,
3481: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',

Line 3480: FND_LOG.STRING(g_level_statement,

3476: 'Tax Rate Id:'||p_tax_rate_id);
3477: FND_LOG.STRING(g_level_statement,
3478: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3479: 'Location Segment Id:'||p_location_segment_id);
3480: FND_LOG.STRING(g_level_statement,
3481: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3482: 'Tax Line Id:'|| p_tax_line_id);
3483: FND_LOG.STRING(g_level_statement,
3484: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',

Line 3483: FND_LOG.STRING(g_level_statement,

3479: 'Location Segment Id:'||p_location_segment_id);
3480: FND_LOG.STRING(g_level_statement,
3481: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3482: 'Tax Line Id:'|| p_tax_line_id);
3483: FND_LOG.STRING(g_level_statement,
3484: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3485: 'Org Id:'|| p_org_id);
3486: FND_LOG.STRING(g_level_statement,
3487: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',

Line 3486: FND_LOG.STRING(g_level_statement,

3482: 'Tax Line Id:'|| p_tax_line_id);
3483: FND_LOG.STRING(g_level_statement,
3484: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3485: 'Org Id:'|| p_org_id);
3486: FND_LOG.STRING(g_level_statement,
3487: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
3488: 'Ledger Id:'|| p_ledger_id);
3489: END IF;
3490:

Line 3508: FND_LOG.STRING(g_level_statement,

3504: IF l_location_segment_id IS NOT NULL THEN
3505:
3506: IF (g_level_statement >= g_current_runtime_level ) THEN
3507:
3508: FND_LOG.STRING(g_level_statement,
3509: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3510: 'Getting accounts using Location Segment.. '||to_char(l_location_segment_id));
3511:
3512: END IF;

Line 3548: FND_LOG.STRING(g_level_statement,

3544: x_return_status);
3545:
3546: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3547: IF (g_level_statement >= g_current_runtime_level ) THEN
3548: FND_LOG.STRING(g_level_statement,
3549: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3550: 'After calling get_tax_jurisdiction_id, x_return_status = '|| x_return_status);
3551: FND_LOG.STRING(g_level_statement,
3552: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.END',

Line 3551: FND_LOG.STRING(g_level_statement,

3547: IF (g_level_statement >= g_current_runtime_level ) THEN
3548: FND_LOG.STRING(g_level_statement,
3549: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3550: 'After calling get_tax_jurisdiction_id, x_return_status = '|| x_return_status);
3551: FND_LOG.STRING(g_level_statement,
3552: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.END',
3553: 'ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID(-)');
3554: END IF;
3555: RETURN;

Line 3561: FND_LOG.STRING(g_level_statement,

3557:
3558: IF p_tax_account_ccid IS NULL THEN
3559: IF p_tax_line_id IS NOT NULL THEN
3560: IF (g_level_statement >= g_current_runtime_level ) THEN
3561: FND_LOG.STRING(g_level_statement,
3562: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3563: 'Getting account information for the jurisdiction id '||to_char(l_tax_jurisdiction_id));
3564: END IF;
3565: IF l_tax_jurisdiction_id IS NOT NULL THEN

Line 3577: FND_LOG.STRING(g_level_statement,

3573: close get_zx_account_ccid;
3574:
3575:
3576: IF (g_level_statement >= g_current_runtime_level ) THEN
3577: FND_LOG.STRING(g_level_statement,
3578: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3579: 'Tax account for jurisdiction_id '||to_char(l_tax_jurisdiction_id)||
3580: ' is: '||to_char(p_tax_account_ccid));
3581: END IF;

Line 3605: FND_LOG.STRING(g_level_statement,

3601:
3602: IF p_tax_line_id IS NOT NULL THEN
3603:
3604: IF (g_level_statement >= g_current_runtime_level ) THEN
3605: FND_LOG.STRING(g_level_statement,
3606: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3607: 'Getting account source tax rate id for tax line id '||to_char(p_tax_line_id));
3608: END IF;
3609:

Line 3624: FND_LOG.STRING(g_level_statement,

3620: close get_zx_account_ccid;
3621:
3622:
3623: IF (g_level_statement >= g_current_runtime_level ) THEN
3624: FND_LOG.STRING(g_level_statement,
3625: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3626: 'Tax account for acct_source_tax_rate_id '||to_char(l_acc_src_tax_rate_id)||
3627: ' is: '||to_char(p_tax_account_ccid));
3628: END IF;

Line 3651: FND_LOG.STRING(g_level_statement,

3647: IF p_tax_account_ccid is null THEN
3648: IF l_tax_rate_id is not null THEN
3649:
3650: IF (g_level_statement >= g_current_runtime_level ) THEN
3651: FND_LOG.STRING(g_level_statement,
3652: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3653: 'Getting account information using tax rate id: '||to_char(l_tax_rate_id));
3654: END IF;
3655:

Line 3697: FND_LOG.STRING(g_level_procedure,

3693: END IF; -- p_interim_tax_ccid is not null
3694:
3695: IF (g_level_procedure >= g_current_runtime_level ) THEN
3696:
3697: FND_LOG.STRING(g_level_procedure,
3698: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.END',
3699: 'ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID(-)'||
3700: ' tax_account_ccid = ' || p_tax_account_ccid ||
3701: ' interim_tax_ccid = ' || p_interim_tax_ccid ||

Line 3721: FND_LOG.STRING(g_level_unexpected,

3717: WHEN OTHERS THEN
3718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3719:
3720: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3721: FND_LOG.STRING(g_level_unexpected,
3722: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3723: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3724: END IF;
3725:

Line 3727: FND_LOG.STRING(g_level_unexpected,

3723: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3724: END IF;
3725:
3726: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3727: FND_LOG.STRING(g_level_unexpected,
3728: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.END',
3729: 'ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID(-)');
3730: END IF;
3731:

Line 3750: FND_LOG.STRING(g_level_procedure,

3746:
3747: BEGIN
3748:
3749: IF (g_level_procedure >= g_current_runtime_level ) THEN
3750: FND_LOG.STRING(g_level_procedure,
3751: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST.BEGIN',
3752: 'ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST(+)');
3753: END IF;
3754:

Line 3864: FND_LOG.STRING(g_level_procedure,

3860: AND trx_line_id = p_tax_line_rec.trx_line_id
3861: AND trx_level_type = p_tax_line_rec.trx_level_type;
3862:
3863: IF (g_level_procedure >= g_current_runtime_level ) THEN
3864: FND_LOG.STRING(g_level_procedure,
3865: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST.END',
3866: 'ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST(-)');
3867: END IF;
3868:

Line 3874: FND_LOG.STRING(g_level_unexpected,

3870: WHEN DUP_VAL_ON_INDEX THEN
3871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3872:
3873: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3874: FND_LOG.STRING(g_level_unexpected,
3875: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',
3876: 'TRL Record Already Exists');
3877: FND_LOG.STRING(g_level_unexpected,
3878: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',

Line 3877: FND_LOG.STRING(g_level_unexpected,

3873: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3874: FND_LOG.STRING(g_level_unexpected,
3875: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',
3876: 'TRL Record Already Exists');
3877: FND_LOG.STRING(g_level_unexpected,
3878: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',
3879: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3880: END IF;
3881:

Line 3886: FND_LOG.STRING(g_level_unexpected,

3882: WHEN OTHERS THEN
3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3884:
3885: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3886: FND_LOG.STRING(g_level_unexpected,
3887: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',
3888: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3889: END IF;
3890:

Line 3892: FND_LOG.STRING(g_level_unexpected,

3888: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3889: END IF;
3890:
3891: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3892: FND_LOG.STRING(g_level_unexpected,
3893: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist.END',
3894: 'ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST(-)');
3895: END IF;
3896: END insert_item_dist;

Line 3951: FND_LOG.STRING(g_level_procedure,

3947: l_error_buffer VARCHAR2(240);
3948: BEGIN
3949:
3950: IF (g_level_procedure >= g_current_runtime_level ) THEN
3951: FND_LOG.STRING(g_level_procedure,
3952: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines.BEGIN',
3953: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines(+)');
3954: END IF;
3955:

Line 3976: FND_LOG.STRING(g_level_procedure,

3972:
3973: IF get_funcl_curr_info_csr%NOTFOUND THEN
3974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3975: IF (g_level_procedure >= g_current_runtime_level ) THEN
3976: FND_LOG.STRING(g_level_procedure,
3977: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines',
3978: 'No data found for the specified ledger_id');
3979: END IF;
3980: END IF;

Line 4024: FND_LOG.STRING(g_level_procedure,

4020: END IF;
4021:
4022: IF (g_level_procedure >= g_current_runtime_level ) THEN
4023:
4024: FND_LOG.STRING(g_level_procedure,
4025: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines.END',
4026: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines(-)'||x_return_status);
4027: END IF;
4028:

Line 4034: FND_LOG.STRING(g_level_unexpected,

4030: WHEN OTHERS THEN
4031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4032:
4033: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4034: FND_LOG.STRING(g_level_unexpected,
4035: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines',
4036: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4037: FND_LOG.STRING(g_level_unexpected,
4038: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines.END',

Line 4037: FND_LOG.STRING(g_level_unexpected,

4033: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4034: FND_LOG.STRING(g_level_unexpected,
4035: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines',
4036: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4037: FND_LOG.STRING(g_level_unexpected,
4038: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines.END',
4039: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines(-)');
4040: END IF;
4041:

Line 4081: FND_LOG.STRING(g_level_procedure,

4077:
4078: BEGIN
4079:
4080: IF (g_level_procedure>= g_current_runtime_level ) THEN
4081: FND_LOG.STRING(g_level_procedure,
4082: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions.BEGIN',
4083: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions(+)'||
4084: ' tax_line_id = ' || p_tax_line_id||
4085: ' trx_line_dist_id = ' || p_trx_line_dist_id);

Line 4107: FND_LOG.STRING(g_level_statement,

4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4104: CLOSE fetch_tax_distributions_csr;
4105: IF (g_level_statement >= g_current_runtime_level ) THEN
4106:
4107: FND_LOG.STRING(g_level_statement,
4108: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions.END',
4109: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions(-)'||' unexpected: No tax dist');
4110: END IF;
4111: RETURN;

Line 4128: FND_LOG.STRING(g_level_procedure,

4124: CLOSE fetch_tax_distributions_csr;
4125:
4126: IF (g_level_procedure >= g_current_runtime_level ) THEN
4127:
4128: FND_LOG.STRING(g_level_procedure,
4129: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions.END',
4130: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions(-)'||x_return_status);
4131: END IF;
4132:

Line 4138: FND_LOG.STRING(g_level_unexpected,

4134: WHEN OTHERS THEN
4135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4136:
4137: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4138: FND_LOG.STRING(g_level_unexpected,
4139: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions',
4140: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4141: FND_LOG.STRING(g_level_unexpected,
4142: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions.END',

Line 4141: FND_LOG.STRING(g_level_unexpected,

4137: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4138: FND_LOG.STRING(g_level_unexpected,
4139: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions',
4140: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4141: FND_LOG.STRING(g_level_unexpected,
4142: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions.END',
4143: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions(-)');
4144: END IF;
4145:

Line 4251: FND_LOG.STRING(g_level_procedure,

4247:
4248: BEGIN
4249:
4250: IF (g_level_procedure >= g_current_runtime_level ) THEN
4251: FND_LOG.STRING(g_level_procedure,
4252: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info.BEGIN',
4253: 'ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info(+)');
4254: END IF;
4255:

Line 4388: FND_LOG.STRING(g_level_statement,

4384: END LOOP;
4385:
4386: IF get_trx_info_csr%NOTFOUND THEN
4387: IF (g_level_statement >= g_current_runtime_level ) THEN
4388: FND_LOG.STRING(g_level_statement,
4389: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info',
4390: 'NO DATA found in zx_lines_det_factors for trx line'||
4391: p_tax_line_tbl(p_index).trx_line_id);
4392: END IF;

Line 4398: FND_LOG.STRING(g_level_procedure,

4394: CLOSE get_trx_info_csr;
4395:
4396: IF (g_level_procedure >= g_current_runtime_level ) THEN
4397:
4398: FND_LOG.STRING(g_level_procedure,
4399: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info.END',
4400: 'ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info(-)'||x_return_status);
4401: END IF;
4402:

Line 4408: FND_LOG.STRING(g_level_unexpected,

4404: WHEN OTHERS THEN
4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406:
4407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4408: FND_LOG.STRING(g_level_unexpected,
4409: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info',
4410: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4411: FND_LOG.STRING(g_level_unexpected,
4412: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info.END',

Line 4411: FND_LOG.STRING(g_level_unexpected,

4407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4408: FND_LOG.STRING(g_level_unexpected,
4409: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info',
4410: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4411: FND_LOG.STRING(g_level_unexpected,
4412: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info.END',
4413: 'ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info(-)');
4414: END IF;
4415:

Line 4437: FND_LOG.STRING(g_level_procedure,

4433:
4434: BEGIN
4435:
4436: IF (g_level_procedure >= g_current_runtime_level ) THEN
4437: FND_LOG.STRING(g_level_procedure,
4438: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table.BEGIN',
4439: 'ZX_TRD_SERVICES_PUB_PKG.insert_global_table(+)');
4440: END IF;
4441:

Line 4455: FND_LOG.STRING(g_level_statement,

4451:
4452: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4453:
4454: IF (g_level_statement >= g_current_runtime_level ) THEN
4455: FND_LOG.STRING(g_level_statement,
4456: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',
4457: 'After calling populate_mandatory_columns x_return_status = '
4458: || x_return_status);
4459: FND_LOG.STRING(g_level_statement,

Line 4459: FND_LOG.STRING(g_level_statement,

4455: FND_LOG.STRING(g_level_statement,
4456: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',
4457: 'After calling populate_mandatory_columns x_return_status = '
4458: || x_return_status);
4459: FND_LOG.STRING(g_level_statement,
4460: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table.END',
4461: 'ZX_TRD_SERVICES_PUB_PKG.insert_global_table(-)');
4462: END IF;
4463: RETURN;

Line 4480: FND_LOG.STRING(g_level_procedure,

4476: END IF;
4477:
4478: IF (g_level_procedure >= g_current_runtime_level ) THEN
4479:
4480: FND_LOG.STRING(g_level_procedure,
4481: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table.END',
4482: 'ZX_TRD_SERVICES_PUB_PKG.insert_global_table(-)'||x_return_status);
4483: END IF;
4484:

Line 4490: FND_LOG.STRING(g_level_unexpected,

4486: WHEN OTHERS THEN
4487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4488:
4489: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4490: FND_LOG.STRING(g_level_unexpected,
4491: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',
4492: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4493: FND_LOG.STRING(g_level_unexpected,
4494: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table.END',

Line 4493: FND_LOG.STRING(g_level_unexpected,

4489: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4490: FND_LOG.STRING(g_level_unexpected,
4491: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',
4492: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4493: FND_LOG.STRING(g_level_unexpected,
4494: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table.END',
4495: 'ZX_TRD_SERVICES_PUB_PKG.insert_global_table(-)');
4496: END IF;
4497:

Line 4520: FND_LOG.STRING(g_level_procedure,

4516:
4517: BEGIN
4518:
4519: IF (g_level_procedure >= g_current_runtime_level ) THEN
4520: FND_LOG.STRING(g_level_procedure,
4521: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.BEGIN',
4522: 'populate_mandatory_columns(+)');
4523: END IF;
4524:

Line 4578: FND_LOG.STRING(g_level_procedure,

4574:
4575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
4576:
4577: IF (g_level_procedure >= g_current_runtime_level ) THEN
4578: FND_LOG.STRING(g_level_procedure,
4579: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4580: 'error: tax dist number is null ');
4581:
4582: FND_LOG.STRING(g_level_procedure,

Line 4582: FND_LOG.STRING(g_level_procedure,

4578: FND_LOG.STRING(g_level_procedure,
4579: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4580: 'error: tax dist number is null ');
4581:
4582: FND_LOG.STRING(g_level_procedure,
4583: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',
4584: 'populate_mandatory_columns(-)');
4585: END IF;
4586: RETURN;

Line 4594: FND_LOG.STRING(g_level_procedure,

4590: IF p_rec_nrec_dist_tbl(i).REC_NREC_RATE IS NULL THEN
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4592:
4593: IF (g_level_procedure >= g_current_runtime_level ) THEN
4594: FND_LOG.STRING(g_level_procedure,
4595: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4596: 'error: rec nrec rate is null ');
4597:
4598: FND_LOG.STRING(g_level_procedure,

Line 4598: FND_LOG.STRING(g_level_procedure,

4594: FND_LOG.STRING(g_level_procedure,
4595: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4596: 'error: rec nrec rate is null ');
4597:
4598: FND_LOG.STRING(g_level_procedure,
4599: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',
4600: 'populate_mandatory_columns(-)');
4601: END IF;
4602: RETURN;

Line 4611: FND_LOG.STRING(g_level_procedure,

4607:
4608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4609: IF (g_level_procedure >= g_current_runtime_level ) THEN
4610:
4611: FND_LOG.STRING(g_level_procedure,
4612: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4613: 'error: RECOVERABLE FLG is null ');
4614: FND_LOG.STRING(g_level_procedure,
4615: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',

Line 4614: FND_LOG.STRING(g_level_procedure,

4610:
4611: FND_LOG.STRING(g_level_procedure,
4612: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4613: 'error: RECOVERABLE FLG is null ');
4614: FND_LOG.STRING(g_level_procedure,
4615: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',
4616: 'populate_mandatory_columns(-)');
4617: END IF;
4618: RETURN;

Line 4627: FND_LOG.STRING(g_level_procedure,

4623:
4624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4625:
4626: IF (g_level_procedure >= g_current_runtime_level ) THEN
4627: FND_LOG.STRING(g_level_procedure,
4628: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4629: 'error: tax dist amount is null ');
4630: FND_LOG.STRING(g_level_procedure,
4631: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',

Line 4630: FND_LOG.STRING(g_level_procedure,

4626: IF (g_level_procedure >= g_current_runtime_level ) THEN
4627: FND_LOG.STRING(g_level_procedure,
4628: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4629: 'error: tax dist amount is null ');
4630: FND_LOG.STRING(g_level_procedure,
4631: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',
4632: 'populate_mandatory_columns(-)');
4633: END IF;
4634: RETURN;

Line 4644: FND_LOG.STRING(g_level_statement,

4640:
4641: else
4642:
4643: IF (g_level_statement >= g_current_runtime_level ) THEN
4644: FND_LOG.STRING(g_level_statement,
4645: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4646: 'No record in p_rec_nrec_dist_tbl ... ');
4647: END IF;
4648:

Line 4653: FND_LOG.STRING(g_level_procedure,

4649: end if;
4650:
4651: IF (g_level_procedure >= g_current_runtime_level ) THEN
4652:
4653: FND_LOG.STRING(g_level_procedure,
4654: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',
4655: 'ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns(-)'||x_return_status);
4656: END IF;
4657:

Line 4663: FND_LOG.STRING(g_level_unexpected,

4659: WHEN OTHERS THEN
4660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4661:
4662: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4663: FND_LOG.STRING(g_level_unexpected,
4664: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4665: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4666: FND_LOG.STRING(g_level_unexpected,
4667: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',

Line 4666: FND_LOG.STRING(g_level_unexpected,

4662: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4663: FND_LOG.STRING(g_level_unexpected,
4664: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',
4665: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4666: FND_LOG.STRING(g_level_unexpected,
4667: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.END',
4668: 'ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns(-)');
4669: END IF;
4670:

Line 4807: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4803: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
4804:
4805: BEGIN
4806:
4807: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4808:
4809: IF (g_level_procedure >= g_current_runtime_level ) THEN
4810: FND_LOG.STRING(g_level_procedure,
4811: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate.BEGIN',

Line 4810: FND_LOG.STRING(g_level_procedure,

4806:
4807: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4808:
4809: IF (g_level_procedure >= g_current_runtime_level ) THEN
4810: FND_LOG.STRING(g_level_procedure,
4811: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate.BEGIN',
4812: 'ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate(+)');
4813: END IF;
4814:

Line 4839: FND_LOG.STRING(g_level_statement,

4835:
4836: IF l_rec_nrec_tax_dist_id_tbl.FIRST IS NULL THEN
4837:
4838: IF (g_level_statement >= g_current_runtime_level ) THEN
4839: FND_LOG.STRING(g_level_statement,
4840: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate',
4841: 'No tax distributions are fetched from ZX_REC_NREC_DIST.');
4842: END IF;
4843: RETURN;

Line 4878: FND_LOG.STRING(g_level_statement,

4874: l_minimum_accountable_unit, l_funcl_currency_code;
4875: CLOSE get_mau_info_csr;
4876:
4877: IF (g_level_statement >= g_current_runtime_level ) THEN
4878: FND_LOG.STRING(g_level_statement,
4879: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate',
4880: 'l_minimum_accountable_unit = ' || l_minimum_accountable_unit);
4881: END IF;
4882:

Line 5545: FND_LOG.STRING(g_level_procedure,

5541: AND event_class_code = p_event_class_rec.event_class_code
5542: AND trx_id = p_event_class_rec.trx_id;
5543:
5544: IF (g_level_procedure >= g_current_runtime_level ) THEN
5545: FND_LOG.STRING(g_level_procedure,
5546: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate.END',
5547: 'ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate(-)');
5548: END IF;
5549:

Line 5558: FND_LOG.STRING(g_level_unexpected,

5554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5555: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5556:
5557: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5558: FND_LOG.STRING(g_level_unexpected,
5559: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate',
5560: l_error_buffer);
5561: FND_LOG.STRING(g_level_unexpected,
5562: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate.END',

Line 5561: FND_LOG.STRING(g_level_unexpected,

5557: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5558: FND_LOG.STRING(g_level_unexpected,
5559: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate',
5560: l_error_buffer);
5561: FND_LOG.STRING(g_level_unexpected,
5562: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate.END',
5563: 'ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate(-)');
5564: END IF;
5565:

Line 5592: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5588: l_error_buffer VARCHAR2(200);
5589:
5590: BEGIN
5591:
5592: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5593:
5594: IF (g_level_statement >= g_current_runtime_level ) THEN
5595: FND_LOG.STRING(g_level_statement,
5596: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau.BEGIN',

Line 5595: FND_LOG.STRING(g_level_statement,

5591:
5592: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5593:
5594: IF (g_level_statement >= g_current_runtime_level ) THEN
5595: FND_LOG.STRING(g_level_statement,
5596: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau.BEGIN',
5597: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau(+)');
5598: END IF;
5599:

Line 5612: FND_LOG.STRING(g_level_statement,

5608: l_rounded_amt_to_mau := round(p_unrounded_amt/l_mau ) * l_mau;
5609:
5610: IF (g_level_statement >= g_current_runtime_level ) THEN
5611:
5612: FND_LOG.STRING(g_level_statement,
5613: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau.END',
5614: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau(-)'||
5615: ' rounded amt to mau '||l_rounded_amt_to_mau);
5616: END IF;

Line 5625: FND_LOG.STRING(g_level_unexpected,

5621: WHEN OTHERS THEN
5622: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5623:
5624: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5625: FND_LOG.STRING(g_level_unexpected,
5626: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau',
5627: l_error_buffer);
5628: FND_LOG.STRING(g_level_unexpected,
5629: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau.END',

Line 5628: FND_LOG.STRING(g_level_unexpected,

5624: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5625: FND_LOG.STRING(g_level_unexpected,
5626: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau',
5627: l_error_buffer);
5628: FND_LOG.STRING(g_level_unexpected,
5629: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau.END',
5630: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau(-)');
5631: END IF;
5632: RAISE;

Line 5651: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5647: p_tax_hold_released_code IN VARCHAR2
5648: ) RETURN NUMBER IS
5649: l_tax_hold_release_value NUMBER;
5650: BEGIN
5651: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5652:
5653: IF (g_level_statement >= g_current_runtime_level ) THEN
5654: FND_LOG.STRING(g_level_statement,
5655: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.get_tax_hold_rls_val_frm_code.BEGIN',

Line 5654: FND_LOG.STRING(g_level_statement,

5650: BEGIN
5651: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5652:
5653: IF (g_level_statement >= g_current_runtime_level ) THEN
5654: FND_LOG.STRING(g_level_statement,
5655: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.get_tax_hold_rls_val_frm_code.BEGIN',
5656: 'ZX_TRD_SERVICES_PUB_PKG.get_tax_hold_rls_val_frm_code(+)');
5657: END IF;
5658:

Line 5668: FND_LOG.STRING(g_level_statement,

5664: l_tax_hold_release_value := 0;
5665: END IF;
5666:
5667: IF (g_level_statement >= g_current_runtime_level ) THEN
5668: FND_LOG.STRING(g_level_statement,
5669: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.get_tax_hold_rls_val_frm_code.END',
5670: 'ZX_TRD_SERVICES_PUB_PKG.get_tax_hold_rls_val_frm_code(-)');
5671: END IF;
5672: RETURN l_tax_hold_release_value;

Line 5697: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5693: l_prd_total_tax_amt NUMBER;
5694:
5695: BEGIN
5696:
5697: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5698:
5699: IF (g_level_procedure >= g_current_runtime_level ) THEN
5700: FND_LOG.STRING(g_level_procedure,
5701: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.get_prod_total_tax_amt.BEGIN',

Line 5700: FND_LOG.STRING(g_level_procedure,

5696:
5697: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5698:
5699: IF (g_level_procedure >= g_current_runtime_level ) THEN
5700: FND_LOG.STRING(g_level_procedure,
5701: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.get_prod_total_tax_amt.BEGIN',
5702: 'ZX_TRD_SERVICES_PUB_PKG.get_prod_total_tax_amt(+)');
5703: END IF;
5704:

Line 5710: FND_LOG.STRING(g_level_statement,

5706: l_prd_total_tax_amt := p_prepay_tax_amt * p_line_amt / p_prepay_line_amt;
5707:
5708: ELSE
5709: IF (g_level_statement >= g_current_runtime_level ) THEN
5710: FND_LOG.STRING(g_level_statement,
5711: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.get_prod_total_tax_amt',
5712: 'p_prepay_line_amt is '||NVL(TO_CHAR(p_prepay_line_amt), 'NULL'));
5713: END IF;
5714:

Line 5718: FND_LOG.STRING(g_level_procedure,

5714:
5715: END IF;
5716:
5717: IF (g_level_procedure >= g_current_runtime_level ) THEN
5718: FND_LOG.STRING(g_level_procedure,
5719: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.get_prod_total_tax_amt.END',
5720: 'ZX_TRD_SERVICES_PUB_PKG.get_prod_total_tax_amt(-)');
5721: END IF;
5722:

Line 5828: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5824: l_error_buffer VARCHAR2(200);
5825:
5826: BEGIN
5827:
5828: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5829:
5830: IF (g_level_procedure >= g_current_runtime_level ) THEN
5831: FND_LOG.STRING(g_level_procedure,
5832: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected.BEGIN',

Line 5831: FND_LOG.STRING(g_level_procedure,

5827:
5828: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5829:
5830: IF (g_level_procedure >= g_current_runtime_level ) THEN
5831: FND_LOG.STRING(g_level_procedure,
5832: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected.BEGIN',
5833: 'ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected(+)');
5834: END IF;
5835:

Line 5937: FND_LOG.STRING(g_level_procedure,

5933: END LOOP; -- tax_dist_rec IN get_tax_dists_csr
5934: END LOOP; -- i IN p_pa_item_info_tbl.FIRST .. p_pa_item_info_tbl.LAST
5935:
5936: IF (g_level_procedure >= g_current_runtime_level ) THEN
5937: FND_LOG.STRING(g_level_procedure,
5938: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected.END',
5939: 'ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected(-)');
5940: END IF;
5941:

Line 5948: FND_LOG.STRING(g_level_unexpected,

5944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5945: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5946:
5947: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5948: FND_LOG.STRING(g_level_unexpected,
5949: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected',
5950: l_error_buffer);
5951: FND_LOG.STRING(g_level_unexpected,
5952: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected.END',

Line 5951: FND_LOG.STRING(g_level_unexpected,

5947: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5948: FND_LOG.STRING(g_level_unexpected,
5949: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected',
5950: l_error_buffer);
5951: FND_LOG.STRING(g_level_unexpected,
5952: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected.END',
5953: 'ZX_TRD_SERVICES_PUB_PKG.ZX_TRD_SERVICES_PUB_PKG(-)');
5954: END IF;
5955:

Line 5997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5993: l_error_buffer VARCHAR2(200);
5994:
5995: BEGIN
5996:
5997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5998:
5999: IF (g_level_procedure >= g_current_runtime_level ) THEN
6000: FND_LOG.STRING(g_level_procedure,
6001: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID.BEGIN',

Line 6000: FND_LOG.STRING(g_level_procedure,

5996:
5997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5998:
5999: IF (g_level_procedure >= g_current_runtime_level ) THEN
6000: FND_LOG.STRING(g_level_procedure,
6001: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID.BEGIN',
6002: 'ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID(+)');
6003: END IF;
6004:

Line 6017: FND_LOG.STRING(g_level_unexpected,

6013: WHEN OTHERS THEN
6014:
6015: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6016: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6017: FND_LOG.STRING(g_level_unexpected,
6018: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID',
6019: 'Exception in ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID: '||l_error_buffer);
6020: END IF;
6021:

Line 6070: FND_LOG.STRING(g_level_procedure,

6066:
6067: END IF; -- l_ccid is null
6068:
6069: IF (g_level_procedure >= g_current_runtime_level ) THEN
6070: FND_LOG.STRING(g_level_procedure,
6071: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID.BEGIN',
6072: 'ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID(-)'||
6073: ' ccid = '||l_ccid);
6074: END IF;

Line 6083: FND_LOG.STRING(g_level_unexpected,

6079: WHEN OTHERS THEN
6080:
6081: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6082: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6083: FND_LOG.STRING(g_level_unexpected,
6084: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID',
6085: 'Exception in ZX_TRD_SERVICES_PUB_PKG.GET_RECOVERABLE_CCID: '||l_error_buffer);
6086: END IF;
6087: return(null);

Line 6175: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6171: l_rec_nrec_tax_Dist_id_tbl2 NUMERIC_TBL_TYPE;
6172:
6173: BEGIN
6174:
6175: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6176:
6177: IF (g_level_procedure >= g_current_runtime_level ) THEN
6178: FND_LOG.STRING(g_level_procedure,
6179: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists.BEGIN',

Line 6178: FND_LOG.STRING(g_level_procedure,

6174:
6175: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6176:
6177: IF (g_level_procedure >= g_current_runtime_level ) THEN
6178: FND_LOG.STRING(g_level_procedure,
6179: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists.BEGIN',
6180: 'ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists(+)');
6181: END IF;
6182:

Line 6333: FND_LOG.STRING(g_level_procedure,

6329: END IF;
6330:
6331:
6332: IF (g_level_procedure >= g_current_runtime_level ) THEN
6333: FND_LOG.STRING(g_level_procedure,
6334: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists.END',
6335: 'ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists(-)');
6336: END IF;
6337:

Line 6343: FND_LOG.STRING(g_level_unexpected,

6339: WHEN OTHERS THEN
6340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6341:
6342: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6343: FND_LOG.STRING(g_level_unexpected,
6344: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists',
6345: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6346: FND_LOG.STRING(g_level_unexpected,
6347: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists.END',

Line 6346: FND_LOG.STRING(g_level_unexpected,

6342: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6343: FND_LOG.STRING(g_level_unexpected,
6344: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists',
6345: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6346: FND_LOG.STRING(g_level_unexpected,
6347: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists.END',
6348: 'ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists(-)');
6349: END IF;
6350:

Line 6361: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6357: l_error_buffer VARCHAR2(200);
6358:
6359: BEGIN
6360:
6361: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6362:
6363: IF (g_level_procedure >= g_current_runtime_level ) THEN
6364: FND_LOG.STRING(g_level_procedure,
6365: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_posting_flag.BEGIN',

Line 6364: FND_LOG.STRING(g_level_procedure,

6360:
6361: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6362:
6363: IF (g_level_procedure >= g_current_runtime_level ) THEN
6364: FND_LOG.STRING(g_level_procedure,
6365: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_posting_flag.BEGIN',
6366: 'ZX_TRD_SERVICES_PUB_PKG.update_posting_flag(+)');
6367: END IF;
6368:

Line 6377: FND_LOG.STRING(g_level_procedure,

6373: SET posting_flag = 'A'
6374: WHERE rec_nrec_tax_dist_id = p_tax_dist_id_tbl(i);
6375:
6376: IF (g_level_procedure >= g_current_runtime_level ) THEN
6377: FND_LOG.STRING(g_level_procedure,
6378: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_posting_flag.END',
6379: 'ZX_TRD_SERVICES_PUB_PKG.update_posting_flag(-)');
6380: END IF;
6381:

Line 6388: FND_LOG.STRING(g_level_unexpected,

6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: l_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_SERVICES_PUB_PKG.update_posting_flag',
6390: l_error_buffer);
6391: FND_LOG.STRING(g_level_unexpected,
6392: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_posting_flag.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_SERVICES_PUB_PKG.update_posting_flag',
6390: l_error_buffer);
6391: FND_LOG.STRING(g_level_unexpected,
6392: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_posting_flag.END',
6393: 'ZX_TRD_SERVICES_PUB_PKG.ZX_TRD_SERVICES_PUB_PKG(-)');
6394: END IF;
6395:

Line 6504: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6500: l_jurisdiction_found BOOLEAN;
6501:
6502: BEGIN
6503:
6504: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6505:
6506: IF (g_level_procedure >= g_current_runtime_level ) THEN
6507:
6508: FND_LOG.STRING(g_level_procedure,

Line 6508: FND_LOG.STRING(g_level_procedure,

6504: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6505:
6506: IF (g_level_procedure >= g_current_runtime_level ) THEN
6507:
6508: FND_LOG.STRING(g_level_procedure,
6509: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
6510: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(+)');
6511:
6512: END IF;

Line 6523: FND_LOG.STRING(g_level_procedure,

6519: close is_jurisdiction_acc_appl;
6520:
6521: IF l_lines_count = 0 THEN
6522: IF (g_level_procedure >= g_current_runtime_level ) THEN
6523: FND_LOG.STRING(g_level_procedure,
6524: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
6525: 'This processing is done only for partner tax calculation, this is not partner processing');
6526: FND_LOG.STRING(g_level_procedure,
6527: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',

Line 6526: FND_LOG.STRING(g_level_procedure,

6522: IF (g_level_procedure >= g_current_runtime_level ) THEN
6523: FND_LOG.STRING(g_level_procedure,
6524: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
6525: 'This processing is done only for partner tax calculation, this is not partner processing');
6526: FND_LOG.STRING(g_level_procedure,
6527: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID.BEGIN',
6528: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(-)');
6529: END IF;
6530: RETURN;

Line 6571: FND_LOG.STRING(g_level_statement,

6567: init_mand_columns(l_event_class_rec,
6568: x_return_status);
6569: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6570: IF (g_level_statement >= g_current_runtime_level ) THEN
6571: FND_LOG.STRING(g_level_statement,
6572: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6573: 'After calling init_mand_columns, x_return_status = '|| x_return_status);
6574: FND_LOG.STRING(g_level_statement,
6575: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',

Line 6574: FND_LOG.STRING(g_level_statement,

6570: IF (g_level_statement >= g_current_runtime_level ) THEN
6571: FND_LOG.STRING(g_level_statement,
6572: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6573: 'After calling init_mand_columns, x_return_status = '|| x_return_status);
6574: FND_LOG.STRING(g_level_statement,
6575: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',
6576: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(-)');
6577: END IF;
6578: RETURN;

Line 6614: FND_LOG.STRING(g_level_statement,

6610: fetch line_acc_src_tax_rate_id into l_acc_src_tax_rate_id;
6611: close line_acc_src_tax_rate_id;
6612:
6613: IF (g_level_statement >= g_current_runtime_level ) THEN
6614: FND_LOG.STRING(g_level_statement,
6615: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6616: 'l_acc_src_tax_rate_id: ' || l_acc_src_tax_rate_id);
6617: END IF;
6618:

Line 6647: FND_LOG.STRING(g_level_statement,

6643:
6644: IF g_geography_use_info_tbl.EXISTS(l_tbl_index) AND
6645: g_geography_use_info_tbl(l_tbl_index).tax_id = l_tax_id THEN
6646: IF (g_level_statement >= g_current_runtime_level ) THEN
6647: FND_LOG.STRING(g_level_statement,
6648: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6649: 'Found Geography usage information in cache ');
6650: END IF;
6651: ELSE

Line 6673: FND_LOG.STRING(G_LEVEL_STATEMENT,

6669: END IF;
6670: EXCEPTION WHEN NO_DATA_FOUND THEN
6671: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6672: l_log_msg := 'hz_geography_type: Not Found for Tax';
6673: FND_LOG.STRING(G_LEVEL_STATEMENT,
6674: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6675: l_log_msg);
6676: END IF;
6677: END;

Line 6691: FND_LOG.STRING(G_LEVEL_STATEMENT,

6687: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6688: l_log_msg := 'hz_geography_type: out:' ||
6689: ', l_geography_type = ' || g_geography_use_info_tbl(l_tbl_index).geography_type ||
6690: ', l_geography_use = ' || g_geography_use_info_tbl(l_tbl_index).geography_use;
6691: FND_LOG.STRING(G_LEVEL_STATEMENT,
6692: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6693: l_log_msg);
6694: END IF;
6695: IF g_geography_use_info_tbl(l_tbl_index).geography_use = 'MASTER_REF' THEN

Line 6706: FND_LOG.STRING(g_level_statement,

6702: x_geography_name,
6703: x_return_status);
6704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6705: IF (g_level_statement >= g_current_runtime_level ) THEN
6706: FND_LOG.STRING(g_level_statement,
6707: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6708: 'Incorrect return_status after calling ' ||
6709: 'ZX_TCM_GEO_JUR_PKG.get_master_geography');
6710: FND_LOG.STRING(g_level_statement,

Line 6710: FND_LOG.STRING(g_level_statement,

6706: FND_LOG.STRING(g_level_statement,
6707: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6708: 'Incorrect return_status after calling ' ||
6709: 'ZX_TCM_GEO_JUR_PKG.get_master_geography');
6710: FND_LOG.STRING(g_level_statement,
6711: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6712: 'RETURN_STATUS = ' || x_return_status);
6713: FND_LOG.STRING(g_level_statement,
6714: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',

Line 6713: FND_LOG.STRING(g_level_statement,

6709: 'ZX_TCM_GEO_JUR_PKG.get_master_geography');
6710: FND_LOG.STRING(g_level_statement,
6711: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6712: 'RETURN_STATUS = ' || x_return_status);
6713: FND_LOG.STRING(g_level_statement,
6714: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',
6715: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(-)');
6716: END IF;
6717: RETURN;

Line 6754: FND_LOG.STRING(g_level_statement,

6750: -----l_geography_id(i),
6751: x_return_status);
6752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6753: IF (g_level_statement >= g_current_runtime_level ) THEN
6754: FND_LOG.STRING(g_level_statement,
6755: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6756: 'Incorrect return_status after calling ' ||
6757: 'ZX_TCM_GEO_JUR_PKG.get_zone');
6758: FND_LOG.STRING(g_level_statement,

Line 6758: FND_LOG.STRING(g_level_statement,

6754: FND_LOG.STRING(g_level_statement,
6755: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6756: 'Incorrect return_status after calling ' ||
6757: 'ZX_TCM_GEO_JUR_PKG.get_zone');
6758: FND_LOG.STRING(g_level_statement,
6759: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6760: 'RETURN_STATUS = ' || x_return_status);
6761: FND_LOG.STRING(g_level_statement,
6762: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',

Line 6761: FND_LOG.STRING(g_level_statement,

6757: 'ZX_TCM_GEO_JUR_PKG.get_zone');
6758: FND_LOG.STRING(g_level_statement,
6759: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6760: 'RETURN_STATUS = ' || x_return_status);
6761: FND_LOG.STRING(g_level_statement,
6762: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',
6763: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(-)');
6764: END IF;
6765: RETURN;

Line 6809: FND_LOG.STRING(g_level_procedure,

6805:
6806: --END IF; -- caching end
6807:
6808: IF (g_level_procedure >= g_current_runtime_level ) THEN
6809: FND_LOG.STRING(g_level_procedure,
6810: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',
6811: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(-)');
6812: END IF;
6813:

Line 6820: FND_LOG.STRING(g_level_unexpected,

6816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6817: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6818:
6819: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6820: FND_LOG.STRING(g_level_unexpected,
6821: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6822: l_error_buffer);
6823: FND_LOG.STRING(g_level_unexpected,
6824: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',

Line 6823: FND_LOG.STRING(g_level_unexpected,

6819: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6820: FND_LOG.STRING(g_level_unexpected,
6821: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6822: l_error_buffer);
6823: FND_LOG.STRING(g_level_unexpected,
6824: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',
6825: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(-)');
6826: END IF;
6827:

Line 6837: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6833:
6834: l_error_buffer VARCHAR2(200);
6835: BEGIN
6836:
6837: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6838: x_return_status := FND_API.G_RET_STS_SUCCESS;
6839:
6840: IF (g_level_procedure >= g_current_runtime_level ) THEN
6841: FND_LOG.STRING(g_level_procedure,

Line 6841: FND_LOG.STRING(g_level_procedure,

6837: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6838: x_return_status := FND_API.G_RET_STS_SUCCESS;
6839:
6840: IF (g_level_procedure >= g_current_runtime_level ) THEN
6841: FND_LOG.STRING(g_level_procedure,
6842: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS.BEGIN',
6843: 'ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS(+)');
6844: END IF;
6845:

Line 6872: FND_LOG.STRING(g_level_statement,

6868: p_event_class_rec => p_event_class_rec);
6869:
6870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6871: IF (g_level_statement >= g_current_runtime_level ) THEN
6872: FND_LOG.STRING(g_level_statement,
6873: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS',
6874: 'After calling calculate_tax, x_return_status = '|| x_return_status);
6875: FND_LOG.STRING(g_level_statement,
6876: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS.END',

Line 6875: FND_LOG.STRING(g_level_statement,

6871: IF (g_level_statement >= g_current_runtime_level ) THEN
6872: FND_LOG.STRING(g_level_statement,
6873: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS',
6874: 'After calling calculate_tax, x_return_status = '|| x_return_status);
6875: FND_LOG.STRING(g_level_statement,
6876: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS.END',
6877: 'ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS(-)');
6878: END IF;
6879: END IF;

Line 6885: FND_LOG.STRING(g_level_statement,

6881: ZX_VALID_INIT_PARAMS_PKG.import_document_with_tax(x_return_status => x_return_status,
6882: p_event_class_rec => p_event_class_rec);
6883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6884: IF (g_level_statement >= g_current_runtime_level ) THEN
6885: FND_LOG.STRING(g_level_statement,
6886: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS',
6887: 'After calling import_document_with_tax, x_return_status = '|| x_return_status);
6888: FND_LOG.STRING(g_level_statement,
6889: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS.END',

Line 6888: FND_LOG.STRING(g_level_statement,

6884: IF (g_level_statement >= g_current_runtime_level ) THEN
6885: FND_LOG.STRING(g_level_statement,
6886: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS',
6887: 'After calling import_document_with_tax, x_return_status = '|| x_return_status);
6888: FND_LOG.STRING(g_level_statement,
6889: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS.END',
6890: 'ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS(-)');
6891: END IF;
6892: END IF;

Line 6901: FND_LOG.STRING(g_level_unexpected,

6897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6898: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6899:
6900: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6901: FND_LOG.STRING(g_level_unexpected,
6902: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6903: l_error_buffer);
6904: FND_LOG.STRING(g_level_unexpected,
6905: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',

Line 6904: FND_LOG.STRING(g_level_unexpected,

6900: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6901: FND_LOG.STRING(g_level_unexpected,
6902: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6903: l_error_buffer);
6904: FND_LOG.STRING(g_level_unexpected,
6905: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID.END',
6906: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(-)');
6907: END IF;
6908: END init_mand_columns;