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

Line 57: x_returnStatus := fnd_api.g_ret_sts_success;

53: l_errNum NUMBER;
54: l_cstRetVal NUMBER;
55: begin
56: savepoint wipcplpb20;
57: x_returnStatus := fnd_api.g_ret_sts_success;
58: if(fnd_api.to_boolean(p_initMsgList)) then
59: fnd_msg_pub.initialize;
60: end if;
61:

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

54: l_cstRetVal NUMBER;
55: begin
56: savepoint wipcplpb20;
57: x_returnStatus := fnd_api.g_ret_sts_success;
58: if(fnd_api.to_boolean(p_initMsgList)) then
59: fnd_msg_pub.initialize;
60: end if;
61:
62: if (l_logLevel <= wip_constants.trace_logging) then

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

65: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.processTemp',
66: p_params => l_params,
67: x_returnStatus => x_returnStatus);
68:
69: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
70: raise fnd_api.g_exc_unexpected_error;
71: end if;
72: end if;
73:

Line 70: raise fnd_api.g_exc_unexpected_error;

66: p_params => l_params,
67: x_returnStatus => x_returnStatus);
68:
69: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
70: raise fnd_api.g_exc_unexpected_error;
71: end if;
72: end if;
73:
74: select wip_entity_type,

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

128: p_collection_id => l_cplRec.qaCollectionID,
129: p_return_status => l_returnStatus,
130: p_msg_count => l_msgCount,
131: p_msg_data => l_errMsg);
132: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
133: l_errMsg := 'QA error: ' || l_errMsg;
134: raise fnd_api.g_exc_unexpected_error;
135: end if;
136: end if;

Line 134: raise fnd_api.g_exc_unexpected_error;

130: p_msg_count => l_msgCount,
131: p_msg_data => l_errMsg);
132: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
133: l_errMsg := 'QA error: ' || l_errMsg;
134: raise fnd_api.g_exc_unexpected_error;
135: end if;
136: end if;
137:
138: if(nvl(l_cplRec.overCplPriQty, 0) <> 0) then

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

150: processOverCpl(p_cplRec => l_cplRec,
151: x_returnStatus => x_returnStatus);
152: end if;
153:
154: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
155: l_errMsg := 'overcompletion processing errored';
156: raise fnd_api.g_exc_unexpected_error;
157: end if;
158: end if;

Line 156: raise fnd_api.g_exc_unexpected_error;

152: end if;
153:
154: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
155: l_errMsg := 'overcompletion processing errored';
156: raise fnd_api.g_exc_unexpected_error;
157: end if;
158: end if;
159:
160: if(l_cplRec.wipEntityType = wip_constants.repetitive) then

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

168: x_serialStartOp => l_serialStartOp,
169: x_returnStatus => x_returnStatus);
170:
171: end if;
172: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
173: l_errMsg := 'entity specific processing failed';
174: raise fnd_api.g_exc_unexpected_error;
175: end if;
176:

Line 174: raise fnd_api.g_exc_unexpected_error;

170:
171: end if;
172: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
173: l_errMsg := 'entity specific processing failed';
174: raise fnd_api.g_exc_unexpected_error;
175: end if;
176:
177: /* Fix for bug 5708242: Moved the call to cstpacms.validate_move_snap_to_temp() from
178: wipmtivb.pls to this place, to avoid intermittent commits, and to facilitate proper

Line 198: raise fnd_api.g_exc_unexpected_error;

194: l_retValue,
195: l_errMsg);
196: if(l_cstRetVal <> 1) then
197: /* Error message will be populated by the procedure. Just raise exception. */
198: raise fnd_api.g_exc_unexpected_error;
199: end if;
200: end if;
201:
202: if(l_logLevel <= wip_constants.trace_logging) then

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

204: p_procReturnStatus => x_returnStatus,
205: p_msg => 'procedure success.',
206: x_returnStatus => l_returnStatus); --discard logging return status
207: end if;
208: if(fnd_api.to_boolean(p_endDebug)) then
209: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
210: end if;
211: exception
212: when no_data_found then

Line 214: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

210: end if;
211: exception
212: when no_data_found then
213: rollback to wipcplpb20;
214: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
215: if (l_logLevel <= wip_constants.trace_logging) then
216: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',
217: p_procReturnStatus => x_returnStatus,
218: p_msg => 'no data found',

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

217: p_procReturnStatus => x_returnStatus,
218: p_msg => 'no data found',
219: x_returnStatus => l_returnStatus); --discard logging return status
220: end if;
221: if(fnd_api.to_boolean(p_endDebug)) then
222: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
223: end if;
224: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');
225: fnd_msg_pub.add;

Line 229: when fnd_api.g_exc_error then --could not derive all lot/serial info for components

225: fnd_msg_pub.add;
226: if (l_logLevel <= wip_constants.full_logging) then
227: wip_logger.log(SQLERRM, l_returnStatus);
228: end if;
229: when fnd_api.g_exc_error then --could not derive all lot/serial info for components
230: --do *not* rollback. leave the component records in mmtt/mtlt for the caller to query/complete
231: --when the record is processed again, only the material processing and inv txn will occur
232: if (l_logLevel <= wip_constants.trace_logging) then
233: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',

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

234: p_procReturnStatus => x_returnStatus,
235: p_msg => 'need to collect l/s info',
236: x_returnStatus => l_returnStatus); --discard logging return status
237: end if;
238: if(fnd_api.to_boolean(p_endDebug)) then
239: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
240: end if;
241: when fnd_api.g_exc_unexpected_error then
242: rollback to wipcplpb20;

Line 241: when fnd_api.g_exc_unexpected_error then

237: end if;
238: if(fnd_api.to_boolean(p_endDebug)) then
239: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
240: end if;
241: when fnd_api.g_exc_unexpected_error then
242: rollback to wipcplpb20;
243: if (l_logLevel <= wip_constants.trace_logging) then
244: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',
245: p_procReturnStatus => x_returnStatus,

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

245: p_procReturnStatus => x_returnStatus,
246: p_msg => l_errMsg,
247: x_returnStatus => l_returnStatus); --discard logging return status
248: end if;
249: if(fnd_api.to_boolean(p_endDebug)) then
250: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
251: end if;
252: when others then
253: rollback to wipcplpb20;

Line 254: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

250: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
251: end if;
252: when others then
253: rollback to wipcplpb20;
254: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
256: p_procedure_name => 'processTemp',
257: p_error_text => SQLERRM);
258: if (l_logLevel <= wip_constants.trace_logging) then

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

260: p_procReturnStatus => x_returnStatus,
261: p_msg => 'unexpected error: ' || SQLERRM,
262: x_returnStatus => l_returnStatus); --discard logging return status
263: end if;
264: if(fnd_api.to_boolean(p_endDebug)) then
265: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
266: end if;
267: end processTemp;
268:

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

301:
302: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
303: p_params => l_params,
304: x_returnStatus => x_returnStatus);
305: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
306: raise fnd_api.g_exc_unexpected_error;
307: end if;
308: end if;
309:

Line 306: raise fnd_api.g_exc_unexpected_error;

302: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
303: p_params => l_params,
304: x_returnStatus => x_returnStatus);
305: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
306: raise fnd_api.g_exc_unexpected_error;
307: end if;
308: end if;
309:
310: -- Fix bug 13826369

Line 354: x_returnStatus := fnd_api.g_ret_sts_success;

350: l_cplDate := nvl(l_cplDate, p_cplRec.txnDate); --Bug 4864403 Only change date_completed if it is null
351: end if;
352: --allocate completions to sales orders
353: l_errMsg := 'SO allocation failed.'; --set message in case it fails
354: x_returnStatus := fnd_api.g_ret_sts_success;
355: if(p_cplRec.lpnID is null) then
356: wip_so_reservations.allocate_completion_to_so(
357: p_organization_id => p_cplRec.orgID,
358: p_wip_entity_id => p_cplRec.wipEntityID,

Line 368: if(x_returnStatus = fnd_api.g_ret_sts_success and

364: x_msg_data => l_errMsg);
365: end if;
366:
367: --if so allocation went ok, then update the kanban card if it exists
368: if(x_returnStatus = fnd_api.g_ret_sts_success and
369: p_cplRec.kanbanCardID is not null) then
370: l_errMsg := 'Kanban update failed.'; --set message in case it fails
371: if(p_cplRec.wipEntityType = wip_constants.lotbased) then
372: l_docType := 8;

Line 401: raise fnd_api.g_exc_unexpected_error;

397: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);
398: fnd_message.set_token('ENTITY2', 'job complete quantity', true);
399: fnd_msg_pub.add;
400: l_errMsg := 'not enough quantity to return';
401: raise fnd_api.g_exc_unexpected_error;
402: end if;
403: --return the so reservation to wip
404: l_errMsg := 'SO return reservation failed'; --set message in case SO return failed
405: wip_so_reservations.return_reservation_to_wip(

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

412: x_msg_count => l_msgCount,
413: x_msg_data => l_errMsg);
414: end if;
415: --if any of the above failed, make sure the error status is unexpected error and fail
416: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
417: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
418: raise fnd_api.g_exc_unexpected_error;
419: end if;
420:

Line 417: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

413: x_msg_data => l_errMsg);
414: end if;
415: --if any of the above failed, make sure the error status is unexpected error and fail
416: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
417: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
418: raise fnd_api.g_exc_unexpected_error;
419: end if;
420:
421: update wip_discrete_jobs --increase the qty completed

Line 418: raise fnd_api.g_exc_unexpected_error;

414: end if;
415: --if any of the above failed, make sure the error status is unexpected error and fail
416: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
417: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
418: raise fnd_api.g_exc_unexpected_error;
419: end if;
420:
421: update wip_discrete_jobs --increase the qty completed
422: set quantity_completed = l_qtyCompleted + p_cplRec.priQty, --remember txn qty is negative for returns

Line 446: raise fnd_api.g_exc_unexpected_error;

442: if(l_toMoveQty - p_cplRec.priQty < 0) then
443: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
444: fnd_msg_pub.add;
445: l_errMsg := 'not enough qty in to move of last op';
446: raise fnd_api.g_exc_unexpected_error;
447: end if;
448: update wip_operations --lower the quantity available to complete
449: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
450: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),

Line 470: raise fnd_api.g_exc_unexpected_error;

466: if p_cplRec.priQty - abs(l_qtyAvailToComplete) - oc_primary_qty > 0 then
467: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
468: fnd_msg_pub.add;
469: l_errMsg := 'Quantity required to complete this transaction no longer available';
470: raise fnd_api.g_exc_unexpected_error;
471:
472: end if;
473: -- end of BUG 4869979 (FP 5107900)
474:

Line 484: when fnd_api.g_exc_unexpected_error then

480: p_msg => 'procedure success.',
481: x_returnStatus => l_returnStatus); --discard logging return status
482: end if;
483: exception
484: when fnd_api.g_exc_unexpected_error then
485: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
486: if (l_logLevel <= wip_constants.trace_logging) then
487: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
488: p_procReturnStatus => x_returnStatus,

Line 485: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

481: x_returnStatus => l_returnStatus); --discard logging return status
482: end if;
483: exception
484: when fnd_api.g_exc_unexpected_error then
485: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
486: if (l_logLevel <= wip_constants.trace_logging) then
487: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
488: p_procReturnStatus => x_returnStatus,
489: p_msg => l_errMsg,

Line 493: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

489: p_msg => l_errMsg,
490: x_returnStatus => l_returnStatus); --discard logging return status
491: end if;
492: when wip_constants.records_locked then
493: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
494: if (l_logLevel <= wip_constants.trace_logging) then
495: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
496: p_procReturnStatus => x_returnStatus,
497: p_msg => 'records were locked',

Line 505: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

501: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
502: fnd_message.set_token('JOBNAME', l_job_name);
503: fnd_msg_pub.add;
504: when others then
505: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
507: p_procedure_name => 'processDiscrete',
508: p_error_text => SQLERRM);
509: if (l_logLevel <= wip_constants.trace_logging) then

Line 577: x_returnStatus := fnd_api.g_ret_sts_success;

573: l_newSchedQty NUMBER;
574: l_cplStatus NUMBER;
575: l_rollFwdSuccess NUMBER;
576: begin
577: x_returnStatus := fnd_api.g_ret_sts_success;
578: if (l_logLevel <= wip_constants.trace_logging) then
579: fillCplParamTbl(p_cplRec => p_cplRec,
580: x_params => l_params);
581: l_paramCount := l_params.count;

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

585: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.processRepetitive',
586: p_params => l_params,
587: x_returnStatus => x_returnStatus);
588:
589: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
590: raise fnd_api.g_exc_unexpected_error;
591: end if;
592: end if;
593:

Line 590: raise fnd_api.g_exc_unexpected_error;

586: p_params => l_params,
587: x_returnStatus => x_returnStatus);
588:
589: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
590: raise fnd_api.g_exc_unexpected_error;
591: end if;
592: end if;
593:
594:

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

602: p_document_detail_id => null,
603: p_replenish_quantity => p_cplRec.priQty,
604: x_return_status => x_returnStatus);
605:
606: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
607: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
608: l_errMsg := 'Kanban update failed.'; --set message in case it fails
609: raise fnd_api.g_exc_unexpected_error;
610: end if;

Line 607: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

603: p_replenish_quantity => p_cplRec.priQty,
604: x_return_status => x_returnStatus);
605:
606: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
607: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
608: l_errMsg := 'Kanban update failed.'; --set message in case it fails
609: raise fnd_api.g_exc_unexpected_error;
610: end if;
611: end if;

Line 609: raise fnd_api.g_exc_unexpected_error;

605:
606: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
607: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
608: l_errMsg := 'Kanban update failed.'; --set message in case it fails
609: raise fnd_api.g_exc_unexpected_error;
610: end if;
611: end if;
612:
613: if(p_cplRec.lastOpSeq is null or p_cplRec.lastOpSeq < 0) then

Line 654: raise fnd_api.g_exc_unexpected_error;

650: --add check for pending txns here
651: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
652: fnd_msg_pub.add;
653: l_errMsg := 'not enough qty in to move of last op';
654: raise fnd_api.g_exc_unexpected_error;
655: end if;
656: end if;
657: if (l_logLevel <= wip_constants.full_logging) then
658: wip_logger.log('schedID' || l_schedRecTbl.schedID(i), l_returnStatus);

Line 693: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

689: p_success_flag => l_rollFwdSuccess,
690: p_error_msg => l_errMsg);
691: if(l_rollFwdSuccess <> wip_constants.yes) then
692: -- fnd_msg_pub.add; --assume error message is still current
693: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
694: l_errMsg := 'roll forward failed for schedule ' || l_schedRec.repSchedID;
695: end if;
696: end if;
697: end loop;

Line 747: when fnd_api.g_exc_unexpected_error then

743: x_returnStatus => l_returnStatus); --discard logging return status
744: end if;
745:
746: exception
747: when fnd_api.g_exc_unexpected_error then
748: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
749: if (l_logLevel <= wip_constants.trace_logging) then
750: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processRepetitive',
751: p_procReturnStatus => x_returnStatus,

Line 748: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

744: end if;
745:
746: exception
747: when fnd_api.g_exc_unexpected_error then
748: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
749: if (l_logLevel <= wip_constants.trace_logging) then
750: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processRepetitive',
751: p_procReturnStatus => x_returnStatus,
752: p_msg => l_errMsg,

Line 756: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

752: p_msg => l_errMsg,
753: x_returnStatus => l_returnStatus); --discard logging return status
754: end if;
755: when others then
756: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
757: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
758: p_procedure_name => 'processRepetitive',
759: p_error_text => SQLERRM);
760: if (l_logLevel <= wip_constants.trace_logging) then

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

804: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.processOverCpl',
805: p_params => l_params,
806: x_returnStatus => x_returnStatus);
807:
808: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
809: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
810: raise fnd_api.g_exc_unexpected_error;
811: end if;
812: end if;

Line 809: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

805: p_params => l_params,
806: x_returnStatus => x_returnStatus);
807:
808: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
809: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
810: raise fnd_api.g_exc_unexpected_error;
811: end if;
812: end if;
813:

Line 810: raise fnd_api.g_exc_unexpected_error;

806: x_returnStatus => x_returnStatus);
807:
808: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
809: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
810: raise fnd_api.g_exc_unexpected_error;
811: end if;
812: end if;
813:
814: if(p_cplRec.wipEntityType = wip_constants.repetitive) then

Line 823: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

819: x_last_sched_id => l_lastSchedID,
820: x_error_mesg => l_errMsg);
821: if(l_errMsg <> null) then
822: fnd_msg_pub.add; --assume prev fn used the fnd_message pkg
823: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
824: l_errMsg := 'wip_repetitive_utilities.get_first_last_sched: ' || l_errMsg;
825: raise fnd_api.g_exc_unexpected_error;
826: end if;
827: end if;

Line 825: raise fnd_api.g_exc_unexpected_error;

821: if(l_errMsg <> null) then
822: fnd_msg_pub.add; --assume prev fn used the fnd_message pkg
823: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
824: l_errMsg := 'wip_repetitive_utilities.get_first_last_sched: ' || l_errMsg;
825: raise fnd_api.g_exc_unexpected_error;
826: end if;
827: end if;
828:
829: wip_overcompletion.check_tolerance(p_organization_id => p_cplRec.orgID,

Line 837: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

833: p_result => x_returnStatus);
834:
835:
836: if(x_returnStatus = wip_constants.no) then
837: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
838: fnd_message.set_name('WIP', 'WIP_OC_TOLERANCE_FAIL');
839: fnd_msg_pub.add;
840: l_errMsg := 'cpl exceeded tolerances';
841: raise fnd_api.g_exc_unexpected_error;

Line 841: raise fnd_api.g_exc_unexpected_error;

837: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
838: fnd_message.set_name('WIP', 'WIP_OC_TOLERANCE_FAIL');
839: fnd_msg_pub.add;
840: l_errMsg := 'cpl exceeded tolerances';
841: raise fnd_api.g_exc_unexpected_error;
842: else
843: x_returnStatus := fnd_api.g_ret_sts_success;
844: end if;
845:

Line 843: x_returnStatus := fnd_api.g_ret_sts_success;

839: fnd_msg_pub.add;
840: l_errMsg := 'cpl exceeded tolerances';
841: raise fnd_api.g_exc_unexpected_error;
842: else
843: x_returnStatus := fnd_api.g_ret_sts_success;
844: end if;
845:
846:
847: --if a routing exists, insert a move record and perform the move

Line 866: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

862: p_err_mesg => l_errMsg);
863:
864: --if insert failed
865: if(l_errMsg is not null) then
866: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
867: fnd_msg_pub.add;
868: l_errMsg := 'wip_overcompletion.insert_oc_move_txn: ' || l_errMsg;
869: raise fnd_api.g_exc_unexpected_error;
870: end if;

Line 869: raise fnd_api.g_exc_unexpected_error;

865: if(l_errMsg is not null) then
866: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
867: fnd_msg_pub.add;
868: l_errMsg := 'wip_overcompletion.insert_oc_move_txn: ' || l_errMsg;
869: raise fnd_api.g_exc_unexpected_error;
870: end if;
871:
872: --we must process material requirements in background mode so any assy pull components in MMTT
873: --do not get processed. Assy pull components must remain through the discrete job processing so

Line 884: p_endDebug => fnd_api.g_false,

880: p_time_out => 0,
881: p_move_mode => wip_constants.online,
882: p_bf_mode => wip_constants.online, --ignored
883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all
884: p_endDebug => fnd_api.g_false,
885: p_initMsgList => fnd_api.g_false,
886: p_insertAssy => fnd_api.g_true,
887: p_do_backflush => fnd_api.g_false,--backflush was already done
888: p_cmp_txn_id => null,

Line 885: p_initMsgList => fnd_api.g_false,

881: p_move_mode => wip_constants.online,
882: p_bf_mode => wip_constants.online, --ignored
883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all
884: p_endDebug => fnd_api.g_false,
885: p_initMsgList => fnd_api.g_false,
886: p_insertAssy => fnd_api.g_true,
887: p_do_backflush => fnd_api.g_false,--backflush was already done
888: p_cmp_txn_id => null,
889: x_returnStatus => x_returnStatus);

Line 886: p_insertAssy => fnd_api.g_true,

882: p_bf_mode => wip_constants.online, --ignored
883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all
884: p_endDebug => fnd_api.g_false,
885: p_initMsgList => fnd_api.g_false,
886: p_insertAssy => fnd_api.g_true,
887: p_do_backflush => fnd_api.g_false,--backflush was already done
888: p_cmp_txn_id => null,
889: x_returnStatus => x_returnStatus);
890:

Line 887: p_do_backflush => fnd_api.g_false,--backflush was already done

883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all
884: p_endDebug => fnd_api.g_false,
885: p_initMsgList => fnd_api.g_false,
886: p_insertAssy => fnd_api.g_true,
887: p_do_backflush => fnd_api.g_false,--backflush was already done
888: p_cmp_txn_id => null,
889: x_returnStatus => x_returnStatus);
890:
891: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

887: p_do_backflush => fnd_api.g_false,--backflush was already done
888: p_cmp_txn_id => null,
889: x_returnStatus => x_returnStatus);
890:
891: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
892: --depend on move to set the message
893: raise fnd_api.g_exc_unexpected_error;
894: end if;
895: --otherwise we just have to increase the component requirements in wro

Line 893: raise fnd_api.g_exc_unexpected_error;

889: x_returnStatus => x_returnStatus);
890:
891: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
892: --depend on move to set the message
893: raise fnd_api.g_exc_unexpected_error;
894: end if;
895: --otherwise we just have to increase the component requirements in wro
896: else
897: if(p_cplRec.wipEntityType = wip_constants.repetitive) then

Line 920: when fnd_api.g_exc_unexpected_error then

916: p_msg => 'procedure success.',
917: x_returnStatus => l_returnStatus); --discard logging return status
918: end if;
919: exception
920: when fnd_api.g_exc_unexpected_error then
921: if (l_logLevel <= wip_constants.trace_logging) then
922: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOverCpl',
923: p_procReturnStatus => x_returnStatus,
924: p_msg => l_errMsg,

Line 928: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

924: p_msg => l_errMsg,
925: x_returnStatus => l_returnStatus); --discard logging return status
926: end if;
927: when others then
928: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
929: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
930: p_procedure_name => 'processOverCpl',
931: p_error_text => SQLERRM);
932: if (l_logLevel <= wip_constants.trace_logging) then

Line 1054: x_returnStatus := fnd_api.g_ret_sts_success;

1050: l_txnRecTbl txn_alloc_recTbl_t;
1051: l_schedRecTbl schedule_recTbl_t;
1052: l_startQty NUMBER;
1053: begin
1054: x_returnStatus := fnd_api.g_ret_sts_success;
1055:
1056: savepoint wipcplpb40;
1057:
1058: if (l_logLevel <= wip_constants.trace_logging) then

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

1072: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1073: p_params => l_params,
1074: x_returnStatus => x_returnStatus);
1075:
1076: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1077: raise fnd_api.g_exc_unexpected_error;
1078: end if;
1079: end if;
1080:

Line 1077: raise fnd_api.g_exc_unexpected_error;

1073: p_params => l_params,
1074: x_returnStatus => x_returnStatus);
1075:
1076: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1077: raise fnd_api.g_exc_unexpected_error;
1078: end if;
1079: end if;
1080:
1081: if(p_tblName = wip_constants.MTI_TBL) then

Line 1203: raise fnd_api.g_exc_unexpected_error;

1199: (l_schedRecTbl.bomRev(j) is not null or l_txnRecTbl.revision(i) is not null)) then
1200: fnd_message.set_name('WIP', 'WIP_SCHED_MULTIPLE_BILL_REV');
1201: fnd_msg_pub.add;
1202: l_errMsg := 'Schedules have different bill revisions.'; --set message in case it fails
1203: raise fnd_api.g_exc_unexpected_error;
1204: end if;
1205:
1206: --complete the lesser of the open quantity and the remaining transaction qty
1207:

Line 1260: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules

1256: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1257: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1258: fnd_msg_pub.add;
1259: l_errMsg := 'did not find any schedules.';
1260: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1261: end if;
1262:
1263: if (l_logLevel <= wip_constants.full_logging) then
1264: wip_logger.log('txnID' || l_txnRecTbl.txnID(i), l_returnStatus);

Line 1291: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules

1287: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1288: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1289: fnd_msg_pub.add;
1290: l_errMsg := 'did not find any schedules.';
1291: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1292: end if;
1293: end if; /*Fix for Bug#6018877 - FP of bug#6004763*/
1294:
1295: if (l_logLevel <= wip_constants.full_logging) then

Line 1348: when fnd_api.g_exc_unexpected_error then

1344: p_msg => 'procedure success.',
1345: x_returnStatus => l_returnStatus); --discard logging return status
1346: end if;
1347: exception
1348: when fnd_api.g_exc_unexpected_error then
1349: rollback to wipcplpb40;
1350: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1351: if (l_logLevel <= wip_constants.trace_logging) then
1352: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',

Line 1350: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1346: end if;
1347: exception
1348: when fnd_api.g_exc_unexpected_error then
1349: rollback to wipcplpb40;
1350: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1351: if (l_logLevel <= wip_constants.trace_logging) then
1352: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1353: p_procReturnStatus => x_returnStatus,
1354: p_msg => l_errMsg,

Line 1358: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1354: p_msg => l_errMsg,
1355: x_returnStatus => l_returnStatus); --discard logging return status
1356: end if;
1357: when others then
1358: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1359: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1360: p_procedure_name => 'preAllocateSchedules',
1361: p_error_text => SQLERRM);
1362: if (l_logLevel <= wip_constants.trace_logging) then

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

1416: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.preAllocateRets',
1417: p_params => l_params,
1418: x_returnStatus => x_returnStatus);
1419:
1420: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1421: raise fnd_api.g_exc_unexpected_error;
1422: end if;
1423: end if;
1424:

Line 1421: raise fnd_api.g_exc_unexpected_error;

1417: p_params => l_params,
1418: x_returnStatus => x_returnStatus);
1419:
1420: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1421: raise fnd_api.g_exc_unexpected_error;
1422: end if;
1423: end if;
1424:
1425: for l_schedRec in c_openScheds loop

Line 1523: x_returnStatus := fnd_api.g_ret_sts_success;

1519: if (l_logLevel <= wip_constants.full_logging) then
1520: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows', l_returnStatus);
1521: end if;
1522:
1523: x_returnStatus := fnd_api.g_ret_sts_success;
1524:
1525: if (l_logLevel <= wip_constants.trace_logging) then
1526: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateRets',
1527: p_procReturnStatus => x_returnStatus,

Line 1534: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1530: end if;
1531:
1532: exception
1533: when others then
1534: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1535: if (l_logLevel <= wip_constants.trace_logging) then
1536: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateRets',
1537: p_procReturnStatus => x_returnStatus,
1538: p_msg => 'unexpected error: ' || SQLERRM,

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

1563: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1564: p_params => l_params,
1565: x_returnStatus => x_returnStatus);
1566:
1567: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1568: raise fnd_api.g_exc_unexpected_error;
1569: end if;
1570: end if;
1571:

Line 1568: raise fnd_api.g_exc_unexpected_error;

1564: p_params => l_params,
1565: x_returnStatus => x_returnStatus);
1566:
1567: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1568: raise fnd_api.g_exc_unexpected_error;
1569: end if;
1570: end if;
1571:
1572: if(p_txnActionID = wip_constants.cplassy_action) then

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

1584: p_tblName => p_tblName,
1585: x_returnStatus => x_returnStatus);
1586: end if;
1587:
1588: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1589: raise fnd_api.g_exc_unexpected_error;
1590: end if;
1591:
1592: if (l_logLevel <= wip_constants.trace_logging) then

Line 1589: raise fnd_api.g_exc_unexpected_error;

1585: x_returnStatus => x_returnStatus);
1586: end if;
1587:
1588: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1589: raise fnd_api.g_exc_unexpected_error;
1590: end if;
1591:
1592: if (l_logLevel <= wip_constants.trace_logging) then
1593: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',

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

1593: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1594: p_procReturnStatus => x_returnStatus,
1595: p_msg => 'procedure success.',
1596: x_returnStatus => l_returnStatus); --discard logging return status
1597: if(fnd_api.to_boolean(p_endDebug)) then
1598: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
1599: end if;
1600: end if;
1601:

Line 1603: when fnd_api.g_exc_unexpected_error then

1599: end if;
1600: end if;
1601:
1602: exception
1603: when fnd_api.g_exc_unexpected_error then
1604: rollback to wipcplpb40;
1605: if (l_logLevel <= wip_constants.trace_logging) then
1606: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1607: p_procReturnStatus => x_returnStatus,

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

1606: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1607: p_procReturnStatus => x_returnStatus,
1608: p_msg => l_errMsg,
1609: x_returnStatus => l_returnStatus); --discard logging return status
1610: if(fnd_api.to_boolean(p_endDebug)) then
1611: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
1612: end if;
1613: end if;
1614: when others then

Line 1616: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1612: end if;
1613: end if;
1614: when others then
1615: rollback to wipcplpb40;
1616: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1617: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1618: p_procedure_name => 'preAllocateSchedules',
1619: p_error_text => SQLERRM);
1620: if (l_logLevel <= wip_constants.trace_logging) then

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

1621: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1622: p_procReturnStatus => x_returnStatus,
1623: p_msg => 'unexpected error: ' || SQLERRM,
1624: x_returnStatus => l_returnStatus); --discard logging return status
1625: if(fnd_api.to_boolean(p_endDebug)) then
1626: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
1627: end if;
1628: end if;
1629: end preAllocateSchedules;

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

1850:
1851: -- Validate and move records from MTI to MMTT.
1852: wip_mtlTempProc_priv.validateInterfaceTxns(
1853: p_txnHdrID => p_mtl_header_id,
1854: p_addMsgToStack => fnd_api.g_true, -- So that we can display to user
1855: p_rollbackOnErr => fnd_api.g_false,
1856: x_returnStatus => x_returnStatus);
1857:
1858: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 1855: p_rollbackOnErr => fnd_api.g_false,

1851: -- Validate and move records from MTI to MMTT.
1852: wip_mtlTempProc_priv.validateInterfaceTxns(
1853: p_txnHdrID => p_mtl_header_id,
1854: p_addMsgToStack => fnd_api.g_true, -- So that we can display to user
1855: p_rollbackOnErr => fnd_api.g_false,
1856: x_returnStatus => x_returnStatus);
1857:
1858: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1859: raise fnd_api.g_exc_unexpected_error;

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

1854: p_addMsgToStack => fnd_api.g_true, -- So that we can display to user
1855: p_rollbackOnErr => fnd_api.g_false,
1856: x_returnStatus => x_returnStatus);
1857:
1858: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1859: raise fnd_api.g_exc_unexpected_error;
1860: END IF;
1861:
1862: l_process_phase := '3';

Line 1859: raise fnd_api.g_exc_unexpected_error;

1855: p_rollbackOnErr => fnd_api.g_false,
1856: x_returnStatus => x_returnStatus);
1857:
1858: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1859: raise fnd_api.g_exc_unexpected_error;
1860: END IF;
1861:
1862: l_process_phase := '3';
1863: SELECT primary_cost_method

Line 1880: raise fnd_api.g_exc_unexpected_error;

1876: IF(l_ret_value <> 1) THEN
1877: fnd_message.set_name(application => 'CST',
1878: name => 'CST_SNAPSHOT_FAILED');
1879: fnd_msg_pub.add;
1880: raise fnd_api.g_exc_unexpected_error;
1881: END IF;
1882: END IF;
1883:
1884: l_process_phase := '5';

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

1890: p_msg_data => l_error_msg,
1891: p_label_status => l_label_status,
1892: p_business_flow_code => 26); -- discrete business flow code
1893: -- do not error out if label printing, only put warning message in log
1894: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1895: wip_utilities.get_message_stack(p_msg => l_msg_stack);
1896: IF (l_log_level <= wip_constants.full_logging) then
1897: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
1898: 'The following error has occurred during ' ||

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

1939:
1940: wip_cplProc_priv.processOverCpl(p_cplRec => l_oc_rec,
1941: x_returnStatus => x_returnStatus);
1942:
1943: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1944: RAISE fnd_api.g_exc_unexpected_error;
1945: END IF;
1946: END IF; -- Overcompletion
1947:

Line 1944: RAISE fnd_api.g_exc_unexpected_error;

1940: wip_cplProc_priv.processOverCpl(p_cplRec => l_oc_rec,
1941: x_returnStatus => x_returnStatus);
1942:
1943: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1944: RAISE fnd_api.g_exc_unexpected_error;
1945: END IF;
1946: END IF; -- Overcompletion
1947:
1948: l_process_phase := '7';

Line 1950: (p_initMsgList => fnd_api.g_true,

1946: END IF; -- Overcompletion
1947:
1948: l_process_phase := '7';
1949: wip_mtlTempProc_priv.processTemp
1950: (p_initMsgList => fnd_api.g_true,
1951: p_txnHdrID => p_mtl_header_id,
1952: p_txnMode => WIP_CONSTANTS.ONLINE,
1953: x_returnStatus => x_returnStatus,
1954: x_errorMsg => l_error_msg);

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

1952: p_txnMode => WIP_CONSTANTS.ONLINE,
1953: x_returnStatus => x_returnStatus,
1954: x_errorMsg => l_error_msg);
1955:
1956: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1957: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1958: fnd_message.set_token('MESSAGE', l_error_msg);
1959: fnd_msg_pub.add;
1960: raise fnd_api.g_exc_unexpected_error;

Line 1960: raise fnd_api.g_exc_unexpected_error;

1956: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1957: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1958: fnd_message.set_token('MESSAGE', l_error_msg);
1959: fnd_msg_pub.add;
1960: raise fnd_api.g_exc_unexpected_error;
1961: END IF;
1962:
1963: l_process_phase := '8';
1964: -- Update to MSN must take place after inventory processing as they always

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

1984: p_operation_seq_num => l_op_seq,
1985: p_intraoperation_step_type => l_step,
1986: x_return_status => x_returnStatus);
1987:
1988: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1989: RAISE fnd_api.g_exc_unexpected_error;
1990: END IF;
1991: END IF; -- Serialized transaction
1992:

Line 1989: RAISE fnd_api.g_exc_unexpected_error;

1985: p_intraoperation_step_type => l_step,
1986: x_return_status => x_returnStatus);
1987:
1988: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1989: RAISE fnd_api.g_exc_unexpected_error;
1990: END IF;
1991: END IF; -- Serialized transaction
1992:
1993: l_process_phase := '9';

Line 1998: x_returnStatus := fnd_api.g_ret_sts_success;

1994: IF(c_cmp_txn%ISOPEN) THEN
1995: CLOSE c_cmp_txn;
1996: END IF;
1997:
1998: x_returnStatus := fnd_api.g_ret_sts_success;
1999: -- write to the log file
2000: IF (l_log_level <= wip_constants.trace_logging) THEN
2001: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
2002: p_procReturnStatus => x_returnStatus,

Line 2010: WHEN fnd_api.g_exc_unexpected_error THEN

2006: -- close log file
2007: wip_logger.cleanUp(x_returnStatus => l_return_status);
2008:
2009: EXCEPTION
2010: WHEN fnd_api.g_exc_unexpected_error THEN
2011: IF(c_cmp_txn%ISOPEN) THEN
2012: CLOSE c_cmp_txn;
2013: END IF;
2014: ROLLBACK TO SAVEPOINT s_oa_txn_proc;

Line 2015: x_returnStatus := fnd_api.g_ret_sts_error;

2011: IF(c_cmp_txn%ISOPEN) THEN
2012: CLOSE c_cmp_txn;
2013: END IF;
2014: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
2015: x_returnStatus := fnd_api.g_ret_sts_error;
2016:
2017: IF (l_log_level <= wip_constants.trace_logging) THEN
2018: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
2019: p_procReturnStatus => x_returnStatus,

Line 2031: x_returnStatus := fnd_api.g_ret_sts_error;

2027: IF(c_cmp_txn%ISOPEN) THEN
2028: CLOSE c_cmp_txn;
2029: END IF;
2030: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
2031: x_returnStatus := fnd_api.g_ret_sts_error;
2032: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
2033: SQLCODE;
2034:
2035: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');