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 336: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 342: FND_MSG_PUB.ADD;

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

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

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

Line 389: FND_MSG_PUB.ADD;

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

Line 534: FND_MSG_PUB.Count_And_Get(

530: END IF;
531:
532: -- Standard call to get message count and if count is 1, get message info.
533:
534: FND_MSG_PUB.Count_And_Get(
535: p_count => x_msg_count,
536: p_data => x_msg_data);
537:
538: -- Write to debug log

Line 547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

543: WHEN FND_API.G_EXC_ERROR THEN
544: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
548: ,P_SQLCODE => SQLCODE
549: ,P_SQLERRM => SQLERRM
550: ,X_MSG_COUNT => X_MSG_COUNT
551: ,X_MSG_DATA => X_MSG_DATA

Line 558: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
556: P_API_NAME => L_API_NAME
557: ,P_PKG_NAME => G_PKG_NAME
558: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
559: ,P_SQLCODE => SQLCODE
560: ,P_SQLERRM => SQLERRM
561: ,X_MSG_COUNT => X_MSG_COUNT
562: ,X_MSG_DATA => X_MSG_DATA

Line 1108: FND_MSG_PUB.initialize;

1104:
1105:
1106: -- Initialize message list if p_init_msg_list is set to TRUE.
1107: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1108: FND_MSG_PUB.initialize;
1109: END IF;
1110:
1111: -- Initialize API return status to success
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1117:
1118: -- Validate required fields for not null values
1119:
1120: if (p_requester_user_name is null and p_requester_email is null) then
1121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1122: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_USER_OR_EMAIL');
1123: FND_MSG_PUB.ADD;
1124: END IF;
1125: RAISE FND_API.G_EXC_ERROR;

Line 1123: FND_MSG_PUB.ADD;

1119:
1120: if (p_requester_user_name is null and p_requester_email is null) then
1121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1122: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_USER_OR_EMAIL');
1123: FND_MSG_PUB.ADD;
1124: END IF;
1125: RAISE FND_API.G_EXC_ERROR;
1126: end if;
1127:

Line 1261: FND_MSG_PUB.Count_And_Get(

1257: END IF;
1258:
1259: -- Standard call to get message count and if count is 1, get message info.
1260:
1261: FND_MSG_PUB.Count_And_Get(
1262: p_count => x_msg_count,
1263: p_data => x_msg_data);
1264:
1265: -- Write to debug log

Line 1276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1272: WHEN FND_API.G_EXC_ERROR THEN
1273: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
1274: P_API_NAME => L_API_NAME
1275: ,P_PKG_NAME => G_PKG_NAME
1276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1277: ,P_SQLCODE => SQLCODE
1278: ,P_SQLERRM => SQLERRM
1279: ,X_MSG_COUNT => X_MSG_COUNT
1280: ,X_MSG_DATA => X_MSG_DATA

Line 1287: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1284: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
1285: P_API_NAME => L_API_NAME
1286: ,P_PKG_NAME => G_PKG_NAME
1287: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1288: ,P_SQLCODE => SQLCODE
1289: ,P_SQLERRM => SQLERRM
1290: ,X_MSG_COUNT => X_MSG_COUNT
1291: ,X_MSG_DATA => X_MSG_DATA