DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on WMS_PUTAWAY_SUGGESTIONS

Line 477: wms_putaway_suggestions.start_pregenerate_program(p_org_id =>i.organization_id,

473: BEGIN
474: IF (l_debug = 1) THEN
475: print_debug('Calling the pregeneration API',4);
476: END IF;
477: wms_putaway_suggestions.start_pregenerate_program(p_org_id =>i.organization_id,
478: p_lpn_id => l_lpn_id,
479: x_return_status => l_return_status,
480: x_msg_count => l_msg_count,
481: x_msg_data => l_msg_data);

Line 919: wms_putaway_suggestions.cleanup_suggestions(p_org_id=>i.organization_id,

915: IF l_pregen_putaway_tasks_flag = 1 THEN
916: IF (l_debug = 1) THEN
917: print_debug('Calling the suggestion clean up API',4);
918: END IF;
919: wms_putaway_suggestions.cleanup_suggestions(p_org_id=>i.organization_id,
920: p_lpn_id => l_lpn_id,
921: x_return_status => l_return_status,
922: x_msg_count => l_msg_count,
923: x_msg_data => l_msg_data);

Line 933: /* BUG 3646129 In WMSPRGEB.pls wms_putaway_suggestions.start_pregenerate_program() *

929: print_debug('Error while cleaning up the suggestions',2);
930: print_debug('Not calling to pregenerate the suggestions',4);
931: END IF;
932: ELSE
933: /* BUG 3646129 In WMSPRGEB.pls wms_putaway_suggestions.start_pregenerate_program() *
934: * new error conditions have been added which check for the lpn_context of lpn and *
935: * will return error if the lpn_context of the passed lpn is othere than 2 or 3 so *
936: * changes are being made to call this program only if the lpn_context is 2 or 3 */
937:

Line 943: wms_putaway_suggestions.start_pregenerate_program(p_org_id =>i.organization_id,

939: INTO l_lpn_context
940: FROM wms_license_plate_numbers
941: WHERE lpn_id = l_lpn_id;
942: IF l_lpn_context in (2,3) THEN
943: wms_putaway_suggestions.start_pregenerate_program(p_org_id =>i.organization_id,
944: p_lpn_id => l_lpn_id,
945: x_return_status => l_return_status,
946: x_msg_count => l_msg_count,
947: x_msg_data => l_msg_data);