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 193: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

189: l_params(2).paramValue := p_processLpn;
190: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
191: p_params => l_params,
192: x_returnStatus => x_returnStatus);
193: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
194: raise fnd_api.g_exc_unexpected_error;
195: end if;
196: end if;
197:

Line 194: raise fnd_api.g_exc_unexpected_error;

190: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
191: p_params => l_params,
192: x_returnStatus => x_returnStatus);
193: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
194: raise fnd_api.g_exc_unexpected_error;
195: end if;
196: end if;
197:
198: x_returnStatus := fnd_api.g_ret_sts_success;

Line 198: x_returnStatus := fnd_api.g_ret_sts_success;

194: raise fnd_api.g_exc_unexpected_error;
195: end if;
196: end if;
197:
198: x_returnStatus := fnd_api.g_ret_sts_success;
199:
200: select transaction_action_id,
201: transaction_header_id, /*Added for bug 6417742(FP of 6342851)*/
202: transaction_type_id, /*Added for bug 6417742(FP of 6342851)*/

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

262: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
263: p_procReturnStatus => x_returnStatus,
264: p_msg => 'success: phantom record deleted without any action',
265: x_returnStatus => l_retStatus);
266: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
267: wip_logger.cleanup(l_retStatus);
268: end if;
269: end if;
270: end if;

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

297: if(l_wipEntityType <> wip_constants.flow) then
298: if(l_logLevel <= wip_constants.full_logging) then
299: wip_logger.log('calling component processor', l_retStatus);
300: end if;
301: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
302: p_endDebug => fnd_api.g_false,
303: p_txnTmpID => p_txnTmpID,
304: x_returnStatus => x_returnStatus);
305: end if;

Line 302: p_endDebug => fnd_api.g_false,

298: if(l_logLevel <= wip_constants.full_logging) then
299: wip_logger.log('calling component processor', l_retStatus);
300: end if;
301: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
302: p_endDebug => fnd_api.g_false,
303: p_txnTmpID => p_txnTmpID,
304: x_returnStatus => x_returnStatus);
305: end if;
306:

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

305: end if;
306:
307: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
308: --no action is necessary for lpn completions
309: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
310: if(l_wipEntityType = wip_constants.flow) then
311: if(l_logLevel <= wip_constants.full_logging) then
312: wip_logger.log('calling flow/wol processor', l_retStatus);
313: end if;

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

310: if(l_wipEntityType = wip_constants.flow) then
311: if(l_logLevel <= wip_constants.full_logging) then
312: wip_logger.log('calling flow/wol processor', l_retStatus);
313: end if;
314: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
315: p_txnTempID => p_txnTmpID,
316: x_returnStatus => x_returnStatus);
317: else --non flow completion
318: if(l_logLevel <= wip_constants.full_logging) then

Line 322: p_initMsgList => fnd_api.g_false,

318: if(l_logLevel <= wip_constants.full_logging) then
319: wip_logger.log('calling cpl processor', l_retStatus);
320: end if;
321: wip_cplProc_priv.processTemp(p_txnTmpID => p_txnTmpID,
322: p_initMsgList => fnd_api.g_false,
323: p_endDebug => fnd_api.g_false,
324: x_returnStatus => x_returnStatus);
325: end if;
326: end if;

Line 323: p_endDebug => fnd_api.g_false,

319: wip_logger.log('calling cpl processor', l_retStatus);
320: end if;
321: wip_cplProc_priv.processTemp(p_txnTmpID => p_txnTmpID,
322: p_initMsgList => fnd_api.g_false,
323: p_endDebug => fnd_api.g_false,
324: x_returnStatus => x_returnStatus);
325: end if;
326: end if;
327: elsif(l_txnActionID = wip_constants.scrassy_action) then

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

335: elsif (l_wipEntityType = wip_constants.flow) then
336: if(l_logLevel <= wip_constants.full_logging) then
337: wip_logger.log('calling flow/wol processor', l_retStatus);
338: end if;
339: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
340: p_txnTempID => p_txnTmpID,
341: x_returnStatus => x_returnStatus);
342: end if;
343: end if;

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

341: x_returnStatus => x_returnStatus);
342: end if;
343: end if;
344:
345: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
346: raise fnd_api.g_exc_unexpected_error;
347: end if;
348:
349: if(l_logLevel <= wip_constants.trace_logging) then

Line 346: raise fnd_api.g_exc_unexpected_error;

342: end if;
343: end if;
344:
345: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
346: raise fnd_api.g_exc_unexpected_error;
347: end if;
348:
349: if(l_logLevel <= wip_constants.trace_logging) then
350: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

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

350: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
351: p_procReturnStatus => x_returnStatus,
352: p_msg => 'success',
353: x_returnStatus => l_retStatus);
354: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
355: wip_logger.cleanup(l_retStatus);
356: end if;
357: end if;
358:

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

361: twice for LPN completion/drop transaction */
362: if ( l_txnActionID = WIP_CONSTANTS.CPLASSY_ACTION and
363: l_flowSchedule = 'Y' and
364: l_transaction_type_id = WIP_CONSTANTS.CPLASSY_TYPE and
365: (l_lpnID is null or fnd_api.to_boolean(p_processLpn))) then
366: -- print label
367: wip_utilities.print_label(p_txn_id => l_transaction_header_id, -- should be transaction header id
368: p_table_type => 2, --MMTT
369: p_ret_status => returnStatus,

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

372: p_label_status => labelStatus,
373: p_business_flow_code => 33); -- discrete business flow code
374:
375: -- do not error out if label printing, only put warning message in log
376: if(returnStatus <> fnd_api.g_ret_sts_success) then
377: WIP_UTILITIES.get_message_stack(p_msg => l_msg_stack);
378: if (l_logLevel <= wip_constants.full_logging) then
379: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
380: 'The following error has occurred during ' ||

Line 396: when fnd_api.g_exc_unexpected_error then

392: /*End - Bug 6417742(FP of 6342851): Added call label printing*/
393:
394:
395: exception
396: when fnd_api.g_exc_unexpected_error then
397: rollback to wiptmpvb100;
398: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
399: wip_utilities.get_message_stack(p_msg => x_errorMsg,
400: p_delete_stack => fnd_api.g_false);

Line 398: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

394:
395: exception
396: when fnd_api.g_exc_unexpected_error then
397: rollback to wiptmpvb100;
398: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
399: wip_utilities.get_message_stack(p_msg => x_errorMsg,
400: p_delete_stack => fnd_api.g_false);
401: if(l_logLevel <= wip_constants.trace_logging) then
402: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 400: p_delete_stack => fnd_api.g_false);

396: when fnd_api.g_exc_unexpected_error then
397: rollback to wiptmpvb100;
398: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
399: wip_utilities.get_message_stack(p_msg => x_errorMsg,
400: p_delete_stack => fnd_api.g_false);
401: if(l_logLevel <= wip_constants.trace_logging) then
402: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
403: p_procReturnStatus => x_returnStatus,
404: p_msg => 'error:' || x_errorMsg,

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

402: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
403: p_procReturnStatus => x_returnStatus,
404: p_msg => 'error:' || x_errorMsg,
405: x_returnStatus => l_retStatus);
406: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
407: wip_logger.cleanup(l_retStatus);
408: end if;
409: end if;
410: when others then

Line 412: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

408: end if;
409: end if;
410: when others then
411: rollback to wiptmpvb100;
412: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
413: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
414: p_procedure_name => l_procName,
415: p_error_text => SQLERRM);
416: wip_utilities.get_message_stack(p_msg => x_errorMsg,

Line 417: p_delete_stack => fnd_api.g_false);

413: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
414: p_procedure_name => l_procName,
415: p_error_text => SQLERRM);
416: wip_utilities.get_message_stack(p_msg => x_errorMsg,
417: p_delete_stack => fnd_api.g_false);
418: if(l_logLevel <= wip_constants.trace_logging) then
419: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
420: p_procReturnStatus => x_returnStatus,
421: p_msg => 'unexp error:' || x_errorMsg,

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

419: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
420: p_procReturnStatus => x_returnStatus,
421: p_msg => 'unexp error:' || x_errorMsg,
422: x_returnStatus => l_retStatus);
423: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
424: wip_logger.cleanup(l_retStatus);
425: end if;
426: end if;
427: end processWIP;

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

445: type item_tbl_t is table of varchar2(2000);
446: l_errExplTbl err_tbl_t;
447: l_itemNameTbl item_tbl_t;
448: l_procName VARCHAR2(30) := 'validateInterfaceTxns';
449: l_endDebug VARCHAR2(1) := nvl(p_endDebug, fnd_api.g_false);
450: l_retStatus VARCHAR2(1);
451: begin
452: savepoint wiptmpvb200;
453: x_returnStatus := fnd_api.g_ret_sts_success;

Line 453: x_returnStatus := fnd_api.g_ret_sts_success;

449: l_endDebug VARCHAR2(1) := nvl(p_endDebug, fnd_api.g_false);
450: l_retStatus VARCHAR2(1);
451: begin
452: savepoint wiptmpvb200;
453: x_returnStatus := fnd_api.g_ret_sts_success;
454:
455: if (l_logLevel <= wip_constants.trace_logging) then
456: l_params(1).paramName := 'p_txnHdrID';
457: l_params(1).paramValue := p_txnHdrID;

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

458:
459: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
460: p_params => l_params,
461: x_returnStatus => x_returnStatus);
462: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
463: raise fnd_api.g_exc_unexpected_error;
464: end if;
465: end if;
466:

Line 463: raise fnd_api.g_exc_unexpected_error;

459: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
460: p_params => l_params,
461: x_returnStatus => x_returnStatus);
462: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
463: raise fnd_api.g_exc_unexpected_error;
464: end if;
465: end if;
466:
467: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then

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

463: raise fnd_api.g_exc_unexpected_error;
464: end if;
465: end if;
466:
467: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
468: fnd_msg_pub.initialize;
469: end if;
470:
471: if(l_numIntRows is null) then

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

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

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

489: return;
490: end if;
491:
492: l_retCode := inv_txn_manager_grp.validate_transactions(p_api_version => 1.0,
493: p_init_msg_list => nvl(p_initMsgList, fnd_api.g_false),
494: p_validation_level => fnd_api.g_valid_level_none,
495: p_header_id => p_txnHdrID,
496: x_trans_count => l_numTempRows,
497: x_return_status => x_returnStatus,

Line 494: p_validation_level => fnd_api.g_valid_level_none,

490: end if;
491:
492: l_retCode := inv_txn_manager_grp.validate_transactions(p_api_version => 1.0,
493: p_init_msg_list => nvl(p_initMsgList, fnd_api.g_false),
494: p_validation_level => fnd_api.g_valid_level_none,
495: p_header_id => p_txnHdrID,
496: x_trans_count => l_numTempRows,
497: x_return_status => x_returnStatus,
498: x_msg_count => l_msgCount,

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

511:
512: --after inv supports x_trans_count, change if below
513: -- if(l_numTempRows = l_numIntRows) then
514: if(l_numErrRows = 0) then
515: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
516: fnd_msg_pub.initialize;
517: end if;
518: if(l_logLevel <= wip_constants.trace_logging) then
519: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

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

519: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
520: p_procReturnStatus => x_returnStatus,
521: p_msg => 'normal completion. ' || l_numTempRows || ' rows processed.',
522: x_returnStatus => l_retStatus);
523: if(fnd_api.to_boolean(l_endDebug)) then
524: wip_logger.cleanup(l_retStatus);
525: end if;
526: end if;
527: return;

Line 531: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

527: return;
528: end if;
529:
530: --if any rows errored...
531: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
532:
533: if(fnd_api.to_boolean(nvl(p_addMsgToStack, fnd_api.g_true))) then
534: --re-initialize message stack
535: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then

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

529:
530: --if any rows errored...
531: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
532:
533: if(fnd_api.to_boolean(nvl(p_addMsgToStack, fnd_api.g_true))) then
534: --re-initialize message stack
535: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
536: fnd_msg_pub.initialize;
537: end if;

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

531: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
532:
533: if(fnd_api.to_boolean(nvl(p_addMsgToStack, fnd_api.g_true))) then
534: --re-initialize message stack
535: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
536: fnd_msg_pub.initialize;
537: end if;
538:
539: select msik.concatenated_segments,

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

557: fnd_msg_pub.add;
558: end loop;
559: end if;
560:
561: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
562: rollback to wiptmpvb200;
563: end if;
564:
565: if(l_logLevel <= wip_constants.trace_logging) then

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

566: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
567: p_procReturnStatus => x_returnStatus,
568: p_msg => to_char(l_numIntRows - l_numTempRows) || ' records errored',
569: x_returnStatus => l_retStatus);
570: if(fnd_api.to_boolean(l_endDebug)) then
571: wip_logger.cleanup(l_retStatus);
572: end if;
573: end if;
574:

Line 576: when fnd_api.g_exc_unexpected_error then

572: end if;
573: end if;
574:
575: exception
576: when fnd_api.g_exc_unexpected_error then
577: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
578: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
579: rollback to wiptmpvb200;
580: else --caller wants error in MTI

Line 577: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

573: end if;
574:
575: exception
576: when fnd_api.g_exc_unexpected_error then
577: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
578: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
579: rollback to wiptmpvb200;
580: else --caller wants error in MTI
581: wip_utilities.get_message_stack(p_msg => l_msgData,

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

574:
575: exception
576: when fnd_api.g_exc_unexpected_error then
577: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
578: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
579: rollback to wiptmpvb200;
580: else --caller wants error in MTI
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 --caller wants error in MTI
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 607: if(fnd_api.to_boolean(l_endDebug)) then

603: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
604: p_procReturnStatus => x_returnStatus,
605: p_msg => 'error:' || l_msgData,
606: x_returnStatus => l_retStatus);
607: if(fnd_api.to_boolean(l_endDebug)) then
608: wip_logger.cleanup(l_retStatus);
609: end if;
610: end if;
611: when others then

Line 612: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

608: wip_logger.cleanup(l_retStatus);
609: end if;
610: end if;
611: when others then
612: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
614: p_procedure_name => l_procName,
615: p_error_text => SQLERRM);
616:

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

613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
614: p_procedure_name => l_procName,
615: p_error_text => SQLERRM);
616:
617: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
618: rollback to wiptmpvb200;
619: else
620: wip_utilities.get_message_stack(p_msg => l_msgData,
621: p_delete_stack => fnd_api.g_false);

Line 621: p_delete_stack => fnd_api.g_false);

617: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
618: rollback to wiptmpvb200;
619: else
620: wip_utilities.get_message_stack(p_msg => l_msgData,
621: p_delete_stack => fnd_api.g_false);
622:
623: update mtl_transactions_interface
624: set last_update_date = sysdate,
625: last_update_login = fnd_global.login_id,

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

637: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
638: p_procReturnStatus => x_returnStatus,
639: p_msg => 'unexp error:' || l_msgData,
640: x_returnStatus => l_retStatus);
641: if(fnd_api.to_boolean(l_endDebug)) then
642: wip_logger.cleanup(l_retStatus);
643: end if;
644: end if;
645: end validateInterfaceTxns;