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

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

1: PACKAGE BODY ZX_ON_DEMAND_TRX_UPGRADE_PKG AS
2: /* $Header: zxmigtrxdemdpkgb.pls 120.48.12020000.2 2012/07/23 12:59:49 srajapar noship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8:
9: CONC_SUCCESS CONSTANT NUMBER := 0;

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

2: /* $Header: zxmigtrxdemdpkgb.pls 120.48.12020000.2 2012/07/23 12:59:49 srajapar noship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8:
9: CONC_SUCCESS CONSTANT NUMBER := 0;
10: CONC_WARNING CONSTANT NUMBER := 1;

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

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8:
9: CONC_SUCCESS CONSTANT NUMBER := 0;
10: CONC_WARNING CONSTANT NUMBER := 1;
11: CONC_FAIL CONSTANT NUMBER := 2;

Line 83: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

79: l_res BOOLEAN;
80: -- bug fix 5483850 end
81:
82: BEGIN
83: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
84:
85: --
86: -- Manager processing
87: --

Line 90: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR','ZX_TRX_UPDATE_MGR(+)');

86: -- Manager processing
87: --
88:
89: IF g_level_procedure >= g_current_runtime_level THEN
90: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR','ZX_TRX_UPDATE_MGR(+)');
91: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',' p_application_id: '||p_application_id);
92: END IF;
93:
94: X_retcode := CONC_SUCCESS;

Line 91: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',' p_application_id: '||p_application_id);

87: --
88:
89: IF g_level_procedure >= g_current_runtime_level THEN
90: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR','ZX_TRX_UPDATE_MGR(+)');
91: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',' p_application_id: '||p_application_id);
92: END IF;
93:
94: X_retcode := CONC_SUCCESS;
95:

Line 118: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR','ZX_TRX_UPDATE_MGR(-)');

114: X_ARGUMENT4=>p_application_id,
115: X_argument5=>l_update_name);
116:
117: IF g_level_statement >= g_current_runtime_level THEN
118: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR','ZX_TRX_UPDATE_MGR(-)');
119: END IF;
120: */
121:
122: -- rewrote the process to submit worker request for bug fix 5483850

Line 131: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',

127: FOR i in 1..X_Num_Workers
128: LOOP
129:
130: IF g_level_statement >= g_current_runtime_level THEN
131: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
132: 'Submitting concurrent request for worker '||i);
133: END IF;
134:
135: l_worker(i) := fnd_request.submit_request(

Line 149: FND_LOG.STRING(g_level_statement,

145: ARGUMENT5=>l_update_name );
146:
147: IF l_worker(i) = 0 THEN
148: IF g_level_statement >= g_current_runtime_level THEN
149: FND_LOG.STRING(g_level_statement,
150: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
151: 'Error submitting request #'||i);
152: FND_LOG.STRING(g_level_statement,
153: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',

Line 152: FND_LOG.STRING(g_level_statement,

148: IF g_level_statement >= g_current_runtime_level THEN
149: FND_LOG.STRING(g_level_statement,
150: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
151: 'Error submitting request #'||i);
152: FND_LOG.STRING(g_level_statement,
153: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
154: fnd_message.get);
155: END IF;
156: COMMIT;

Line 159: FND_LOG.STRING(g_level_statement,

155: END IF;
156: COMMIT;
157: ELSE
158: IF g_level_statement >= g_current_runtime_level THEN
159: FND_LOG.STRING(g_level_statement,
160: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
161: 'Submitted request #'||i);
162: FND_LOG.STRING(g_level_statement,
163: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',

Line 162: FND_LOG.STRING(g_level_statement,

158: IF g_level_statement >= g_current_runtime_level THEN
159: FND_LOG.STRING(g_level_statement,
160: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
161: 'Submitted request #'||i);
162: FND_LOG.STRING(g_level_statement,
163: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
164: 'Request ID: ' ||l_worker(i));
165: END IF;
166: COMMIT;

Line 178: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',

174: l_worker_not_complete := TRUE;
175: WHILE l_worker_not_complete LOOP
176: --dbms_lock.sleep(10);
177: IF g_level_statement >= g_current_runtime_level THEN
178: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
179: 'Inside Loop for checking the child request status');
180: END IF;
181:
182: l_worker_not_complete := FALSE;

Line 195: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',

191: l_dev_status,
192: l_message);
193:
194: IF g_level_statement >= g_current_runtime_level THEN
195: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
196: 'l_dev_phase: '||l_dev_phase);
197: END IF;
198:
199: IF l_dev_phase = 'COMPLETE' Then

Line 206: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',

202: l_worker_success := 'N';
203: END IF;
204: ELSE
205: IF g_level_statement >= g_current_runtime_level THEN
206: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
207: 'Loop once again');
208: END IF;
209: l_worker_not_complete := TRUE;
210: END IF;

Line 226: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR','ZX_TRX_UPDATE_MGR(-)');

222:
223: COMMIT;
224:
225: IF g_level_procedure >= g_current_runtime_level THEN
226: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR','ZX_TRX_UPDATE_MGR(-)');
227: END IF;
228: EXCEPTION
229: WHEN OTHERS THEN
230: X_retcode := CONC_FAIL;

Line 232: FND_LOG.STRING(g_level_unexpected,

228: EXCEPTION
229: WHEN OTHERS THEN
230: X_retcode := CONC_FAIL;
231: IF g_level_unexpected >= g_current_runtime_level THEN
232: FND_LOG.STRING(g_level_unexpected,
233: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_MGR',
234: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
235: END IF;
236: raise;

Line 275: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

271: l_temp BOOLEAN;
272:
273: BEGIN
274:
275: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
276:
277: --
278: -- get schema name of the table for ROWID range processing
279: --

Line 281: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','ZX_TRX_UPDATE_WKR(+)');

277: --
278: -- get schema name of the table for ROWID range processing
279: --
280: IF g_level_procedure >= g_current_runtime_level then
281: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','ZX_TRX_UPDATE_WKR(+)');
282: END IF;
283:
284: X_retcode := CONC_SUCCESS;
285:

Line 300: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' l_multi_org_flag is ' || l_multi_org_flag);

296: END IF;
297:
298:
299: IF g_level_statement >= g_current_runtime_level THEN
300: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' l_multi_org_flag is ' || l_multi_org_flag);
301: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' l_org_id is ' || l_org_id );
302:
303: END IF;
304:

Line 301: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' l_org_id is ' || l_org_id );

297:
298:
299: IF g_level_statement >= g_current_runtime_level THEN
300: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' l_multi_org_flag is ' || l_multi_org_flag);
301: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' l_org_id is ' || l_org_id );
302:
303: END IF;
304:
305: l_fnd_return := FND_INSTALLATION.GET(401,401, l_inv_flag, l_industry);

Line 331: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' X_Worker_Id is ' || X_Worker_Id);

327: END IF;
328:
329:
330: IF g_level_statement >= g_current_runtime_level then
331: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' X_Worker_Id is ' || X_Worker_Id);
332: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' X_Num_Workers is ' || X_Num_Workers );
333: END IF;
334:
335: BEGIN

Line 332: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' X_Num_Workers is ' || X_Num_Workers );

328:
329:
330: IF g_level_statement >= g_current_runtime_level then
331: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' X_Worker_Id is ' || X_Worker_Id);
332: FND_LOG.STRING(g_level_statement,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','Worker: '||X_Worker_Id||' X_Num_Workers is ' || X_Num_Workers );
333: END IF;
334:
335: BEGIN
336:

Line 432: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','ZX_TRX_UPDATE_WKR(-)');

428: raise;
429: END;
430:
431: IF g_level_procedure >= g_current_runtime_level then
432: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR','ZX_TRX_UPDATE_WKR(-)');
433: END IF;
434:
435: EXCEPTION
436: WHEN OTHERS THEN

Line 439: FND_LOG.STRING(g_level_unexpected,

435: EXCEPTION
436: WHEN OTHERS THEN
437: X_retcode := CONC_FAIL;
438: IF g_level_unexpected >= g_current_runtime_level THEN
439: FND_LOG.STRING(g_level_unexpected,
440: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_TRX_UPDATE_WKR',
441: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
442: END IF;
443: raise;

Line 470: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (+)' );

466: l_inv_installed := p_inv_installed;
467:
468:
469: IF g_level_procedure >= g_current_runtime_level then
470: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (+)' );
471: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
472: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_end_rowid is ' || p_end_rowid );
473: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_org_id is ' || p_org_id );
474: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_multi_org_flag is ' || p_multi_org_flag );

Line 471: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );

467:
468:
469: IF g_level_procedure >= g_current_runtime_level then
470: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (+)' );
471: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
472: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_end_rowid is ' || p_end_rowid );
473: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_org_id is ' || p_org_id );
474: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_multi_org_flag is ' || p_multi_org_flag );
475: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_inv_installed is ' || p_inv_installed );

Line 472: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_end_rowid is ' || p_end_rowid );

468:
469: IF g_level_procedure >= g_current_runtime_level then
470: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (+)' );
471: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
472: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_end_rowid is ' || p_end_rowid );
473: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_org_id is ' || p_org_id );
474: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_multi_org_flag is ' || p_multi_org_flag );
475: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_inv_installed is ' || p_inv_installed );
476: END IF;

Line 473: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_org_id is ' || p_org_id );

469: IF g_level_procedure >= g_current_runtime_level then
470: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (+)' );
471: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
472: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_end_rowid is ' || p_end_rowid );
473: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_org_id is ' || p_org_id );
474: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_multi_org_flag is ' || p_multi_org_flag );
475: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_inv_installed is ' || p_inv_installed );
476: END IF;
477:

Line 474: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_multi_org_flag is ' || p_multi_org_flag );

470: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (+)' );
471: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
472: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_end_rowid is ' || p_end_rowid );
473: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_org_id is ' || p_org_id );
474: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_multi_org_flag is ' || p_multi_org_flag );
475: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_inv_installed is ' || p_inv_installed );
476: END IF;
477:
478: x_retcode := CONC_SUCCESS;

Line 475: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_inv_installed is ' || p_inv_installed );

471: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
472: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_end_rowid is ' || p_end_rowid );
473: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_org_id is ' || p_org_id );
474: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_multi_org_flag is ' || p_multi_org_flag );
475: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' p_inv_installed is ' || p_inv_installed );
476: END IF;
477:
478: x_retcode := CONC_SUCCESS;
479:

Line 2259: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );

2255:
2256: x_rows_processed := SQL%ROWCOUNT;
2257:
2258: IF g_level_procedure >= g_current_runtime_level THEN
2259: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );
2260: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (-)' );
2261: END IF;
2262:
2263: EXCEPTION

Line 2260: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (-)' );

2256: x_rows_processed := SQL%ROWCOUNT;
2257:
2258: IF g_level_procedure >= g_current_runtime_level THEN
2259: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );
2260: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG','Worker: '||p_worker_id||' zx_ar_trx_mig (-)' );
2261: END IF;
2262:
2263: EXCEPTION
2264: WHEN OTHERS THEN

Line 2267: FND_LOG.STRING(g_level_unexpected,

2263: EXCEPTION
2264: WHEN OTHERS THEN
2265: X_retcode := CONC_FAIL;
2266: IF g_level_unexpected >= g_current_runtime_level THEN
2267: FND_LOG.STRING(g_level_unexpected,
2268: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AR_TRX_MIG',
2269: 'Worker: '||p_worker_id||'Raised exceptions: '||
2270: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
2271: END IF;

Line 2295: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (+)' );

2291: l_org_id := p_org_id;
2292:
2293:
2294: IF g_level_procedure >= g_current_runtime_level THEN
2295: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (+)' );
2296: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
2297: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
2298: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
2299: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );

Line 2296: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );

2292:
2293:
2294: IF g_level_procedure >= g_current_runtime_level THEN
2295: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (+)' );
2296: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
2297: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
2298: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
2299: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
2300: END IF;

Line 2297: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );

2293:
2294: IF g_level_procedure >= g_current_runtime_level THEN
2295: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (+)' );
2296: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
2297: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
2298: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
2299: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
2300: END IF;
2301:

Line 2298: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );

2294: IF g_level_procedure >= g_current_runtime_level THEN
2295: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (+)' );
2296: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
2297: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
2298: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
2299: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
2300: END IF;
2301:
2302: x_retcode := CONC_SUCCESS;

Line 2299: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );

2295: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (+)' );
2296: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' p_start_rowid is ' || p_start_rowid );
2297: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
2298: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
2299: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
2300: END IF;
2301:
2302: x_retcode := CONC_SUCCESS;
2303:

Line 3956: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );

3952:
3953: x_rows_processed := SQL%ROWCOUNT;
3954:
3955: IF g_level_procedure >= g_current_runtime_level THEN
3956: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );
3957: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (-)' );
3958: END IF;
3959:
3960: EXCEPTION

Line 3957: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (-)' );

3953: x_rows_processed := SQL%ROWCOUNT;
3954:
3955: IF g_level_procedure >= g_current_runtime_level THEN
3956: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );
3957: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG','Worker: '||p_worker_id||' zx_ap_trx_mig (-)' );
3958: END IF;
3959:
3960: EXCEPTION
3961: WHEN OTHERS THEN

Line 3964: FND_LOG.STRING(g_level_unexpected,

3960: EXCEPTION
3961: WHEN OTHERS THEN
3962: X_retcode := CONC_FAIL;
3963: IF g_level_unexpected >= g_current_runtime_level THEN
3964: FND_LOG.STRING(g_level_unexpected,
3965: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_AP_TRX_MIG',
3966: 'Worker: '||p_worker_id||'Raised exceptions: '||
3967: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
3968: END IF;

Line 3992: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (+)' );

3988: l_org_id := p_org_id;
3989:
3990:
3991: IF g_level_procedure >= g_current_runtime_level THEN
3992: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (+)' );
3993: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_start_rowid is ' || p_start_rowid );
3994: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
3995: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
3996: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );

Line 3993: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_start_rowid is ' || p_start_rowid );

3989:
3990:
3991: IF g_level_procedure >= g_current_runtime_level THEN
3992: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (+)' );
3993: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_start_rowid is ' || p_start_rowid );
3994: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
3995: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
3996: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
3997: END IF;

Line 3994: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );

3990:
3991: IF g_level_procedure >= g_current_runtime_level THEN
3992: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (+)' );
3993: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_start_rowid is ' || p_start_rowid );
3994: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
3995: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
3996: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
3997: END IF;
3998:

Line 3995: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );

3991: IF g_level_procedure >= g_current_runtime_level THEN
3992: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (+)' );
3993: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_start_rowid is ' || p_start_rowid );
3994: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
3995: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
3996: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
3997: END IF;
3998:
3999: x_retcode := CONC_SUCCESS;

Line 3996: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );

3992: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (+)' );
3993: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_start_rowid is ' || p_start_rowid );
3994: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_end_rowid is ' || p_end_rowid );
3995: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_org_id is ' || p_org_id );
3996: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||'p_multi_org_flag is ' || p_multi_org_flag );
3997: END IF;
3998:
3999: x_retcode := CONC_SUCCESS;
4000:

Line 6328: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );

6324:
6325: x_rows_processed := SQL%ROWCOUNT;
6326:
6327: IF g_level_procedure >= g_current_runtime_level THEN
6328: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );
6329: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (-)' );
6330: END IF;
6331:
6332: EXCEPTION

Line 6329: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (-)' );

6325: x_rows_processed := SQL%ROWCOUNT;
6326:
6327: IF g_level_procedure >= g_current_runtime_level THEN
6328: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' x_rows_processed is ' || x_rows_processed );
6329: FND_LOG.STRING(g_level_procedure,'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG','Worker: '||p_worker_id||' zx_po_trx_mig (-)' );
6330: END IF;
6331:
6332: EXCEPTION
6333: WHEN OTHERS THEN

Line 6336: FND_LOG.STRING(g_level_unexpected,

6332: EXCEPTION
6333: WHEN OTHERS THEN
6334: X_retcode := CONC_FAIL;
6335: IF g_level_unexpected >= g_current_runtime_level THEN
6336: FND_LOG.STRING(g_level_unexpected,
6337: 'ZX_ON_DEMAND_TRX_UPGRADE_PKG.ZX_PO_TRX_MIG',
6338: 'Worker: '||p_worker_id||'Raised exceptions: '||
6339: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
6340: END IF;