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

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39:
40: BEGIN
41:
42: -- Initialize the return status to success
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: --Log Message
46: IF l_enable_log = 'Y' THEN
47: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set.begin'

Line 62: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

58: x_return_status => l_return_status,
59: x_error_msg_code => l_msg_data);
60: END IF;
61:
62: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
63: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
64: ,p_msg_name => l_msg_data);
65: END IF;
66:

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123: ,x_log_level => 5);
124: END IF;
125:
126: IF FND_MSG_PUB.Count_Msg > 0 THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: END IF;
129:
130: EXCEPTION
131: WHEN OTHERS THEN

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

133: -- Set the excetption Message and the stack
134: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Create_Project_Set'
135: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
136: --
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138:
139: -- Start : RESET other OUT param too : 4537865
140: x_project_set_id := NULL ;
141: -- ENd : 4537865

Line 187: x_return_status := FND_API.G_RET_STS_SUCCESS;

183:
184: BEGIN
185:
186: -- Initialize the return status to success
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: --Log Message
190: IF l_enable_log = 'Y' THEN
191: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Update_Project_Set.begin'

Line 207: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

203: x_return_status => l_return_status,
204: x_error_msg_code => l_msg_data);
205: END IF;
206:
207: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
208: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
209: ,p_msg_name => l_msg_data);
210: END IF;
211:

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260:
261: END IF;
262:
263: IF FND_MSG_PUB.Count_Msg > 0 THEN
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: END IF;
266:
267: EXCEPTION
268: WHEN OTHERS THEN

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

270: -- Set the excetption Message and the stack
271: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Update_Project_Set'
272: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
273: --
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: --RAISE;
276:
277: END Update_Project_Set;
278:

Line 294: x_return_status := FND_API.G_RET_STS_SUCCESS;

290:
291: BEGIN
292:
293: -- Initialize the return status to success
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: --Log Message
297: IF l_enable_log = 'Y' THEN
298: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set'

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329:
330: END IF;
331:
332: IF FND_MSG_PUB.Count_Msg > 0 THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335:
336: EXCEPTION
337: WHEN OTHERS THEN

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

339: -- Set the excetption Message and the stack
340: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Delete_Project_Set'
341: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
342: --
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
344: --RAISE;
345:
346: END Delete_Project_Set;
347:

Line 364: x_return_status := FND_API.G_RET_STS_SUCCESS;

360:
361: BEGIN
362:
363: -- Initialize the return status to success
364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: --Log Message
367: IF l_enable_log = 'Y' THEN
368: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set_Line.begin'

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392: EXCEPTION
393: WHEN e_row_is_locked THEN
394: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
395: ,p_msg_name => 'PA_PROJECT_SET_LOCKED');
396: x_return_status := FND_API.G_RET_STS_ERROR;
397:
398: WHEN OTHERS THEN
399: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.create_project_set_line'
400: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

397:
398: WHEN OTHERS THEN
399: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.create_project_set_line'
400: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: RAISE;
403:
404: END create_project_set_line;
405:

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
416: BEGIN
417:
418: -- Initialize the return status to success
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: --Log Message
422: IF l_enable_log = 'Y' THEN
423: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set_Line.begin'

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

446: ,p_procedure_name => 'Delete_Project_Set_line',
447: p_error_text => SUBSTRB(SQLERRM,1,120)
448: );
449: --
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: -- Not RAISING because caller doesnt expect a RAISE
452:
453: END delete_project_set_line;
454:

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

458: )
459: IS
460: BEGIN
461: -- Initialize the return status to success
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463:
464: DELETE FROM pa_project_set_lines
465: WHERE project_id = p_project_id;
466:

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

469: -- Set the exception Message and the stack
470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_project_from_project_sets'
471: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
472:
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: RAISE;
475:
476: END delete_proj_from_proj_set;
477: