eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WV_UTILS dependencies on FND_MESSAGE

Line 110: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');

106: -- Reset the result to 0 to preserve compatibility before
107: -- the bug fix made above (namely, always call inv_um_convert).
108: if result = -99999 then
109: result := 0;
110: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');
111: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);
112: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);
113: end if;
114: END IF;

Line 111: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);

107: -- the bug fix made above (namely, always call inv_um_convert).
108: if result = -99999 then
109: result := 0;
110: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');
111: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);
112: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);
113: end if;
114: END IF;
115: END IF;

Line 112: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);

108: if result = -99999 then
109: result := 0;
110: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');
111: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);
112: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);
113: end if;
114: END IF;
115: END IF;
116:

Line 205: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');

201: if result = -99999 then
202: fnd_profile.get('WSH_IGNORE_WT_VOL',l_ignore_wtvol);
203: IF NVL(l_ignore_wtvol,'Y') = 'N' THEN
204: x_return_status := wsh_util_core.g_ret_sts_error;
205: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');
206: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);
207: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);
208: WSH_UTIL_CORE.add_message (x_return_status);
209: END IF;

Line 206: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);

202: fnd_profile.get('WSH_IGNORE_WT_VOL',l_ignore_wtvol);
203: IF NVL(l_ignore_wtvol,'Y') = 'N' THEN
204: x_return_status := wsh_util_core.g_ret_sts_error;
205: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');
206: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);
207: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);
208: WSH_UTIL_CORE.add_message (x_return_status);
209: END IF;
210: result := 0;

Line 207: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);

203: IF NVL(l_ignore_wtvol,'Y') = 'N' THEN
204: x_return_status := wsh_util_core.g_ret_sts_error;
205: FND_MESSAGE.SET_NAME('WSH','WSH_UNDEF_UOM_CONVERSION');
206: FND_MESSAGE.SET_TOKEN('FROM_UOM',from_uom);
207: FND_MESSAGE.SET_TOKEN('TO_UOM',to_uom);
208: WSH_UTIL_CORE.add_message (x_return_status);
209: END IF;
210: result := 0;
211: end if;

Line 477: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');

473: l_container_flag,
474: l_wv_frozen_flag,
475: l_line_direction; -- LPN CONV. rv
476: IF get_detail_wv%NOTFOUND THEN
477: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
478: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
479: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
480: CLOSE get_detail_wv;
481: IF l_debug_on THEN

Line 478: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);

474: l_wv_frozen_flag,
475: l_line_direction; -- LPN CONV. rv
476: IF get_detail_wv%NOTFOUND THEN
477: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
478: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
479: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
480: CLOSE get_detail_wv;
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.pop(l_module_name);

Line 542: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');

538: l_item_unit_wt,
539: l_item_unit_vol;
540:
541: IF Item_Net_Wt_Vol%NOTFOUND THEN
542: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
543: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
545: CLOSE Item_Net_Wt_Vol;
546: IF l_debug_on THEN

Line 543: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);

539: l_item_unit_vol;
540:
541: IF Item_Net_Wt_Vol%NOTFOUND THEN
542: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
543: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
545: CLOSE Item_Net_Wt_Vol;
546: IF l_debug_on THEN
547: WSH_DEBUG_SV.pop(l_module_name);

Line 630: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');

626: WHERE delivery_detail_id = p_delivery_detail_id;
627:
628: IF SQL%NOTFOUND THEN
629: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
630: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
631: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
632: IF l_debug_on THEN
633: WSH_DEBUG_SV.pop(l_module_name);
634: END IF;

Line 631: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);

627:
628: IF SQL%NOTFOUND THEN
629: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
630: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
631: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
632: IF l_debug_on THEN
633: WSH_DEBUG_SV.pop(l_module_name);
634: END IF;
635: return;

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

696: EXCEPTION
697:
698: WHEN mark_reprice_error then
699:
700: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
701: x_return_status := l_return_status;
702: WSH_UTIL_CORE.add_message (x_return_status);
703: --
704: -- Debug Statements

Line 1561: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');

1557: END IF;
1558:
1559: EXCEPTION
1560: WHEN e_wt_vol_fail THEN
1561: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
1562: FND_MESSAGE.Set_Token('LPN', p_entity_id);
1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1564: WSH_UTIL_CORE.add_message (x_return_status);
1565: IF l_debug_on THEN

Line 1562: FND_MESSAGE.Set_Token('LPN', p_entity_id);

1558:
1559: EXCEPTION
1560: WHEN e_wt_vol_fail THEN
1561: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
1562: FND_MESSAGE.Set_Token('LPN', p_entity_id);
1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1564: WSH_UTIL_CORE.add_message (x_return_status);
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.logmsg(l_module_name,'E_WT_VOL_FAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1585: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');

1581: WSH_DEBUG_SV.pop(l_module_name);
1582: END IF;
1583:
1584: WHEN lock_detected THEN -- BugFix 3570954
1585: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
1586: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1587: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1588:
1589: IF l_debug_on THEN

Line 2021: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');

2017:
2018: EXCEPTION
2019:
2020: WHEN lock_detected THEN -- BugFix 3570954
2021: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
2022: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2023: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
2024:
2025: IF l_debug_on THEN

Line 2203: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');

2199: WHERE delivery_id = p_delivery_id;
2200:
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN
2203: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
2204: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
2205: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2206: IF l_debug_on THEN
2207: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');

Line 2204: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);

2200:
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN
2203: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
2204: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
2205: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2206: IF l_debug_on THEN
2207: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');
2208: WSH_DEBUG_SV.pop(l_module_name);

Line 2365: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');

2361:
2362: EXCEPTION
2363:
2364: WHEN lock_detected THEN -- BugFix 3570954
2365: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
2366: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2367: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
2368:
2369: WHEN e_abort THEN

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

2372: WSH_DEBUG_SV.pop(l_module_name);
2373: END IF;
2374:
2375: WHEN mark_reprice_error then
2376: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2377: x_return_status := l_return_status;
2378: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2379: --
2380: IF l_debug_on THEN

Line 2475: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');

2471: WHERE delivery_detail_id = p_delivery_detail_id
2472: AND container_flag = 'N';
2473: EXCEPTION
2474: WHEN NO_DATA_FOUND THEN
2475: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2476: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2477: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2478: IF l_debug_on THEN
2479: WSH_DEBUG_SV.logmsg(l_module_name,'DD '||p_delivery_detail_id||' not found');

Line 2476: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);

2472: AND container_flag = 'N';
2473: EXCEPTION
2474: WHEN NO_DATA_FOUND THEN
2475: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2476: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2477: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2478: IF l_debug_on THEN
2479: WSH_DEBUG_SV.logmsg(l_module_name,'DD '||p_delivery_detail_id||' not found');
2480: WSH_DEBUG_SV.pop(l_module_name);

Line 2670: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

2666: END IF;
2667: IF c_get_detail_wv%NOTFOUND THEN
2668: CLOSE c_get_detail_wv;
2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2670: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2671:
2672: IF l_debug_on THEN
2673: WSH_DEBUG_SV.pop(l_module_name);
2674: END IF;

Line 2753: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

2749: WHERE delivery_detail_id = p_container_instance_id;
2750:
2751: IF SQL%NOTFOUND THEN
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2753: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2754:
2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.pop(l_module_name);
2757: END IF;

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

2832: END IF;
2833:
2834: EXCEPTION
2835: WHEN mark_reprice_error then
2836: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2837: x_return_status := l_return_status;
2838: WSH_UTIL_CORE.add_message (x_return_status);
2839: IF l_debug_on THEN
2840: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3123: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');

3119: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
3122: END IF;
3123: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
3124: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
3125: wsh_util_core.get_org_name(childInfo_rec.organization_id));
3126: wsh_util_core.add_message(l_return_status,l_module_name);
3127: raise e_abort;

Line 3124: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',

3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
3122: END IF;
3123: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
3124: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
3125: wsh_util_core.get_org_name(childInfo_rec.organization_id));
3126: wsh_util_core.add_message(l_return_status,l_module_name);
3127: raise e_abort;
3128: END IF;

Line 3197: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');

3193: -- Raise warning if delivery detail has null W/V depending on percent_fill_basis_flag
3194: IF (childInfo_rec.container_flag = 'N') THEN
3195: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_line_grossWeight IS NULL) OR
3196: (l_param_info.percent_fill_basis_flag = 'V' AND l_line_volume IS NULL) THEN
3197: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
3198: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',childInfo_rec.delivery_detail_id);
3199: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
3200: l_num_warnings := l_num_warnings + 1;
3201:

Line 3198: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',childInfo_rec.delivery_detail_id);

3194: IF (childInfo_rec.container_flag = 'N') THEN
3195: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_line_grossWeight IS NULL) OR
3196: (l_param_info.percent_fill_basis_flag = 'V' AND l_line_volume IS NULL) THEN
3197: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
3198: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',childInfo_rec.delivery_detail_id);
3199: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
3200: l_num_warnings := l_num_warnings + 1;
3201:
3202: IF l_debug_on THEN

Line 3311: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');

3307: --
3308: IF SQL%NOTFOUND OR SQL%ROWCOUNT = 0
3309: THEN
3310: --{
3311: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
3312: FND_MESSAGE.SET_TOKEN('DETAIL_ID',childInfo_rec.delivery_detail_id);
3313: RAISE e_invalid_detail;
3314: --}
3315: END IF;

Line 3312: FND_MESSAGE.SET_TOKEN('DETAIL_ID',childInfo_rec.delivery_detail_id);

3308: IF SQL%NOTFOUND OR SQL%ROWCOUNT = 0
3309: THEN
3310: --{
3311: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
3312: FND_MESSAGE.SET_TOKEN('DETAIL_ID',childInfo_rec.delivery_detail_id);
3313: RAISE e_invalid_detail;
3314: --}
3315: END IF;
3316:

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

3482: END IF;
3483: --
3484: EXCEPTION
3485: WHEN mark_reprice_error then
3486: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
3487: x_returnStatus := l_return_status;
3488: WSH_UTIL_CORE.add_message (x_returnStatus);
3489: --
3490: -- Debug Statements

Line 3509: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');

3505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_DETAIL');
3506: END IF;
3507: --
3508: WHEN e_wt_vol_fail THEN
3509: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
3510: FND_MESSAGE.Set_Token('LPN', l_err_container);
3511: x_returnStatus := WSH_UTIL_CORE.G_RET_STS_ERROR;
3512: WSH_UTIL_CORE.add_message (x_returnStatus);
3513: --

Line 3510: FND_MESSAGE.Set_Token('LPN', l_err_container);

3506: END IF;
3507: --
3508: WHEN e_wt_vol_fail THEN
3509: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
3510: FND_MESSAGE.Set_Token('LPN', l_err_container);
3511: x_returnStatus := WSH_UTIL_CORE.G_RET_STS_ERROR;
3512: WSH_UTIL_CORE.add_message (x_returnStatus);
3513: --
3514: -- Debug Statements

Line 3736: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');

3732: WHERE delivery_detail_id = p_container_instance_id
3733: AND container_flag IN ('Y', 'C');
3734: EXCEPTION
3735: WHEN NO_DATA_FOUND THEN
3736: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
3737: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_container_instance_id);
3738: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3739: IF l_debug_on THEN
3740: WSH_DEBUG_SV.pop(l_module_name);

Line 3737: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_container_instance_id);

3733: AND container_flag IN ('Y', 'C');
3734: EXCEPTION
3735: WHEN NO_DATA_FOUND THEN
3736: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
3737: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_container_instance_id);
3738: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3739: IF l_debug_on THEN
3740: WSH_DEBUG_SV.pop(l_module_name);
3741: END IF;

Line 4005: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_ERROR');

4001:
4002: END IF; -- l_flag = 'Y'
4003:
4004: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4005: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_ERROR');
4006: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_rows(i));
4007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4008: wsh_util_core.add_message(x_return_status);
4009: l_num_error := l_num_error + 1;

Line 4006: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_rows(i));

4002: END IF; -- l_flag = 'Y'
4003:
4004: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4005: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_ERROR');
4006: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_rows(i));
4007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4008: wsh_util_core.add_message(x_return_status);
4009: l_num_error := l_num_error + 1;
4010: END IF;

Line 4060: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');

4056: IF (p_detail_rows.count > 1) THEN
4057:
4058: IF (l_num_error > 0) THEN
4059:
4060: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
4061: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
4062: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_detail_rows.count - l_num_error);
4063:
4064: IF (p_detail_rows.count = l_num_error) THEN

Line 4061: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);

4057:
4058: IF (l_num_error > 0) THEN
4059:
4060: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
4061: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
4062: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_detail_rows.count - l_num_error);
4063:
4064: IF (p_detail_rows.count = l_num_error) THEN
4065: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4062: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_detail_rows.count - l_num_error);

4058: IF (l_num_error > 0) THEN
4059:
4060: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
4061: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
4062: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_detail_rows.count - l_num_error);
4063:
4064: IF (p_detail_rows.count = l_num_error) THEN
4065: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4066: ELSE

Line 4217: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

4213: l_organization_id;
4214:
4215: IF Get_Cont_Info%NOTFOUND THEN
4216: CLOSE Get_Cont_Info;
4217: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
4218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4219: --
4220: -- Debug Statements
4221: --

Line 4246: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_UNDEFINED');

4242: OPEN Get_Fill_Basis (l_cont_org_id);
4243: FETCH Get_Fill_Basis INTO l_fill_pc_basis;
4244: IF Get_Fill_Basis%NOTFOUND THEN
4245: CLOSE Get_Fill_Basis;
4246: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_UNDEFINED');
4247: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4248: --
4249: -- Debug Statements
4250: --

Line 4314: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');

4310: END IF;
4311:
4312: IF l_fill_pc_basis = 'W' THEN
4313: IF nvl(l_cont_max_load, 0 ) <= 0 THEN
4314: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4315: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4316: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4317: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4318: END IF;

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

4311:
4312: IF l_fill_pc_basis = 'W' THEN
4313: IF nvl(l_cont_max_load, 0 ) <= 0 THEN
4314: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4315: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4316: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4317: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4318: END IF;
4319: ELSIF l_fill_pc_basis = 'V' THEN

Line 4321: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');

4317: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4318: END IF;
4319: ELSIF l_fill_pc_basis = 'V' THEN
4320: IF nvl(l_cont_max_vol, 0 ) <= 0 THEN
4321: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4322: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4323: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4324: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4325: END IF;

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

4318: END IF;
4319: ELSIF l_fill_pc_basis = 'V' THEN
4320: IF nvl(l_cont_max_vol, 0 ) <= 0 THEN
4321: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4322: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4323: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4324: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4325: END IF;
4326: END IF;

Line 4430: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_FILL_BASIS');

4426: END LOOP;
4427:
4428: ELSE
4429:
4430: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_FILL_BASIS');
4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4432: --
4433: -- Debug Statements
4434: --

Line 4519: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');

4515: WHERE delivery_detail_id = p_container_instance_id;
4516:
4517: IF SQL%NOTFOUND THEN
4518: -- dbms_output.put_line('unexp error while updating fill percent');
4519: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
4520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4521: --
4522: -- Debug Statements
4523: --

Line 4635: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

4631:
4632: FETCH Get_Cont_Info INTO l_cont_item_id, l_cont_wt_uom, l_cont_org_id;
4633:
4634: IF Get_Cont_Info%NOTFOUND THEN
4635: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
4636: CLOSE Get_Cont_Info;
4637: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4638: --
4639: -- Debug Statements

Line 4652: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CONT_OR_ORG');

4648: CLOSE Get_Cont_Info;
4649:
4650: ELSIF p_cont_item_id IS NULL OR p_organization_id IS NULL THEN
4651:
4652: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CONT_OR_ORG');
4653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4654: --
4655: -- Debug Statements
4656: --

Line 4670: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_ITEM');

4666:
4667: FETCH Get_Unit_Weight INTO l_cont_unit_wt, l_wt_uom;
4668:
4669: IF Get_Unit_Weight%NOTFOUND THEN
4670: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_ITEM');
4671: CLOSE Get_Unit_Weight;
4672: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4673: --
4674: -- Debug Statements

Line 4797: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

4793:
4794: IF Get_Cont_Info%NOTFOUND THEN
4795: CLOSE Get_Cont_Info;
4796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4797: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
4798: WSH_UTIL_CORE.Add_Message (x_return_status);
4799: --
4800: -- Debug Statements
4801: --

Line 4830: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');

4826: p_organization_id => l_organization_id,
4827: x_param_info => l_param_info,
4828: x_return_status => x_return_status);
4829: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4830: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
4831: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
4832: wsh_util_core.get_org_name(l_organization_id));
4833: wsh_util_core.add_message(x_return_status,l_module_name);
4834: IF l_debug_on THEN

Line 4831: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',

4827: x_param_info => l_param_info,
4828: x_return_status => x_return_status);
4829: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4830: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
4831: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
4832: wsh_util_core.get_org_name(l_organization_id));
4833: wsh_util_core.add_message(x_return_status,l_module_name);
4834: IF l_debug_on THEN
4835: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||x_return_status);

Line 5116: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');

5112: l_ignore_for_planning, -- OTM R12 : packing ECO
5113: l_tms_interface_flag; -- OTM R12 : packing ECO
5114: IF (del_uoms%NOTFOUND) THEN
5115: CLOSE del_uoms;
5116: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5117: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5118: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5119: IF l_debug_on THEN
5120: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');

Line 5117: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);

5113: l_tms_interface_flag; -- OTM R12 : packing ECO
5114: IF (del_uoms%NOTFOUND) THEN
5115: CLOSE del_uoms;
5116: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5117: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5118: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5119: IF l_debug_on THEN
5120: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');
5121: WSH_DEBUG_SV.pop(l_module_name);

Line 5159: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');

5155: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
5156: IF l_debug_on THEN
5157: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
5158: END IF;
5159: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
5160: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5161: wsh_util_core.get_org_name(l_organization_id));
5162: wsh_util_core.add_message(l_return_status,l_module_name);
5163: raise e_abort;

Line 5160: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',

5156: IF l_debug_on THEN
5157: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
5158: END IF;
5159: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
5160: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5161: wsh_util_core.get_org_name(l_organization_id));
5162: wsh_util_core.add_message(l_return_status,l_module_name);
5163: raise e_abort;
5164: END IF;

Line 5513: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');

5509:
5510: -- Raise warning if delivery detail has null W/V depending on percent_fill_basis_flag
5511: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_net_weight IS NULL) OR
5512: (l_param_info.percent_fill_basis_flag = 'V' AND l_volume IS NULL) THEN
5513: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
5514: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',dt.dd_id);
5515: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
5516: l_num_warnings := l_num_warnings + 1;
5517: END IF;

Line 5514: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',dt.dd_id);

5510: -- Raise warning if delivery detail has null W/V depending on percent_fill_basis_flag
5511: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_net_weight IS NULL) OR
5512: (l_param_info.percent_fill_basis_flag = 'V' AND l_volume IS NULL) THEN
5513: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
5514: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',dt.dd_id);
5515: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
5516: l_num_warnings := l_num_warnings + 1;
5517: END IF;
5518:

Line 5870: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');

5866: WHERE delivery_id = p_delivery_id;
5867:
5868: EXCEPTION
5869: WHEN NO_DATA_FOUND THEN
5870: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5871: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5872: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5873: IF l_debug_on THEN
5874: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery '||p_delivery_id||' not found');

Line 5871: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);

5867:
5868: EXCEPTION
5869: WHEN NO_DATA_FOUND THEN
5870: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5871: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5872: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5873: IF l_debug_on THEN
5874: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery '||p_delivery_id||' not found');
5875: WSH_DEBUG_SV.pop(l_module_name);

Line 6044: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');

6040: x_volume => l_volume,
6041: x_return_status => x_return_status);
6042:
6043: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6044: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6045: IF l_debug_on THEN
6046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6047: END IF;
6048: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

Line 6048: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

6044: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6045: IF l_debug_on THEN
6046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6047: END IF;
6048: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6050: wsh_util_core.add_message(x_return_status);
6051: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6052: l_num_error := l_num_error + 1;

Line 6061: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');

6057: IF (p_del_rows.count > 1) THEN
6058:
6059: IF (l_num_error > 0) THEN
6060:
6061: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
6062: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6063: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count - l_num_error);
6064:
6065: IF (p_del_rows.count = l_num_error) THEN

Line 6062: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);

6058:
6059: IF (l_num_error > 0) THEN
6060:
6061: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
6062: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6063: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count - l_num_error);
6064:
6065: IF (p_del_rows.count = l_num_error) THEN
6066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 6063: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count - l_num_error);

6059: IF (l_num_error > 0) THEN
6060:
6061: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
6062: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6063: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count - l_num_error);
6064:
6065: IF (p_del_rows.count = l_num_error) THEN
6066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6067: ELSE