DBA Data[Home] [Help]

APPS.JTF_UM_PASSWORD_PVT dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.initialize;

78:
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list ) THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 128: FND_MSG_PUB.Count_And_Get(

124: END IF;
125:
126: -- Standard call to get message count and if count is 1, get message info.
127:
128: FND_MSG_PUB.Count_And_Get(
129: p_count => x_msg_count,
130: p_data => x_msg_data);
131:
132: -- Write to debug log

Line 142: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

138: WHEN FND_API.G_EXC_ERROR THEN
139: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
140: P_API_NAME => L_API_NAME
141: ,P_PKG_NAME => G_PKG_NAME
142: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
143: ,P_SQLCODE => SQLCODE
144: ,P_SQLERRM => SQLERRM
145: ,X_MSG_COUNT => X_MSG_COUNT
146: ,X_MSG_DATA => X_MSG_DATA

Line 153: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
151: P_API_NAME => L_API_NAME
152: ,P_PKG_NAME => G_PKG_NAME
153: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
154: ,P_SQLCODE => SQLCODE
155: ,P_SQLERRM => SQLERRM
156: ,X_MSG_COUNT => X_MSG_COUNT
157: ,X_MSG_DATA => X_MSG_DATA

Line 293: FND_MSG_PUB.initialize;

289:
290:
291: -- Initialize message list if p_init_msg_list is set to TRUE.
292: IF FND_API.to_Boolean( p_init_msg_list ) THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:
296: -- Initialize API return status to success
297: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

302:
303: -- Validate required fields for not null values
304:
305: if (p_requester_user_name is null) then
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
307: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
308: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
309: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
310: FND_MESSAGE.Set_Token('FIELD', 'USER_NAME', FALSE);

Line 311: FND_MSG_PUB.ADD;

307: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
308: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
309: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
310: FND_MESSAGE.Set_Token('FIELD', 'USER_NAME', FALSE);
311: FND_MSG_PUB.ADD;
312: END IF;
313: RAISE FND_API.G_EXC_ERROR;
314: end if;
315:

Line 319: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

315:
316: -- password can be null when sending only enrollments
317:
318: if (p_requester_password is null and p_enrollment_only <> 'Y') then
319: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
320: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
321: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
322: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
323: FND_MESSAGE.Set_Token('FIELD', 'PASSWORD', FALSE);

Line 324: FND_MSG_PUB.ADD;

320: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
321: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
322: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
323: FND_MESSAGE.Set_Token('FIELD', 'PASSWORD', FALSE);
324: FND_MSG_PUB.ADD;
325: END IF;
326: RAISE FND_API.G_EXC_ERROR;
327: end if;
328:

Line 335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

331: Open c_user(l_requester_user_name);
332: Fetch c_user into l_requester_email;
333: If (c_user%NOTFOUND) then
334: Close c_user;
335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_FIELD');
337: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
338: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
339: FND_MESSAGE.Set_Token('FIELD', 'USER', FALSE);

Line 341: FND_MSG_PUB.ADD;

337: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
338: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
339: FND_MESSAGE.Set_Token('FIELD', 'USER', FALSE);
340: FND_MESSAGE.Set_Token('VALUE', p_requester_user_name, FALSE);
341: FND_MSG_PUB.ADD;
342: END IF;
343: RAISE FND_API.G_EXC_ERROR;
344: end if;
345: Close c_user;

Line 380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

376:
377: end if;
378: --
379: If l_requester_email is NULL then
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
381: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_EMAIL');
382: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
383: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
384: FND_MESSAGE.Set_Token('USER_NAME',p_requester_user_name, FALSE);

Line 385: FND_MSG_PUB.ADD;

381: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_EMAIL');
382: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
383: FND_MESSAGE.Set_Token('API_NAME', 'sending the password', FALSE);
384: FND_MESSAGE.Set_Token('USER_NAME',p_requester_user_name, FALSE);
385: FND_MSG_PUB.ADD;
386: END IF;
387: RAISE FND_API.G_EXC_ERROR;
388: end if;
389:

Line 529: FND_MSG_PUB.Count_And_Get(

525: END IF;
526:
527: -- Standard call to get message count and if count is 1, get message info.
528:
529: FND_MSG_PUB.Count_And_Get(
530: p_count => x_msg_count,
531: p_data => x_msg_data);
532:
533: -- Write to debug log

Line 542: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

538: WHEN FND_API.G_EXC_ERROR THEN
539: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
540: P_API_NAME => L_API_NAME
541: ,P_PKG_NAME => G_PKG_NAME
542: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
543: ,P_SQLCODE => SQLCODE
544: ,P_SQLERRM => SQLERRM
545: ,X_MSG_COUNT => X_MSG_COUNT
546: ,X_MSG_DATA => X_MSG_DATA

Line 553: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
551: P_API_NAME => L_API_NAME
552: ,P_PKG_NAME => G_PKG_NAME
553: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
554: ,P_SQLCODE => SQLCODE
555: ,P_SQLERRM => SQLERRM
556: ,X_MSG_COUNT => X_MSG_COUNT
557: ,X_MSG_DATA => X_MSG_DATA

Line 1159: FND_MSG_PUB.initialize;

1155:
1156:
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;
1160: END IF;
1161:
1162: -- Initialize API return status to success
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1168:
1169: -- Validate required fields for not null values
1170:
1171: if (p_requester_user_name is null and p_requester_email is null) then
1172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1173: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_USER_OR_EMAIL');
1174: FND_MSG_PUB.ADD;
1175: END IF;
1176: RAISE FND_API.G_EXC_ERROR;

Line 1174: FND_MSG_PUB.ADD;

1170:
1171: if (p_requester_user_name is null and p_requester_email is null) then
1172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1173: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_USER_OR_EMAIL');
1174: FND_MSG_PUB.ADD;
1175: END IF;
1176: RAISE FND_API.G_EXC_ERROR;
1177: end if;
1178:

Line 1312: FND_MSG_PUB.Count_And_Get(

1308: END IF;
1309:
1310: -- Standard call to get message count and if count is 1, get message info.
1311:
1312: FND_MSG_PUB.Count_And_Get(
1313: p_count => x_msg_count,
1314: p_data => x_msg_data);
1315:
1316: -- Write to debug log

Line 1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1323: WHEN FND_API.G_EXC_ERROR THEN
1324: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME
1326: ,P_PKG_NAME => G_PKG_NAME
1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1328: ,P_SQLCODE => SQLCODE
1329: ,P_SQLERRM => SQLERRM
1330: ,X_MSG_COUNT => X_MSG_COUNT
1331: ,X_MSG_DATA => X_MSG_DATA

Line 1338: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
1336: P_API_NAME => L_API_NAME
1337: ,P_PKG_NAME => G_PKG_NAME
1338: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1339: ,P_SQLCODE => SQLCODE
1340: ,P_SQLERRM => SQLERRM
1341: ,X_MSG_COUNT => X_MSG_COUNT
1342: ,X_MSG_DATA => X_MSG_DATA