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.FUN_XLA_TAB_PKG dependencies on FUN_XLA_TAB_PKG

Line 1: PACKAGE BODY FUN_XLA_TAB_PKG AS

1: PACKAGE BODY FUN_XLA_TAB_PKG AS
2: /* $Header: funxlatabb.pls 120.1.12010000.2 2008/08/22 09:04:46 makansal ship $ */
3: /*======================================================================+
4: | Copyright (c) 2004 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | FUN_XLA_TAB_PKG |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | FUN_XLA_TAB_PKG |
10: | |
11: | DESCRIPTION |
12: | |
13: | Transaction Account Builder API. |

Line 38: C_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'FUN_XLA_TAB_PKG';

34: --Private exceptions
35: le_fatal_error EXCEPTION;
36: --Private constants
37: C_API_VERSION CONSTANT NUMBER(1) := 1;
38: C_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'FUN_XLA_TAB_PKG';
39:
40:
41: --=============================================================================
42: -- *********** Local Trace Routine **********

Line 52: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'fun.plsql.fun_xla_tab_pkg';

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:
54: g_log_level NUMBER;
55: g_log_enabled BOOLEAN;
56:

Line 76: ,'fun_xla_tab_pkg.trace');

72: RAISE;
73: WHEN OTHERS THEN
74: fnd_message.set_name('XLA', 'XLA_TAB_UNHANDLED_EXCEPTION');
75: fnd_message.set_token( 'PROCEDURE'
76: ,'fun_xla_tab_pkg.trace');
77: RAISE;
78: END trace;
79:
80: --Private procedure

Line 147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Calling xla_tab_pub_pkg.run with following parameters');

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);

Line 148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_api_version = ' || p_api_version);

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);

Line 149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_application_id = ' || 435);

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);

Line 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);

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;

Line 151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_account_definition_code = ' || p_account_definition_code);

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:

Line 152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_transaction_coa_id = ' || p_transaction_coa_id);

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

Line 153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run','p_mode = ' || p_mode);

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: (

Line 170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'xla_tab_pub_pkg returns status ' || l_return_status );

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:

Line 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 );

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

Line 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 );

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

Line 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');

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;

Line 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');

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:

Line 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');

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;

Line 203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Raise fatal exception');

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;

Line 210: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');

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;

Line 211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);

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:

Line 212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);

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

Line 213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_SUCCESS);

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);

Line 232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Fatal Exception remove all element from 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;

Line 233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');

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

Line 256: ,'fun_xla_tab_pkg.run');

252: application => 'XLA'
253: ,name => 'XLA_TAB_RUN_FAILED'
254: );
255: fnd_message.set_token( 'FUNCTION_NAME'
256: ,'fun_xla_tab_pkg.run');
257:
258: --Add it to the message table
259: fnd_msg_pub.add;
260:

Line 276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');

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:

Line 277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);

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

Line 278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);

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

Line 284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || l_return_status);

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

Line 289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);

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

Line 295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Other Exception remove all element from 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;

Line 296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');

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

Line 318: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'Assign out parameters');

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;

Line 319: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_count = ' || l_msg_count);

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:

Line 320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x_msg_data = ' || l_msg_data);

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

Line 321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'x-return_status = ' || C_RET_STS_UNEXP_ERROR);

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;

Line 1139: END FUN_XLA_TAB_PKG;

1135: g_log_level := C_LEVEL_LOG_DISABLED;
1136: END IF;
1137:
1138:
1139: END FUN_XLA_TAB_PKG;