[Home] [Help]
959: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
960: l_wave_header_id number;
961: begin
962:
963: select WMS_WP_WAVE_HEADERS_S.NEXTVAL into l_wave_header_id from dual;
964:
965: INSERT INTO wms_wp_wave_headers_vl
966: (wave_header_id,
967: WAVE_NAME,
1165: BRACKET_CLOSE
1166: FROM wms_wp_Advanced_Criteria
1167: WHERE rule_wave_header_id = p_wave_header_id;
1168:
1169: select WMS_WP_WAVE_HEADERS_S.CURRVAL into p_wave_header_id from dual;
1170:
1171: exception
1172: when others then
1173: select WMS_WP_WAVE_HEADERS_S.CURRVAL into p_wave_header_id from dual;
1169: select WMS_WP_WAVE_HEADERS_S.CURRVAL into p_wave_header_id from dual;
1170:
1171: exception
1172: when others then
1173: select WMS_WP_WAVE_HEADERS_S.CURRVAL into p_wave_header_id from dual;
1174: print_debug('Error in Insert Wave Record: ' || SQLCODE || ' : ' ||
1175: SQLERRM,
1176: l_debug);
1177: end insert_wave_record;
1429: ELSE
1430: begin
1431: SELECT 'Y'
1432: INTO l_std_oprn_id
1433: FROM dual
1434: WHERE x_labor_time_tbl(task)
1435: .standard_operation_id IN
1436: (SELECT standard_operation_id
1437: FROM bom_std_op_resources_v
1451: print_debug('resource4',l_debug);
1452:
1453: SELECT 'Y'
1454: INTO l_item_cat_id
1455: FROM dual
1456: WHERE x_labor_setup_tbl(setup)
1457: .item_category_id is null
1458: or (x_labor_setup_tbl(setup)
1459: .item_category_id IN
2515: --x_return_status := fnd_api.g_ret_sts_success;
2516:
2517: SELECT MTL_TXN_REQUEST_HEADERS_S.NEXTVAL
2518: into l_request_number
2519: FROM SYS.DUAL;
2520:
2521: l_mo_header_id := INV_TRANSFER_ORDER_PVT.get_next_header_id;
2522:
2523: INSERT INTO mtl_txn_request_headers
2665:
2666: l_group_match_seq_tbl(i).match_group_id := l_attr_tab(i).group_id;
2667: select WSH_DELIVERY_GROUP_S.nextval
2668: into l_group_match_seq_tbl(i).delivery_group_id
2669: from dual;
2670:
2671: End IF;
2672:
2673: print_debug('CARTON GROUPING ID : ' || l_group_match_seq_tbl(i).delivery_group_id, l_debug);
2678:
2679:
2680: for i in g_troline_table.FIRST .. g_troline_table.LAST loop
2681:
2682: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL INTO l_seq_val FROM dual; -- Changed
2683: l_line_id := l_seq_val;
2684:
2685: g_mtrl_tbl(i).LINE_ID := l_line_id;
2686: g_mtrl_tbl(i).HEADER_ID := l_mo_header_id;
2839: to_name => NULL);
2840: END IF;
2841:
2842:
2843: -- SELECT WSH_DELIVERY_GROUP_S.NEXTVAL INTO l_seq_val FROM dual; -- Changed
2844:
2845:
2846: g_mtrl_tbl(i).TO_ORGANIZATION_ID := null;
2847: g_mtrl_tbl(i).PUT_AWAY_STRATEGY_ID := null;
9688: INSTR(txt, ',', 1, level) + 1,
9689: INSTR(txt, ',', 1, level + 1) -
9690: INSTR(txt, ',', 1, level) - 1)) AS token
9691: FROM (SELECT ',' || l_move_order_line_id || ',' AS txt
9692: FROM dual)
9693: CONNECT BY level <=
9694: LENGTH(txt) - LENGTH(REPLACE(txt, ',', '')) - 1);*/
9695:
9696: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10592: l_debug);
10593:
10594: select WSH_DELIVERY_GROUP_S.nextval
10595: into l_group_match_seq_tbl(i) .delivery_group_id
10596: from dual;
10597: --}
10598: End IF;
10599:
10600: -- l_group_match_seq_tbl(i) .delivery_group_id := l_temp;
10636: l_group_match_seq_tbl(i).match_group_id := l_attr_tab(i)
10637: .group_id;
10638: select WSH_DELIVERY_GROUP_S.nextval
10639: into l_group_match_seq_tbl(i) .delivery_group_id
10640: from dual;
10641: --}
10642: End IF;
10643:
10644: print_debug('CARTON GROUPING ID : ' || l_group_match_seq_tbl(i)
12940: a number;
12941: begin
12942: SELECT (1)
12943: INTO a
12944: FROM dual
12945: WHERE l_custom_line_tbl(i)
12946: .delivery_detail_id IN
12947: (SELECT distinct wwl.delivery_detail_id
12948: FROM WMS_WP_WAVE_LINES wwl,
16220: l_msg := l_msg || l_addl_msg;
16221:
16222: print_debug('message for exception is : ' || l_msg, l_debug);
16223:
16224: SELECT wms_WP_WAVE_exceptions_s.NEXTVAL INTO l_seq_val FROM dual; -- Changed
16225:
16226: WMS_WP_WAVE_EXCEPTIONS_PKG.INSERT_ROW(
16227: -- X_ROWID => l_null, --
16228: X_EXCEPTION_ID => l_seq_val,
16888: (p_entity = 'Delivery' AND delivery_id = p_entity_value) OR
16889: (p_entity = 'Order' AND order_number = p_entity_value) OR
16890: (p_entity = 'Order Line' AND source_line_id = p_entity_value));
16891:
16892: SELECT wms_WP_WAVE_exceptions_s.currval INTO l_seq_val FROM dual; -- Changed
16893: l_update_exception_id := l_seq_val; -- Changed
16894:
16895: UPDATE wms_wp_wave_exceptions_b
16896: SET ready_to_release = l_readytorelease,
16919: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16920:
16921: IF (p_take_corrective_measures = 'Yes') THEN
16922: -- call api to take corrective measures
16923: SELECT wms_WP_WAVE_exceptions_s.CURRVAL INTO l_seq_val FROM dual; -- Changed
16924: take_corrective_measures(l_seq_val, -- Changed
16925: p_wave_id,
16926: p_entity,
16927: p_entity_value,
19325: begin
19326:
19327: --line is in crossdocked status if wdd.released status is 'K' or wdd.move_order_line_id is null
19328: begin
19329: select 'Y' into l_crossdocked from dual where exists
19330: (select 1 from wsh_delivery_details wdd, wms_wp_wave_lines wwl
19331: where wwl.wave_line_id = p_wave_line_id
19332: and wwl.delivery_detail_id = wdd.delivery_detail_id
19333: and wwl.organization_id = wdd.organization_id
19439: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
19440: l_wave_header_id number;
19441: l_request_id number;
19442: BEGIN
19443: select WMS_WP_WAVE_HEADERS_S.NEXTVAL into l_wave_header_id from dual;
19444:
19445: print_debug('Enter LAUNCH_WAVE_ENDECA ' || ' : ' || l_wave_header_id,
19446: l_debug);
19447: