DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on FND_MESSAGE

Line 451: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');

447: WSH_DEBUG_SV.log(l_module_name,'After WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs: return',l_return_status);
448: END IF;
449:
450: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --{
451: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
452: WSH_UTIL_CORE.add_message(l_return_status, l_module_name);
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Remove_FTE_Freight_Costs failed');
455: END IF;

Line 526: FND_MESSAGE.SET_NAME('WSH', 'WSH_REPRICE_REQUIRED_ERR');

522: EXCEPTION
523:
524: WHEN MARK_REPRICE_ERROR THEN
525: x_return_status := l_return_status;
526: FND_MESSAGE.SET_NAME('WSH', 'WSH_REPRICE_REQUIRED_ERR');
527: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
528: -- OTM R12 : unassign delivery detail
529: IF (c_detail_cont_planning_cur%ISOPEN) THEN
530: CLOSE c_detail_cont_planning_cur;

Line 1109: FND_MESSAGE.Set_Name('WSH', 'WSH_QUERY_RESERVATION');

1105: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF RESERVATIONS FOUND: '||TO_CHAR ( X_MTL_RESERVATION_TBL_COUNT ) );
1106: END IF;
1107: --
1108: ELSE
1109: FND_MESSAGE.Set_Name('WSH', 'WSH_QUERY_RESERVATION');
1110: IF l_msg_count = 1 THEN
1111: --
1112: -- Debug Statements
1113: --

Line 1118: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);

1114: IF l_debug_on THEN
1115: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1116: END IF;
1117: --
1118: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1119: ELSE
1120: FOR l_index IN 1..l_msg_count LOOP
1121: l_msg_data := fnd_msg_pub.get;
1122: --

Line 1131: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);

1127: END IF;
1128: --
1129: l_error_text := l_error_text || l_msg_data;
1130: END LOOP;
1131: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1132: END IF;
1133: raise query_reservation_failed;
1134: END IF;
1135:

Line 1217: FND_MESSAGE.Set_Name('WSH', 'WSH_DELETE_RESERVATION');

1213: IF l_debug_on THEN
1214: WSH_DEBUG_SV.logmsg(l_module_name, 'COULD NOT DELETE RESERVATION FOR RESERVATION ID : '||P_QUERY_INPUT.RESERVATION_ID );
1215: END IF;
1216: --
1217: FND_MESSAGE.Set_Name('WSH', 'WSH_DELETE_RESERVATION');
1218: IF l_msg_count = 1 THEN
1219: --
1220: -- Debug Statements
1221: --

Line 1226: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);

1222: IF l_debug_on THEN
1223: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1224: END IF;
1225: --
1226: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1227: ELSE
1228: FOR l_index IN 1..l_msg_count LOOP
1229: l_msg_data := fnd_msg_pub.get;
1230: --

Line 1239: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);

1235: END IF;
1236: --
1237: l_error_text := l_error_text || l_msg_data;
1238: END LOOP;
1239: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1240: END IF;
1241: raise delete_reservation_failed;
1242: END IF;
1243:

Line 1386: FND_MESSAGE.Set_Name('WSH', 'WSH_CREATE_RESERVATION');

1382: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATION CREATED FOR RESERVATION ID : '||X_RESERVATION_ID );
1383: END IF;
1384: --
1385: ELSE
1386: FND_MESSAGE.Set_Name('WSH', 'WSH_CREATE_RESERVATION');
1387: IF l_msg_count = 1 THEN
1388: --
1389: -- Debug Statements
1390: --

Line 1395: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);

1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1393: END IF;
1394: --
1395: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1396: ELSE
1397: FOR l_index IN 1..l_msg_count LOOP
1398: l_msg_data := fnd_msg_pub.get;
1399: --

Line 1408: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);

1404: END IF;
1405: --
1406: l_error_text := l_error_text || l_msg_data;
1407: END LOOP;
1408: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1409: END IF;
1410: raise create_reservation_failed;
1411: END IF;
1412: -- HW OPMCONV removed forking

Line 1522: FND_MESSAGE.Set_Name('WSH', 'WSH_UPDATE_RESERVATION');

1518: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATION UPDATED FOR RESERVATION ID : '||TO_CHAR ( P_QUERY_INPUT.RESERVATION_ID ) );
1519: END IF;
1520: --
1521: ELSE
1522: FND_MESSAGE.Set_Name('WSH', 'WSH_UPDATE_RESERVATION');
1523: IF l_msg_count = 1 THEN
1524: --
1525: -- Debug Statements
1526: --

Line 1531: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);

1527: IF l_debug_on THEN
1528: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1529: END IF;
1530: --
1531: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1532: ELSE
1533: FOR l_index IN 1..l_msg_count LOOP
1534: l_msg_data := fnd_msg_pub.get;
1535: --

Line 1544: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);

1540: END IF;
1541: --
1542: l_error_text := l_error_text || l_msg_data;
1543: END LOOP;
1544: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1545: END IF;
1546: raise update_reservation_failed;
1547: END IF;
1548:

Line 3062: FND_MESSAGE.Set_Name('WSH', 'WSH_TRANSFER_RESERVATION');

3058: ELSE
3059: IF l_debug_on THEN
3060: WSH_DEBUG_SV.logmsg(l_module_name, 'COULD NOT TRANSFER FOR RESERVATION ID : '||P_RSV.RESERVATION_ID );
3061: END IF;
3062: FND_MESSAGE.Set_Name('WSH', 'WSH_TRANSFER_RESERVATION');
3063: IF l_msg_count = 1 THEN
3064: IF l_debug_on THEN
3065: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
3066: END IF;

Line 3068: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);

3064: IF l_debug_on THEN
3065: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
3066: END IF;
3067: --
3068: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
3069: ELSE
3070: FOR l_index IN 1..l_msg_count LOOP
3071: l_msg_data := fnd_msg_pub.get;
3072: IF l_debug_on THEN

Line 3078: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);

3074: END IF;
3075: --
3076: l_error_text := l_error_text || l_msg_data;
3077: END LOOP;
3078: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3079: l_error_text := '';
3080: END IF;
3081: raise transfer_split_failed;
3082: END IF;

Line 4204: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

4200: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of records passed by inventory ' || p_changed_attributes.COUNT );
4201: WSH_DEBUG_SV.logmsg(l_module_name, 'Reject request as transaction_temp_id is passed for more than 1 record by inventory ');
4202: END IF;
4203: l_ship_status := 'having more than 1 record from inventory to be processed';
4204: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
4205: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
4206: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
4207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4208: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 4205: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

4201: WSH_DEBUG_SV.logmsg(l_module_name, 'Reject request as transaction_temp_id is passed for more than 1 record by inventory ');
4202: END IF;
4203: l_ship_status := 'having more than 1 record from inventory to be processed';
4204: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
4205: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
4206: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
4207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4208: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4209: IF l_debug_on THEN

Line 4206: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');

4202: END IF;
4203: l_ship_status := 'having more than 1 record from inventory to be processed';
4204: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
4205: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
4206: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
4207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4208: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4209: IF l_debug_on THEN
4210: WSH_DEBUG_SV.pop(l_module_name,'ERROR:REJECT INV REQUEST');

Line 4309: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LINE_DIR_INVALID');

4305: END IF;
4306: CLOSE C_Old_Detail;
4307: -- J: raise an exception if line_direction is not 'outbound' or 'internal order' -- jckwok
4308: IF (old_delivery_detail_rec.line_direction NOT IN ('O', 'IO')) THEN
4309: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LINE_DIR_INVALID');
4310: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', old_delivery_detail_rec.delivery_detail_id);
4311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4312: IF l_debug_on THEN
4313: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: operation is invalid for delivery line direction');

Line 4310: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', old_delivery_detail_rec.delivery_detail_id);

4306: CLOSE C_Old_Detail;
4307: -- J: raise an exception if line_direction is not 'outbound' or 'internal order' -- jckwok
4308: IF (old_delivery_detail_rec.line_direction NOT IN ('O', 'IO')) THEN
4309: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LINE_DIR_INVALID');
4310: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', old_delivery_detail_rec.delivery_detail_id);
4311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4312: IF l_debug_on THEN
4313: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: operation is invalid for delivery line direction');
4314: END IF;

Line 4340: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');

4336: THEN
4337:
4338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4339:
4340: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');
4341:
4342: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',
4343: old_delivery_detail_rec.source_line_number);
4344: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',

Line 4342: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',

4338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4339:
4340: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');
4341:
4342: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',
4343: old_delivery_detail_rec.source_line_number);
4344: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',
4345: old_delivery_detail_rec.source_header_number);
4346:

Line 4344: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',

4340: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');
4341:
4342: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',
4343: old_delivery_detail_rec.source_line_number);
4344: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',
4345: old_delivery_detail_rec.source_header_number);
4346:
4347: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
4348:

Line 5242: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');

5238: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPSET/SMC LINE GETTING BACKORDERED DUE TO ANOTHER LINE' );
5239: END IF;
5240: --
5241: IF g_ship_set_id IS NOT NULL THEN
5242: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
5243: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5244: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);

Line 5243: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

5239: END IF;
5240: --
5241: IF g_ship_set_id IS NOT NULL THEN
5242: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
5243: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5244: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5247: ELSE

Line 5244: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);

5240: --
5241: IF g_ship_set_id IS NOT NULL THEN
5242: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
5243: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5244: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5247: ELSE
5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');

Line 5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);

5241: IF g_ship_set_id IS NOT NULL THEN
5242: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
5243: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5244: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5247: ELSE
5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

Line 5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);

5242: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
5243: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5244: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5247: ELSE
5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);

Line 5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');

5244: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5247: ELSE
5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);

Line 5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

5245: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5247: ELSE
5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5253: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);

Line 5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);

5246: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5247: ELSE
5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5253: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5254: END IF;

Line 5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);

5247: ELSE
5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5253: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5254: END IF;
5255: l_msg:=FND_MESSAGE.GET;

Line 5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);

5248: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5253: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5254: END IF;
5255: l_msg:=FND_MESSAGE.GET;
5256: --

Line 5253: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);

5249: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5250: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5253: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5254: END IF;
5255: l_msg:=FND_MESSAGE.GET;
5256: --
5257: -- Debug Statements

Line 5255: l_msg:=FND_MESSAGE.GET;

5251: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
5252: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5253: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
5254: END IF;
5255: l_msg:=FND_MESSAGE.GET;
5256: --
5257: -- Debug Statements
5258: --
5259: IF l_debug_on THEN

Line 5312: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');

5308: IF l_debug_on THEN
5309: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPSET/SMC LINE GETTING BACKORDERED DUE TO INSUFFICIENT QTY ' );
5310: END IF;
5311: --
5312: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
5313: -- muom
5314: IF l_fulfillment_base = 'P' THEN
5315: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
5316: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity;

Line 5315: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);

5311: --
5312: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
5313: -- muom
5314: IF l_fulfillment_base = 'P' THEN
5315: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
5316: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity;
5317: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom;
5318: ELSE
5319: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);

Line 5319: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);

5315: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
5316: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity;
5317: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom;
5318: ELSE
5319: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);
5320: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity2;
5321: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5322: END IF;
5323: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

Line 5323: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

5319: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);
5320: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity2;
5321: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5322: END IF;
5323: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5324: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5325: l_msg:=FND_MESSAGE.GET;
5326: --
5327: -- Debug Statements

Line 5324: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);

5320: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity2;
5321: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5322: END IF;
5323: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5324: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5325: l_msg:=FND_MESSAGE.GET;
5326: --
5327: -- Debug Statements
5328: --

Line 5325: l_msg:=FND_MESSAGE.GET;

5321: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5322: END IF;
5323: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5324: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5325: l_msg:=FND_MESSAGE.GET;
5326: --
5327: -- Debug Statements
5328: --
5329: IF l_debug_on THEN

Line 5389: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');

5385: IF l_debug_on THEN
5386: WSH_DEBUG_SV.logmsg(l_module_name, 'LOGGING EXCEPTIONS FOR NON SHIPSET/SMC LINES ' );
5387: END IF;
5388: --
5389: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
5390: -- muom
5391: IF l_fulfillment_base = 'P' THEN
5392: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
5393: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity;

Line 5392: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);

5388: --
5389: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
5390: -- muom
5391: IF l_fulfillment_base = 'P' THEN
5392: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
5393: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity;
5394: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom;
5395: ELSE
5396: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);

Line 5396: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);

5392: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
5393: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity;
5394: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom;
5395: ELSE
5396: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);
5397: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity2;
5398: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5399: END IF;
5400: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

Line 5400: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

5396: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity2);
5397: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity2;
5398: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5399: END IF;
5400: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5401: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5402: l_msg:=FND_MESSAGE.GET;
5403: --
5404: -- Debug Statements

Line 5401: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);

5397: l_quantity := p_changed_attributes(l_Counter).cycle_count_quantity2;
5398: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5399: END IF;
5400: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5401: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5402: l_msg:=FND_MESSAGE.GET;
5403: --
5404: -- Debug Statements
5405: --

Line 5402: l_msg:=FND_MESSAGE.GET;

5398: l_unit_of_measure := old_delivery_detail_rec.requested_quantity_uom2;
5399: END IF;
5400: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
5401: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
5402: l_msg:=FND_MESSAGE.GET;
5403: --
5404: -- Debug Statements
5405: --
5406: IF l_debug_on THEN

Line 5736: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

5732: IF l_debug_on THEN
5733: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE REJECTED' );
5734: END IF;
5735: --
5736: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5737: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5738: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5740: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 5737: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

5733: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE REJECTED' );
5734: END IF;
5735: --
5736: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5737: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5738: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5740: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5741: ELSE

Line 5738: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');

5734: END IF;
5735: --
5736: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5737: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5738: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5740: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5741: ELSE
5742: IF (l_parent_detail_id IS NOT NULL) THEN

Line 5745: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PACKING');

5741: ELSE
5742: IF (l_parent_detail_id IS NOT NULL) THEN
5743:
5744: l_msg := NULL;
5745: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PACKING');
5746: l_msg := FND_MESSAGE.GET;
5747: l_exception_location_id := old_delivery_detail_rec.ship_from_location_id;
5748:
5749: --

Line 5746: l_msg := FND_MESSAGE.GET;

5742: IF (l_parent_detail_id IS NOT NULL) THEN
5743:
5744: l_msg := NULL;
5745: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PACKING');
5746: l_msg := FND_MESSAGE.GET;
5747: l_exception_location_id := old_delivery_detail_rec.ship_from_location_id;
5748:
5749: --
5750: wsh_xc_util.log_exception(

Line 6043: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');

6039: WSH_DEBUG_SV.log(l_module_name,'Update_Cont_Hierarchy l_return_status',l_return_status);
6040: END IF;
6041:
6042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6043: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
6044: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
6045: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6047: END IF;

Line 6044: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

6040: END IF;
6041:
6042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6043: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
6044: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
6045: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6047: END IF;
6048:

Line 6068: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6064: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE INVENTORY' );
6065: END IF;
6066: --
6067: IF ( l_reject_update = 'Y' ) THEN
6068: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6069: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6070: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
6071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6072: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 6069: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6065: END IF;
6066: --
6067: IF ( l_reject_update = 'Y' ) THEN
6068: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6069: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6070: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
6071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6072: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6073: ELSE

Line 6070: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');

6066: --
6067: IF ( l_reject_update = 'Y' ) THEN
6068: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6069: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6070: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
6071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6072: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6073: ELSE
6074: -- bug 2302693: we do not log an exception if the line is packed

Line 6096: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6092: --
6093: IF (l_reject_update = 'Y') THEN
6094: -- At least one line is shipped, reject user's request
6095: l_ship_status := 'confirmed, in-transit or closed';
6096: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6097: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6098: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
6099: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6100: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 6097: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6093: IF (l_reject_update = 'Y') THEN
6094: -- At least one line is shipped, reject user's request
6095: l_ship_status := 'confirmed, in-transit or closed';
6096: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6097: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6098: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
6099: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6100: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6101: ELSE

Line 6098: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');

6094: -- At least one line is shipped, reject user's request
6095: l_ship_status := 'confirmed, in-transit or closed';
6096: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6097: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6098: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
6099: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6100: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6101: ELSE
6102: -- bug 2302693: we do not log an exception if the line is packed

Line 6122: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6118: --
6119: IF (l_reject_update = 'Y') THEN
6120: -- At least one line is shipped, reject user's request
6121: l_ship_status := 'confirmed, in-transit or closed';
6122: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6123: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6124: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
6125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6126: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 6123: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6119: IF (l_reject_update = 'Y') THEN
6120: -- At least one line is shipped, reject user's request
6121: l_ship_status := 'confirmed, in-transit or closed';
6122: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6123: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6124: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
6125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6126: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6127: ELSE

Line 6124: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');

6120: -- At least one line is shipped, reject user's request
6121: l_ship_status := 'confirmed, in-transit or closed';
6122: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6123: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6124: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
6125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6126: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6127: ELSE
6128: -- bug 2302693: we do not log an exception if the line is packed

Line 6155: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6151: --
6152: IF (l_reject_update = 'Y') THEN
6153: -- At least one line is shipped, reject user's request
6154: l_ship_status := 'confirmed, in-transit or closed';
6155: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6156: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6157: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6159: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 6156: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6152: IF (l_reject_update = 'Y') THEN
6153: -- At least one line is shipped, reject user's request
6154: l_ship_status := 'confirmed, in-transit or closed';
6155: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6156: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6157: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6159: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6160: ELSE

Line 6157: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');

6153: -- At least one line is shipped, reject user's request
6154: l_ship_status := 'confirmed, in-transit or closed';
6155: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6156: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6157: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6159: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6160: ELSE
6161: -- bug 2302693: we do not log an exception if the line is packed

Line 6184: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6180: --
6181: IF (l_reject_update = 'Y') THEN
6182: -- At least one line is shipped, reject user's request
6183: l_ship_status := 'confirmed, in-transit or closed';
6184: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6185: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6186: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
6187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6188: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 6185: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6181: IF (l_reject_update = 'Y') THEN
6182: -- At least one line is shipped, reject user's request
6183: l_ship_status := 'confirmed, in-transit or closed';
6184: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6185: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6186: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
6187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6188: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6189: ELSE

Line 6186: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');

6182: -- At least one line is shipped, reject user's request
6183: l_ship_status := 'confirmed, in-transit or closed';
6184: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6185: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6186: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
6187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6188: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6189: ELSE
6190: -- bug 2302693: we do not log an exception if the line is packed

Line 6215: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6211: --
6212: IF (l_reject_update = 'Y') THEN
6213: -- At least one line is shipped, reject user's request
6214: l_ship_status := 'confirmed, in-transit or closed';
6215: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6216: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6217: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
6218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6219: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 6216: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6212: IF (l_reject_update = 'Y') THEN
6213: -- At least one line is shipped, reject user's request
6214: l_ship_status := 'confirmed, in-transit or closed';
6215: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6216: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6217: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
6218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6219: WSH_UTIL_CORE.Add_Message(x_return_status);
6220: ELSE

Line 6217: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');

6213: -- At least one line is shipped, reject user's request
6214: l_ship_status := 'confirmed, in-transit or closed';
6215: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6216: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6217: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
6218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6219: WSH_UTIL_CORE.Add_Message(x_return_status);
6220: ELSE
6221: l_update_transaction_temp_id := 'Y';

Line 6237: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6233: --
6234: IF (l_reject_update = 'Y') THEN
6235: -- At least one line is shipped, reject user's request
6236: l_ship_status := 'confirmed, in-transit or closed';
6237: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6238: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6239: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
6240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6241: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 6238: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6234: IF (l_reject_update = 'Y') THEN
6235: -- At least one line is shipped, reject user's request
6236: l_ship_status := 'confirmed, in-transit or closed';
6237: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6238: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6239: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
6240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6241: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6242: ELSE

Line 6239: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');

6235: -- At least one line is shipped, reject user's request
6236: l_ship_status := 'confirmed, in-transit or closed';
6237: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6238: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6239: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
6240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6241: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6242: ELSE
6243: -- bug 2302693: we do not log an exception if the line is packed

Line 6263: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');

6259: --
6260: IF (l_reject_update = 'Y') THEN
6261: -- At least one line is shipped, reject user's request
6262: l_ship_status := 'confirmed, in-transit or closed';
6263: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6264: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6265: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
6266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6267: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 6264: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);

6260: IF (l_reject_update = 'Y') THEN
6261: -- At least one line is shipped, reject user's request
6262: l_ship_status := 'confirmed, in-transit or closed';
6263: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6264: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6265: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
6266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6267: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6268: ELSE

Line 6265: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');

6261: -- At least one line is shipped, reject user's request
6262: l_ship_status := 'confirmed, in-transit or closed';
6263: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6264: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6265: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
6266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6267: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6268: ELSE
6269: l_update_rel_status := 'Y';

Line 6483: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');

6479: )
6480: ) THEN
6481:
6482: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
6483: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
6484: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
6485: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
6486: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 6484: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);

6480: ) THEN
6481:
6482: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
6483: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
6484: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
6485: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
6486: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6488: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 6485: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);

6481:
6482: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
6483: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
6484: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
6485: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
6486: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6488: WSH_UTIL_CORE.Add_Message(x_return_status);
6489:

Line 6486: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);

6482: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
6483: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
6484: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
6485: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
6486: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6488: WSH_UTIL_CORE.Add_Message(x_return_status);
6489:
6490: END IF;

Line 7110: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');

7106: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Delivery_Line_Direction_Err');
7107: END IF;
7108: -- deliveryMerge
7109: WHEN Adjust_Planned_Flag_Err THEN
7110: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
7111: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
7112: x_return_status := l_return_status;
7113:
7114: --