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

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
58: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
59:
60: BEGIN
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: /* Checking for the empty table of record */
64: -- IF (p_sch_except_record_tab.count = 0 ) THEN
65: -- raise l_empty_tab_record;

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

166: EXCEPTION
167: WHEN l_empty_tab_record THEN
168: NULL;
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
172: p_procedure_name => 'insert_rows');
173: raise;
174:

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: l_t_schedule_exception_id NUMBER;
234: BEGIN
235: /* 1799636 following line of code was commented to enhance the performance */
236: -- l_t_schedule_exception_id := get_nextval;
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: /*Bug 5854571: Added following for inserting l_t_schedule_exception_id
240: as schedule_exception_id into PA_SCHEDULE_EXCEPTIONS */
241: SELECT pa_schedule_exceptions_s.nextval

Line 313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

309: x_exception_id := l_t_schedule_exception_id;
310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
315: p_procedure_name => 'insert_rows');
316: raise;
317:

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
360:
361: BEGIN
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: /* Checking for the empty table of record */
366: IF (p_sch_except_record_tab.count = 0 ) THEN
367: raise l_empty_tab_record;

Line 436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

432: EXCEPTION
433: WHEN l_empty_tab_record THEN
434: NULL;
435: WHEN OTHERS THEN
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
438: p_procedure_name => 'update_rows');
439: raise;
440:

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

501: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
502: IS
503: BEGIN
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: UPDATE PA_SCHEDULE_EXCEPTIONS
508: SET
509: calendar_id = p_calendar_id,

Line 541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

537:
538:
539: EXCEPTION
540: WHEN OTHERS THEN
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
543: p_procedure_name => 'update_rows');
544: raise;
545:

Line 606: x_return_status := FND_API.G_RET_STS_SUCCESS;

602: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
603: IS
604: BEGIN
605:
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: UPDATE PA_SCHEDULE_EXCEPTIONS
609: SET
610: calendar_id = p_calendar_id,

Line 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

638:
639:
640: EXCEPTION
641: WHEN OTHERS THEN
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
644: p_procedure_name => 'update_rows');
645: raise;
646:

Line 664: x_return_status := FND_API.G_RET_STS_SUCCESS;

660: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
661:
662: BEGIN
663:
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: /* Checking for the empty table of record */
667: IF (p_sch_except_record_tab.count = 0 ) THEN
668: raise l_empty_tab_record;

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

677: DELETE FROM PA_SCHEDULE_EXCEPTIONS WHERE schedule_exception_id = l_schedule_exception_id(l_J);
678:
679: EXCEPTION
680: WHEN OTHERS THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
683: p_procedure_name => 'delete_rows');
684: raise;
685:

Line 702: x_return_status := FND_API.G_RET_STS_SUCCESS;

698: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
699: IS
700: BEGIN
701:
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: DELETE
705: FROM PA_SCHEDULE_EXCEPTIONS
706: WHERE schedule_exception_id = p_schedule_exception_id;

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: WHERE schedule_exception_id = p_schedule_exception_id;
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
712: p_procedure_name => 'delete_rows');
713: raise;
714:

Line 731: x_return_status := FND_API.G_RET_STS_SUCCESS;

727: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
728: IS
729: BEGIN
730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:
733: DELETE
734: FROM PA_SCHEDULE_EXCEPTIONS
735: WHERE rowid = p_exceptrowid;

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

735: WHERE rowid = p_exceptrowid;
736:
737: EXCEPTION
738: WHEN OTHERS THEN
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCH_EXCEPT_PKG',
741: p_procedure_name => 'delete_rows');
742: raise;
743: