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

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47:
48: -- Clear the global PL/SQL message table
49: FND_MSG_PUB.initialize;
50:
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: IF p_effective_end_date IS NOT NULL THEN
54: IF p_effective_start_date > p_effective_end_date THEN
55: pa_utils.add_message (p_app_short_name => 'PA',

Line 57: RAISE FND_API.G_EXC_ERROR;

53: IF p_effective_end_date IS NOT NULL THEN
54: IF p_effective_start_date > p_effective_end_date THEN
55: pa_utils.add_message (p_app_short_name => 'PA',
56: p_msg_name => 'PA_INVALID_ASGMT_DATES');
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59: END IF;
60:
61: PA_ROLE_PROFILES_UTILS.Check_Business_Level_Attrs

Line 78: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

74: x_return_status => l_return_status,
75: x_msg_count => x_msg_count,
76: x_msg_data => x_msg_data ) ;
77:
78: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81:
82: --Next, validate profile lines

Line 79: RAISE FND_API.G_EXC_ERROR;

75: x_msg_count => x_msg_count,
76: x_msg_data => x_msg_data ) ;
77:
78: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81:
82: --Next, validate profile lines
83:

Line 93: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

89: x_return_status => l_return_status,
90: x_msg_count => x_msg_count,
91: x_msg_data => x_msg_data );
92:
93: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: --dbms_output.put_line ('l_business_group_id ' || l_business_group_id);

Line 94: RAISE FND_API.G_EXC_ERROR;

90: x_msg_count => x_msg_count,
91: x_msg_data => x_msg_data );
92:
93: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: --dbms_output.put_line ('l_business_group_id ' || l_business_group_id);
98: --dbms_output.put_line ('l_org_id ' || l_organization_id);

Line 119: RAISE FND_API.G_EXC_ERROR;

115: AND rownum = 1;
116:
117: pa_utils.add_message (p_app_short_name => 'PA',
118: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
119: RAISE FND_API.G_EXC_ERROR;
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: null;
123: END;

Line 140: RAISE FND_API.G_EXC_ERROR;

136: AND NVL(TRUNC(effective_end_date), TRUNC(effective_start_date));
137:
138: pa_utils.add_message (p_app_short_name => 'PA',
139: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
140: RAISE FND_API.G_EXC_ERROR;
141:
142: EXCEPTION
143: WHEN NO_DATA_FOUND THEN
144: --dbms_output.put_line ('1.0');

Line 210: WHEN FND_API.G_EXC_ERROR THEN

206:
207: -- pa_role_profile_lines table does not need sequence
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: x_msg_count := FND_MSG_PUB.Count_Msg;
213:
214: IF x_msg_count = 1 THEN

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: -- pa_role_profile_lines table does not need sequence
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: x_msg_count := FND_MSG_PUB.Count_Msg;
213:
214: IF x_msg_count = 1 THEN
215: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

Line 215: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

211: x_return_status := FND_API.G_RET_STS_ERROR;
212: x_msg_count := FND_MSG_PUB.Count_Msg;
213:
214: IF x_msg_count = 1 THEN
215: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
216: p_msg_index => 1,
217: p_data => x_msg_data,
218: p_msg_index_out => l_msg_index_out );
219: END IF;

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

268:
269: -- Clear the global PL/SQL message table
270: FND_MSG_PUB.initialize;
271:
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: IF p_effective_end_date IS NOT NULL THEN
275: IF p_effective_start_date > p_effective_end_date THEN
276: pa_utils.add_message (p_app_short_name => 'PA',

Line 278: RAISE FND_API.G_EXC_ERROR;

274: IF p_effective_end_date IS NOT NULL THEN
275: IF p_effective_start_date > p_effective_end_date THEN
276: pa_utils.add_message (p_app_short_name => 'PA',
277: p_msg_name => 'PA_INVALID_ASGMT_DATES');
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: END IF;
281:
282: PA_ROLE_PROFILES_UTILS.Check_Business_Level_Attrs

Line 299: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

295: x_return_status => l_return_status,
296: x_msg_count => x_msg_count,
297: x_msg_data => x_msg_data ) ;
298:
299: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:
303: --Next, validate profile lines

Line 300: RAISE FND_API.G_EXC_ERROR;

296: x_msg_count => x_msg_count,
297: x_msg_data => x_msg_data ) ;
298:
299: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:
303: --Next, validate profile lines
304:

Line 314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

310: x_return_status => l_return_status,
311: x_msg_count => x_msg_count,
312: x_msg_data => x_msg_data );
313:
314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: --dbms_output.put_line ('l_business_group_id ' || l_business_group_id);

Line 315: RAISE FND_API.G_EXC_ERROR;

311: x_msg_count => x_msg_count,
312: x_msg_data => x_msg_data );
313:
314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: --dbms_output.put_line ('l_business_group_id ' || l_business_group_id);
319: --dbms_output.put_line ('l_org_id ' || l_organization_id);

Line 341: RAISE FND_API.G_EXC_ERROR;

337: AND rownum = 1;
338:
339: pa_utils.add_message (p_app_short_name => 'PA',
340: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
341: RAISE FND_API.G_EXC_ERROR;
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN
344: null;
345: END;

Line 363: RAISE FND_API.G_EXC_ERROR;

359: AND profile_id <> p_profile_id;
360:
361: pa_utils.add_message (p_app_short_name => 'PA',
362: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
363: RAISE FND_API.G_EXC_ERROR;
364:
365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN
367: --dbms_output.put_line ('1.0');

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435:
436: -- pa_role_profile_lines table does not need sequence
437:
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_msg_count := FND_MSG_PUB.Count_Msg;
442:
443: IF x_msg_count = 1 THEN

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: -- pa_role_profile_lines table does not need sequence
437:
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_msg_count := FND_MSG_PUB.Count_Msg;
442:
443: IF x_msg_count = 1 THEN
444: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

Line 444: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_msg_count := FND_MSG_PUB.Count_Msg;
442:
443: IF x_msg_count = 1 THEN
444: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
445: p_msg_index => 1,
446: p_data => x_msg_data,
447: p_msg_index_out => l_msg_index_out );
448: END IF;

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

458:
459: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
460:
461: BEGIN
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: x_msg_count := 0;
464: x_msg_data := null;
465:
466: DELETE FROM pa_role_profiles

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

469: DELETE FROM pa_role_profile_lines
470: WHERE profile_id = p_profile_id;
471: EXCEPTION
472: WHEN OTHERS THEN
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: RAISE;
475: End Delete_Profile;
476:
477: PROCEDURE Create_Profile_for_Resource

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS;

525:
526: c1 cur%ROWTYPE;
527:
528: BEGIN
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530:
531: FOR c1 in cur LOOP
532: --dbms_output.put_line ('profile_id: ' || c1.profile_id);
533: --dbms_output.put_line ('profile_weighting: ' || c1.weight);