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

Line 161: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

157: EXCEPTION
158: WHEN OTHERS THEN
159: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
160: x_period_name := NULL ;
161: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
162: x_msg_count := 1;
163: x_msg_data := SQLERRM;
164:
165: Fnd_Msg_Pub.add_exc_msg

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: -- and pfxat.calendar_type (+) = 'A'
209: order by ppru.as_of_date desc;
210:
211: BEGIN
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: l_wp_versioN_id := pa_project_structure_utils.GET_LATEST_WP_VERSION(p_object_id);
215: IF l_wp_version_id IS NULL THEN
216: --no publish version; return 0;

Line 228: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

224: EXCEPTION
225: WHEN OTHERS THEN
226: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
227: x_period_name := NULL ;
228: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
229: x_msg_count := 1;
230: x_msg_data := SQLERRM;
231:
232: Fnd_Msg_Pub.add_exc_msg

Line 283: x_return_status := FND_API.G_RET_STS_SUCCESS;

279: -- and pfxat.calendar_type (+) = 'A'
280: order by ppru.as_of_date desc;
281:
282: BEGIN
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: l_wp_versioN_id := pa_project_structure_utils.GET_LATEST_WP_VERSION(p_object_id);
286: IF l_wp_version_id IS NULL THEN
287: --no publish version; return 0;

Line 299: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

295: EXCEPTION
296: WHEN OTHERS THEN
297: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
298: x_period_name := NULL ;
299: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
300: x_msg_count := 1;
301: x_msg_data := SQLERRM;
302:
303: Fnd_Msg_Pub.add_exc_msg

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS;

336:
337: l_value1 NUMBER;
338: l_value2 NUMBER;
339: BEGIN
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341:
342: l_wp_versioN_id := pa_project_structure_utils.GET_LATEST_WP_VERSION(p_object_id);
343: IF l_wp_version_id IS NULL THEN
344: --no publish version; return 0;

Line 368: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

364: EXCEPTION
365: WHEN OTHERS THEN
366: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
367: x_period_name := NULL ;
368: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
369: x_msg_count := 1;
370: x_msg_data := SQLERRM;
371:
372: Fnd_Msg_Pub.add_exc_msg

Line 401: x_return_status := FND_API.G_RET_STS_SUCCESS;

397: where project_id = p_object_id;
398: l_b_fin DATE;
399: l_s_fin DATE;
400: BEGIN
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:
403: OPEN c1;
404: FETCH c1 into l_b_fin, l_s_fin;
405: CLOSE c1;

Line 417: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

413: EXCEPTION
414: WHEN OTHERS THEN
415: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
416: x_period_name := NULL ;
417: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
418: x_msg_count := 1;
419: x_msg_data := SQLERRM;
420:
421: Fnd_Msg_Pub.add_exc_msg

Line 450: x_return_status := FND_API.G_RET_STS_SUCCESS;

446: where project_id = p_object_id;
447: l_b_st DATE;
448: l_s_st DATE;
449: BEGIN
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451:
452: OPEN c1;
453: FETCH c1 into l_b_st, l_s_st;
454: CLOSE c1;

Line 466: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

462: EXCEPTION
463: WHEN OTHERS THEN
464: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
465: x_period_name := NULL ;
466: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
467: x_msg_count := 1;
468: x_msg_data := SQLERRM;
469:
470: Fnd_Msg_Pub.add_exc_msg

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

506:
507: l_sch_date1 DATE;
508: l_sch_date2 DATE;
509: BEGIN
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511:
512: open C1;
513: FETCH c1 into l_sch_date1;
514: IF c1%NOTFOUND THEN

Line 531: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

527: EXCEPTION
528: WHEN OTHERS THEN
529: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
530: x_period_name := NULL ;
531: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
532: x_msg_count := 1;
533: x_msg_data := SQLERRM;
534:
535: Fnd_Msg_Pub.add_exc_msg

Line 575: x_return_status := FND_API.G_RET_STS_SUCCESS;

571:
572: l_sch_date1 DATE;
573: l_sch_date2 DATE;
574: BEGIN
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: open C1;
578: FETCH c1 into l_sch_date1;
579: IF c1%NOTFOUND THEN

Line 596: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

592: EXCEPTION
593: WHEN OTHERS THEN
594: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
595: x_period_name := NULL ;
596: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
597: x_msg_count := 1;
598: x_msg_data := SQLERRM;
599:
600: Fnd_Msg_Pub.add_exc_msg

Line 640: x_return_status := FND_API.G_RET_STS_SUCCESS;

636:
637: l_sch_date DATE;
638: l_est_date DATE;
639: BEGIN
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: open C1;
643: FETCH c1 into l_sch_date, l_est_date;
644: IF c1%NOTFOUND THEN

Line 655: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

651: EXCEPTION
652: WHEN OTHERS THEN
653: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
654: x_period_name := NULL ;
655: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
656: x_msg_count := 1;
657: x_msg_data := SQLERRM;
658:
659: Fnd_Msg_Pub.add_exc_msg

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695:
696: l_sch_date DATE;
697: l_est_date DATE;
698: BEGIN
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: open C1;
702: FETCH c1 into l_sch_date, l_est_date;
703: IF c1%NOTFOUND THEN

Line 714: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

710: EXCEPTION
711: WHEN OTHERS THEN
712: x_measure_value := 0 ; -- Setting this value to zero ,not NULL for issue mentioned in 3842408
713: x_period_name := NULL ;
714: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
715: x_msg_count := 1;
716: x_msg_data := SQLERRM;
717:
718: Fnd_Msg_Pub.add_exc_msg