APPS.WSH_DELIVERY_UTIL dependencies on WSH_EXTERNAL_INTERFACE_SV

Line 486: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

482: Fetch det_org_cur into l_organization_id, l_delivery_detail_id;
483:
484: IF ( det_org_cur%FOUND ) THEN
485: close det_org_cur;
486: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
487: x_return_status => l_return_status,
488: p_delivery_detail_id => l_delivery_detail_id);
489:
490: IF l_debug_on THEN

Line 778: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

774:
775: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y', 'F') ) THEN
776: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
777: ELSE
778: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
779: x_return_status => l_return_status,
780: p_delivery_id => l_delivery_id,
781: p_msg_display => 'N');
782: IF l_debug_on THEN

Line 821: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

817:
818: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y', 'F') ) THEN
819: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
820: ELSE
821: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
822: x_return_status => l_return_status,
823: p_delivery_id => l_delivery_id,
824: p_msg_display => 'N');
825:

Line 864: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

860:
861: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y','F') ) THEN
862: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
863: ELSE
864: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
865: x_return_status => l_return_status,
866: p_delivery_id => l_delivery_id);
867: IF l_debug_on THEN
868: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);

Line 900: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

896:
897: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y','F') ) THEN
898: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
899: ELSE
900: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
901: x_return_status => l_return_status,
902: p_delivery_id => x_entity_ids(l_counter),
903: p_msg_display => 'N');
904: IF l_debug_on THEN

Line 928: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

924: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
925: END IF;
926: ELSIF ( p_action ='GEN_LOAD_SEQ' ) THEN
927: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y','F') ) THEN
928: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
929: x_return_status => l_return_status,
930: p_delivery_id => x_entity_ids(l_counter),
931: p_msg_display => 'N');
932: IF l_debug_on THEN

Line 949: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

945: open del_to_det_cur(x_entity_ids(l_counter));
946: Fetch del_to_det_cur into l_tpw_temp;
947: close del_to_det_cur;
948: IF ( l_tpw_temp is null ) THEN
949: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
950: x_return_status => l_return_status,
951: p_delivery_id => x_entity_ids(l_counter),
952: p_msg_display => 'N');
953: IF l_debug_on THEN

Line 966: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

962: ELSE
963: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
964: END IF;
965: ELSE
966: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
967: x_return_status => l_return_status,
968: p_delivery_id => x_entity_ids(l_counter),
969: p_msg_display => 'N');
970: IF l_debug_on THEN

Line 983: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

979: ELSIF ( p_action ='SHIP_CONFIRM' ) THEN
980: IF ( l_status_code IN ( 'SR', 'SC' )) THEN
981: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
982: ELSE
983: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
984: x_return_status => l_return_status,
985: p_delivery_id => x_entity_ids(l_counter),
986: p_msg_display => 'N');
987: IF l_debug_on THEN

Line 1015: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

1011: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1012: END IF;
1013: END IF;
1014: ELSIF ( p_action IN ('OUTBOUND_DOCUMENT','TRANSACTION_HISTORY') ) THEN
1015: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
1016: x_return_status => l_return_status,
1017: p_delivery_id => x_entity_ids(l_counter));
1018: IF l_debug_on THEN
1019: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);

Line 1050: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

1046: ELSIF ( p_action IN ('AUTO_CREATE_TRIP','ASSIGN_TO_TRIP')) THEN
1047: IF ( l_status_code = 'SA' ) THEN
1048: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1049: ELSE
1050: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
1051: x_return_status => l_return_status,
1052: p_delivery_id => x_entity_ids(l_counter),
1053: p_msg_display => 'N');
1054:

Line 1089: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

1085: END IF;
1086: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y','F') ) THEN
1087: raise wsh_delivery_locked;
1088: ELSE
1089: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
1090: x_return_status => l_return_status,
1091: p_delivery_id => x_entity_ids(l_counter),
1092: p_msg_display => 'N');
1093: IF l_debug_on THEN

Line 1126: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

1122: close det_to_del_cur;
1123: open det_cur(x_entity_ids(l_counter));
1124: Fetch det_cur into l_organization_id, l_source_code, l_cnt_flag;
1125: close det_cur;
1126: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
1127: x_return_status => l_return_status,
1128: p_delivery_id => l_delivery_id,
1129: p_delivery_detail_id => x_entity_ids(l_counter),
1130: p_msg_display => 'N');

Line 1147: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

1143: ELSE
1144: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y','F') ) THEN
1145: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1146: ELSE
1147: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
1148: x_return_status => l_return_status,
1149: p_delivery_id => l_delivery_id,
1150: p_delivery_detail_id => x_entity_ids(l_counter),
1151: p_msg_display => 'N');

Line 1201: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,

1197: close det_to_del_cur;
1198: open det_cur(x_entity_ids(l_counter));
1199: Fetch det_cur into l_organization_id, l_source_code, l_cnt_flag;
1200: close det_cur;
1201: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => l_organization_id,
1202: x_return_status => l_return_status,
1203: p_delivery_id => l_delivery_id,
1204: p_delivery_detail_id => x_entity_ids(l_counter),
1205: p_msg_display => 'N');