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

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

Line 409: p_processLpn => fnd_api.g_true,

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

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

408: wip_mtlTempProc_priv.processWIP(p_txnTmpID => l_txnTmpID,
409: p_processLpn => fnd_api.g_true,
410: x_returnStatus => l_retStatus,
411: x_errorMsg => error);
412: if(l_retStatus <> fnd_api.g_ret_sts_success) then
413: rollback to wmapcmpb_proc1000;
414: status := -1;
415: errMessage := error;
416: return;

Line 1135: x_returnStatus := fnd_api.g_ret_sts_success;

1131: p_params => l_params,
1132: x_returnStatus => l_returnStatus);
1133: end if;
1134:
1135: x_returnStatus := fnd_api.g_ret_sts_success;
1136: if ( p_overCplQty > 0 ) then
1137: wip_overcompletion.check_tolerance(
1138: p_organization_id => p_orgID,
1139: p_wip_entity_id => p_wipEntityID,

Line 1147: x_returnStatus := fnd_api.g_ret_sts_error;

1143: if (result = WIP_CONSTANTS.NO) then
1144: -- exceed tolerance, set error message
1145: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1146: x_errMessage := fnd_message.get;
1147: x_returnStatus := fnd_api.g_ret_sts_error;
1148: end if;
1149: end if;
1150:
1151: if (l_logLevel <= wip_constants.trace_logging) then

Line 1159: x_returnStatus := fnd_api.g_ret_sts_error;

1155: x_returnStatus => l_returnStatus);
1156: end if;
1157: EXCEPTION
1158: when others then
1159: x_returnStatus := fnd_api.g_ret_sts_error;
1160: if (l_logLevel <= wip_constants.trace_logging) then
1161: wip_logger.exitPoint(p_procName => 'wma_completion.checkOverCpl',
1162: p_procReturnStatus => -1,
1163: p_msg => x_errMessage,

Line 1393: p_initMsgList => fnd_api.g_true,

1389: end if;
1390:
1391:
1392: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => cmpRecord.transaction_header_id,
1393: p_initMsgList => fnd_api.g_true,
1394: x_returnStatus => l_retStatus);
1395:
1396: if(l_retStatus <> fnd_api.g_ret_sts_success) then
1397: if (l_logLevel <= wip_constants.full_logging) then

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

1392: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => cmpRecord.transaction_header_id,
1393: p_initMsgList => fnd_api.g_true,
1394: x_returnStatus => l_retStatus);
1395:
1396: if(l_retStatus <> fnd_api.g_ret_sts_success) then
1397: if (l_logLevel <= wip_constants.full_logging) then
1398: wip_logger.log('error from validateInterfaceTxns', l_retStatus);
1399: end if;
1400: wip_utilities.get_message_stack(p_msg => errMessage);

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

1504: x_errMessage OUT NOCOPY VARCHAR2) IS
1505: l_txnMode NUMBER;
1506: l_minOpSeqNum NUMBER;
1507: l_maxOpSeqNum NUMBER;
1508: l_assyPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1509: l_opPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1510: l_compTbl system.wip_component_tbl_t;
1511: l_returnStatus VARCHAR2(1);
1512: l_params wip_logger.param_tbl_t;

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

1505: l_txnMode NUMBER;
1506: l_minOpSeqNum NUMBER;
1507: l_maxOpSeqNum NUMBER;
1508: l_assyPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1509: l_opPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1510: l_compTbl system.wip_component_tbl_t;
1511: l_returnStatus VARCHAR2(1);
1512: l_params wip_logger.param_tbl_t;
1513: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

Line 1559: p_mergeMode => fnd_api.g_false,

1555: p_wipSupplyType => wip_constants.assy_pull,
1556: p_txnHdrID => p_txnHdrID,
1557: p_firstOp => -1,
1558: p_lastOp => l_maxOpSeqNum,
1559: p_mergeMode => fnd_api.g_false,
1560: p_initMsgList => fnd_api.g_true,
1561: p_endDebug => fnd_api.g_true,
1562: p_mtlTxnMode => l_txnMode,
1563: x_compTbl => l_compTbl,

Line 1560: p_initMsgList => fnd_api.g_true,

1556: p_txnHdrID => p_txnHdrID,
1557: p_firstOp => -1,
1558: p_lastOp => l_maxOpSeqNum,
1559: p_mergeMode => fnd_api.g_false,
1560: p_initMsgList => fnd_api.g_true,
1561: p_endDebug => fnd_api.g_true,
1562: p_mtlTxnMode => l_txnMode,
1563: x_compTbl => l_compTbl,
1564: x_returnStatus => x_returnStatus);

Line 1561: p_endDebug => fnd_api.g_true,

1557: p_firstOp => -1,
1558: p_lastOp => l_maxOpSeqNum,
1559: p_mergeMode => fnd_api.g_false,
1560: p_initMsgList => fnd_api.g_true,
1561: p_endDebug => fnd_api.g_true,
1562: p_mtlTxnMode => l_txnMode,
1563: x_compTbl => l_compTbl,
1564: x_returnStatus => x_returnStatus);
1565: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

1561: p_endDebug => fnd_api.g_true,
1562: p_mtlTxnMode => l_txnMode,
1563: x_compTbl => l_compTbl,
1564: x_returnStatus => x_returnStatus);
1565: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1566: raise fnd_api.g_exc_unexpected_error;
1567: end if;
1568:
1569: if(p_overCplQty > 0) then --backflush move components if any exist

Line 1566: raise fnd_api.g_exc_unexpected_error;

1562: p_mtlTxnMode => l_txnMode,
1563: x_compTbl => l_compTbl,
1564: x_returnStatus => x_returnStatus);
1565: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1566: raise fnd_api.g_exc_unexpected_error;
1567: end if;
1568:
1569: if(p_overCplQty > 0) then --backflush move components if any exist
1570: wip_bflProc_priv.processRequirements(p_wipEntityID => p_jobID,

Line 1582: p_mergeMode => fnd_api.g_false,

1578: p_firstMoveOp => l_minOpSeqNum,
1579: p_lastMoveOp => l_maxOpSeqNum,
1580: p_firstOp => -1,
1581: p_lastOp => l_maxOpSeqNum,
1582: p_mergeMode => fnd_api.g_false,
1583: p_initMsgList => fnd_api.g_false,
1584: p_endDebug => fnd_api.g_true,
1585: p_mtlTxnMode => l_txnMode,
1586: x_compTbl => l_compTbl,

Line 1583: p_initMsgList => fnd_api.g_false,

1579: p_lastMoveOp => l_maxOpSeqNum,
1580: p_firstOp => -1,
1581: p_lastOp => l_maxOpSeqNum,
1582: p_mergeMode => fnd_api.g_false,
1583: p_initMsgList => fnd_api.g_false,
1584: p_endDebug => fnd_api.g_true,
1585: p_mtlTxnMode => l_txnMode,
1586: x_compTbl => l_compTbl,
1587: x_returnStatus => x_returnStatus);

Line 1584: p_endDebug => fnd_api.g_true,

1580: p_firstOp => -1,
1581: p_lastOp => l_maxOpSeqNum,
1582: p_mergeMode => fnd_api.g_false,
1583: p_initMsgList => fnd_api.g_false,
1584: p_endDebug => fnd_api.g_true,
1585: p_mtlTxnMode => l_txnMode,
1586: x_compTbl => l_compTbl,
1587: x_returnStatus => x_returnStatus);
1588:

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

1585: p_mtlTxnMode => l_txnMode,
1586: x_compTbl => l_compTbl,
1587: x_returnStatus => x_returnStatus);
1588:
1589: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1590: raise fnd_api.g_exc_unexpected_error;
1591: end if;
1592: end if;
1593:

Line 1590: raise fnd_api.g_exc_unexpected_error;

1586: x_compTbl => l_compTbl,
1587: x_returnStatus => x_returnStatus);
1588:
1589: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1590: raise fnd_api.g_exc_unexpected_error;
1591: end if;
1592: end if;
1593:
1594: x_compInfo := system.wip_lot_serial_obj_t(null, null, null, l_compTbl, null, null);

Line 1600: p_initMsgList => fnd_api.g_false,

1596:
1597: wip_autoLotProc_priv.deriveLots(x_compLots => x_compInfo,
1598: p_orgID => p_orgID,
1599: p_wipEntityID => p_jobID,
1600: p_initMsgList => fnd_api.g_false,
1601: p_endDebug => fnd_api.g_true,
1602: p_destroyTrees => fnd_api.g_true,
1603: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
1604: p_treeSrcName => null,

Line 1601: p_endDebug => fnd_api.g_true,

1597: wip_autoLotProc_priv.deriveLots(x_compLots => x_compInfo,
1598: p_orgID => p_orgID,
1599: p_wipEntityID => p_jobID,
1600: p_initMsgList => fnd_api.g_false,
1601: p_endDebug => fnd_api.g_true,
1602: p_destroyTrees => fnd_api.g_true,
1603: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
1604: p_treeSrcName => null,
1605: x_returnStatus => x_returnStatus);

Line 1602: p_destroyTrees => fnd_api.g_true,

1598: p_orgID => p_orgID,
1599: p_wipEntityID => p_jobID,
1600: p_initMsgList => fnd_api.g_false,
1601: p_endDebug => fnd_api.g_true,
1602: p_destroyTrees => fnd_api.g_true,
1603: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
1604: p_treeSrcName => null,
1605: x_returnStatus => x_returnStatus);
1606:

Line 1610: if(x_returnStatus = fnd_api.g_ret_sts_error and

1606:
1607: --if there is missing l/s info for a background txn, error out.
1608: --note that we are ignoring the serialization derivation below b/c
1609: --serialized pages are only online...
1610: if(x_returnStatus = fnd_api.g_ret_sts_error and
1611: l_txnMode = wip_constants.background) then
1612: fnd_message.set_name('WIP', 'WIP_NO_LS_COMP_IN_BKGND');
1613: fnd_msg_pub.add;
1614: raise fnd_api.g_exc_unexpected_error;

Line 1614: raise fnd_api.g_exc_unexpected_error;

1610: if(x_returnStatus = fnd_api.g_ret_sts_error and
1611: l_txnMode = wip_constants.background) then
1612: fnd_message.set_name('WIP', 'WIP_NO_LS_COMP_IN_BKGND');
1613: fnd_msg_pub.add;
1614: raise fnd_api.g_exc_unexpected_error;
1615: end if;
1616:
1617: if(x_returnStatus = fnd_api.g_ret_sts_unexp_error) then
1618: raise fnd_api.g_exc_unexpected_error;

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

1613: fnd_msg_pub.add;
1614: raise fnd_api.g_exc_unexpected_error;
1615: end if;
1616:
1617: if(x_returnStatus = fnd_api.g_ret_sts_unexp_error) then
1618: raise fnd_api.g_exc_unexpected_error;
1619: end if;
1620:
1621: -- derive serial for serialized transaction. We can just check p_objectID.

Line 1618: raise fnd_api.g_exc_unexpected_error;

1614: raise fnd_api.g_exc_unexpected_error;
1615: end if;
1616:
1617: if(x_returnStatus = fnd_api.g_ret_sts_unexp_error) then
1618: raise fnd_api.g_exc_unexpected_error;
1619: end if;
1620:
1621: -- derive serial for serialized transaction. We can just check p_objectID.
1622: -- If p_objectID is -1, don't need to call deriveSerial. Otherwise call

Line 1628: p_initMsgList => fnd_api.g_true,

1624: if ( p_objectID <> -1 ) then
1625: wip_autoSerialProc_priv.deriveSerial(x_compLots => x_compInfo,
1626: p_orgID => p_orgID,
1627: p_objectID => p_objectID,
1628: p_initMsgList => fnd_api.g_true,
1629: x_returnStatus => x_returnStatus);
1630: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then
1631: raise fnd_api.g_exc_unexpected_error;
1632: end if;

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

1626: p_orgID => p_orgID,
1627: p_objectID => p_objectID,
1628: p_initMsgList => fnd_api.g_true,
1629: x_returnStatus => x_returnStatus);
1630: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then
1631: raise fnd_api.g_exc_unexpected_error;
1632: end if;
1633: end if;
1634:

Line 1631: raise fnd_api.g_exc_unexpected_error;

1627: p_objectID => p_objectID,
1628: p_initMsgList => fnd_api.g_true,
1629: x_returnStatus => x_returnStatus);
1630: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then
1631: raise fnd_api.g_exc_unexpected_error;
1632: end if;
1633: end if;
1634:
1635: if(l_txnMode = wip_constants.background) then

Line 1636: x_returnStatus := fnd_api.g_ret_sts_success;

1632: end if;
1633: end if;
1634:
1635: if(l_txnMode = wip_constants.background) then
1636: x_returnStatus := fnd_api.g_ret_sts_success;
1637: if (l_logLevel <= wip_constants.trace_logging) then
1638: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1639: p_procReturnStatus => x_returnStatus,
1640: p_msg => x_errMessage,

Line 1653: when fnd_api.g_exc_unexpected_error then

1649: p_msg => 'success',
1650: x_returnStatus => l_returnStatus);
1651: end if;
1652: exception
1653: when fnd_api.g_exc_unexpected_error then
1654: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1655: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1656: if (l_logLevel <= wip_constants.trace_logging) then
1657: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',

Line 1654: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1650: x_returnStatus => l_returnStatus);
1651: end if;
1652: exception
1653: when fnd_api.g_exc_unexpected_error then
1654: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1655: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1656: if (l_logLevel <= wip_constants.trace_logging) then
1657: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1658: p_procReturnStatus => x_returnStatus,

Line 1664: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1660: x_returnStatus => l_returnStatus);
1661: end if;
1662: rollback;
1663: when others then
1664: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1665: x_errMessage := SQLERRM;
1666: if (l_logLevel <= wip_constants.trace_logging) then
1667: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1668: p_procReturnStatus => x_returnStatus,