865: END IF;
866:
867: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
868:
869: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
870: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
871: l_msg := FND_MESSAGE.GET;
872:
873: Log_Exception(
866:
867: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
868:
869: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
870: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
871: l_msg := FND_MESSAGE.GET;
872:
873: Log_Exception(
874: p_entity_id => V_dd_attr.delivery_id,
867: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
868:
869: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
870: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
871: l_msg := FND_MESSAGE.GET;
872:
873: Log_Exception(
874: p_entity_id => V_dd_attr.delivery_id,
875: p_logging_entity_name => 'DELIVERY',
903: IF (l_rr_status) THEN
904: -- If routing response in send and the ship to location is undergoing a change, then
905: -- an exception is logged against the delivery detail.
906:
907: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
908: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
909: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_dd_attr.ship_to_location_id);
910: FND_MESSAGE.SET_TOKEN('NEW_VALUE', p_line_rec.ship_to_location_id(p_line_rec_index));
911: l_msg := FND_MESSAGE.GET;
904: -- If routing response in send and the ship to location is undergoing a change, then
905: -- an exception is logged against the delivery detail.
906:
907: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
908: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
909: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_dd_attr.ship_to_location_id);
910: FND_MESSAGE.SET_TOKEN('NEW_VALUE', p_line_rec.ship_to_location_id(p_line_rec_index));
911: l_msg := FND_MESSAGE.GET;
912:
905: -- an exception is logged against the delivery detail.
906:
907: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
908: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
909: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_dd_attr.ship_to_location_id);
910: FND_MESSAGE.SET_TOKEN('NEW_VALUE', p_line_rec.ship_to_location_id(p_line_rec_index));
911: l_msg := FND_MESSAGE.GET;
912:
913: IF l_debug_on THEN
906:
907: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
908: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
909: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_dd_attr.ship_to_location_id);
910: FND_MESSAGE.SET_TOKEN('NEW_VALUE', p_line_rec.ship_to_location_id(p_line_rec_index));
911: l_msg := FND_MESSAGE.GET;
912:
913: IF l_debug_on THEN
914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
907: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
908: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
909: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_dd_attr.ship_to_location_id);
910: FND_MESSAGE.SET_TOKEN('NEW_VALUE', p_line_rec.ship_to_location_id(p_line_rec_index));
911: l_msg := FND_MESSAGE.GET;
912:
913: IF l_debug_on THEN
914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
915: END IF;
984: END IF;
985:
986: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
987:
988: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
989: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
990: l_msg := FND_MESSAGE.GET;
991:
992: Log_Exception(
985:
986: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
987:
988: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
989: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
990: l_msg := FND_MESSAGE.GET;
991:
992: Log_Exception(
993: p_entity_id => V_dd_attr.delivery_id,
986: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
987:
988: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
989: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
990: l_msg := FND_MESSAGE.GET;
991:
992: Log_Exception(
993: p_entity_id => V_dd_attr.delivery_id,
994: p_logging_entity_name => 'DELIVERY',
1030: IF SQL%ROWCOUNT <> 1 THEN
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
1033: END IF;
1034: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
1035: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038:
1063: IF SQL%ROWCOUNT <> 1 THEN
1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
1066: END IF;
1067: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
1068: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1121: END IF;
1122:
1123: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
1124:
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TS_DATE_EXCP');
1126: FND_MESSAGE.SET_TOKEN('STOP',l_stop_id);
1127: l_msg := FND_MESSAGE.GET;
1128:
1129: Log_Exception(
1122:
1123: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
1124:
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TS_DATE_EXCP');
1126: FND_MESSAGE.SET_TOKEN('STOP',l_stop_id);
1127: l_msg := FND_MESSAGE.GET;
1128:
1129: Log_Exception(
1130: p_entity_id => l_stop_id,
1123: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
1124:
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TS_DATE_EXCP');
1126: FND_MESSAGE.SET_TOKEN('STOP',l_stop_id);
1127: l_msg := FND_MESSAGE.GET;
1128:
1129: Log_Exception(
1130: p_entity_id => l_stop_id,
1131: p_logging_entity_name => 'STOP',
1162: END IF;
1163:
1164: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
1165:
1166: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_DATE_EXCP');
1167: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
1168: l_msg := FND_MESSAGE.GET;
1169:
1170: Log_Exception(
1163:
1164: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
1165:
1166: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_DATE_EXCP');
1167: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
1168: l_msg := FND_MESSAGE.GET;
1169:
1170: Log_Exception(
1171: p_entity_id => V_dd_attr.delivery_id,
1164: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
1165:
1166: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_DATE_EXCP');
1167: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);
1168: l_msg := FND_MESSAGE.GET;
1169:
1170: Log_Exception(
1171: p_entity_id => V_dd_attr.delivery_id,
1172: p_logging_entity_name => 'DELIVERY',
1207:
1208: l_old_value := to_char(v_dd_attr.date_requested);
1209: l_new_value := to_char(p_line_rec.request_date(p_line_rec_index));
1210:
1211: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NEED_DT_CHANGE');
1212: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
1213: FND_MESSAGE.SET_TOKEN('OLD_VALUE', to_char(v_dd_attr.date_requested));
1214: FND_MESSAGE.SET_TOKEN('NEW_VALUE', to_char(p_line_rec.request_date(p_line_rec_index)));
1215: l_msg := FND_MESSAGE.GET;
1208: l_old_value := to_char(v_dd_attr.date_requested);
1209: l_new_value := to_char(p_line_rec.request_date(p_line_rec_index));
1210:
1211: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NEED_DT_CHANGE');
1212: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
1213: FND_MESSAGE.SET_TOKEN('OLD_VALUE', to_char(v_dd_attr.date_requested));
1214: FND_MESSAGE.SET_TOKEN('NEW_VALUE', to_char(p_line_rec.request_date(p_line_rec_index)));
1215: l_msg := FND_MESSAGE.GET;
1216:
1209: l_new_value := to_char(p_line_rec.request_date(p_line_rec_index));
1210:
1211: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NEED_DT_CHANGE');
1212: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
1213: FND_MESSAGE.SET_TOKEN('OLD_VALUE', to_char(v_dd_attr.date_requested));
1214: FND_MESSAGE.SET_TOKEN('NEW_VALUE', to_char(p_line_rec.request_date(p_line_rec_index)));
1215: l_msg := FND_MESSAGE.GET;
1216:
1217: IF l_debug_on THEN
1210:
1211: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NEED_DT_CHANGE');
1212: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
1213: FND_MESSAGE.SET_TOKEN('OLD_VALUE', to_char(v_dd_attr.date_requested));
1214: FND_MESSAGE.SET_TOKEN('NEW_VALUE', to_char(p_line_rec.request_date(p_line_rec_index)));
1215: l_msg := FND_MESSAGE.GET;
1216:
1217: IF l_debug_on THEN
1218: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1211: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NEED_DT_CHANGE');
1212: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);
1213: FND_MESSAGE.SET_TOKEN('OLD_VALUE', to_char(v_dd_attr.date_requested));
1214: FND_MESSAGE.SET_TOKEN('NEW_VALUE', to_char(p_line_rec.request_date(p_line_rec_index)));
1215: l_msg := FND_MESSAGE.GET;
1216:
1217: IF l_debug_on THEN
1218: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1219: END IF;
1234: p_return_status => l_return_status,
1235: x_num_warnings => l_num_warnings,
1236: x_num_errors => l_num_errors);
1237:
1238: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');
1239: FND_MESSAGE.SET_TOKEN('DELIVERY', V_dd_attr.delivery_id);
1240: l_msg := FND_MESSAGE.GET;
1241:
1242: Log_Exception(
1235: x_num_warnings => l_num_warnings,
1236: x_num_errors => l_num_errors);
1237:
1238: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');
1239: FND_MESSAGE.SET_TOKEN('DELIVERY', V_dd_attr.delivery_id);
1240: l_msg := FND_MESSAGE.GET;
1241:
1242: Log_Exception(
1243: p_entity_id => V_dd_attr.delivery_id,
1236: x_num_errors => l_num_errors);
1237:
1238: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');
1239: FND_MESSAGE.SET_TOKEN('DELIVERY', V_dd_attr.delivery_id);
1240: l_msg := FND_MESSAGE.GET;
1241:
1242: Log_Exception(
1243: p_entity_id => V_dd_attr.delivery_id,
1244: p_logging_entity_name => 'DELIVERY',
1653: EXCEPTION
1654: WHEN e_wdd_locked THEN
1655: ROLLBACK TO Update_dd_Attributes_PVT;
1656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1657: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
1658: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1659:
1660: --
1661: -- Debug Statements
2358: WSH_DEBUG_SV.log(l_module_name,'Line Updated in wsh_delivery_details',sql%rowcount);
2359: END IF;
2360:
2361: IF SQL%ROWCOUNT <> 1 THEN
2362: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2363: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2364: RAISE FND_API.G_EXC_ERROR;
2365: END IF;
2366:
2511: END IF;
2512:
2513: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
2514:
2515: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
2516: FND_MESSAGE.SET_TOKEN('DELIVERY', v_lines_with_rr.delivery_id);
2517: l_msg := FND_MESSAGE.GET;
2518:
2519: Log_Exception(
2512:
2513: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
2514:
2515: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
2516: FND_MESSAGE.SET_TOKEN('DELIVERY', v_lines_with_rr.delivery_id);
2517: l_msg := FND_MESSAGE.GET;
2518:
2519: Log_Exception(
2520: p_entity_id => v_lines_with_rr.delivery_id,
2513: -- Bug 3395410 : Setting the message that needs to be displayed while logging exception.
2514:
2515: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');
2516: FND_MESSAGE.SET_TOKEN('DELIVERY', v_lines_with_rr.delivery_id);
2517: l_msg := FND_MESSAGE.GET;
2518:
2519: Log_Exception(
2520: p_entity_id => v_lines_with_rr.delivery_id,
2521: p_logging_entity_name => 'DELIVERY',
2551: -- these delivery details, then log exception against the delivery detail.
2552:
2553: IF (WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send( v_lines_with_rr.delivery_detail_id,l_req_res_id) ) THEN
2554:
2555: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
2556: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2557: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.ship_from_location_id);
2558: FND_MESSAGE.SET_TOKEN('NEW_VALUE', '-1');
2559: l_msg := FND_MESSAGE.GET;
2552:
2553: IF (WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send( v_lines_with_rr.delivery_detail_id,l_req_res_id) ) THEN
2554:
2555: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
2556: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2557: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.ship_from_location_id);
2558: FND_MESSAGE.SET_TOKEN('NEW_VALUE', '-1');
2559: l_msg := FND_MESSAGE.GET;
2560:
2553: IF (WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send( v_lines_with_rr.delivery_detail_id,l_req_res_id) ) THEN
2554:
2555: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
2556: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2557: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.ship_from_location_id);
2558: FND_MESSAGE.SET_TOKEN('NEW_VALUE', '-1');
2559: l_msg := FND_MESSAGE.GET;
2560:
2561: IF l_debug_on THEN
2554:
2555: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
2556: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2557: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.ship_from_location_id);
2558: FND_MESSAGE.SET_TOKEN('NEW_VALUE', '-1');
2559: l_msg := FND_MESSAGE.GET;
2560:
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
2555: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
2556: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2557: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.ship_from_location_id);
2558: FND_MESSAGE.SET_TOKEN('NEW_VALUE', '-1');
2559: l_msg := FND_MESSAGE.GET;
2560:
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
2563: END IF;
2668: IF SQL%ROWCOUNT <> 1 THEN
2669: IF l_debug_on THEN
2670: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
2671: END IF;
2672: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2673: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2674: RAISE FND_API.G_EXC_ERROR;
2675: END IF;
2676:
2717: OR (v_lines_with_rr.planned_flag in ('Y','F'))) THEN
2718: -- If routing response is send then log excpetion against the delivery detail and delivery.
2719: -- If delivery is firm,then log excpetion against the delivery.
2720:
2721: FND_MESSAGE.SET_NAME('WSH','WSH_IB_REQ_QTY_CHANGE');
2722: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2723: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.qty);
2724: FND_MESSAGE.SET_TOKEN('NEW_VALUE', l_requested_qty);
2725: l_msg := FND_MESSAGE.GET;
2718: -- If routing response is send then log excpetion against the delivery detail and delivery.
2719: -- If delivery is firm,then log excpetion against the delivery.
2720:
2721: FND_MESSAGE.SET_NAME('WSH','WSH_IB_REQ_QTY_CHANGE');
2722: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2723: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.qty);
2724: FND_MESSAGE.SET_TOKEN('NEW_VALUE', l_requested_qty);
2725: l_msg := FND_MESSAGE.GET;
2726:
2719: -- If delivery is firm,then log excpetion against the delivery.
2720:
2721: FND_MESSAGE.SET_NAME('WSH','WSH_IB_REQ_QTY_CHANGE');
2722: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2723: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.qty);
2724: FND_MESSAGE.SET_TOKEN('NEW_VALUE', l_requested_qty);
2725: l_msg := FND_MESSAGE.GET;
2726:
2727: IF l_debug_on THEN
2720:
2721: FND_MESSAGE.SET_NAME('WSH','WSH_IB_REQ_QTY_CHANGE');
2722: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2723: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.qty);
2724: FND_MESSAGE.SET_TOKEN('NEW_VALUE', l_requested_qty);
2725: l_msg := FND_MESSAGE.GET;
2726:
2727: IF l_debug_on THEN
2728: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
2721: FND_MESSAGE.SET_NAME('WSH','WSH_IB_REQ_QTY_CHANGE');
2722: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2723: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.qty);
2724: FND_MESSAGE.SET_TOKEN('NEW_VALUE', l_requested_qty);
2725: l_msg := FND_MESSAGE.GET;
2726:
2727: IF l_debug_on THEN
2728: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
2729: END IF;
2770: END IF;
2771:
2772:
2773:
2774: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');
2775: FND_MESSAGE.SET_TOKEN('DELIVERY',v_lines_with_rr.delivery_id);
2776: l_msg := FND_MESSAGE.GET;
2777:
2778: IF l_debug_on THEN
2771:
2772:
2773:
2774: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');
2775: FND_MESSAGE.SET_TOKEN('DELIVERY',v_lines_with_rr.delivery_id);
2776: l_msg := FND_MESSAGE.GET;
2777:
2778: IF l_debug_on THEN
2779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
2772:
2773:
2774: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');
2775: FND_MESSAGE.SET_TOKEN('DELIVERY',v_lines_with_rr.delivery_id);
2776: l_msg := FND_MESSAGE.GET;
2777:
2778: IF l_debug_on THEN
2779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
2780: END IF;
2905: IF SQL%ROWCOUNT <> 1 THEN
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
2908: END IF;
2909: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2910: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913: l_update_flag := TRUE;
3172: IF SQL%ROWCOUNT <> 1 THEN
3173: IF l_debug_on THEN
3174: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
3175: END IF;
3176: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
3177: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3178: RAISE FND_API.G_EXC_ERROR;
3179: END IF;
3180: --
3304: EXCEPTION
3305: WHEN e_wdd_locked THEN
3306: ROLLBACK TO Update_quantity_PVT;
3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3308: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
3309: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3310:
3311: --
3312: -- Debug Statements
3627: EXCEPTION
3628: WHEN e_wdd_locked THEN
3629: ROLLBACK TO cancel_close_PO_PVT;
3630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3631: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
3632: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3633:
3634: --
3635: -- Debug Statements
3968:
3969: /* IF (p_exception_name= 'WSH_IB_DEL_ATT_CHANGE') THEN
3970: l_msg := p_message;
3971: ELSE
3972: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
3973: FND_MESSAGE.SET_TOKEN('DELIVERY', p_entity_id);
3974: l_msg := FND_MESSAGE.GET;
3975: END IF;
3976: */
3969: /* IF (p_exception_name= 'WSH_IB_DEL_ATT_CHANGE') THEN
3970: l_msg := p_message;
3971: ELSE
3972: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
3973: FND_MESSAGE.SET_TOKEN('DELIVERY', p_entity_id);
3974: l_msg := FND_MESSAGE.GET;
3975: END IF;
3976: */
3977: IF l_debug_on THEN
3970: l_msg := p_message;
3971: ELSE
3972: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
3973: FND_MESSAGE.SET_TOKEN('DELIVERY', p_entity_id);
3974: l_msg := FND_MESSAGE.GET;
3975: END IF;
3976: */
3977: IF l_debug_on THEN
3978: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
4000: ELSIF p_logging_entity_name = 'STOP' THEN
4001: -- Bug 3395410 : Commented the following code as p_message is getting populated with the
4002: -- message to be displayed.
4003: /*
4004: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
4005: FND_MESSAGE.SET_TOKEN('STOP', p_entity_id);
4006: l_msg := FND_MESSAGE.GET;
4007: */
4008: --
4001: -- Bug 3395410 : Commented the following code as p_message is getting populated with the
4002: -- message to be displayed.
4003: /*
4004: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
4005: FND_MESSAGE.SET_TOKEN('STOP', p_entity_id);
4006: l_msg := FND_MESSAGE.GET;
4007: */
4008: --
4009: -- Debug Statements
4002: -- message to be displayed.
4003: /*
4004: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
4005: FND_MESSAGE.SET_TOKEN('STOP', p_entity_id);
4006: l_msg := FND_MESSAGE.GET;
4007: */
4008: --
4009: -- Debug Statements
4010: --