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 499: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

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

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

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

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

Line 509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 577: l_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;

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

Line 578: l_del_old_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

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

Line 579: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

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

Line 588: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

Line 620: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

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

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

Line 1042: 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.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
1040: END IF;
1041:
1042: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
1045: END IF;
1046: RAISE api_return_fail;

Line 1142: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

1138: p_diff_net_wt => l_diff_net_wt,
1139: p_diff_volume => l_diff_vol,
1140: x_return_status => l_return_status);
1141:
1142: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1143: raise e_wt_vol_fail;
1144: END IF;
1145:
1146: END IF;

Line 1168: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

Line 1175: wsh_util_core.api_post_call(

1171: IF l_debug_on THEN
1172: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.prorate_weight',l_return_status);
1173: END IF;
1174: --
1175: wsh_util_core.api_post_call(
1176: p_return_status => l_return_status,
1177: x_num_warnings => l_num_warnings,
1178: x_num_errors => l_num_errors);
1179: --

Line 1201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 1202: WSH_UTIL_CORE.add_message (x_return_status);

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

Line 1210: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1206: END IF;
1207:
1208: WHEN NO_DATA_FOUND THEN
1209: FND_MESSAGE.Set_Name('WSH','WSH_DEL_NOT_FOUND');
1210: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1211: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1212: --
1213: IF l_debug_on THEN
1214: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1207:
1208: WHEN NO_DATA_FOUND THEN
1209: FND_MESSAGE.Set_Name('WSH','WSH_DEL_NOT_FOUND');
1210: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1211: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1212: --
1213: IF l_debug_on THEN
1214: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 1222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1218:
1219: --Bug # 3268641
1220: WHEN DUP_VAL_ON_INDEX THEN
1221: FND_MESSAGE.SET_NAME('WSH','WSH_ASSIGN_NEW_DEL');
1222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1223: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1224:
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1223: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1219: --Bug # 3268641
1220: WHEN DUP_VAL_ON_INDEX THEN
1221: FND_MESSAGE.SET_NAME('WSH','WSH_ASSIGN_NEW_DEL');
1222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1223: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1224:
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1227: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');

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

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

Line 1233: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 1283: l_mdc_del_tab WSH_UTIL_CORE.id_tab_type;

1279:
1280:
1281: l_delivery_id NUMBER;
1282: l_delivery_leg_id NUMBER;
1283: l_mdc_del_tab WSH_UTIL_CORE.id_tab_type;
1284:
1285: cannot_delete_delivery EXCEPTION;
1286: others EXCEPTION;
1287:

Line 1315: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1311: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
1312: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
1313: END IF;
1314: --
1315: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1316: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1317:
1318: l_num_warn := 0;
1319:

Line 1316: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1312: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
1313: END IF;
1314: --
1315: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1316: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1317:
1318: l_num_warn := 0;
1319:
1320: -- map rowid to a delivery_id

Line 1339: 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: IF (p_validate_flag = 'Y') THEN
1336: wsh_delivery_validations.check_delete_delivery(
1337: p_delivery_id => l_delivery_id,
1338: x_return_status => l_return_status);
1339: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE cannot_delete_delivery;
1341: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1342: l_num_warn := l_num_warn + 1;
1343: END IF;

Line 1341: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1337: p_delivery_id => l_delivery_id,
1338: x_return_status => l_return_status);
1339: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE cannot_delete_delivery;
1341: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1342: l_num_warn := l_num_warn + 1;
1343: END IF;
1344: END IF;
1345:

Line 1363: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

1359: wsh_delivery_details_actions.unassign_detail_from_delivery
1360: (p_detail_id => dt.delivery_detail_id,
1361: x_return_status => l_return_status);
1362:
1363: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1364: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1365: x_return_status := l_return_status;
1366: ROLLBACK TO SAVEPOINT unassign_details;
1367: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');

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

1360: (p_detail_id => dt.delivery_detail_id,
1361: x_return_status => l_return_status);
1362:
1363: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1364: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1365: x_return_status := l_return_status;
1366: ROLLBACK TO SAVEPOINT unassign_details;
1367: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
1368: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));

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

1366: ROLLBACK TO SAVEPOINT unassign_details;
1367: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
1368: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1369: FND_MESSAGE.SET_TOKEN('DET_NAME',dt.delivery_detail_id);
1370: wsh_util_core.add_message(x_return_status,l_module_name);
1371: --
1372: IF l_debug_on THEN
1373: WSH_DEBUG_SV.log(l_module_name,'x_return_status',
1374: x_return_status);

Line 1379: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1375: WSH_DEBUG_SV.pop(l_module_name);
1376: END IF;
1377: --
1378: RETURN;
1379: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1380: l_num_warn := l_num_warn + 1;
1381: END IF;
1382:
1383: END LOOP;

Line 1399: 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: p_caller => 'WSH_DELETE_DEL',
1396: p_del_tab => l_mdc_del_tab,
1397: x_return_status => l_return_status);
1398: l_mdc_del_tab.delete;
1399: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1400: ROLLBACK TO wsh_before_delivery_delete;
1401: RAISE cannot_delete_delivery;
1402: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1403: l_num_warn := l_num_warn + 1;

Line 1402: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1398: l_mdc_del_tab.delete;
1399: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1400: ROLLBACK TO wsh_before_delivery_delete;
1401: RAISE cannot_delete_delivery;
1402: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1403: l_num_warn := l_num_warn + 1;
1404: END IF;
1405:
1406: END IF;

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

1407:
1408: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg(
1409: p_delivery_leg_id => dl.delivery_leg_id,
1410: x_return_status => l_return_status);
1411: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1412: ) THEN
1413: ROLLBACK TO wsh_before_delivery_delete;
1414:
1415: RAISE cannot_delete_delivery;

Line 1416: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1412: ) THEN
1413: ROLLBACK TO wsh_before_delivery_delete;
1414:
1415: RAISE cannot_delete_delivery;
1416: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1417: l_num_warn := l_num_warn + 1;
1418: END IF;
1419: END LOOP;
1420:

Line 1446: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1442: RAISE others;
1443: END IF; --} l_delivery_id IS NOT NULL
1444: /* Bug 2310456 warning */
1445: IF l_num_warn > 0 THEN
1446: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1447: END IF;
1448: --
1449: IF l_debug_on THEN
1450: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 1471: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1467: END IF;
1468:
1469: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DELETE_ERROR');
1470: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1471: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1472: wsh_util_core.add_message(x_return_status,l_module_name);
1473: --
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'CANNOT_DELETE_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

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

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

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

Line 1496: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 2254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2250: FETCH delivery_record INTO x_delivery_info;
2251:
2252: IF (delivery_record%NOTFOUND) THEN
2253: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
2254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2255: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
2256: IF l_debug_on THEN
2257: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2258: END IF;

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

2251:
2252: IF (delivery_record%NOTFOUND) THEN
2253: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
2254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2255: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
2256: IF l_debug_on THEN
2257: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2258: END IF;
2259: ELSE

Line 2260: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2256: IF l_debug_on THEN
2257: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2258: END IF;
2259: ELSE
2260: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2261: END IF;
2262:
2263: CLOSE delivery_record;
2264: --

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

2271: IF (delivery_record%ISOPEN) THEN
2272: CLOSE delivery_record;
2273: END IF;
2274:
2275: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',l_module_name);
2276: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2277: --
2278: IF l_debug_on THEN
2279: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2276: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2272: CLOSE delivery_record;
2273: END IF;
2274:
2275: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',l_module_name);
2276: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2277: --
2278: IF l_debug_on THEN
2279: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2280: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2333: CLOSE get_name;
2334:
2335: IF (x_name IS NULL) THEN
2336: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
2337: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2338: --
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_NOT_FOUND');
2341: WSH_DEBUG_SV.pop(l_module_name);

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

2354:
2355: EXCEPTION
2356:
2357: WHEN others THEN
2358: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.GET_NAME',l_module_name);
2359: --
2360: IF l_debug_on THEN
2361: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2362: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2372: p_valid_index_tab IN wsh_util_core.id_tab_type,

2368:
2369: procedure Lock_Delivery(
2370: p_rec_attr_tab IN Delivery_Attr_Tbl_Type,
2371: p_caller IN VARCHAR2,
2372: p_valid_index_tab IN wsh_util_core.id_tab_type,
2373: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
2374: x_return_status OUT NOCOPY VARCHAR2,
2375: p_action IN VARCHAR2 -- Bug fix 2657182
2376: )

Line 2373: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,

2369: procedure Lock_Delivery(
2370: p_rec_attr_tab IN Delivery_Attr_Tbl_Type,
2371: p_caller IN VARCHAR2,
2372: p_valid_index_tab IN wsh_util_core.id_tab_type,
2373: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
2374: x_return_status OUT NOCOPY VARCHAR2,
2375: p_action IN VARCHAR2 -- Bug fix 2657182
2376: )
2377:

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

2454: OR nvl(p_caller, '!') like 'FTE%'
2455: OR nvl(p_caller, '!') = 'WSH_TRCON' THEN
2456: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
2457: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).name);
2458: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2459: END IF;
2460: l_num_errors := l_num_errors + 1;
2461: --
2462: IF l_debug_on THEN

Line 2476: x_return_status := wsh_util_core.g_ret_sts_success;

2472: end loop;
2473: --
2474: --
2475: IF p_valid_index_tab.COUNT = 0 THEN
2476: x_return_status := wsh_util_core.g_ret_sts_success;
2477: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2478: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2479: x_return_status := wsh_util_core.g_ret_sts_error;
2480: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2479: x_return_status := wsh_util_core.g_ret_sts_error;

2475: IF p_valid_index_tab.COUNT = 0 THEN
2476: x_return_status := wsh_util_core.g_ret_sts_success;
2477: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2478: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2479: x_return_status := wsh_util_core.g_ret_sts_error;
2480: wsh_util_core.add_message(x_return_status,l_module_name);
2481: IF l_debug_on THEN
2482: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2483: END IF;

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

2476: x_return_status := wsh_util_core.g_ret_sts_success;
2477: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2478: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2479: x_return_status := wsh_util_core.g_ret_sts_error;
2480: wsh_util_core.add_message(x_return_status,l_module_name);
2481: IF l_debug_on THEN
2482: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2483: END IF;
2484: RAISE FND_API.G_EXC_ERROR;

Line 2487: x_return_status := wsh_util_core.g_ret_sts_warning;

2483: END IF;
2484: RAISE FND_API.G_EXC_ERROR;
2485: ELSIF l_num_errors > 0 THEN
2486: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2487: x_return_status := wsh_util_core.g_ret_sts_warning;
2488: wsh_util_core.add_message(x_return_status,l_module_name);
2489: IF l_debug_on THEN
2490: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2491: END IF;

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

2484: RAISE FND_API.G_EXC_ERROR;
2485: ELSIF l_num_errors > 0 THEN
2486: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2487: x_return_status := wsh_util_core.g_ret_sts_warning;
2488: wsh_util_core.add_message(x_return_status,l_module_name);
2489: IF l_debug_on THEN
2490: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2491: END IF;
2492: raise wsh_util_core.g_exc_warning;

Line 2492: raise wsh_util_core.g_exc_warning;

2488: wsh_util_core.add_message(x_return_status,l_module_name);
2489: IF l_debug_on THEN
2490: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2491: END IF;
2492: raise wsh_util_core.g_exc_warning;
2493: ELSE
2494: x_return_status := wsh_util_core.g_ret_sts_success;
2495: END IF;
2496: --

Line 2494: x_return_status := wsh_util_core.g_ret_sts_success;

2490: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2491: END IF;
2492: raise wsh_util_core.g_exc_warning;
2493: ELSE
2494: x_return_status := wsh_util_core.g_ret_sts_success;
2495: END IF;
2496: --
2497: --
2498: --

Line 2508: x_return_status := wsh_util_core.g_ret_sts_error;

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

Line 2516: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2513: END IF;
2514: --
2515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2516: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2517: --
2518: IF l_debug_on THEN
2519: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2524: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

2520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2521: END IF;
2522: --
2523: --
2524: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2525: x_return_status := wsh_util_core.g_ret_sts_warning;
2526: --
2527: IF l_debug_on THEN
2528: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2525: x_return_status := wsh_util_core.g_ret_sts_warning;

2521: END IF;
2522: --
2523: --
2524: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2525: x_return_status := wsh_util_core.g_ret_sts_warning;
2526: --
2527: IF l_debug_on THEN
2528: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

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

2524: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2525: x_return_status := wsh_util_core.g_ret_sts_warning;
2526: --
2527: IF l_debug_on THEN
2528: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2530: END IF;
2531: --
2532: --

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

2525: x_return_status := wsh_util_core.g_ret_sts_warning;
2526: --
2527: IF l_debug_on THEN
2528: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2530: END IF;
2531: --
2532: --
2533: WHEN OTHERS THEN

Line 2535: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2531: --
2532: --
2533: WHEN OTHERS THEN
2534: --
2535: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2536: --
2537: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);
2538: --
2539: IF l_debug_on THEN

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

2533: WHEN OTHERS THEN
2534: --
2535: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2536: --
2537: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);
2538: --
2539: IF l_debug_on THEN
2540: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2650: x_leg_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

2646: p_delivery_id IN NUMBER,
2647: p_copy_legs IN VARCHAR2 DEFAULT 'N',
2648: x_delivery_id OUT NOCOPY NUMBER,
2649: x_rowid OUT NOCOPY VARCHAR2,
2650: x_leg_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
2651: x_return_status OUT NOCOPY VARCHAR2
2652: )
2653: IS
2654: --{

Line 2710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2706: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2707: WSH_DEBUG_SV.log(l_module_name,'p_copy_legs',p_copy_legs);
2708: END IF;
2709: --
2710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2711: --
2712: -- Generate delivery ID
2713: --
2714: OPEN get_next_delivery;

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

3074: IF SQL%ROWCOUNT = 0
3075: THEN
3076: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');
3077: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id);
3078: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
3079: --
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082: --

Line 3260: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3256: --}
3257: EXCEPTION
3258: WHEN FND_API.G_EXC_ERROR THEN
3259:
3260: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3261: --
3262: IF l_debug_on THEN
3263: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3264: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 3267: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3263: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3264: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3265: END IF;
3266: WHEN others THEN
3267: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3268: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CLONE',l_module_name);
3269: --
3270: IF l_debug_on THEN
3271: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

3264: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3265: END IF;
3266: WHEN others THEN
3267: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3268: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.CLONE',l_module_name);
3269: --
3270: IF l_debug_on THEN
3271: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3272: END IF;

Line 3497: x_return_status := wsh_util_core.g_ret_sts_success;

3493: CLOSE c_tbl_rec;
3494: IF l_debug_on THEN
3495: WSH_DEBUG_SV.pop(l_module_name);
3496: END IF;
3497: x_return_status := wsh_util_core.g_ret_sts_success;
3498:
3499: EXCEPTION
3500:
3501: WHEN OTHERS THEN

Line 3506: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

3502: IF c_tbl_rec%ISOPEN THEN
3503: CLOSE c_tbl_rec;
3504: END IF;
3505: --
3506: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
3507: --
3508: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.Table_to_Record',l_module_name);
3509: --
3510: IF l_debug_on THEN

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

3504: END IF;
3505: --
3506: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
3507: --
3508: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.Table_to_Record',l_module_name);
3509: --
3510: IF l_debug_on THEN
3511: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3533: (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

3529: -- to the according flag in the p_tms_interface_flag_tab.
3530: -- Also calls LOG_OTM_EXCEPTION.
3531: ----------------------------------------------------------
3532: PROCEDURE UPDATE_TMS_INTERFACE_FLAG
3533: (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
3534: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
3535: x_return_status OUT NOCOPY VARCHAR2) IS
3536:
3537: l_num_error NUMBER;

Line 3534: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,

3530: -- Also calls LOG_OTM_EXCEPTION.
3531: ----------------------------------------------------------
3532: PROCEDURE UPDATE_TMS_INTERFACE_FLAG
3533: (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
3534: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
3535: x_return_status OUT NOCOPY VARCHAR2) IS
3536:
3537: l_num_error NUMBER;
3538: l_num_warn NUMBER;

Line 3543: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

3539: l_return_status VARCHAR2(1);
3540: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
3541: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
3542:
3543: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3544: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3545: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3546: l_trip_not_found VARCHAR2(1);
3547: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 3544: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3540: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
3541: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
3542:
3543: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3544: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3545: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3546: l_trip_not_found VARCHAR2(1);
3547: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
3548: i NUMBER;

Line 3545: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3541: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
3542:
3543: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3544: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3545: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3546: l_trip_not_found VARCHAR2(1);
3547: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
3548: i NUMBER;
3549: l_count NUMBER;

Line 3573: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3569: WSH_DEBUG_SV.log(l_module_name,'Delivery ID count', p_delivery_id_tab.COUNT);
3570: WSH_DEBUG_SV.log(l_module_name,'Interface Flag count', p_tms_interface_flag_tab.COUNT);
3571: END IF;
3572: --
3573: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3574:
3575: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3576:
3577: IF l_gc3_is_installed IS NULL THEN

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

3571: END IF;
3572: --
3573: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3574:
3575: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3576:
3577: IF l_gc3_is_installed IS NULL THEN
3578: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
3579: END IF;

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

3574:
3575: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3576:
3577: IF l_gc3_is_installed IS NULL THEN
3578: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
3579: END IF;
3580:
3581: l_num_warn := 0;
3582: l_num_error := 0;

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

3613: IF l_debug_on THEN
3614: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);
3615: END IF;
3616:
3617: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3618: IF l_debug_on THEN
3619: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during get_trip_information');
3620: END IF;
3621: l_num_error := l_num_error + 1;

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

3619: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during get_trip_information');
3620: END IF;
3621: l_num_error := l_num_error + 1;
3622: EXIT;
3623: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3624: l_num_warn := l_num_warn + 1;
3625: END IF;
3626:
3627: IF (l_trip_not_found = 'N' AND l_trip_info_rec.trip_id IS NULL) THEN

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

3645: IF l_debug_on THEN
3646: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);
3647: END IF;
3648:
3649: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3650: IF l_debug_on THEN
3651: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during table_to_record');
3652: END IF;
3653: l_num_error := l_num_error + 1;

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

3651: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ' || p_delivery_id_tab(i) || ' failed during table_to_record');
3652: END IF;
3653: l_num_error := l_num_error + 1;
3654: EXIT;
3655: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3656: l_num_warn := l_num_warn + 1;
3657: END IF;
3658:
3659: l_delivery_info_tab(l_delivery_info_tab.COUNT+1) := l_delivery_info;

Line 3721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3717: END LOOP;
3718: -- end of while loop
3719:
3720: IF l_num_error > 0 THEN
3721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3722: ELSIF l_num_warn > 0 THEN
3723: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3724: ELSE
3725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3723: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3719:
3720: IF l_num_error > 0 THEN
3721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3722: ELSIF l_num_warn > 0 THEN
3723: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3724: ELSE
3725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3726: END IF;
3727:

Line 3725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3722: ELSIF l_num_warn > 0 THEN
3723: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3724: ELSE
3725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3726: END IF;
3727:
3728: IF l_debug_on THEN
3729: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

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

3729: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
3730: END IF;
3731:
3732: --proceed with update if not error status
3733: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)
3734: AND (l_delivery_info_tab.COUNT > 0)) THEN
3735:
3736: FORALL j IN l_delivery_info_tab.FIRST..l_delivery_info_tab.LAST
3737: UPDATE wsh_new_deliveries

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

3756: IF l_debug_on THEN
3757: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
3758: END IF;
3759:
3760: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3761: IF l_debug_on THEN
3762: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed');
3763: END IF;
3764: RAISE FND_API.G_EXC_ERROR;

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

3761: IF l_debug_on THEN
3762: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed');
3763: END IF;
3764: RAISE FND_API.G_EXC_ERROR;
3765: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3766: IF l_debug_on THEN
3767: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed unexpectedly');
3768: END IF;
3769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3766: IF l_debug_on THEN
3767: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed unexpectedly');
3768: END IF;
3769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3770: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3771: --set return status to warning if l_return_status is warning
3772: x_return_status := l_return_status;
3773: END IF;
3774:

Line 3789: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3785:
3786: EXCEPTION
3787: WHEN FND_API.G_EXC_ERROR THEN
3788: ROLLBACK TO tms_update;
3789: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3790:
3791: IF l_debug_on THEN
3792: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3793: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 3798: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3794: END IF;
3795:
3796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3797: ROLLBACK TO tms_update;
3798: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3799:
3800: IF l_debug_on THEN
3801: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 3807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3803: END IF;
3804:
3805: WHEN RECORD_LOCKED THEN
3806: ROLLBACK TO tms_update;
3807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3808: IF l_debug_on THEN
3809: WSH_DEBUG_SV.logmsg(l_module_name,'Record_locked exception has occured. Cannot update delivery tms_interface_flag', WSH_DEBUG_SV.C_EXCEP_LEVEL);
3810: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
3811: END IF;

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

3811: END IF;
3812:
3813: WHEN others THEN
3814: ROLLBACK TO tms_update;
3815: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
3816: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3817: IF l_debug_on THEN
3818: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3816: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3812:
3813: WHEN others THEN
3814: ROLLBACK TO tms_update;
3815: wsh_util_core.default_handler('WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
3816: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3817: IF l_debug_on THEN
3818: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3820: END IF;