DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on WSH_DELIVERY_DETAILS_GRP

Line 1433: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(),Printing l_delivery_cnt:::'||l_delivery_cnt, l_api_name);

1429: OPEN c_delivery_cnt (p_organization_id, p_transfer_lpn_id);
1430: FETCH c_delivery_cnt INTO l_delivery_cnt;
1431: CLOSE c_delivery_cnt;
1432: IF (l_debug = 1) THEN
1433: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(),Printing l_delivery_cnt:::'||l_delivery_cnt, l_api_name);
1434: END IF;
1435: --Bug 13644027 END
1436: -- bug#10062741
1437: IF (l_drop_count = 1 AND l_delivery_cnt = 0) THEN

Line 1444: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop into 1 LPN', l_api_name);

1440: FETCH c_stg_delivery_details BULK COLLECT INTO l_line_rows;
1441: CLOSE c_stg_delivery_details;
1442:
1443: IF (l_debug = 1) THEN
1444: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop into 1 LPN', l_api_name);
1445: END IF;
1446: --
1447: -- call to the shipping API.
1448: --

Line 1449: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

1445: END IF;
1446: --
1447: -- call to the shipping API.
1448: --
1449: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(
1450: p_line_rows => l_line_rows,
1451: x_grouping_rows => l_grouping_rows,
1452: x_return_status => l_return_status);
1453: --

Line 3969: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop in the same task', l_api_name);

3965: l_line_rows(1) := c_tasks_orig_rec.delivery_detail_id;
3966: l_line_rows(2) := c_tasks_curr_rec.delivery_detail_id;
3967:
3968: IF (l_debug = 1) THEN
3969: print_debug('Before calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping() to decide if we can drop in the same task', l_api_name);
3970: print_debug('Parameters : delivery_detail_id(1):'|| l_line_rows(1) ||' , delivery_detail_id(2) :'||l_line_rows(2), l_api_name);
3971: END IF;
3972: --
3973: -- call to the shipping API.

Line 3975: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(

3971: END IF;
3972: --
3973: -- call to the shipping API.
3974: --
3975: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping(
3976: p_line_rows => l_line_rows,
3977: x_grouping_rows => l_grouping_rows,
3978: x_return_status => l_return_status);
3979: --

Line 11115: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_line_rows,

11111: AND mmtt.transfer_lpn_id= p_transfer_lpn_id
11112: AND rownum = 1 ;
11113:
11114: --call to the shipping API.
11115: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_line_rows,
11116: x_grouping_rows => l_grouping_rows,
11117: x_return_status => x_return_status);
11118: IF (l_debug = 1) THEN
11119: print_debug ('parameters : l_line_rows(1) :'||l_line_rows(1) ||',l_line_rows(2) :' || l_line_rows(2), l_api_name);