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 482: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');

478: l_container_flag,
479: l_wv_frozen_flag,
480: l_line_direction; -- LPN CONV. rv
481: IF get_detail_wv%NOTFOUND THEN
482: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
483: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
484: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
485: CLOSE get_detail_wv;
486: IF l_debug_on THEN

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

479: l_wv_frozen_flag,
480: l_line_direction; -- LPN CONV. rv
481: IF get_detail_wv%NOTFOUND THEN
482: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
483: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
484: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
485: CLOSE get_detail_wv;
486: IF l_debug_on THEN
487: WSH_DEBUG_SV.pop(l_module_name);

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

543: l_item_unit_wt,
544: l_item_unit_vol;
545:
546: IF Item_Net_Wt_Vol%NOTFOUND THEN
547: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
548: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
550: CLOSE Item_Net_Wt_Vol;
551: IF l_debug_on THEN

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

544: l_item_unit_vol;
545:
546: IF Item_Net_Wt_Vol%NOTFOUND THEN
547: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
548: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
550: CLOSE Item_Net_Wt_Vol;
551: IF l_debug_on THEN
552: WSH_DEBUG_SV.pop(l_module_name);

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

631: WHERE delivery_detail_id = p_delivery_detail_id;
632:
633: IF SQL%NOTFOUND THEN
634: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
635: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
636: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.pop(l_module_name);
639: END IF;

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

632:
633: IF SQL%NOTFOUND THEN
634: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
635: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
636: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.pop(l_module_name);
639: END IF;
640: return;

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

701: EXCEPTION
702:
703: WHEN mark_reprice_error then
704:
705: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
706: x_return_status := l_return_status;
707: WSH_UTIL_CORE.add_message (x_return_status);
708: --
709: -- Debug Statements

Line 1178: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');

1174: IF l_debug_on THEN
1175: WSH_DEBUG_SV.logmsg(l_module_name,'Error: '||p_entity_type||' Id '||p_entity_id||' could not be locked');
1176: END IF;
1177: --Bug8513181
1178: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
1179: x_return_status := wsh_util_core.g_ret_sts_error;
1180: wsh_util_core.add_message(x_return_status,l_module_name);
1181: IF l_debug_on THEN
1182: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');

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

1570: END IF;
1571:
1572: EXCEPTION
1573: WHEN e_wt_vol_fail THEN
1574: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
1575: FND_MESSAGE.Set_Token('LPN', p_entity_id);
1576: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1577: WSH_UTIL_CORE.add_message (x_return_status);
1578: IF l_debug_on THEN

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

1571:
1572: EXCEPTION
1573: WHEN e_wt_vol_fail THEN
1574: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
1575: FND_MESSAGE.Set_Token('LPN', p_entity_id);
1576: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1577: WSH_UTIL_CORE.add_message (x_return_status);
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name,'E_WT_VOL_FAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1594: WSH_DEBUG_SV.pop(l_module_name);
1595: END IF;
1596:
1597: WHEN lock_detected THEN -- BugFix 3570954
1598: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
1599: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1600: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1601:
1602: IF l_debug_on THEN

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

2030:
2031: EXCEPTION
2032:
2033: WHEN lock_detected THEN -- BugFix 3570954
2034: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
2035: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2036: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
2037:
2038: IF l_debug_on THEN

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

2212: WHERE delivery_id = p_delivery_id;
2213:
2214: EXCEPTION
2215: WHEN NO_DATA_FOUND THEN
2216: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
2217: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
2218: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');

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

2213:
2214: EXCEPTION
2215: WHEN NO_DATA_FOUND THEN
2216: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
2217: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
2218: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');
2221: WSH_DEBUG_SV.pop(l_module_name);

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

2374:
2375: EXCEPTION
2376:
2377: WHEN lock_detected THEN -- BugFix 3570954
2378: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
2379: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2380: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
2381:
2382: WHEN e_abort THEN

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

2385: WSH_DEBUG_SV.pop(l_module_name);
2386: END IF;
2387:
2388: WHEN mark_reprice_error then
2389: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2390: x_return_status := l_return_status;
2391: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2392: --
2393: IF l_debug_on THEN

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

2484: WHERE delivery_detail_id = p_delivery_detail_id
2485: AND container_flag = 'N';
2486: EXCEPTION
2487: WHEN NO_DATA_FOUND THEN
2488: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2489: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2491: IF l_debug_on THEN
2492: WSH_DEBUG_SV.logmsg(l_module_name,'DD '||p_delivery_detail_id||' not found');

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

2485: AND container_flag = 'N';
2486: EXCEPTION
2487: WHEN NO_DATA_FOUND THEN
2488: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2489: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2491: IF l_debug_on THEN
2492: WSH_DEBUG_SV.logmsg(l_module_name,'DD '||p_delivery_detail_id||' not found');
2493: WSH_DEBUG_SV.pop(l_module_name);

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

2679: END IF;
2680: IF c_get_detail_wv%NOTFOUND THEN
2681: CLOSE c_get_detail_wv;
2682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2683: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2684:
2685: IF l_debug_on THEN
2686: WSH_DEBUG_SV.pop(l_module_name);
2687: END IF;

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

2762: WHERE delivery_detail_id = p_container_instance_id;
2763:
2764: IF SQL%NOTFOUND THEN
2765: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2766: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2767:
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.pop(l_module_name);
2770: END IF;

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

2845: END IF;
2846:
2847: EXCEPTION
2848: WHEN mark_reprice_error then
2849: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2850: x_return_status := l_return_status;
2851: WSH_UTIL_CORE.add_message (x_return_status);
2852: IF l_debug_on THEN
2853: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

3132: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3133: IF l_debug_on THEN
3134: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
3135: END IF;
3136: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
3137: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
3138: wsh_util_core.get_org_name(childInfo_rec.organization_id));
3139: wsh_util_core.add_message(l_return_status,l_module_name);
3140: raise e_abort;

Line 3137: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',

3133: IF l_debug_on THEN
3134: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
3135: END IF;
3136: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
3137: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
3138: wsh_util_core.get_org_name(childInfo_rec.organization_id));
3139: wsh_util_core.add_message(l_return_status,l_module_name);
3140: raise e_abort;
3141: END IF;

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

3206: -- Raise warning if delivery detail has null W/V depending on percent_fill_basis_flag
3207: IF (childInfo_rec.container_flag = 'N') THEN
3208: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_line_grossWeight IS NULL) OR
3209: (l_param_info.percent_fill_basis_flag = 'V' AND l_line_volume IS NULL) THEN
3210: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
3211: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',childInfo_rec.delivery_detail_id);
3212: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
3213: l_num_warnings := l_num_warnings + 1;
3214:

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

3207: IF (childInfo_rec.container_flag = 'N') THEN
3208: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_line_grossWeight IS NULL) OR
3209: (l_param_info.percent_fill_basis_flag = 'V' AND l_line_volume IS NULL) THEN
3210: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
3211: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',childInfo_rec.delivery_detail_id);
3212: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
3213: l_num_warnings := l_num_warnings + 1;
3214:
3215: IF l_debug_on THEN

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

3320: --
3321: IF SQL%NOTFOUND OR SQL%ROWCOUNT = 0
3322: THEN
3323: --{
3324: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('DETAIL_ID',childInfo_rec.delivery_detail_id);
3326: RAISE e_invalid_detail;
3327: --}
3328: END IF;

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

3321: IF SQL%NOTFOUND OR SQL%ROWCOUNT = 0
3322: THEN
3323: --{
3324: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('DETAIL_ID',childInfo_rec.delivery_detail_id);
3326: RAISE e_invalid_detail;
3327: --}
3328: END IF;
3329:

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

3495: END IF;
3496: --
3497: EXCEPTION
3498: WHEN mark_reprice_error then
3499: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
3500: x_returnStatus := l_return_status;
3501: WSH_UTIL_CORE.add_message (x_returnStatus);
3502: --
3503: -- Debug Statements

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

3518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_DETAIL');
3519: END IF;
3520: --
3521: WHEN e_wt_vol_fail THEN
3522: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
3523: FND_MESSAGE.Set_Token('LPN', l_err_container);
3524: x_returnStatus := WSH_UTIL_CORE.G_RET_STS_ERROR;
3525: WSH_UTIL_CORE.add_message (x_returnStatus);
3526: --

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

3519: END IF;
3520: --
3521: WHEN e_wt_vol_fail THEN
3522: FND_MESSAGE.Set_Name('WSH','WSH_UPDATE_WTVOL_FAIL');
3523: FND_MESSAGE.Set_Token('LPN', l_err_container);
3524: x_returnStatus := WSH_UTIL_CORE.G_RET_STS_ERROR;
3525: WSH_UTIL_CORE.add_message (x_returnStatus);
3526: --
3527: -- Debug Statements

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

3745: WHERE delivery_detail_id = p_container_instance_id
3746: AND container_flag IN ('Y', 'C');
3747: EXCEPTION
3748: WHEN NO_DATA_FOUND THEN
3749: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
3750: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_container_instance_id);
3751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3752: IF l_debug_on THEN
3753: WSH_DEBUG_SV.pop(l_module_name);

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

3746: AND container_flag IN ('Y', 'C');
3747: EXCEPTION
3748: WHEN NO_DATA_FOUND THEN
3749: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
3750: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_container_instance_id);
3751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3752: IF l_debug_on THEN
3753: WSH_DEBUG_SV.pop(l_module_name);
3754: END IF;

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

4014:
4015: END IF; -- l_flag = 'Y'
4016:
4017: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4018: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_ERROR');
4019: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_rows(i));
4020: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4021: wsh_util_core.add_message(x_return_status);
4022: l_num_error := l_num_error + 1;

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

4015: END IF; -- l_flag = 'Y'
4016:
4017: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4018: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_ERROR');
4019: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_rows(i));
4020: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4021: wsh_util_core.add_message(x_return_status);
4022: l_num_error := l_num_error + 1;
4023: END IF;

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

4069: IF (p_detail_rows.count > 1) THEN
4070:
4071: IF (l_num_error > 0) THEN
4072:
4073: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
4074: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
4075: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_detail_rows.count - l_num_error);
4076:
4077: IF (p_detail_rows.count = l_num_error) THEN

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

4070:
4071: IF (l_num_error > 0) THEN
4072:
4073: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
4074: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
4075: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_detail_rows.count - l_num_error);
4076:
4077: IF (p_detail_rows.count = l_num_error) THEN
4078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

4071: IF (l_num_error > 0) THEN
4072:
4073: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
4074: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
4075: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_detail_rows.count - l_num_error);
4076:
4077: IF (p_detail_rows.count = l_num_error) THEN
4078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4079: ELSE

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

4226: l_organization_id;
4227:
4228: IF Get_Cont_Info%NOTFOUND THEN
4229: CLOSE Get_Cont_Info;
4230: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
4231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4232: --
4233: -- Debug Statements
4234: --

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

4255: OPEN Get_Fill_Basis (l_cont_org_id);
4256: FETCH Get_Fill_Basis INTO l_fill_pc_basis;
4257: IF Get_Fill_Basis%NOTFOUND THEN
4258: CLOSE Get_Fill_Basis;
4259: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_UNDEFINED');
4260: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4261: --
4262: -- Debug Statements
4263: --

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

4323: END IF;
4324:
4325: IF l_fill_pc_basis = 'W' THEN
4326: IF nvl(l_cont_max_load, 0 ) <= 0 THEN
4327: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4328: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4329: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4330: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4331: END IF;

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

4324:
4325: IF l_fill_pc_basis = 'W' THEN
4326: IF nvl(l_cont_max_load, 0 ) <= 0 THEN
4327: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4328: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4329: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4330: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4331: END IF;
4332: ELSIF l_fill_pc_basis = 'V' THEN

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

4330: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4331: END IF;
4332: ELSIF l_fill_pc_basis = 'V' THEN
4333: IF nvl(l_cont_max_vol, 0 ) <= 0 THEN
4334: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4335: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4336: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4337: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4338: END IF;

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

4331: END IF;
4332: ELSIF l_fill_pc_basis = 'V' THEN
4333: IF nvl(l_cont_max_vol, 0 ) <= 0 THEN
4334: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_FILL_PC_ERROR');
4335: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4336: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
4337: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4338: END IF;
4339: END IF;

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

4439: END LOOP;
4440:
4441: ELSE
4442:
4443: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_FILL_BASIS');
4444: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4445: --
4446: -- Debug Statements
4447: --

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

4528: WHERE delivery_detail_id = p_container_instance_id;
4529:
4530: IF SQL%NOTFOUND THEN
4531: -- dbms_output.put_line('unexp error while updating fill percent');
4532: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
4533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4534: --
4535: -- Debug Statements
4536: --

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

4644:
4645: FETCH Get_Cont_Info INTO l_cont_item_id, l_cont_wt_uom, l_cont_org_id;
4646:
4647: IF Get_Cont_Info%NOTFOUND THEN
4648: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
4649: CLOSE Get_Cont_Info;
4650: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4651: --
4652: -- Debug Statements

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

4661: CLOSE Get_Cont_Info;
4662:
4663: ELSIF p_cont_item_id IS NULL OR p_organization_id IS NULL THEN
4664:
4665: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CONT_OR_ORG');
4666: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4667: --
4668: -- Debug Statements
4669: --

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

4679:
4680: FETCH Get_Unit_Weight INTO l_cont_unit_wt, l_wt_uom;
4681:
4682: IF Get_Unit_Weight%NOTFOUND THEN
4683: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_ITEM');
4684: CLOSE Get_Unit_Weight;
4685: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4686: --
4687: -- Debug Statements

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

4806:
4807: IF Get_Cont_Info%NOTFOUND THEN
4808: CLOSE Get_Cont_Info;
4809: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4810: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
4811: WSH_UTIL_CORE.Add_Message (x_return_status);
4812: --
4813: -- Debug Statements
4814: --

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

4839: p_organization_id => l_organization_id,
4840: x_param_info => l_param_info,
4841: x_return_status => x_return_status);
4842: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4843: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
4844: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
4845: wsh_util_core.get_org_name(l_organization_id));
4846: wsh_util_core.add_message(x_return_status,l_module_name);
4847: IF l_debug_on THEN

Line 4844: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',

4840: x_param_info => l_param_info,
4841: x_return_status => x_return_status);
4842: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4843: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
4844: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
4845: wsh_util_core.get_org_name(l_organization_id));
4846: wsh_util_core.add_message(x_return_status,l_module_name);
4847: IF l_debug_on THEN
4848: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||x_return_status);

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

5125: l_ignore_for_planning, -- OTM R12 : packing ECO
5126: l_tms_interface_flag; -- OTM R12 : packing ECO
5127: IF (del_uoms%NOTFOUND) THEN
5128: CLOSE del_uoms;
5129: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5130: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5131: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5132: IF l_debug_on THEN
5133: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');

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

5126: l_tms_interface_flag; -- OTM R12 : packing ECO
5127: IF (del_uoms%NOTFOUND) THEN
5128: CLOSE del_uoms;
5129: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5130: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5131: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5132: IF l_debug_on THEN
5133: WSH_DEBUG_SV.log(l_module_name,'Delivery '||p_delivery_id||' not found');
5134: WSH_DEBUG_SV.pop(l_module_name);

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

5168: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
5169: IF l_debug_on THEN
5170: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
5171: END IF;
5172: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
5173: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5174: wsh_util_core.get_org_name(l_organization_id));
5175: wsh_util_core.add_message(l_return_status,l_module_name);
5176: raise e_abort;

Line 5173: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',

5169: IF l_debug_on THEN
5170: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
5171: END IF;
5172: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
5173: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5174: wsh_util_core.get_org_name(l_organization_id));
5175: wsh_util_core.add_message(l_return_status,l_module_name);
5176: raise e_abort;
5177: END IF;

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

5522:
5523: -- Raise warning if delivery detail has null W/V depending on percent_fill_basis_flag
5524: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_net_weight IS NULL) OR
5525: (l_param_info.percent_fill_basis_flag = 'V' AND l_volume IS NULL) THEN
5526: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
5527: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',dt.dd_id);
5528: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
5529: l_num_warnings := l_num_warnings + 1;
5530: END IF;

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

5523: -- Raise warning if delivery detail has null W/V depending on percent_fill_basis_flag
5524: IF (l_param_info.percent_fill_basis_flag = 'W' AND l_net_weight IS NULL) OR
5525: (l_param_info.percent_fill_basis_flag = 'V' AND l_volume IS NULL) THEN
5526: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WEIGHT_VOLUME');
5527: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',dt.dd_id);
5528: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
5529: l_num_warnings := l_num_warnings + 1;
5530: END IF;
5531:

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

5879: WHERE delivery_id = p_delivery_id;
5880:
5881: EXCEPTION
5882: WHEN NO_DATA_FOUND THEN
5883: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5884: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5885: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery '||p_delivery_id||' not found');

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

5880:
5881: EXCEPTION
5882: WHEN NO_DATA_FOUND THEN
5883: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DELIVERY');
5884: FND_MESSAGE.SET_TOKEN('DELIVERY',p_delivery_id);
5885: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery '||p_delivery_id||' not found');
5888: WSH_DEBUG_SV.pop(l_module_name);

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

6053: x_volume => l_volume,
6054: x_return_status => x_return_status);
6055:
6056: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6057: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6058: IF l_debug_on THEN
6059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6060: END IF;
6061: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

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

6057: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6058: IF l_debug_on THEN
6059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6060: END IF;
6061: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6062: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6063: wsh_util_core.add_message(x_return_status);
6064: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6065: l_num_error := l_num_error + 1;

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

6070: IF (p_del_rows.count > 1) THEN
6071:
6072: IF (l_num_error > 0) THEN
6073:
6074: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
6075: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6076: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count - l_num_error);
6077:
6078: IF (p_del_rows.count = l_num_error) THEN

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

6071:
6072: IF (l_num_error > 0) THEN
6073:
6074: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
6075: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6076: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count - l_num_error);
6077:
6078: IF (p_del_rows.count = l_num_error) THEN
6079: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

6072: IF (l_num_error > 0) THEN
6073:
6074: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_SUMMARY');
6075: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6076: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count - l_num_error);
6077:
6078: IF (p_del_rows.count = l_num_error) THEN
6079: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6080: ELSE