DBA Data[Home] [Help]

APPS.ZX_TDS_REVERSE_DOCUMENT_PKG dependencies on FND_LOG

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

8: l_number_value IN zx_lines.tax_line_id%TYPE,
9: x_return_status OUT NOCOPY VARCHAR2 ) RETURN NUMBER;
10:
11: g_current_runtime_level NUMBER;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:

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

9: x_return_status OUT NOCOPY VARCHAR2 ) RETURN NUMBER;
10:
11: g_current_runtime_level NUMBER;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:
17: /* ======================================================================*

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

10:
11: g_current_runtime_level NUMBER;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:
17: /* ======================================================================*
18: | PROCEDURE reverse_document |

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

11: g_current_runtime_level NUMBER;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:
17: /* ======================================================================*
18: | PROCEDURE reverse_document |
19: | This published service creates an exact mirror image of the tax lines |

Line 137: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

133: l_reversed_sum_tax_line_id_tb tax_line_id_tp;
134: l_reversing_sum_tax_line_id_tb tax_line_id_tp;
135:
136: BEGIN
137: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
138:
139: IF (g_level_procedure >= g_current_runtime_level ) THEN
140: FND_LOG.STRING(g_level_procedure,
141: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document.BEGIN',

Line 140: FND_LOG.STRING(g_level_procedure,

136: BEGIN
137: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
138:
139: IF (g_level_procedure >= g_current_runtime_level ) THEN
140: FND_LOG.STRING(g_level_procedure,
141: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document.BEGIN',
142: 'ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document(+)');
143: END IF;
144:

Line 1063: FND_LOG.STRING(g_level_procedure,

1059: FROM zx_lines zl
1060: WHERE tax_line_id = l_reversed_tax_line_id_tb(i);
1061:
1062: IF (g_level_procedure >= g_current_runtime_level ) THEN
1063: FND_LOG.STRING(g_level_procedure,
1064: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',
1065: 'RETURN_STATUS = ' || x_return_status);
1066: FND_LOG.STRING(g_level_procedure,
1067: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document.END',

Line 1066: FND_LOG.STRING(g_level_procedure,

1062: IF (g_level_procedure >= g_current_runtime_level ) THEN
1063: FND_LOG.STRING(g_level_procedure,
1064: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',
1065: 'RETURN_STATUS = ' || x_return_status);
1066: FND_LOG.STRING(g_level_procedure,
1067: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document.END',
1068: 'ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document(-)');
1069: END IF;
1070:

Line 1076: FND_LOG.STRING(g_level_unexpected,

1072: WHEN OTHERS THEN
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074:
1075: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1076: FND_LOG.STRING(g_level_unexpected,
1077: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',
1078: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1079: FND_LOG.STRING(g_level_unexpected,
1080: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',

Line 1079: FND_LOG.STRING(g_level_unexpected,

1075: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1076: FND_LOG.STRING(g_level_unexpected,
1077: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',
1078: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1079: FND_LOG.STRING(g_level_unexpected,
1080: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',
1081: 'reverse_document(-)');
1082: END IF;
1083:

Line 1102: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1098: l_return_index NUMBER;
1099:
1100: BEGIN
1101:
1102: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1103:
1104: IF (g_level_procedure >= g_current_runtime_level ) THEN
1105: FND_LOG.STRING(g_level_procedure,
1106: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index.BEGIN',

Line 1105: FND_LOG.STRING(g_level_procedure,

1101:
1102: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1103:
1104: IF (g_level_procedure >= g_current_runtime_level ) THEN
1105: FND_LOG.STRING(g_level_procedure,
1106: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index.BEGIN',
1107: 'ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index(+)');
1108: END IF;
1109:

Line 1122: FND_LOG.STRING(g_level_procedure,

1118: END IF;
1119: END LOOP;
1120:
1121: IF (g_level_procedure >= g_current_runtime_level ) THEN
1122: FND_LOG.STRING(g_level_procedure,
1123: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',
1124: 'RETURN_STATUS = ' || x_return_status);
1125: FND_LOG.STRING(g_level_procedure,
1126: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index.END',

Line 1125: FND_LOG.STRING(g_level_procedure,

1121: IF (g_level_procedure >= g_current_runtime_level ) THEN
1122: FND_LOG.STRING(g_level_procedure,
1123: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',
1124: 'RETURN_STATUS = ' || x_return_status);
1125: FND_LOG.STRING(g_level_procedure,
1126: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index.END',
1127: 'ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index(-)');
1128: END IF;
1129:

Line 1137: FND_LOG.STRING(g_level_unexpected,

1133: WHEN OTHERS THEN
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135:
1136: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1137: FND_LOG.STRING(g_level_unexpected,
1138: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',
1139: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1140: FND_LOG.STRING(g_level_unexpected,
1141: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',

Line 1140: FND_LOG.STRING(g_level_unexpected,

1136: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1137: FND_LOG.STRING(g_level_unexpected,
1138: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',
1139: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1140: FND_LOG.STRING(g_level_unexpected,
1141: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',
1142: 'get_tbl_index(-)');
1143: END IF;
1144: END get_tbl_index;