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

Line 64: if(fnd_api.to_boolean(p_initMsgList)) then

60: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
61: begin
62: savepoint wipmtlpb_SP1;
63:
64: if(fnd_api.to_boolean(p_initMsgList)) then
65: fnd_msg_pub.initialize;
66: end if;
67:
68: if (l_logLevel <= wip_constants.trace_logging) then

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

70: l_params(1).paramValue := p_txnTmpID;
71: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTemp',
72: p_params => l_params,
73: x_returnStatus => x_returnStatus);
74: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
75: raise fnd_api.g_exc_unexpected_error;
76: end if;
77: end if;
78:

Line 75: raise fnd_api.g_exc_unexpected_error;

71: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTemp',
72: p_params => l_params,
73: x_returnStatus => x_returnStatus);
74: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
75: raise fnd_api.g_exc_unexpected_error;
76: end if;
77: end if;
78:
79: select p_txnTmpID,

Line 180: raise fnd_api.g_exc_unexpected_error;

176: end;
177: fnd_message.set_name('WIP', 'WIP_PICKING_STATUS_ERROR');
178: fnd_message.set_token('STATUS', l_jobStatus);
179: fnd_msg_pub.add;
180: raise fnd_api.g_exc_unexpected_error;
181: end if;
182: */
183:
184: processTxn(p_issueRec => l_issueRec,

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

184: processTxn(p_issueRec => l_issueRec,
185: p_issueQty => null, --since not processing rep schedules
186: p_repSchedID => null, --since not processing rep schedules
187: x_returnStatus => x_returnStatus);
188: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
189: raise fnd_api.g_exc_unexpected_error;
190: end if;
191:
192: -------------------

Line 189: raise fnd_api.g_exc_unexpected_error;

185: p_issueQty => null, --since not processing rep schedules
186: p_repSchedID => null, --since not processing rep schedules
187: x_returnStatus => x_returnStatus);
188: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
189: raise fnd_api.g_exc_unexpected_error;
190: end if;
191:
192: -------------------
193: --eam issue code

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

198: wip_logger.log('about to call EAM processor ', l_returnStatus);
199: end if;
200: wip_eamMtlProc_priv.processCompTxn(p_compRec => l_issueRec,
201: x_returnStatus => x_returnStatus);
202: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
203: l_errMsg := 'EAM logic failed';
204: raise fnd_api.g_exc_unexpected_error;
205: end if;
206: end if;

Line 204: raise fnd_api.g_exc_unexpected_error;

200: wip_eamMtlProc_priv.processCompTxn(p_compRec => l_issueRec,
201: x_returnStatus => x_returnStatus);
202: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
203: l_errMsg := 'EAM logic failed';
204: raise fnd_api.g_exc_unexpected_error;
205: end if;
206: end if;
207:
208: elsif(l_issueRec.wipEntityType = wip_constants.repetitive) then

Line 217: raise fnd_api.g_exc_unexpected_error;

213: else
214: fnd_message.set_name('WIP', 'OPERATION_PROCESSING_ERROR');
215: l_errMsg := 'Invalid WIP Entity Type:' || l_issueRec.wipEntityType;
216: fnd_msg_pub.add;
217: raise fnd_api.g_exc_unexpected_error;
218: end if;
219:
220: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
221: l_errMsg := 'processing failed';

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

216: fnd_msg_pub.add;
217: raise fnd_api.g_exc_unexpected_error;
218: end if;
219:
220: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
221: l_errMsg := 'processing failed';
222: raise fnd_api.g_exc_unexpected_error;
223: end if;
224: if(l_issueRec.qaCollectionID is not null and

Line 222: raise fnd_api.g_exc_unexpected_error;

218: end if;
219:
220: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
221: l_errMsg := 'processing failed';
222: raise fnd_api.g_exc_unexpected_error;
223: end if;
224: if(l_issueRec.qaCollectionID is not null and
225: l_issueRec.movTxnID is null) then --if movTxnID is present, move would have enabled results.
226: qa_result_grp.enable(p_api_version => 1.0,

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

228: p_collection_id => l_issueRec.qaCollectionID,
229: p_return_status => x_returnStatus,
230: p_msg_count => l_msgCount,
231: p_msg_data => l_errMsg);
232: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
233: l_errMsg := 'QA Failed. Collection ID:' || l_issueRec.qaCollectionID;
234: raise fnd_api.g_exc_unexpected_error;
235: end if;
236: end if;

Line 234: raise fnd_api.g_exc_unexpected_error;

230: p_msg_count => l_msgCount,
231: p_msg_data => l_errMsg);
232: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
233: l_errMsg := 'QA Failed. Collection ID:' || l_issueRec.qaCollectionID;
234: raise fnd_api.g_exc_unexpected_error;
235: end if;
236: end if;
237:
238: if (l_logLevel <= wip_constants.trace_logging) then

Line 244: if(fnd_api.to_boolean(p_endDebug)) then

240: p_procReturnStatus => x_returnStatus,
241: p_msg => 'Transaction Succeeded',
242: x_returnStatus => l_returnStatus); --discard logging return status
243: end if;
244: if(fnd_api.to_boolean(p_endDebug)) then
245: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
246: end if;
247: exception
248: --processing error. return status and error msg should have already been set.

Line 250: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

246: end if;
247: exception
248: --processing error. return status and error msg should have already been set.
249: when no_data_found then
250: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
251: rollback to wipmtlpb_SP1;
252: if (l_logLevel <= wip_constants.trace_logging) then
253: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
254: p_procReturnStatus => x_returnStatus,

Line 258: if(fnd_api.to_boolean(p_endDebug)) then

254: p_procReturnStatus => x_returnStatus,
255: p_msg => 'no data found exception. tmpID:' || p_txnTmpID,
256: x_returnStatus => l_returnStatus); --discard logging return status
257: end if;
258: if(fnd_api.to_boolean(p_endDebug)) then
259: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
260: end if;
261: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');
262: fnd_msg_pub.add;

Line 265: when fnd_api.g_exc_unexpected_error then

261: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');
262: fnd_msg_pub.add;
263: writeError(p_txnTmpID);
264:
265: when fnd_api.g_exc_unexpected_error then
266: rollback to wipmtlpb_SP1;
267:
268: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
269:

Line 268: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

264:
265: when fnd_api.g_exc_unexpected_error then
266: rollback to wipmtlpb_SP1;
267:
268: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
269:
270: writeError(p_txnTmpID); --update the MMTT line to error for wip failures
271: if (l_logLevel <= wip_constants.trace_logging) then
272: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

Line 277: if(fnd_api.to_boolean(p_endDebug)) then

273: p_procReturnStatus => x_returnStatus,
274: p_msg => l_errMsg,
275: x_returnStatus => l_returnStatus); --discard logging return status
276: end if;
277: if(fnd_api.to_boolean(p_endDebug)) then
278: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
279: end if;
280: when others then
281: rollback to wipmtlpb_SP1;

Line 282: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

278: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
279: end if;
280: when others then
281: rollback to wipmtlpb_SP1;
282: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
283: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
284: p_procedure_name => 'processTemp',
285: p_error_text => SQLERRM);
286: writeError(p_txnTmpID);

Line 293: if(fnd_api.to_boolean(p_endDebug)) then

289: p_procReturnStatus => x_returnStatus,
290: p_msg => 'item' || l_issueRec.itemID || ' unexpected error: ' || SQLERRM,
291: x_returnStatus => l_returnStatus); --discard logging return status
292: end if;
293: if(fnd_api.to_boolean(p_endDebug)) then
294: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
295: end if;
296: end processTemp;
297:

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

388: l_params(l_paramCount + 2).paramValue := p_repSchedID;
389: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTxn',
390: p_params => l_params,
391: x_returnStatus => x_returnStatus);
392: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
393: raise fnd_api.g_exc_unexpected_error;
394: end if;
395: end if;
396:

Line 393: raise fnd_api.g_exc_unexpected_error;

389: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTxn',
390: p_params => l_params,
391: x_returnStatus => x_returnStatus);
392: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
393: raise fnd_api.g_exc_unexpected_error;
394: end if;
395: end if;
396:
397: if(p_repSchedID is null) then

Line 582: x_returnStatus := fnd_api.g_ret_sts_success;

578: wip_logger.log('inserted ' || SQL %ROWCOUNT, l_returnStatus);
579: end if;
580: end if;
581:
582: x_returnStatus := fnd_api.g_ret_sts_success;
583:
584: if (l_logLevel <= wip_constants.trace_logging) then
585: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
586: p_procReturnStatus => x_returnStatus,

Line 591: when fnd_api.g_exc_unexpected_error then

587: p_msg => 'procedure success',
588: x_returnStatus => l_returnStatus); --discard logging return status
589: end if;
590: exception
591: when fnd_api.g_exc_unexpected_error then
592: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
593: if (l_logLevel <= wip_constants.trace_logging) then
594: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
595: p_procReturnStatus => x_returnStatus,

Line 592: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

588: x_returnStatus => l_returnStatus); --discard logging return status
589: end if;
590: exception
591: when fnd_api.g_exc_unexpected_error then
592: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
593: if (l_logLevel <= wip_constants.trace_logging) then
594: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
595: p_procReturnStatus => x_returnStatus,
596: p_msg => l_errMsg,

Line 603: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

599: fnd_message.set_name('WIP', 'OPERATION_PROCESSING_ERROR');
600: fnd_msg_pub.add;
601: --need to add a message to the stack and count it
602: when wip_constants.records_locked then
603: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
604: if (l_logLevel <= wip_constants.trace_logging) then
605: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
606: p_procReturnStatus => x_returnStatus,
607: p_msg => 'records locked',

Line 613: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

609: end if;
610: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
611: fnd_msg_pub.add;
612: when others then
613: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
614: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
615: p_procedure_name => 'processTxn',
616: p_error_text => SQLERRM);
617: if (l_logLevel <= wip_constants.trace_logging) then

Line 644: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

640: begin
641: x_schedTbl := l_schedTbl ;
642: x_qtyTbl := l_qtyTbl ;
643: --return status is set to success at the last line of the procedure.
644: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
645:
646: if(p_issueRec.wipSupplyType = wip_constants.push) then
647: /* Fix for bug 5373061: Added date_released condition */
648: if(p_issueRec.txnActionID in (wip_constants.isscomp_action, wip_constants.issnegc_action)) then

Line 902: x_returnStatus := fnd_api.g_ret_sts_success;

898: order by wrs.first_unit_start_date desc;
899: end if;--issue/return stmt
900: end if; --MMTT/MMT stmt
901: end if; --supply type stmt
902: x_returnStatus := fnd_api.g_ret_sts_success;
903: --only errors that can occur are sql exceptions. let those fall through to the calling fn
904: end populateRepScheds;
905:
906: procedure processRepetitive(p_issueRec IN OUT NOCOPY wip_mtlTempProc_grp.comp_rec_t,

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

930: x_params => l_params);
931: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
932: p_params => l_params,
933: x_returnStatus => x_returnStatus);
934: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
935: raise fnd_api.g_exc_unexpected_error;
936: end if;
937: end if;
938:

Line 935: raise fnd_api.g_exc_unexpected_error;

931: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
932: p_params => l_params,
933: x_returnStatus => x_returnStatus);
934: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
935: raise fnd_api.g_exc_unexpected_error;
936: end if;
937: end if;
938:
939: if (l_logLevel <= wip_constants.full_logging) then

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

944: x_schedTbl => l_schedTbl,
945: x_qtyTbl => l_qtyTbl,
946: x_returnStatus => x_returnStatus);
947:
948: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
949: raise fnd_api.g_exc_unexpected_error;
950: end if;
951:
952: if(p_issueRec.mtlTxnID is null) then

Line 949: raise fnd_api.g_exc_unexpected_error;

945: x_qtyTbl => l_qtyTbl,
946: x_returnStatus => x_returnStatus);
947:
948: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
949: raise fnd_api.g_exc_unexpected_error;
950: end if;
951:
952: if(p_issueRec.mtlTxnID is null) then
953: update mtl_material_transactions_temp

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

1010: p_issueQty => l_issueQty, --override p_issueRec.primaryQty
1011: p_repSchedID => l_schedTbl(i),
1012: x_returnStatus => x_returnStatus);
1013:
1014: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1015: l_errMsg := 'processTxn for schedule ' || l_schedTbl(i) || ' failed.';
1016: raise fnd_api.g_exc_unexpected_error;
1017: end if;
1018: <>

Line 1016: raise fnd_api.g_exc_unexpected_error;

1012: x_returnStatus => x_returnStatus);
1013:
1014: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1015: l_errMsg := 'processTxn for schedule ' || l_schedTbl(i) || ' failed.';
1016: raise fnd_api.g_exc_unexpected_error;
1017: end if;
1018: <>
1019: null;
1020: end loop;

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

1064: processTxn(p_issueRec => p_issueRec,
1065: p_issueQty => l_issueQty,
1066: p_repSchedID => l_excessQtySchedID,
1067: x_returnStatus => x_returnStatus);
1068: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1069: l_errMsg := 'processTxn for the first schedule ' || l_excessQtySchedID || ' failed.';
1070: raise fnd_api.g_exc_unexpected_error;
1071: end if;
1072: end if;

Line 1070: raise fnd_api.g_exc_unexpected_error;

1066: p_repSchedID => l_excessQtySchedID,
1067: x_returnStatus => x_returnStatus);
1068: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1069: l_errMsg := 'processTxn for the first schedule ' || l_excessQtySchedID || ' failed.';
1070: raise fnd_api.g_exc_unexpected_error;
1071: end if;
1072: end if;
1073:
1074: if (l_logLevel <= wip_constants.full_logging) then

Line 1130: when fnd_api.g_exc_unexpected_error then

1126: p_msg => 'procedure success.',
1127: x_returnStatus => l_returnStatus); --discard logging return status
1128: end if;
1129: exception
1130: when fnd_api.g_exc_unexpected_error then
1131: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1132: if (l_logLevel <= wip_constants.trace_logging) then
1133: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1134: p_procReturnStatus => x_returnStatus,

Line 1131: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1127: x_returnStatus => l_returnStatus); --discard logging return status
1128: end if;
1129: exception
1130: when fnd_api.g_exc_unexpected_error then
1131: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1132: if (l_logLevel <= wip_constants.trace_logging) then
1133: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1134: p_procReturnStatus => x_returnStatus,
1135: p_msg => l_errMsg,

Line 1139: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1135: p_msg => l_errMsg,
1136: x_returnStatus => l_returnStatus); --discard logging return status
1137: end if;
1138: when others then
1139: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
1141: p_procedure_name => 'processRepetitive',
1142: p_error_text => SQLERRM);
1143: if (l_logLevel <= wip_constants.trace_logging) then

Line 1158: wip_utilities.get_message_stack(p_delete_stack => fnd_api.g_false,

1154: l_errExpl VARCHAR2(2000);
1155: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1156: l_returnStatus VARCHAR(1);
1157: begin
1158: wip_utilities.get_message_stack(p_delete_stack => fnd_api.g_false,
1159: p_msg => l_errExpl);
1160: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');
1161: l_errCode := fnd_message.get;
1162: if (l_logLevel <= wip_constants.full_logging) then

Line 1200: p_addMsgToStack => fnd_api.g_true, -- So that we can display to user

1196: SAVEPOINT s_oa_txn_proc;
1197: -- Validate and move records from MTI to MMTT.
1198: wip_mtlTempProc_priv.validateInterfaceTxns(
1199: p_txnHdrID => p_mtl_header_id,
1200: p_addMsgToStack => fnd_api.g_true, -- So that we can display to user
1201: p_rollbackOnErr => fnd_api.g_false,
1202: x_returnStatus => x_returnStatus);
1203:
1204: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 1201: p_rollbackOnErr => fnd_api.g_false,

1197: -- Validate and move records from MTI to MMTT.
1198: wip_mtlTempProc_priv.validateInterfaceTxns(
1199: p_txnHdrID => p_mtl_header_id,
1200: p_addMsgToStack => fnd_api.g_true, -- So that we can display to user
1201: p_rollbackOnErr => fnd_api.g_false,
1202: x_returnStatus => x_returnStatus);
1203:
1204: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1205: raise fnd_api.g_exc_unexpected_error;

Line 1204: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

1200: p_addMsgToStack => fnd_api.g_true, -- So that we can display to user
1201: p_rollbackOnErr => fnd_api.g_false,
1202: x_returnStatus => x_returnStatus);
1203:
1204: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1205: raise fnd_api.g_exc_unexpected_error;
1206: END IF;
1207:
1208: l_process_phase := '3';

Line 1205: raise fnd_api.g_exc_unexpected_error;

1201: p_rollbackOnErr => fnd_api.g_false,
1202: x_returnStatus => x_returnStatus);
1203:
1204: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1205: raise fnd_api.g_exc_unexpected_error;
1206: END IF;
1207:
1208: l_process_phase := '3';
1209: wip_mtlTempProc_priv.processTemp

Line 1210: (p_initMsgList => fnd_api.g_true,

1206: END IF;
1207:
1208: l_process_phase := '3';
1209: wip_mtlTempProc_priv.processTemp
1210: (p_initMsgList => fnd_api.g_true,
1211: p_txnHdrID => p_mtl_header_id,
1212: p_txnMode => WIP_CONSTANTS.ONLINE,
1213: x_returnStatus => x_returnStatus,
1214: x_errorMsg => l_error_msg);

Line 1216: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

1212: p_txnMode => WIP_CONSTANTS.ONLINE,
1213: x_returnStatus => x_returnStatus,
1214: x_errorMsg => l_error_msg);
1215:
1216: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1217: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1218: fnd_message.set_token('MESSAGE', l_error_msg);
1219: fnd_msg_pub.add;
1220: raise fnd_api.g_exc_unexpected_error;

Line 1220: raise fnd_api.g_exc_unexpected_error;

1216: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1217: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1218: fnd_message.set_token('MESSAGE', l_error_msg);
1219: fnd_msg_pub.add;
1220: raise fnd_api.g_exc_unexpected_error;
1221: END IF;
1222: l_process_phase := '4';
1223: x_returnStatus := fnd_api.g_ret_sts_success;
1224:

Line 1223: x_returnStatus := fnd_api.g_ret_sts_success;

1219: fnd_msg_pub.add;
1220: raise fnd_api.g_exc_unexpected_error;
1221: END IF;
1222: l_process_phase := '4';
1223: x_returnStatus := fnd_api.g_ret_sts_success;
1224:
1225: -- write to the log file
1226: IF (l_log_level <= wip_constants.trace_logging) THEN
1227: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',

Line 1235: WHEN fnd_api.g_exc_unexpected_error THEN

1231: END IF;
1232: -- close log file
1233: wip_logger.cleanUp(x_returnStatus => l_return_status);
1234: EXCEPTION
1235: WHEN fnd_api.g_exc_unexpected_error THEN
1236: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
1237: x_returnStatus := fnd_api.g_ret_sts_error;
1238:
1239: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 1237: x_returnStatus := fnd_api.g_ret_sts_error;

1233: wip_logger.cleanUp(x_returnStatus => l_return_status);
1234: EXCEPTION
1235: WHEN fnd_api.g_exc_unexpected_error THEN
1236: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
1237: x_returnStatus := fnd_api.g_ret_sts_error;
1238:
1239: IF (l_log_level <= wip_constants.trace_logging) THEN
1240: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',
1241: p_procReturnStatus => x_returnStatus,

Line 1250: x_returnStatus := fnd_api.g_ret_sts_error;

1246: -- close log file
1247: wip_logger.cleanUp(x_returnStatus => l_return_status);
1248: WHEN others THEN
1249: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
1250: x_returnStatus := fnd_api.g_ret_sts_error;
1251: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
1252: SQLCODE;
1253:
1254: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');