DBA Data[Home] [Help]

APPS.ZX_TDS_REVERSE_DOCUMENT_PKG dependencies on ZX_TDS_REVERSE_DOCUMENT_PKG

Line 1: PACKAGE BODY ZX_TDS_REVERSE_DOCUMENT_PKG AS

1: PACKAGE BODY ZX_TDS_REVERSE_DOCUMENT_PKG AS
2: /* $Header: zxdirevdocmtpkgb.pls 120.27.12010000.2 2008/11/18 05:59:25 srajapar ship $ */
3:
4: TYPE tax_line_id_tp IS TABLE OF zx_lines.tax_line_id%TYPE INDEX BY BINARY_INTEGER;
5:

Line 141: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document.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:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 142: 'ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document(+)');

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:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:

Line 1064: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',

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',
1068: 'ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document(-)');

Line 1067: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document.END',

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:
1071: EXCEPTION

Line 1068: 'ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document(-)');

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:
1071: EXCEPTION
1072: WHEN OTHERS THEN

Line 1077: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',

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',
1081: 'reverse_document(-)');

Line 1080: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.reverse_document',

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:
1084: END reverse_document;

Line 1106: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index.BEGIN',

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:
1110: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1107: 'ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index(+)');

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:
1110: x_return_status := FND_API.G_RET_STS_SUCCESS;
1111:

Line 1123: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',

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',
1127: 'ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index(-)');

Line 1126: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index.END',

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:
1130: RETURN l_return_index;

Line 1127: 'ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index(-)');

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:
1130: RETURN l_return_index;
1131:

Line 1138: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',

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',
1142: 'get_tbl_index(-)');

Line 1141: 'ZX.PLSQL.ZX_TDS_REVERSE_DOCUMENT_PKG.get_tbl_index',

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;
1145:

Line 1146: END ZX_TDS_REVERSE_DOCUMENT_PKG;

1142: 'get_tbl_index(-)');
1143: END IF;
1144: END get_tbl_index;
1145:
1146: END ZX_TDS_REVERSE_DOCUMENT_PKG;
1147: