DBA Data[Home] [Help]

APPS.WSH_ITM_PARAMETER_SETUPS_PKG dependencies on FND_MESSAGE

Line 82: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');

78: p_api_version ,
79: l_api_name ,
80: G_PKG_NAME )
81: THEN
82: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 122: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');

118: FND_GLOBAL.login_id
119: );
120:
121: IF SQL%NOTFOUND THEN
122: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: RAISE FND_API.G_EXC_ERROR ;
126: END IF;

Line 174: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');

170: where T.PARAMETER_ID = l_PARAMETER_ID
171: and T.LANGUAGE = L.LANGUAGE_CODE);
172:
173: IF SQL%NOTFOUND THEN
174: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
175: FND_MSG_PUB.ADD;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: RAISE FND_API.G_EXC_ERROR ;
178: END IF;

Line 318: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');

314: p_api_version ,
315: l_api_name ,
316: G_PKG_NAME )
317: THEN
318: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
319: FND_MSG_PUB.ADD;
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:

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

333: open c;
334: fetch c into recinfo;
335: if (c%notfound) then
336: close c;
337: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
338: app_exception.raise_exception;
339: end if;
340:
341: close c;

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

347: OR ((recinfo.DEFAULT_VALUE is null) AND (p_DEFAULT_VALUE is null)))
348: AND (recinfo.USER_SETTABLE = p_USER_SETTABLE)) THEN
349: RETURN;
350: ELSE
351: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
352: app_exception.raise_exception;
353: END IF;
354:
355: for tlinfo in c1 loop

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

359: AND ((tlinfo.DESCRIPTION = p_DESCRIPTION) OR
360: ((tlinfo.DESCRIPTION is null) AND (p_DESCRIPTION is null)))) then
361: RETURN;
362: ELSE
363: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
364: app_exception.raise_exception;
365: END IF;
366: END IF;
367: end loop;

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

377: WHEN others THEN
378: if (c%ISOPEN) then
379: close c;
380: end if;
381: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
382: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_PARAMETER_SETUPS_PKG.LOCK_ROW');
383: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
384: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
385:

Line 382: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_PARAMETER_SETUPS_PKG.LOCK_ROW');

378: if (c%ISOPEN) then
379: close c;
380: end if;
381: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
382: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_PARAMETER_SETUPS_PKG.LOCK_ROW');
383: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
384: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
385:
386: RAISE;

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

379: close c;
380: end if;
381: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
382: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_PARAMETER_SETUPS_PKG.LOCK_ROW');
383: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
384: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
385:
386: RAISE;
387:

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

380: end if;
381: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
382: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_PARAMETER_SETUPS_PKG.LOCK_ROW');
383: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
384: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
385:
386: RAISE;
387:
388: end LOCK_ROW;

Line 467: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');

463: p_api_version ,
464: l_api_name ,
465: G_PKG_NAME )
466: THEN
467: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
468: FND_MSG_PUB.ADD;
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;
471: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 492: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');

488: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
489: where PARAMETER_ID = P_PARAMETER_ID;
490:
491: IF SQL%NOTFOUND THEN
492: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
493: FND_MSG_PUB.ADD;
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: RAISE FND_API.G_EXC_ERROR ;
496: END IF;

Line 520: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');

516: where PARAMETER_ID = P_PARAMETER_ID
517: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
518:
519: IF SQL%NOTFOUND THEN
520: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
521: FND_MSG_PUB.ADD;
522: x_return_status := FND_API.G_RET_STS_ERROR;
523: RAISE FND_API.G_EXC_ERROR ;
524: END IF;

Line 641: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');

637: p_api_version ,
638: l_api_name ,
639: G_PKG_NAME )
640: THEN
641: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
642: FND_MSG_PUB.ADD;
643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 660: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');

656: delete from WSH_ITM_PARAMETER_SETUPS_TL
657: where PARAMETER_ID = P_PARAMETER_ID;
658:
659: IF SQL%NOTFOUND THEN
660: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
661: FND_MSG_PUB.ADD;
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: RAISE FND_API.G_EXC_ERROR ;
664: END IF;

Line 684: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');

680: delete from WSH_ITM_PARAMETER_SETUPS_B
681: where PARAMETER_ID = p_PARAMETER_ID;
682:
683: IF SQL%NOTFOUND THEN
684: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
685: FND_MSG_PUB.ADD;
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: RAISE FND_API.G_EXC_ERROR ;
688: END IF;