40:
41: --=============================================================================
42: -- *********** Local Trace Routine **********
43: --=============================================================================
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
41: --=============================================================================
42: -- *********** Local Trace Routine **********
43: --=============================================================================
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
42: -- *********** Local Trace Routine **********
43: --=============================================================================
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
43: --=============================================================================
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
51: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
51: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
52: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'fun.plsql.fun_xla_tab_pkg';
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
51: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
52: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'fun.plsql.fun_xla_tab_pkg';
53:
61: )
62: IS
63: BEGIN
64: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
65: fnd_log.message(p_level, p_module);
66: ELSIF p_level >= g_log_level THEN
67: fnd_log.string(p_level, p_module, p_msg);
68: END IF;
69:
63: BEGIN
64: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
65: fnd_log.message(p_level, p_module);
66: ELSIF p_level >= g_log_level THEN
67: fnd_log.string(p_level, p_module, p_msg);
68: END IF;
69:
70: EXCEPTION
71: WHEN app_exceptions.application_exception THEN
142:
143: --Initialize the global message table
144: FND_MSG_PUB.Initialize;
145:
146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Calling xla_tab_pub_pkg.run with following parameters');
148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
143: --Initialize the global message table
144: FND_MSG_PUB.Initialize;
145:
146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Calling xla_tab_pub_pkg.run with following parameters');
148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);
144: FND_MSG_PUB.Initialize;
145:
146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Calling xla_tab_pub_pkg.run with following parameters');
148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_transaction_coa_id = ' || p_transaction_coa_id);
145:
146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Calling xla_tab_pub_pkg.run with following parameters');
148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_transaction_coa_id = ' || p_transaction_coa_id);
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_mode = ' || p_mode);
146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Calling xla_tab_pub_pkg.run with following parameters');
148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_transaction_coa_id = ' || p_transaction_coa_id);
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_mode = ' || p_mode);
154: END IF;
147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Calling xla_tab_pub_pkg.run with following parameters');
148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_transaction_coa_id = ' || p_transaction_coa_id);
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_mode = ' || p_mode);
154: END IF;
155:
148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_transaction_coa_id = ' || p_transaction_coa_id);
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_mode = ' || p_mode);
154: END IF;
155:
156: xla_tab_pub_pkg.run
149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_type_code = ' || p_account_definition_type_code);
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_transaction_coa_id = ' || p_transaction_coa_id);
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_mode = ' || p_mode);
154: END IF;
155:
156: xla_tab_pub_pkg.run
157: (
165: ,x_msg_count => l_msg_count
166: ,x_msg_data => l_msg_data
167: );
168:
169: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg returns status ' || l_return_status );
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_count = ' || l_msg_count );
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_data = ' || l_msg_data );
173: END IF;
166: ,x_msg_data => l_msg_data
167: );
168:
169: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg returns status ' || l_return_status );
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_count = ' || l_msg_count );
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_data = ' || l_msg_data );
173: END IF;
174:
167: );
168:
169: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg returns status ' || l_return_status );
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_count = ' || l_msg_count );
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_data = ' || l_msg_data );
173: END IF;
174:
175: IF l_return_status <> C_RET_STS_SUCCESS
168:
169: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg returns status ' || l_return_status );
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_count = ' || l_msg_count );
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg l_msg_data = ' || l_msg_data );
173: END IF;
174:
175: IF l_return_status <> C_RET_STS_SUCCESS
176: THEN
176: THEN
177: --Push the error message again so that it does not get lost
178: IF l_msg_data IS NOT NULL
179: THEN
180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'If return status is not success and l_msg_data is not null');
182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'initialize fnd_msg_pub and add message data in to fnd_msg_pub');
183: END IF;
184:
177: --Push the error message again so that it does not get lost
178: IF l_msg_data IS NOT NULL
179: THEN
180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'If return status is not success and l_msg_data is not null');
182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'initialize fnd_msg_pub and add message data in to fnd_msg_pub');
183: END IF;
184:
185: fnd_msg_pub.initialize;
178: IF l_msg_data IS NOT NULL
179: THEN
180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'If return status is not success and l_msg_data is not null');
182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'initialize fnd_msg_pub and add message data in to fnd_msg_pub');
183: END IF;
184:
185: fnd_msg_pub.initialize;
186:
191:
192: --Add it to the message table
193: fnd_msg_pub.add;
194:
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'set l_msg_count and l_msd_data to NULL');
197: END IF;
198: --Reset single message variables
199: l_msg_count := NULL;
192: --Add it to the message table
193: fnd_msg_pub.add;
194:
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'set l_msg_count and l_msd_data to NULL');
197: END IF;
198: --Reset single message variables
199: l_msg_count := NULL;
200: l_msg_data := NULL;
198: --Reset single message variables
199: l_msg_count := NULL;
200: l_msg_data := NULL;
201: END IF;
202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Raise fatal exception');
204: END IF;
205:
206: RAISE le_fatal_error;
199: l_msg_count := NULL;
200: l_msg_data := NULL;
201: END IF;
202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Raise fatal exception');
204: END IF;
205:
206: RAISE le_fatal_error;
207: END IF;
205:
206: RAISE le_fatal_error;
207: END IF;
208:
209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_SUCCESS);
206: RAISE le_fatal_error;
207: END IF;
208:
209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_SUCCESS);
214: END IF;
207: END IF;
208:
209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_SUCCESS);
214: END IF;
215:
208:
209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_SUCCESS);
214: END IF;
215:
216: --Assign out parameters
209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_SUCCESS);
214: END IF;
215:
216: --Assign out parameters
217: x_msg_count := NVL(l_msg_count, 0);
227:
228: EXCEPTION
229: WHEN le_fatal_error THEN
230:
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Fatal Exception remove all element from PLSQL table');
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
234: END IF;
235: --Remove all the elements from the PLSQL table
228: EXCEPTION
229: WHEN le_fatal_error THEN
230:
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Fatal Exception remove all element from PLSQL table');
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
234: END IF;
235: --Remove all the elements from the PLSQL table
236: reset_online_interface;
229: WHEN le_fatal_error THEN
230:
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Fatal Exception remove all element from PLSQL table');
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
234: END IF;
235: --Remove all the elements from the PLSQL table
236: reset_online_interface;
237: --If there is a no token message to log
271: );
272: --Assign out parameters
273: x_msg_count := l_msg_count;
274: x_msg_data := l_msg_data;
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
279: END IF;
272: --Assign out parameters
273: x_msg_count := l_msg_count;
274: x_msg_data := l_msg_data;
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
279: END IF;
280:
273: x_msg_count := l_msg_count;
274: x_msg_data := l_msg_data;
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
279: END IF;
280:
281: IF l_return_status IS NOT NULL
274: x_msg_data := l_msg_data;
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
279: END IF;
280:
281: IF l_return_status IS NOT NULL
282: THEN
279: END IF;
280:
281: IF l_return_status IS NOT NULL
282: THEN
283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || l_return_status);
285: END IF;
286: x_return_status := l_return_status;
287: ELSE
280:
281: IF l_return_status IS NOT NULL
282: THEN
283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || l_return_status);
285: END IF;
286: x_return_status := l_return_status;
287: ELSE
288: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || l_return_status);
285: END IF;
286: x_return_status := l_return_status;
287: ELSE
288: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);
290: END IF;
291: x_return_status := C_RET_STS_UNEXP_ERROR;
292: END IF;
285: END IF;
286: x_return_status := l_return_status;
287: ELSE
288: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);
290: END IF;
291: x_return_status := C_RET_STS_UNEXP_ERROR;
292: END IF;
293: WHEN OTHERS THEN
290: END IF;
291: x_return_status := C_RET_STS_UNEXP_ERROR;
292: END IF;
293: WHEN OTHERS THEN
294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Other Exception remove all element from PLSQL table');
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
297: END IF;
298: --Remove all the elements from the PLSQL table
291: x_return_status := C_RET_STS_UNEXP_ERROR;
292: END IF;
293: WHEN OTHERS THEN
294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Other Exception remove all element from PLSQL table');
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
297: END IF;
298: --Remove all the elements from the PLSQL table
299: reset_online_interface;
292: END IF;
293: WHEN OTHERS THEN
294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Other Exception remove all element from PLSQL table');
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
297: END IF;
298: --Remove all the elements from the PLSQL table
299: reset_online_interface;
300: --Add the standard unexpected error message
313: (
314: encoded_message => l_msg_data
315: );
316:
317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);
314: encoded_message => l_msg_data
315: );
316:
317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);
322: END IF;
315: );
316:
317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);
322: END IF;
323:
316:
317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);
322: END IF;
323:
324: --Assign out parameters
317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');
319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);
320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);
322: END IF;
323:
324: --Assign out parameters
325: x_msg_count := l_msg_count;
1125:
1126:
1127: --Trace initialization
1128: BEGIN
1129: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1130: g_log_enabled := fnd_log.test
1131: (log_level => g_log_level
1132: ,module => C_DEFAULT_MODULE);
1133:
1126:
1127: --Trace initialization
1128: BEGIN
1129: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1130: g_log_enabled := fnd_log.test
1131: (log_level => g_log_level
1132: ,module => C_DEFAULT_MODULE);
1133:
1134: IF NOT g_log_enabled THEN