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

Line 77: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;

73:
74: --Added for bug Bug 5684828
75: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
76: l_out_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
77: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
78:
79: --Added for bug 5856987
80: K NUMBER;
81:

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81:
82:
83: BEGIN
84:
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: /* Checking for the empty table of record */
88: IF (p_sch_record_tab.count = 0 ) THEN
89: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... before return ... ');

Line 453: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

449: PA_SCHEDULE_UTILS.log_message(1, 'Insert_Row After apply_other_changes ....' || l_x_return_status);
450: PA_SCHEDULE_UTILS.log_message(1,'l_out_sch_rec_tab (change ) : ',l_out_sch_rec_tab );
451:
452:
453: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
454:
455: IF l_out_sch_rec_tab.count < p_sch_record_tab.COUNT THEN
456: -- This condition will not happen since apply_other_changes will only append the change_type_code = D it will
457: -- not delete any record from p_sch_record_tab pl/sql table while generating l_out_sch_rec_tab

Line 460: RAISE FND_API.G_EXC_ERROR;

456: -- This condition will not happen since apply_other_changes will only append the change_type_code = D it will
457: -- not delete any record from p_sch_record_tab pl/sql table while generating l_out_sch_rec_tab
458: -- This has only been placed for debugging purposes in future to trap the error point in apply_other_changes
459: PA_SCHEDULE_UTILS.log_message(1,'apply_other_changes retuned less count ');
460: RAISE FND_API.G_EXC_ERROR;
461: ELSE
462: --Added for bug 5856987
463: l_schedule_id.delete;
464: l_calendar_id.delete;

Line 513: RAISE FND_API.G_EXC_ERROR;

509: END LOOP;
510: END IF;
511: ELSE
512: PA_SCHEDULE_UTILS.log_message(1,'l_x_return_status is not success ');
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: --- End of bug 5684828
516:
517:

Line 580: WHEN FND_API.G_EXC_ERROR THEN --Added for bug 5684828

576:
577: PA_SCHEDULE_UTILS.log_message(1,'end of the schedule inser row .... ');
578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN --Added for bug 5684828
581: x_return_status := l_x_return_status;
582: WHEN l_empty_tab_record THEN
583: NULL;
584: WHEN OTHERS THEN

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

581: x_return_status := l_x_return_status;
582: WHEN l_empty_tab_record THEN
583: NULL;
584: WHEN OTHERS THEN
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
587: p_procedure_name => 'insert_rows');
588: raise;
589:

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: BEGIN
633: /* 1799636 The following line of code was commented to resolve the performance issue */
634: -- l_t_schedule_id := get_nextval;
635:
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638: INSERT INTO PA_SCHEDULES
639: ( schedule_id ,
640: calendar_id ,

Line 696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

692: trunc(sysdate) );
693:
694: EXCEPTION
695: WHEN OTHERS THEN
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
698: p_procedure_name => 'insert_rows');
699: raise;
700:

Line 732: x_return_status := FND_API.G_RET_STS_SUCCESS;

728: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
729: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
730:
731: BEGIN
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: PA_SCHEDULE_UTILS.log_message(1,'start of the schedule inser row .... ');
735: if ( p_sch_record_tab.count = 0 ) then
736: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');

Line 793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

789: EXCEPTION
790: WHEN l_empty_tab_record THEN
791: NULL;
792: WHEN OTHERS THEN
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
795: p_procedure_name => 'update_rows');
796: raise;
797:

Line 843: x_return_status := FND_API.G_RET_STS_SUCCESS;

839: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
840: IS
841: BEGIN
842:
843: x_return_status := FND_API.G_RET_STS_SUCCESS;
844: UPDATE PA_SCHEDULES
845: SET
846: calendar_id = p_calendar_id,
847: assignment_id = p_assignment_id,

Line 868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

864:
865:
866: EXCEPTION
867: WHEN OTHERS THEN
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
870: p_procedure_name => 'update_rows');
871: raise;
872:

Line 917: x_return_status := FND_API.G_RET_STS_SUCCESS;

913: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
914: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
915: IS
916: BEGIN
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918:
919: UPDATE PA_SCHEDULES
920: SET
921: calendar_id = p_calendar_id,

Line 943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

939:
940:
941: EXCEPTION
942: WHEN OTHERS THEN
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
945: p_procedure_name => 'update_rows');
946: raise;
947:

Line 964: x_return_status := FND_API.G_RET_STS_SUCCESS;

960: IS
961: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
962:
963: BEGIN
964: x_return_status := FND_API.G_RET_STS_SUCCESS;
965:
966: PA_SCHEDULE_UTILS.log_message(1,'start of the delete row ..... ');
967: if ( p_sch_record_tab.count = 0 ) then
968: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');

Line 986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

982: EXCEPTION
983: WHEN l_empty_tab_record THEN
984: NULL;
985: WHEN OTHERS THEN
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
988: p_procedure_name => 'delete_rows');
989: raise;
990:

Line 1007: x_return_status := FND_API.G_RET_STS_SUCCESS;

1003: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
1004: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1005: IS
1006: BEGIN
1007: x_return_status := FND_API.G_RET_STS_SUCCESS;
1008:
1009: DELETE
1010: FROM PA_SCHEDULES
1011: WHERE schedule_id = p_schedule_id;

Line 1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1011: WHERE schedule_id = p_schedule_id;
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1016: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
1017: p_procedure_name => 'delete_rows');
1018: raise;
1019:

Line 1035: x_return_status := FND_API.G_RET_STS_SUCCESS;

1031: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
1032: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1033: IS
1034: BEGIN
1035: x_return_status := FND_API.G_RET_STS_SUCCESS;
1036:
1037: DELETE
1038: FROM PA_SCHEDULES
1039: WHERE rowid = p_schrowid ;

Line 1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1039: WHERE rowid = p_schrowid ;
1040:
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
1045: p_procedure_name => 'delete_rows');
1046: raise;
1047: