[Home] [Help]
79: p_api_version ,
80: l_api_name ,
81: G_PKG_NAME )
82: THEN
83: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
84: FND_MSG_PUB.ADD;
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.
119: FND_GLOBAL.login_id
120: );
121:
122: IF SQL%NOTFOUND THEN
123: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
124: FND_MSG_PUB.ADD;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: RAISE FND_API.G_EXC_ERROR ;
127: END IF;
171: where T.PARAMETER_ID = l_PARAMETER_ID
172: and T.LANGUAGE = L.LANGUAGE_CODE);
173:
174: IF SQL%NOTFOUND THEN
175: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
176: FND_MSG_PUB.ADD;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: RAISE FND_API.G_EXC_ERROR ;
179: END IF;
318: p_api_version ,
319: l_api_name ,
320: G_PKG_NAME )
321: THEN
322: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326: -- Initialize message list if p_init_msg_list is set to TRUE.
335: open c;
336: fetch c into recinfo;
337: if (c%notfound) then
338: close c;
339: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
340: app_exception.raise_exception;
341: end if;
342: close c;
343: if ( ((recinfo.PARAMETER_NAME = p_PARAMETER_NAME)
351: ) then
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: else
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
356: app_exception.raise_exception;
357: end if;
358:
359: for tlinfo in c1 loop
365: ) then
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367: else
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
370: app_exception.raise_exception;
371: end if;
372: end if;
373: end loop;
457: p_api_version ,
458: l_api_name ,
459: G_PKG_NAME )
460: THEN
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: -- Initialize message list if p_init_msg_list is set to TRUE.
482: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
483: where PARAMETER_ID = P_PARAMETER_ID;
484:
485: IF SQL%NOTFOUND THEN
486: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
487: FND_MSG_PUB.ADD;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: RAISE FND_API.G_EXC_ERROR ;
490: END IF;
510: where PARAMETER_ID = P_PARAMETER_ID
511: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
512:
513: IF SQL%NOTFOUND THEN
514: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
515: FND_MSG_PUB.ADD;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: RAISE FND_API.G_EXC_ERROR ;
518: END IF;
631: p_api_version ,
632: l_api_name ,
633: G_PKG_NAME )
634: THEN
635: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
636: FND_MSG_PUB.ADD;
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639: -- Initialize message list if p_init_msg_list is set to TRUE.
650: delete from WSH_CC_PARAMETER_SETUPS_TL
651: where PARAMETER_ID = P_PARAMETER_ID;
652:
653: IF SQL%NOTFOUND THEN
654: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
655: FND_MSG_PUB.ADD;
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: RAISE FND_API.G_EXC_ERROR ;
658: END IF;
674: delete from WSH_CC_PARAMETER_SETUPS_B
675: where PARAMETER_ID = p_PARAMETER_ID;
676:
677: IF SQL%NOTFOUND THEN
678: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
679: FND_MSG_PUB.ADD;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: RAISE FND_API.G_EXC_ERROR ;
682: END IF;