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;
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: