eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMA_FLOW dependencies on WIP_CONSTANTS

Line 23: if (l_logLevel <= wip_constants.trace_logging) then

19: l_params wip_logger.param_tbl_t;
20: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
21: Begin
22: status := 0;
23: if (l_logLevel <= wip_constants.trace_logging) then
24: l_params(1).paramName := 'not printing params';
25: l_params(1).paramValue := ' ';
26: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecord',
27: p_params => l_params,

Line 34: if (l_logLevel <= wip_constants.trace_logging) then

30:
31: if ( derive(param, flowRec, errMsg) = false ) then
32: status := -1;
33: errMessage := errMsg;
34: if (l_logLevel <= wip_constants.trace_logging) then
35: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
36: p_procReturnStatus => status,
37: p_msg => errMessage,
38: x_returnStatus => l_returnStatus);

Line 46: if (l_logLevel <= wip_constants.trace_logging) then

42:
43: if ( put(flowRec, errMsg) = false ) then
44: status := -1;
45: errMessage := errMsg;
46: if (l_logLevel <= wip_constants.trace_logging) then
47: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
48: p_procReturnStatus => status,
49: p_msg => errMessage,
50: x_returnStatus => l_returnStatus);

Line 55: if (l_logLevel <= wip_constants.trace_logging) then

51: end if;
52: return;
53: end if;
54:
55: if (l_logLevel <= wip_constants.trace_logging) then
56: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
57: p_procReturnStatus => status,
58: p_msg => 'success',
59: x_returnStatus => l_returnStatus);

Line 69: if (l_logLevel <= wip_constants.trace_logging) then

65: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
71: p_procReturnStatus => status,
72: p_msg => errMessage,
73: x_returnStatus => l_returnStatus);

Line 94: if (l_logLevel <= wip_constants.trace_logging) then

90: l_params wip_logger.param_tbl_t;
91: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
92: Begin
93:
94: if (l_logLevel <= wip_constants.trace_logging) then
95: l_params(1).paramName := 'not printing params';
96: l_params(1).paramValue := ' ';
97: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
98: p_params => l_params,

Line 105: if (l_logLevel <= wip_constants.trace_logging) then

101:
102: if ( derive(param, flowRec, errMsg) = false ) then
103: status := -1;
104: errMessage := errMsg;
105: if (l_logLevel <= wip_constants.trace_logging) then
106: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
107: p_procReturnStatus => status,
108: p_msg => errMessage,
109: x_returnStatus => l_returnStatus);

Line 117: if (l_logLevel <= wip_constants.trace_logging) then

113:
114: if ( putIntoMMTT(flowRec, errMsg) = false ) then
115: status := -1;
116: errMessage := errMsg;
117: if (l_logLevel <= wip_constants.trace_logging) then
118: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
119: p_procReturnStatus => status,
120: p_msg => errMessage,
121: x_returnStatus => l_returnStatus);

Line 126: if (l_logLevel <= wip_constants.trace_logging) then

122: end if;
123: return;
124: end if;
125:
126: if (l_logLevel <= wip_constants.trace_logging) then
127: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
128: p_procReturnStatus => status,
129: p_msg => 'success',
130: x_returnStatus => l_returnStatus);

Line 140: if (l_logLevel <= wip_constants.trace_logging) then

136: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
142: p_procReturnStatus => status,
143: p_msg => errMessage,
144: x_returnStatus => l_returnStatus);

Line 175: if assembly.revQtyControlCode = WIP_CONSTANTS.REV then

171: assembly := wma_derive.getItem(param.assemblyID,
172: param.environment.orgID,
173: param.locatorID);
174:
175: if assembly.revQtyControlCode = WIP_CONSTANTS.REV then
176: BOM_REVISIONS.Get_Revision(
177: type => 'PART',
178: eco_status => 'EXCLUDE_OPEN_HOLD',
179: examine_type => 'ALL',

Line 256: flowRec.process_flag := wip_constants.mti_inventory;

252: flowRec.transaction_interface_id := param.transactionIntID;
253: flowRec.transaction_header_id := param.transactionHeaderID;
254: flowRec.completion_transaction_id := param.completionTxnID;
255: flowRec.transaction_mode := wma_derive.getTxnMode(param.environment.orgID);
256: flowRec.process_flag := wip_constants.mti_inventory;
257:
258: flowRec.source_code := WMA_COMMON.SOURCE_CODE;
259:
260: flowRec.last_updated_by := param.environment.userID;

Line 273: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then

269: flowRec.transaction_type_id := param.transactionType;
270: flowRec.transaction_quantity := param.transactionQty;
271: flowRec.primary_quantity := param.transactionQty;
272:
273: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
274: -- for completion
275: flowRec.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
276: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
277: -- for return

Line 275: flowRec.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;

271: flowRec.primary_quantity := param.transactionQty;
272:
273: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
274: -- for completion
275: flowRec.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
276: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
277: -- for return
278: flowRec.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
279: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,

Line 276: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then

272:
273: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
274: -- for completion
275: flowRec.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
276: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
277: -- for return
278: flowRec.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
279: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
280: WIP_CONSTANTS.RETSCRA_TYPE) ) then

Line 278: flowRec.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;

274: -- for completion
275: flowRec.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
276: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
277: -- for return
278: flowRec.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
279: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
280: WIP_CONSTANTS.RETSCRA_TYPE) ) then
281: -- for scrap
282: flowRec.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;

Line 279: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,

275: flowRec.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
276: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
277: -- for return
278: flowRec.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
279: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
280: WIP_CONSTANTS.RETSCRA_TYPE) ) then
281: -- for scrap
282: flowRec.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
283: if ( wma_util.getScrapAcctID(param.environment.orgID,

Line 280: WIP_CONSTANTS.RETSCRA_TYPE) ) then

276: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
277: -- for return
278: flowRec.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
279: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
280: WIP_CONSTANTS.RETSCRA_TYPE) ) then
281: -- for scrap
282: flowRec.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
283: if ( wma_util.getScrapAcctID(param.environment.orgID,
284: scrapAcctID,

Line 282: flowRec.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;

278: flowRec.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
279: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
280: WIP_CONSTANTS.RETSCRA_TYPE) ) then
281: -- for scrap
282: flowRec.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
283: if ( wma_util.getScrapAcctID(param.environment.orgID,
284: scrapAcctID,
285: errMsg) = false ) then
286: return false;

Line 306: flowRec.wipEntityType := wip_constants.flow;

302: flowRec.repetitive_line_id := param.lineID;
303: flowRec.operation_seq_num := param.lineOp;
304: flowRec.scheduled_flag := param.scheduledFlag;
305: flowRec.flow_schedule := 'Y';
306: flowRec.wipEntityType := wip_constants.flow;
307:
308: flowRec.demand_source_header_id := param.demandSourceHeaderId;
309: flowRec.demand_source_line := param.demandSourceLine;
310: flowRec.demand_source_delivery := param.demandSourceDelivery;

Line 314: flowRec.wip_entity_type := wip_constants.flow; -- means flow schedule

310: flowRec.demand_source_delivery := param.demandSourceDelivery;
311:
312: flowRec.transaction_source_id := param.wipEntityID;
313: if ( flowRec.transaction_source_id is not null ) then
314: flowRec.wip_entity_type := wip_constants.flow; -- means flow schedule
315: end if;
316:
317: flowRec.header_id := param.headerId;/*Fix for bug #6216695, which is an FP of 6082623 :
318: Add header id to populate MTLT and MSNT*/

Line 325: if (param.scheduledFlag <> 1 and param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE) then

321: flowRec.kanban_card_id := param.kanbanID;
322:
323: -- if the transaction is a work order-less completion, call the PJM
324: -- API to check that the project references are correct
325: if (param.scheduledFlag <> 1 and param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE) then
326: retval := PJM_PROJECT.VALIDATE_PROJ_REFERENCES
327: (x_inventory_org_id => param.environment.orgID,
328: x_project_id => param.projectID,
329: x_task_id => param.taskID,

Line 493: wip_constants.ASSY_BATCH_SEQ --bug 4545130

489: flowRec.lpn_id,
490: flowRec.source_header_id,
491: flowRec.source_line_id,
492: flowRec.transaction_header_id, --bug 4545130
493: wip_constants.ASSY_BATCH_SEQ --bug 4545130
494: );
495: return true;
496:
497: EXCEPTION

Line 576: decode(flowRec.process_flag, wip_constants.mti_inventory, 'Y', 'N'),

572: VALUES (flowRec.transaction_interface_id,
573: flowRec.transaction_header_id,
574: flowRec.completion_transaction_id,
575: flowRec.transaction_mode,
576: decode(flowRec.process_flag, wip_constants.mti_inventory, 'Y', 'N'),
577: flowRec.source_code,
578: flowRec.last_updated_by, flowRec.last_update_date,
579: flowRec.creation_date, flowRec.created_by,
580: flowRec.inventory_item_id,

Line 1019: if (l_logLevel <= wip_constants.trace_logging) then

1015:
1016: begin
1017: x_returnStatus := fnd_api.g_ret_sts_success;
1018:
1019: if (l_logLevel <= wip_constants.trace_logging) then
1020: l_params(1).paramName := 'not printing params';
1021: l_params(1).paramValue := ' ';
1022: wip_logger.entryPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1023: p_params => l_params,

Line 1077: if (l_logLevel <= wip_constants.full_logging) then

1073: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
1074: raise fnd_api.g_exc_unexpected_error;
1075: end if;
1076:
1077: if (l_logLevel <= wip_constants.full_logging) then
1078: wip_logger.log('Done with explosion of components',l_returnStatus);
1079: end if;
1080:
1081: -- fetch flow schedule's information into wfs_info

Line 1094: if (l_logLevel <= wip_constants.full_logging) then

1090: -- we dont insert any component that is not transaction_enabled
1091: if ((nvl(l_compTbl(l_count).wip_supply_type, -1) <> 6) and
1092: (l_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y')) then
1093: l_compTbl.delete(l_count);
1094: if (l_logLevel <= wip_constants.full_logging) then
1095: wip_logger.log('Removed non txn enabled component: '+l_compTbl(l_count).item_name, l_returnStatus);
1096: end if;
1097: goto continue_loop;
1098: end if;

Line 1101: if (nvl(l_compTbl(l_count).basis_type,WIP_CONSTANTS.ITEM_BASED_MTL) = WIP_CONSTANTS.LOT_BASED_MTL) then

1097: goto continue_loop;
1098: end if;
1099:
1100: -- bug 5605598: filter out lot-based components appropriately
1101: if (nvl(l_compTbl(l_count).basis_type,WIP_CONSTANTS.ITEM_BASED_MTL) = WIP_CONSTANTS.LOT_BASED_MTL) then
1102: if (
1103: not(
1104: (l_wfs_info.quantity_completed = 0 and l_wfs_info.quantity_scrapped <= 0 and p_qty > 0) or
1105: (l_wfs_info.quantity_completed + l_wfs_info.quantity_scrapped > 0 and

Line 1135: if (l_logLevel <= wip_constants.full_logging) then

1131: if ( x_returnStatus = fnd_api.g_ret_sts_unexp_error ) then
1132: raise fnd_api.g_exc_unexpected_error;
1133: end if;
1134:
1135: if (l_logLevel <= wip_constants.full_logging) then
1136: wip_logger.log('Done with lot derivation',l_returnStatus);
1137: end if;
1138:
1139: --now that we have exploded components and derived lots

Line 1158: if (l_logLevel <= wip_constants.trace_logging) then

1154: p_altRoutDesig => l_alt_rtg,
1155: x_compInfo => x_compInfo,
1156: x_returnStatus => x_returnStatus);
1157:
1158: if (l_logLevel <= wip_constants.trace_logging) then
1159: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1160: p_procReturnStatus => x_returnStatus,
1161: p_msg => 'success',
1162: x_returnStatus => l_returnStatus);

Line 1169: if (l_logLevel <= wip_constants.trace_logging) then

1165: exception
1166: when fnd_api.g_exc_unexpected_error then
1167: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1168: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1169: if (l_logLevel <= wip_constants.trace_logging) then
1170: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1171: p_procReturnStatus => x_returnStatus,
1172: p_msg => x_errMessage,
1173: x_returnStatus => l_returnStatus);

Line 1181: if (l_logLevel <= wip_constants.trace_logging) then

1177:
1178: when others then
1179: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1180: x_errMessage := SQLERRM;
1181: if (l_logLevel <= wip_constants.trace_logging) then
1182: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1183: p_procReturnStatus => x_returnStatus,
1184: p_msg => x_errMessage,
1185: x_returnStatus => l_returnStatus);