eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_UM_PASSWORD_PVT dependencies on FND_API

Line 47: p_init_msg_list in varchar2 := FND_API.G_FALSE,

43: * Errors :
44: * Other Comments :
45: */
46: procedure generate_password (p_api_version_number in number,
47: p_init_msg_list in varchar2 := FND_API.G_FALSE,
48: p_commit in varchar2 := FND_API.G_FALSE,
49: p_validation_level in number
50: := FND_API.G_VALID_LEVEL_FULL,
51: x_password out NOCOPY varchar2,

Line 48: p_commit in varchar2 := FND_API.G_FALSE,

44: * Other Comments :
45: */
46: procedure generate_password (p_api_version_number in number,
47: p_init_msg_list in varchar2 := FND_API.G_FALSE,
48: p_commit in varchar2 := FND_API.G_FALSE,
49: p_validation_level in number
50: := FND_API.G_VALID_LEVEL_FULL,
51: x_password out NOCOPY varchar2,
52: x_return_status out NOCOPY varchar2,

Line 50: := FND_API.G_VALID_LEVEL_FULL,

46: procedure generate_password (p_api_version_number in number,
47: p_init_msg_list in varchar2 := FND_API.G_FALSE,
48: p_commit in varchar2 := FND_API.G_FALSE,
49: p_validation_level in number
50: := FND_API.G_VALID_LEVEL_FULL,
51: x_password out NOCOPY varchar2,
52: x_return_status out NOCOPY varchar2,
53: x_msg_count out NOCOPY number,
54: x_msg_data out NOCOPY varchar2

Line 71: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

67: -- Standard Start of API savepoint
68: SAVEPOINT generate_password;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME)
75: THEN

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME)
75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 81: IF FND_API.to_Boolean( p_init_msg_list ) THEN

77: END IF;
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

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
87:
88: --
89: -- API body
90: --

Line 121: IF FND_API.to_Boolean( p_commit )

117: -- End of API body
118: --
119:
120: -- Standard check for p_commit
121: IF FND_API.to_Boolean( p_commit )
122: THEN
123: COMMIT WORK;
124: END IF;
125:

Line 138: WHEN FND_API.G_EXC_ERROR THEN

134: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API Generate_Password ...');
135: --
136:
137: EXCEPTION
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

Line 149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

145: ,X_MSG_COUNT => X_MSG_COUNT
146: ,X_MSG_DATA => X_MSG_DATA
147: ,X_RETURN_STATUS => X_RETURN_STATUS);
148:
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

Line 219: p_init_msg_list in varchar2 := FND_API.G_FALSE,

215:
216:
217:
218: procedure send_password (p_api_version_number in number,
219: p_init_msg_list in varchar2 := FND_API.G_FALSE,
220: p_commit in varchar2 := FND_API.G_FALSE,
221: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
222: p_requester_user_name in varchar2,
223: p_requester_password in varchar2,

Line 220: p_commit in varchar2 := FND_API.G_FALSE,

216:
217:
218: procedure send_password (p_api_version_number in number,
219: p_init_msg_list in varchar2 := FND_API.G_FALSE,
220: p_commit in varchar2 := FND_API.G_FALSE,
221: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
222: p_requester_user_name in varchar2,
223: p_requester_password in varchar2,
224: p_requester_last_name in varchar2 := null,

Line 221: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

217:
218: procedure send_password (p_api_version_number in number,
219: p_init_msg_list in varchar2 := FND_API.G_FALSE,
220: p_commit in varchar2 := FND_API.G_FALSE,
221: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
222: p_requester_user_name in varchar2,
223: p_requester_password in varchar2,
224: p_requester_last_name in varchar2 := null,
225: p_requester_first_name in varchar2 := null,

Line 261: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

257: select email_address
258: from fnd_user
259: where user_name = l_user_name
260: and (nvl(end_date, sysdate+1) > sysdate OR
261: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
262:
263: CURSOR c_wf_user(l_user_name in varchar2) IS
264: select email_address
265: from wf_users

Line 282: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

278: -- Standard Start of API savepoint
279: SAVEPOINT send_password;
280:
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
283: p_api_version_number,
284: l_api_name,
285: G_PKG_NAME)
286: THEN

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283: p_api_version_number,
284: l_api_name,
285: G_PKG_NAME)
286: THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:
290:
291: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 292: IF FND_API.to_Boolean( p_init_msg_list ) THEN

288: END IF;
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

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
298:
299: --
300: -- API body
301: --

Line 313: RAISE FND_API.G_EXC_ERROR;

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:
316: -- password can be null when sending only enrollments
317:

Line 326: RAISE FND_API.G_EXC_ERROR;

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:
329: -- validate user_name
330:

Line 344: RAISE FND_API.G_EXC_ERROR;

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;
347:
348: -- get email address to which the password needs to be sent

Line 358: if x_return_status = FND_API.G_RET_STS_ERROR then

354: x_return_status => x_return_Status,
355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_Data );
357:
358: if x_return_status = FND_API.G_RET_STS_ERROR then
359: RAISE FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: end if;

Line 359: RAISE FND_API.G_EXC_ERROR;

355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_Data );
357:
358: if x_return_status = FND_API.G_RET_STS_ERROR then
359: RAISE FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: end if;
363:

Line 360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

356: x_msg_data => x_msg_Data );
357:
358: if x_return_status = FND_API.G_RET_STS_ERROR then
359: RAISE FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: end if;
363:
364: -- if wf_user is NULL then we need to create an adhoc user

Line 361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

357:
358: if x_return_status = FND_API.G_RET_STS_ERROR then
359: RAISE FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: end if;
363:
364: -- if wf_user is NULL then we need to create an adhoc user
365: -- create adhoc user

Line 375: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

371: p_email_address => l_requester_email,
372: x_return_status => x_return_status,
373: x_msg_data => x_msg_data,
374: x_msg_count => x_msg_count);
375: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: end if;
378: end if;
379:

Line 376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

372: x_return_status => x_return_status,
373: x_msg_data => x_msg_data,
374: x_msg_count => x_msg_count);
375: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: end if;
378: end if;
379:
380: end if;

Line 391: RAISE FND_API.G_EXC_ERROR;

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:
394:
395:

Line 527: IF FND_API.to_Boolean( p_commit )

523: -- End of API body
524: --
525:
526: -- Standard check for p_commit
527: IF FND_API.to_Boolean( p_commit )
528: THEN
529: COMMIT WORK;
530: END IF;
531:

Line 543: WHEN FND_API.G_EXC_ERROR THEN

539: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
540: --
541:
542: EXCEPTION
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

Line 554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

550: ,X_MSG_COUNT => X_MSG_COUNT
551: ,X_MSG_DATA => X_MSG_DATA
552: ,X_RETURN_STATUS => X_RETURN_STATUS);
553:
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

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: where responsibility_id = p_resp_id;
630:
631: begin
632: -- Initialize API return status to success
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: l_application_id := p_application_id;
636:
637: -- set approval_required

Line 1061: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1057: */
1058:
1059:
1060: procedure reset_password(p_api_version_number in number,
1061: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1062: p_commit in varchar2 := FND_API.G_FALSE,
1063: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1064: p_requester_user_name in varchar2 := null,
1065: p_requester_email in varchar2 := null,

Line 1062: p_commit in varchar2 := FND_API.G_FALSE,

1058:
1059:
1060: procedure reset_password(p_api_version_number in number,
1061: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1062: p_commit in varchar2 := FND_API.G_FALSE,
1063: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1064: p_requester_user_name in varchar2 := null,
1065: p_requester_email in varchar2 := null,
1066: p_application_id in number := null,

Line 1063: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1059:
1060: procedure reset_password(p_api_version_number in number,
1061: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1062: p_commit in varchar2 := FND_API.G_FALSE,
1063: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1064: p_requester_user_name in varchar2 := null,
1065: p_requester_email in varchar2 := null,
1066: p_application_id in number := null,
1067: p_responsibility_id in number := null,

Line 1097: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1093: -- Standard Start of API savepoint
1094: SAVEPOINT reset_password;
1095:
1096: -- Standard call to check for call compatibility.
1097: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1098: p_api_version_number,
1099: l_api_name,
1100: G_PKG_NAME)
1101: THEN

Line 1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1098: p_api_version_number,
1099: l_api_name,
1100: G_PKG_NAME)
1101: THEN
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;
1104:
1105:
1106: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1107: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1103: END IF;
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

Line 1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1113:
1114: --
1115: -- API body
1116: --

Line 1125: RAISE FND_API.G_EXC_ERROR;

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:
1128: -- validate / default username/email
1129:

Line 1140: if x_return_status = FND_API.G_RET_STS_ERROR then

1136: x_return_status => x_return_Status,
1137: x_msg_count => x_msg_count,
1138: x_msg_data => x_msg_Data );
1139:
1140: if x_return_status = FND_API.G_RET_STS_ERROR then
1141: RAISE FND_API.G_EXC_ERROR;
1142: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: end if;

Line 1141: RAISE FND_API.G_EXC_ERROR;

1137: x_msg_count => x_msg_count,
1138: x_msg_data => x_msg_Data );
1139:
1140: if x_return_status = FND_API.G_RET_STS_ERROR then
1141: RAISE FND_API.G_EXC_ERROR;
1142: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: end if;
1145:

Line 1142: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1138: x_msg_data => x_msg_Data );
1139:
1140: if x_return_status = FND_API.G_RET_STS_ERROR then
1141: RAISE FND_API.G_EXC_ERROR;
1142: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: end if;
1145:
1146: -- if wf_user is NULL then we need to create an adhoc user

Line 1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1139:
1140: if x_return_status = FND_API.G_RET_STS_ERROR then
1141: RAISE FND_API.G_EXC_ERROR;
1142: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: end if;
1145:
1146: -- if wf_user is NULL then we need to create an adhoc user
1147: -- create adhoc user

Line 1157: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1153: p_email_address => l_requester_email,
1154: x_return_status => x_return_status,
1155: x_msg_data => x_msg_data,
1156: x_msg_count => x_msg_count);
1157: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: end if;
1160: end if;
1161:

Line 1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1154: x_return_status => x_return_status,
1155: x_msg_data => x_msg_data,
1156: x_msg_count => x_msg_count);
1157: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: end if;
1160: end if;
1161:
1162:

Line 1199: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1195: END LOOP;
1196: -- end of code for validating username
1197:
1198:
1199: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201: end if;
1202:
1203: if not fnd_user_pkg.changePassword(username => l_requester_user_name,

Line 1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1196: -- end of code for validating username
1197:
1198:
1199: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201: end if;
1202:
1203: if not fnd_user_pkg.changePassword(username => l_requester_user_name,
1204: newpassword => l_password) then

Line 1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1201: end if;
1202:
1203: if not fnd_user_pkg.changePassword(username => l_requester_user_name,
1204: newpassword => l_password) then
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: end if;
1207:
1208: -- update the password date to null to force user to change psswd upon
1209: -- first login

Line 1220: -- not needed now as FND API allows setting the password date to null

1216:
1217:
1218: -- update the password date to null. this will force the user to change
1219: -- password upon first logon
1220: -- not needed now as FND API allows setting the password date to null
1221: /*
1222: --begin
1223: update fnd_user set
1224: password_date = null

Line 1246: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1242: x_return_status => x_return_status,
1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data
1245: );
1246: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: end if;
1249: --
1250: -- End of API body

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data
1245: );
1246: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: end if;
1249: --
1250: -- End of API body
1251: --

Line 1254: IF FND_API.to_Boolean( p_commit )

1250: -- End of API body
1251: --
1252:
1253: -- Standard check for p_commit
1254: IF FND_API.to_Boolean( p_commit )
1255: THEN
1256: COMMIT WORK;
1257: END IF;
1258:

Line 1272: WHEN FND_API.G_EXC_ERROR THEN

1268: end if;
1269: --
1270:
1271: EXCEPTION
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

Line 1283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1279: ,X_MSG_COUNT => X_MSG_COUNT
1280: ,X_MSG_DATA => X_MSG_DATA
1281: ,X_RETURN_STATUS => X_RETURN_STATUS);
1282:
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