eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CUST_MERGE dependencies on WSH_UTIL_CORE

Line 107: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

103: l_debug_on BOOLEAN;
104: --
105: BEGIN
106:
107: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
108: --
109: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
110: --
111: IF l_debug_on IS NULL

Line 180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

176: --
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: --
182: IF l_debug_on THEN
183: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Insert_Log_Table()+ Others - ' || getTimeStamp);
184: ARP_MESSAGE.Set_Error('Eror Mesg : ' || sqlerrm );

Line 223: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;

219: p_gross_weight IN g_number_tbl_type,
220: p_volume IN g_number_tbl_type,
221: x_return_status OUT NOCOPY VARCHAR2 )
222: IS
223: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
224: l_return_status VARCHAR2(10);
225:
226: Weight_Volume_Exp EXCEPTION;
227:

Line 266: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

262: p_entity_type => 'DELIVERY',
263: p_entity_ids => l_del_tab,
264: x_return_status => l_return_status);
265:
266: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
267: WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
268: --
269: IF ( l_debug_on ) THEN
270: ARP_MESSAGE.Set_Error('API WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required returned error');

Line 267: WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN

263: p_entity_ids => l_del_tab,
264: x_return_status => l_return_status);
265:
266: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
267: WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
268: --
269: IF ( l_debug_on ) THEN
270: ARP_MESSAGE.Set_Error('API WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required returned error');
271: END IF;

Line 309: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

305: p_diff_fill_volume => -1 * p_volume(wvCnt),
306: p_check_for_empty => 'Y',
307: x_return_status => l_return_status );
308:
309: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
310: WSH_UTIL_CORE.G_RET_STS_WARNING) )
311: THEN
312: --
313: IF ( l_debug_on ) THEN

Line 310: WSH_UTIL_CORE.G_RET_STS_WARNING) )

306: p_check_for_empty => 'Y',
307: x_return_status => l_return_status );
308:
309: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
310: WSH_UTIL_CORE.G_RET_STS_WARNING) )
311: THEN
312: --
313: IF ( l_debug_on ) THEN
314: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.DD_WV_Post_Process returned error');

Line 340: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

336: p_check_for_empty => 'Y',
337: p_leg_id => p_delivery_leg_id(wvCnt),
338: x_return_status => l_return_status);
339:
340: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
341: WSH_UTIL_CORE.G_RET_STS_WARNING) )
342: THEN
343: --
344: IF ( l_debug_on ) THEN

Line 341: WSH_UTIL_CORE.G_RET_STS_WARNING) )

337: p_leg_id => p_delivery_leg_id(wvCnt),
338: x_return_status => l_return_status);
339:
340: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
341: WSH_UTIL_CORE.G_RET_STS_WARNING) )
342: THEN
343: --
344: IF ( l_debug_on ) THEN
345: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.Del_WV_Post_Process returned error');

Line 465: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

461: p_organization_id => p_organization_id(wvCnt),
462: x_param_info => l_param_info,
463: x_return_status => l_return_status);
464:
465: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
466: --
467: IF ( l_debug_on ) THEN
468: ARP_MESSAGE.Set_Error('API WSH_SHIPPING_PARAMS_PVT.Get returned error');
469: END IF;

Line 495: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

491: p_vol_uom_code => p_volume_uom(wvCnt),
492: p_inv_item_id => p_inventory_item_id(wvCnt),
493: x_return_status => l_return_status);
494:
495: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
496: WSH_UTIL_CORE.G_RET_STS_WARNING) )
497: THEN
498: --
499: IF ( l_debug_on ) THEN

Line 496: WSH_UTIL_CORE.G_RET_STS_WARNING) )

492: p_inv_item_id => p_inventory_item_id(wvCnt),
493: x_return_status => l_return_status);
494:
495: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
496: WSH_UTIL_CORE.G_RET_STS_WARNING) )
497: THEN
498: --
499: IF ( l_debug_on ) THEN
500: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.Adjust_Parent_WV returned error');

Line 668: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

664:
665: Unassign_Del_Exp EXCEPTION;
666:
667: -- OTM R12 : unassign delivery detail
668: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
669: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
670: l_ignoreForPlanningTab g_char_tbl_type;
671: l_is_delivery_empty VARCHAR2(1);
672: l_index NUMBER;

Line 669: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

665: Unassign_Del_Exp EXCEPTION;
666:
667: -- OTM R12 : unassign delivery detail
668: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
669: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
670: l_ignoreForPlanningTab g_char_tbl_type;
671: l_is_delivery_empty VARCHAR2(1);
672: l_index NUMBER;
673: l_count NUMBER;

Line 694: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

690: arp_message.set_line('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+' || getTimeStamp );
691: END IF;
692: --
693:
694: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
695:
696: -- OTM R12
697: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
698:

Line 697: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

693:
694: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
695:
696: -- OTM R12
697: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
698:
699: IF (l_gc3_is_installed IS NULL) THEN
700: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
701: END IF;

Line 700: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

696: -- OTM R12
697: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
698:
699: IF (l_gc3_is_installed IS NULL) THEN
700: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
701: END IF;
702: -- End of OTM R12
703:
704: OPEN Get_Cont_Unassign_Details (

Line 784: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

780: p_gross_weight => l_grossWeightTab,
781: p_volume => l_volumeTab,
782: x_return_status => l_return_status );
783:
784: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
785: WSH_UTIL_CORE.G_RET_STS_WARNING) )
786: THEN
787: --
788: IF ( l_debug_on ) THEN

Line 785: WSH_UTIL_CORE.G_RET_STS_WARNING) )

781: p_volume => l_volumeTab,
782: x_return_status => l_return_status );
783:
784: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
785: WSH_UTIL_CORE.G_RET_STS_WARNING) )
786: THEN
787: --
788: IF ( l_debug_on ) THEN
789: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');

Line 830: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

826: -- entries with the same delivery id if l_deliveryIdTab does
827:
828: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_deliveryIdTab(l_index));
829:
830: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
831: IF ( l_debug_on ) THEN
832: ARP_MESSAGE.Set_Error('Error returned from API wsh_new_delivery_actions.is_delivery_empty');
833: END IF;
834: raise FND_API.G_EXC_ERROR;

Line 867: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

863: p_delivery_id_tab => l_delivery_id_tab,
864: p_tms_interface_flag_tab => l_interface_flag_tab,
865: x_return_status => l_return_status);
866:
867: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
868: --
869: IF l_debug_on THEN
870: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
871: END IF;

Line 906: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

902: FETCH Get_Grouping_Id INTO l_carton_grouping_id;
903: IF ( Get_Grouping_Id%NOTFOUND )
904: THEN
905: ARP_MESSAGE.Set_Error('Not able to fetch carton_grouping_id');
906: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
907: CLOSE Get_Grouping_Id;
908: --
909: RAISE Unassign_Del_Exp;
910: --

Line 921: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

917: x_msg_data => l_msg_data,
918: p_line_id => l_moveOrderLineIdTab(wmsCnt),
919: p_carton_grouping_id => l_carton_grouping_id );
920:
921: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
922: WSH_UTIL_CORE.G_RET_STS_WARNING) )
923: THEN
924: --
925: IF ( l_debug_on ) THEN

Line 922: WSH_UTIL_CORE.G_RET_STS_WARNING) )

918: p_line_id => l_moveOrderLineIdTab(wmsCnt),
919: p_carton_grouping_id => l_carton_grouping_id );
920:
921: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
922: WSH_UTIL_CORE.G_RET_STS_WARNING) )
923: THEN
924: --
925: IF ( l_debug_on ) THEN
926: ARP_MESSAGE.Set_Error('Error returned from API INV_MO_Cancel_PVT.Update_Mol_Carton_Group');

Line 952: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

948: p_weight_uom => l_weightUomTab,
949: p_volume_uom => l_volumeUomTab,
950: x_return_status => l_return_status );
951:
952: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
953: WSH_UTIL_CORE.G_RET_STS_WARNING) )
954: THEN
955: --
956: IF ( l_debug_on ) THEN

Line 953: WSH_UTIL_CORE.G_RET_STS_WARNING) )

949: p_volume_uom => l_volumeUomTab,
950: x_return_status => l_return_status );
951:
952: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
953: WSH_UTIL_CORE.G_RET_STS_WARNING) )
954: THEN
955: --
956: IF ( l_debug_on ) THEN
957: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Parent_WV');

Line 981: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

977: p_table_name => 'WSH_DELIVERY_ASSIGNMENTS',
978: p_req_id => p_req_id,
979: x_return_status => l_return_status );
980:
981: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
982: THEN
983: Raise Unassign_Del_Exp;
984: END IF;
985: END IF;

Line 1035: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1031: p_delivery_name => l_deliveryNameTab(expCnt),
1032: p_error_message => l_message_text
1033: );
1034:
1035: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1036: THEN
1037: ARP_MESSAGE.Set_Error('API WSH_XC_UTIL.Log_Exception returned error..');
1038: RAISE Unassign_Del_Exp;
1039: END IF;

Line 1077: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1073: CLOSE Get_Grouping_Id;
1074: END IF;
1075: --
1076: WHEN OTHERS THEN
1077: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1078: --
1079: IF ( l_debug_on ) THEN
1080: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+ Others - ' || getTimeStamp );
1081: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

Line 1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1145: arp_message.set_line('WSH_CUST_MERGE.Get_Delivery_Hash()+' || getTimeStamp );
1146: END IF;
1147: --
1148:
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1150: l_hash_count := 0;
1151:
1152: FOR i IN Get_Tmp_Deliveries
1153: LOOP

Line 1167: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

1163: p_group_by_header => 'N',
1164: p_action_code => l_action_code,
1165: x_return_status => l_return_status );
1166:
1167: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1168: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1169: THEN
1170: --
1171: IF ( l_debug_on ) THEN

Line 1168: WSH_UTIL_CORE.G_RET_STS_WARNING) )

1164: p_action_code => l_action_code,
1165: x_return_status => l_return_status );
1166:
1167: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1168: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1169: THEN
1170: --
1171: IF ( l_debug_on ) THEN
1172: ARP_MESSAGE.Set_Error('Error returned from API Create_Hash');

Line 1202: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1198: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Get_Delivery_Hash()+ Update_Hash_Exp - ' || getTimeStamp );
1199: END IF;
1200: --
1201: WHEN OTHERS THEN
1202: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1203: --
1204: IF ( l_debug_on ) THEN
1205: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Get_Delivery_Hash()+ Others - ' || getTimeStamp );
1206: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

Line 1299: l_aw_dlvy_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1295: AND freight_cost_type_code = 'FREIGHT';
1296:
1297: l_trip_id NUMBER;
1298: l_trip_status WSH_TRIPS.STATUS_CODE%TYPE;
1299: l_aw_dlvy_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1300: l_aw_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1301: l_frcost_type_id NUMBER;
1302:
1303: l_skip VARCHAR2(1);

Line 1300: l_aw_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1296:
1297: l_trip_id NUMBER;
1298: l_trip_status WSH_TRIPS.STATUS_CODE%TYPE;
1299: l_aw_dlvy_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1300: l_aw_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1301: l_frcost_type_id NUMBER;
1302:
1303: l_skip VARCHAR2(1);
1304: l_dlvy_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1304: l_dlvy_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1300: l_aw_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1301: l_frcost_type_id NUMBER;
1302:
1303: l_skip VARCHAR2(1);
1304: l_dlvy_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1305: l_gc3_is_installed VARCHAR2(1);
1306:
1307: frcost_not_found EXCEPTION;
1308: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

Line 1312: l_ignoreTab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1308: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1309: l_tms_trip_tab WSH_DELIVERY_VALIDATIONS.trip_info_tab_type;
1310: l_new_delivery_leg_tab g_rowid_tbl_type;
1311: l_delivery_leg_count NUMBER;
1312: l_ignoreTab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1313: l_tms_count NUMBER;
1314: l_tms_delivery_id_tab g_number_tbl_type;
1315:
1316: -- End of OTM R12 : customer merge

Line 1321: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1317:
1318: -- OTM R12 : update delivery
1319: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1320: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1321: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1322: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1323: l_trip_not_found VARCHAR2(1);
1324: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
1325: l_tms_version_number g_number_tbl_type;

Line 1322: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1318: -- OTM R12 : update delivery
1319: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1320: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1321: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1322: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1323: l_trip_not_found VARCHAR2(1);
1324: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
1325: l_tms_version_number g_number_tbl_type;
1326: l_tms_interface_flag WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 1326: l_tms_interface_flag WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1322: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1323: l_trip_not_found VARCHAR2(1);
1324: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
1325: l_tms_version_number g_number_tbl_type;
1326: l_tms_interface_flag WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1327: l_index NUMBER;
1328: l_delivery_count NUMBER;
1329: -- End of OTM R12 : update delivery
1330:

Line 1375: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1371: arp_message.set_line('WSH_CUST_MERGE.Process_Deliveries()+' || getTimeStamp );
1372: END IF;
1373: --
1374:
1375: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1376:
1377: -- OTM R12
1378: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1379:

Line 1378: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

1374:
1375: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1376:
1377: -- OTM R12
1378: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1379:
1380: IF (l_gc3_is_installed IS NULL) THEN
1381: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
1382: END IF;

Line 1381: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

1377: -- OTM R12
1378: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1379:
1380: IF (l_gc3_is_installed IS NULL) THEN
1381: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
1382: END IF;
1383: -- End of OTM R12
1384:
1385: OPEN Get_Delivery_Containers;

Line 1431: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1427: p_table_name => 'WSH_DELIVERY_DETAILS',
1428: p_req_id => p_req_id,
1429: x_return_status => l_return_status );
1430:
1431: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1432: THEN
1433: Raise Update_Del_Exp;
1434: END IF;
1435: END IF;

Line 1456: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1452: x_hash_value_tab => l_hash_value_tab,
1453: x_delivery_id_tab => l_delivery_id_tab,
1454: x_return_status => l_return_status );
1455:
1456: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1457: THEN
1458: Raise Update_Del_Exp;
1459: END IF;
1460:

Line 1499: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1495: p_delivery_id => l_delivery_id_tab(l_index),
1496: x_delivery_rec => l_delivery_info,
1497: x_return_status => l_return_status);
1498:
1499: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1500: x_return_status := l_return_status;
1501: RETURN;
1502: END IF;
1503:

Line 1512: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1508: (p_delivery_id => l_delivery_id_tab(l_index),
1509: x_trip_info_rec => l_trip_info_rec,
1510: x_return_status => l_return_status);
1511:
1512: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1513: x_return_status := l_return_status;
1514: RETURN;
1515: END IF;
1516:

Line 1621: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1617: p_delivery_info_tab => l_delivery_info_tab,
1618: p_new_interface_flag_tab => l_new_interface_flag_tab,
1619: x_return_status => l_return_status);
1620:
1621: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1622: x_return_status := l_return_status;
1623: RETURN;
1624: END IF;
1625: END IF;

Line 1647: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1643: p_table_name => 'WSH_NEW_DELIVERIES',
1644: p_req_id => p_req_id,
1645: x_return_status => l_return_status );
1646:
1647: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1648: THEN
1649: Raise Update_Del_Exp;
1650: END IF;
1651: -- } Profile Value

Line 1694: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

1690: p_gross_weight => l_grossWeightTab,
1691: p_volume => l_volumeTab,
1692: x_return_status => l_return_status );
1693:
1694: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1695: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1696: THEN
1697: --
1698: IF ( l_debug_on ) THEN

Line 1695: WSH_UTIL_CORE.G_RET_STS_WARNING) )

1691: p_volume => l_volumeTab,
1692: x_return_status => l_return_status );
1693:
1694: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1695: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1696: THEN
1697: --
1698: IF ( l_debug_on ) THEN
1699: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');

Line 1807: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1803: p_delivery_id => l_tms_delivery_id_tab(l_index),
1804: x_delivery_rec => l_delivery_info,
1805: x_return_status => l_return_status);
1806:
1807: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1808: x_return_status := l_return_status;
1809: RETURN;
1810: END IF;
1811:

Line 1820: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1816: (p_delivery_id => l_tms_delivery_id_tab(l_index),
1817: x_trip_info_rec => l_trip_info_rec,
1818: x_return_status => l_return_status);
1819:
1820: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1821: x_return_status := l_return_status;
1822: RETURN;
1823: END IF;
1824:

Line 1929: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1925: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
1926: p_delivery_id_tab => l_aw_dlvy_tab,
1927: p_tms_interface_flag_tab => l_aw_interface_flag_tab,
1928: x_return_status => l_return_status);
1929: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1930: IF l_debug_on THEN
1931: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
1932: END IF;
1933: RAISE Update_Del_Exp;

Line 2043: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2039: p_trip_stop_id => l_stopIdTab(ExpCnt),
2040: p_error_message => l_message_text
2041: );
2042:
2043: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2044: THEN
2045: RAISE Update_Del_Exp;
2046: END IF;
2047: END IF; -- OTM R12 : customer merge

Line 2098: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2094: p_table_name => 'WSH_TRIP_STOPS',
2095: p_req_id => p_req_id,
2096: x_return_status => l_return_status );
2097:
2098: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2099: THEN
2100: Raise Update_Del_Exp;
2101: END IF;
2102: END IF;

Line 2139: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2135: END IF;
2136: -- End of OTM R12 : customer merge
2137: -- OTM R12 : customer merge
2138: WHEN frcost_not_found THEN
2139: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2140: --
2141: IF ( l_debug_on ) THEN
2142: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ OTM Freight cost type not defined- ' || getTimeStamp );
2143: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

Line 2167: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2163: CLOSE Get_Del_Unassign_From_Stop;
2164: END IF;
2165: -- End of OTM R12 : customer merge
2166: WHEN OTHERS THEN
2167: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2168: --
2169: IF ( l_debug_on ) THEN
2170: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ Others - ' || getTimeStamp );
2171: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

Line 2283: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2279: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Deliveries()+' || getTimeStamp );
2280: END IF;
2281: --
2282:
2283: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2284:
2285: OPEN Get_Empty_Deliveries ( G_FROM_CUSTOMER_ID,
2286: G_FROM_LOCATION_ID );
2287:

Line 2333: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2329: p_table_name => 'WSH_NEW_DELIVERIES',
2330: p_req_id => p_req_id,
2331: x_return_status => l_return_status );
2332:
2333: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2334: THEN
2335: RAISE Process_Deliveries_Exp;
2336: END IF;
2337: END IF;

Line 2396: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2392: p_table_name => 'WSH_NEW_DELIVERIES',
2393: p_req_id => p_req_id,
2394: x_return_status => l_return_status );
2395:
2396: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2397: THEN
2398: RAISE Process_Deliveries_Exp;
2399: END IF;
2400: END IF;

Line 2435: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2431: p_table_name => 'WSH_DELIVERY_DETAILS',
2432: p_req_id => p_req_id,
2433: x_return_status => l_return_status );
2434:
2435: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2436: THEN
2437: RAISE Process_Deliveries_Exp;
2438: END IF;
2439: END IF;

Line 2471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2467: CLOSE Get_Empty_Cont_Delivery;
2468: END IF;
2469: --
2470: WHEN OTHERS THEN
2471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2472: --
2473: IF ( l_debug_on ) THEN
2474: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Deliveries()+ Others - ' || getTimeStamp );
2475: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

Line 2569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2565: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Lines()+' || getTimeStamp );
2566: END IF;
2567: --
2568:
2569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2570:
2571: -- Processing open lines in shipping
2572: OPEN Get_Open_Lines ( G_FROM_CUSTOMER_ID,
2573: G_FROM_CUST_SITE_ID,

Line 2645: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2641: p_table_name => 'WSH_DELIVERY_DETAILS',
2642: p_req_id => p_req_id,
2643: x_return_status => l_return_status );
2644:
2645: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2646: THEN
2647: RAISE Process_Open_Lines_Exp;
2648: END IF;
2649: END IF;

Line 2673: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

2669: p_gross_weight => l_grossWeightTab,
2670: p_volume => l_volumeTab,
2671: x_return_status => l_return_status );
2672:
2673: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2674: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2675: THEN
2676: --
2677: IF ( l_debug_on ) THEN

Line 2674: WSH_UTIL_CORE.G_RET_STS_WARNING) )

2670: p_volume => l_volumeTab,
2671: x_return_status => l_return_status );
2672:
2673: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2674: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2675: THEN
2676: --
2677: IF ( l_debug_on ) THEN
2678: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');

Line 2716: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

2712: p_weight_uom => l_weightUomTab,
2713: p_volume_uom => l_volumeUomTab,
2714: x_return_status => l_return_status );
2715:
2716: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2717: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2718: THEN
2719: --
2720: IF ( l_debug_on ) THEN

Line 2717: WSH_UTIL_CORE.G_RET_STS_WARNING) )

2713: p_volume_uom => l_volumeUomTab,
2714: x_return_status => l_return_status );
2715:
2716: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2717: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2718: THEN
2719: --
2720: IF ( l_debug_on ) THEN
2721: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Parent_WV');

Line 2775: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2771: p_delivery_detail_id => l_parentDeliveryDetailIdTab(expCnt),
2772: p_error_message => l_message_text
2773: );
2774:
2775: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2776: THEN
2777: ARP_MESSAGE.Set_Error('Error returned from API WSH_XC_UTIL.Log_Exception');
2778: RAISE Process_Open_Lines_Exp;
2779: END IF;

Line 2830: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2826: Unassign_Details_From_Delivery (
2827: p_req_id => p_req_id,
2828: x_return_status => l_return_status );
2829:
2830: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2831: THEN
2832: RAISE Process_Open_Lines_Exp;
2833: END IF;
2834:

Line 2845: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2841: Process_Deliveries (
2842: p_req_id => p_req_id,
2843: x_return_status => l_return_status );
2844:
2845: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2846: THEN
2847: RAISE Process_Open_Lines_Exp;
2848: END IF;
2849: END IF;

Line 2887: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2883: IF ( Get_Open_Lines%ISOPEN ) THEN
2884: CLOSE Get_Open_Lines;
2885: END IF;
2886:
2887: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2888: END Process_Open_Lines;
2889:
2890: -----------------------------------------------------------------------------------------
2891: --

Line 3029: l_old_location_id := WSH_UTIL_CORE.Cust_Site_To_Location(l_fromCustomerSiteIdTab(i));

3025: -- { Main Loop
3026: -- Get Locations of the old/duplicate Site Use ID
3027: --
3028: BEGIN
3029: l_old_location_id := WSH_UTIL_CORE.Cust_Site_To_Location(l_fromCustomerSiteIdTab(i));
3030: EXCEPTION
3031: WHEN NO_DATA_FOUND then
3032: raise wsh_cust_site_to_loc_err;
3033: WHEN OTHERS then

Line 3042: l_new_location_id := WSH_UTIL_CORE.Cust_Site_To_Location(l_toCustomerSiteIdTab(i));

3038: --
3039: -- Get Locations of the new Site Use ID
3040: --
3041: BEGIN
3042: l_new_location_id := WSH_UTIL_CORE.Cust_Site_To_Location(l_toCustomerSiteIdTab(i));
3043: EXCEPTION
3044: WHEN NO_DATA_FOUND then
3045: raise wsh_cust_site_to_loc_err;
3046: WHEN OTHERS then

Line 3116: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

3112: p_table_name => 'WSH_DELIVERY_DETAILS',
3113: p_req_id => req_id,
3114: x_return_status => l_return_status );
3115:
3116: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3117: THEN
3118: RAISE Merge_Exp;
3119: END IF;
3120: END IF;

Line 3179: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

3175: p_table_name => 'WSH_DELIVERY_DETAILS',
3176: p_req_id => req_id,
3177: x_return_status => l_return_status );
3178:
3179: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3180: THEN
3181: --
3182: IF ( l_debug_on ) THEN
3183: ARP_MESSAGE.Set_Error('Error returned from API Insert_Log_Table');

Line 3206: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

3202: Process_Open_Lines (
3203: p_req_id => req_id,
3204: x_return_status => l_return_status );
3205:
3206: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3207: THEN
3208: --
3209: IF ( l_debug_on ) THEN
3210: ARP_MESSAGE.Set_Error('Error returned from API Process_Open_Lines');

Line 3225: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

3221: Process_Open_Deliveries (
3222: p_req_id => req_id,
3223: x_return_status => l_return_status );
3224:
3225: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3226: THEN
3227: --
3228: IF ( l_debug_on ) THEN
3229: ARP_MESSAGE.Set_Error('Error returned from API Process_Open_Deliveries');

Line 3762: AND wdd.ship_to_location_id = WSH_UTIL_CORE.Cust_Site_To_Location( duplicate_site_id )

3758: AND wda.parent_delivery_detail_id IS NOT NULL
3759: -- AND wda.delivery_id IS NULL
3760: AND wda.delivery_detail_id = wdd.delivery_detail_id
3761: AND wdd.customer_id = rcm.duplicate_id
3762: AND wdd.ship_to_location_id = WSH_UTIL_CORE.Cust_Site_To_Location( duplicate_site_id )
3763: AND wdd.container_flag = 'N'
3764: -- AND wdd.released_status IN ( 'R', 'N', 'X', 'Y', 'S', 'B' )
3765: AND wdd.released_status = 'Y'
3766: AND rcm.customer_site_code = 'SHIP_TO'

Line 3872: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;

3868: --
3869: -- Check whether FTE is Installed
3870: --
3871: IF ( G_FTE_INSTALLED IS NULL ) THEN
3872: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;
3873: END IF;
3874:
3875: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );