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

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24:
25: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
26:
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: INSERT INTO pa_role_profiles
31: (profile_id,
32: profile_name,

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

68: WHEN OTHERS THEN -- catch the exceptins here
69: -- Set the exception Message and the stack
70: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row1'
71: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE;
74: END Insert_Row1;
75:
76:

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89:
90: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
91:
92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: INSERT INTO pa_role_profile_lines
96: (profile_id,
97: project_role_id,

Line 117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

113: WHEN OTHERS THEN -- catch the exceptins here
114: -- Set the exception Message and the stack
115: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row2'
116: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
118: RAISE;
119: END Insert_Row2;
120:
121:

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143:
144: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
145:
146: BEGIN
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: UPDATE pa_role_profiles SET
150: profile_name = p_profile_name,
151: description = p_description,

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

165: WHEN OTHERS THEN -- catch the exceptins here
166: -- Set the exception Message and the stack
167: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Update_Row'
168: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: RAISE;
171: END Update_Row;
172:
173:

Line 196: p_commit IN VARCHAR2 := FND_API.G_FALSE,

192: p_effective_end_date IN DATE := NULL,
193: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
194: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
195: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: x_return_status OUT VARCHAR2,
198: x_msg_count OUT NUMBER,
199: x_msg_data OUT VARCHAR2)
200: IS

Line 232: IF (p_commit = FND_API.G_TRUE) THEN

228: -- Clear the global PL/SQL message table
229: FND_MSG_PUB.initialize;
230:
231: -- Issue API savepoint if the transaction is to be committed
232: IF (p_commit = FND_API.G_TRUE) THEN
233: SAVEPOINT ROLE_PUB_ADD_RES_PRF;
234: END IF;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: IF (p_commit = FND_API.G_TRUE) THEN
233: SAVEPOINT ROLE_PUB_ADD_RES_PRF;
234: END IF;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:
238: -------------------------------------------------------------------
239: -- Validate Resource Profile (any conflicting profile?)
240: -------------------------------------------------------------------

Line 249: RAISE FND_API.G_EXC_ERROR;

245: IF is_conflict_profile_csr%FOUND THEN
246: dbms_output.put_line('corsor found');
247: pa_utils.add_message (p_app_short_name => 'PA',
248: p_msg_name => 'PA_DATE_CONFLICT');
249: RAISE FND_API.G_EXC_ERROR;
250: END IF;
251: CLOSE is_conflict_profile_csr;
252:
253: dbms_output.put_line('corsor found passed');

Line 265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

261: p_weighting_tbl => p_weighting_tbl,
262: x_role_id_tbl => l_role_id_tbl,
263: x_return_status => l_return_status);
264:
265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268: dbms_output.put_line('Validate_Profile_Lines passed');
269:

Line 266: RAISE FND_API.G_EXC_ERROR;

262: x_role_id_tbl => l_role_id_tbl,
263: x_return_status => l_return_status);
264:
265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268: dbms_output.put_line('Validate_Profile_Lines passed');
269:
270: -------------------------------------------------------------------

Line 333: WHEN FND_API.G_EXC_ERROR THEN

329: -------------------------------------------------------------------
330: -- Exceptions
331: -------------------------------------------------------------------
332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_msg_count := FND_MSG_PUB.Count_Msg;
336: IF x_msg_count = 1 THEN
337: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330: -- Exceptions
331: -------------------------------------------------------------------
332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_msg_count := FND_MSG_PUB.Count_Msg;
336: IF x_msg_count = 1 THEN
337: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
338: p_msg_index => 1,

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

333: WHEN FND_API.G_EXC_ERROR THEN
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_msg_count := FND_MSG_PUB.Count_Msg;
336: IF x_msg_count = 1 THEN
337: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
338: p_msg_index => 1,
339: p_data => x_msg_data,
340: p_msg_index_out => l_msg_index_out );
341: END IF;

Line 344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

340: p_msg_index_out => l_msg_index_out );
341: END IF;
342: WHEN OTHERS THEN
343: dbms_output.put_line('other error');
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: x_msg_data := SQLERRM;
346: IF p_commit = FND_API.G_TRUE THEN
347: ROLLBACK TO ROLE_PUB_ADD_RES_PRF;
348: END IF;

Line 346: IF p_commit = FND_API.G_TRUE THEN

342: WHEN OTHERS THEN
343: dbms_output.put_line('other error');
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: x_msg_data := SQLERRM;
346: IF p_commit = FND_API.G_TRUE THEN
347: ROLLBACK TO ROLE_PUB_ADD_RES_PRF;
348: END IF;
349:
350: -- Set the exception Message and the stack

Line 374: p_commit IN VARCHAR2 := FND_API.G_FALSE,

370: p_effective_end_date IN DATE := NULL,
371: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
372: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
373: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
374: p_commit IN VARCHAR2 := FND_API.G_FALSE,
375: x_return_status OUT VARCHAR2,
376: x_msg_count OUT NUMBER,
377: x_msg_data OUT VARCHAR2)
378: IS

Line 411: IF (p_commit = FND_API.G_TRUE) THEN

407: -- Clear the global PL/SQL message table
408: FND_MSG_PUB.initialize;
409:
410: -- Issue API savepoint if the transaction is to be committed
411: IF (p_commit = FND_API.G_TRUE) THEN
412: SAVEPOINT ROLE_PUB_UPD_RES_PRF;
413: END IF;
414:
415: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 415: x_return_status := FND_API.G_RET_STS_SUCCESS;

411: IF (p_commit = FND_API.G_TRUE) THEN
412: SAVEPOINT ROLE_PUB_UPD_RES_PRF;
413: END IF;
414:
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: -------------------------------------------------------------------
418: -- Validate Resource Profile (start_date, end_date)
419: -------------------------------------------------------------------

Line 427: RAISE FND_API.G_EXC_ERROR;

423:
424: IF is_conflict_profile_csr%FOUND THEN
425: pa_utils.add_message (p_app_short_name => 'PA',
426: p_msg_name => 'PA_DATE_CONFLICT');
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429: CLOSE is_conflict_profile_csr;
430:
431: -------------------------------------------------------------------

Line 441: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

437: p_weighting_tbl => p_weighting_tbl,
438: x_role_id_tbl => l_role_id_tbl,
439: x_return_status => l_return_status);
440:
441: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: -------------------------------------------------------------------

Line 442: RAISE FND_API.G_EXC_ERROR;

438: x_role_id_tbl => l_role_id_tbl,
439: x_return_status => l_return_status);
440:
441: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: -------------------------------------------------------------------
446: -- Start Workflow

Line 492: WHEN FND_API.G_EXC_ERROR THEN

488: -------------------------------------------------------------------
489: -- Exceptions
490: -------------------------------------------------------------------
491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_msg_count := FND_MSG_PUB.Count_Msg;
495: IF x_msg_count = 1 THEN
496: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489: -- Exceptions
490: -------------------------------------------------------------------
491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_msg_count := FND_MSG_PUB.Count_Msg;
495: IF x_msg_count = 1 THEN
496: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
497: p_msg_index => 1,

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

492: WHEN FND_API.G_EXC_ERROR THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_msg_count := FND_MSG_PUB.Count_Msg;
495: IF x_msg_count = 1 THEN
496: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
497: p_msg_index => 1,
498: p_data => x_msg_data,
499: p_msg_index_out => l_msg_index_out );
500: END IF;

Line 502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

498: p_data => x_msg_data,
499: p_msg_index_out => l_msg_index_out );
500: END IF;
501: WHEN OTHERS THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
503: x_msg_data := SQLERRM;
504: IF p_commit = FND_API.G_TRUE THEN
505: ROLLBACK TO ROLE_PUB_UPD_RES_PRF;
506: END IF;

Line 504: IF p_commit = FND_API.G_TRUE THEN

500: END IF;
501: WHEN OTHERS THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
503: x_msg_data := SQLERRM;
504: IF p_commit = FND_API.G_TRUE THEN
505: ROLLBACK TO ROLE_PUB_UPD_RES_PRF;
506: END IF;
507:
508: -- Set the exception Message and the stack