APPS.WSH_DELIVERY_UTIL dependencies on FND_API

Line 498: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ( 'TPW', 'CMS' )) THEN

494: IF ( l_return_status <> wsh_util_core.g_ret_sts_success ) THEN
495: raise wsh_invalid_org;
496: END IF;
497: -- if the warehouse is either a Third Party Warehouse or a Carrier Manifesting System.
498: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ( 'TPW', 'CMS' )) THEN
499: open del_cur(l_source_line_id);
500: FETCH del_cur into l_dCount;
501: close del_cur;
502: IF l_dCount > 0 THEN

Line 786: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN

782: IF l_debug_on THEN
783: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
784: END IF;
785:
786: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
787: open trip_to_det_cur(x_entity_ids(l_counter));
788: Fetch trip_to_det_cur into l_tpw_temp;
789: close trip_to_det_cur;
790: IF ( l_tpw_temp is null ) THEN

Line 830: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN

826: IF l_debug_on THEN
827: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
828: END IF;
829:
830: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
831: open stop_to_det_cur(x_entity_ids(l_counter));
832: Fetch stop_to_det_cur into l_tpw_temp;
833: close stop_to_det_cur;
834: IF ( l_tpw_temp is null ) THEN

Line 871: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN

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);
869: END IF;
870:
871: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN
872: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
873: ELSE
874: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
875: END IF;

Line 907: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN

903: p_msg_display => 'N');
904: IF l_debug_on THEN
905: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
906: END IF;
907: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
908: open del_to_det_cur(x_entity_ids(l_counter));
909: Fetch del_to_det_cur into l_tpw_temp;
910: close del_to_det_cur;
911: IF ( l_tpw_temp is null ) THEN

Line 935: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN

931: p_msg_display => 'N');
932: IF l_debug_on THEN
933: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
934: END IF;
935: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
936: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
937: ELSE
938: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
939: END IF;

Line 956: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN

952: p_msg_display => 'N');
953: IF l_debug_on THEN
954: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
955: END IF;
956: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN
957: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
958: ELSE
959: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
960: END IF;

Line 973: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN

969: p_msg_display => 'N');
970: IF l_debug_on THEN
971: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
972: END IF;
973: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN
974: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
975: ELSE
976: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
977: END IF;

Line 990: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN

986: p_msg_display => 'N');
987: IF l_debug_on THEN
988: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
989: END IF;
990: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN
991: open del_to_det_cur(x_entity_ids(l_counter));
992: Fetch del_to_det_cur into l_tpw_temp;
993: close del_to_det_cur;
994: IF ( l_tpw_temp IS NULL ) THEN

Line 1021: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR ) THEN

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);
1020: END IF;
1021: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR ) THEN
1022: open det_stat_cur(x_entity_ids(l_counter));
1023: fetch det_stat_cur into l_atd_tpw_temp;
1024: close det_stat_cur;
1025: IF ( l_atd_tpw_temp IS NULL ) THEN

Line 1030: ELSIF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('CMS','TPW') ) THEN

1026: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1027: ELSE
1028: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1029: END IF;
1030: ELSIF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('CMS','TPW') ) THEN
1031: IF ( l_status_code = 'OP' ) THEN
1032: open valid_shpmnt_advice_cur(x_entity_ids(l_counter), l_organization_id);
1033: fetch valid_shpmnt_advice_cur into l_valid_shpt_advc_tmp;
1034: close valid_shpmnt_advice_cur;

Line 1058: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ( 'CMS','TPW') ) THEN

1054:
1055: IF l_debug_on THEN
1056: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
1057: END IF;
1058: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ( 'CMS','TPW') ) THEN
1059: open del_to_det_cur(x_entity_ids(l_counter));
1060: fetch del_to_det_cur into l_tpw_temp;
1061: close del_to_det_cur;
1062: IF ( l_tpw_temp IS NULL ) THEN

Line 1096: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN

1092: p_msg_display => 'N');
1093: IF l_debug_on THEN
1094: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
1095: END IF;
1096: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN
1097: raise wsh_delivery_locked;
1098: ELSE
1099: l_entity_ids := x_entity_ids;
1100: END IF;

Line 1134: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN

1130: p_msg_display => 'N');
1131: IF l_debug_on THEN
1132: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
1133: END IF;
1134: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
1135: IF ( l_source_code = 'WSH' and l_cnt_flag = 'N' ) THEN
1136: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1137: ELSE
1138: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);

Line 1155: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN

1151: p_msg_display => 'N');
1152: IF l_debug_on THEN
1153: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
1154: END IF;
1155: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
1156: open det_cur(x_entity_ids(l_counter));
1157: Fetch det_cur into l_organization_id, l_source_code, l_cnt_flag;
1158: close det_cur;
1159: IF ( l_source_code = 'WSH' and l_cnt_flag = 'N' ) THEN

Line 1174: ELSIF ( nvl(l_status_code, FND_API.G_MISS_CHAR) IN ('SR', 'SC') AND nvl(l_planned_flag,FND_API.G_MISS_CHAR) IN ('Y','F') ) THEN

1170: ELSIF ( p_action = 'SPLIT_LINE') THEN
1171: IF ( det_to_del_cur%NOTFOUND ) THEN
1172: close det_to_del_cur;
1173: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1174: ELSIF ( nvl(l_status_code, FND_API.G_MISS_CHAR) IN ('SR', 'SC') AND nvl(l_planned_flag,FND_API.G_MISS_CHAR) IN ('Y','F') ) THEN
1175: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1176: ELSE
1177: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1178: END IF;

Line 1183: ELSIF ( nvl(l_status_code, FND_API.G_MISS_CHAR) IN ('SR', 'SC', 'SA') AND nvl(l_planned_flag,FND_API.G_MISS_CHAR) IN ('Y','F') ) THEN

1179: ELSIF ( p_action = 'UNASSIGN_FROM_DELIVERY') THEN
1180: IF ( det_to_del_cur%NOTFOUND ) THEN
1181: close det_to_del_cur;
1182: l_entity_ids(l_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1183: ELSIF ( nvl(l_status_code, FND_API.G_MISS_CHAR) IN ('SR', 'SC', 'SA') AND nvl(l_planned_flag,FND_API.G_MISS_CHAR) IN ('Y','F') ) THEN
1184: l_err_entity_ids(l_err_entity_ids.COUNT + 1) := x_entity_ids(l_counter);
1185: ELSE
1186: open det_cur(x_entity_ids(l_counter));
1187: Fetch det_cur into l_organization_id, l_source_code, l_cnt_flag;

Line 1209: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ('CMS','TPW')) THEN

1205: p_msg_display => 'N');
1206: IF l_debug_on THEN
1207: wsh_debug_sv.log (l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
1208: END IF;
1209: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ('CMS','TPW')) THEN
1210: open det_cur(x_entity_ids(l_counter));
1211: Fetch det_cur into l_organization_id, l_source_code, l_cnt_flag;
1212: close det_cur;
1213: IF ( l_source_code = 'WSH' and l_cnt_flag = 'N' ) THEN