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.EAM_COMPLETION dependencies on WIP_CONSTANTS

Line 181: i_transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;

177: i_primary_quantity := i_transaction_quantity;
178:
179: -- prepare the rest data
180: if(s_transaction_type = 1) then -- Complete Transaction
181: i_transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
182: i_transaction_type_id := WIP_CONSTANTS.CPLASSY_TYPE;
183: elsif(s_transaction_type = 2) then -- Uncomplete Transaction
184: i_transaction_quantity := - i_transaction_quantity;
185: i_primary_quantity := - i_primary_quantity;

Line 182: i_transaction_type_id := WIP_CONSTANTS.CPLASSY_TYPE;

178:
179: -- prepare the rest data
180: if(s_transaction_type = 1) then -- Complete Transaction
181: i_transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
182: i_transaction_type_id := WIP_CONSTANTS.CPLASSY_TYPE;
183: elsif(s_transaction_type = 2) then -- Uncomplete Transaction
184: i_transaction_quantity := - i_transaction_quantity;
185: i_primary_quantity := - i_primary_quantity;
186: i_transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;

Line 186: i_transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;

182: i_transaction_type_id := WIP_CONSTANTS.CPLASSY_TYPE;
183: elsif(s_transaction_type = 2) then -- Uncomplete Transaction
184: i_transaction_quantity := - i_transaction_quantity;
185: i_primary_quantity := - i_primary_quantity;
186: i_transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
187: i_transaction_type_id := WIP_CONSTANTS.RETASSY_TYPE;
188: else
189: fnd_message.set_name('EAM','EAM_INVALID_TRANSACTION_TYPE');
190: errCode := 1;

Line 187: i_transaction_type_id := WIP_CONSTANTS.RETASSY_TYPE;

183: elsif(s_transaction_type = 2) then -- Uncomplete Transaction
184: i_transaction_quantity := - i_transaction_quantity;
185: i_primary_quantity := - i_primary_quantity;
186: i_transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
187: i_transaction_type_id := WIP_CONSTANTS.RETASSY_TYPE;
188: else
189: fnd_message.set_name('EAM','EAM_INVALID_TRANSACTION_TYPE');
190: errCode := 1;
191: errMsg := fnd_message.get;

Line 237: if(item.lotControlCode = WIP_CONSTANTS.LOT) then

233: end if;
234:
235: -- Check whether the item is under lot or serial control or not
236: -- If it is, insert the data to coresponding tables
237: if(item.lotControlCode = WIP_CONSTANTS.LOT) then
238:
239: -- the item is under lot control
240:
241: -- call inventory API to insert data to mtl_transaction_lots_temp

Line 261: if(item.serialNumberControlCode in (WIP_CONSTANTS.FULL_SN,

257: null;
258: end if; -- end lot control check
259:
260: -- Check if the item is under serial control or not
261: if(item.serialNumberControlCode in (WIP_CONSTANTS.FULL_SN,
262: WIP_CONSTANTS.DYN_RCV_SN)) then
263: -- item is under serial control
264:
265: -- Check if the item is under lot control or not

Line 262: WIP_CONSTANTS.DYN_RCV_SN)) then

258: end if; -- end lot control check
259:
260: -- Check if the item is under serial control or not
261: if(item.serialNumberControlCode in (WIP_CONSTANTS.FULL_SN,
262: WIP_CONSTANTS.DYN_RCV_SN)) then
263: -- item is under serial control
264:
265: -- Check if the item is under lot control or not
266: if(item.lotControlCode = WIP_CONSTANTS.LOT) then

Line 266: if(item.lotControlCode = WIP_CONSTANTS.LOT) then

262: WIP_CONSTANTS.DYN_RCV_SN)) then
263: -- item is under serial control
264:
265: -- Check if the item is under lot control or not
266: if(item.lotControlCode = WIP_CONSTANTS.LOT) then
267:
268: -- under lot control
269: i_transaction_temp_id_s := i_serial_transaction_temp_id;
270: else

Line 1114: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

1110: WHERE parent_relationship_type =1
1111: START WITH parent_object_id = x_wip_entity_id AND parent_relationship_type = 1
1112: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1
1113: )
1114: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
1115: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED,WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_CLOSE)
1116:
1117: );
1118:

Line 1115: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED,WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_CLOSE)

1111: START WITH parent_object_id = x_wip_entity_id AND parent_relationship_type = 1
1112: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1
1113: )
1114: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
1115: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED,WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_CLOSE)
1116:
1117: );
1118:
1119: if (network_child_job_var = '1') then --In the network Work Order has Uncompleted Child Work Orders

Line 1148: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

1144: FROM eam_wo_relationships
1145: WHERE parent_relationship_type =2 and
1146: child_object_id = x_wip_entity_id
1147: )
1148: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
1149: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED)
1150:
1151: );
1152:

Line 1149: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED)

1145: WHERE parent_relationship_type =2 and
1146: child_object_id = x_wip_entity_id
1147: )
1148: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
1149: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED)
1150:
1151: );
1152:
1153: if (sibling_parent_job_var = '1') then

Line 1348: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

1344: FROM wip_discrete_jobs wdj, wip_entities we
1345: WHERE wdj.wip_entity_id = we.wip_entity_id
1346: AND wdj.parent_wip_entity_id = x_wip_entity_id
1347: AND wdj.manual_rebuild_flag = 'Y'
1348: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
1349: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED));
1350: if (child_job_var = '1') then
1351: ROLLBACK TO job_comp;
1352: fnd_message.set_name('EAM','EAM_CHILD_JOB_NOT_COMPLETE');

Line 1349: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED));

1345: WHERE wdj.wip_entity_id = we.wip_entity_id
1346: AND wdj.parent_wip_entity_id = x_wip_entity_id
1347: AND wdj.manual_rebuild_flag = 'Y'
1348: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
1349: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED));
1350: if (child_job_var = '1') then
1351: ROLLBACK TO job_comp;
1352: fnd_message.set_name('EAM','EAM_CHILD_JOB_NOT_COMPLETE');
1353: errCode := 1;

Line 1396: i_status_type := WIP_CONSTANTS.COMP_CHRG;

1392:
1393:
1394:
1395: -- initial the rest important variable
1396: i_status_type := WIP_CONSTANTS.COMP_CHRG;
1397: i_completion_date := x_actual_end_date;
1398: i_work_request_status := 6; -- Work request complete
1399:
1400: elsif (x_transaction_type = 2) then -- Uncomplete Transaction

Line 1444: if(i_parent_status_type = WIP_CONSTANTS.COMP_CHRG) then

1440: null;
1441: end;
1442:
1443: -- Check whether parent job already completed or not
1444: if(i_parent_status_type = WIP_CONSTANTS.COMP_CHRG) then
1445: ROLLBACK TO job_comp;
1446: fnd_message.set_name('EAM','EAM_PARENT_JOB_COMPLETED');
1447: errCode := 1;
1448: errMsg := fnd_message.get;

Line 1488: i_status_type := WIP_CONSTANTS.RELEASED;

1484: eam_pm_utils.update_pm_when_uncomplete(i_org_id, x_wip_entity_id);
1485: end if; -- end of source entity check
1486:
1487: -- initial the rest important variable
1488: i_status_type := WIP_CONSTANTS.RELEASED;
1489: i_completion_date := null;
1490: i_work_request_status := 4; -- Work request in process
1491:
1492: else -- Other Transactions