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_USER_ADMIN_PVT dependencies on FND_API

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

73: select user_id
74: from fnd_user
75: where user_name = p_username
76: and (nvl (end_date, sysdate + 1) > sysdate or
77: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE)) ;
78:
79: begin
80: open getUserIDCursor;
81: fetch getUserIDCursor into l_userid;

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
92: END IF;
93: close getUserIDCursor;
94:
95: return l_userid;

Line 134: p_init_msg_list in varchar2 default FND_API.G_FALSE,

130: * Errors : possible errors raised by this API
131: * Other Comments :
132: */
133: PROCEDURE INACTIVE_USER (p_api_version_number in number,
134: p_init_msg_list in varchar2 default FND_API.G_FALSE,
135: p_commit in varchar2 default FND_API.G_FALSE,
136: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
137: p_username in varchar2,
138: x_return_status out NOCOPY varchar2,

Line 135: p_commit in varchar2 default FND_API.G_FALSE,

131: * Other Comments :
132: */
133: PROCEDURE INACTIVE_USER (p_api_version_number in number,
134: p_init_msg_list in varchar2 default FND_API.G_FALSE,
135: p_commit in varchar2 default FND_API.G_FALSE,
136: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
137: p_username in varchar2,
138: x_return_status out NOCOPY varchar2,
139: x_msg_data out NOCOPY varchar2,

Line 136: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,

132: */
133: PROCEDURE INACTIVE_USER (p_api_version_number in number,
134: p_init_msg_list in varchar2 default FND_API.G_FALSE,
135: p_commit in varchar2 default FND_API.G_FALSE,
136: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
137: p_username in varchar2,
138: x_return_status out NOCOPY varchar2,
139: x_msg_data out NOCOPY varchar2,
140: x_msg_count out NOCOPY number) is

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

172: select customer_id
173: from fnd_user
174: where user_id = l_userid
175: and (nvl (end_date, sysdate + 1) > sysdate OR
176: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE)) ;
177:
178: BEGIN
179: -- Write to debug log
180: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');

Line 183: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

179: -- Write to debug log
180: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');
181:
182: -- Standard call to check for call compatibility.
183: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
184: p_api_version_number,
185: l_api_name,
186: G_PKG_NAME)
187: THEN

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: p_api_version_number,
185: l_api_name,
186: G_PKG_NAME)
187: THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190:
191: -- call the user hook if it is a public api. Private APIs do not require a user hook call.
192:

Line 197: IF FND_API.to_Boolean (p_init_msg_list) THEN

193: -- Standard Start of API savepoint
194: SAVEPOINT INACTIVE_USER;
195:
196: -- Initialize message list if p_init_msg_list is set to TRUE.
197: IF FND_API.to_Boolean (p_init_msg_list) THEN
198: FND_MSG_PUB.initialize;
199: END IF;
200:
201: -- Initialize API return status to success

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198: FND_MSG_PUB.initialize;
199: END IF;
200:
201: -- Initialize API return status to success
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: --
205: -- Beginning of API body
206: --

Line 215: RAISE FND_API.G_EXC_ERROR;

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;
217:
218: -- Get the userid
219: l_userid := getUserID (p_username);

Line 308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

304: x_total_retrieved => l_total_retrieved,
305: x_total_returned => l_total_returned,
306: x_object_version_number => l_version_num);
307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;

Line 309: RAISE FND_API.G_EXC_ERROR;

305: x_total_returned => l_total_returned,
306: x_object_version_number => l_version_num);
307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:

Line 310: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

306: x_object_version_number => l_version_num);
307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314: -- now, we can update the task with the task_id

Line 311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314: -- now, we can update the task with the task_id
315: task_mgr.update_task ('1.0', '1',

Line 320: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

316: l_task_table(l_task_table.first).task_id,
317: 'USER DELETED', 'REJECT', x_msg_data,
318: x_return_status, x_msg_count);
319:
320: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;

Line 321: RAISE FND_API.G_EXC_ERROR;

317: 'USER DELETED', 'REJECT', x_msg_data,
318: x_return_status, x_msg_count);
319:
320: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:

Line 322: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

318: x_return_status, x_msg_count);
319:
320: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: ELSIF (l_status_code = 'APPROVED') OR (l_status_code = 'UPGRADE') THEN

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319:
320: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: ELSIF (l_status_code = 'APPROVED') OR (l_status_code = 'UPGRADE') THEN
327: -- 1. abort Enrollment WF Process

Line 346: -- End date the user with the FND_API

342: AND status_code = 'PENDING';
343:
344: END IF;
345:
346: -- End date the user with the FND_API
347: FND_USER_PKG.DisableUser (p_username);
348:
349: --
350: -- End of API body

Line 354: IF FND_API.to_Boolean (p_commit) THEN

350: -- End of API body
351: --
352:
353: -- Standard check for p_commit
354: IF FND_API.to_Boolean (p_commit) THEN
355: COMMIT WORK;
356: END IF;
357:
358: -- Standard call to get message count and if count is 1, get message info.

Line 368: WHEN FND_API.G_EXC_ERROR THEN

364: -- Write to debug log
365: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
370: P_PKG_NAME => G_PKG_NAME,
371: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
372: P_SQLCODE => SQLCODE,

Line 378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

374: X_MSG_COUNT => X_MSG_COUNT,
375: X_MSG_DATA => X_MSG_DATA,
376: X_RETURN_STATUS => X_RETURN_STATUS);
377:
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
380: P_PKG_NAME => G_PKG_NAME,
381: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
382: P_SQLCODE => SQLCODE,