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

Line 85: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

81: WSH_DEBUG_SV.log(l_module_name,'p_delivery_info.name',
82: p_delivery_info.name);
83: END IF;
84: --
85: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
86: x_delivery_id := p_delivery_info.delivery_id;
87: x_name := p_delivery_info.name;
88:
89: -- get next delivery id

Line 497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

493: --
494: EXCEPTION
495: WHEN wsh_duplicate_name THEN
496: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
498: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
499: --
500: IF l_debug_on THEN
501: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DUPLICATE_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 498: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

494: EXCEPTION
495: WHEN wsh_duplicate_name THEN
496: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
498: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
499: --
500: IF l_debug_on THEN
501: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DUPLICATE_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
502: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DUPLICATE_NAME');

Line 506: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',l_module_name);

502: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DUPLICATE_NAME');
503: END IF;
504: --
505: WHEN others THEN
506: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',l_module_name);
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
508: --
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

503: END IF;
504: --
505: WHEN others THEN
506: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',l_module_name);
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
508: --
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
511: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 575: l_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;

571: l_num_errors NUMBER := 0;
572: l_num_warnings NUMBER := 0;
573: --WF: CMR
574: l_wf_rs VARCHAR2(1);
575: l_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
576: l_del_old_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
577: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
578: l_organization_id NUMBER;
579: -- Following two variable are added for Bugfix #4587421

Line 576: l_del_old_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

572: l_num_warnings NUMBER := 0;
573: --WF: CMR
574: l_wf_rs VARCHAR2(1);
575: l_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
576: l_del_old_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
577: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
578: l_organization_id NUMBER;
579: -- Following two variable are added for Bugfix #4587421
580: l_gross_weight NUMBER;

Line 577: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

573: --WF: CMR
574: l_wf_rs VARCHAR2(1);
575: l_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
576: l_del_old_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
577: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
578: l_organization_id NUMBER;
579: -- Following two variable are added for Bugfix #4587421
580: l_gross_weight NUMBER;
581: l_net_weight NUMBER;

Line 586: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

582:
583: --OTM R12
584: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
585: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
586: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
587: l_tms_update VARCHAR2(1);
588: l_trip_not_found VARCHAR2(1);
589: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
590: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

Line 618: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

614: --
615: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
616: END IF;
617: --
618: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
619:
620:
621: --OTM R12, initialize
622: l_tms_update := 'N';

Line 624: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable

620:
621: --OTM R12, initialize
622: l_tms_update := 'N';
623: l_new_interface_flag_tab(1) := NULL;
624: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
625:
626: IF l_gc3_is_installed IS NULL THEN
627: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
628: END IF;

Line 627: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function

623: l_new_interface_flag_tab(1) := NULL;
624: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
625:
626: IF l_gc3_is_installed IS NULL THEN
627: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
628: END IF;
629: --
630:
631: /*CURRENTLY NOT IN USE

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

744: IF l_debug_on THEN
745: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);
746: END IF;
747:
748: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
749: IF l_debug_on THEN
750: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
751: END IF;
752: RAISE api_return_fail;

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

771: IF l_debug_on THEN
772: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);
773: END IF;
774:
775: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
776: IF l_debug_on THEN
777: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
778: END IF;
779: RAISE api_return_fail;

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

1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
1035: END IF;
1036:
1037: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
1040: END IF;
1041: RAISE api_return_fail;

Line 1137: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

1133: p_diff_net_wt => l_diff_net_wt,
1134: p_diff_volume => l_diff_vol,
1135: x_return_status => l_return_status);
1136:
1137: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1138: raise e_wt_vol_fail;
1139: END IF;
1140:
1141: END IF;

Line 1163: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1159: p_old_net_wt => l_net_wt,
1160: p_new_net_wt => l_net_weight, -- BigFix #4587421
1161: p_weight_uom_code => l_weight_uom_code,
1162: x_return_status => l_return_status);
1163: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1164: x_return_status := l_return_status;
1165: --
1166: IF l_debug_on THEN
1167: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.prorate_weight',l_return_status);

Line 1170: wsh_util_core.api_post_call(

1166: IF l_debug_on THEN
1167: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.prorate_weight',l_return_status);
1168: END IF;
1169: --
1170: wsh_util_core.api_post_call(
1171: p_return_status => l_return_status,
1172: x_num_warnings => l_num_warnings,
1173: x_num_errors => l_num_errors);
1174: --

Line 1196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1192: -- J: W/V Changes
1193: WHEN e_wt_vol_fail THEN
1194: FND_MESSAGE.Set_Name('WSH','WSH_DEL_WT_VOL_FAILED');
1195: FND_MESSAGE.Set_Token('DEL_NAME', p_delivery_info.name);
1196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1197: WSH_UTIL_CORE.add_message (x_return_status);
1198: IF l_debug_on THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,'E_WT_VOL_FAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_WT_VOL_FAIL');

Line 1197: WSH_UTIL_CORE.add_message (x_return_status);

1193: WHEN e_wt_vol_fail THEN
1194: FND_MESSAGE.Set_Name('WSH','WSH_DEL_WT_VOL_FAILED');
1195: FND_MESSAGE.Set_Token('DEL_NAME', p_delivery_info.name);
1196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1197: WSH_UTIL_CORE.add_message (x_return_status);
1198: IF l_debug_on THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,'E_WT_VOL_FAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_WT_VOL_FAIL');
1201: END IF;

Line 1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1201: END IF;
1202:
1203: WHEN NO_DATA_FOUND THEN
1204: FND_MESSAGE.Set_Name('WSH','WSH_DEL_NOT_FOUND');
1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1206: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1207: --
1208: IF l_debug_on THEN
1209: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1206: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

1202:
1203: WHEN NO_DATA_FOUND THEN
1204: FND_MESSAGE.Set_Name('WSH','WSH_DEL_NOT_FOUND');
1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1206: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1207: --
1208: IF l_debug_on THEN
1209: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 1217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1213:
1214: --Bug # 3268641
1215: WHEN DUP_VAL_ON_INDEX THEN
1216: FND_MESSAGE.SET_NAME('WSH','WSH_ASSIGN_NEW_DEL');
1217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1218: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1219:
1220: IF l_debug_on THEN
1221: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1218: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1214: --Bug # 3268641
1215: WHEN DUP_VAL_ON_INDEX THEN
1216: FND_MESSAGE.SET_NAME('WSH','WSH_ASSIGN_NEW_DEL');
1217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1218: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1219:
1220: IF l_debug_on THEN
1221: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');

Line 1227: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',l_module_name);

1223: END IF;
1224: --
1225:
1226: WHEN others THEN
1227: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',l_module_name);
1228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1229: IF l_debug_on THEN
1230: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1231: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1224: --
1225:
1226: WHEN others THEN
1227: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',l_module_name);
1228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1229: IF l_debug_on THEN
1230: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1231: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1232: END IF;

Line 1278: l_mdc_del_tab WSH_UTIL_CORE.id_tab_type;

1274:
1275:
1276: l_delivery_id NUMBER;
1277: l_delivery_leg_id NUMBER;
1278: l_mdc_del_tab WSH_UTIL_CORE.id_tab_type;
1279:
1280: cannot_delete_delivery EXCEPTION;
1281: others EXCEPTION;
1282:

Line 1310: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1306: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
1307: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
1308: END IF;
1309: --
1310: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1311: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1312:
1313: l_num_warn := 0;
1314:

Line 1311: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1307: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
1308: END IF;
1309: --
1310: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1311: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1312:
1313: l_num_warn := 0;
1314:
1315: -- map rowid to a delivery_id

Line 1334: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1330: IF (p_validate_flag = 'Y') THEN
1331: wsh_delivery_validations.check_delete_delivery(
1332: p_delivery_id => l_delivery_id,
1333: x_return_status => l_return_status);
1334: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE cannot_delete_delivery;
1336: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1337: l_num_warn := l_num_warn + 1;
1338: END IF;

Line 1336: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1332: p_delivery_id => l_delivery_id,
1333: x_return_status => l_return_status);
1334: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE cannot_delete_delivery;
1336: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1337: l_num_warn := l_num_warn + 1;
1338: END IF;
1339: END IF;
1340:

Line 1358: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

1354: wsh_delivery_details_actions.unassign_detail_from_delivery
1355: (p_detail_id => dt.delivery_detail_id,
1356: x_return_status => l_return_status);
1357:
1358: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1359: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1360: x_return_status := l_return_status;
1361: ROLLBACK TO SAVEPOINT unassign_details;
1362: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');

Line 1359: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1355: (p_detail_id => dt.delivery_detail_id,
1356: x_return_status => l_return_status);
1357:
1358: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1359: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1360: x_return_status := l_return_status;
1361: ROLLBACK TO SAVEPOINT unassign_details;
1362: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
1363: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));

Line 1365: wsh_util_core.add_message(x_return_status,l_module_name);

1361: ROLLBACK TO SAVEPOINT unassign_details;
1362: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
1363: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1364: FND_MESSAGE.SET_TOKEN('DET_NAME',dt.delivery_detail_id);
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366: --
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.log(l_module_name,'x_return_status',
1369: x_return_status);

Line 1374: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1370: WSH_DEBUG_SV.pop(l_module_name);
1371: END IF;
1372: --
1373: RETURN;
1374: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1375: l_num_warn := l_num_warn + 1;
1376: END IF;
1377:
1378: END LOOP;

Line 1394: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1390: p_caller => 'WSH_DELETE_DEL',
1391: p_del_tab => l_mdc_del_tab,
1392: x_return_status => l_return_status);
1393: l_mdc_del_tab.delete;
1394: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1395: ROLLBACK TO wsh_before_delivery_delete;
1396: RAISE cannot_delete_delivery;
1397: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1398: l_num_warn := l_num_warn + 1;

Line 1397: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1393: l_mdc_del_tab.delete;
1394: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1395: ROLLBACK TO wsh_before_delivery_delete;
1396: RAISE cannot_delete_delivery;
1397: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1398: l_num_warn := l_num_warn + 1;
1399: END IF;
1400:
1401: END IF;

Line 1406: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1402:
1403: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg(
1404: p_delivery_leg_id => dl.delivery_leg_id,
1405: x_return_status => l_return_status);
1406: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1407: ) THEN
1408: ROLLBACK TO wsh_before_delivery_delete;
1409:
1410: RAISE cannot_delete_delivery;

Line 1411: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1407: ) THEN
1408: ROLLBACK TO wsh_before_delivery_delete;
1409:
1410: RAISE cannot_delete_delivery;
1411: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1412: l_num_warn := l_num_warn + 1;
1413: END IF;
1414: END LOOP;
1415:

Line 1441: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1437: RAISE others;
1438: END IF; --} l_delivery_id IS NOT NULL
1439: /* Bug 2310456 warning */
1440: IF l_num_warn > 0 THEN
1441: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1442: END IF;
1443: --
1444: IF l_debug_on THEN
1445: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 1466: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1462: END IF;
1463:
1464: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DELETE_ERROR');
1465: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1466: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1467: wsh_util_core.add_message(x_return_status,l_module_name);
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name,'CANNOT_DELETE_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1467: wsh_util_core.add_message(x_return_status,l_module_name);

1463:
1464: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DELETE_ERROR');
1465: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1466: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1467: wsh_util_core.add_message(x_return_status,l_module_name);
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name,'CANNOT_DELETE_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CANNOT_DELETE_DELIVERY');

Line 1490: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.DELETE_DELIVERY',l_module_name);

1486: IF (detail_info%ISOPEN) THEN
1487: CLOSE detail_info;
1488: END IF;
1489:
1490: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.DELETE_DELIVERY',l_module_name);
1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1492: --
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1487: CLOSE detail_info;
1488: END IF;
1489:
1490: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.DELETE_DELIVERY',l_module_name);
1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1492: --
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1495: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2230: FETCH delivery_record INTO x_delivery_info;
2231:
2232: IF (delivery_record%NOTFOUND) THEN
2233: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
2234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2235: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
2236: IF l_debug_on THEN
2237: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2238: END IF;

Line 2235: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

2231:
2232: IF (delivery_record%NOTFOUND) THEN
2233: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
2234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2235: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
2236: IF l_debug_on THEN
2237: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2238: END IF;
2239: ELSE

Line 2240: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2236: IF l_debug_on THEN
2237: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2238: END IF;
2239: ELSE
2240: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2241: END IF;
2242:
2243: CLOSE delivery_record;
2244: --

Line 2255: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',l_module_name);

2251: IF (delivery_record%ISOPEN) THEN
2252: CLOSE delivery_record;
2253: END IF;
2254:
2255: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',l_module_name);
2256: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2257: --
2258: IF l_debug_on THEN
2259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2256: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2252: CLOSE delivery_record;
2253: END IF;
2254:
2255: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',l_module_name);
2256: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2257: --
2258: IF l_debug_on THEN
2259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2317: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

2313: CLOSE get_name;
2314:
2315: IF (x_name IS NULL) THEN
2316: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
2317: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2318: --
2319: IF l_debug_on THEN
2320: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2321: WSH_DEBUG_SV.pop(l_module_name);

Line 2338: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.GET_NAME',l_module_name);

2334:
2335: EXCEPTION
2336:
2337: WHEN others THEN
2338: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.GET_NAME',l_module_name);
2339: --
2340: IF l_debug_on THEN
2341: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2352: p_valid_index_tab IN wsh_util_core.id_tab_type,

2348:
2349: procedure Lock_Delivery(
2350: p_rec_attr_tab IN Delivery_Attr_Tbl_Type,
2351: p_caller IN VARCHAR2,
2352: p_valid_index_tab IN wsh_util_core.id_tab_type,
2353: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
2354: x_return_status OUT NOCOPY VARCHAR2,
2355: p_action IN VARCHAR2 -- Bug fix 2657182
2356: )

Line 2353: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,

2349: procedure Lock_Delivery(
2350: p_rec_attr_tab IN Delivery_Attr_Tbl_Type,
2351: p_caller IN VARCHAR2,
2352: p_valid_index_tab IN wsh_util_core.id_tab_type,
2353: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
2354: x_return_status OUT NOCOPY VARCHAR2,
2355: p_action IN VARCHAR2 -- Bug fix 2657182
2356: )
2357:

Line 2438: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

2434: OR nvl(p_caller, '!') like 'FTE%'
2435: OR nvl(p_caller, '!') = 'WSH_TRCON' THEN
2436: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
2437: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).name);
2438: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2439: END IF;
2440: l_num_errors := l_num_errors + 1;
2441: --
2442: IF l_debug_on THEN

Line 2456: x_return_status := wsh_util_core.g_ret_sts_success;

2452: end loop;
2453: --
2454: --
2455: IF p_valid_index_tab.COUNT = 0 THEN
2456: x_return_status := wsh_util_core.g_ret_sts_success;
2457: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2458: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2459: x_return_status := wsh_util_core.g_ret_sts_error;
2460: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2459: x_return_status := wsh_util_core.g_ret_sts_error;

2455: IF p_valid_index_tab.COUNT = 0 THEN
2456: x_return_status := wsh_util_core.g_ret_sts_success;
2457: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2458: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2459: x_return_status := wsh_util_core.g_ret_sts_error;
2460: wsh_util_core.add_message(x_return_status,l_module_name);
2461: IF l_debug_on THEN
2462: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2463: END IF;

Line 2460: wsh_util_core.add_message(x_return_status,l_module_name);

2456: x_return_status := wsh_util_core.g_ret_sts_success;
2457: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2458: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2459: x_return_status := wsh_util_core.g_ret_sts_error;
2460: wsh_util_core.add_message(x_return_status,l_module_name);
2461: IF l_debug_on THEN
2462: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2463: END IF;
2464: RAISE FND_API.G_EXC_ERROR;

Line 2467: x_return_status := wsh_util_core.g_ret_sts_warning;

2463: END IF;
2464: RAISE FND_API.G_EXC_ERROR;
2465: ELSIF l_num_errors > 0 THEN
2466: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2467: x_return_status := wsh_util_core.g_ret_sts_warning;
2468: wsh_util_core.add_message(x_return_status,l_module_name);
2469: IF l_debug_on THEN
2470: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2471: END IF;

Line 2468: wsh_util_core.add_message(x_return_status,l_module_name);

2464: RAISE FND_API.G_EXC_ERROR;
2465: ELSIF l_num_errors > 0 THEN
2466: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2467: x_return_status := wsh_util_core.g_ret_sts_warning;
2468: wsh_util_core.add_message(x_return_status,l_module_name);
2469: IF l_debug_on THEN
2470: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2471: END IF;
2472: raise wsh_util_core.g_exc_warning;

Line 2472: raise wsh_util_core.g_exc_warning;

2468: wsh_util_core.add_message(x_return_status,l_module_name);
2469: IF l_debug_on THEN
2470: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2471: END IF;
2472: raise wsh_util_core.g_exc_warning;
2473: ELSE
2474: x_return_status := wsh_util_core.g_ret_sts_success;
2475: END IF;
2476: --

Line 2474: x_return_status := wsh_util_core.g_ret_sts_success;

2470: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2471: END IF;
2472: raise wsh_util_core.g_exc_warning;
2473: ELSE
2474: x_return_status := wsh_util_core.g_ret_sts_success;
2475: END IF;
2476: --
2477: --
2478: --

Line 2488: x_return_status := wsh_util_core.g_ret_sts_error;

2484: --
2485: --
2486: WHEN FND_API.G_EXC_ERROR THEN
2487: --
2488: x_return_status := wsh_util_core.g_ret_sts_error;
2489: --
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2496: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2493: END IF;
2494: --
2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2497: --
2498: IF l_debug_on THEN
2499: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2504: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

2500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2501: END IF;
2502: --
2503: --
2504: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2505: x_return_status := wsh_util_core.g_ret_sts_warning;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2505: x_return_status := wsh_util_core.g_ret_sts_warning;

2501: END IF;
2502: --
2503: --
2504: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2505: x_return_status := wsh_util_core.g_ret_sts_warning;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 2508: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2504: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2505: x_return_status := wsh_util_core.g_ret_sts_warning;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2510: END IF;
2511: --
2512: --

Line 2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2505: x_return_status := wsh_util_core.g_ret_sts_warning;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2510: END IF;
2511: --
2512: --
2513: WHEN OTHERS THEN

Line 2515: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2511: --
2512: --
2513: WHEN OTHERS THEN
2514: --
2515: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2516: --
2517: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);
2518: --
2519: IF l_debug_on THEN

Line 2517: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);

2513: WHEN OTHERS THEN
2514: --
2515: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2516: --
2517: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);
2518: --
2519: IF l_debug_on THEN
2520: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2521: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2630: x_leg_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

2626: p_delivery_id IN NUMBER,
2627: p_copy_legs IN VARCHAR2 DEFAULT 'N',
2628: x_delivery_id OUT NOCOPY NUMBER,
2629: x_rowid OUT NOCOPY VARCHAR2,
2630: x_leg_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
2631: x_return_status OUT NOCOPY VARCHAR2
2632: )
2633: IS
2634: --{

Line 2690: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2686: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2687: WSH_DEBUG_SV.log(l_module_name,'p_copy_legs',p_copy_legs);
2688: END IF;
2689: --
2690: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2691: --
2692: -- Generate delivery ID
2693: --
2694: OPEN get_next_delivery;

Line 3058: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);

3054: IF SQL%ROWCOUNT = 0
3055: THEN
3056: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');
3057: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id);
3058: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
3059: --
3060: RAISE FND_API.G_EXC_ERROR;
3061: END IF;
3062: --

Line 3240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3236: --}
3237: EXCEPTION
3238: WHEN FND_API.G_EXC_ERROR THEN
3239:
3240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3241: --
3242: IF l_debug_on THEN
3243: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 3247: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3243: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3245: END IF;
3246: WHEN others THEN
3247: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3248: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CLONE',l_module_name);
3249: --
3250: IF l_debug_on THEN
3251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3248: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CLONE',l_module_name);

3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3245: END IF;
3246: WHEN others THEN
3247: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3248: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CLONE',l_module_name);
3249: --
3250: IF l_debug_on THEN
3251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3252: END IF;

Line 3473: x_return_status := wsh_util_core.g_ret_sts_success;

3469: CLOSE c_tbl_rec;
3470: IF l_debug_on THEN
3471: WSH_DEBUG_SV.pop(l_module_name);
3472: END IF;
3473: x_return_status := wsh_util_core.g_ret_sts_success;
3474:
3475: EXCEPTION
3476:
3477: WHEN OTHERS THEN

Line 3482: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

3478: IF c_tbl_rec%ISOPEN THEN
3479: CLOSE c_tbl_rec;
3480: END IF;
3481: --
3482: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
3483: --
3484: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.Table_to_Record',l_module_name);
3485: --
3486: IF l_debug_on THEN

Line 3484: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.Table_to_Record',l_module_name);

3480: END IF;
3481: --
3482: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
3483: --
3484: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.Table_to_Record',l_module_name);
3485: --
3486: IF l_debug_on THEN
3487: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3488: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3509: (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

3505: -- to the according flag in the p_tms_interface_flag_tab.
3506: -- Also calls LOG_OTM_EXCEPTION.
3507: ----------------------------------------------------------
3508: PROCEDURE UPDATE_TMS_INTERFACE_FLAG
3509: (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
3510: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
3511: x_return_status OUT NOCOPY VARCHAR2) IS
3512:
3513: l_num_error NUMBER;

Line 3510: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,

3506: -- Also calls LOG_OTM_EXCEPTION.
3507: ----------------------------------------------------------
3508: PROCEDURE UPDATE_TMS_INTERFACE_FLAG
3509: (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
3510: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
3511: x_return_status OUT NOCOPY VARCHAR2) IS
3512:
3513: l_num_error NUMBER;
3514: l_num_warn NUMBER;

Line 3519: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

3515: l_return_status VARCHAR2(1);
3516: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
3517: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
3518:
3519: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3520: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3521: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3522: l_trip_not_found VARCHAR2(1);
3523: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 3520: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3516: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
3517: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
3518:
3519: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3520: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3521: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3522: l_trip_not_found VARCHAR2(1);
3523: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
3524: i NUMBER;

Line 3521: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3517: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
3518:
3519: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3520: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3521: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3522: l_trip_not_found VARCHAR2(1);
3523: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
3524: i NUMBER;
3525: l_count NUMBER;

Line 3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3545: WSH_DEBUG_SV.log(l_module_name,'Delivery ID count', p_delivery_id_tab.COUNT);
3546: WSH_DEBUG_SV.log(l_module_name,'Interface Flag count', p_tms_interface_flag_tab.COUNT);
3547: END IF;
3548: --
3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3550:
3551: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3552:
3553: IF l_gc3_is_installed IS NULL THEN

Line 3551: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable

3547: END IF;
3548: --
3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3550:
3551: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3552:
3553: IF l_gc3_is_installed IS NULL THEN
3554: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
3555: END IF;

Line 3554: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function

3550:
3551: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3552:
3553: IF l_gc3_is_installed IS NULL THEN
3554: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
3555: END IF;
3556:
3557: l_num_warn := 0;
3558: l_num_error := 0;

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

3589: IF l_debug_on THEN
3590: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);
3591: END IF;
3592:
3593: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3594: IF l_debug_on THEN
3595: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during get_trip_information');
3596: END IF;
3597: l_num_error := l_num_error + 1;

Line 3599: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3595: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during get_trip_information');
3596: END IF;
3597: l_num_error := l_num_error + 1;
3598: EXIT;
3599: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3600: l_num_warn := l_num_warn + 1;
3601: END IF;
3602:
3603: IF (l_trip_not_found = 'N' AND l_trip_info_rec.trip_id IS NULL) THEN

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

3621: IF l_debug_on THEN
3622: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);
3623: END IF;
3624:
3625: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3626: IF l_debug_on THEN
3627: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during table_to_record');
3628: END IF;
3629: l_num_error := l_num_error + 1;

Line 3631: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3627: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during table_to_record');
3628: END IF;
3629: l_num_error := l_num_error + 1;
3630: EXIT;
3631: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3632: l_num_warn := l_num_warn + 1;
3633: END IF;
3634:
3635: l_delivery_info_tab(l_delivery_info_tab.COUNT+1) := l_delivery_info;

Line 3697: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3693: END LOOP;
3694: -- end of while loop
3695:
3696: IF l_num_error > 0 THEN
3697: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3698: ELSIF l_num_warn > 0 THEN
3699: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3700: ELSE
3701: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3699: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3695:
3696: IF l_num_error > 0 THEN
3697: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3698: ELSIF l_num_warn > 0 THEN
3699: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3700: ELSE
3701: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3702: END IF;
3703:

Line 3701: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3697: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3698: ELSIF l_num_warn > 0 THEN
3699: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3700: ELSE
3701: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3702: END IF;
3703:
3704: IF l_debug_on THEN
3705: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 3709: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)

3705: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
3706: END IF;
3707:
3708: --proceed with update if not error status
3709: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)
3710: AND (l_delivery_info_tab.COUNT > 0)) THEN
3711:
3712: FORALL j IN l_delivery_info_tab.FIRST..l_delivery_info_tab.LAST
3713: UPDATE wsh_new_deliveries

Line 3736: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
3734: END IF;
3735:
3736: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3737: IF l_debug_on THEN
3738: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed');
3739: END IF;
3740: RAISE FND_API.G_EXC_ERROR;

Line 3741: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3737: IF l_debug_on THEN
3738: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed');
3739: END IF;
3740: RAISE FND_API.G_EXC_ERROR;
3741: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3742: IF l_debug_on THEN
3743: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed unexpectedly');
3744: END IF;
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3746: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3742: IF l_debug_on THEN
3743: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed unexpectedly');
3744: END IF;
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3747: --set return status to warning if l_return_status is warning
3748: x_return_status := l_return_status;
3749: END IF;
3750:

Line 3765: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3761:
3762: EXCEPTION
3763: WHEN FND_API.G_EXC_ERROR THEN
3764: ROLLBACK TO tms_update;
3765: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3766:
3767: IF l_debug_on THEN
3768: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 3774: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3770: END IF;
3771:
3772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3773: ROLLBACK TO tms_update;
3774: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3775:
3776: IF l_debug_on THEN
3777: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 3783: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3779: END IF;
3780:
3781: WHEN RECORD_LOCKED THEN
3782: ROLLBACK TO tms_update;
3783: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3784: IF l_debug_on THEN
3785: WSH_DEBUG_SV.logmsg(l_module_name,'Record_locked exception has occured. Cannot update delivery tms_interface_flag', WSH_DEBUG_SV.C_EXCEP_LEVEL);
3786: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
3787: END IF;

Line 3791: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);

3787: END IF;
3788:
3789: WHEN others THEN
3790: ROLLBACK TO tms_update;
3791: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
3792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3793: IF l_debug_on THEN
3794: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3788:
3789: WHEN others THEN
3790: ROLLBACK TO tms_update;
3791: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
3792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3793: IF l_debug_on THEN
3794: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3796: END IF;