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 2279: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

2275: OPEN C_LOCK_DELIVERY_DETAIL;
2276: FETCH C_LOCK_DELIVERY_DETAIL INTO recinfo;
2277: IF (C_LOCK_DELIVERY_DETAIL%NOTFOUND) THEN
2278: CLOSE C_LOCK_DELIVERY_DETAIL;
2279: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2280: IF l_debug_on THEN
2281: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
2282: END IF;
2283: app_exception.raise_exception;

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

3216: END IF;
3217: --
3218: RETURN;
3219: ELSE
3220: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3221: app_exception.raise_exception;
3222: END IF;
3223:
3224: --

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

3252: if (c_lock_delivery_detail%ISOPEN) then
3253: close c_lock_delivery_detail;
3254: end if;
3255:
3256: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3257: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3258: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3259: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3260:

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

3253: close c_lock_delivery_detail;
3254: end if;
3255:
3256: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3257: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3258: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3259: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3260:
3261: --

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

3254: end if;
3255:
3256: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3257: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3258: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3259: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3260:
3261: --
3262: IF l_debug_on THEN

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

3255:
3256: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3257: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3258: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3259: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3260:
3261: --
3262: IF l_debug_on THEN
3263: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

4359: END IF;
4360: --
4361: WHEN e_wt_vol_fail THEN
4362: ROLLBACK TO s_before_update_dd;
4363: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
4364: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_details_info.delivery_detail_id);
4365: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4366: WSH_UTIL_CORE.add_message (x_return_status);
4367:

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

4360: --
4361: WHEN e_wt_vol_fail THEN
4362: ROLLBACK TO s_before_update_dd;
4363: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
4364: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_details_info.delivery_detail_id);
4365: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4366: WSH_UTIL_CORE.add_message (x_return_status);
4367:
4368: IF (get_dd_info%ISOPEN) THEN

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

4748: FETCH lock_row INTO Recinfo;
4749: IF (lock_row%NOTFOUND) THEN
4750: CLOSE lock_row;
4751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4752: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
4753: wsh_util_core.add_message(x_return_status,l_module_name);
4754: --
4755: IF l_debug_on THEN
4756: WSH_DEBUG_SV.pop(l_module_name);

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

4790: --
4791: RETURN;
4792: ELSE
4793: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4794: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.log(l_module_name,'FORM RECORD CHANGED');
4797: END IF;
4798: app_exception.raise_exception;

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

4878: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4879: rollback to lock_delivery_detail_loop;
4880: IF nvl(p_caller,'!') = 'WSH_PUB'
4881: OR nvl(p_caller, '!') like 'FTE%' THEN
4882: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
4883: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).delivery_detail_id);
4884: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4885: END IF;
4886: l_num_errors := l_num_errors + 1;

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

4879: rollback to lock_delivery_detail_loop;
4880: IF nvl(p_caller,'!') = 'WSH_PUB'
4881: OR nvl(p_caller, '!') like 'FTE%' THEN
4882: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
4883: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).delivery_detail_id);
4884: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4885: END IF;
4886: l_num_errors := l_num_errors + 1;
4887: --

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

4900: --
4901: IF p_valid_index_tab.COUNT = 0 THEN
4902: x_return_status := wsh_util_core.g_ret_sts_success;
4903: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
4904: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
4905: x_return_status := wsh_util_core.g_ret_sts_error;
4906: wsh_util_core.add_message(x_return_status,l_module_name);
4907: IF l_debug_on THEN
4908: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');

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

4908: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
4909: END IF;
4910: raise fnd_api.g_exc_error;
4911: ELSIF l_num_errors > 0 THEN
4912: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
4913: x_return_status := wsh_util_core.g_ret_sts_warning;
4914: wsh_util_core.add_message(x_return_status,l_module_name);
4915: IF l_debug_on THEN
4916: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');

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

5039: EXCEPTION
5040: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5041: IF p_delivery_id IS NOT NULL THEN
5042: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5043: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5044: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5045: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5046: IF l_debug_on THEN
5047: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);

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

5040: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5041: IF p_delivery_id IS NOT NULL THEN
5042: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5043: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5044: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5045: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5046: IF l_debug_on THEN
5047: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);
5048: END IF;

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

5415: EXCEPTION
5416: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5417: IF p_delivery_id IS NOT NULL THEN
5418: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5419: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5420: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5421: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5422: IF l_debug_on THEN
5423: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);

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

5416: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5417: IF p_delivery_id IS NOT NULL THEN
5418: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5419: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5420: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5421: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5422: IF l_debug_on THEN
5423: wsh_debug_sv.log(l_module_name, 'Could not obtain lock on some lines or lpns of delivery', p_delivery_id);
5424: END IF;