APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_UTIL_CORE

Line 285: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

281: wsh_debug_sv.log (l_module_name,'parent_delivery_detail_id ',p_parent_delivery_detail_id);
282: wsh_debug_sv.log (l_module_name,'parent_detail_interface_id ',p_parent_detail_interface_id);
283: END IF;
284:
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
286:
287: UPDATE wsh_del_assgn_interface
288: SET parent_detail_interface_id = p_parent_detail_interface_id
289: WHERE parent_delivery_detail_id = p_parent_delivery_detail_id;

Line 304: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

300: EXCEPTION
301:
302: WHEN Others THEN
303:
304: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
307: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 379: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

375: wsh_debug_sv.log (l_module_name,'New Delivery Id', p_new_delivery_id);
376: wsh_debug_sv.log (l_module_name,'Action Code ',p_action_code);
377: END IF;
378:
379: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
380:
381: IF(p_delivery_interface_id IS NULL) THEN
382: raise invalid_input;
383: END IF;

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

400: IF l_debug_on THEN
401: wsh_debug_sv.log (l_module_name, 'Return Status from Process_Non_Splits', l_return_status);
402: END IF;
403:
404: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
405: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
406: END IF;
407:
408: IF(p_action_code = 'UPDATE') THEN

Line 405: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

401: wsh_debug_sv.log (l_module_name, 'Return Status from Process_Non_Splits', l_return_status);
402: END IF;
403:
404: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
405: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
406: END IF;
407:
408: IF(p_action_code = 'UPDATE') THEN
409: Process_Splits(

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

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

Line 420: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

416: wsh_debug_sv.log (l_module_name, 'Return Status from Process Splits', l_return_status);
417: END IF;
418:
419: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
421: END IF;
422:
423: IF l_debug_on THEN
424: wsh_debug_sv.log (l_module_name, 'Packing Table Count', G_Packing_Detail_Tab.count);

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

430: IF l_debug_on THEN
431: wsh_debug_sv.log (l_module_name, 'Return Status from Pack Lines', l_return_status);
432: END IF;
433:
434: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
436: END IF;
437: END IF;
438:

Line 435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

431: wsh_debug_sv.log (l_module_name, 'Return Status from Pack Lines', l_return_status);
432: END IF;
433:
434: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
436: END IF;
437: END IF;
438:
439: Update_Delivery_Details(

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

444: IF l_debug_on THEN
445: wsh_debug_sv.log (l_module_name, 'Return Status from Update Del Details', l_return_status);
446: END IF;
447:
448: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
450: END IF;
451:
452:

Line 449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

445: wsh_debug_sv.log (l_module_name, 'Return Status from Update Del Details', l_return_status);
446: END IF;
447:
448: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
450: END IF;
451:
452:
453: IF l_debug_on THEN

Line 459: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

455: END IF;
456:
457: EXCEPTION
458: WHEN invalid_action_code THEN
459: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
460: IF l_debug_on THEN
461: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
463: END IF;

Line 465: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

461: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
463: END IF;
464: WHEN invalid_input THEN
465: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
469: END IF;

Line 471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

467: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
469: END IF;
470: WHEN Others THEN
471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
474: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
475: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 488: l_new_detail_ids WSH_UTIL_CORE.Id_Tab_Type;

484: p_action_code IN VARCHAR2,
485: x_return_status OUT NOCOPY VARCHAR2) IS
486: -- local variables
487: l_new_del_detail_id NUMBER;
488: l_new_detail_ids WSH_UTIL_CORE.Id_Tab_Type;
489: l_table_count NUMBER;
490: l_return_status VARCHAR2(30);
491:
492: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

Line 577: l_cont_tab wsh_util_core.id_tab_type;

573: l_msg_details varchar2(2000);
574: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
575:
576: -- K LPN CONV. rv
577: l_cont_tab wsh_util_core.id_tab_type;
578: l_lpn_unit_weight NUMBER;
579: l_lpn_unit_volume NUMBER;
580: l_lpn_weight_uom_code VARCHAR2(100);
581: l_lpn_volume_uom_code VARCHAR2(100);

Line 606: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

602: wsh_debug_sv.log (l_module_name, 'New Delivery Id', p_new_delivery_id);
603: wsh_debug_sv.log (l_module_name,'Action Code ',p_action_code);
604: END IF;
605:
606: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
607:
608: IF(p_delivery_interface_id IS NULL) THEN
609: raise invalid_input;
610: END IF;

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

865: l_del_details_info.EARLIEST_PICKUP_DATE := del_det_int_rec.EARLIEST_PICKUP_DATE;
866: l_del_details_info.LATEST_PICKUP_DATE := del_det_int_rec.LATEST_PICKUP_DATE;
867: l_del_details_info.EARLIEST_DROPOFF_DATE:= del_det_int_rec.EARLIEST_DROPOFF_DATE;
868: l_del_details_info.LATEST_DROPOFF_DATE := del_det_int_rec.LATEST_DROPOFF_DATE;
869: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
870: AND wsh_util_core.tp_is_installed = 'Y')
871: THEN
872: l_del_details_info.ignore_for_planning := 'Y';
873: END IF;

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

866: l_del_details_info.LATEST_PICKUP_DATE := del_det_int_rec.LATEST_PICKUP_DATE;
867: l_del_details_info.EARLIEST_DROPOFF_DATE:= del_det_int_rec.EARLIEST_DROPOFF_DATE;
868: l_del_details_info.LATEST_DROPOFF_DATE := del_det_int_rec.LATEST_DROPOFF_DATE;
869: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
870: AND wsh_util_core.tp_is_installed = 'Y')
871: THEN
872: l_del_details_info.ignore_for_planning := 'Y';
873: END IF;
874:

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

925: wsh_debug_sv.log (l_module_name, 'Create Shipment Lines l_new_del_detail_id,l_return_status',
926: l_new_del_detail_id||','||l_return_status);
927: END IF;
928:
929: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
930:
931: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
932: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
933:

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

1022: l_return_status',l_cont_instance_id||','||l_return_status);
1023: END IF;
1024: */
1025:
1026: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1027: raise create_cont_instance_failed;
1028: END IF;
1029:
1030:

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

1068: IF l_debug_on THEN
1069: wsh_debug_sv.log (l_module_name, 'Add_To_Update_Table l_return_status',l_return_status);
1070: END IF;
1071:
1072: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1073: raise add_to_update_failed;
1074: END IF;
1075:
1076: -- Process Interface freight costs

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

1091: IF l_debug_on THEN
1092: wsh_debug_sv.log (l_module_name,'Return status from Process Int Freight Costs',l_return_status);
1093: END IF;
1094:
1095: IF( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1096: raise freight_cost_processing_error;
1097: END IF;
1098:
1099: END IF;

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

1127: wsh_debug_sv.log (l_module_name, 'Detail to Delivery api msg count', l_msg_count);
1128: wsh_debug_sv.log (l_module_name, 'Detail to Delivery api msg data', l_msg_data);
1129: END IF;
1130:
1131: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1132: raise new_assignment_failed;
1133: END IF;
1134: END IF;
1135:

Line 1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1137: wsh_debug_sv.pop(l_module_name);
1138: END IF;
1139: EXCEPTION
1140: WHEN FND_API.G_EXC_ERROR THEN
1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1142: IF l_debug_on THEN
1143: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1144: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');
1145: END IF;

Line 1147: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1143: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1144: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');
1145: END IF;
1146: WHEN create_cont_instance_failed THEN
1147: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'create_cont_instance_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_cont_instance_failed');
1151: END IF;

Line 1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1149: WSH_DEBUG_SV.logmsg(l_module_name,'create_cont_instance_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_cont_instance_failed');
1151: END IF;
1152: WHEN invalid_input THEN
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1154: IF l_debug_on THEN
1155: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
1157: END IF;

Line 1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1157: END IF;
1158: WHEN create_lines_failed THEN
1159: FND_MESSAGE.SET_NAME('WSH', 'WSH_CREATE_LINES_FAILED');
1160: FND_MESSAGE.SET_TOKEN('DET_INT',del_det_int_rec.delivery_detail_interface_id);
1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name,'create_lines_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_lines_failed');
1165: END IF;

Line 1169: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1165: END IF;
1166: WHEN new_assignment_failed THEN
1167: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSGN_ERROR');
1168: FND_MESSAGE.SET_TOKEN('DLVY', p_new_delivery_id);
1169: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name,'new_assignment_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:new_assignment_failed');
1173: END IF;

Line 1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1171: WSH_DEBUG_SV.logmsg(l_module_name,'new_assignment_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:new_assignment_failed');
1173: END IF;
1174: WHEN freight_cost_processing_error THEN
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1176: IF l_debug_on THEN
1177: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1178: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
1179: END IF;

Line 1181: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1177: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1178: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
1179: END IF;
1180: WHEN Others THEN
1181: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1184: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1251: x_return_status := wsh_util_core.g_ret_sts_success;

1247: p_delivery_interface_id);
1248: wsh_debug_sv.LOG(l_module_name, 'Delivery Id', p_delivery_id);
1249: END IF;
1250:
1251: x_return_status := wsh_util_core.g_ret_sts_success;
1252:
1253: IF (p_delivery_interface_id IS NULL) THEN
1254: RAISE invalid_input;
1255: END IF;

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

1299: p_qty_to_split => l_total_req_qty,
1300: x_new_detail_id => l_new_split_detail_id,
1301: x_return_status => l_return_status);
1302:
1303: wsh_util_core.api_post_call(p_return_status => l_return_status,
1304: x_num_warnings => l_number_of_warnings,
1305: x_num_errors => l_number_of_errors);
1306:
1307: -- For the newly created base delivery detail, make updates

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

1328: add_to_update_table(p_del_det_int_rec => l_prev_int_rec,
1329: p_update_mode => 'UPDATE', p_delivery_id => l_delivery_id,
1330: x_return_status => l_return_status);
1331:
1332: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1333: RAISE fnd_api.g_exc_error;
1334: END IF;
1335:
1336: --

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

1351: split_delivery_detail(p_delivery_detail_id => l_prev_int_rec.delivery_detail_id,
1352: p_qty_to_split => l_total_req_qty,
1353: x_new_detail_id => l_new_split_detail_id,
1354: x_return_status => l_return_status);
1355: wsh_util_core.api_post_call(p_return_status => l_return_status,
1356: x_num_warnings => l_number_of_warnings,
1357: x_num_errors => l_number_of_errors);
1358:
1359: -- For the newly created base delivery detail, make updates

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

1378: add_to_update_table(p_del_det_int_rec => l_prev_int_rec,
1379: p_update_mode => 'UPDATE', p_delivery_id => l_delivery_id,
1380: x_return_status => l_return_status);
1381:
1382: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1383: RAISE fnd_api.g_exc_error;
1384: END IF;
1385:
1386: add_to_serial_table(p_serial_range_tab => l_serial_range_tab);

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

1398: add_to_update_table(p_del_det_int_rec => l_prev_int_rec,
1399: p_update_mode => 'UPDATE', p_delivery_id => l_delivery_id,
1400: x_return_status => l_return_status);
1401:
1402: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1403: RAISE fnd_api.g_exc_error;
1404: END IF;
1405:
1406: add_to_serial_table(p_serial_range_tab => l_serial_range_tab);

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

1477: wsh_debug_sv.LOG(l_module_name,
1478: 'Process_Int_Freight_Costs l_return_status', l_return_status);
1479: END IF;
1480:
1481: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1482: RAISE freight_cost_processing_error;
1483: END IF;
1484: END IF;
1485:

Line 1507: wsh_util_core.api_post_call(

1503: p_qty_to_split => l_total_req_qty,
1504: x_new_detail_id => l_new_split_detail_id,
1505: x_return_status => l_return_status);
1506: --
1507: wsh_util_core.api_post_call(
1508: p_return_status => l_return_status,
1509: x_num_warnings => l_number_of_warnings,
1510: x_num_errors => l_number_of_errors);
1511:

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

1527: p_update_mode => 'UPDATE',
1528: p_delivery_id => l_delivery_id,
1529: x_return_status => l_return_status);
1530:
1531: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1532: RAISE fnd_api.g_exc_error;
1533: END IF;
1534: --
1535: add_to_serial_table(p_serial_range_tab => l_serial_range_tab);

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

1542: add_to_update_table(p_del_det_int_rec => l_prev_int_rec,
1543: p_update_mode => 'UPDATE', p_delivery_id => l_delivery_id,
1544: x_return_status => l_return_status);
1545:
1546: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1547: RAISE fnd_api.g_exc_error;
1548: END IF;
1549: --
1550: add_to_serial_table(p_serial_range_tab => l_serial_range_tab);

Line 1581: WHEN wsh_util_core.g_exc_warning THEN

1577: wsh_debug_sv.pop(l_module_name,
1578: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1579: END IF;
1580: --
1581: WHEN wsh_util_core.g_exc_warning THEN
1582: x_return_status := wsh_util_core.g_ret_sts_warning;
1583: --
1584: IF l_debug_on THEN
1585: wsh_debug_sv.logmsg(l_module_name,

Line 1582: x_return_status := wsh_util_core.g_ret_sts_warning;

1578: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1579: END IF;
1580: --
1581: WHEN wsh_util_core.g_exc_warning THEN
1582: x_return_status := wsh_util_core.g_ret_sts_warning;
1583: --
1584: IF l_debug_on THEN
1585: wsh_debug_sv.logmsg(l_module_name,
1586: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',

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

1582: x_return_status := wsh_util_core.g_ret_sts_warning;
1583: --
1584: IF l_debug_on THEN
1585: wsh_debug_sv.logmsg(l_module_name,
1586: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
1587: wsh_debug_sv.c_excep_level);
1588: wsh_debug_sv.pop(l_module_name,
1589: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1590: END IF;

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

1585: wsh_debug_sv.logmsg(l_module_name,
1586: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
1587: wsh_debug_sv.c_excep_level);
1588: wsh_debug_sv.pop(l_module_name,
1589: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1590: END IF;
1591: --
1592: WHEN invalid_input THEN
1593: x_return_status := wsh_util_core.g_ret_sts_error;

Line 1593: x_return_status := wsh_util_core.g_ret_sts_error;

1589: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1590: END IF;
1591: --
1592: WHEN invalid_input THEN
1593: x_return_status := wsh_util_core.g_ret_sts_error;
1594:
1595: IF l_debug_on THEN
1596: wsh_debug_sv.logmsg(l_module_name,
1597: 'invalid_input exception has occured.',

Line 1602: x_return_status := wsh_util_core.g_ret_sts_error;

1598: wsh_debug_sv.c_excep_level);
1599: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:invalid_input');
1600: END IF;
1601: WHEN freight_cost_processing_error THEN
1602: x_return_status := wsh_util_core.g_ret_sts_error;
1603:
1604: IF l_debug_on THEN
1605: wsh_debug_sv.logmsg(l_module_name,
1606: 'freight_cost_processing_error exception has occured.',

Line 1612: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1608: wsh_debug_sv.pop(l_module_name,
1609: 'EXCEPTION:freight_cost_processing_error');
1610: END IF;
1611: WHEN OTHERS THEN
1612: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1613:
1614: IF l_debug_on THEN
1615: wsh_debug_sv.logmsg(l_module_name,
1616: 'Unexpected error has occured. Oracle error message is '

Line 1629: l_del_detail_tab WSH_UTIL_CORE.id_tab_type;

1625: x_return_status OUT NOCOPY VARCHAR2) IS
1626: -- variables
1627: l_return_status VARCHAR2(30);
1628: l_pack_status VARCHAR2(30);
1629: l_del_detail_tab WSH_UTIL_CORE.id_tab_type;
1630:
1631: --exceptions
1632: packing_failed exception;
1633:

Line 1653: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1649: wsh_debug_sv.push(l_module_name, 'Pack_Lines');
1650: wsh_debug_sv.log (l_module_name, 'Packing Table Count', G_Packing_Detail_Tab.count);
1651: END IF;
1652:
1653: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1654:
1655: FOR i in 1..G_Packing_Detail_Tab.count LOOP
1656: -- Need to delete the table because we pass only one delivery detail per call
1657: l_del_detail_tab.delete;

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

1673: IF l_debug_on THEN
1674: wsh_debug_sv.log (l_module_name,'Return Status from Assign_Detail', l_return_status);
1675: END IF;
1676:
1677: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1678: FND_MESSAGE.SET_NAME('WSH','WSH_PACKING_ERROR');
1679: FND_MESSAGE.SET_TOKEN('DEL_DETAIL', G_Packing_Detail_Tab(i).Delivery_Detail_Id);
1680: raise packing_failed;
1681: END IF;

Line 1690: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1686: END IF;
1687:
1688: EXCEPTION
1689: WHEN packing_failed THEN
1690: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1691: IF l_debug_on THEN
1692: WSH_DEBUG_SV.logmsg(l_module_name,'packing_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_failed');
1694: END IF;

Line 1696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1692: WSH_DEBUG_SV.logmsg(l_module_name,'packing_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_failed');
1694: END IF;
1695: WHEN Others THEN
1696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1697: IF l_debug_on THEN
1698: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1699: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1700: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1956: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1952: wsh_debug_sv.log (l_module_name,'Action Code', p_action_code);
1953: wsh_debug_sv.log (l_module_name, 'Warehouse type', WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE);
1954: END IF;
1955:
1956: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1957:
1958: IF(p_delivery_interface_id IS NULL)
1959: THEN
1960: raise fnd_api.g_exc_error;

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

1992: l_del_int_rec.delivered_date;
1993: ELSIF p_action_code = 'CREATE' THEN
1994: l_dlvy_attr_tab(l_index).shipment_direction :=
1995: l_del_int_rec.shipment_direction;
1996: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
1997: AND wsh_util_core.tp_is_installed = 'Y')
1998: THEN
1999: l_dlvy_attr_tab(l_index).ignore_for_planning := 'Y';
2000: END IF;

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

1993: ELSIF p_action_code = 'CREATE' THEN
1994: l_dlvy_attr_tab(l_index).shipment_direction :=
1995: l_del_int_rec.shipment_direction;
1996: IF (WSH_UTIL_CORE.GC3_IS_INSTALLED = 'N'
1997: AND wsh_util_core.tp_is_installed = 'Y')
1998: THEN
1999: l_dlvy_attr_tab(l_index).ignore_for_planning := 'Y';
2000: END IF;
2001: END IF; -- if p_action_code=update

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

2313: IF l_debug_on THEN
2314: wsh_debug_sv.log (l_module_name, 'Return status from process int freight costs', l_return_status);
2315: END IF;
2316: --
2317: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2318: raise freight_cost_processing_error;
2319: END IF;
2320: -- }
2321: END IF;

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

2348: wsh_debug_sv.log (l_module_name, 'Create Update Delivery api msg count', l_msg_count);
2349: wsh_debug_sv.log (l_module_name, 'Create Update Delivery api msg', l_msg_data);
2350: END IF;
2351:
2352: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2353: THEN
2354: -- {
2355: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2356: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;

Line 2416: WHEN wsh_util_core.g_exc_warning THEN

2412: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
2413: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2414: END IF;
2415: --
2416: WHEN wsh_util_core.g_exc_warning THEN
2417: x_return_status := wsh_util_core.g_ret_sts_warning;
2418: --
2419: IF l_debug_on THEN
2420: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);

Line 2417: x_return_status := wsh_util_core.g_ret_sts_warning;

2413: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2414: END IF;
2415: --
2416: WHEN wsh_util_core.g_exc_warning THEN
2417: x_return_status := wsh_util_core.g_ret_sts_warning;
2418: --
2419: IF l_debug_on THEN
2420: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
2421: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

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

2416: WHEN wsh_util_core.g_exc_warning THEN
2417: x_return_status := wsh_util_core.g_ret_sts_warning;
2418: --
2419: IF l_debug_on THEN
2420: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
2421: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2422: END IF;
2423: --
2424: WHEN invalid_ship_method THEN

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

2417: x_return_status := wsh_util_core.g_ret_sts_warning;
2418: --
2419: IF l_debug_on THEN
2420: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
2421: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2422: END IF;
2423: --
2424: WHEN invalid_ship_method THEN
2425: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2425: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2421: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2422: END IF;
2423: --
2424: WHEN invalid_ship_method THEN
2425: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2426: IF l_debug_on THEN
2427: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_ship_method exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2428: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_ship_method');
2429: END IF;

Line 2431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2427: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_ship_method exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2428: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_ship_method');
2429: END IF;
2430: WHEN freight_cost_processing_error THEN
2431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2432: IF l_debug_on THEN
2433: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
2435: END IF;

Line 2437: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2433: WSH_DEBUG_SV.logmsg(l_module_name,'freight_cost_processing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
2435: END IF;
2436: WHEN OTHERS THEN
2437: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2438: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.PROCESS_INTERFACED_DELIVERIES');
2439:
2440: IF l_debug_on THEN
2441: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);

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

2434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
2435: END IF;
2436: WHEN OTHERS THEN
2437: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2438: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.PROCESS_INTERFACED_DELIVERIES');
2439:
2440: IF l_debug_on THEN
2441: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);
2442: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

Line 2546: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2542: wsh_debug_sv.log (l_module_name,'Delivery interface Id', p_delivery_interface_id);
2543: wsh_debug_sv.log (l_module_name,'Action Code', p_action_code);
2544: END IF;
2545:
2546: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2547:
2548: l_action_code := p_action_code;
2549:
2550: -- First process the delivery

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

2572: IF l_debug_on THEN
2573: wsh_debug_sv.log (l_module_name,'Return status from lock delivery and details', l_return_status);
2574: END IF;
2575:
2576: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2577: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2578: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
2579: l_loc_interface_error_rec.p_message_name := 'WSH_NO_LOCK';
2580:

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

2601: IF l_debug_on THEN
2602: wsh_debug_sv.log (l_module_name, 'Return Status from Process Deliveries', l_return_status);
2603: END IF;
2604:
2605: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2606: raise process_delivery_failed;
2607: END IF;
2608:
2609: IF(l_action_code = 'CREATE' AND l_created_delivery_id is NULL ) THEN

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

2624: IF l_debug_on THEN
2625: wsh_debug_sv.log (l_module_name, 'Return Status from Process Details', l_return_status);
2626: END IF;
2627:
2628: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2629: raise process_del_details_failed;
2630: END IF;
2631:
2632: -- J: W/V Changes

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

2665: IF l_debug_on THEN
2666: wsh_debug_sv.log (l_module_name, 'Return status from WSH_WV_UTILS.Del_WV_Post_Process ',l_return_status);
2667: END IF;
2668:
2669: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2670:
2671: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2672: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
2673:

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

2704: IF l_debug_on THEN
2705: wsh_debug_sv.log (l_module_name, 'Return Status from Process Cancel', l_return_status);
2706: END IF;
2707:
2708: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2709: raise cancel_lines_failed;
2710: END IF;
2711:
2712: ELSE

Line 2722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2718: END IF;
2719:
2720: EXCEPTION
2721: WHEN invalid_input THEN
2722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2723: IF l_debug_on THEN
2724: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
2726: END IF;

Line 2728: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2724: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
2726: END IF;
2727: WHEN no_lock_found THEN
2728: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2729: IF l_debug_on THEN
2730: WSH_DEBUG_SV.logmsg(l_module_name,'no_lock_found exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2731: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:no_lock_found');
2732: END IF;

Line 2734: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2730: WSH_DEBUG_SV.logmsg(l_module_name,'no_lock_found exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2731: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:no_lock_found');
2732: END IF;
2733: WHEN invalid_action_code THEN
2734: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2735: IF l_debug_on THEN
2736: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
2738: END IF;

Line 2740: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2736: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_code');
2738: END IF;
2739: WHEN process_delivery_failed THEN
2740: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');
2744: END IF;

Line 2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');
2744: END IF;
2745: -- J: W/V Changes
2746: WHEN process_delivery_wv_failed THEN
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2748: IF l_debug_on THEN
2749: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_wv_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_wv_failed');
2751: END IF;

Line 2753: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2749: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_wv_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_wv_failed');
2751: END IF;
2752: WHEN process_del_details_failed THEN
2753: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'process_del_details_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2756: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_del_details_failed');
2757: END IF;

Line 2759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2755: WSH_DEBUG_SV.logmsg(l_module_name,'process_del_details_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2756: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_del_details_failed');
2757: END IF;
2758: WHEN cancel_lines_failed THEN
2759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2760: IF l_debug_on THEN
2761: WSH_DEBUG_SV.logmsg(l_module_name,'cancel_lines_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2762: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cancel_lines_failed');
2763: END IF;

Line 2765: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2761: WSH_DEBUG_SV.logmsg(l_module_name,'cancel_lines_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2762: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cancel_lines_failed');
2763: END IF;
2764: WHEN Others THEN
2765: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2766: IF l_debug_on THEN
2767: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2768: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2905: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2901: wsh_debug_sv.log (l_module_name,'Delivery interface Id', p_delivery_interface_id);
2902: wsh_debug_sv.log (l_module_name,'del_detail_interface_id', p_del_detail_interface_id);
2903: END IF;
2904:
2905: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2906:
2907:
2908: IF(p_del_detail_interface_id IS NOT NULL) THEN
2909: l_entity_interface_id := p_del_detail_interface_id;

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

3047: wsh_debug_sv.log (l_module_name, 'Create Update Freight Costs api msg', l_msg_data);
3048: wsh_debug_sv.log (l_module_name, 'freight_cost id created', l_freight_cost_id);
3049: END IF;
3050:
3051: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3052: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';
3053: l_loc_interface_error_rec.p_interface_id := l_entity_interface_id;
3054:
3055: Log_Errors(

Line 3063: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3059: x_return_status => l_return_status);
3060: IF l_debug_on THEN
3061: wsh_debug_sv.log (l_module_name, 'Log_Errors l_return_status',l_return_status);
3062: END IF;
3063: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3064: END IF;
3065:
3066: END LOOP;
3067:

Line 3074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3070: END IF;
3071:
3072: EXCEPTION
3073: WHEN invalid_input THEN
3074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3075: IF l_debug_on THEN
3076: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3077: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
3078: END IF;

Line 3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3076: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3077: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
3078: END IF;
3079: WHEN invalid_freight_cost_type THEN
3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3081: IF l_debug_on THEN
3082: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_freight_cost_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3083: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_freight_cost_type');
3084: END IF;

Line 3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3088: WSH_DEBUG_SV.logmsg(l_module_name,'no_freight_record exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3089: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:no_freight_record');
3090: END IF;
3091: WHEN Others THEN
3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3093: IF l_debug_on THEN
3094: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
3095: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3160: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3156: wsh_debug_sv.log (l_module_name, 'Update Table Count', G_Update_Attributes_Tab.count);
3157: wsh_debug_sv.log(l_module_name, 'Serial Range Tab count',G_SERIAL_RANGE_TAB.count);
3158: END IF;
3159:
3160: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3161: -- Use the global table to call create_update Group API
3162:
3163: IF(G_Update_Attributes_Tab.count > 0 ) THEN
3164: l_in_rec.caller := 'WSH_INBOUND';

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

3184: wsh_debug_sv.log (l_module_name, 'Update Ship Attr api msg count', l_msg_count);
3185: wsh_debug_sv.log (l_module_name, 'Update Ship Attr api msg data', l_msg_data);
3186: END IF;
3187:
3188: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3189: -- Need to insert record in interface errors table only
3190: -- for 'OE' source code, i.e during 945 inbound
3191: -- For 940 inbound - cancel case, there may not be any
3192: -- data in interface tables.

Line 3219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3215: END IF;
3216:
3217: EXCEPTION
3218: WHEN update_shipping_att_failed THEN
3219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3220: IF l_debug_on THEN
3221: WSH_DEBUG_SV.logmsg(l_module_name,'update_shipping_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_shipping_att_failed');
3223: END IF;

Line 3225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3221: WSH_DEBUG_SV.logmsg(l_module_name,'update_shipping_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_shipping_att_failed');
3223: END IF;
3224: WHEN cont_upd_ship_att_failed THEN
3225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3226: IF l_debug_on THEN
3227: WSH_DEBUG_SV.logmsg(l_module_name,'cont_upd_ship_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cont_upd_ship_att_failed');
3229: END IF;

Line 3231: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3227: WSH_DEBUG_SV.logmsg(l_module_name,'cont_upd_ship_att_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:cont_upd_ship_att_failed');
3229: END IF;
3230: WHEN Others THEN
3231: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3232: IF l_debug_on THEN
3233: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
3234: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3267: l_del_rows wsh_util_core.id_tab_type;

3263: x_trip_id OUT NOCOPY NUMBER,
3264: x_return_status OUT NOCOPY VARCHAR2) IS
3265:
3266: -- variables
3267: l_del_rows wsh_util_core.id_tab_type;
3268:
3269: l_pickup_stop_id NUMBER ;
3270: l_dropoff_stop_id NUMBER ;
3271: l_delivery_leg_id NUMBER ;

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

3280: l_dropoff_stop_int_id NUMBER;
3281:
3282: l_return_status VARCHAR2(30);
3283:
3284: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3285: l_dbi_rs VARCHAR2(1); -- DBI Project
3286:
3287: -- cursors
3288: CURSOR del_trip_stops IS

Line 3350: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3346: wsh_debug_sv.push(l_module_name,'Create_Update_Trip_For_Dlvy');
3347: wsh_debug_sv.log (l_module_name, 'Delivery id', p_delivery_id);
3348: END IF;
3349:
3350: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3351:
3352: IF(p_delivery_id IS NULL) THEN
3353: raise invalid_input;
3354: END IF;

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

3379: wsh_debug_sv.log (l_module_name, 'Return status from autocreate trip', l_return_status);
3380: wsh_debug_sv.log (l_module_name, 'Trip created', l_trip_id);
3381: END IF;
3382:
3383: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3384: x_return_status := l_return_status;
3385: raise trip_creation_failed;
3386: END IF;
3387:

Line 3451: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3447:
3448: IF l_debug_on THEN
3449: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3450: END IF;
3451: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3452: x_return_status := l_dbi_rs;
3453: -- just pass this return status to caller API
3454: IF l_debug_on THEN
3455: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 3504: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3500:
3501: IF l_debug_on THEN
3502: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3503: END IF;
3504: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3505: x_return_status := l_dbi_rs;
3506: -- just pass this return status to caller API
3507: IF l_debug_on THEN
3508: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 3560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3556: wsh_debug_sv.pop(l_module_name);
3557: END IF;
3558: EXCEPTION
3559: WHEN trip_creation_failed THEN
3560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3561: IF l_debug_on THEN
3562: WSH_DEBUG_SV.logmsg(l_module_name,'trip_creation_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:trip_creation_failed');
3564: END IF;

Line 3566: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3562: WSH_DEBUG_SV.logmsg(l_module_name,'trip_creation_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:trip_creation_failed');
3564: END IF;
3565: WHEN invalid_input THEN
3566: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3567: IF l_debug_on THEN
3568: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
3570: END IF;

Line 3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3568: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
3570: END IF;
3571: WHEN Others THEN
3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3573: IF l_debug_on THEN
3574: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
3575: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3628: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3624: wsh_debug_sv.log (l_module_name, 'Routing Ins', p_trip_routing_ins);
3625: wsh_debug_sv.log (l_module_name, 'p_operator', p_operator);
3626: END IF;
3627:
3628: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3629: -- get delivery_leg_interface_id, stop_interface_id, trip_interface_id
3630:
3631: SELECT
3632: WSH_DEL_LEGS_INTERFACE_S.nextval,

Line 3744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3740: END IF;
3741: EXCEPTION
3742:
3743: WHEN Others THEN
3744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3745: IF l_debug_on THEN
3746: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
3747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3976: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3972: WHEN packing_error THEN
3973: IF(base_detail_cur%ISOPEN) THEN
3974: CLOSE base_detail_cur;
3975: END IF;
3976: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3977: IF l_debug_on THEN
3978: WSH_DEBUG_SV.logmsg(l_module_name,'packing_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3979: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_error');
3980: END IF;

Line 3983: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3979: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:packing_error');
3980: END IF;
3981:
3982: WHEN Others THEN
3983: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3984: IF l_debug_on THEN
3985: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
3986: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4030: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4026: wsh_debug_sv.push(l_module_name, 'Process_Cancel');
4027: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
4028: END IF;
4029:
4030: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4031:
4032: -- select the delivery lines
4033: -- Add to the global update table
4034:

Line 4076: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4072: END IF;
4073:
4074: EXCEPTION
4075: WHEN Others THEN
4076: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4077: IF l_debug_on THEN
4078: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
4079: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4121: x_return_status := wsh_util_core.g_ret_sts_success;

4117: wsh_debug_sv.push(l_module_name, 'Lock_Delivery_And_Details');
4118: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
4119: END IF;
4120:
4121: x_return_status := wsh_util_core.g_ret_sts_success;
4122:
4123: IF l_debug_on THEN
4124: wsh_debug_sv.logmsg(l_module_name, 'Locking the Delivery');
4125: END IF;

Line 4142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4138: IF l_debug_on THEN
4139: wsh_debug_sv.logmsg(l_module_name, 'No details found');
4140: END IF;
4141:
4142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4143: CLOSE lock_delivery_details;
4144: END IF;
4145: IF (lock_delivery_details%ISOPEN) THEN
4146: CLOSE lock_delivery_details;

Line 4154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4150: END IF;
4151:
4152: EXCEPTION
4153: WHEN RECORD_LOCKED THEN
4154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4155:
4156: IF l_debug_on THEN
4157: wsh_debug_sv.logmsg(l_module_name, 'Could not obtain lock');
4158: END IF;

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

4157: wsh_debug_sv.logmsg(l_module_name, 'Could not obtain lock');
4158: END IF;
4159:
4160: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
4161: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
4162: IF l_debug_on THEN
4163: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
4165: END IF;

Line 4168: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
4165: END IF;
4166:
4167: WHEN others THEN
4168: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4169: IF l_debug_on THEN
4170: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
4171: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4211: wsh_debug_sv.pop(l_module_name);
4212: END IF;
4213: EXCEPTION
4214: WHEN others THEN
4215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4216: IF l_debug_on THEN
4217: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
4218: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4219: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

4280:
4281: IF p_qty_to_split IS NULL THEN
4282: fnd_message.set_name('WSH', 'WSH_REQUIRED_FIELD_NULL');
4283: fnd_message.set_token('FIELD_NAME', 'REQUESTED_QTY');
4284: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
4285: RAISE FND_API.G_EXC_ERROR;
4286: END IF;
4287:
4288: l_qty_to_split := p_qty_to_split;

Line 4300: wsh_util_core.api_post_call(

4296: wsh_debug_sv.LOG(l_module_name, 'Split_Delivery_Details x_new_detail_id,l_return_status',
4297: x_new_detail_id || ',' || l_return_status);
4298: END IF;
4299:
4300: wsh_util_core.api_post_call(
4301: p_return_status =>l_return_status,
4302: x_num_warnings =>l_number_of_warnings,
4303: x_num_errors =>l_number_of_errors);
4304: END IF;

Line 4310: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

4306: IF l_number_of_warnings > 0 THEN
4307: IF l_debug_on THEN
4308: wsh_debug_sv.logmsg (l_module_name,'Number of warnings', l_number_of_warnings);
4309: END IF;
4310: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4311: END IF;
4312:
4313: x_return_status := wsh_util_core.g_ret_sts_success;
4314:

Line 4313: x_return_status := wsh_util_core.g_ret_sts_success;

4309: END IF;
4310: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4311: END IF;
4312:
4313: x_return_status := wsh_util_core.g_ret_sts_success;
4314:
4315: IF l_debug_on THEN
4316: wsh_debug_sv.pop(l_module_name);
4317: END IF;

Line 4340: WHEN wsh_util_core.g_exc_warning THEN

4336: wsh_debug_sv.pop(l_module_name,
4337: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4338: END IF;
4339: --
4340: WHEN wsh_util_core.g_exc_warning THEN
4341: x_return_status := wsh_util_core.g_ret_sts_warning;
4342: --
4343: IF l_debug_on THEN
4344: wsh_debug_sv.logmsg(l_module_name,

Line 4341: x_return_status := wsh_util_core.g_ret_sts_warning;

4337: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4338: END IF;
4339: --
4340: WHEN wsh_util_core.g_exc_warning THEN
4341: x_return_status := wsh_util_core.g_ret_sts_warning;
4342: --
4343: IF l_debug_on THEN
4344: wsh_debug_sv.logmsg(l_module_name,
4345: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',

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

4341: x_return_status := wsh_util_core.g_ret_sts_warning;
4342: --
4343: IF l_debug_on THEN
4344: wsh_debug_sv.logmsg(l_module_name,
4345: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
4346: wsh_debug_sv.c_excep_level);
4347: wsh_debug_sv.pop(l_module_name,
4348: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4349: END IF;

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

4344: wsh_debug_sv.logmsg(l_module_name,
4345: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
4346: wsh_debug_sv.c_excep_level);
4347: wsh_debug_sv.pop(l_module_name,
4348: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4349: END IF;
4350: WHEN OTHERS THEN
4351: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4352: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');

Line 4351: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

4347: wsh_debug_sv.pop(l_module_name,
4348: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4349: END IF;
4350: WHEN OTHERS THEN
4351: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4352: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');
4353: --
4354: IF l_debug_on THEN
4355: wsh_debug_sv.logmsg(l_module_name,

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

4348: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4349: END IF;
4350: WHEN OTHERS THEN
4351: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4352: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');
4353: --
4354: IF l_debug_on THEN
4355: wsh_debug_sv.logmsg(l_module_name,
4356: 'Unexpected error has occured. Oracle error message is '