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;
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:
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;
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,
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);
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;
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: -------------------------------------------------------------
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
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
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 => ' ');
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,
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
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,
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:
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;
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:
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;
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)*/
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;
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;
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:
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;
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
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;
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
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;
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
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,
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:
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,
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 ' ||
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);
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,
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,
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
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,
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,
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;
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;
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;
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:
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
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
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;
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,
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,
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,
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;
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
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;
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,
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
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:
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
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,
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);
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,
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
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:
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);
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,
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;