DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on FND_MESSAGE

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

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

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

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

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

1092: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF RESERVATIONS FOUND: '||TO_CHAR ( X_MTL_RESERVATION_TBL_COUNT ) );
1093: END IF;
1094: --
1095: ELSE
1096: FND_MESSAGE.Set_Name('WSH', 'WSH_QUERY_RESERVATION');
1097: IF l_msg_count = 1 THEN
1098: --
1099: -- Debug Statements
1100: --

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

1101: IF l_debug_on THEN
1102: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1103: END IF;
1104: --
1105: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1106: ELSE
1107: FOR l_index IN 1..l_msg_count LOOP
1108: l_msg_data := fnd_msg_pub.get;
1109: --

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

1114: END IF;
1115: --
1116: l_error_text := l_error_text || l_msg_data;
1117: END LOOP;
1118: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1119: END IF;
1120: raise query_reservation_failed;
1121: END IF;
1122:

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

1200: IF l_debug_on THEN
1201: WSH_DEBUG_SV.logmsg(l_module_name, 'COULD NOT DELETE RESERVATION FOR RESERVATION ID : '||P_QUERY_INPUT.RESERVATION_ID );
1202: END IF;
1203: --
1204: FND_MESSAGE.Set_Name('WSH', 'WSH_DELETE_RESERVATION');
1205: IF l_msg_count = 1 THEN
1206: --
1207: -- Debug Statements
1208: --

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

1209: IF l_debug_on THEN
1210: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1211: END IF;
1212: --
1213: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1214: ELSE
1215: FOR l_index IN 1..l_msg_count LOOP
1216: l_msg_data := fnd_msg_pub.get;
1217: --

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

1222: END IF;
1223: --
1224: l_error_text := l_error_text || l_msg_data;
1225: END LOOP;
1226: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1227: END IF;
1228: raise delete_reservation_failed;
1229: END IF;
1230:

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

1369: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATION CREATED FOR RESERVATION ID : '||X_RESERVATION_ID );
1370: END IF;
1371: --
1372: ELSE
1373: FND_MESSAGE.Set_Name('WSH', 'WSH_CREATE_RESERVATION');
1374: IF l_msg_count = 1 THEN
1375: --
1376: -- Debug Statements
1377: --

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

1378: IF l_debug_on THEN
1379: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1380: END IF;
1381: --
1382: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1383: ELSE
1384: FOR l_index IN 1..l_msg_count LOOP
1385: l_msg_data := fnd_msg_pub.get;
1386: --

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

1391: END IF;
1392: --
1393: l_error_text := l_error_text || l_msg_data;
1394: END LOOP;
1395: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1396: END IF;
1397: raise create_reservation_failed;
1398: END IF;
1399: -- HW OPMCONV removed forking

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

1505: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATION UPDATED FOR RESERVATION ID : '||TO_CHAR ( P_QUERY_INPUT.RESERVATION_ID ) );
1506: END IF;
1507: --
1508: ELSE
1509: FND_MESSAGE.Set_Name('WSH', 'WSH_UPDATE_RESERVATION');
1510: IF l_msg_count = 1 THEN
1511: --
1512: -- Debug Statements
1513: --

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

1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
1516: END IF;
1517: --
1518: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
1519: ELSE
1520: FOR l_index IN 1..l_msg_count LOOP
1521: l_msg_data := fnd_msg_pub.get;
1522: --

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

1527: END IF;
1528: --
1529: l_error_text := l_error_text || l_msg_data;
1530: END LOOP;
1531: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
1532: END IF;
1533: raise update_reservation_failed;
1534: END IF;
1535:

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

2785: ELSE
2786: IF l_debug_on THEN
2787: WSH_DEBUG_SV.logmsg(l_module_name, 'COULD NOT TRANSFER FOR RESERVATION ID : '||P_RSV.RESERVATION_ID );
2788: END IF;
2789: FND_MESSAGE.Set_Name('WSH', 'WSH_TRANSFER_RESERVATION');
2790: IF l_msg_count = 1 THEN
2791: IF l_debug_on THEN
2792: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
2793: END IF;

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

2791: IF l_debug_on THEN
2792: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
2793: END IF;
2794: --
2795: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
2796: ELSE
2797: FOR l_index IN 1..l_msg_count LOOP
2798: l_msg_data := fnd_msg_pub.get;
2799: IF l_debug_on THEN

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

2801: END IF;
2802: --
2803: l_error_text := l_error_text || l_msg_data;
2804: END LOOP;
2805: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2806: l_error_text := '';
2807: END IF;
2808: raise transfer_split_failed;
2809: END IF;

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

3793: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of records passed by inventory ' || p_changed_attributes.COUNT );
3794: WSH_DEBUG_SV.logmsg(l_module_name, 'Reject request as transaction_temp_id is passed for more than 1 record by inventory ');
3795: END IF;
3796: l_ship_status := 'having more than 1 record from inventory to be processed';
3797: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
3798: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
3799: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
3800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3801: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3794: WSH_DEBUG_SV.logmsg(l_module_name, 'Reject request as transaction_temp_id is passed for more than 1 record by inventory ');
3795: END IF;
3796: l_ship_status := 'having more than 1 record from inventory to be processed';
3797: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
3798: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
3799: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
3800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3801: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3802: IF l_debug_on THEN

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

3795: END IF;
3796: l_ship_status := 'having more than 1 record from inventory to be processed';
3797: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
3798: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
3799: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
3800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3801: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3802: IF l_debug_on THEN
3803: WSH_DEBUG_SV.pop(l_module_name,'ERROR:REJECT INV REQUEST');

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

3900: END IF;
3901: CLOSE C_Old_Detail;
3902: -- J: raise an exception if line_direction is not 'outbound' or 'internal order' -- jckwok
3903: IF (old_delivery_detail_rec.line_direction NOT IN ('O', 'IO')) THEN
3904: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LINE_DIR_INVALID');
3905: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', old_delivery_detail_rec.delivery_detail_id);
3906: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3907: IF l_debug_on THEN
3908: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: operation is invalid for delivery line direction');

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

3901: CLOSE C_Old_Detail;
3902: -- J: raise an exception if line_direction is not 'outbound' or 'internal order' -- jckwok
3903: IF (old_delivery_detail_rec.line_direction NOT IN ('O', 'IO')) THEN
3904: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LINE_DIR_INVALID');
3905: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', old_delivery_detail_rec.delivery_detail_id);
3906: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3907: IF l_debug_on THEN
3908: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: operation is invalid for delivery line direction');
3909: END IF;

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

3931: THEN
3932:
3933: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3934:
3935: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');
3936:
3937: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',
3938: old_delivery_detail_rec.source_line_number);
3939: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',

Line 3937: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',

3933: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3934:
3935: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');
3936:
3937: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',
3938: old_delivery_detail_rec.source_line_number);
3939: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',
3940: old_delivery_detail_rec.source_header_number);
3941:

Line 3939: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',

3935: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');
3936:
3937: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',
3938: old_delivery_detail_rec.source_line_number);
3939: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',
3940: old_delivery_detail_rec.source_header_number);
3941:
3942: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
3943:

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

4702: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPSET/SMC LINE GETTING BACKORDERED DUE TO ANOTHER LINE' );
4703: END IF;
4704: --
4705: IF g_ship_set_id IS NOT NULL THEN
4706: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
4707: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4708: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
4709: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);

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

4703: END IF;
4704: --
4705: IF g_ship_set_id IS NOT NULL THEN
4706: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
4707: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4708: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
4709: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4711: ELSE

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

4704: --
4705: IF g_ship_set_id IS NOT NULL THEN
4706: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
4707: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4708: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
4709: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4711: ELSE
4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');

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

4705: IF g_ship_set_id IS NOT NULL THEN
4706: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
4707: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4708: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
4709: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4711: ELSE
4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

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

4706: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SS_FAILED');
4707: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4708: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
4709: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4711: ELSE
4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4714: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);

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

4708: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME',g_ship_set_name);
4709: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4711: ELSE
4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4714: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
4715: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
4716: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);

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

4709: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4711: ELSE
4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4714: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
4715: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
4716: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4717: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);

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

4710: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4711: ELSE
4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4714: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
4715: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
4716: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4717: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4718: END IF;

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

4711: ELSE
4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4714: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
4715: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
4716: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4717: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4718: END IF;
4719: l_msg:=FND_MESSAGE.GET;

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

4712: FND_MESSAGE.SET_NAME('WSH','WSH_PR_OTHER_SMC_FAILED');
4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4714: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
4715: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
4716: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4717: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4718: END IF;
4719: l_msg:=FND_MESSAGE.GET;
4720: --

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

4713: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4714: FND_MESSAGE.SET_TOKEN('LINE',old_delivery_detail_rec.source_line_number);
4715: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
4716: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4717: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4718: END IF;
4719: l_msg:=FND_MESSAGE.GET;
4720: --
4721: -- Debug Statements

Line 4719: l_msg:=FND_MESSAGE.GET;

4715: FND_MESSAGE.SET_TOKEN('MODEL_ITEM',g_top_model_item);
4716: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4717: FND_MESSAGE.SET_TOKEN('BACKORDER_ITEM',g_backordered_item);
4718: END IF;
4719: l_msg:=FND_MESSAGE.GET;
4720: --
4721: -- Debug Statements
4722: --
4723: IF l_debug_on THEN

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

4772: IF l_debug_on THEN
4773: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPSET/SMC LINE GETTING BACKORDERED DUE TO INSUFFICIENT QTY ' );
4774: END IF;
4775: --
4776: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4777: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4778: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4779: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4780: l_msg:=FND_MESSAGE.GET;

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

4773: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPSET/SMC LINE GETTING BACKORDERED DUE TO INSUFFICIENT QTY ' );
4774: END IF;
4775: --
4776: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4777: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4778: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4779: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4780: l_msg:=FND_MESSAGE.GET;
4781: --

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

4774: END IF;
4775: --
4776: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4777: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4778: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4779: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4780: l_msg:=FND_MESSAGE.GET;
4781: --
4782: -- Debug Statements

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

4775: --
4776: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4777: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4778: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4779: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4780: l_msg:=FND_MESSAGE.GET;
4781: --
4782: -- Debug Statements
4783: --

Line 4780: l_msg:=FND_MESSAGE.GET;

4776: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4777: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4778: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4779: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4780: l_msg:=FND_MESSAGE.GET;
4781: --
4782: -- Debug Statements
4783: --
4784: IF l_debug_on THEN

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

4839: IF l_debug_on THEN
4840: WSH_DEBUG_SV.logmsg(l_module_name, 'LOGGING EXCEPTIONS FOR NON SHIPSET/SMC LINES ' );
4841: END IF;
4842: --
4843: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4844: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4845: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4846: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4847: l_msg:=FND_MESSAGE.GET;

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

4840: WSH_DEBUG_SV.logmsg(l_module_name, 'LOGGING EXCEPTIONS FOR NON SHIPSET/SMC LINES ' );
4841: END IF;
4842: --
4843: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4844: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4845: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4846: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4847: l_msg:=FND_MESSAGE.GET;
4848: --

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

4841: END IF;
4842: --
4843: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4844: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4845: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4846: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4847: l_msg:=FND_MESSAGE.GET;
4848: --
4849: -- Debug Statements

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

4842: --
4843: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4844: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4845: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4846: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4847: l_msg:=FND_MESSAGE.GET;
4848: --
4849: -- Debug Statements
4850: --

Line 4847: l_msg:=FND_MESSAGE.GET;

4843: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_BACKORDER');
4844: FND_MESSAGE.SET_TOKEN('QTY',p_Changed_attributes(l_Counter).cycle_count_quantity);
4845: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
4846: FND_MESSAGE.SET_TOKEN('ORDER',old_delivery_detail_rec.source_header_number);
4847: l_msg:=FND_MESSAGE.GET;
4848: --
4849: -- Debug Statements
4850: --
4851: IF l_debug_on THEN

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

5161: IF l_debug_on THEN
5162: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE REJECTED' );
5163: END IF;
5164: --
5165: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5166: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5167: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5168: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5169: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

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

5162: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE REJECTED' );
5163: END IF;
5164: --
5165: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5166: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5167: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5168: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5169: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5170: ELSE

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

5163: END IF;
5164: --
5165: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5166: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5167: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5168: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5169: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5170: ELSE
5171: IF (l_parent_detail_id IS NOT NULL) THEN

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

5170: ELSE
5171: IF (l_parent_detail_id IS NOT NULL) THEN
5172:
5173: l_msg := NULL;
5174: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PACKING');
5175: l_msg := FND_MESSAGE.GET;
5176: l_exception_location_id := old_delivery_detail_rec.ship_from_location_id;
5177:
5178: --

Line 5175: l_msg := FND_MESSAGE.GET;

5171: IF (l_parent_detail_id IS NOT NULL) THEN
5172:
5173: l_msg := NULL;
5174: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PACKING');
5175: l_msg := FND_MESSAGE.GET;
5176: l_exception_location_id := old_delivery_detail_rec.ship_from_location_id;
5177:
5178: --
5179: wsh_xc_util.log_exception(

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

5465: WSH_DEBUG_SV.log(l_module_name,'Update_Cont_Hierarchy l_return_status',l_return_status);
5466: END IF;
5467:
5468: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5469: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
5470: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
5471: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5473: END IF;

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

5466: END IF;
5467:
5468: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5469: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
5470: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
5471: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5473: END IF;
5474:

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

5490: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE INVENTORY' );
5491: END IF;
5492: --
5493: IF ( l_reject_update = 'Y' ) THEN
5494: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5495: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5496: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
5497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5498: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

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

5491: END IF;
5492: --
5493: IF ( l_reject_update = 'Y' ) THEN
5494: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5495: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5496: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
5497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5498: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5499: ELSE

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

5492: --
5493: IF ( l_reject_update = 'Y' ) THEN
5494: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5495: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5496: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
5497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5498: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5499: ELSE
5500: -- bug 2302693: we do not log an exception if the line is packed

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

5518: --
5519: IF (l_reject_update = 'Y') THEN
5520: -- At least one line is shipped, reject user's request
5521: l_ship_status := 'confirmed, in-transit or closed';
5522: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5523: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5524: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
5525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5526: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

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

5519: IF (l_reject_update = 'Y') THEN
5520: -- At least one line is shipped, reject user's request
5521: l_ship_status := 'confirmed, in-transit or closed';
5522: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5523: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5524: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
5525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5526: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5527: ELSE

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

5520: -- At least one line is shipped, reject user's request
5521: l_ship_status := 'confirmed, in-transit or closed';
5522: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5523: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5524: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
5525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5526: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5527: ELSE
5528: -- bug 2302693: we do not log an exception if the line is packed

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

5544: --
5545: IF (l_reject_update = 'Y') THEN
5546: -- At least one line is shipped, reject user's request
5547: l_ship_status := 'confirmed, in-transit or closed';
5548: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5549: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5550: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
5551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5552: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

5545: IF (l_reject_update = 'Y') THEN
5546: -- At least one line is shipped, reject user's request
5547: l_ship_status := 'confirmed, in-transit or closed';
5548: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5549: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5550: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
5551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5552: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5553: ELSE

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

5546: -- At least one line is shipped, reject user's request
5547: l_ship_status := 'confirmed, in-transit or closed';
5548: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5549: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5550: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
5551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5552: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5553: ELSE
5554: -- bug 2302693: we do not log an exception if the line is packed

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

5580: --
5581: IF (l_reject_update = 'Y') THEN
5582: -- At least one line is shipped, reject user's request
5583: l_ship_status := 'confirmed, in-transit or closed';
5584: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5585: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5586: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
5587: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5588: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

5581: IF (l_reject_update = 'Y') THEN
5582: -- At least one line is shipped, reject user's request
5583: l_ship_status := 'confirmed, in-transit or closed';
5584: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5585: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5586: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
5587: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5588: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5589: ELSE

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

5582: -- At least one line is shipped, reject user's request
5583: l_ship_status := 'confirmed, in-transit or closed';
5584: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5585: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5586: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
5587: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5588: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5589: ELSE
5590: -- bug 2302693: we do not log an exception if the line is packed

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

5609: --
5610: IF (l_reject_update = 'Y') THEN
5611: -- At least one line is shipped, reject user's request
5612: l_ship_status := 'confirmed, in-transit or closed';
5613: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5614: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5615: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5617: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

5610: IF (l_reject_update = 'Y') THEN
5611: -- At least one line is shipped, reject user's request
5612: l_ship_status := 'confirmed, in-transit or closed';
5613: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5614: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5615: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5617: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5618: ELSE

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

5611: -- At least one line is shipped, reject user's request
5612: l_ship_status := 'confirmed, in-transit or closed';
5613: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5614: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5615: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5617: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5618: ELSE
5619: -- bug 2302693: we do not log an exception if the line is packed

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

5640: --
5641: IF (l_reject_update = 'Y') THEN
5642: -- At least one line is shipped, reject user's request
5643: l_ship_status := 'confirmed, in-transit or closed';
5644: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5645: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5646: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
5647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5648: WSH_UTIL_CORE.Add_Message(x_return_status);

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

5641: IF (l_reject_update = 'Y') THEN
5642: -- At least one line is shipped, reject user's request
5643: l_ship_status := 'confirmed, in-transit or closed';
5644: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5645: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5646: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
5647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5648: WSH_UTIL_CORE.Add_Message(x_return_status);
5649: ELSE

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

5642: -- At least one line is shipped, reject user's request
5643: l_ship_status := 'confirmed, in-transit or closed';
5644: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5645: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5646: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
5647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5648: WSH_UTIL_CORE.Add_Message(x_return_status);
5649: ELSE
5650: l_update_transaction_temp_id := 'Y';

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

5662: --
5663: IF (l_reject_update = 'Y') THEN
5664: -- At least one line is shipped, reject user's request
5665: l_ship_status := 'confirmed, in-transit or closed';
5666: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5667: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5668: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
5669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5670: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

5663: IF (l_reject_update = 'Y') THEN
5664: -- At least one line is shipped, reject user's request
5665: l_ship_status := 'confirmed, in-transit or closed';
5666: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5667: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5668: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
5669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5670: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5671: ELSE

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

5664: -- At least one line is shipped, reject user's request
5665: l_ship_status := 'confirmed, in-transit or closed';
5666: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5667: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5668: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
5669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5670: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5671: ELSE
5672: -- bug 2302693: we do not log an exception if the line is packed

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

5688: --
5689: IF (l_reject_update = 'Y') THEN
5690: -- At least one line is shipped, reject user's request
5691: l_ship_status := 'confirmed, in-transit or closed';
5692: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5693: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5694: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
5695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5696: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

5689: IF (l_reject_update = 'Y') THEN
5690: -- At least one line is shipped, reject user's request
5691: l_ship_status := 'confirmed, in-transit or closed';
5692: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5693: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5694: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
5695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5696: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5697: ELSE

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

5690: -- At least one line is shipped, reject user's request
5691: l_ship_status := 'confirmed, in-transit or closed';
5692: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5693: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5694: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
5695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5696: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5697: ELSE
5698: l_update_rel_status := 'Y';

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

5907: )
5908: ) THEN
5909:
5910: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
5911: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
5912: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
5913: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
5914: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
5915: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

5908: ) THEN
5909:
5910: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
5911: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
5912: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
5913: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
5914: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
5915: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5916: WSH_UTIL_CORE.Add_Message(x_return_status);

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

5909:
5910: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
5911: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
5912: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
5913: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
5914: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
5915: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5916: WSH_UTIL_CORE.Add_Message(x_return_status);
5917:

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

5910: OE_DEBUG_PUB.Add('REJECTING INVENTORY REQUEST');
5911: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
5912: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
5913: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
5914: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
5915: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5916: WSH_UTIL_CORE.Add_Message(x_return_status);
5917:
5918: END IF;

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

6400: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Delivery_Line_Direction_Err');
6401: END IF;
6402: -- deliveryMerge
6403: WHEN Adjust_Planned_Flag_Err THEN
6404: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
6405: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
6406: x_return_status := l_return_status;
6407:
6408: --