DBA Data[Home] [Help]

APPS.WSH_REGIONS_SEARCH_PKG dependencies on FND_MESSAGE

Line 1688: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');

1684: ELSIF l_dev_status <> 'NORMAL' THEN
1685: l_errors := l_errors + 1;
1686: END IF;
1687:
1688: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
1689: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
1690: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1691: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
1692: j := l_child_req_ids.NEXT(j);

Line 1689: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));

1685: l_errors := l_errors + 1;
1686: END IF;
1687:
1688: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
1689: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
1690: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1691: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
1692: j := l_child_req_ids.NEXT(j);
1693: END LOOP;

Line 1690: FND_MESSAGE.SET_TOKEN('STATUS', l_status);

1686: END IF;
1687:
1688: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
1689: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
1690: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1691: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
1692: j := l_child_req_ids.NEXT(j);
1693: END LOOP;
1694:

Line 1691: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);

1687:
1688: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
1689: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
1690: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1691: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
1692: j := l_child_req_ids.NEXT(j);
1693: END LOOP;
1694:
1695: IF l_errors = 0 AND l_warnings = 0 THEN

Line 3333: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');

3329: -- Exception Handling part
3330: EXCEPTION
3331: WHEN OTHERS THEN
3332: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3333: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3334: fnd_message.set_token('MSG_TEXT', SQLERRM);
3335: IF l_debug_on THEN
3336: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO EXCEPTION : ' || sqlerrm);
3337: WSH_DEBUG_SV.pop(l_module_name);

Line 3334: fnd_message.set_token('MSG_TEXT', SQLERRM);

3330: EXCEPTION
3331: WHEN OTHERS THEN
3332: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3333: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3334: fnd_message.set_token('MSG_TEXT', SQLERRM);
3335: IF l_debug_on THEN
3336: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO EXCEPTION : ' || sqlerrm);
3337: WSH_DEBUG_SV.pop(l_module_name);
3338: END IF;

Line 3444: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');

3440: -- Exception Handling part
3441: EXCEPTION
3442: WHEN OTHERS THEN
3443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3444: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3445: fnd_message.set_token('MSG_TEXT', SQLERRM);
3446: IF l_debug_on THEN
3447: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO_CODE EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3448: WSH_DEBUG_SV.pop(l_module_name);

Line 3445: fnd_message.set_token('MSG_TEXT', SQLERRM);

3441: EXCEPTION
3442: WHEN OTHERS THEN
3443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3444: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3445: fnd_message.set_token('MSG_TEXT', SQLERRM);
3446: IF l_debug_on THEN
3447: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO_CODE EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3448: WSH_DEBUG_SV.pop(l_module_name);
3449: END IF;

Line 3591: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');

3587: -- Exception Handling part
3588: EXCEPTION
3589: WHEN OTHERS THEN
3590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3591: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3592: fnd_message.set_token('MSG_TEXT', SQLERRM);
3593: IF l_debug_on THEN
3594: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_ID_CODES_ONLY EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3595: WSH_DEBUG_SV.pop(l_module_name);

Line 3592: fnd_message.set_token('MSG_TEXT', SQLERRM);

3588: EXCEPTION
3589: WHEN OTHERS THEN
3590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3591: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3592: fnd_message.set_token('MSG_TEXT', SQLERRM);
3593: IF l_debug_on THEN
3594: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_ID_CODES_ONLY EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3595: WSH_DEBUG_SV.pop(l_module_name);
3596: END IF;