1604: FND_PROFILE.Get('WSH_OTM_CORP_COUNTRY_CODE',l_country_code);
1605:
1606: IF (l_domain_name is null) THEN
1607: --{
1608: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DOMAIN_NOT_SET_ERR');
1609: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1610: wsh_util_core.add_message(x_return_status, l_module_name);
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1616: END IF;
1617:
1618: IF (l_country_code is null) THEN
1619: --{
1620: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CNTR_CODE_NOT_SET_ERR');
1621: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1622: wsh_util_core.add_message(x_return_status, l_module_name);
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
2168: END IF;
2169:
2170: IF (x_loc_xmission_rec.username is null) THEN
2171: --{
2172: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2173: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2174: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2175: wsh_util_core.add_message(x_return_status, l_module_name);
2176: IF l_debug_on THEN
2169:
2170: IF (x_loc_xmission_rec.username is null) THEN
2171: --{
2172: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2173: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2174: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2175: wsh_util_core.add_message(x_return_status, l_module_name);
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2181: END IF;
2182:
2183: IF (x_loc_xmission_rec.password is null) THEN
2184: --{
2185: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2186: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2187: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2188: wsh_util_core.add_message(x_return_status, l_module_name);
2189: IF l_debug_on THEN
2182:
2183: IF (x_loc_xmission_rec.password is null) THEN
2184: --{
2185: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2186: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2187: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2188: wsh_util_core.add_message(x_return_status, l_module_name);
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2759:
2760: --} -- wms-otm for ORG_LOC
2761: ELSE
2762: --{
2763: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2764: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2765: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2766: wsh_util_core.add_message(x_return_status, l_module_name);
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2760: --} -- wms-otm for ORG_LOC
2761: ELSE
2762: --{
2763: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2764: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2765: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2766: wsh_util_core.add_message(x_return_status, l_module_name);
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: --}
3050: IF l_debug_on THEN
3051: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is invalid');
3052: END IF;
3053: x_tkt_valid := 'F';
3054: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TKT');
3055: FND_MESSAGE.SET_TOKEN('TICKET',p_ticket);
3056: x_return_status := wsh_util_core.G_RET_STS_ERROR;
3057: x_msg_data :=FND_MESSAGE.GET;
3058: --}
3051: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is invalid');
3052: END IF;
3053: x_tkt_valid := 'F';
3054: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TKT');
3055: FND_MESSAGE.SET_TOKEN('TICKET',p_ticket);
3056: x_return_status := wsh_util_core.G_RET_STS_ERROR;
3057: x_msg_data :=FND_MESSAGE.GET;
3058: --}
3059: END IF;
3053: x_tkt_valid := 'F';
3054: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TKT');
3055: FND_MESSAGE.SET_TOKEN('TICKET',p_ticket);
3056: x_return_status := wsh_util_core.G_RET_STS_ERROR;
3057: x_msg_data :=FND_MESSAGE.GET;
3058: --}
3059: END IF;
3060: --
3061: -- Debug Statements