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 178: fnd_api.g_ret_sts_success ) then

174: end if;
175:
176: if(l_fromUI = 0) then /* bug #11073237 Revision was null in case Assembly have item */
177: if ( validateInterfaceCompletion(flow_rec.rowid) <>
178: fnd_api.g_ret_sts_success ) then
179: l_errMsg := 'error validating';
180: raise l_validationException;
181: end if;
182:

Line 185: fnd_api.g_ret_sts_success ) then

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

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

199: if flow_rec.transaction_source_id is null then
200: createFlowSchedule(p_txnInterfaceID => flow_rec.transaction_interface_id,
201: x_returnStatus => l_returnStatus,
202: x_wipEntityID => flow_rec.transaction_source_id);
203: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
204: l_errMsg := 'createFlowSchedule error';
205: raise l_validationException;
206: end if;
207: end if;

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

242: p_txnBatchSeq => flow_rec.transaction_batch_seq + 1,
243: p_defaultPushSubinv => 'Y', --bug#5262858
244: x_returnStatus => l_returnStatus,
245: x_nontxn_excluded =>l_nontxn_excluded); --added for fix 5630078
246: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
247: l_errMsg := 'explosion error';
248: raise l_validationException;
249: end if;
250:

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

249: end if;
250:
251: -- now merge the exploded records with those substitution records.
252: mergeComponents(flow_rec.transaction_interface_id, l_returnStatus);
253: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
254: l_errMsg := 'component merge error';
255: raise l_validationException;
256: end if;
257:

Line 328: p_initMsgList => fnd_api.g_false,

324: p_txnHdrID => p_txnHeaderID,
325: p_cplTxnID => flow_rec.completion_transaction_id,
326: p_movTxnID => null,
327: p_childMovTxnID => null,
328: p_initMsgList => fnd_api.g_false,
329: p_endDebug => fnd_api.g_false,
330: x_returnStatus => l_returnStatus);
331: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
332: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN

Line 329: p_endDebug => fnd_api.g_false,

325: p_cplTxnID => flow_rec.completion_transaction_id,
326: p_movTxnID => null,
327: p_childMovTxnID => null,
328: p_initMsgList => fnd_api.g_false,
329: p_endDebug => fnd_api.g_false,
330: x_returnStatus => l_returnStatus);
331: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
332: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN
333: l_errMsg := 'wip_autoLotProc_priv.deriveLotsFromMTI failed';

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

327: p_childMovTxnID => null,
328: p_initMsgList => fnd_api.g_false,
329: p_endDebug => fnd_api.g_false,
330: x_returnStatus => l_returnStatus);
331: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
332: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN
333: l_errMsg := 'wip_autoLotProc_priv.deriveLotsFromMTI failed';
334: raise l_validationException ;
335: END IF;

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

328: p_initMsgList => fnd_api.g_false,
329: p_endDebug => fnd_api.g_false,
330: x_returnStatus => l_returnStatus);
331: IF ((l_returnStatus = fnd_api.g_ret_sts_unexp_error) or
332: (l_returnStatus = fnd_api.g_ret_sts_error)) THEN
333: l_errMsg := 'wip_autoLotProc_priv.deriveLotsFromMTI failed';
334: raise l_validationException ;
335: END IF;
336: END IF;

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

348:
349: -- generate issue locator
350: if ( flow_rec.source_project_id is not null ) then
351: generateIssueLocator(flow_rec.transaction_interface_id, l_returnStatus);
352: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
353: l_errMsg := 'issue locator error';
354: raise l_validationException;
355: end if;
356: end if;

Line 371: p_procReturnStatus => fnd_api.g_ret_sts_success,

367: end loop;
368:
369: if (l_logLevel <= wip_constants.trace_logging) then
370: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.processFlowInterfaceRecords',
371: p_procReturnStatus => fnd_api.g_ret_sts_success,
372: p_msg => 'Finished processFlowInterfaceRecords',
373: x_returnStatus => l_returnStatus); --discard logging return status
374: end if;
375: end processFlowInterfaceRecords;

Line 454: return fnd_api.g_ret_sts_error;

450: p_org_id => p_orgID,
451: p_item_id => p_itemID,
452: p_wip_entity_type => 4,
453: p_project_id => p_srcProjID) = 0 ) ) then
454: return fnd_api.g_ret_sts_error;
455: end if;
456: else -- else of p_scheduledFlag = 2
457: if ( wip_flow_derive.scheduled_flow_derivation(
458: p_txn_action_id => p_txnActionID,

Line 478: return fnd_api.g_ret_sts_error;

474: p_wip_entity_type => l_dummy,
475: p_comp_loc => p_cplLocID,
476: p_alt_rtg_des => p_altRtgDes,
477: p_alt_bom_des => p_altBomDes) = 0 ) then
478: return fnd_api.g_ret_sts_error;
479: end if;
480: end if;
481: return fnd_api.g_ret_sts_success;
482: exception

Line 481: return fnd_api.g_ret_sts_success;

477: p_alt_bom_des => p_altBomDes) = 0 ) then
478: return fnd_api.g_ret_sts_error;
479: end if;
480: end if;
481: return fnd_api.g_ret_sts_success;
482: exception
483: when others then
484: return fnd_api.g_ret_sts_error;
485: end deriveCompletion;

Line 484: return fnd_api.g_ret_sts_error;

480: end if;
481: return fnd_api.g_ret_sts_success;
482: exception
483: when others then
484: return fnd_api.g_ret_sts_error;
485: end deriveCompletion;
486:
487:
488: /**

Line 560: return fnd_api.g_ret_sts_success;

556:
557: elsif (wip_flow_validation.unit_number(p_rowid => p_rowid) = 0 ) then
558: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');
559: else
560: return fnd_api.g_ret_sts_success;
561: end if;
562:
563: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
564: p_errCode => null,

Line 566: return fnd_api.g_ret_sts_error;

562:
563: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
564: p_errCode => null,
565: p_msgData => fnd_message.get);
566: return fnd_api.g_ret_sts_error;
567: exception
568: when others then
569: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
570: fnd_message.set_token('ENTITY1', l_scheduleNumber);

Line 574: return fnd_api.g_ret_sts_error;

570: fnd_message.set_token('ENTITY1', l_scheduleNumber);
571: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
572: p_errCode => null,
573: p_msgData => fnd_message.get);
574: return fnd_api.g_ret_sts_error;
575: end validateInterfaceCompletion;
576:
577:
578: /**

Line 617: return fnd_api.g_ret_sts_error;

613: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_TYPE');
614: wip_mti_pub.setMtiError(p_parentID,
615: 'substitution_type_id',
616: substrb(fnd_message.get, 1, 240));
617: return fnd_api.g_ret_sts_error;
618: end if;
619:
620: select count(*)
621: into l_result

Line 632: return fnd_api.g_ret_sts_error;

628: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
629: wip_mti_pub.setMtiError(p_parentID,
630: 'flow_schedule',
631: substrb(fnd_message.get, 1, 240));
632: return fnd_api.g_ret_sts_error;
633: end if;
634: exception
635: when others then
636: null; -- no substitution record

Line 671: return fnd_api.g_ret_sts_error;

667: fnd_message.set_token('ENTITY2', 'Original Component');
668: wip_mti_pub.setMtiError(p_parentID,
669: 'inventory_item_id',
670: substrb(fnd_message.get, 1, 240));
671: return fnd_api.g_ret_sts_error;
672: end if;
673: end if;
674:
675: if ( sub_rec.substitution_type_id in (1, 3) ) then

Line 699: return fnd_api.g_ret_sts_error;

695: fnd_message.set_token('ENTITY2', 'Substitution Component');
696: wip_mti_pub.setMtiError(p_parentID,
697: 'substitution_item_id',
698: substrb(fnd_message.get, 1, 240));
699: return fnd_api.g_ret_sts_error;
700: end if;
701: end if;
702: end loop;
703:

Line 704: return fnd_api.g_ret_sts_success;

700: end if;
701: end if;
702: end loop;
703:
704: return fnd_api.g_ret_sts_success;
705: end checkSubstitution;
706:
707:
708: /**

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

815: l_params(20).paramValue := p_defaultPushSubinv;
816: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
817: p_params => l_params,
818: x_returnStatus => x_returnStatus);
819: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
820: raise fnd_api.g_exc_unexpected_error;
821: end if;
822: end if;
823:

Line 820: raise fnd_api.g_exc_unexpected_error;

816: wip_logger.entryPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
817: p_params => l_params,
818: x_returnStatus => x_returnStatus);
819: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
820: raise fnd_api.g_exc_unexpected_error;
821: end if;
822: end if;
823:
824: explodeRequirementsAndDefault(p_assyID => p_assyID,

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

836: p_txnFlag => true, -- p_txnFlag, for bug 4538135 /* ER 4369064 */
837: p_defaultPushSubinv => p_defaultPushSubinv, --bug#5262858
838: x_compTbl => l_compTbl,
839: x_returnStatus => x_returnStatus);
840: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
841: raise fnd_api.g_exc_unexpected_error;
842: end if;
843:
844: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);

Line 841: raise fnd_api.g_exc_unexpected_error;

837: p_defaultPushSubinv => p_defaultPushSubinv, --bug#5262858
838: x_compTbl => l_compTbl,
839: x_returnStatus => x_returnStatus);
840: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
841: raise fnd_api.g_exc_unexpected_error;
842: end if;
843:
844: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
845:

Line 1022: when fnd_api.g_exc_unexpected_error then

1018: to_char(p_parentID) || ' successfully!',
1019: x_returnStatus => l_returnStatus); --discard logging return status
1020: end if;
1021: exception
1022: when fnd_api.g_exc_unexpected_error then
1023: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1024:
1025: wip_utilities.get_message_stack(p_msg => l_errMsg,
1026: p_delete_stack => fnd_api.g_false);

Line 1023: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1019: x_returnStatus => l_returnStatus); --discard logging return status
1020: end if;
1021: exception
1022: when fnd_api.g_exc_unexpected_error then
1023: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1024:
1025: wip_utilities.get_message_stack(p_msg => l_errMsg,
1026: p_delete_stack => fnd_api.g_false);
1027:

Line 1026: p_delete_stack => fnd_api.g_false);

1022: when fnd_api.g_exc_unexpected_error then
1023: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1024:
1025: wip_utilities.get_message_stack(p_msg => l_errMsg,
1026: p_delete_stack => fnd_api.g_false);
1027:
1028: if (l_logLevel <= wip_constants.trace_logging) then
1029: wip_logger.exitPoint(p_procName => 'wip_flowutil_priv.explodeRequirementsToMTI',
1030: p_procReturnStatus => x_returnStatus,

Line 1043: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1039: null,
1040: substrb(fnd_message.get, 1, 240));
1041:
1042: when others then
1043: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1044: if (l_logLevel <= wip_constants.trace_logging) then
1045:
1046: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_flowutil_priv',
1047: p_procedure_name => 'explodeRequirementsToMTI',

Line 1109: x_returnStatus := fnd_api.g_ret_sts_success;

1105: l_wipEntityID number := null;
1106:
1107: merge_exception exception;
1108: begin
1109: x_returnStatus := fnd_api.g_ret_sts_success;
1110:
1111: for subs_rec in subs_c loop
1112: if ( subs_rec.substitution_type_id = 1 ) then
1113: ------------- Replacement ----------------------

Line 1264: x_returnStatus := fnd_api.g_ret_sts_error;

1260: and substitution_type_id is null;
1261:
1262: exception
1263: when merge_exception then
1264: x_returnStatus := fnd_api.g_ret_sts_error;
1265: wip_mti_pub.setMtiError(p_parentID,
1266: null,
1267: substrb(fnd_message.get, 1, 240));
1268: when others then

Line 1269: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1265: wip_mti_pub.setMtiError(p_parentID,
1266: null,
1267: substrb(fnd_message.get, 1, 240));
1268: when others then
1269: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1270: wip_mti_pub.setMtiError(p_parentID,
1271: null,
1272: substrb('Error in merging: ' || SQLERRM, 1, 240));
1273: end mergeComponents;

Line 1291: x_returnStatus := fnd_api.g_ret_sts_success;

1287: l_srcProjID number := null;
1288: l_srcTaskID number := null;
1289: l_success number;
1290: begin
1291: x_returnStatus := fnd_api.g_ret_sts_success;
1292: null;
1293: end generateIssueLocator;
1294:
1295: /**

Line 1500: x_returnStatus := fnd_api.g_ret_sts_success;

1496: where transaction_interface_id = p_txnInterfaceID;
1497:
1498: begin
1499:
1500: x_returnStatus := fnd_api.g_ret_sts_success;
1501:
1502: if (l_logLevel <= wip_constants.trace_logging) then
1503: l_params(1).paramName := 'p_txnInterfaceID';
1504: l_params(1).paramValue := p_txnInterfaceID;

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

1504: l_params(1).paramValue := p_txnInterfaceID;
1505: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1506: p_params => l_params,
1507: x_returnStatus => x_returnStatus);
1508: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1509: raise fnd_api.g_exc_unexpected_error;
1510: end if;
1511: end if;
1512:

Line 1509: raise fnd_api.g_exc_unexpected_error;

1505: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1506: p_params => l_params,
1507: x_returnStatus => x_returnStatus);
1508: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1509: raise fnd_api.g_exc_unexpected_error;
1510: end if;
1511: end if;
1512:
1513: if(l_logLevel <= wip_constants.full_logging) then

Line 1566: x_returnStatus := fnd_api.g_ret_sts_success;

1562: p_procReturnStatus => x_returnStatus,
1563: p_msg => 'Flow schedule creation not necessary.',
1564: x_returnStatus => l_returnStatus); --discard logging return status
1565: end if;
1566: x_returnStatus := fnd_api.g_ret_sts_success;
1567: return;
1568: end if;
1569:
1570: l_flowRec.wip_entity_type := 4 ; -- Set it to Flow Schedule

Line 1811: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1807: x_returnStatus => l_returnStatus); --discard logging return status
1808: end if;
1809: exception
1810: when others then
1811: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1812: if (l_logLevel <= wip_constants.trace_logging) then
1813: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.createFlowSchedule',
1814: p_procReturnStatus => x_returnStatus,
1815: p_msg => 'unexpected error: ' || SQLERRM,

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

1847: l_params(1).paramValue := p_txnTempID;
1848: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1849: p_params => l_params,
1850: x_returnStatus => x_returnStatus);
1851: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1852: raise fnd_api.g_exc_unexpected_error;
1853: end if;
1854: end if;
1855:

Line 1852: raise fnd_api.g_exc_unexpected_error;

1848: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1849: p_params => l_params,
1850: x_returnStatus => x_returnStatus);
1851: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1852: raise fnd_api.g_exc_unexpected_error;
1853: end if;
1854: end if;
1855:
1856: /*

Line 1936: x_returnStatus := fnd_api.g_ret_sts_error;

1932: x_returnStatus => l_returnStatus); --discard logging return status
1933: end if;
1934: exception
1935: when others then
1936: x_returnStatus := fnd_api.g_ret_sts_error;
1937: if (l_logLevel <= wip_constants.trace_logging) then
1938: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.updateFlowSchedule',
1939: p_procReturnStatus => x_returnStatus,
1940: p_msg => 'unexpected error: ' || SQLERRM,

Line 2025: x_returnStatus := fnd_api.g_ret_sts_success;

2021:
2022: l_includeYield NUMBER; /*Component Yield Enhancement(Bug 4369064)*/
2023: l_service_item_flag varchar2(1); /*Bug 6134576*/
2024: begin
2025: x_returnStatus := fnd_api.g_ret_sts_success;
2026:
2027: wip_bflProc_priv.explodeRequirements(p_itemID => p_assyID,
2028: p_orgID => p_orgID,
2029: p_qty => p_qty,

Line 2038: p_initMsgList => fnd_api.g_false,

2034: p_implFlag => p_implFlag,
2035: p_projectID => p_projectID,
2036: p_taskID => p_taskID,
2037: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
2038: p_initMsgList => fnd_api.g_false,
2039: p_endDebug => fnd_api.g_true,
2040: x_compTbl => x_compTbl,
2041: x_returnStatus => x_returnStatus);
2042: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

Line 2039: p_endDebug => fnd_api.g_true,

2035: p_projectID => p_projectID,
2036: p_taskID => p_taskID,
2037: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
2038: p_initMsgList => fnd_api.g_false,
2039: p_endDebug => fnd_api.g_true,
2040: x_compTbl => x_compTbl,
2041: x_returnStatus => x_returnStatus);
2042: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2043: return;

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

2038: p_initMsgList => fnd_api.g_false,
2039: p_endDebug => fnd_api.g_true,
2040: x_compTbl => x_compTbl,
2041: x_returnStatus => x_returnStatus);
2042: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2043: return;
2044: end if;
2045:
2046: if (l_logLevel <= wip_constants.full_logging) then

Line 2200: x_returnStatus := fnd_api.g_ret_sts_error;

2196: if l_service_item_flag = 'N' then
2197: if ( nvl(x_compTbl(l_count).wip_supply_type, -1) <> 6 and
2198: x_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y' and
2199: p_txnFlag) then --Bug4538135.Don't check this while creating job
2200: x_returnStatus := fnd_api.g_ret_sts_error;
2201: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2202: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2203: fnd_msg_pub.add;
2204: if (l_logLevel <= wip_constants.full_logging) then

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

2343: l_params(11).paramValue := p_altRoutDesig;
2344: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2345: p_params => l_params,
2346: x_returnStatus => x_returnStatus);
2347: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2348: raise fnd_api.g_exc_unexpected_error;
2349: end if;
2350: end if;
2351:

Line 2348: raise fnd_api.g_exc_unexpected_error;

2344: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2345: p_params => l_params,
2346: x_returnStatus => x_returnStatus);
2347: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2348: raise fnd_api.g_exc_unexpected_error;
2349: end if;
2350: end if;
2351:
2352: invttmtx.tdatechk(org_id => p_orgID,

Line 2359: raise fnd_api.g_exc_unexpected_error;

2355: open_past_period => l_openPastPeriod);
2356: if ( l_acctPeriodID is null ) then
2357: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
2358: fnd_msg_pub.add;
2359: raise fnd_api.g_exc_unexpected_error;
2360: end if;
2361:
2362: explodeRequirementsAndDefault(p_assyID => p_assyID,
2363: p_orgID => p_orgID,

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

2372: p_altRoutDesig => p_altRoutDesig,
2373: /* fix for bug4538135 */ p_txnFlag => true, /* E 4369064 */
2374: x_compTbl => l_compTbl,
2375: x_returnStatus => x_returnStatus);
2376: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2377: raise fnd_api.g_exc_unexpected_error;
2378: end if;
2379:
2380: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);

Line 2377: raise fnd_api.g_exc_unexpected_error;

2373: /* fix for bug4538135 */ p_txnFlag => true, /* E 4369064 */
2374: x_compTbl => l_compTbl,
2375: x_returnStatus => x_returnStatus);
2376: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
2377: raise fnd_api.g_exc_unexpected_error;
2378: end if;
2379:
2380: l_insertPhantom := wip_globals.use_phantom_routings(p_orgID);
2381:

Line 2492: x_returnStatus := fnd_api.g_ret_sts_error;

2488: x_returnStatus => l_returnStatus); --discard logging return status
2489: end if;
2490: exception
2491: when others then
2492: x_returnStatus := fnd_api.g_ret_sts_error;
2493: if (l_logLevel <= wip_constants.trace_logging) then
2494: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.explodeRequirementsToMMTT',
2495: p_procReturnStatus => x_returnStatus,
2496: p_msg => 'unexpected error: ' || SQLERRM,

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

2730: l_params(1).paramValue := p_parentID;
2731: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2732: p_params => l_params,
2733: x_returnStatus => x_returnStatus);
2734: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2735: raise fnd_api.g_exc_unexpected_error;
2736: end if;
2737: end if;
2738:

Line 2735: raise fnd_api.g_exc_unexpected_error;

2731: wip_logger.entryPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2732: p_params => l_params,
2733: x_returnStatus => x_returnStatus);
2734: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2735: raise fnd_api.g_exc_unexpected_error;
2736: end if;
2737: end if;
2738:
2739: select organization_id,

Line 2781: x_returnStatus := fnd_api.g_ret_sts_error;

2777: p_supply_loc_id => comp_rec.locator_id,
2778: p_item_id => comp_rec.inventory_item_id,
2779: p_org_loc_control => l_orgLocControl);
2780: if ( l_success = false ) then
2781: x_returnStatus := fnd_api.g_ret_sts_error;
2782: if (l_logLevel <= wip_constants.trace_logging) then
2783: wip_logger.exitPoint(p_procName => 'wip_flowUtil_priv.generateCompLocator',
2784: p_procReturnStatus => x_returnStatus,
2785: p_msg => 'Error in calling '||