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.WIP_MTLTEMPPROC_PRIV dependencies on FND_API

Line 48: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

44: l_params(4).paramValue := p_destroyQtyTrees;
45: wip_logger.entryPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
46: p_params => l_params,
47: x_returnStatus => x_returnStatus);
48: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
49: raise fnd_api.g_exc_unexpected_error;
50: end if;
51: end if;
52: x_returnStatus := fnd_api.g_ret_sts_success;

Line 49: raise fnd_api.g_exc_unexpected_error;

45: wip_logger.entryPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
46: p_params => l_params,
47: x_returnStatus => x_returnStatus);
48: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
49: raise fnd_api.g_exc_unexpected_error;
50: end if;
51: end if;
52: x_returnStatus := fnd_api.g_ret_sts_success;
53:

Line 52: x_returnStatus := fnd_api.g_ret_sts_success;

48: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
49: raise fnd_api.g_exc_unexpected_error;
50: end if;
51: end if;
52: x_returnStatus := fnd_api.g_ret_sts_success;
53:
54: if(fnd_api.to_boolean(p_initMsgList)) then
55: fnd_msg_pub.initialize;
56: end if;

Line 54: if(fnd_api.to_boolean(p_initMsgList)) then

50: end if;
51: end if;
52: x_returnStatus := fnd_api.g_ret_sts_success;
53:
54: if(fnd_api.to_boolean(p_initMsgList)) then
55: fnd_msg_pub.initialize;
56: end if;
57:
58: l_retCode := inv_lpn_trx_pub.process_lpn_trx(p_trx_hdr_id => p_txnHdrID,

Line 74: p_delete_stack => fnd_api.g_false);

70: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
71: fnd_message.set_token('MESSAGE', l_errMsg);
72: fnd_msg_pub.add;
73: wip_utilities.get_message_stack(p_msg => x_errorMsg,
74: p_delete_stack => fnd_api.g_false);
75: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
76: else
77: wip_utilities.get_message_stack(p_msg => x_errorMsg,
78: p_delete_stack => fnd_api.g_false);

Line 75: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

71: fnd_message.set_token('MESSAGE', l_errMsg);
72: fnd_msg_pub.add;
73: wip_utilities.get_message_stack(p_msg => x_errorMsg,
74: p_delete_stack => fnd_api.g_false);
75: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
76: else
77: wip_utilities.get_message_stack(p_msg => x_errorMsg,
78: p_delete_stack => fnd_api.g_false);
79: end if;

Line 78: p_delete_stack => fnd_api.g_false);

74: p_delete_stack => fnd_api.g_false);
75: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
76: else
77: wip_utilities.get_message_stack(p_msg => x_errorMsg,
78: p_delete_stack => fnd_api.g_false);
79: end if;
80:
81:
82: -------------------------------------------------------------

Line 85: if(fnd_api.to_boolean(nvl(p_destroyQtyTrees, fnd_api.g_false))) then

81:
82: -------------------------------------------------------------
83: --Cleanup Processing
84: -------------------------------------------------------------
85: if(fnd_api.to_boolean(nvl(p_destroyQtyTrees, fnd_api.g_false))) then
86: inv_quantity_tree_pub.clear_quantity_cache;
87: end if;
88:
89: if (l_logLevel <= wip_constants.trace_logging) then

Line 94: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

90: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
91: p_procReturnStatus => x_returnStatus,
92: p_msg => 'success',
93: x_returnStatus => l_retStatus);
94: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
95: wip_logger.cleanup(l_retStatus);
96: end if;
97: end if;
98: exception

Line 99: when fnd_api.g_exc_unexpected_error then

95: wip_logger.cleanup(l_retStatus);
96: end if;
97: end if;
98: exception
99: when fnd_api.g_exc_unexpected_error then
100: rollback to wiptmpvb0;
101: wip_utilities.get_message_stack(p_msg => x_errorMsg,
102: p_delete_stack => fnd_api.g_false,
103: p_separator => ' ');

Line 102: p_delete_stack => fnd_api.g_false,

98: exception
99: when fnd_api.g_exc_unexpected_error then
100: rollback to wiptmpvb0;
101: wip_utilities.get_message_stack(p_msg => x_errorMsg,
102: p_delete_stack => fnd_api.g_false,
103: p_separator => ' ');
104: if (l_logLevel <= wip_constants.trace_logging) then
105: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
106: p_procReturnStatus => x_returnStatus,

Line 109: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

105: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
106: p_procReturnStatus => x_returnStatus,
107: p_msg => 'unhandled exception: ' || SQLERRM,
108: x_returnStatus => l_retStatus);
109: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
110: wip_logger.cleanup(l_retStatus);
111: end if;
112: end if;
113: when others then

Line 115: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

111: end if;
112: end if;
113: when others then
114: rollback to wiptmpvb0;
115: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlTempProc_priv',
117: p_procedure_name => 'processTemp',
118: p_error_text => SQLERRM);
119: wip_utilities.get_message_stack(p_msg => x_errorMsg,

Line 120: p_delete_stack => fnd_api.g_false,

116: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlTempProc_priv',
117: p_procedure_name => 'processTemp',
118: p_error_text => SQLERRM);
119: wip_utilities.get_message_stack(p_msg => x_errorMsg,
120: p_delete_stack => fnd_api.g_false,
121: p_separator => ' ');
122: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');
123: l_errCode := fnd_message.get;
124:

Line 142: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
139: p_procReturnStatus => x_returnStatus,
140: p_msg => 'unhandled exception: ' || SQLERRM,
141: x_returnStatus => l_retStatus);
142: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
143: wip_logger.cleanup(l_retStatus);
144: end if;
145: end if;
146: end processTemp;

Line 187: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

183: l_params(2).paramValue := p_processLpn;
184: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
185: p_params => l_params,
186: x_returnStatus => x_returnStatus);
187: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
188: raise fnd_api.g_exc_unexpected_error;
189: end if;
190: end if;
191:

Line 188: raise fnd_api.g_exc_unexpected_error;

184: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
185: p_params => l_params,
186: x_returnStatus => x_returnStatus);
187: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
188: raise fnd_api.g_exc_unexpected_error;
189: end if;
190: end if;
191:
192: x_returnStatus := fnd_api.g_ret_sts_success;

Line 192: x_returnStatus := fnd_api.g_ret_sts_success;

188: raise fnd_api.g_exc_unexpected_error;
189: end if;
190: end if;
191:
192: x_returnStatus := fnd_api.g_ret_sts_success;
193:
194: select transaction_action_id,
195: transaction_header_id, /*Added for bug 6417742(FP of 6342851)*/
196: transaction_type_id, /*Added for bug 6417742(FP of 6342851)*/

Line 233: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

229: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
230: p_procReturnStatus => x_returnStatus,
231: p_msg => 'success: phantom record deleted without any action',
232: x_returnStatus => l_retStatus);
233: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
234: wip_logger.cleanup(l_retStatus);
235: end if;
236: end if;
237: return;

Line 267: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

263: if(l_wipEntityType <> wip_constants.flow) then
264: if(l_logLevel <= wip_constants.full_logging) then
265: wip_logger.log('calling component processor', l_retStatus);
266: end if;
267: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
268: p_endDebug => fnd_api.g_false,
269: p_txnTmpID => p_txnTmpID,
270: x_returnStatus => x_returnStatus);
271: end if;

Line 268: p_endDebug => fnd_api.g_false,

264: if(l_logLevel <= wip_constants.full_logging) then
265: wip_logger.log('calling component processor', l_retStatus);
266: end if;
267: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
268: p_endDebug => fnd_api.g_false,
269: p_txnTmpID => p_txnTmpID,
270: x_returnStatus => x_returnStatus);
271: end if;
272:

Line 275: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then

271: end if;
272:
273: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
274: --no action is necessary for lpn completions
275: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
276: if(l_wipEntityType = wip_constants.flow) then
277: if(l_logLevel <= wip_constants.full_logging) then
278: wip_logger.log('calling flow/wol processor', l_retStatus);
279: end if;

Line 280: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

276: if(l_wipEntityType = wip_constants.flow) then
277: if(l_logLevel <= wip_constants.full_logging) then
278: wip_logger.log('calling flow/wol processor', l_retStatus);
279: end if;
280: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
281: p_txnTempID => p_txnTmpID,
282: x_returnStatus => x_returnStatus);
283: else --non flow completion
284: if(l_logLevel <= wip_constants.full_logging) then

Line 288: p_initMsgList => fnd_api.g_false,

284: if(l_logLevel <= wip_constants.full_logging) then
285: wip_logger.log('calling cpl processor', l_retStatus);
286: end if;
287: wip_cplProc_priv.processTemp(p_txnTmpID => p_txnTmpID,
288: p_initMsgList => fnd_api.g_false,
289: p_endDebug => fnd_api.g_false,
290: x_returnStatus => x_returnStatus);
291: end if;
292: end if;

Line 289: p_endDebug => fnd_api.g_false,

285: wip_logger.log('calling cpl processor', l_retStatus);
286: end if;
287: wip_cplProc_priv.processTemp(p_txnTmpID => p_txnTmpID,
288: p_initMsgList => fnd_api.g_false,
289: p_endDebug => fnd_api.g_false,
290: x_returnStatus => x_returnStatus);
291: end if;
292: end if;
293: elsif(l_txnActionID = wip_constants.scrassy_action) then

Line 305: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

301: elsif (l_wipEntityType = wip_constants.flow) then
302: if(l_logLevel <= wip_constants.full_logging) then
303: wip_logger.log('calling flow/wol processor', l_retStatus);
304: end if;
305: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
306: p_txnTempID => p_txnTmpID,
307: x_returnStatus => x_returnStatus);
308: end if;
309: end if;

Line 311: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

307: x_returnStatus => x_returnStatus);
308: end if;
309: end if;
310:
311: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
312: raise fnd_api.g_exc_unexpected_error;
313: end if;
314:
315: if(l_logLevel <= wip_constants.trace_logging) then

Line 312: raise fnd_api.g_exc_unexpected_error;

308: end if;
309: end if;
310:
311: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
312: raise fnd_api.g_exc_unexpected_error;
313: end if;
314:
315: if(l_logLevel <= wip_constants.trace_logging) then
316: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 320: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

316: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
317: p_procReturnStatus => x_returnStatus,
318: p_msg => 'success',
319: x_returnStatus => l_retStatus);
320: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
321: wip_logger.cleanup(l_retStatus);
322: end if;
323: end if;
324:

Line 337: if(returnStatus <> fnd_api.g_ret_sts_success) then

333: p_label_status => labelStatus,
334: p_business_flow_code => 33); -- discrete business flow code
335:
336: -- do not error out if label printing, only put warning message in log
337: if(returnStatus <> fnd_api.g_ret_sts_success) then
338: WIP_UTILITIES.get_message_stack(p_msg => l_msg_stack);
339: if (l_logLevel <= wip_constants.full_logging) then
340: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
341: 'The following error has occurred during ' ||

Line 357: when fnd_api.g_exc_unexpected_error then

353: end if;
354: /*End - Bug 6417742(FP of 6342851): Added call label printing*/
355:
356: exception
357: when fnd_api.g_exc_unexpected_error then
358: rollback to wiptmpvb100;
359: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
360: wip_utilities.get_message_stack(p_msg => x_errorMsg,
361: p_delete_stack => fnd_api.g_false);

Line 359: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

355:
356: exception
357: when fnd_api.g_exc_unexpected_error then
358: rollback to wiptmpvb100;
359: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
360: wip_utilities.get_message_stack(p_msg => x_errorMsg,
361: p_delete_stack => fnd_api.g_false);
362: if(l_logLevel <= wip_constants.trace_logging) then
363: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 361: p_delete_stack => fnd_api.g_false);

357: when fnd_api.g_exc_unexpected_error then
358: rollback to wiptmpvb100;
359: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
360: wip_utilities.get_message_stack(p_msg => x_errorMsg,
361: p_delete_stack => fnd_api.g_false);
362: if(l_logLevel <= wip_constants.trace_logging) then
363: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
364: p_procReturnStatus => x_returnStatus,
365: p_msg => 'error:' || x_errorMsg,

Line 367: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

363: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
364: p_procReturnStatus => x_returnStatus,
365: p_msg => 'error:' || x_errorMsg,
366: x_returnStatus => l_retStatus);
367: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
368: wip_logger.cleanup(l_retStatus);
369: end if;
370: end if;
371: when others then

Line 373: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

369: end if;
370: end if;
371: when others then
372: rollback to wiptmpvb100;
373: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
374: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
375: p_procedure_name => l_procName,
376: p_error_text => SQLERRM);
377: wip_utilities.get_message_stack(p_msg => x_errorMsg,

Line 378: p_delete_stack => fnd_api.g_false);

374: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
375: p_procedure_name => l_procName,
376: p_error_text => SQLERRM);
377: wip_utilities.get_message_stack(p_msg => x_errorMsg,
378: p_delete_stack => fnd_api.g_false);
379: if(l_logLevel <= wip_constants.trace_logging) then
380: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
381: p_procReturnStatus => x_returnStatus,
382: p_msg => 'unexp error:' || x_errorMsg,

Line 384: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

380: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
381: p_procReturnStatus => x_returnStatus,
382: p_msg => 'unexp error:' || x_errorMsg,
383: x_returnStatus => l_retStatus);
384: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
385: wip_logger.cleanup(l_retStatus);
386: end if;
387: end if;
388: end processWIP;

Line 410: l_endDebug VARCHAR2(1) := nvl(p_endDebug, fnd_api.g_false);

406: type item_tbl_t is table of varchar2(2000);
407: l_errExplTbl err_tbl_t;
408: l_itemNameTbl item_tbl_t;
409: l_procName VARCHAR2(30) := 'validateInterfaceTxns';
410: l_endDebug VARCHAR2(1) := nvl(p_endDebug, fnd_api.g_false);
411: l_retStatus VARCHAR2(1);
412: begin
413: savepoint wiptmpvb200;
414: x_returnStatus := fnd_api.g_ret_sts_success;

Line 414: x_returnStatus := fnd_api.g_ret_sts_success;

410: l_endDebug VARCHAR2(1) := nvl(p_endDebug, fnd_api.g_false);
411: l_retStatus VARCHAR2(1);
412: begin
413: savepoint wiptmpvb200;
414: x_returnStatus := fnd_api.g_ret_sts_success;
415:
416: if (l_logLevel <= wip_constants.trace_logging) then
417: l_params(1).paramName := 'p_txnHdrID';
418: l_params(1).paramValue := p_txnHdrID;

Line 423: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

419:
420: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
421: p_params => l_params,
422: x_returnStatus => x_returnStatus);
423: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
424: raise fnd_api.g_exc_unexpected_error;
425: end if;
426: end if;
427:

Line 424: raise fnd_api.g_exc_unexpected_error;

420: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
421: p_params => l_params,
422: x_returnStatus => x_returnStatus);
423: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
424: raise fnd_api.g_exc_unexpected_error;
425: end if;
426: end if;
427:
428: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then

Line 428: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then

424: raise fnd_api.g_exc_unexpected_error;
425: end if;
426: end if;
427:
428: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
429: fnd_msg_pub.initialize;
430: end if;
431:
432: if(l_numIntRows is null) then

Line 446: if(fnd_api.to_boolean(l_endDebug)) then

442: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
443: p_procReturnStatus => x_returnStatus,
444: p_msg => 'no rows to backflush',
445: x_returnStatus => l_retStatus);
446: if(fnd_api.to_boolean(l_endDebug)) then
447: wip_logger.cleanup(l_retStatus);
448: end if;
449: end if;
450: return;

Line 454: p_init_msg_list => nvl(p_initMsgList, fnd_api.g_false),

450: return;
451: end if;
452:
453: l_retCode := inv_txn_manager_grp.validate_transactions(p_api_version => 1.0,
454: p_init_msg_list => nvl(p_initMsgList, fnd_api.g_false),
455: p_validation_level => fnd_api.g_valid_level_none,
456: p_header_id => p_txnHdrID,
457: x_trans_count => l_numTempRows,
458: x_return_status => x_returnStatus,

Line 455: p_validation_level => fnd_api.g_valid_level_none,

451: end if;
452:
453: l_retCode := inv_txn_manager_grp.validate_transactions(p_api_version => 1.0,
454: p_init_msg_list => nvl(p_initMsgList, fnd_api.g_false),
455: p_validation_level => fnd_api.g_valid_level_none,
456: p_header_id => p_txnHdrID,
457: x_trans_count => l_numTempRows,
458: x_return_status => x_returnStatus,
459: x_msg_count => l_msgCount,

Line 476: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then

472:
473: --after inv supports x_trans_count, change if below
474: -- if(l_numTempRows = l_numIntRows) then
475: if(l_numErrRows = 0) then
476: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
477: fnd_msg_pub.initialize;
478: end if;
479: if(l_logLevel <= wip_constants.trace_logging) then
480: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 484: if(fnd_api.to_boolean(l_endDebug)) then

480: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
481: p_procReturnStatus => x_returnStatus,
482: p_msg => 'normal completion. ' || l_numTempRows || ' rows processed.',
483: x_returnStatus => l_retStatus);
484: if(fnd_api.to_boolean(l_endDebug)) then
485: wip_logger.cleanup(l_retStatus);
486: end if;
487: end if;
488: return;

Line 492: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

488: return;
489: end if;
490:
491: --if any rows errored...
492: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
493:
494: if(fnd_api.to_boolean(nvl(p_addMsgToStack, fnd_api.g_true))) then
495: --re-initialize message stack
496: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then

Line 494: if(fnd_api.to_boolean(nvl(p_addMsgToStack, fnd_api.g_true))) then

490:
491: --if any rows errored...
492: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
493:
494: if(fnd_api.to_boolean(nvl(p_addMsgToStack, fnd_api.g_true))) then
495: --re-initialize message stack
496: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
497: fnd_msg_pub.initialize;
498: end if;

Line 496: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then

492: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
493:
494: if(fnd_api.to_boolean(nvl(p_addMsgToStack, fnd_api.g_true))) then
495: --re-initialize message stack
496: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
497: fnd_msg_pub.initialize;
498: end if;
499:
500: select msik.concatenated_segments,

Line 522: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then

518: fnd_msg_pub.add;
519: end loop;
520: end if;
521:
522: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
523: rollback to wiptmpvb200;
524: end if;
525:
526: if(l_logLevel <= wip_constants.trace_logging) then

Line 531: if(fnd_api.to_boolean(l_endDebug)) then

527: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
528: p_procReturnStatus => x_returnStatus,
529: p_msg => to_char(l_numIntRows - l_numTempRows) || ' records errored',
530: x_returnStatus => l_retStatus);
531: if(fnd_api.to_boolean(l_endDebug)) then
532: wip_logger.cleanup(l_retStatus);
533: end if;
534: end if;
535:

Line 537: when fnd_api.g_exc_unexpected_error then

533: end if;
534: end if;
535:
536: exception
537: when fnd_api.g_exc_unexpected_error then
538: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
539: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
540: rollback to wiptmpvb200;
541: else --caller wants error in MTI

Line 538: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

534: end if;
535:
536: exception
537: when fnd_api.g_exc_unexpected_error then
538: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
539: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
540: rollback to wiptmpvb200;
541: else --caller wants error in MTI
542: wip_utilities.get_message_stack(p_msg => l_msgData,

Line 539: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then

535:
536: exception
537: when fnd_api.g_exc_unexpected_error then
538: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
539: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
540: rollback to wiptmpvb200;
541: else --caller wants error in MTI
542: wip_utilities.get_message_stack(p_msg => l_msgData,
543: p_delete_stack => fnd_api.g_false);

Line 543: p_delete_stack => fnd_api.g_false);

539: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
540: rollback to wiptmpvb200;
541: else --caller wants error in MTI
542: wip_utilities.get_message_stack(p_msg => l_msgData,
543: p_delete_stack => fnd_api.g_false);
544:
545: update mtl_transactions_interface
546: set last_update_date = sysdate,
547: last_update_login = fnd_global.login_id,

Line 568: if(fnd_api.to_boolean(l_endDebug)) then

564: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
565: p_procReturnStatus => x_returnStatus,
566: p_msg => 'error:' || l_msgData,
567: x_returnStatus => l_retStatus);
568: if(fnd_api.to_boolean(l_endDebug)) then
569: wip_logger.cleanup(l_retStatus);
570: end if;
571: end if;
572: when others then

Line 573: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

569: wip_logger.cleanup(l_retStatus);
570: end if;
571: end if;
572: when others then
573: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
574: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
575: p_procedure_name => l_procName,
576: p_error_text => SQLERRM);
577:

Line 578: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then

574: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
575: p_procedure_name => l_procName,
576: p_error_text => SQLERRM);
577:
578: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
579: rollback to wiptmpvb200;
580: else
581: wip_utilities.get_message_stack(p_msg => l_msgData,
582: p_delete_stack => fnd_api.g_false);

Line 582: p_delete_stack => fnd_api.g_false);

578: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
579: rollback to wiptmpvb200;
580: else
581: wip_utilities.get_message_stack(p_msg => l_msgData,
582: p_delete_stack => fnd_api.g_false);
583:
584: update mtl_transactions_interface
585: set last_update_date = sysdate,
586: last_update_login = fnd_global.login_id,

Line 602: if(fnd_api.to_boolean(l_endDebug)) then

598: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
599: p_procReturnStatus => x_returnStatus,
600: p_msg => 'unexp error:' || l_msgData,
601: x_returnStatus => l_retStatus);
602: if(fnd_api.to_boolean(l_endDebug)) then
603: wip_logger.cleanup(l_retStatus);
604: end if;
605: end if;
606: end validateInterfaceTxns;