DBA Data[Home] [Help]

APPS.WSH_USA_QUANTITY_PVT dependencies on FND_MESSAGE

Line 841: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_DELETE_QUANTITY');

837: IF l_debug_on THEN
838: WSH_DEBUG_SV.logmsg(l_module_name, 'REJECT REQUEST AS SOME DELIVERY LINES ARE '||L_RELEASED_STATUS );
839: END IF;
840: --
841: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_DELETE_QUANTITY');
842: RAISE reject_delete;
843: END IF;
844:
845: ELSIF (p_action_flag = 'U') THEN --} {

Line 1395: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');

1391: AND old_delivery_detail_rec.move_order_line_id IS NOT NULL
1392: AND p_wms_flag = 'Y'
1393: AND p_changed_attribute.ordered_quantity > 0 THEN
1394: ROLLBACK TO SAVEPOINT startloop;
1395: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
1396: RAISE reject_update;
1397: END IF;
1398: -- muom
1399: l_requested_adj_quantity := 0;

Line 1567: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');

1563: -- muom
1564: AND ((l_fulfillment_base = 'P' and p_changed_attribute.ordered_quantity > 0) OR
1565: (l_fulfillment_base = 'S' and p_changed_attribute.ordered_quantity2 > 0)))) THEN
1566: ROLLBACK TO SAVEPOINT startloop;
1567: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
1568: RAISE reject_update;
1569: END IF;
1570:
1571: IF (old_delivery_detail_rec.parent_delivery_detail_id IS NOT NULL) THEN -- Packed = Y

Line 1608: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');

1604: END IF;
1605: --
1606: x_return_status := l_return_status;
1607: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1608: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1609: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1610: ELSE
1611: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);
1612: END IF;

Line 1783: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY');

1779: -- muom
1780: IF (l_fulfillment_base = 'P') THEN
1781: IF l_valid_update_quantity > 0 THEN
1782: -- Throw message saying the quantity that can be cancelled
1783: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY');
1784: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity);
1785: ELSE
1786: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');
1787: END IF;

Line 1784: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity);

1780: IF (l_fulfillment_base = 'P') THEN
1781: IF l_valid_update_quantity > 0 THEN
1782: -- Throw message saying the quantity that can be cancelled
1783: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY');
1784: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity);
1785: ELSE
1786: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');
1787: END IF;
1788: ELSE

Line 1786: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');

1782: -- Throw message saying the quantity that can be cancelled
1783: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY');
1784: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity);
1785: ELSE
1786: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');
1787: END IF;
1788: ELSE
1789: -- muom
1790: IF l_valid_update_quantity2 > 0 THEN

Line 1792: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY2');

1788: ELSE
1789: -- muom
1790: IF l_valid_update_quantity2 > 0 THEN
1791: -- Throw message saying the quantity that can be cancelled
1792: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY2');
1793: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity2);
1794: ELSE
1795: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');
1796: END IF;

Line 1793: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity2);

1789: -- muom
1790: IF l_valid_update_quantity2 > 0 THEN
1791: -- Throw message saying the quantity that can be cancelled
1792: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY2');
1793: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity2);
1794: ELSE
1795: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');
1796: END IF;
1797: END IF;

Line 1795: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');

1791: -- Throw message saying the quantity that can be cancelled
1792: FND_MESSAGE.Set_Name('WSH', 'WSH_VALID_UPDATE_QUANTITY2');
1793: FND_MESSAGE.Set_Token('UPDATE_QUANTITY',l_valid_update_quantity2);
1794: ELSE
1795: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_QUANTITY');
1796: END IF;
1797: END IF;
1798:
1799: RAISE reject_update;

Line 2027: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_AS_FAILED');

2023: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_DELETE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_DELETE');
2025: END IF;
2026: WHEN create_assignment_failure THEN
2027: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_AS_FAILED');
2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2029: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_ASSIGNMENT_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2036: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_DET_FAILED');

2032: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_ASSIGNMENT_FAILURE');
2033: END IF;
2034: --
2035: WHEN create_detail_failure THEN
2036: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_DET_FAILED');
2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2038: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2039:
2040: IF l_debug_on THEN

Line 2045: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_DELETE_DET_FAILED');

2041: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2042: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_DETAIL_FAILURE');
2043: END IF;
2044: WHEN delete_detail_failure THEN
2045: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_DELETE_DET_FAILED');
2046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2047: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2048:
2049: IF l_debug_on THEN

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

2050: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2051: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELETE_DETAIL_FAILURE');
2052: END IF;
2053: WHEN mark_reprice_error THEN
2054: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2055: x_return_status := l_return_status;
2056: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2057:
2058: IF l_debug_on THEN

Line 2067: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');

2063: WHEN invalid_ship_set THEN
2064: IF l_debug_on THEN
2065: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: INVALID SHIP SET' );
2066: END IF;
2067: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');
2068: fnd_message.set_token('SHIP_SET',l_ship_set_name);
2069: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 2068: fnd_message.set_token('SHIP_SET',l_ship_set_name);

2064: IF l_debug_on THEN
2065: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: INVALID SHIP SET' );
2066: END IF;
2067: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');
2068: fnd_message.set_token('SHIP_SET',l_ship_set_name);
2069: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2072: WHEN invalid_smc_model_change THEN

Line 2069: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);

2065: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: INVALID SHIP SET' );
2066: END IF;
2067: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');
2068: fnd_message.set_token('SHIP_SET',l_ship_set_name);
2069: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2072: WHEN invalid_smc_model_change THEN
2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');

Line 2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');

2069: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2072: WHEN invalid_smc_model_change THEN
2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
2074: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
2075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2076: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2077: IF l_debug_on THEN

Line 2074: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);

2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2072: WHEN invalid_smc_model_change THEN
2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
2074: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
2075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2076: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2081:
2082:
2083:
2084: WHEN Adjust_Planned_Flag_Err THEN
2085: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
2086: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
2087: x_return_status := l_return_status;
2088:
2089: IF l_debug_on THEN

Line 2324: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_MO_LINE');

2320: IF l_debug_on THEN
2321: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN INV_MO_CANCEL_PVT.CANCEL_MOVE_ORDER_LINE ' );
2322: END IF;
2323: --
2324: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_MO_LINE');
2325: IF l_msg_count = 1 THEN
2326: --
2327: -- Debug Statements
2328: --

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

2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
2331: END IF;
2332: --
2333: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
2334: ELSE
2335: FOR l_index IN 1..l_msg_count LOOP
2336: l_msg_data := fnd_msg_pub.get;
2337: --

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

2342: END IF;
2343: --
2344: l_error_text := l_error_text || l_msg_data;
2345: END LOOP;
2346: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2347: l_error_text := '';
2348: END IF;
2349: x_return_status := FND_API.G_RET_STS_ERROR;
2350: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 2576: FND_MESSAGE.SET_NAME('WSH',p_reason);

2572:
2573: x_return_status := FND_API.G_RET_STS_SUCCESS;
2574:
2575: -- Get p_reason here which is passed as the message name
2576: FND_MESSAGE.SET_NAME('WSH',p_reason);
2577: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
2578: IF p_reason = 'WSH_CANCELLED_PLANNED' THEN
2579: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',p_delivery_id);
2580: END IF;

Line 2577: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);

2573: x_return_status := FND_API.G_RET_STS_SUCCESS;
2574:
2575: -- Get p_reason here which is passed as the message name
2576: FND_MESSAGE.SET_NAME('WSH',p_reason);
2577: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
2578: IF p_reason = 'WSH_CANCELLED_PLANNED' THEN
2579: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',p_delivery_id);
2580: END IF;
2581:

Line 2579: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',p_delivery_id);

2575: -- Get p_reason here which is passed as the message name
2576: FND_MESSAGE.SET_NAME('WSH',p_reason);
2577: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
2578: IF p_reason = 'WSH_CANCELLED_PLANNED' THEN
2579: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',p_delivery_id);
2580: END IF;
2581:
2582: l_msg := FND_MESSAGE.GET;
2583: l_exception_location_id := p_ship_from_location_id;

Line 2582: l_msg := FND_MESSAGE.GET;

2578: IF p_reason = 'WSH_CANCELLED_PLANNED' THEN
2579: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',p_delivery_id);
2580: END IF;
2581:
2582: l_msg := FND_MESSAGE.GET;
2583: l_exception_location_id := p_ship_from_location_id;
2584:
2585: IF p_reason = 'WSH_CANCELLED_PACKED' THEN
2586: l_delivery_id := NULL;

Line 3216: FND_MESSAGE.Set_Name('WSH', 'WSH_REDUCE_MO_QUANTITY');

3212: WSH_DEBUG_SV.log(l_module_name,'Reduce_Move_Order_Quantity x_return_status',x_return_status);
3213: END IF;
3214:
3215: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3216: FND_MESSAGE.Set_Name('WSH', 'WSH_REDUCE_MO_QUANTITY');
3217: IF l_msg_count = 1 THEN
3218: --
3219: -- Debug Statements
3220: --

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

3221: IF l_debug_on THEN
3222: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
3223: END IF;
3224: --
3225: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
3226: ELSE
3227: FOR l_index IN 1..l_msg_count LOOP
3228: l_msg_data := fnd_msg_pub.get;
3229: --

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

3234: END IF;
3235: --
3236: l_error_text := l_error_text || l_msg_data;
3237: END LOOP;
3238: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3239: l_error_text := '';
3240: END IF;
3241: x_return_status := FND_API.G_RET_STS_ERROR;
3242: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 3456: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_MO_LINE');

3452: IF l_debug_on THEN
3453: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN INV_MO_CANCEL_PVT.CANCEL_MOVE_ORDER_LINE ' );
3454: END IF;
3455: --
3456: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_MO_LINE');
3457: IF l_msg_count = 1 THEN
3458: --
3459: -- Debug Statements
3460: --

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

3461: IF l_debug_on THEN
3462: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
3463: END IF;
3464: --
3465: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
3466: ELSE
3467: FOR l_index IN 1..l_msg_count LOOP
3468: l_msg_data := fnd_msg_pub.get;
3469: --

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

3474: END IF;
3475: --
3476: l_error_text := l_error_text || l_msg_data;
3477: END LOOP;
3478: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3479: l_error_text := '';
3480: END IF;
3481: x_return_status := FND_API.G_RET_STS_ERROR;
3482: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 3533: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_MO_LINE');

3529: IF l_debug_on THEN
3530: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN INV_MO_CANCEL_PVT.CANCEL_MOVE_ORDER_LINE ' );
3531: END IF;
3532: --
3533: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_MO_LINE');
3534: IF l_msg_count = 1 THEN
3535: --
3536: -- Debug Statements
3537: --

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

3538: IF l_debug_on THEN
3539: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: '|| L_MSG_DATA );
3540: END IF;
3541: --
3542: FND_MESSAGE.Set_Token('ERROR_TEXT',l_msg_data);
3543: ELSE
3544: FOR l_index IN 1..l_msg_count LOOP
3545: l_msg_data := fnd_msg_pub.get;
3546: --

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

3551: END IF;
3552: --
3553: l_error_text := l_error_text || l_msg_data;
3554: END LOOP;
3555: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3556: END IF;
3557: x_return_status := FND_API.G_RET_STS_ERROR;
3558: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3559: --

Line 3660: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');

3656: WSH_DEBUG_SV.logmsg(l_module_name, l_serial_quantity||' Serial Number(s) have to be deleted for dd '
3657: ||p_delivery_detail_id);
3658: END IF;
3659: --
3660: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3661: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3662: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3663: x_return_status := FND_API.G_RET_STS_ERROR;
3664: return;

Line 3661: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);

3657: ||p_delivery_detail_id);
3658: END IF;
3659: --
3660: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3661: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3662: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3663: x_return_status := FND_API.G_RET_STS_ERROR;
3664: return;
3665:

Line 3662: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);

3658: END IF;
3659: --
3660: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3661: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3662: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3663: x_return_status := FND_API.G_RET_STS_ERROR;
3664: return;
3665:
3666: ELSIF (p_serial_number IS NOT NULL ) AND (p_requested_quantity - ABS(p_changed_detail_quantity) <= 0) THEN

Line 3676: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');

3672: WSH_DEBUG_SV.logmsg(l_module_name, l_serial_quantity||' Serial Number(s) have to be deleted for dd '
3673: ||p_delivery_detail_id);
3674: END IF;
3675: --
3676: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3677: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3678: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3679: x_return_status := FND_API.G_RET_STS_ERROR;
3680: return;

Line 3677: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);

3673: ||p_delivery_detail_id);
3674: END IF;
3675: --
3676: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3677: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3678: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3679: x_return_status := FND_API.G_RET_STS_ERROR;
3680: return;
3681: END IF;

Line 3678: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);

3674: END IF;
3675: --
3676: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3677: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3678: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3679: x_return_status := FND_API.G_RET_STS_ERROR;
3680: return;
3681: END IF;
3682: