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

Line 65: raise fnd_api.g_exc_unexpected_error;

61: fnd_msg_pub.add;
62: if (l_logLevel <= wip_constants.full_logging) then
63: wip_logger.log('error from derive', errCode);
64: end if;
65: raise fnd_api.g_exc_unexpected_error;
66: end if;
67: if (l_logLevel <= wip_constants.full_logging) then
68: wip_logger.log('new tmp id is ' || cmpRecord.transaction_interface_id, errCode);
69: end if;

Line 76: raise fnd_api.g_exc_unexpected_error;

72: if (put(cmpRecord, errMessage) = FALSE) then
73: if (l_logLevel <= wip_constants.full_logging) then
74: wip_logger.log('error from put', errCode);
75: end if;
76: raise fnd_api.g_exc_unexpected_error;
77: end if;
78:
79: select primary_cost_method
80: into primaryCostMethod

Line 102: raise fnd_api.g_exc_unexpected_error;

98: fnd_msg_pub.add;
99: if (l_logLevel <= wip_constants.full_logging) then
100: wip_logger.log('error from cst', errMessage);
101: end if;
102: raise fnd_api.g_exc_unexpected_error;
103: end if;
104: end if;
105:
106: wip_utilities.print_label(p_txn_id => cmpRecord.transaction_header_id,

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

110: p_msg_data => error,
111: p_label_status => labelStatus,
112: p_business_flow_code => 26); -- discrete business flow code
113: -- do not error out if label printing, only put warning message in log
114: if(returnStatus <> fnd_api.g_ret_sts_success) then
115: wip_utilities.get_message_stack(p_msg => l_msg_stack);
116: if (l_logLevel <= wip_constants.full_logging) then
117: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
118: 'The following error has occurred during ' ||

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

164: wip_logger.log('wma_completion.process: overcomplete retStatus => ' ||
165: returnStatus, dummy);
166: end if;
167:
168: if(returnStatus <> fnd_api.g_ret_sts_success) then
169: raise fnd_api.g_exc_unexpected_error;
170: end if;
171: end if;
172:

Line 169: raise fnd_api.g_exc_unexpected_error;

165: returnStatus, dummy);
166: end if;
167:
168: if(returnStatus <> fnd_api.g_ret_sts_success) then
169: raise fnd_api.g_exc_unexpected_error;
170: end if;
171: end if;
172:
173: if(fnd_api.to_boolean(processInv)) then

Line 173: if(fnd_api.to_boolean(processInv)) then

169: raise fnd_api.g_exc_unexpected_error;
170: end if;
171: end if;
172:
173: if(fnd_api.to_boolean(processInv)) then
174: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
175: p_txnHdrID => cmpRecord.transaction_header_id,
176: p_txnMode => l_txnMode,
177: p_destroyQtyTrees => fnd_api.g_true,

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

170: end if;
171: end if;
172:
173: if(fnd_api.to_boolean(processInv)) then
174: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
175: p_txnHdrID => cmpRecord.transaction_header_id,
176: p_txnMode => l_txnMode,
177: p_destroyQtyTrees => fnd_api.g_true,
178: p_endDebug => fnd_api.g_false,

Line 177: p_destroyQtyTrees => fnd_api.g_true,

173: if(fnd_api.to_boolean(processInv)) then
174: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
175: p_txnHdrID => cmpRecord.transaction_header_id,
176: p_txnMode => l_txnMode,
177: p_destroyQtyTrees => fnd_api.g_true,
178: p_endDebug => fnd_api.g_false,
179: x_returnStatus => returnStatus,
180: x_errorMsg => errMessage);
181: else

Line 178: p_endDebug => fnd_api.g_false,

174: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
175: p_txnHdrID => cmpRecord.transaction_header_id,
176: p_txnMode => l_txnMode,
177: p_destroyQtyTrees => fnd_api.g_true,
178: p_endDebug => fnd_api.g_false,
179: x_returnStatus => returnStatus,
180: x_errorMsg => errMessage);
181: else
182: wip_mtlTempProc_priv.processWIP(p_txnTmpID => cmpRecord.transaction_interface_id,

Line 183: p_processLpn => fnd_api.g_true,

179: x_returnStatus => returnStatus,
180: x_errorMsg => errMessage);
181: else
182: wip_mtlTempProc_priv.processWIP(p_txnTmpID => cmpRecord.transaction_interface_id,
183: p_processLpn => fnd_api.g_true,
184: x_returnStatus => returnStatus,
185: x_errorMsg => errMessage);
186: end if;
187:

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

187:
188: if (l_logLevel <= wip_constants.full_logging) then
189: wip_logger.log('wma_completion.process: retStatus => ' || returnStatus, dummy);
190: end if;
191: if(returnStatus <> fnd_api.g_ret_sts_success) then
192: raise fnd_api.g_exc_unexpected_error;
193: end if;
194:
195: --update to MSN must take place after inventory processing as they always clear the

Line 192: raise fnd_api.g_exc_unexpected_error;

188: if (l_logLevel <= wip_constants.full_logging) then
189: wip_logger.log('wma_completion.process: retStatus => ' || returnStatus, dummy);
190: end if;
191: if(returnStatus <> fnd_api.g_ret_sts_success) then
192: raise fnd_api.g_exc_unexpected_error;
193: end if;
194:
195: --update to MSN must take place after inventory processing as they always clear the
196: --group mark id when processing a serial. Here we have to repopulate the group_mark_id,

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

219: end if;
220: if (l_logLevel <= wip_constants.full_logging) then
221: wip_logger.log('wma_completion.process: serialization op retStatus => ' || returnStatus, dummy);
222: end if;
223: if(returnStatus <> fnd_api.g_ret_sts_success) then
224: if (l_logLevel <= wip_constants.full_logging) then
225: wip_logger.log('wma_completion.process: retStatus of serial update failure ' || returnStatus, dummy);
226: end if;
227: wip_utilities.get_message_stack(p_msg => errMessage);

Line 228: raise fnd_api.g_exc_unexpected_error;

224: if (l_logLevel <= wip_constants.full_logging) then
225: wip_logger.log('wma_completion.process: retStatus of serial update failure ' || returnStatus, dummy);
226: end if;
227: wip_utilities.get_message_stack(p_msg => errMessage);
228: raise fnd_api.g_exc_unexpected_error;
229: end if;
230: end if;
231: if (l_logLevel <= wip_constants.trace_logging) then
232: wip_logger.exitPoint(p_procName => 'wma_completion.process',

Line 239: when fnd_api.g_exc_unexpected_error then

235: x_returnStatus => dummy);
236: end if;
237: wip_logger.cleanUp(dummy);
238: EXCEPTION
239: when fnd_api.g_exc_unexpected_error then
240: status := -1;
241: if (l_logLevel <= wip_constants.trace_logging) then
242: wip_logger.exitPoint(p_procName => 'wma_completion.process',
243: p_procReturnStatus => status,

Line 259: returnStatus := fnd_api.g_ret_sts_unexp_error;

255: x_returnStatus => dummy);
256: wip_logger.cleanUp(dummy);
257: end if;
258: rollback to wma_cmp_proc10;
259: returnStatus := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
262: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
263: errMessage := fnd_message.get;

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

387: p_msg_data => error,
388: p_label_status => labelStatus,
389: p_business_flow_code => 26); -- discrete business flow code
390: -- do not error out if label printing, only put warning message in log
391: if(l_retStatus <> fnd_api.g_ret_sts_success) then
392: wip_utilities.get_message_stack(p_msg => l_msg_stack);
393: if (l_logLevel <= wip_constants.full_logging) then
394: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
395: 'The following error has occurred during ' ||

Line 414: p_processLpn => fnd_api.g_true,

410: cmpl_txnTmpID := l_txnTmpID;
411: --End: Bug 6013398.
412: --use it to do WIP processing...
413: wip_mtlTempProc_priv.processWIP(p_txnTmpID => l_txnTmpID,
414: p_processLpn => fnd_api.g_true,
415: x_returnStatus => l_retStatus,
416: x_errorMsg => error);
417: if(l_retStatus <> fnd_api.g_ret_sts_success) then
418: rollback to wmapcmpb_proc1000;

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

413: wip_mtlTempProc_priv.processWIP(p_txnTmpID => l_txnTmpID,
414: p_processLpn => fnd_api.g_true,
415: x_returnStatus => l_retStatus,
416: x_errorMsg => error);
417: if(l_retStatus <> fnd_api.g_ret_sts_success) then
418: rollback to wmapcmpb_proc1000;
419: status := -1;
420: errMessage := error;
421: return;

Line 1144: x_returnStatus := fnd_api.g_ret_sts_success;

1140: p_params => l_params,
1141: x_returnStatus => l_returnStatus);
1142: end if;
1143:
1144: x_returnStatus := fnd_api.g_ret_sts_success;
1145: if ( p_overCplQty > 0 ) then
1146: wip_overcompletion.check_tolerance(
1147: p_organization_id => p_orgID,
1148: p_wip_entity_id => p_wipEntityID,

Line 1156: x_returnStatus := fnd_api.g_ret_sts_error;

1152: if (result = WIP_CONSTANTS.NO) then
1153: -- exceed tolerance, set error message
1154: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1155: x_errMessage := fnd_message.get;
1156: x_returnStatus := fnd_api.g_ret_sts_error;
1157: end if;
1158: end if;
1159:
1160: if (l_logLevel <= wip_constants.trace_logging) then

Line 1168: x_returnStatus := fnd_api.g_ret_sts_error;

1164: x_returnStatus => l_returnStatus);
1165: end if;
1166: EXCEPTION
1167: when others then
1168: x_returnStatus := fnd_api.g_ret_sts_error;
1169: if (l_logLevel <= wip_constants.trace_logging) then
1170: wip_logger.exitPoint(p_procName => 'wma_completion.checkOverCpl',
1171: p_procReturnStatus => -1,
1172: p_msg => x_errMessage,

Line 1402: p_initMsgList => fnd_api.g_true,

1398: end if;
1399:
1400:
1401: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => cmpRecord.transaction_header_id,
1402: p_initMsgList => fnd_api.g_true,
1403: x_returnStatus => l_retStatus);
1404:
1405: if(l_retStatus <> fnd_api.g_ret_sts_success) then
1406: if (l_logLevel <= wip_constants.full_logging) then

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

1401: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => cmpRecord.transaction_header_id,
1402: p_initMsgList => fnd_api.g_true,
1403: x_returnStatus => l_retStatus);
1404:
1405: if(l_retStatus <> fnd_api.g_ret_sts_success) then
1406: if (l_logLevel <= wip_constants.full_logging) then
1407: wip_logger.log('error from validateInterfaceTxns', l_retStatus);
1408: end if;
1409: wip_utilities.get_message_stack(p_msg => errMessage);

Line 1517: l_assyPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;

1513: x_errMessage OUT NOCOPY VARCHAR2) IS
1514: l_txnMode NUMBER;
1515: l_minOpSeqNum NUMBER;
1516: l_maxOpSeqNum NUMBER;
1517: l_assyPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1518: l_opPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1519: l_compTbl system.wip_component_tbl_t;
1520: l_returnStatus VARCHAR2(1);
1521: l_params wip_logger.param_tbl_t;

Line 1518: l_opPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;

1514: l_txnMode NUMBER;
1515: l_minOpSeqNum NUMBER;
1516: l_maxOpSeqNum NUMBER;
1517: l_assyPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1518: l_opPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1519: l_compTbl system.wip_component_tbl_t;
1520: l_returnStatus VARCHAR2(1);
1521: l_params wip_logger.param_tbl_t;
1522: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

Line 1568: p_mergeMode => fnd_api.g_false,

1564: p_wipSupplyType => wip_constants.assy_pull,
1565: p_txnHdrID => p_txnHdrID,
1566: p_firstOp => -1,
1567: p_lastOp => l_maxOpSeqNum,
1568: p_mergeMode => fnd_api.g_false,
1569: p_initMsgList => fnd_api.g_true,
1570: p_endDebug => fnd_api.g_true,
1571: p_mtlTxnMode => l_txnMode,
1572: x_compTbl => l_compTbl,

Line 1569: p_initMsgList => fnd_api.g_true,

1565: p_txnHdrID => p_txnHdrID,
1566: p_firstOp => -1,
1567: p_lastOp => l_maxOpSeqNum,
1568: p_mergeMode => fnd_api.g_false,
1569: p_initMsgList => fnd_api.g_true,
1570: p_endDebug => fnd_api.g_true,
1571: p_mtlTxnMode => l_txnMode,
1572: x_compTbl => l_compTbl,
1573: x_returnStatus => x_returnStatus);

Line 1570: p_endDebug => fnd_api.g_true,

1566: p_firstOp => -1,
1567: p_lastOp => l_maxOpSeqNum,
1568: p_mergeMode => fnd_api.g_false,
1569: p_initMsgList => fnd_api.g_true,
1570: p_endDebug => fnd_api.g_true,
1571: p_mtlTxnMode => l_txnMode,
1572: x_compTbl => l_compTbl,
1573: x_returnStatus => x_returnStatus);
1574: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

1570: p_endDebug => fnd_api.g_true,
1571: p_mtlTxnMode => l_txnMode,
1572: x_compTbl => l_compTbl,
1573: x_returnStatus => x_returnStatus);
1574: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1575: raise fnd_api.g_exc_unexpected_error;
1576: end if;
1577:
1578: if(p_overCplQty > 0) then --backflush move components if any exist

Line 1575: raise fnd_api.g_exc_unexpected_error;

1571: p_mtlTxnMode => l_txnMode,
1572: x_compTbl => l_compTbl,
1573: x_returnStatus => x_returnStatus);
1574: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1575: raise fnd_api.g_exc_unexpected_error;
1576: end if;
1577:
1578: if(p_overCplQty > 0) then --backflush move components if any exist
1579: wip_bflProc_priv.processRequirements(p_wipEntityID => p_jobID,

Line 1591: p_mergeMode => fnd_api.g_false,

1587: p_firstMoveOp => l_minOpSeqNum,
1588: p_lastMoveOp => l_maxOpSeqNum,
1589: p_firstOp => -1,
1590: p_lastOp => l_maxOpSeqNum,
1591: p_mergeMode => fnd_api.g_false,
1592: p_initMsgList => fnd_api.g_false,
1593: p_endDebug => fnd_api.g_true,
1594: p_mtlTxnMode => l_txnMode,
1595: x_compTbl => l_compTbl,

Line 1592: p_initMsgList => fnd_api.g_false,

1588: p_lastMoveOp => l_maxOpSeqNum,
1589: p_firstOp => -1,
1590: p_lastOp => l_maxOpSeqNum,
1591: p_mergeMode => fnd_api.g_false,
1592: p_initMsgList => fnd_api.g_false,
1593: p_endDebug => fnd_api.g_true,
1594: p_mtlTxnMode => l_txnMode,
1595: x_compTbl => l_compTbl,
1596: x_returnStatus => x_returnStatus);

Line 1593: p_endDebug => fnd_api.g_true,

1589: p_firstOp => -1,
1590: p_lastOp => l_maxOpSeqNum,
1591: p_mergeMode => fnd_api.g_false,
1592: p_initMsgList => fnd_api.g_false,
1593: p_endDebug => fnd_api.g_true,
1594: p_mtlTxnMode => l_txnMode,
1595: x_compTbl => l_compTbl,
1596: x_returnStatus => x_returnStatus);
1597:

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

1594: p_mtlTxnMode => l_txnMode,
1595: x_compTbl => l_compTbl,
1596: x_returnStatus => x_returnStatus);
1597:
1598: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1599: raise fnd_api.g_exc_unexpected_error;
1600: end if;
1601: end if;
1602:

Line 1599: raise fnd_api.g_exc_unexpected_error;

1595: x_compTbl => l_compTbl,
1596: x_returnStatus => x_returnStatus);
1597:
1598: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1599: raise fnd_api.g_exc_unexpected_error;
1600: end if;
1601: end if;
1602:
1603: x_compInfo := system.wip_lot_serial_obj_t(null, null, null, l_compTbl, null, null);

Line 1609: p_initMsgList => fnd_api.g_false,

1605:
1606: wip_autoLotProc_priv.deriveLots(x_compLots => x_compInfo,
1607: p_orgID => p_orgID,
1608: p_wipEntityID => p_jobID,
1609: p_initMsgList => fnd_api.g_false,
1610: p_endDebug => fnd_api.g_true,
1611: p_destroyTrees => fnd_api.g_true,
1612: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
1613: p_treeSrcName => null,

Line 1610: p_endDebug => fnd_api.g_true,

1606: wip_autoLotProc_priv.deriveLots(x_compLots => x_compInfo,
1607: p_orgID => p_orgID,
1608: p_wipEntityID => p_jobID,
1609: p_initMsgList => fnd_api.g_false,
1610: p_endDebug => fnd_api.g_true,
1611: p_destroyTrees => fnd_api.g_true,
1612: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
1613: p_treeSrcName => null,
1614: x_returnStatus => x_returnStatus);

Line 1611: p_destroyTrees => fnd_api.g_true,

1607: p_orgID => p_orgID,
1608: p_wipEntityID => p_jobID,
1609: p_initMsgList => fnd_api.g_false,
1610: p_endDebug => fnd_api.g_true,
1611: p_destroyTrees => fnd_api.g_true,
1612: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
1613: p_treeSrcName => null,
1614: x_returnStatus => x_returnStatus);
1615:

Line 1619: if(x_returnStatus = fnd_api.g_ret_sts_error and

1615:
1616: --if there is missing l/s info for a background txn, error out.
1617: --note that we are ignoring the serialization derivation below b/c
1618: --serialized pages are only online...
1619: if(x_returnStatus = fnd_api.g_ret_sts_error and
1620: l_txnMode = wip_constants.background) then
1621: fnd_message.set_name('WIP', 'WIP_NO_LS_COMP_IN_BKGND');
1622: fnd_msg_pub.add;
1623: raise fnd_api.g_exc_unexpected_error;

Line 1623: raise fnd_api.g_exc_unexpected_error;

1619: if(x_returnStatus = fnd_api.g_ret_sts_error and
1620: l_txnMode = wip_constants.background) then
1621: fnd_message.set_name('WIP', 'WIP_NO_LS_COMP_IN_BKGND');
1622: fnd_msg_pub.add;
1623: raise fnd_api.g_exc_unexpected_error;
1624: end if;
1625:
1626: if(x_returnStatus = fnd_api.g_ret_sts_unexp_error) then
1627: raise fnd_api.g_exc_unexpected_error;

Line 1626: if(x_returnStatus = fnd_api.g_ret_sts_unexp_error) then

1622: fnd_msg_pub.add;
1623: raise fnd_api.g_exc_unexpected_error;
1624: end if;
1625:
1626: if(x_returnStatus = fnd_api.g_ret_sts_unexp_error) then
1627: raise fnd_api.g_exc_unexpected_error;
1628: end if;
1629:
1630: -- derive serial for serialized transaction. We can just check p_objectID.

Line 1627: raise fnd_api.g_exc_unexpected_error;

1623: raise fnd_api.g_exc_unexpected_error;
1624: end if;
1625:
1626: if(x_returnStatus = fnd_api.g_ret_sts_unexp_error) then
1627: raise fnd_api.g_exc_unexpected_error;
1628: end if;
1629:
1630: -- derive serial for serialized transaction. We can just check p_objectID.
1631: -- If p_objectID is -1, don't need to call deriveSerial. Otherwise call

Line 1637: p_initMsgList => fnd_api.g_true,

1633: if ( p_objectID <> -1 ) then
1634: wip_autoSerialProc_priv.deriveSerial(x_compLots => x_compInfo,
1635: p_orgID => p_orgID,
1636: p_objectID => p_objectID,
1637: p_initMsgList => fnd_api.g_true,
1638: x_returnStatus => x_returnStatus);
1639: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then
1640: raise fnd_api.g_exc_unexpected_error;
1641: end if;

Line 1639: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then

1635: p_orgID => p_orgID,
1636: p_objectID => p_objectID,
1637: p_initMsgList => fnd_api.g_true,
1638: x_returnStatus => x_returnStatus);
1639: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then
1640: raise fnd_api.g_exc_unexpected_error;
1641: end if;
1642: end if;
1643:

Line 1640: raise fnd_api.g_exc_unexpected_error;

1636: p_objectID => p_objectID,
1637: p_initMsgList => fnd_api.g_true,
1638: x_returnStatus => x_returnStatus);
1639: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then
1640: raise fnd_api.g_exc_unexpected_error;
1641: end if;
1642: end if;
1643:
1644: if(l_txnMode = wip_constants.background) then

Line 1645: x_returnStatus := fnd_api.g_ret_sts_success;

1641: end if;
1642: end if;
1643:
1644: if(l_txnMode = wip_constants.background) then
1645: x_returnStatus := fnd_api.g_ret_sts_success;
1646: if (l_logLevel <= wip_constants.trace_logging) then
1647: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1648: p_procReturnStatus => x_returnStatus,
1649: p_msg => x_errMessage,

Line 1662: when fnd_api.g_exc_unexpected_error then

1658: p_msg => 'success',
1659: x_returnStatus => l_returnStatus);
1660: end if;
1661: exception
1662: when fnd_api.g_exc_unexpected_error then
1663: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1664: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1665: if (l_logLevel <= wip_constants.trace_logging) then
1666: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',

Line 1663: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1659: x_returnStatus => l_returnStatus);
1660: end if;
1661: exception
1662: when fnd_api.g_exc_unexpected_error then
1663: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1664: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1665: if (l_logLevel <= wip_constants.trace_logging) then
1666: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1667: p_procReturnStatus => x_returnStatus,

Line 1673: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1669: x_returnStatus => l_returnStatus);
1670: end if;
1671: rollback;
1672: when others then
1673: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1674: x_errMessage := SQLERRM;
1675: if (l_logLevel <= wip_constants.trace_logging) then
1676: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1677: p_procReturnStatus => x_returnStatus,