DBA Data[Home] [Help]

APPS.WSH_PO_CMG_PVT dependencies on FND_MESSAGE

Line 869: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');

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(

Line 870: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);

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,

Line 871: l_msg := FND_MESSAGE.GET;

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',

Line 907: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');

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;

Line 908: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);

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:

Line 909: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_dd_attr.ship_to_location_id);

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

Line 910: FND_MESSAGE.SET_TOKEN('NEW_VALUE', p_line_rec.ship_to_location_id(p_line_rec_index));

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);

Line 911: l_msg := FND_MESSAGE.GET;

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;

Line 988: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');

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(

Line 989: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);

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,

Line 990: l_msg := FND_MESSAGE.GET;

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',

Line 1034: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');

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:

Line 1067: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');

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:

Line 1125: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TS_DATE_EXCP');

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(

Line 1126: FND_MESSAGE.SET_TOKEN('STOP',l_stop_id);

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,

Line 1127: l_msg := FND_MESSAGE.GET;

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',

Line 1166: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_DATE_EXCP');

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(

Line 1167: FND_MESSAGE.SET_TOKEN('DELIVERY',v_dd_attr.delivery_id);

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,

Line 1168: l_msg := FND_MESSAGE.GET;

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',

Line 1211: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NEED_DT_CHANGE');

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;

Line 1212: FND_MESSAGE.SET_TOKEN('DETAIL', V_dd_attr.delivery_detail_id);

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:

Line 1213: FND_MESSAGE.SET_TOKEN('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:
1217: IF l_debug_on THEN

Line 1214: FND_MESSAGE.SET_TOKEN('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
1218: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Log_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1215: l_msg := FND_MESSAGE.GET;

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;

Line 1238: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');

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(

Line 1239: FND_MESSAGE.SET_TOKEN('DELIVERY', V_dd_attr.delivery_id);

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,

Line 1240: l_msg := FND_MESSAGE.GET;

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',

Line 1657: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');

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

Line 2362: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');

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:

Line 2515: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DELIVERY_CHANGE');

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(

Line 2516: FND_MESSAGE.SET_TOKEN('DELIVERY', v_lines_with_rr.delivery_id);

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,

Line 2517: l_msg := FND_MESSAGE.GET;

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',

Line 2555: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');

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;

Line 2556: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);

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:

Line 2557: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.ship_from_location_id);

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

Line 2558: FND_MESSAGE.SET_TOKEN('NEW_VALUE', '-1');

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);

Line 2559: l_msg := FND_MESSAGE.GET;

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;

Line 2672: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');

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:

Line 2721: FND_MESSAGE.SET_NAME('WSH','WSH_IB_REQ_QTY_CHANGE');

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;

Line 2722: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);

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:

Line 2723: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.qty);

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

Line 2724: FND_MESSAGE.SET_TOKEN('NEW_VALUE', l_requested_qty);

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);

Line 2725: l_msg := FND_MESSAGE.GET;

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;

Line 2774: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DEL_ATT_CHANGE');

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

Line 2775: FND_MESSAGE.SET_TOKEN('DELIVERY',v_lines_with_rr.delivery_id);

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);

Line 2776: l_msg := FND_MESSAGE.GET;

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;

Line 2909: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');

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;

Line 3176: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');

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: --

Line 3308: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');

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

Line 3631: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');

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

Line 3972: FND_MESSAGE.SET_NAME('WSH',p_exception_name);

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: */

Line 3973: FND_MESSAGE.SET_TOKEN('DELIVERY', p_entity_id);

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

Line 3974: l_msg := FND_MESSAGE.GET;

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);

Line 4004: FND_MESSAGE.SET_NAME('WSH',p_exception_name);

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: --

Line 4005: FND_MESSAGE.SET_TOKEN('STOP', p_entity_id);

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

Line 4006: l_msg := FND_MESSAGE.GET;

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: --