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: -- validate end date and email address using user_name

Line 343: RAISE FND_API.G_EXC_ERROR;

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;
346: -- get email address to which the password needs to be sent
347: if l_wf_user_name is NULL then

Line 356: if x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 357: RAISE FND_API.G_EXC_ERROR;

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

Line 358: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 372: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 387: RAISE FND_API.G_EXC_ERROR;

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:
390:
391:

Line 522: IF FND_API.to_Boolean( p_commit )

518: -- End of API body
519: --
520:
521: -- Standard check for p_commit
522: IF FND_API.to_Boolean( p_commit )
523: THEN
524: COMMIT WORK;
525: END IF;
526:

Line 538: WHEN FND_API.G_EXC_ERROR THEN

534: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
535: --
536:
537: EXCEPTION
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

Line 549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

545: ,X_MSG_COUNT => X_MSG_COUNT
546: ,X_MSG_DATA => X_MSG_DATA
547: ,X_RETURN_STATUS => X_RETURN_STATUS);
548:
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

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: where responsibility_id = p_resp_id;
625:
626: begin
627: -- Initialize API return status to success
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: l_application_id := p_application_id;
631:
632: -- set approval_required

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

1108: */
1109:
1110:
1111: procedure reset_password(p_api_version_number in number,
1112: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1113: p_commit in varchar2 := FND_API.G_FALSE,
1114: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1115: p_requester_user_name in varchar2 := null,
1116: p_requester_email in varchar2 := null,

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

1109:
1110:
1111: procedure reset_password(p_api_version_number in number,
1112: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1113: p_commit in varchar2 := FND_API.G_FALSE,
1114: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1115: p_requester_user_name in varchar2 := null,
1116: p_requester_email in varchar2 := null,
1117: p_application_id in number := null,

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

1110:
1111: procedure reset_password(p_api_version_number in number,
1112: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1113: p_commit in varchar2 := FND_API.G_FALSE,
1114: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1115: p_requester_user_name in varchar2 := null,
1116: p_requester_email in varchar2 := null,
1117: p_application_id in number := null,
1118: p_responsibility_id in number := null,

Line 1148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1144: -- Standard Start of API savepoint
1145: SAVEPOINT reset_password;
1146:
1147: -- Standard call to check for call compatibility.
1148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1149: p_api_version_number,
1150: l_api_name,
1151: G_PKG_NAME)
1152: THEN

Line 1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1149: p_api_version_number,
1150: l_api_name,
1151: G_PKG_NAME)
1152: THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;
1155:
1156:
1157: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1163: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1164:
1165: --
1166: -- API body
1167: --

Line 1176: RAISE FND_API.G_EXC_ERROR;

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:
1179: -- validate / default username/email
1180:

Line 1191: if x_return_status = FND_API.G_RET_STS_ERROR then

1187: x_return_status => x_return_Status,
1188: x_msg_count => x_msg_count,
1189: x_msg_data => x_msg_Data );
1190:
1191: if x_return_status = FND_API.G_RET_STS_ERROR then
1192: RAISE FND_API.G_EXC_ERROR;
1193: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: end if;

Line 1192: RAISE FND_API.G_EXC_ERROR;

1188: x_msg_count => x_msg_count,
1189: x_msg_data => x_msg_Data );
1190:
1191: if x_return_status = FND_API.G_RET_STS_ERROR then
1192: RAISE FND_API.G_EXC_ERROR;
1193: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: end if;
1196:

Line 1193: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1189: x_msg_data => x_msg_Data );
1190:
1191: if x_return_status = FND_API.G_RET_STS_ERROR then
1192: RAISE FND_API.G_EXC_ERROR;
1193: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: end if;
1196:
1197: -- if wf_user is NULL then we need to create an adhoc user

Line 1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1190:
1191: if x_return_status = FND_API.G_RET_STS_ERROR then
1192: RAISE FND_API.G_EXC_ERROR;
1193: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: end if;
1196:
1197: -- if wf_user is NULL then we need to create an adhoc user
1198: -- create adhoc user

Line 1208: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1204: p_email_address => l_requester_email,
1205: x_return_status => x_return_status,
1206: x_msg_data => x_msg_data,
1207: x_msg_count => x_msg_count);
1208: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: end if;
1211: end if;
1212:

Line 1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1205: x_return_status => x_return_status,
1206: x_msg_data => x_msg_data,
1207: x_msg_count => x_msg_count);
1208: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: end if;
1211: end if;
1212:
1213:

Line 1250: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1246: END LOOP;
1247: -- end of code for validating username
1248:
1249:
1250: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: end if;
1253:
1254: if not fnd_user_pkg.changePassword(username => l_requester_user_name,

Line 1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1247: -- end of code for validating username
1248:
1249:
1250: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: end if;
1253:
1254: if not fnd_user_pkg.changePassword(username => l_requester_user_name,
1255: newpassword => l_password) then

Line 1256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1252: end if;
1253:
1254: if not fnd_user_pkg.changePassword(username => l_requester_user_name,
1255: newpassword => l_password) then
1256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1257: end if;
1258:
1259: -- update the password date to null to force user to change psswd upon
1260: -- first login

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

1267:
1268:
1269: -- update the password date to null. this will force the user to change
1270: -- password upon first logon
1271: -- not needed now as FND API allows setting the password date to null
1272: /*
1273: --begin
1274: update fnd_user set
1275: password_date = null

Line 1297: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1293: x_return_status => x_return_status,
1294: x_msg_count => x_msg_count,
1295: x_msg_data => x_msg_data
1296: );
1297: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: end if;
1300: --
1301: -- End of API body

Line 1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1294: x_msg_count => x_msg_count,
1295: x_msg_data => x_msg_data
1296: );
1297: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: end if;
1300: --
1301: -- End of API body
1302: --

Line 1305: IF FND_API.to_Boolean( p_commit )

1301: -- End of API body
1302: --
1303:
1304: -- Standard check for p_commit
1305: IF FND_API.to_Boolean( p_commit )
1306: THEN
1307: COMMIT WORK;
1308: END IF;
1309:

Line 1323: WHEN FND_API.G_EXC_ERROR THEN

1319: end if;
1320: --
1321:
1322: EXCEPTION
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

Line 1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1330: ,X_MSG_COUNT => X_MSG_COUNT
1331: ,X_MSG_DATA => X_MSG_DATA
1332: ,X_RETURN_STATUS => X_RETURN_STATUS);
1333:
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