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_INTERFACE_COMMON_ACTIONS dependencies on WSH_UTIL_CORE

Line 293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

289: wsh_debug_sv.log (l_module_name,'parent_delivery_detail_id ',p_parent_delivery_detail_id);
290: wsh_debug_sv.log (l_module_name,'parent_detail_interface_id ',p_parent_detail_interface_id);
291: END IF;
292:
293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
294:
295: UPDATE wsh_del_assgn_interface
296: SET parent_detail_interface_id = p_parent_detail_interface_id
297: WHERE parent_delivery_detail_id = p_parent_delivery_detail_id;

Line 312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

308: EXCEPTION
309:
310: WHEN Others THEN
311:
312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
313: IF l_debug_on THEN
314: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
315: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 360: l_detail_tab WSH_UTIL_CORE.id_tab_type;

356: x_return_status OUT NOCOPY VARCHAR2) IS
357:
358: -- procedure specific variables
359: -- TPW - Distributed changes - Starts
360: l_detail_tab WSH_UTIL_CORE.id_tab_type;
361: l_organization_tab WSH_UTIL_CORE.id_tab_type;
362: l_wf_rs VARCHAR2(1);
363: l_dbi_rs VARCHAR2(1);
364: -- TPW - Distributed changes - Ends

Line 361: l_organization_tab WSH_UTIL_CORE.id_tab_type;

357:
358: -- procedure specific variables
359: -- TPW - Distributed changes - Starts
360: l_detail_tab WSH_UTIL_CORE.id_tab_type;
361: l_organization_tab WSH_UTIL_CORE.id_tab_type;
362: l_wf_rs VARCHAR2(1);
363: l_dbi_rs VARCHAR2(1);
364: -- TPW - Distributed changes - Ends
365: l_return_status VARCHAR2(30);

Line 395: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

391: wsh_debug_sv.log (l_module_name,'New Delivery Id', p_new_delivery_id);
392: wsh_debug_sv.log (l_module_name,'Action Code ',p_action_code);
393: END IF;
394:
395: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
396:
397: IF(p_delivery_interface_id IS NULL) THEN
398: raise invalid_input;
399: END IF;

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

416: IF l_debug_on THEN
417: wsh_debug_sv.log (l_module_name, 'Return Status from Process_Non_Splits', l_return_status);
418: END IF;
419:
420: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
422: END IF;
423:
424: IF(p_action_code = 'UPDATE') THEN

Line 421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

417: wsh_debug_sv.log (l_module_name, 'Return Status from Process_Non_Splits', l_return_status);
418: END IF;
419:
420: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
422: END IF;
423:
424: IF(p_action_code = 'UPDATE') THEN
425: Process_Splits(

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

431: IF l_debug_on THEN
432: wsh_debug_sv.log (l_module_name, 'Return Status from Process Splits', l_return_status);
433: END IF;
434:
435: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
437: END IF;
438:
439: -- TPW - Distributed changes - Start

Line 436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

432: wsh_debug_sv.log (l_module_name, 'Return Status from Process Splits', l_return_status);
433: END IF;
434:
435: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
437: END IF;
438:
439: -- TPW - Distributed changes - Start
440: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') in ( 'TPW', 'TW2')) THEN

Line 491: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

487: --
488: IF l_debug_on THEN
489: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
490: END IF;
491: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
492: -- just pass this return status to caller API
493: -- this is a pre-defined exception handled in parent EXCEPTIONS block
494: -- x_return_status is set as Unexpected in exceptions handler
495: RAISE others_dbi;

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

507: and status_code IN ('OP','SR','SC');
508: END IF;
509: -- TPW - Distributed changes - End
510:
511: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
512: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
513: END IF;
514:
515: IF l_debug_on THEN

Line 512: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

508: END IF;
509: -- TPW - Distributed changes - End
510:
511: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
512: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
513: END IF;
514:
515: IF l_debug_on THEN
516: wsh_debug_sv.log (l_module_name, 'Packing Table Count', G_Packing_Detail_Tab.count);

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

522: IF l_debug_on THEN
523: wsh_debug_sv.log (l_module_name, 'Return Status from Pack Lines', l_return_status);
524: END IF;
525:
526: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
527: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
528: END IF;
529: END IF;
530:

Line 527: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

523: wsh_debug_sv.log (l_module_name, 'Return Status from Pack Lines', l_return_status);
524: END IF;
525:
526: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
527: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
528: END IF;
529: END IF;
530:
531: Update_Delivery_Details(

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

539:
540: -- TPW - Distributed changes - Inv. Rsv API Integration Changes
541: -- Identified during Inventory Integration testing
542: -- Handling Return status of API Update_Delivery_Details
543: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
545: END IF;
546:
547: IF l_debug_on THEN

Line 544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

540: -- TPW - Distributed changes - Inv. Rsv API Integration Changes
541: -- Identified during Inventory Integration testing
542: -- Handling Return status of API Update_Delivery_Details
543: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
545: END IF;
546:
547: IF l_debug_on THEN
548: wsh_debug_sv.pop(l_module_name);

Line 553: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

549: END IF;
550:
551: EXCEPTION
552: WHEN invalid_action_code THEN
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
557: END IF;

Line 559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

555: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
557: END IF;
558: WHEN invalid_input THEN
559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
560: IF l_debug_on THEN
561: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
563: END IF;

Line 566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
563: END IF;
564: -- TPW - Distributed changes
565: WHEN others_dbi THEN
566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.logmsg(l_module_name,'others_dbi exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_dbi');
570: END IF;

Line 572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

568: WSH_DEBUG_SV.logmsg(l_module_name,'others_dbi exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_dbi');
570: END IF;
571: WHEN Others THEN
572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
575: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 589: l_new_detail_ids WSH_UTIL_CORE.Id_Tab_Type;

585: p_action_code IN VARCHAR2,
586: x_return_status OUT NOCOPY VARCHAR2) IS
587: -- local variables
588: l_new_del_detail_id NUMBER;
589: l_new_detail_ids WSH_UTIL_CORE.Id_Tab_Type;
590: l_table_count NUMBER;
591: l_return_status VARCHAR2(30);
592:
593: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

Line 688: l_cont_tab wsh_util_core.id_tab_type;

684: l_msg_details varchar2(2000);
685: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
686:
687: -- K LPN CONV. rv
688: l_cont_tab wsh_util_core.id_tab_type;
689: l_lpn_unit_weight NUMBER;
690: l_lpn_unit_volume NUMBER;
691: l_lpn_weight_uom_code VARCHAR2(100);
692: l_lpn_volume_uom_code VARCHAR2(100);

Line 703: l_detail_id_tab wsh_util_core.id_tab_type;

699: l_req_qty number;
700: l_pending_req_qty number;
701: l_pending_shp_qty number;
702: l_curr_index number;
703: l_detail_id_tab wsh_util_core.id_tab_type;
704: l_detail_qty_tab wsh_util_core.id_tab_type;
705: l_number_of_errors NUMBER := 0;
706: l_number_of_warnings NUMBER := 0;
707: l_serial_number_control NUMBER;

Line 704: l_detail_qty_tab wsh_util_core.id_tab_type;

700: l_pending_req_qty number;
701: l_pending_shp_qty number;
702: l_curr_index number;
703: l_detail_id_tab wsh_util_core.id_tab_type;
704: l_detail_qty_tab wsh_util_core.id_tab_type;
705: l_number_of_errors NUMBER := 0;
706: l_number_of_warnings NUMBER := 0;
707: l_serial_number_control NUMBER;
708: -- TPW - Distributed changes

Line 732: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

728: wsh_debug_sv.log (l_module_name, 'New Delivery Id', p_new_delivery_id);
729: wsh_debug_sv.log (l_module_name,'Action Code ',p_action_code);
730: END IF;
731:
732: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
733:
734: IF(p_delivery_interface_id IS NULL) THEN
735: raise invalid_input;
736: END IF;

Line 996: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'

992: l_del_details_info.EARLIEST_PICKUP_DATE := del_det_int_rec.EARLIEST_PICKUP_DATE;
993: l_del_details_info.LATEST_PICKUP_DATE := del_det_int_rec.LATEST_PICKUP_DATE;
994: l_del_details_info.EARLIEST_DROPOFF_DATE:= del_det_int_rec.EARLIEST_DROPOFF_DATE;
995: l_del_details_info.LATEST_DROPOFF_DATE := del_det_int_rec.LATEST_DROPOFF_DATE;
996: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
997: AND wsh_util_core.tp_is_installed = 'Y')
998: THEN
999: l_del_details_info.ignore_for_planning := 'Y';
1000: END IF;

Line 997: AND wsh_util_core.tp_is_installed = 'Y')

993: l_del_details_info.LATEST_PICKUP_DATE := del_det_int_rec.LATEST_PICKUP_DATE;
994: l_del_details_info.EARLIEST_DROPOFF_DATE:= del_det_int_rec.EARLIEST_DROPOFF_DATE;
995: l_del_details_info.LATEST_DROPOFF_DATE := del_det_int_rec.LATEST_DROPOFF_DATE;
996: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
997: AND wsh_util_core.tp_is_installed = 'Y')
998: THEN
999: l_del_details_info.ignore_for_planning := 'Y';
1000: END IF;
1001:

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

1012: IF l_debug_on THEN
1013: wsh_debug_sv.log (l_module_name, 'Return Status from WSH_SHIPPING_PARAMS_PVT.GET', l_return_status);
1014: END IF;
1015:
1016: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1017: raise FND_API.G_EXC_ERROR ;
1018: END IF;
1019:
1020: --If any of the delivery grouping attribute is enabled copy the grouping attributes from delivery to delivery line

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

1036: IF l_debug_on THEN
1037: wsh_debug_sv.log (l_module_name, 'Return Status from WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD', l_return_status);
1038: END IF;
1039:
1040: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1041: raise FND_API.G_EXC_ERROR ;
1042: END IF;
1043:
1044: IF l_shipping_param_info.GROUP_BY_SHIP_METHOD_FLAG = 'Y' THEN

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

1149: wsh_debug_sv.log (l_module_name, 'Create Shipment Lines l_new_del_detail_id,l_return_status',
1150: l_new_del_detail_id||','||l_return_status);
1151: END IF;
1152:
1153: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1154:
1155: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
1156: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
1157:

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

1246: l_return_status',l_cont_instance_id||','||l_return_status);
1247: END IF;
1248: */
1249:
1250: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1251: raise create_cont_instance_failed;
1252: END IF;
1253:
1254:

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

1286: IF l_debug_on THEN
1287: wsh_debug_sv.log (l_module_name, 'Add_To_Update_Table l_return_status',l_return_status);
1288: END IF;
1289:
1290: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1291: raise add_to_update_failed;
1292: END IF;
1293:
1294:

Line 1410: wsh_util_core.api_post_call(p_return_status => l_return_status,

1406: p_qty_to_split => l_pending_req_qty,
1407: x_new_detail_id => l_new_split_detail_id,
1408: x_return_status => l_return_status);
1409:
1410: wsh_util_core.api_post_call(p_return_status => l_return_status,
1411: x_num_warnings => l_number_of_warnings,
1412: x_num_errors => l_number_of_errors);
1413:
1414: -- For the newly created base delivery detail, make updates

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

1450: IF l_debug_on THEN
1451: wsh_debug_sv.log (l_module_name, 'Add_To_Update_Table l_return_status',l_return_status);
1452: END IF;
1453:
1454: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1455: raise add_to_update_failed;
1456: END IF;
1457:
1458: l_new_detail_ids(l_new_detail_ids.COUNT+1) := del_det_int_rec.delivery_detail_id;

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

1473: IF l_debug_on THEN
1474: wsh_debug_sv.log (l_module_name, 'Add_To_Update_Table l_return_status',l_return_status);
1475: END IF;
1476:
1477: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1478: raise add_to_update_failed;
1479: END IF;
1480: END IF; --}
1481:

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

1502: IF l_debug_on THEN
1503: wsh_debug_sv.log (l_module_name,'Return status from Process Int Freight Costs',l_return_status);
1504: END IF;
1505:
1506: IF( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1507: raise freight_cost_processing_error;
1508: END IF;
1509:
1510: END IF;

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

1538: wsh_debug_sv.log (l_module_name, 'Detail to Delivery api msg count', l_msg_count);
1539: wsh_debug_sv.log (l_module_name, 'Detail to Delivery api msg data', l_msg_data);
1540: END IF;
1541:
1542: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1543: raise new_assignment_failed;
1544: END IF;
1545: END IF;
1546:

Line 1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1548: wsh_debug_sv.pop(l_module_name);
1549: END IF;
1550: EXCEPTION
1551: WHEN FND_API.G_EXC_ERROR THEN
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');
1556: END IF;

Line 1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');
1556: END IF;
1557: WHEN create_cont_instance_failed THEN
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,'create_cont_instance_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1561: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_cont_instance_failed');
1562: END IF;

Line 1564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1560: WSH_DEBUG_SV.logmsg(l_module_name,'create_cont_instance_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1561: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_cont_instance_failed');
1562: END IF;
1563: WHEN invalid_input THEN
1564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
1568: END IF;

Line 1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1568: END IF;
1569: WHEN create_lines_failed THEN
1570: FND_MESSAGE.SET_NAME('WSH', 'WSH_CREATE_LINES_FAILED');
1571: FND_MESSAGE.SET_TOKEN('DET_INT',del_det_int_rec.delivery_detail_interface_id);
1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1573: IF l_debug_on THEN
1574: WSH_DEBUG_SV.logmsg(l_module_name,'create_lines_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1575: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_lines_failed');
1576: END IF;

Line 1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1576: END IF;
1577: WHEN new_assignment_failed THEN
1578: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSGN_ERROR');
1579: FND_MESSAGE.SET_TOKEN('DLVY', p_new_delivery_id);
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: IF l_debug_on THEN
1582: WSH_DEBUG_SV.logmsg(l_module_name,'new_assignment_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:new_assignment_failed');
1584: END IF;

Line 1586: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1582: WSH_DEBUG_SV.logmsg(l_module_name,'new_assignment_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:new_assignment_failed');
1584: END IF;
1585: WHEN freight_cost_processing_error THEN
1586: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1587: IF l_debug_on THEN
1588: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1589: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
1590: END IF;

Line 1592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1588: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1589: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
1590: END IF;
1591: WHEN Others THEN
1592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1593: IF l_debug_on THEN
1594: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1595: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1652: l_detail_id_tab wsh_util_core.id_tab_type;

1648: l_pending_shp_qty NUMBER;
1649: l_curr_index NUMBER;
1650:
1651: l_serial_number_control NUMBER;
1652: l_detail_id_tab wsh_util_core.id_tab_type;
1653: l_detail_qty_tab wsh_util_core.id_tab_type;
1654: l_new_detail_ids wsh_util_core.id_tab_type;
1655: l_frt_detail_intf_tab wsh_util_core.id_tab_type;
1656: l_frt_detail_tab wsh_util_core.id_tab_type;

Line 1653: l_detail_qty_tab wsh_util_core.id_tab_type;

1649: l_curr_index NUMBER;
1650:
1651: l_serial_number_control NUMBER;
1652: l_detail_id_tab wsh_util_core.id_tab_type;
1653: l_detail_qty_tab wsh_util_core.id_tab_type;
1654: l_new_detail_ids wsh_util_core.id_tab_type;
1655: l_frt_detail_intf_tab wsh_util_core.id_tab_type;
1656: l_frt_detail_tab wsh_util_core.id_tab_type;
1657: new_assignment_failed exception;

Line 1654: l_new_detail_ids wsh_util_core.id_tab_type;

1650:
1651: l_serial_number_control NUMBER;
1652: l_detail_id_tab wsh_util_core.id_tab_type;
1653: l_detail_qty_tab wsh_util_core.id_tab_type;
1654: l_new_detail_ids wsh_util_core.id_tab_type;
1655: l_frt_detail_intf_tab wsh_util_core.id_tab_type;
1656: l_frt_detail_tab wsh_util_core.id_tab_type;
1657: new_assignment_failed exception;
1658: -- TPW - Distributed changes

Line 1655: l_frt_detail_intf_tab wsh_util_core.id_tab_type;

1651: l_serial_number_control NUMBER;
1652: l_detail_id_tab wsh_util_core.id_tab_type;
1653: l_detail_qty_tab wsh_util_core.id_tab_type;
1654: l_new_detail_ids wsh_util_core.id_tab_type;
1655: l_frt_detail_intf_tab wsh_util_core.id_tab_type;
1656: l_frt_detail_tab wsh_util_core.id_tab_type;
1657: new_assignment_failed exception;
1658: -- TPW - Distributed changes
1659:

Line 1656: l_frt_detail_tab wsh_util_core.id_tab_type;

1652: l_detail_id_tab wsh_util_core.id_tab_type;
1653: l_detail_qty_tab wsh_util_core.id_tab_type;
1654: l_new_detail_ids wsh_util_core.id_tab_type;
1655: l_frt_detail_intf_tab wsh_util_core.id_tab_type;
1656: l_frt_detail_tab wsh_util_core.id_tab_type;
1657: new_assignment_failed exception;
1658: -- TPW - Distributed changes
1659:
1660: --exceptions

Line 1686: x_return_status := wsh_util_core.g_ret_sts_success;

1682: p_delivery_interface_id);
1683: wsh_debug_sv.LOG(l_module_name, 'Delivery Id', p_delivery_id);
1684: END IF;
1685:
1686: x_return_status := wsh_util_core.g_ret_sts_success;
1687:
1688: IF (p_delivery_interface_id IS NULL) THEN
1689: RAISE invalid_input;
1690: END IF;

Line 1757: wsh_util_core.api_post_call(p_return_status => l_return_status,

1753: p_qty_to_split => l_pending_req_qty,
1754: x_new_detail_id => l_new_split_detail_id,
1755: x_return_status => l_return_status);
1756:
1757: wsh_util_core.api_post_call(p_return_status => l_return_status,
1758: x_num_warnings => l_number_of_warnings,
1759: x_num_errors => l_number_of_errors);
1760:
1761: -- For the newly created base delivery detail, make updates

Line 1810: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

1806: p_update_mode => 'UPDATE',
1807: p_delivery_id => l_delivery_id,
1808: x_return_status => l_return_status);
1809:
1810: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1811: RAISE fnd_api.g_exc_error;
1812: END IF;
1813:
1814:

Line 1864: wsh_util_core.api_post_call(p_return_status => l_return_status,

1860: p_qty_to_split => l_pending_req_qty,
1861: x_new_detail_id => l_new_split_detail_id,
1862: x_return_status => l_return_status);
1863:
1864: wsh_util_core.api_post_call(p_return_status => l_return_status,
1865: x_num_warnings => l_number_of_warnings,
1866: x_num_errors => l_number_of_errors);
1867:
1868: -- For the newly created base delivery detail, make updates

Line 1917: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

1913: p_update_mode => 'UPDATE',
1914: p_delivery_id => l_delivery_id,
1915: x_return_status => l_return_status);
1916:
1917: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1918: RAISE fnd_api.g_exc_error;
1919: END IF;
1920:
1921:

Line 1961: wsh_util_core.api_post_call(p_return_status => l_return_status,

1957: p_qty_to_split => l_pending_req_qty,
1958: x_new_detail_id => l_new_split_detail_id,
1959: x_return_status => l_return_status);
1960:
1961: wsh_util_core.api_post_call(p_return_status => l_return_status,
1962: x_num_warnings => l_number_of_warnings,
1963: x_num_errors => l_number_of_errors);
1964:
1965: -- For the newly created base delivery detail, make updates

Line 2014: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

2010: p_update_mode => 'UPDATE',
2011: p_delivery_id => l_delivery_id,
2012: x_return_status => l_return_status);
2013:
2014: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2015: RAISE fnd_api.g_exc_error;
2016: END IF;
2017:
2018:

Line 2232: wsh_util_core.api_post_call(p_return_status => l_return_status,

2228: p_qty_to_split => l_pending_req_qty,
2229: x_new_detail_id => l_new_split_detail_id,
2230: x_return_status => l_return_status);
2231:
2232: wsh_util_core.api_post_call(p_return_status => l_return_status,
2233: x_num_warnings => l_number_of_warnings,
2234: x_num_errors => l_number_of_errors);
2235:
2236: -- For the newly created base delivery detail, make updates

Line 2285: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

2281: p_update_mode => 'UPDATE',
2282: p_delivery_id => l_delivery_id,
2283: x_return_status => l_return_status);
2284:
2285: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2286: RAISE fnd_api.g_exc_error;
2287: END IF;
2288:
2289:

Line 2329: wsh_util_core.api_post_call(p_return_status => l_return_status,

2325: p_qty_to_split => l_pending_req_qty,
2326: x_new_detail_id => l_new_split_detail_id,
2327: x_return_status => l_return_status);
2328:
2329: wsh_util_core.api_post_call(p_return_status => l_return_status,
2330: x_num_warnings => l_number_of_warnings,
2331: x_num_errors => l_number_of_errors);
2332:
2333: -- For the newly created base delivery detail, make updates

Line 2382: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

2378: p_update_mode => 'UPDATE',
2379: p_delivery_id => l_delivery_id,
2380: x_return_status => l_return_status);
2381:
2382: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2383: RAISE fnd_api.g_exc_error;
2384: END IF;
2385:
2386:

Line 2443: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

2439: IF l_debug_on THEN
2440: wsh_debug_sv.LOG(l_module_name, 'Process_Int_Freight_Costs l_return_status', l_return_status);
2441: END IF;
2442:
2443: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2444: RAISE freight_cost_processing_error;
2445: END IF;
2446: END IF;
2447: END LOOP;

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

2472: wsh_debug_sv.log (l_module_name, 'Detail to Delivery api msg count', l_msg_count);
2473: wsh_debug_sv.log (l_module_name, 'Detail to Delivery api msg data', l_msg_data);
2474: END IF;
2475:
2476: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2477: raise new_assignment_failed;
2478: END IF;
2479:
2480: END IF;

Line 2509: WHEN wsh_util_core.g_exc_warning THEN

2505: wsh_debug_sv.pop(l_module_name,
2506: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2507: END IF;
2508: --
2509: WHEN wsh_util_core.g_exc_warning THEN
2510: x_return_status := wsh_util_core.g_ret_sts_warning;
2511: --
2512: IF l_debug_on THEN
2513: wsh_debug_sv.logmsg(l_module_name,

Line 2510: x_return_status := wsh_util_core.g_ret_sts_warning;

2506: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2507: END IF;
2508: --
2509: WHEN wsh_util_core.g_exc_warning THEN
2510: x_return_status := wsh_util_core.g_ret_sts_warning;
2511: --
2512: IF l_debug_on THEN
2513: wsh_debug_sv.logmsg(l_module_name,
2514: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',

Line 2514: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',

2510: x_return_status := wsh_util_core.g_ret_sts_warning;
2511: --
2512: IF l_debug_on THEN
2513: wsh_debug_sv.logmsg(l_module_name,
2514: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
2515: wsh_debug_sv.c_excep_level);
2516: wsh_debug_sv.pop(l_module_name,
2517: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2518: END IF;

Line 2517: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2513: wsh_debug_sv.logmsg(l_module_name,
2514: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
2515: wsh_debug_sv.c_excep_level);
2516: wsh_debug_sv.pop(l_module_name,
2517: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2518: END IF;
2519: --
2520: WHEN invalid_input THEN
2521: x_return_status := wsh_util_core.g_ret_sts_error;

Line 2521: x_return_status := wsh_util_core.g_ret_sts_error;

2517: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2518: END IF;
2519: --
2520: WHEN invalid_input THEN
2521: x_return_status := wsh_util_core.g_ret_sts_error;
2522:
2523: IF l_debug_on THEN
2524: wsh_debug_sv.logmsg(l_module_name,
2525: 'invalid_input exception has occured.',

Line 2530: x_return_status := wsh_util_core.g_ret_sts_error;

2526: wsh_debug_sv.c_excep_level);
2527: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:invalid_input');
2528: END IF;
2529: WHEN freight_cost_processing_error THEN
2530: x_return_status := wsh_util_core.g_ret_sts_error;
2531:
2532: IF l_debug_on THEN
2533: wsh_debug_sv.logmsg(l_module_name,
2534: 'freight_cost_processing_error exception has occured.',

Line 2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2539: -- TPW - Distributed changes
2540: WHEN new_assignment_failed THEN
2541: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSGN_ERROR');
2542: FND_MESSAGE.SET_TOKEN('DLVY', l_delivery_id);
2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2544: IF l_debug_on THEN
2545: WSH_DEBUG_SV.logmsg(l_module_name,'new_assignment_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:new_assignment_failed');
2547: END IF;

Line 2549: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2545: WSH_DEBUG_SV.logmsg(l_module_name,'new_assignment_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:new_assignment_failed');
2547: END IF;
2548: WHEN OTHERS THEN
2549: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2550:
2551: IF l_debug_on THEN
2552: wsh_debug_sv.logmsg(l_module_name,
2553: 'Unexpected error has occured. Oracle error message is '

Line 2566: l_del_detail_tab WSH_UTIL_CORE.id_tab_type;

2562: x_return_status OUT NOCOPY VARCHAR2) IS
2563: -- variables
2564: l_return_status VARCHAR2(30);
2565: l_pack_status VARCHAR2(30);
2566: l_del_detail_tab WSH_UTIL_CORE.id_tab_type;
2567:
2568: --exceptions
2569: packing_failed exception;
2570:

Line 2590: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2586: wsh_debug_sv.push(l_module_name, 'Pack_Lines');
2587: wsh_debug_sv.log (l_module_name, 'Packing Table Count', G_Packing_Detail_Tab.count);
2588: END IF;
2589:
2590: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2591:
2592: FOR i in 1..G_Packing_Detail_Tab.count LOOP
2593: -- TPW - Distributed changes
2594: IF (G_Packing_Detail_Tab(i).src_container_flag = 'N') THEN --{

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

2626: IF l_debug_on THEN
2627: wsh_debug_sv.log (l_module_name,'Return Status', l_return_status);
2628: END IF;
2629:
2630: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2631: FND_MESSAGE.SET_NAME('WSH','WSH_PACKING_ERROR');
2632: FND_MESSAGE.SET_TOKEN('DEL_DETAIL', G_Packing_Detail_Tab(i).Delivery_Detail_Id);
2633: raise packing_failed;
2634: END IF;

Line 2643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2639: END IF;
2640:
2641: EXCEPTION
2642: WHEN packing_failed THEN
2643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2644: IF l_debug_on THEN
2645: WSH_DEBUG_SV.logmsg(l_module_name,'packing_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_failed');
2647: END IF;

Line 2649: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2645: WSH_DEBUG_SV.logmsg(l_module_name,'packing_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_failed');
2647: END IF;
2648: WHEN Others THEN
2649: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2650: IF l_debug_on THEN
2651: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2652: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2908: wsh_debug_sv.log (l_module_name,'Action Code', p_action_code);
2909: wsh_debug_sv.log (l_module_name, 'Warehouse type', WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE);
2910: END IF;
2911:
2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2913:
2914: IF(p_delivery_interface_id IS NULL)
2915: THEN
2916: raise fnd_api.g_exc_error;

Line 2952: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'

2948: l_del_int_rec.delivered_date;
2949: ELSIF p_action_code = 'CREATE' THEN
2950: l_dlvy_attr_tab(l_index).shipment_direction :=
2951: l_del_int_rec.shipment_direction;
2952: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
2953: AND wsh_util_core.tp_is_installed = 'Y')
2954: THEN
2955: l_dlvy_attr_tab(l_index).ignore_for_planning := 'Y';
2956: END IF;

Line 2953: AND wsh_util_core.tp_is_installed = 'Y')

2949: ELSIF p_action_code = 'CREATE' THEN
2950: l_dlvy_attr_tab(l_index).shipment_direction :=
2951: l_del_int_rec.shipment_direction;
2952: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
2953: AND wsh_util_core.tp_is_installed = 'Y')
2954: THEN
2955: l_dlvy_attr_tab(l_index).ignore_for_planning := 'Y';
2956: END IF;
2957: END IF; -- if p_action_code=update

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

3275: wsh_debug_sv.log (l_module_name, 'Create Update Delivery api msg count', l_msg_count);
3276: wsh_debug_sv.log (l_module_name, 'Create Update Delivery api msg', l_msg_data);
3277: END IF;
3278:
3279: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
3280: THEN
3281: -- {
3282: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3283: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;

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

3354: IF l_debug_on THEN
3355: wsh_debug_sv.log (l_module_name, 'Return status from process int freight costs', l_return_status);
3356: END IF;
3357: --
3358: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3359: raise freight_cost_processing_error;
3360: END IF;
3361: -- }
3362: END IF;

Line 3385: WHEN wsh_util_core.g_exc_warning THEN

3381: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3382: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3383: END IF;
3384: --
3385: WHEN wsh_util_core.g_exc_warning THEN
3386: x_return_status := wsh_util_core.g_ret_sts_warning;
3387: --
3388: IF l_debug_on THEN
3389: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);

Line 3386: x_return_status := wsh_util_core.g_ret_sts_warning;

3382: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3383: END IF;
3384: --
3385: WHEN wsh_util_core.g_exc_warning THEN
3386: x_return_status := wsh_util_core.g_ret_sts_warning;
3387: --
3388: IF l_debug_on THEN
3389: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
3390: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 3389: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);

3385: WHEN wsh_util_core.g_exc_warning THEN
3386: x_return_status := wsh_util_core.g_ret_sts_warning;
3387: --
3388: IF l_debug_on THEN
3389: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
3390: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3391: END IF;
3392: --
3393: WHEN invalid_ship_method THEN

Line 3390: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

3386: x_return_status := wsh_util_core.g_ret_sts_warning;
3387: --
3388: IF l_debug_on THEN
3389: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
3390: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3391: END IF;
3392: --
3393: WHEN invalid_ship_method THEN
3394: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3394: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3390: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3391: END IF;
3392: --
3393: WHEN invalid_ship_method THEN
3394: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3395: IF l_debug_on THEN
3396: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_ship_method exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_ship_method');
3398: END IF;

Line 3400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3396: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_ship_method exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_ship_method');
3398: END IF;
3399: WHEN freight_cost_processing_error THEN
3400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3401: IF l_debug_on THEN
3402: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3403: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
3404: END IF;

Line 3406: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

3402: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3403: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
3404: END IF;
3405: WHEN OTHERS THEN
3406: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
3407: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.PROCESS_INTERFACED_DELIVERIES');
3408:
3409: IF l_debug_on THEN
3410: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);

Line 3407: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.PROCESS_INTERFACED_DELIVERIES');

3403: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
3404: END IF;
3405: WHEN OTHERS THEN
3406: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
3407: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.PROCESS_INTERFACED_DELIVERIES');
3408:
3409: IF l_debug_on THEN
3410: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);
3411: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

Line 3515: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3511: wsh_debug_sv.log (l_module_name,'Delivery interface Id', p_delivery_interface_id);
3512: wsh_debug_sv.log (l_module_name,'Action Code', p_action_code);
3513: END IF;
3514:
3515: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3516:
3517: l_action_code := p_action_code;
3518:
3519: -- First process the delivery

Line 3545: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN

3541: IF l_debug_on THEN
3542: wsh_debug_sv.log (l_module_name,'Return status from lock delivery and details', l_return_status);
3543: END IF;
3544:
3545: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN
3546: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3547: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3548: l_loc_interface_error_rec.p_message_name := 'WSH_NO_LOCK';
3549:

Line 3573: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN

3569: IF l_debug_on THEN
3570: wsh_debug_sv.log (l_module_name,'Return status from Lock_Delivery_Details', l_return_status);
3571: END IF;
3572:
3573: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN
3574: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3575: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3576: l_loc_interface_error_rec.p_message_name := 'WSH_NO_LOCK';
3577:

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

3597: IF l_debug_on THEN
3598: wsh_debug_sv.log (l_module_name, 'Return Status from Process Deliveries', l_return_status);
3599: END IF;
3600:
3601: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3602: raise process_delivery_failed;
3603: END IF;
3604:
3605: IF(l_action_code = 'CREATE' AND l_created_delivery_id is NULL ) THEN

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

3631: IF l_debug_on THEN
3632: wsh_debug_sv.log (l_module_name, 'Return Status from Process Details', l_return_status);
3633: END IF;
3634:
3635: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3636: raise process_del_details_failed;
3637: END IF;
3638:
3639: -- J: W/V Changes

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

3672: IF l_debug_on THEN
3673: wsh_debug_sv.log (l_module_name, 'Return status from WSH_WV_UTILS.Del_WV_Post_Process ',l_return_status);
3674: END IF;
3675:
3676: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3677:
3678: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3679: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3680:

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

3711: IF l_debug_on THEN
3712: wsh_debug_sv.log (l_module_name, 'Return Status from Process Cancel', l_return_status);
3713: END IF;
3714:
3715: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3716: raise cancel_lines_failed;
3717: END IF;
3718:
3719: ELSE

Line 3729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3725: END IF;
3726:
3727: EXCEPTION
3728: WHEN invalid_input THEN
3729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3730: IF l_debug_on THEN
3731: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3732: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
3733: END IF;

Line 3735: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3731: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3732: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
3733: END IF;
3734: WHEN no_lock_found THEN
3735: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3736: IF l_debug_on THEN
3737: WSH_DEBUG_SV.logmsg(l_module_name,'no_lock_found exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3738: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:no_lock_found');
3739: END IF;

Line 3741: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3737: WSH_DEBUG_SV.logmsg(l_module_name,'no_lock_found exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3738: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:no_lock_found');
3739: END IF;
3740: WHEN invalid_action_code THEN
3741: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3742: IF l_debug_on THEN
3743: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
3745: END IF;

Line 3747: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3743: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
3745: END IF;
3746: WHEN process_delivery_failed THEN
3747: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3748: IF l_debug_on THEN
3749: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');
3751: END IF;

Line 3754: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');
3751: END IF;
3752: -- J: W/V Changes
3753: WHEN process_delivery_wv_failed THEN
3754: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3755: IF l_debug_on THEN
3756: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_wv_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_wv_failed');
3758: END IF;

Line 3760: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3756: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_wv_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_wv_failed');
3758: END IF;
3759: WHEN process_del_details_failed THEN
3760: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3761: IF l_debug_on THEN
3762: WSH_DEBUG_SV.logmsg(l_module_name,'process_del_details_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_del_details_failed');
3764: END IF;

Line 3766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3762: WSH_DEBUG_SV.logmsg(l_module_name,'process_del_details_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_del_details_failed');
3764: END IF;
3765: WHEN cancel_lines_failed THEN
3766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3767: IF l_debug_on THEN
3768: WSH_DEBUG_SV.logmsg(l_module_name,'cancel_lines_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cancel_lines_failed');
3770: END IF;

Line 3772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3768: WSH_DEBUG_SV.logmsg(l_module_name,'cancel_lines_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cancel_lines_failed');
3770: END IF;
3771: WHEN Others THEN
3772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3773: IF l_debug_on THEN
3774: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
3775: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3776: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3916: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3912: wsh_debug_sv.log (l_module_name,'del_detail_interface_id', p_del_detail_interface_id);
3913: wsh_debug_sv.log (l_module_name,'delivery detail id', p_delivery_detail_id);
3914: END IF;
3915:
3916: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3917:
3918:
3919: IF(p_del_detail_interface_id IS NOT NULL) THEN
3920: IF(p_delivery_detail_id IS NULL) THEN

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

4050: wsh_debug_sv.log (l_module_name, 'Create Update Freight Costs api msg', l_msg_data);
4051: wsh_debug_sv.log (l_module_name, 'freight_cost id created', l_freight_cost_id);
4052: END IF;
4053:
4054: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4055: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';
4056: l_loc_interface_error_rec.p_interface_id := l_entity_interface_id;
4057:
4058: Log_Errors(

Line 4066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4062: x_return_status => l_return_status);
4063: IF l_debug_on THEN
4064: wsh_debug_sv.log (l_module_name, 'Log_Errors l_return_status',l_return_status);
4065: END IF;
4066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4067: END IF;
4068:
4069: END LOOP;
4070:

Line 4077: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4073: END IF;
4074:
4075: EXCEPTION
4076: WHEN invalid_input THEN
4077: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4078: IF l_debug_on THEN
4079: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
4081: END IF;

Line 4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4079: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
4081: END IF;
4082: WHEN invalid_freight_cost_type THEN
4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4084: IF l_debug_on THEN
4085: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_freight_cost_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_freight_cost_type');
4087: END IF;

Line 4095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4091: WSH_DEBUG_SV.logmsg(l_module_name,'no_freight_record exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:no_freight_record');
4093: END IF;
4094: WHEN Others THEN
4095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4096: IF l_debug_on THEN
4097: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
4098: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4168: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4164: wsh_debug_sv.log (l_module_name, 'Update Table Count', G_Update_Attributes_Tab.count);
4165: wsh_debug_sv.log(l_module_name, 'Serial Range Tab count',G_SERIAL_RANGE_TAB.count);
4166: END IF;
4167:
4168: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4169: -- Use the global table to call create_update Group API
4170:
4171: IF(G_Update_Attributes_Tab.count > 0 ) THEN
4172: l_in_rec.caller := 'WSH_INBOUND';

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

4192: wsh_debug_sv.log (l_module_name, 'Update Ship Attr api msg count', l_msg_count);
4193: wsh_debug_sv.log (l_module_name, 'Update Ship Attr api msg data', l_msg_data);
4194: END IF;
4195:
4196: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4197: -- Need to insert record in interface errors table only
4198: -- for 'OE' source code, i.e during 945 inbound
4199: -- For 940 inbound - cancel case, there may not be any
4200: -- data in interface tables.

Line 4303: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4299: END IF;
4300:
4301: EXCEPTION
4302: WHEN update_shipping_att_failed THEN
4303: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4304: IF l_debug_on THEN
4305: WSH_DEBUG_SV.logmsg(l_module_name,'update_shipping_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_shipping_att_failed');
4307: END IF;

Line 4309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4305: WSH_DEBUG_SV.logmsg(l_module_name,'update_shipping_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_shipping_att_failed');
4307: END IF;
4308: WHEN cont_upd_ship_att_failed THEN
4309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4310: IF l_debug_on THEN
4311: WSH_DEBUG_SV.logmsg(l_module_name,'cont_upd_ship_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4312: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cont_upd_ship_att_failed');
4313: END IF;

Line 4315: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4311: WSH_DEBUG_SV.logmsg(l_module_name,'cont_upd_ship_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4312: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cont_upd_ship_att_failed');
4313: END IF;
4314: WHEN Others THEN
4315: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4316: IF l_debug_on THEN
4317: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
4318: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4351: l_del_rows wsh_util_core.id_tab_type;

4347: x_trip_id OUT NOCOPY NUMBER,
4348: x_return_status OUT NOCOPY VARCHAR2) IS
4349:
4350: -- variables
4351: l_del_rows wsh_util_core.id_tab_type;
4352:
4353: l_pickup_stop_id NUMBER ;
4354: l_dropoff_stop_id NUMBER ;
4355: l_delivery_leg_id NUMBER ;

Line 4368: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

4364: l_dropoff_stop_int_id NUMBER;
4365:
4366: l_return_status VARCHAR2(30);
4367:
4368: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
4369: l_dbi_rs VARCHAR2(1); -- DBI Project
4370:
4371: -- cursors
4372: CURSOR del_trip_stops IS

Line 4434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4430: wsh_debug_sv.push(l_module_name,'Create_Update_Trip_For_Dlvy');
4431: wsh_debug_sv.log (l_module_name, 'Delivery id', p_delivery_id);
4432: END IF;
4433:
4434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4435:
4436: IF(p_delivery_id IS NULL) THEN
4437: raise invalid_input;
4438: END IF;

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

4463: wsh_debug_sv.log (l_module_name, 'Return status from autocreate trip', l_return_status);
4464: wsh_debug_sv.log (l_module_name, 'Trip created', l_trip_id);
4465: END IF;
4466:
4467: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4468: x_return_status := l_return_status;
4469: raise trip_creation_failed;
4470: END IF;
4471:

Line 4535: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

4531:
4532: IF l_debug_on THEN
4533: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
4534: END IF;
4535: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4536: x_return_status := l_dbi_rs;
4537: -- just pass this return status to caller API
4538: IF l_debug_on THEN
4539: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 4588: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

4584:
4585: IF l_debug_on THEN
4586: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
4587: END IF;
4588: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4589: x_return_status := l_dbi_rs;
4590: -- just pass this return status to caller API
4591: IF l_debug_on THEN
4592: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 4644: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4640: wsh_debug_sv.pop(l_module_name);
4641: END IF;
4642: EXCEPTION
4643: WHEN trip_creation_failed THEN
4644: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4645: IF l_debug_on THEN
4646: WSH_DEBUG_SV.logmsg(l_module_name,'trip_creation_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:trip_creation_failed');
4648: END IF;

Line 4650: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4646: WSH_DEBUG_SV.logmsg(l_module_name,'trip_creation_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:trip_creation_failed');
4648: END IF;
4649: WHEN invalid_input THEN
4650: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4651: IF l_debug_on THEN
4652: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
4654: END IF;

Line 4656: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4652: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
4654: END IF;
4655: WHEN Others THEN
4656: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4657: IF l_debug_on THEN
4658: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
4659: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4660: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4712: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4708: wsh_debug_sv.log (l_module_name, 'Routing Ins', p_trip_routing_ins);
4709: wsh_debug_sv.log (l_module_name, 'p_operator', p_operator);
4710: END IF;
4711:
4712: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4713: -- get delivery_leg_interface_id, stop_interface_id, trip_interface_id
4714:
4715: SELECT
4716: WSH_DEL_LEGS_INTERFACE_S.nextval,

Line 4828: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4824: END IF;
4825: EXCEPTION
4826:
4827: WHEN Others THEN
4828: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4829: IF l_debug_on THEN
4830: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
4831: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4832: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5118: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5114: WHEN packing_error THEN
5115: IF(base_detail_cur%ISOPEN) THEN
5116: CLOSE base_detail_cur;
5117: END IF;
5118: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5119: IF l_debug_on THEN
5120: WSH_DEBUG_SV.logmsg(l_module_name,'packing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5121: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_error');
5122: END IF;

Line 5125: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5121: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_error');
5122: END IF;
5123:
5124: WHEN Others THEN
5125: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5126: IF l_debug_on THEN
5127: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5128: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5172: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5168: wsh_debug_sv.push(l_module_name, 'Process_Cancel');
5169: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
5170: END IF;
5171:
5172: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5173:
5174: -- select the delivery lines
5175: -- Add to the global update table
5176:

Line 5218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5214: END IF;
5215:
5216: EXCEPTION
5217: WHEN Others THEN
5218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5221: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5263: x_return_status := wsh_util_core.g_ret_sts_success;

5259: wsh_debug_sv.push(l_module_name, 'Lock_Delivery_And_Details');
5260: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
5261: END IF;
5262:
5263: x_return_status := wsh_util_core.g_ret_sts_success;
5264:
5265: IF l_debug_on THEN
5266: wsh_debug_sv.logmsg(l_module_name, 'Locking the Delivery');
5267: END IF;

Line 5284: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5280: IF l_debug_on THEN
5281: wsh_debug_sv.logmsg(l_module_name, 'No details found');
5282: END IF;
5283:
5284: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5285: CLOSE lock_delivery_details;
5286: END IF;
5287: IF (lock_delivery_details%ISOPEN) THEN
5288: CLOSE lock_delivery_details;

Line 5296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5292: END IF;
5293:
5294: EXCEPTION
5295: WHEN RECORD_LOCKED THEN
5296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5297:
5298: IF l_debug_on THEN
5299: wsh_debug_sv.logmsg(l_module_name, 'Could not obtain lock');
5300: END IF;

Line 5303: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

5299: wsh_debug_sv.logmsg(l_module_name, 'Could not obtain lock');
5300: END IF;
5301:
5302: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
5303: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5304: IF l_debug_on THEN
5305: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
5307: END IF;

Line 5310: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
5307: END IF;
5308:
5309: WHEN others THEN
5310: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5311: IF l_debug_on THEN
5312: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5313: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5314: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5397: x_return_status := wsh_util_core.g_ret_sts_success;

5393: wsh_debug_sv.push(l_module_name, 'Lock_Delivery_Details');
5394: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
5395: END IF;
5396:
5397: x_return_status := wsh_util_core.g_ret_sts_success;
5398:
5399: IF l_debug_on THEN
5400: wsh_debug_sv.logmsg(l_module_name, 'Locking the delivery details');
5401: END IF;

Line 5409: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5405: IF l_debug_on THEN
5406: wsh_debug_sv.logmsg(l_module_name, 'No details found');
5407: END IF;
5408:
5409: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5410: CLOSE lock_delivery_details;
5411: END IF;
5412: IF (lock_delivery_details%ISOPEN) THEN
5413: CLOSE lock_delivery_details;

Line 5421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5417: END IF;
5418:
5419: EXCEPTION
5420: WHEN RECORD_LOCKED THEN
5421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5422:
5423: IF l_debug_on THEN
5424: wsh_debug_sv.logmsg(l_module_name, 'Could not obtain lock');
5425: END IF;

Line 5428: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

5424: wsh_debug_sv.logmsg(l_module_name, 'Could not obtain lock');
5425: END IF;
5426:
5427: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
5428: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5429: IF l_debug_on THEN
5430: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5431: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
5432: END IF;

Line 5435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5431: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
5432: END IF;
5433:
5434: WHEN others THEN
5435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5436: IF l_debug_on THEN
5437: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5438: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5482: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5478: wsh_debug_sv.pop(l_module_name);
5479: END IF;
5480: EXCEPTION
5481: WHEN others THEN
5482: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5483: IF l_debug_on THEN
5484: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5485: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5486: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5551: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);

5547:
5548: IF p_qty_to_split IS NULL THEN
5549: fnd_message.set_name('WSH', 'WSH_REQUIRED_FIELD_NULL');
5550: fnd_message.set_token('FIELD_NAME', 'REQUESTED_QTY');
5551: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
5552: RAISE FND_API.G_EXC_ERROR;
5553: END IF;
5554:
5555: l_qty_to_split := p_qty_to_split;

Line 5567: wsh_util_core.api_post_call(

5563: wsh_debug_sv.LOG(l_module_name, 'Split_Delivery_Details x_new_detail_id,l_return_status',
5564: x_new_detail_id || ',' || l_return_status);
5565: END IF;
5566:
5567: wsh_util_core.api_post_call(
5568: p_return_status =>l_return_status,
5569: x_num_warnings =>l_number_of_warnings,
5570: x_num_errors =>l_number_of_errors);
5571: END IF;

Line 5577: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

5573: IF l_number_of_warnings > 0 THEN
5574: IF l_debug_on THEN
5575: wsh_debug_sv.logmsg (l_module_name,'Number of warnings', l_number_of_warnings);
5576: END IF;
5577: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
5578: END IF;
5579:
5580: x_return_status := wsh_util_core.g_ret_sts_success;
5581:

Line 5580: x_return_status := wsh_util_core.g_ret_sts_success;

5576: END IF;
5577: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
5578: END IF;
5579:
5580: x_return_status := wsh_util_core.g_ret_sts_success;
5581:
5582: IF l_debug_on THEN
5583: wsh_debug_sv.pop(l_module_name);
5584: END IF;

Line 5607: WHEN wsh_util_core.g_exc_warning THEN

5603: wsh_debug_sv.pop(l_module_name,
5604: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5605: END IF;
5606: --
5607: WHEN wsh_util_core.g_exc_warning THEN
5608: x_return_status := wsh_util_core.g_ret_sts_warning;
5609: --
5610: IF l_debug_on THEN
5611: wsh_debug_sv.logmsg(l_module_name,

Line 5608: x_return_status := wsh_util_core.g_ret_sts_warning;

5604: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5605: END IF;
5606: --
5607: WHEN wsh_util_core.g_exc_warning THEN
5608: x_return_status := wsh_util_core.g_ret_sts_warning;
5609: --
5610: IF l_debug_on THEN
5611: wsh_debug_sv.logmsg(l_module_name,
5612: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',

Line 5612: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',

5608: x_return_status := wsh_util_core.g_ret_sts_warning;
5609: --
5610: IF l_debug_on THEN
5611: wsh_debug_sv.logmsg(l_module_name,
5612: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
5613: wsh_debug_sv.c_excep_level);
5614: wsh_debug_sv.pop(l_module_name,
5615: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5616: END IF;

Line 5615: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

5611: wsh_debug_sv.logmsg(l_module_name,
5612: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
5613: wsh_debug_sv.c_excep_level);
5614: wsh_debug_sv.pop(l_module_name,
5615: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5616: END IF;
5617: WHEN OTHERS THEN
5618: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
5619: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');

Line 5618: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

5614: wsh_debug_sv.pop(l_module_name,
5615: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5616: END IF;
5617: WHEN OTHERS THEN
5618: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
5619: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');
5620: --
5621: IF l_debug_on THEN
5622: wsh_debug_sv.logmsg(l_module_name,

Line 5619: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');

5615: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5616: END IF;
5617: WHEN OTHERS THEN
5618: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
5619: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');
5620: --
5621: IF l_debug_on THEN
5622: wsh_debug_sv.logmsg(l_module_name,
5623: 'Unexpected error has occured. Oracle error message is '