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 864: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

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

Line 903: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

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

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

Line 919: WSH_UTIL_CORE.G_RET_STS_WARNING) )

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

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

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

Line 950: WSH_UTIL_CORE.G_RET_STS_WARNING) )

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

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

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

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

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

Line 1074: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 1146: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

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

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

Line 1165: WSH_UTIL_CORE.G_RET_STS_WARNING) )

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

Line 1199: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 1296: l_aw_dlvy_tab WSH_UTIL_CORE.ID_TAB_TYPE;

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

Line 1297: l_aw_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

Line 1301: l_dlvy_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

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

Line 1309: l_ignoreTab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

Line 1318: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

Line 1319: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

Line 1323: l_tms_interface_flag WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

Line 1372: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 1375: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

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

Line 1378: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1692: WSH_UTIL_CORE.G_RET_STS_WARNING) )

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

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

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

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

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

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

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

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

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

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

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

Line 2136: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 2164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 2280: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

Line 2468: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 2566: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 2671: WSH_UTIL_CORE.G_RET_STS_WARNING) )

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

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

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

Line 2714: WSH_UTIL_CORE.G_RET_STS_WARNING) )

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

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

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

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

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

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

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

Line 2884: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3968: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;

3964: --
3965: -- Check whether FTE is Installed
3966: --
3967: IF ( G_FTE_INSTALLED IS NULL ) THEN
3968: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;
3969: END IF;
3970: -- LSP PROJECT : Check for LSP clients.
3971: WSH_CUST_MERGE.Check_Lsp_Install( Req_Id, Set_Num, Process_Mode ); -- ADDED
3972: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED