[Home] [Help]
12: | This file creates the utilities that are required to create |
13: | work orders for ATO configurations. |
14: | |
15: | insert_wip_interface - inserts a record into |
16: | WIP_JOB_SCHEDULE_INTERFACE for |
17: | WIP_MASS_LOAD to create work orders |
18: | |
19: | To Do: Handle Errors. Need to discuss with Usha and Girish what |
20: | error information to include in Notification. |
221: x_message_name - Error message name
222: x_message_text - Error message text
223:
224: Description: This function inserts a record into the
225: WIP_JOB_SCHEDULE_INTERFACE table for the creation of
226: work orders through AutoCreate FAS in OM.
227:
228: *****************************************************************************/
229:
968: else
969:
970: l_stmt_num := 4;
971: if (l_rows_selected - l_rows_errored = 1) then
972: select wip_job_schedule_interface_s.nextval
973: into x_wip_seq
974: from dual;
975: end if;
976:
1130: END IF;
1131:
1132: l_rows_inserted := l_rows_inserted + 1;
1133:
1134: end if; /* end of insert into wip_job_schedule_interface*/
1135:
1136: EXCEPTION
1137: when NOT_PLANNED then
1138: IF PG_DEBUG <> 0 THEN
1183: -- If run thru SO pad (progress order), the cursor should pick that record for progressing.
1184: -- If not, return FAILURE. If we dont return FAILURE, the WF will end normal and
1185: -- move to Ship Line Notified without creating work-order and reservations.
1186: -- This could happen if this line was picked by FAS earlier but was terminated (as in PAXAR's case)
1187: -- Also, if insert into wip_job_schedule_interface fails for this order line, we will error out.
1188:
1189:
1190:
1191: if (l_line_id is not null AND x_orders_loaded = 0) then
1223:
1224: exception
1225: when no_data_found then
1226: IF PG_DEBUG <> 0 THEN
1227: oe_debug_pub.add ('get_order_lines: ' || 'Could not find a WIP job. Records probably stuck in wip job schedule interface.',1);
1228: END IF;
1229:
1230: when others then
1231: IF PG_DEBUG <> 0 THEN
1297: x_message_name - name of error message if insert
1298: fails
1299:
1300: Description: This function inserts a record into the
1301: WIP_JOB_SCHEDULE_INTERFACE table for the creation of
1302: work orders.
1303:
1304: *****************************************************************************/
1305:
1377: -- wei.bom_revision
1378: -- 2620282: Selecting bom revision info
1379: decode( nvl(msi.revision_qty_control_code , 1 ) , 1, NULL , wei.bom_revision) bom_revision,
1380: oel.org_id -- bugfix 3014000
1381: from wip_job_schedule_interface wei,
1382: oe_order_lines_all oel,
1383: mtl_sales_orders mso,
1384: oe_order_headers_all oeh,
1385: --oe_order_types_v oet
1542: set status_type = 7 -- CANCELLED
1543: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1544:
1545: l_stmt_num := 110;
1546: update wip_job_schedule_interface
1547: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1548: process_status = WIP_CONSTANTS.RUNNING
1549: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1550: and group_id = p_wip_seq;
1567:
1568: l_stmt_num := 115;
1569: select status_type
1570: into l_status_type
1571: from wip_job_schedule_interface
1572: where group_id = p_wip_seq
1573: and source_line_id = WorkOrder_Rec.line_id
1574: and last_update_date <> creation_date
1575: and rownum = 1;
1625: set status_type = 7 -- CANCEL
1626: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1627:
1628: l_stmt_num := 140;
1629: update wip_job_schedule_interface
1630: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1631: process_status = WIP_CONSTANTS.RUNNING
1632: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1633: and group_id = p_wip_seq;
1669: update oe_order_lines_all
1670: set program_id = null
1671: where program_id = -99
1672: and line_id in (select wei.source_line_id
1673: from wip_job_schedule_interface wei
1674: where wei.group_id = p_wip_seq);
1675: end if;
1676: -- end bugfix 3136206
1677:
1721: Description: This function is to support AutoCreate Supply for
1722: Partial Order Qty
1723: It returns the quantity for which supply has been created.
1724: Reserved Qty = Qty in mtl_reservations
1725: + Qty in wip_job_schedule_interface
1726: In case of an error, 0 qty will be returned.
1727:
1728: Modified by :
1729: Renga Kannan 09/20/01 removed the debug messages
1765: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1766: INV_RESERVATION_GLOBAL.g_source_type_oe); --bugfix 1799874
1767:
1768:
1769: -- Cursor to get qty in wip_job_schedule_interface
1770: -- This cursor was modified for bugs 2074290, 2435875, 2455900
1771: -- Bugfix 4254404: We should treat COMPLETED records as supply due to concurrency reasons.
1772:
1773: cursor c_wjsi_qty is
1771: -- Bugfix 4254404: We should treat COMPLETED records as supply due to concurrency reasons.
1772:
1773: cursor c_wjsi_qty is
1774: select nvl(sum(wjs.start_quantity), 0)
1775: from wip_job_schedule_interface wjs,
1776: oe_order_lines_all oel
1777: where oel.line_id = pLineId
1778: and wjs.source_line_id = oel.line_id
1779: and (wjs.process_status = WIP_CONSTANTS.PENDING