DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_RULES_PVT dependencies on FND_MESSAGE

Line 96: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');

92: IF c_dup_name%ISOPEN THEN
93: CLOSE c_dup_name;
94: END IF;
95: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
96: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
97: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
98:
99:
100: WHEN others THEN

Line 172: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');

168: IF c_dup_name%ISOPEN THEN
169: CLOSE c_dup_name;
170: END IF;
171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
172: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
174:
175:
176: WHEN others THEN

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

236: OPEN C_Lock_Row;
237: FETCH C_Lock_Row INTO recinfo;
238: IF C_Lock_Row%NOTFOUND THEN
239: CLOSE C_Lock_Row;
240: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
241: IF l_debug_on THEN
242:
243: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
244:

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

321: END IF;
322: --
323: RETURN;
324: ELSE
325: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
326: app_exception.raise_exception;
327: END IF;
328: --
329: IF l_debug_on THEN

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

353: if (c_lock_row%ISOPEN) then
354: close c_lock_row;
355: end if;
356:
357: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
358: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_SHIP_CONFRIM_RULES_PVT.LOCK_ROW');
359: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
360: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
361:

Line 358: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_SHIP_CONFRIM_RULES_PVT.LOCK_ROW');

354: close c_lock_row;
355: end if;
356:
357: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
358: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_SHIP_CONFRIM_RULES_PVT.LOCK_ROW');
359: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
360: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
361:
362: --

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

355: end if;
356:
357: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
358: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_SHIP_CONFRIM_RULES_PVT.LOCK_ROW');
359: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
360: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
361:
362: --
363: IF l_debug_on THEN

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

356:
357: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
358: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_SHIP_CONFRIM_RULES_PVT.LOCK_ROW');
359: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
360: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
361:
362: --
363: IF l_debug_on THEN
364: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);