DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on FND_MESSAGE

Line 90: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');

86: FETCH Get_Exist_Cont INTO l_cont_cnt;
87: CLOSE Get_Exist_Cont;
88: IF l_cont_cnt = 1 THEN
89: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');
91: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_container_name);
92: WSH_UTIL_CORE.Add_Message(x_return_status);
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.pop(l_module_name);

Line 91: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_container_name);

87: CLOSE Get_Exist_Cont;
88: IF l_cont_cnt = 1 THEN
89: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');
91: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_container_name);
92: WSH_UTIL_CORE.Add_Message(x_return_status);
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.pop(l_module_name);
95: END IF;

Line 2144: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

2140: OPEN C_LOCK_DELIVERY_DETAIL;
2141: FETCH C_LOCK_DELIVERY_DETAIL INTO recinfo;
2142: IF (C_LOCK_DELIVERY_DETAIL%NOTFOUND) THEN
2143: CLOSE C_LOCK_DELIVERY_DETAIL;
2144: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2145: IF l_debug_on THEN
2146: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
2147: END IF;
2148: app_exception.raise_exception;

Line 3085: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

3081: END IF;
3082: --
3083: RETURN;
3084: ELSE
3085: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3086: app_exception.raise_exception;
3087: END IF;
3088:
3089: --

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

3117: if (c_lock_delivery_detail%ISOPEN) then
3118: close c_lock_delivery_detail;
3119: end if;
3120:
3121: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3122: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3123: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3124: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3125:

Line 3122: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');

3118: close c_lock_delivery_detail;
3119: end if;
3120:
3121: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3122: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3123: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3124: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3125:
3126: --

Line 3123: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);

3119: end if;
3120:
3121: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3122: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3123: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3124: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3125:
3126: --
3127: IF l_debug_on THEN

Line 3124: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);

3120:
3121: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3122: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3123: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3124: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3125:
3126: --
3127: IF l_debug_on THEN
3128: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4228: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');

4224: END IF;
4225: --
4226: WHEN e_wt_vol_fail THEN
4227: ROLLBACK TO s_before_update_dd;
4228: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
4229: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_details_info.delivery_detail_id);
4230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4231: WSH_UTIL_CORE.add_message (x_return_status);
4232:

Line 4229: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_details_info.delivery_detail_id);

4225: --
4226: WHEN e_wt_vol_fail THEN
4227: ROLLBACK TO s_before_update_dd;
4228: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
4229: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_details_info.delivery_detail_id);
4230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4231: WSH_UTIL_CORE.add_message (x_return_status);
4232:
4233: IF (get_dd_info%ISOPEN) THEN

Line 4617: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

4613: FETCH lock_row INTO Recinfo;
4614: IF (lock_row%NOTFOUND) THEN
4615: CLOSE lock_row;
4616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4617: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
4618: wsh_util_core.add_message(x_return_status,l_module_name);
4619: --
4620: IF l_debug_on THEN
4621: WSH_DEBUG_SV.pop(l_module_name);

Line 4659: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

4655: --
4656: RETURN;
4657: ELSE
4658: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4659: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
4660: IF l_debug_on THEN
4661: WSH_DEBUG_SV.log(l_module_name,'FORM RECORD CHANGED');
4662: END IF;
4663: app_exception.raise_exception;

Line 4747: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');

4743: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4744: rollback to lock_delivery_detail_loop;
4745: IF nvl(p_caller,'!') = 'WSH_PUB'
4746: OR nvl(p_caller, '!') like 'FTE%' THEN
4747: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
4748: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).delivery_detail_id);
4749: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4750: END IF;
4751: l_num_errors := l_num_errors + 1;

Line 4748: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).delivery_detail_id);

4744: rollback to lock_delivery_detail_loop;
4745: IF nvl(p_caller,'!') = 'WSH_PUB'
4746: OR nvl(p_caller, '!') like 'FTE%' THEN
4747: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
4748: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).delivery_detail_id);
4749: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4750: END IF;
4751: l_num_errors := l_num_errors + 1;
4752: --

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

4765: --
4766: IF p_valid_index_tab.COUNT = 0 THEN
4767: x_return_status := wsh_util_core.g_ret_sts_success;
4768: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
4769: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
4770: x_return_status := wsh_util_core.g_ret_sts_error;
4771: wsh_util_core.add_message(x_return_status,l_module_name);
4772: IF l_debug_on THEN
4773: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');

Line 4777: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');

4773: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
4774: END IF;
4775: raise fnd_api.g_exc_error;
4776: ELSIF l_num_errors > 0 THEN
4777: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
4778: x_return_status := wsh_util_core.g_ret_sts_warning;
4779: wsh_util_core.add_message(x_return_status,l_module_name);
4780: IF l_debug_on THEN
4781: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');

Line 4908: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');

4904: EXCEPTION
4905: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4906: IF p_delivery_id IS NOT NULL THEN
4907: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
4908: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
4909: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
4910: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4911: IF l_debug_on THEN
4912: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);

Line 4909: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);

4905: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4906: IF p_delivery_id IS NOT NULL THEN
4907: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
4908: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
4909: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
4910: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4911: IF l_debug_on THEN
4912: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);
4913: END IF;

Line 5267: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');

5263: EXCEPTION
5264: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5265: IF p_delivery_id IS NOT NULL THEN
5266: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5267: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5268: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5269: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5270: IF l_debug_on THEN
5271: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);

Line 5268: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);

5264: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5265: IF p_delivery_id IS NOT NULL THEN
5266: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5267: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5268: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5269: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5270: IF l_debug_on THEN
5271: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);
5272: END IF;