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

Line 110: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

106: l_params(1).paramValue := p_txnHeaderID;
107: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',
108: p_params => l_params,
109: x_returnStatus => l_returnStatus);
110: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
111: raise fnd_api.g_exc_unexpected_error;
112: end if;
113: end if;
114:

Line 111: raise fnd_api.g_exc_unexpected_error;

107: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',
108: p_params => l_params,
109: x_returnStatus => l_returnStatus);
110: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
111: raise fnd_api.g_exc_unexpected_error;
112: end if;
113: end if;
114:
115: for flow_rec in flow_c loop

Line 148: if ( l_returnStatus = fnd_api.g_ret_sts_success ) then

144: flow_rec.alternate_routing_designator,
145: flow_rec.subinventory_code,
146: flow_rec.locator_id,
147: flow_rec.accounting_class);
148: if ( l_returnStatus = fnd_api.g_ret_sts_success ) then
149: update mtl_transactions_interface
150: set schedule_number = flow_rec.schedule_number,
151: source_project_id = flow_rec.source_project_id,
152: project_id = flow_rec.project_id,

Line 177: fnd_api.g_ret_sts_success ) then

173: raise l_validationException;
174: end if;
175:
176: if ( validateInterfaceCompletion(flow_rec.rowid) <>
177: fnd_api.g_ret_sts_success ) then
178: l_errMsg := 'error validating';
179: raise l_validationException;
180: end if;
181:

Line 184: fnd_api.g_ret_sts_success ) then

180: end if;
181:
182: -- now validate the substitution records
183: if ( checkSubstitution(flow_rec.transaction_interface_id) <>
184: fnd_api.g_ret_sts_success ) then
185: l_errMsg := 'check sub error';
186: raise l_validationException;
187: end if;
188: end if;

Line 195: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

191: --after deriveCompletion() in case of background.
192: createFlowSchedule(p_txnInterfaceID => flow_rec.transaction_interface_id,
193: x_returnStatus => l_returnStatus,
194: x_wipEntityID => flow_rec.transaction_source_id);
195: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
196: l_errMsg := 'createFlowSchedule error';
197: raise l_validationException;
198: end if;
199:

Line 237: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

233: p_txnBatchSeq => flow_rec.transaction_batch_seq + 1,
234: p_defaultPushSubinv => 'Y', --bug#5262858
235: x_returnStatus => l_returnStatus,
236: x_nontxn_excluded =>l_nontxn_excluded); --added for fix 5630078
237: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
238: l_errMsg := 'explosion error';
239: raise l_validationException;
240: end if;
241:

Line 244: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

240: end if;
241:
242: -- now merge the exploded records with those substitution records.
243: mergeComponents(flow_rec.transaction_interface_id, l_returnStatus);
244: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
245: l_errMsg := 'component merge error';
246: raise l_validationException;
247: end if;
248:

Line 297: p_initMsgList => fnd_api.g_false,

293: p_txnHdrID => p_txnHeaderID,
294: p_cplTxnID => flow_rec.completion_transaction_id,
295: p_movTxnID => null,
296: p_childMovTxnID => null,
297: p_initMsgList => fnd_api.g_false,
298: p_endDebug => fnd_api.g_false,
299: x_returnStatus => l_returnStatus);
300: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
301: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN

Line 298: p_endDebug => fnd_api.g_false,

294: p_cplTxnID => flow_rec.completion_transaction_id,
295: p_movTxnID => null,
296: p_childMovTxnID => null,
297: p_initMsgList => fnd_api.g_false,
298: p_endDebug => fnd_api.g_false,
299: x_returnStatus => l_returnStatus);
300: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
301: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN
302: l_errMsg := 'wip_autoLotProc_priv.deriveLotsFromMTI failed';

Line 300: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or

296: p_childMovTxnID => null,
297: p_initMsgList => fnd_api.g_false,
298: p_endDebug => fnd_api.g_false,
299: x_returnStatus => l_returnStatus);
300: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
301: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN
302: l_errMsg := 'wip_autoLotProc_priv.deriveLotsFromMTI failed';
303: raise l_validationException ;
304: END IF;

Line 301: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN

297: p_initMsgList => fnd_api.g_false,
298: p_endDebug => fnd_api.g_false,
299: x_returnStatus => l_returnStatus);
300: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
301: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN
302: l_errMsg := 'wip_autoLotProc_priv.deriveLotsFromMTI failed';
303: raise l_validationException ;
304: END IF;
305: END IF;

Line 321: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

317:
318: -- generate issue locator
319: if ( flow_rec.source_project_id is not null ) then
320: generateIssueLocator(flow_rec.transaction_interface_id, l_returnStatus);
321: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
322: l_errMsg := 'issue locator error';
323: raise l_validationException;
324: end if;
325: end if;

Line 340: p_procReturnStatus => fnd_api.g_ret_sts_success,

336: end loop;
337:
338: if (l_logLevel <= wip_constants.trace_logging) then
339: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',
340: p_procReturnStatus => fnd_api.g_ret_sts_success,
341: p_msg => 'Finished processFlowInterfaceRecords',
342: x_returnStatus => l_returnStatus); --discard logging return status
343: end if;
344: end processFlowInterfaceRecords;

Line 423: return fnd_api.g_ret_sts_error;

419: p_org_id => p_orgID,
420: p_item_id => p_itemID,
421: p_wip_entity_type => 4,
422: p_project_id => p_srcProjID) = 0 ) ) then
423: return fnd_api.g_ret_sts_error;
424: end if;
425: else -- else of p_scheduledFlag = 2
426: if ( wip_flow_derive.scheduled_flow_derivation(
427: p_txn_action_id => p_txnActionID,

Line 447: return fnd_api.g_ret_sts_error;

443: p_wip_entity_type => l_dummy,
444: p_comp_loc => p_cplLocID,
445: p_alt_rtg_des => p_altRtgDes,
446: p_alt_bom_des => p_altBomDes) = 0 ) then
447: return fnd_api.g_ret_sts_error;
448: end if;
449: end if;
450: return fnd_api.g_ret_sts_success;
451: exception

Line 450: return fnd_api.g_ret_sts_success;

446: p_alt_bom_des => p_altBomDes) = 0 ) then
447: return fnd_api.g_ret_sts_error;
448: end if;
449: end if;
450: return fnd_api.g_ret_sts_success;
451: exception
452: when others then
453: return fnd_api.g_ret_sts_error;
454: end deriveCompletion;

Line 453: return fnd_api.g_ret_sts_error;

449: end if;
450: return fnd_api.g_ret_sts_success;
451: exception
452: when others then
453: return fnd_api.g_ret_sts_error;
454: end deriveCompletion;
455:
456:
457: /**

Line 529: return fnd_api.g_ret_sts_success;

525:
526: elsif (wip_flow_validation.unit_number(p_rowid => p_rowid) = 0 ) then
527: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');
528: else
529: return fnd_api.g_ret_sts_success;
530: end if;
531:
532: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
533: p_errCode => null,

Line 535: return fnd_api.g_ret_sts_error;

531:
532: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
533: p_errCode => null,
534: p_msgData => fnd_message.get);
535: return fnd_api.g_ret_sts_error;
536: exception
537: when others then
538: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
539: fnd_message.set_token('ENTITY1', l_scheduleNumber);

Line 543: return fnd_api.g_ret_sts_error;

539: fnd_message.set_token('ENTITY1', l_scheduleNumber);
540: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
541: p_errCode => null,
542: p_msgData => fnd_message.get);
543: return fnd_api.g_ret_sts_error;
544: end validateInterfaceCompletion;
545:
546:
547: /**

Line 586: return fnd_api.g_ret_sts_error;

582: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_TYPE');
583: wip_mti_pub.setMtiError(p_parentID,
584: 'substitution_type_id',
585: substrb(fnd_message.get, 1, 240));
586: return fnd_api.g_ret_sts_error;
587: end if;
588:
589: select count(*)
590: into l_result

Line 601: return fnd_api.g_ret_sts_error;

597: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
598: wip_mti_pub.setMtiError(p_parentID,
599: 'flow_schedule',
600: substrb(fnd_message.get, 1, 240));
601: return fnd_api.g_ret_sts_error;
602: end if;
603: exception
604: when others then
605: null; -- no substitution record

Line 640: return fnd_api.g_ret_sts_error;

636: fnd_message.set_token('ENTITY2', 'Original Component');
637: wip_mti_pub.setMtiError(p_parentID,
638: 'inventory_item_id',
639: substrb(fnd_message.get, 1, 240));
640: return fnd_api.g_ret_sts_error;
641: end if;
642: end if;
643:
644: if ( sub_rec.substitution_type_id in (1, 3) ) then

Line 668: return fnd_api.g_ret_sts_error;

664: fnd_message.set_token('ENTITY2', 'Substitution Component');
665: wip_mti_pub.setMtiError(p_parentID,
666: 'substitution_item_id',
667: substrb(fnd_message.get, 1, 240));
668: return fnd_api.g_ret_sts_error;
669: end if;
670: end if;
671: end loop;
672:

Line 673: return fnd_api.g_ret_sts_success;

669: end if;
670: end if;
671: end loop;
672:
673: return fnd_api.g_ret_sts_success;
674: end checkSubstitution;
675:
676:
677: /**

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

784: l_params(20).paramValue := p_defaultPushSubinv;
785: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
786: p_params => l_params,
787: x_returnStatus => x_returnStatus);
788: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
789: raise fnd_api.g_exc_unexpected_error;
790: end if;
791: end if;
792:

Line 789: raise fnd_api.g_exc_unexpected_error;

785: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
786: p_params => l_params,
787: x_returnStatus => x_returnStatus);
788: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
789: raise fnd_api.g_exc_unexpected_error;
790: end if;
791: end if;
792:
793: explodeRequirementsAndDefault(p_assyID => p_assyID,

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

805: p_txnFlag => true, -- p_txnFlag, for bug 4538135 /* ER 4369064 */
806: p_defaultPushSubinv => p_defaultPushSubinv, --bug#5262858
807: x_compTbl => l_compTbl,
808: x_returnStatus => x_returnStatus);
809: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
810: raise fnd_api.g_exc_unexpected_error;
811: end if;
812:
813: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);

Line 810: raise fnd_api.g_exc_unexpected_error;

806: p_defaultPushSubinv => p_defaultPushSubinv, --bug#5262858
807: x_compTbl => l_compTbl,
808: x_returnStatus => x_returnStatus);
809: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
810: raise fnd_api.g_exc_unexpected_error;
811: end if;
812:
813: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
814:

Line 991: when fnd_api.g_exc_unexpected_error then

987: to_char(p_parentID) || ' successfully!',
988: x_returnStatus => l_returnStatus); --discard logging return status
989: end if;
990: exception
991: when fnd_api.g_exc_unexpected_error then
992: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
993:
994: wip_utilities.get_message_stack(p_msg => l_errMsg,
995: p_delete_stack => fnd_api.g_false);

Line 992: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

988: x_returnStatus => l_returnStatus); --discard logging return status
989: end if;
990: exception
991: when fnd_api.g_exc_unexpected_error then
992: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
993:
994: wip_utilities.get_message_stack(p_msg => l_errMsg,
995: p_delete_stack => fnd_api.g_false);
996:

Line 995: p_delete_stack => fnd_api.g_false);

991: when fnd_api.g_exc_unexpected_error then
992: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
993:
994: wip_utilities.get_message_stack(p_msg => l_errMsg,
995: p_delete_stack => fnd_api.g_false);
996:
997: if (l_logLevel <= wip_constants.trace_logging) then
998: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
999: p_procReturnStatus => x_returnStatus,

Line 1012: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1008: null,
1009: substrb(fnd_message.get, 1, 240));
1010:
1011: when others then
1012: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1013: if (l_logLevel <= wip_constants.trace_logging) then
1014:
1015: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_flowutil_priv',
1016: p_procedure_name => 'explodeRequirementsToMTI',

Line 1078: x_returnStatus := fnd_api.g_ret_sts_success;

1074: l_wipEntityID number := null;
1075:
1076: merge_exception exception;
1077: begin
1078: x_returnStatus := fnd_api.g_ret_sts_success;
1079:
1080: for subs_rec in subs_c loop
1081: if ( subs_rec.substitution_type_id = 1 ) then
1082: ------------- Replacement ----------------------

Line 1233: x_returnStatus := fnd_api.g_ret_sts_error;

1229: and substitution_type_id is null;
1230:
1231: exception
1232: when merge_exception then
1233: x_returnStatus := fnd_api.g_ret_sts_error;
1234: wip_mti_pub.setMtiError(p_parentID,
1235: null,
1236: substrb(fnd_message.get, 1, 240));
1237: when others then

Line 1238: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1234: wip_mti_pub.setMtiError(p_parentID,
1235: null,
1236: substrb(fnd_message.get, 1, 240));
1237: when others then
1238: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1239: wip_mti_pub.setMtiError(p_parentID,
1240: null,
1241: substrb('Error in merging: ' || SQLERRM, 1, 240));
1242: end mergeComponents;

Line 1260: x_returnStatus := fnd_api.g_ret_sts_success;

1256: l_srcProjID number := null;
1257: l_srcTaskID number := null;
1258: l_success number;
1259: begin
1260: x_returnStatus := fnd_api.g_ret_sts_success;
1261: null;
1262: end generateIssueLocator;
1263:
1264: /**

Line 1469: x_returnStatus := fnd_api.g_ret_sts_success;

1465: where transaction_interface_id = p_txnInterfaceID;
1466:
1467: begin
1468:
1469: x_returnStatus := fnd_api.g_ret_sts_success;
1470:
1471: if (l_logLevel <= wip_constants.trace_logging) then
1472: l_params(1).paramName := 'p_txnInterfaceID';
1473: l_params(1).paramValue := p_txnInterfaceID;

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

1473: l_params(1).paramValue := p_txnInterfaceID;
1474: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1475: p_params => l_params,
1476: x_returnStatus => x_returnStatus);
1477: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1478: raise fnd_api.g_exc_unexpected_error;
1479: end if;
1480: end if;
1481:

Line 1478: raise fnd_api.g_exc_unexpected_error;

1474: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1475: p_params => l_params,
1476: x_returnStatus => x_returnStatus);
1477: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1478: raise fnd_api.g_exc_unexpected_error;
1479: end if;
1480: end if;
1481:
1482: if(l_logLevel <= wip_constants.full_logging) then

Line 1535: x_returnStatus := fnd_api.g_ret_sts_success;

1531: p_procReturnStatus => x_returnStatus,
1532: p_msg => 'Flow schedule creation not necessary.',
1533: x_returnStatus => l_returnStatus); --discard logging return status
1534: end if;
1535: x_returnStatus := fnd_api.g_ret_sts_success;
1536: return;
1537: end if;
1538:
1539: l_flowRec.wip_entity_type := 4 ; -- Set it to Flow Schedule

Line 1780: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1776: x_returnStatus => l_returnStatus); --discard logging return status
1777: end if;
1778: exception
1779: when others then
1780: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1781: if (l_logLevel <= wip_constants.trace_logging) then
1782: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1783: p_procReturnStatus => x_returnStatus,
1784: p_msg => 'unexpected error: ' || SQLERRM,

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

1816: l_params(1).paramValue := p_txnTempID;
1817: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1818: p_params => l_params,
1819: x_returnStatus => x_returnStatus);
1820: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1821: raise fnd_api.g_exc_unexpected_error;
1822: end if;
1823: end if;
1824:

Line 1821: raise fnd_api.g_exc_unexpected_error;

1817: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1818: p_params => l_params,
1819: x_returnStatus => x_returnStatus);
1820: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1821: raise fnd_api.g_exc_unexpected_error;
1822: end if;
1823: end if;
1824:
1825: /*

Line 1903: x_returnStatus := fnd_api.g_ret_sts_error;

1899: x_returnStatus => l_returnStatus); --discard logging return status
1900: end if;
1901: exception
1902: when others then
1903: x_returnStatus := fnd_api.g_ret_sts_error;
1904: if (l_logLevel <= wip_constants.trace_logging) then
1905: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1906: p_procReturnStatus => x_returnStatus,
1907: p_msg => 'unexpected error: ' || SQLERRM,

Line 1992: x_returnStatus := fnd_api.g_ret_sts_success;

1988:
1989: l_includeYield NUMBER; /*Component Yield Enhancement(Bug 4369064)*/
1990: l_service_item_flag varchar2(1); /*Bug 6134576*/
1991: begin
1992: x_returnStatus := fnd_api.g_ret_sts_success;
1993:
1994: wip_bflProc_priv.explodeRequirements(p_itemID => p_assyID,
1995: p_orgID => p_orgID,
1996: p_qty => p_qty,

Line 2005: p_initMsgList => fnd_api.g_false,

2001: p_implFlag => p_implFlag,
2002: p_projectID => p_projectID,
2003: p_taskID => p_taskID,
2004: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
2005: p_initMsgList => fnd_api.g_false,
2006: p_endDebug => fnd_api.g_true,
2007: x_compTbl => x_compTbl,
2008: x_returnStatus => x_returnStatus);
2009: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

Line 2006: p_endDebug => fnd_api.g_true,

2002: p_projectID => p_projectID,
2003: p_taskID => p_taskID,
2004: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
2005: p_initMsgList => fnd_api.g_false,
2006: p_endDebug => fnd_api.g_true,
2007: x_compTbl => x_compTbl,
2008: x_returnStatus => x_returnStatus);
2009: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2010: return;

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

2005: p_initMsgList => fnd_api.g_false,
2006: p_endDebug => fnd_api.g_true,
2007: x_compTbl => x_compTbl,
2008: x_returnStatus => x_returnStatus);
2009: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2010: return;
2011: end if;
2012:
2013: if (l_logLevel <= wip_constants.full_logging) then

Line 2161: x_returnStatus := fnd_api.g_ret_sts_error;

2157: if l_service_item_flag = 'N' then
2158: if ( nvl(x_compTbl(l_count).wip_supply_type, -1) <> 6 and
2159: x_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y' and
2160: p_txnFlag) then --Bug4538135.Don't check this while creating job
2161: x_returnStatus := fnd_api.g_ret_sts_error;
2162: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2163: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2164: fnd_msg_pub.add;
2165: if (l_logLevel <= wip_constants.full_logging) then

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

2304: l_params(11).paramValue := p_altRoutDesig;
2305: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2306: p_params => l_params,
2307: x_returnStatus => x_returnStatus);
2308: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2309: raise fnd_api.g_exc_unexpected_error;
2310: end if;
2311: end if;
2312:

Line 2309: raise fnd_api.g_exc_unexpected_error;

2305: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2306: p_params => l_params,
2307: x_returnStatus => x_returnStatus);
2308: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2309: raise fnd_api.g_exc_unexpected_error;
2310: end if;
2311: end if;
2312:
2313: invttmtx.tdatechk(org_id => p_orgID,

Line 2320: raise fnd_api.g_exc_unexpected_error;

2316: open_past_period => l_openPastPeriod);
2317: if ( l_acctPeriodID is null ) then
2318: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
2319: fnd_msg_pub.add;
2320: raise fnd_api.g_exc_unexpected_error;
2321: end if;
2322:
2323: explodeRequirementsAndDefault(p_assyID => p_assyID,
2324: p_orgID => p_orgID,

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

2333: p_altRoutDesig => p_altRoutDesig,
2334: /* fix for bug4538135 */ p_txnFlag => true, /* E 4369064 */
2335: x_compTbl => l_compTbl,
2336: x_returnStatus => x_returnStatus);
2337: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2338: raise fnd_api.g_exc_unexpected_error;
2339: end if;
2340:
2341: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);

Line 2338: raise fnd_api.g_exc_unexpected_error;

2334: /* fix for bug4538135 */ p_txnFlag => true, /* E 4369064 */
2335: x_compTbl => l_compTbl,
2336: x_returnStatus => x_returnStatus);
2337: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2338: raise fnd_api.g_exc_unexpected_error;
2339: end if;
2340:
2341: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
2342:

Line 2453: x_returnStatus := fnd_api.g_ret_sts_error;

2449: x_returnStatus => l_returnStatus); --discard logging return status
2450: end if;
2451: exception
2452: when others then
2453: x_returnStatus := fnd_api.g_ret_sts_error;
2454: if (l_logLevel <= wip_constants.trace_logging) then
2455: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2456: p_procReturnStatus => x_returnStatus,
2457: p_msg => 'unexpected error: ' || SQLERRM,

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

2691: l_params(1).paramValue := p_parentID;
2692: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2693: p_params => l_params,
2694: x_returnStatus => x_returnStatus);
2695: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2696: raise fnd_api.g_exc_unexpected_error;
2697: end if;
2698: end if;
2699:

Line 2696: raise fnd_api.g_exc_unexpected_error;

2692: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2693: p_params => l_params,
2694: x_returnStatus => x_returnStatus);
2695: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2696: raise fnd_api.g_exc_unexpected_error;
2697: end if;
2698: end if;
2699:
2700: select organization_id,

Line 2742: x_returnStatus := fnd_api.g_ret_sts_error;

2738: p_supply_loc_id => comp_rec.locator_id,
2739: p_item_id => comp_rec.inventory_item_id,
2740: p_org_loc_control => l_orgLocControl);
2741: if ( l_success = false ) then
2742: x_returnStatus := fnd_api.g_ret_sts_error;
2743: if (l_logLevel <= wip_constants.trace_logging) then
2744: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2745: p_procReturnStatus => x_returnStatus,
2746: p_msg => 'Error in calling '||