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_ONLINE_MTL_TXN_PROCESSOR dependencies on FND_API

Line 21: x_return_status := FND_API.G_RET_STS_SUCCESS;

17: and wlc.header_id = wlcs.header_id;
18:
19: l_msg_count NUMBER;
20: BEGIN
21: x_return_status := FND_API.G_RET_STS_SUCCESS;
22: SAVEPOINT PRE_UPDATE;
23: FOR v_serial IN c_serials LOOP
24: wms_wip_integration.post_completion(p_item_id => v_serial.inventory_item_id,
25: p_org_id => v_serial.organization_id,

Line 32: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

28: p_to_serial_number => v_serial.to_serial_number,
29: x_msg_count => l_msg_count,
30: x_msg_data => x_err_msg,
31: x_return_status => x_return_status);
32: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
33: ROLLBACK TO PRE_UPDATE;
34: raise FND_API.G_EXC_UNEXPECTED_ERROR;
35: end if;
36: END LOOP;

Line 34: raise FND_API.G_EXC_UNEXPECTED_ERROR;

30: x_msg_data => x_err_msg,
31: x_return_status => x_return_status);
32: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
33: ROLLBACK TO PRE_UPDATE;
34: raise FND_API.G_EXC_UNEXPECTED_ERROR;
35: end if;
36: END LOOP;
37:
38: EXCEPTION

Line 39: when FND_API.G_EXC_UNEXPECTED_ERROR then

35: end if;
36: END LOOP;
37:
38: EXCEPTION
39: when FND_API.G_EXC_UNEXPECTED_ERROR then
40: if(l_msg_count > 1) then
41: fnd_msg_pub.get(p_data => x_err_msg,
42: p_msg_index_out => l_msg_count);
43: end if;

Line 74: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

70: wip_wol_processor.completeAssyItem(p_header_id => p_header_id,
71: x_err_msg => x_err_msg,
72: x_return_status => x_return_status);
73:
74: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
75: raise FND_API.G_EXC_UNEXPECTED_ERROR;
76: end if;
77:
78: updateSerials(p_header_id => p_header_id,

Line 75: raise FND_API.G_EXC_UNEXPECTED_ERROR;

71: x_err_msg => x_err_msg,
72: x_return_status => x_return_status);
73:
74: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
75: raise FND_API.G_EXC_UNEXPECTED_ERROR;
76: end if;
77:
78: updateSerials(p_header_id => p_header_id,
79: x_err_msg => x_err_msg,

Line 82: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

78: updateSerials(p_header_id => p_header_id,
79: x_err_msg => x_err_msg,
80: x_return_status => x_return_status);
81:
82: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
83: raise FND_API.G_EXC_UNEXPECTED_ERROR;
84: end if;
85:
86: exception when others then

Line 83: raise FND_API.G_EXC_UNEXPECTED_ERROR;

79: x_err_msg => x_err_msg,
80: x_return_status => x_return_status);
81:
82: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
83: raise FND_API.G_EXC_UNEXPECTED_ERROR;
84: end if;
85:
86: exception when others then
87: ROLLBACK TO COMPLETEWOL;

Line 100: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then --now perform material txns for the components

96: wip_online_mtl_txn_processor.completeAssyItem(p_header_id => p_header_id,
97: x_err_msg => x_err_msg,
98: x_return_status => x_return_status);
99:
100: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then --now perform material txns for the components
101: transactMaterials(p_source_id => p_header_id,
102: x_err_msg => x_err_msg,
103: x_return_status => x_return_status);
104: end if;

Line 107: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

103: x_return_status => x_return_status);
104: end if;
105:
106:
107: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
108: ROLLBACK to SAVEPOINT CACSTART;
109: end if;
110: END completeAssyAndComponents;
111:

Line 121: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

117: SAVEPOINT COMPASSYITEM;
118: wip_discrete_job_processor.completeAssyItem(p_header_id => p_header_id,
119: x_err_msg => x_err_msg,
120: x_return_status => x_return_status);
121: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
122: raise FND_API.G_EXC_UNEXPECTED_ERROR;
123: end if;
124: updateSerials(p_header_id => p_header_id,
125: x_err_msg => x_err_msg,

Line 122: raise FND_API.G_EXC_UNEXPECTED_ERROR;

118: wip_discrete_job_processor.completeAssyItem(p_header_id => p_header_id,
119: x_err_msg => x_err_msg,
120: x_return_status => x_return_status);
121: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
122: raise FND_API.G_EXC_UNEXPECTED_ERROR;
123: end if;
124: updateSerials(p_header_id => p_header_id,
125: x_err_msg => x_err_msg,
126: x_return_status => x_return_status);

Line 128: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

124: updateSerials(p_header_id => p_header_id,
125: x_err_msg => x_err_msg,
126: x_return_status => x_return_status);
127:
128: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
129: raise FND_API.G_EXC_UNEXPECTED_ERROR;
130: end if;
131:
132: EXCEPTION

Line 129: raise FND_API.G_EXC_UNEXPECTED_ERROR;

125: x_err_msg => x_err_msg,
126: x_return_status => x_return_status);
127:
128: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
129: raise FND_API.G_EXC_UNEXPECTED_ERROR;
130: end if;
131:
132: EXCEPTION
133: when others then

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148: FROM WIP_LPN_COMPLETIONS
149: WHERE v_source_id = SOURCE_ID
150: AND v_source_id <> HEADER_ID;
151: BEGIN
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: SAVEPOINT TXMAT;
154: FOR v_comp_header_id IN c_components(p_source_id) LOOP
155: transactMaterial(p_header_id => v_comp_header_id.header_id,
156: x_err_msg => x_err_msg,

Line 158: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

154: FOR v_comp_header_id IN c_components(p_source_id) LOOP
155: transactMaterial(p_header_id => v_comp_header_id.header_id,
156: x_err_msg => x_err_msg,
157: x_return_status => x_return_status);
158: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
159: raise FND_API.G_EXC_UNEXPECTED_ERROR;
160: end if;--break out nocopy of the loop, preserving the error message and status for the bad component
161: END LOOP;
162:

Line 159: raise FND_API.G_EXC_UNEXPECTED_ERROR;

155: transactMaterial(p_header_id => v_comp_header_id.header_id,
156: x_err_msg => x_err_msg,
157: x_return_status => x_return_status);
158: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
159: raise FND_API.G_EXC_UNEXPECTED_ERROR;
160: end if;--break out nocopy of the loop, preserving the error message and status for the bad component
161: END LOOP;
162:
163: EXCEPTION

Line 282: x_return_status := fnd_api.g_ret_sts_unexp_error;

278: -- mmttParameter.locatorID := null;
279:
280: wma_flow.insertParentRecordIntoMMTT(mmttParameter, l_ret_value , x_err_msg);
281: if ( l_ret_value = -1 ) then
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: if (l_logLevel <= wip_constants.full_logging) then
284: wip_logger.log('assy insert failed', dummyErrCode);
285: end if;
286: raise fnd_api.g_exc_unexpected_error;

Line 286: raise fnd_api.g_exc_unexpected_error;

282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: if (l_logLevel <= wip_constants.full_logging) then
284: wip_logger.log('assy insert failed', dummyErrCode);
285: end if;
286: raise fnd_api.g_exc_unexpected_error;
287: end if;
288:
289:
290: /*Bug 6417742 (FP of 6342851) - Commented label printing call, this API will be called from WIP_MTLTEMPPROC_PRIV.PROCESSWIP.

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

296: p_msg_data => error,
297: p_label_status => labelStatus,
298: p_business_flow_code => 33); -- discrete business flow code
299: -- do not error out if label printing, only put warning message in log
300: if(returnStatus <> fnd_api.g_ret_sts_success) then
301: WIP_UTILITIES.get_message_stack(p_msg => l_msg_stack);
302: if (l_logLevel <= wip_constants.full_logging) then
303: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
304: 'The following error has occurred during ' ||

Line 320: fnd_api.g_false, -- do not call inv trx processor

316:
317: -- process the transaction
318: wip_cfmProc_priv.processMobile(p_processHeaderID,
319: p_processTempID,
320: fnd_api.g_false, -- do not call inv trx processor
321: x_return_status,
322: x_err_msg);
323:
324: if ( x_return_status <> fnd_api.g_ret_sts_success ) then

Line 324: if ( x_return_status <> fnd_api.g_ret_sts_success ) then

320: fnd_api.g_false, -- do not call inv trx processor
321: x_return_status,
322: x_err_msg);
323:
324: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
325: if (l_logLevel <= wip_constants.full_logging) then
326: wip_logger.log('assy processing failed', dummyErrCode);
327: end if;
328: raise fnd_api.g_exc_unexpected_error;

Line 328: raise fnd_api.g_exc_unexpected_error;

324: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
325: if (l_logLevel <= wip_constants.full_logging) then
326: wip_logger.log('assy processing failed', dummyErrCode);
327: end if;
328: raise fnd_api.g_exc_unexpected_error;
329: end if;
330:
331: --get the flow schedule wip entity id if it is a wol trx
332: if (p_scheduledFlag = 2) then

Line 359: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,

355: /*End - Fix for bug #6216695, which is an FP of 6082623:
356: Delete MTLT and MSNT records also*/
357:
358: --process the components
359: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
360: p_txnHdrID => p_processHeaderID,
361: p_txnMode => wip_constants.online,
362: p_destroyQtyTrees => fnd_api.g_true,
363: p_endDebug => fnd_api.g_false,

Line 362: p_destroyQtyTrees => fnd_api.g_true,

358: --process the components
359: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
360: p_txnHdrID => p_processHeaderID,
361: p_txnMode => wip_constants.online,
362: p_destroyQtyTrees => fnd_api.g_true,
363: p_endDebug => fnd_api.g_false,
364: x_returnStatus => x_return_status,
365: x_errorMsg => x_err_msg);
366: if(x_return_status <> fnd_api.g_ret_sts_success) then

Line 363: p_endDebug => fnd_api.g_false,

359: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
360: p_txnHdrID => p_processHeaderID,
361: p_txnMode => wip_constants.online,
362: p_destroyQtyTrees => fnd_api.g_true,
363: p_endDebug => fnd_api.g_false,
364: x_returnStatus => x_return_status,
365: x_errorMsg => x_err_msg);
366: if(x_return_status <> fnd_api.g_ret_sts_success) then
367: if (l_logLevel <= wip_constants.full_logging) then

Line 366: if(x_return_status <> fnd_api.g_ret_sts_success) then

362: p_destroyQtyTrees => fnd_api.g_true,
363: p_endDebug => fnd_api.g_false,
364: x_returnStatus => x_return_status,
365: x_errorMsg => x_err_msg);
366: if(x_return_status <> fnd_api.g_ret_sts_success) then
367: if (l_logLevel <= wip_constants.full_logging) then
368: wip_logger.log('component processing failed', dummyErrCode);
369: end if;
370: raise fnd_api.g_exc_unexpected_error;

Line 370: raise fnd_api.g_exc_unexpected_error;

366: if(x_return_status <> fnd_api.g_ret_sts_success) then
367: if (l_logLevel <= wip_constants.full_logging) then
368: wip_logger.log('component processing failed', dummyErrCode);
369: end if;
370: raise fnd_api.g_exc_unexpected_error;
371: end if;
372:
373: -- insert into wip_lpn_completions
374: lpnParameter.environment := environment ;

Line 402: x_return_status := fnd_api.g_ret_sts_unexp_error;

398: lpnParameter.demandSourceLine := p_demandSourceLine;
399: lpnParameter.demandSourceDelivery := p_demandSourceDelivery;
400: wma_cfm.process(lpnParameter, l_ret_value , x_err_msg);
401: if ( l_ret_value = -1 ) then
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: if (l_logLevel <= wip_constants.full_logging) then
404: wip_logger.log('assy lpn insert failed', dummyErrCode);
405: end if;
406: raise fnd_api.g_exc_unexpected_error;

Line 406: raise fnd_api.g_exc_unexpected_error;

402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: if (l_logLevel <= wip_constants.full_logging) then
404: wip_logger.log('assy lpn insert failed', dummyErrCode);
405: end if;
406: raise fnd_api.g_exc_unexpected_error;
407: end if;
408:
409: updateSerials(p_header_id => lpnParameter.headerID,
410: x_err_msg => x_err_msg,

Line 413: if ( x_return_status <> fnd_api.g_ret_sts_success ) then

409: updateSerials(p_header_id => lpnParameter.headerID,
410: x_err_msg => x_err_msg,
411: x_return_status => x_return_status);
412:
413: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
414: if (l_logLevel <= wip_constants.full_logging) then
415: wip_logger.log('updateSerials failed', dummyErrCode);
416: end if;
417: raise fnd_api.g_exc_unexpected_error;

Line 417: raise fnd_api.g_exc_unexpected_error;

413: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
414: if (l_logLevel <= wip_constants.full_logging) then
415: wip_logger.log('updateSerials failed', dummyErrCode);
416: end if;
417: raise fnd_api.g_exc_unexpected_error;
418: end if;
419:
420: x_return_status := fnd_api.G_RET_STS_SUCCESS;
421:

Line 420: x_return_status := fnd_api.G_RET_STS_SUCCESS;

416: end if;
417: raise fnd_api.g_exc_unexpected_error;
418: end if;
419:
420: x_return_status := fnd_api.G_RET_STS_SUCCESS;
421:
422: if (l_logLevel <= wip_constants.trace_logging) then
423: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteFlow',
424: p_procReturnStatus => x_return_status,

Line 431: when fnd_api.g_exc_unexpected_error then

427: wip_logger.cleanUp(dummyErrCode);
428: end if;
429:
430: EXCEPTION
431: when fnd_api.g_exc_unexpected_error then
432: if (l_logLevel <= wip_constants.trace_logging) then
433: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteFlow',
434: p_procReturnStatus => x_return_status,
435: p_msg => 'error:' || x_err_msg,

Line 440: x_return_status := fnd_api.g_ret_sts_unexp_error;

436: x_returnStatus => dummyErrCode);
437: wip_logger.cleanUp(dummyErrCode);
438: end if;
439: when others then
440: x_return_status := fnd_api.g_ret_sts_unexp_error;
441: x_err_msg := SQLERRM;
442: -- WIP_UTILITIES.get_message_stack(p_msg => x_err_msg);
443: if (l_logLevel <= wip_constants.trace_logging) then
444: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteFlow',

Line 462: * x_return_status -- fnd_api.G_RET_STS_SUCCESS ('S') if successful

458: * p_transactionHeaderID -- header ID in wip_lpn_completions
459: * p_processHeaderID -- transaction header ID in mmtt
460: * p_processIntID -- transaction temp ID in mmtt
461: * x_err_msg -- err_msg if call fails, null if success
462: * x_return_status -- fnd_api.G_RET_STS_SUCCESS ('S') if successful
463: */
464: PROCEDURE lpnCompleteJob (p_orgID NUMBER,
465: p_userID NUMBER,
466: p_transactionTypeID NUMBER,

Line 538: x_return_status := fnd_api.g_ret_sts_unexp_error;

534: status => l_ret_value,
535: errMessage => x_err_msg,
536: cmpl_txnTmpID => l_cmpl_txnTmpID); --Bug 6013398
537: if ( l_ret_value = -1 ) then
538: x_return_status := fnd_api.g_ret_sts_unexp_error;
539: if (l_logLevel <= wip_constants.full_logging) then
540: wip_logger.log('lpn processing failed', dummyErrCode);
541: end if;
542: raise fnd_api.g_exc_unexpected_error;

Line 542: raise fnd_api.g_exc_unexpected_error;

538: x_return_status := fnd_api.g_ret_sts_unexp_error;
539: if (l_logLevel <= wip_constants.full_logging) then
540: wip_logger.log('lpn processing failed', dummyErrCode);
541: end if;
542: raise fnd_api.g_exc_unexpected_error;
543: end if;
544:
545: --move the components to MMTT
546: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => p_processHeaderID,

Line 547: p_initMsgList => fnd_api.g_true,

543: end if;
544:
545: --move the components to MMTT
546: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => p_processHeaderID,
547: p_initMsgList => fnd_api.g_true,
548: x_returnStatus => x_return_status);
549: if(x_return_status <> fnd_api.g_ret_sts_success) then
550: if (l_logLevel <= wip_constants.full_logging) then
551: wip_logger.log('component validation failed', dummyErrCode);

Line 549: if(x_return_status <> fnd_api.g_ret_sts_success) then

545: --move the components to MMTT
546: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => p_processHeaderID,
547: p_initMsgList => fnd_api.g_true,
548: x_returnStatus => x_return_status);
549: if(x_return_status <> fnd_api.g_ret_sts_success) then
550: if (l_logLevel <= wip_constants.full_logging) then
551: wip_logger.log('component validation failed', dummyErrCode);
552: end if;
553: wip_utilities.get_message_stack(p_msg => x_err_msg);

Line 554: raise fnd_api.g_exc_unexpected_error;

550: if (l_logLevel <= wip_constants.full_logging) then
551: wip_logger.log('component validation failed', dummyErrCode);
552: end if;
553: wip_utilities.get_message_stack(p_msg => x_err_msg);
554: raise fnd_api.g_exc_unexpected_error;
555: end if;
556:
557: --process the components
558: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,

Line 558: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,

554: raise fnd_api.g_exc_unexpected_error;
555: end if;
556:
557: --process the components
558: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
559: p_txnHdrID => p_processHeaderID,
560: p_txnMode => wip_constants.online,
561: p_destroyQtyTrees => fnd_api.g_true,
562: p_endDebug => fnd_api.g_false,

Line 561: p_destroyQtyTrees => fnd_api.g_true,

557: --process the components
558: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
559: p_txnHdrID => p_processHeaderID,
560: p_txnMode => wip_constants.online,
561: p_destroyQtyTrees => fnd_api.g_true,
562: p_endDebug => fnd_api.g_false,
563: x_returnStatus => x_return_status,
564: x_errorMsg => x_err_msg);
565:

Line 562: p_endDebug => fnd_api.g_false,

558: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
559: p_txnHdrID => p_processHeaderID,
560: p_txnMode => wip_constants.online,
561: p_destroyQtyTrees => fnd_api.g_true,
562: p_endDebug => fnd_api.g_false,
563: x_returnStatus => x_return_status,
564: x_errorMsg => x_err_msg);
565:
566: if(x_return_status <> fnd_api.g_ret_sts_success) then

Line 566: if(x_return_status <> fnd_api.g_ret_sts_success) then

562: p_endDebug => fnd_api.g_false,
563: x_returnStatus => x_return_status,
564: x_errorMsg => x_err_msg);
565:
566: if(x_return_status <> fnd_api.g_ret_sts_success) then
567: if (l_logLevel <= wip_constants.full_logging) then
568: wip_logger.log('component processing failed', dummyErrCode);
569: end if;
570: raise fnd_api.g_exc_unexpected_error;

Line 570: raise fnd_api.g_exc_unexpected_error;

566: if(x_return_status <> fnd_api.g_ret_sts_success) then
567: if (l_logLevel <= wip_constants.full_logging) then
568: wip_logger.log('component processing failed', dummyErrCode);
569: end if;
570: raise fnd_api.g_exc_unexpected_error;
571: end if;
572:
573: /* Start - Bug 6013398: Moved below code from procedure wma_completion.process to here*/
574: /* Start of fix for bug 4253002 */

Line 583: if(l_retStatus <> fnd_api.g_ret_sts_success) then

579: p_msg_data => error,
580: p_label_status => labelStatus,
581: p_business_flow_code => 26); -- discrete business flow code
582: -- do not error out if label printing, only put warning message in log
583: if(l_retStatus <> fnd_api.g_ret_sts_success) then
584: wip_utilities.get_message_stack(p_msg => l_msg_stack);
585: if (l_logLevel <= wip_constants.full_logging) then
586: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
587: 'The following error has occurred during ' ||

Line 622: if ( x_return_status <> fnd_api.g_ret_sts_success ) then

618: updateSerials(p_header_id => lpnParameters.headerID,
619: x_err_msg => x_err_msg,
620: x_return_status => x_return_status);
621:
622: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
623: if (l_logLevel <= wip_constants.full_logging) then
624: wip_logger.log('updateSerials failed', dummyErrCode);
625: end if;
626: raise fnd_api.g_exc_unexpected_error;

Line 626: raise fnd_api.g_exc_unexpected_error;

622: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
623: if (l_logLevel <= wip_constants.full_logging) then
624: wip_logger.log('updateSerials failed', dummyErrCode);
625: end if;
626: raise fnd_api.g_exc_unexpected_error;
627: end if;
628:
629:
630:

Line 631: x_return_status := fnd_api.G_RET_STS_SUCCESS;

627: end if;
628:
629:
630:
631: x_return_status := fnd_api.G_RET_STS_SUCCESS;
632:
633: if (l_logLevel <= wip_constants.trace_logging) then
634: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteJob',
635: p_procReturnStatus => x_return_status,

Line 642: when fnd_api.g_exc_unexpected_error then

638: wip_logger.cleanUp(dummyErrCode);
639: end if;
640:
641: EXCEPTION
642: when fnd_api.g_exc_unexpected_error then
643: if (l_logLevel <= wip_constants.trace_logging) then
644: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteJob',
645: p_procReturnStatus => x_return_status,
646: p_msg => x_err_msg,

Line 651: x_return_status := fnd_api.g_ret_sts_unexp_error;

647: x_returnStatus => dummyErrCode);
648: wip_logger.cleanUp(dummyErrCode);
649: end if;
650: when others then
651: x_return_status := fnd_api.g_ret_sts_unexp_error;
652: WIP_UTILITIES.get_message_stack(p_msg => x_err_msg);
653: if (l_logLevel <= wip_constants.trace_logging) then
654: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteJob',
655: p_procReturnStatus => x_return_status,