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.PA_ROLE_PROFILES_UTILS dependencies on FND_API

Line 65: x_return_status:= FND_API.G_RET_STS_SUCCESS;

61: ELSE x_business_group_id := NULL;
62: END IF;
63: END IF;
64:
65: x_return_status:= FND_API.G_RET_STS_SUCCESS;
66: x_error_msg_code := NULL;
67: IF l_enable_log = 'Y' THEN
68: pa_debug.reset_err_stack;
69: END IF;

Line 75: x_return_status:= FND_API.G_RET_STS_ERROR;

71: EXCEPTION
72: WHEN NO_DATA_FOUND THEN
73: --dbms_output.put_line ('No data exists');
74: x_business_group_id := NULL;
75: x_return_status:= FND_API.G_RET_STS_ERROR;
76: x_error_msg_code:= 'PA_BUS_GROUP_INVALID';
77: WHEN TOO_MANY_ROWS THEN
78: --dbms_output.put_line ('Too Many Rows');
79: x_business_group_id := NULL;

Line 80: x_return_status:= FND_API.G_RET_STS_ERROR;

76: x_error_msg_code:= 'PA_BUS_GROUP_INVALID';
77: WHEN TOO_MANY_ROWS THEN
78: --dbms_output.put_line ('Too Many Rows');
79: x_business_group_id := NULL;
80: x_return_status:= FND_API.G_RET_STS_ERROR;
81: x_error_msg_code:= 'PA_BUS_GROUP_NOT_UNIQUE';
82: WHEN OTHERS THEN
83: x_business_group_id := NULL;
84: fnd_msg_pub.add_exc_msg

Line 87: x_error_msg_code:= FND_API.G_RET_STS_UNEXP_ERROR;

83: x_business_group_id := NULL;
84: fnd_msg_pub.add_exc_msg
85: (p_pkg_name => 'PA_ROLE_PROFILES_UTILS',
86: p_procedure_name => pa_debug.g_err_stack );
87: x_error_msg_code:= FND_API.G_RET_STS_UNEXP_ERROR;
88: RAISE;
89:
90: END Check_BusGroup_Name_Or_Id;
91:

Line 154: x_return_status:= FND_API.G_RET_STS_SUCCESS;

150: ELSE x_position_id := NULL;
151: END IF;
152: END IF;
153:
154: x_return_status:= FND_API.G_RET_STS_SUCCESS;
155: x_error_msg_code := NULL;
156: IF l_enable_log = 'Y' THEN
157: pa_debug.reset_err_stack;
158: END IF;

Line 163: x_return_status:= FND_API.G_RET_STS_ERROR;

159:
160: EXCEPTION
161: WHEN NO_DATA_FOUND THEN
162: x_position_id := NULL;
163: x_return_status:= FND_API.G_RET_STS_ERROR;
164: x_error_msg_code:= 'PA_POSITION_INVALID';
165: WHEN TOO_MANY_ROWS THEN
166: x_position_id := NULL;
167: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 167: x_return_status:= FND_API.G_RET_STS_ERROR;

163: x_return_status:= FND_API.G_RET_STS_ERROR;
164: x_error_msg_code:= 'PA_POSITION_INVALID';
165: WHEN TOO_MANY_ROWS THEN
166: x_position_id := NULL;
167: x_return_status:= FND_API.G_RET_STS_ERROR;
168: x_error_msg_code:= 'PA_POSITION_NOT_UNIQUE';
169: WHEN OTHERS THEN
170: x_position_id := NULL;
171: fnd_msg_pub.add_exc_msg

Line 174: x_error_msg_code:= FND_API.G_RET_STS_UNEXP_ERROR;

170: x_position_id := NULL;
171: fnd_msg_pub.add_exc_msg
172: (p_pkg_name => 'PA_ROLE_PROFILES_UTILS',
173: p_procedure_name => pa_debug.g_err_stack );
174: x_error_msg_code:= FND_API.G_RET_STS_UNEXP_ERROR;
175: RAISE;
176:
177: END Check_Position_Name_Or_Id;
178:

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: l_exists VARCHAR(1);
209: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
210:
211: BEGIN
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213: --FND_MSG_PUB.initialize;
214:
215: IF p_business_group_name IS NULL
216: AND p_organization_name IS NULL

Line 221: RAISE FND_API.G_EXC_ERROR;

217: AND p_job_name IS NULL
218: AND p_position_name IS NULL THEN
219: PA_UTILS.Add_Message ( p_app_short_name => 'PA',
220: p_msg_name => 'PA_PROFILE_BUS_LEVEL_MISSING' );
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;
223:
224: IF p_business_group_name IS NOT NULL THEN
225: Check_BusGroup_Name_Or_Id

Line 232: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

228: x_business_group_id => x_business_group_id,
229: x_return_status => l_return_status,
230: x_error_msg_code => l_error_msg_code );
231:
232: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
233: PA_UTILS.Add_Message ( p_app_short_name => 'PA',
234: p_msg_name => l_error_msg_code );
235: END IF;
236: END IF;

Line 247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

243: x_organization_id => x_organization_id,
244: x_return_status => l_return_status,
245: x_error_msg_code => l_error_msg_code );
246:
247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
248: PA_UTILS.Add_Message ( p_app_short_name => 'PA',
249: p_msg_name => l_error_msg_code );
250: END IF;
251: END IF;

Line 262: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

258: x_job_id => x_job_id,
259: x_return_status => l_return_status,
260: x_error_message_code => l_error_msg_code );
261:
262: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
263: PA_UTILS.Add_Message ( p_app_short_name => 'PA',
264: p_msg_name => l_error_msg_code );
265: END IF;
266: END IF;

Line 277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

273: p_position_name => p_position_name,
274: x_position_id => x_position_id,
275: x_return_status => l_return_status,
276: x_error_msg_code => l_error_msg_code );
277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
278: PA_UTILS.Add_Message ( p_app_short_name => 'PA',
279: p_msg_name => l_error_msg_code );
280: END IF;
281: END IF;

Line 286: RAISE FND_API.G_EXC_ERROR;

282:
283: --dbms_output.put_line ('no of errors in the stack ' || FND_MSG_PUB.Count_Msg);
284:
285: IF FND_MSG_PUB.Count_Msg > 0 THEN
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: --The following code checks if organization, job, position belong to the business group
290: --and also if position belongs to the organization and job.

Line 339: RAISE FND_API.G_EXC_ERROR;

335: END;
336: END IF;
337:
338: IF FND_MSG_PUB.Count_Msg > 0 THEN
339: RAISE FND_API.G_EXC_ERROR;
340: END IF;
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: RAISE FND_API.G_EXC_ERROR;
340: END IF;
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_msg_count := FND_MSG_PUB.Count_Msg;
346: WHEN OTHERS THEN
347: RAISE;

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: END IF;
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_msg_count := FND_MSG_PUB.Count_Msg;
346: WHEN OTHERS THEN
347: RAISE;
348: END Check_Business_Level_Attrs;

Line 373: x_return_status := FND_API.G_RET_STS_SUCCESS;

369: l_sum NUMBER := 0;
370: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
371: BEGIN
372:
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374:
375: IF l_role_id_tbl.count <= 0 THEN
376: PA_UTILS.Add_Message (p_app_short_name => 'PA',
377: p_msg_name => 'PA_PROFILE_NUM_ROLES_ZERO');

Line 378: RAISE FND_API.G_EXC_ERROR;

374:
375: IF l_role_id_tbl.count <= 0 THEN
376: PA_UTILS.Add_Message (p_app_short_name => 'PA',
377: p_msg_name => 'PA_PROFILE_NUM_ROLES_ZERO');
378: RAISE FND_API.G_EXC_ERROR;
379: ELSE
380: FOR i IN 1..l_role_id_tbl.count LOOP
381: IF l_role_id_tbl(i) = 0 THEN
382: l_role_id_tbl(i) := NULL;

Line 388: RAISE FND_API.G_EXC_ERROR;

384:
385: IF p_weighting_tbl(i) <= 0 THEN
386: PA_UTILS.Add_Message (p_app_short_name => 'PA',
387: p_msg_name => 'PA_WEIGHTING_NOT_POSITIVE');
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390:
391: pa_role_utils.Check_Role_Name_Or_Id
392: (p_role_id => l_role_id_tbl(i),

Line 399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

395: x_role_id => l_role_id_tbl(i),
396: x_return_status => l_return_status,
397: x_error_message_code => l_error_msg_code);
398:
399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
400: PA_UTILS.Add_Message (p_app_short_name => 'PA',
401: p_msg_name => l_error_msg_code);
402: RAISE FND_API.G_EXC_ERROR;
403: END IF;

Line 402: RAISE FND_API.G_EXC_ERROR;

398:
399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
400: PA_UTILS.Add_Message (p_app_short_name => 'PA',
401: p_msg_name => l_error_msg_code);
402: RAISE FND_API.G_EXC_ERROR;
403: END IF;
404:
405: l_sum := l_sum + p_weighting_tbl(i);
406: END LOOP;

Line 412: RAISE FND_API.G_EXC_ERROR;

408:
409: IF l_sum <> 100 THEN
410: PA_UTILS.Add_Message (p_app_short_name => 'PA',
411: p_msg_name => 'PA_INCORRECT_SUM');
412: RAISE FND_API.G_EXC_ERROR;
413: END IF;
414:
415: IF FND_MSG_PUB.Count_Msg > 0 THEN -- One or more roles are invalid
416: RAISE FND_API.G_EXC_ERROR;

Line 416: RAISE FND_API.G_EXC_ERROR;

412: RAISE FND_API.G_EXC_ERROR;
413: END IF;
414:
415: IF FND_MSG_PUB.Count_Msg > 0 THEN -- One or more roles are invalid
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:
419: FOR i IN 1..l_role_id_tbl.count LOOP
420: FOR j IN i+1..l_role_id_tbl.count LOOP

Line 424: RAISE FND_API.G_EXC_ERROR;

420: FOR j IN i+1..l_role_id_tbl.count LOOP
421: IF l_role_id_tbl(i) = l_role_id_tbl(j) THEN
422: PA_UTILS.Add_Message (p_app_short_name => 'PA',
423: p_msg_name => 'PA_DUPLICATE_ROLES');
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: END LOOP;
427: END LOOP;
428:

Line 432: WHEN FND_API.G_EXC_ERROR THEN

428:
429: x_role_id_tbl := l_role_id_tbl;
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: x_msg_count := FND_MSG_PUB.Count_Msg;
435: WHEN OTHERS THEN
436: RAISE;

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: x_role_id_tbl := l_role_id_tbl;
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: x_msg_count := FND_MSG_PUB.Count_Msg;
435: WHEN OTHERS THEN
436: RAISE;
437: END Validate_Profile_Lines;