81: fetch getUserIDCursor into l_userid;
82: IF (getUserIDCursor%notfound) THEN
83: -- Cannot find the userid of the user.
84: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
85: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_UA_MISSING_USERID');
86: FND_MESSAGE.Set_Token('0', G_PKG_NAME, FALSE);
87: FND_MESSAGE.Set_Token('1', 'p_username', FALSE);
88: FND_MSG_PUB.ADD;
89: END IF;
82: IF (getUserIDCursor%notfound) THEN
83: -- Cannot find the userid of the user.
84: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
85: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_UA_MISSING_USERID');
86: FND_MESSAGE.Set_Token('0', G_PKG_NAME, FALSE);
87: FND_MESSAGE.Set_Token('1', 'p_username', FALSE);
88: FND_MSG_PUB.ADD;
89: END IF;
90: close getUserIDCursor;
83: -- Cannot find the userid of the user.
84: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
85: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_UA_MISSING_USERID');
86: FND_MESSAGE.Set_Token('0', G_PKG_NAME, FALSE);
87: FND_MESSAGE.Set_Token('1', 'p_username', FALSE);
88: FND_MSG_PUB.ADD;
89: END IF;
90: close getUserIDCursor;
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: --
207: -- Validate required fields
208: IF (p_username is null) THEN
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
210: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
211: FND_MESSAGE.Set_Token('API_NAME', G_PKG_NAME, FALSE);
212: FND_MESSAGE.Set_Token('FIELD', 'p_username', FALSE);
213: FND_MSG_PUB.ADD;
214: END IF;
207: -- Validate required fields
208: IF (p_username is null) THEN
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
210: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
211: FND_MESSAGE.Set_Token('API_NAME', G_PKG_NAME, FALSE);
212: FND_MESSAGE.Set_Token('FIELD', 'p_username', FALSE);
213: FND_MSG_PUB.ADD;
214: END IF;
215: RAISE FND_API.G_EXC_ERROR;
208: IF (p_username is null) THEN
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
210: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
211: FND_MESSAGE.Set_Token('API_NAME', G_PKG_NAME, FALSE);
212: FND_MESSAGE.Set_Token('FIELD', 'p_username', FALSE);
213: FND_MSG_PUB.ADD;
214: END IF;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;