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

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: ;
34:
35: BEGIN
36:
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39:
40: --SELECT pa_object_page_versions_s.NEXTVAL
41: --INTO l_version_id

Line 111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

107:
108: EXCEPTION
109: WHEN OTHERS THEN -- catch the exceptions here
110: -- Set the current program unit name in the error stack
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: RAISE;
113:
114: end INSERT_PROGRESS_REPORT_VER_ROW;
115:

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
140: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
141: ) is
142: begin
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: --debug_msg ('before update ');
146: --debug_msg ('before update ' || To_char (p_version_id));
147:

Line 161: overview = decode(p_overview,FND_API.G_MISS_CHAR,null,nvl(p_overview,overview)), -- Bug 3877982

157: report_start_date =Nvl(p_report_start_date, report_start_date) ,
158: report_end_date =Nvl(p_report_end_date, report_end_date),
159: reported_by =Nvl(p_reported_by, reported_by),
160: progress_status_code =Nvl(p_progress_status, progress_status_code),
161: overview = decode(p_overview,FND_API.G_MISS_CHAR,null,nvl(p_overview,overview)), -- Bug 3877982
162: -- overview=Nvl(p_overview,overview),
163: current_flag =Nvl(p_current_flag, current_flag),
164: published_date=Nvl(p_published_date, published_date),
165: comments =Nvl(p_comments, comments),

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: --debug_msg ('after update ');
177: if (sql%notfound) THEN
178: -- debug_msg ('failed after update ');
179: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: end if;
182:
183: EXCEPTION
184: WHEN OTHERS THEN -- catch the exceptins here

Line 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

182:
183: EXCEPTION
184: WHEN OTHERS THEN -- catch the exceptins here
185: -- Set the current program unit name in the error stack
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: RAISE;
188: end UPDATE_PROGRESS_REPORT_VER_ROW;
189:
190:

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
199: ) is
200: begin
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: delete from PA_PROGRESS_REPORT_VERS
205: where VERSION_ID = p_version_id AND record_version_number = nvl(p_record_version_number, record_version_number);
206:

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

207: EXCEPTION
208: WHEN OTHERS THEN
209: -- Set the current program unit name in the error stack
210:
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
212: RAISE;
213:
214: end DELETE_PROGRESS_REPORT_VER_ROW;
215:

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: and RECORD_SEQUENCE = L_RECORD_SEQUENCE;
276:
277: BEGIN
278:
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280:
281:
282: insert into PA_PROGRESS_REPORT_VALS (
283: VERSION_ID,

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

397: EXCEPTION
398: WHEN OTHERS THEN -- catch the exceptions here
399: -- Set the current program unit name in the error stack
400: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Insert_Row');
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: RAISE;
403:
404: end INSERT_PROGRESS_REPORT_VAL_ROW;
405:

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
456: ) is
457: begin
458:
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461:
462: --debug_msg ('***********update attribute 3: ' ||P_ATTRIBUTE3 );
463:

Line 521: x_return_status := FND_API.G_RET_STS_ERROR;

517: if (sql%notfound) THEN
518:
519: --debug_msg ('***********update failed');
520: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: end if;
523:
524: EXCEPTION
525: WHEN OTHERS THEN -- catch the exceptins here

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

523:
524: EXCEPTION
525: WHEN OTHERS THEN -- catch the exceptins here
526: -- Set the current program unit name in the error stack
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
528: RAISE;
529:
530: end UPDATE_PROGRESS_REPORT_VAL_ROW;
531:

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
542: ) is
543: begin
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: delete from PA_PROGRESS_REPORT_VALS
548: where VERSION_ID = P_VERSION_ID
549: and REGION_SOURCE_TYPE = P_REGION_SOURCE_TYPE

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

555: EXCEPTION
556: WHEN OTHERS THEN
557: -- Set the current program unit name in the error stack
558:
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: RAISE;
561:
562: end DELETE_PROGRESS_REPORT_VAL_ROW;
563:

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
570: ) is
571: begin
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575: delete from PA_PROGRESS_REPORT_VALS
576: where VERSION_ID = p_version_id;
577:

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

580: EXCEPTION
581: WHEN OTHERS THEN
582: -- Set the current program unit name in the error stack
583:
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585: RAISE;
586:
587: end DELETE_PROGRESS_REPORT_VALS;
588:

Line 600: x_return_status := FND_API.G_RET_STS_SUCCESS;

596: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
597: ) is
598: begin
599:
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: delete from PA_PROGRESS_REPORT_VALS
603: where VERSION_ID = p_version_id
604: AND region_source_type = p_region_source_type

Line 613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

609: EXCEPTION
610: WHEN OTHERS THEN
611: -- Set the current program unit name in the error stack
612:
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: RAISE;
615:
616: end DELETE_PROGRESS_REPORT_REGION;
617:

Line 656: x_return_status := FND_API.G_RET_STS_SUCCESS;

652: where object_Page_Layout_id = l_layout_id;
653:
654: BEGIN
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657:
658: --get the unique task id from the Oracle Sequence
659: SELECT pa_object_page_layouts_s.nextval
660: INTO l_layout_id

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

735:
736: EXCEPTION
737: WHEN OTHERS THEN -- catch the exceptions here
738: -- Set the current program unit name in the error stack
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: RAISE;
741:
742: end INSERT_OBJECT_PAGE_LAYOUT_ROW;
743:

Line 776: x_return_status := FND_API.G_RET_STS_SUCCESS;

772: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
773: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
774: ) is
775: begin
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777:
778: update PA_OBJECT_PAGE_LAYOUTS set
779: OBJECT_ID = Nvl(p_object_id, object_id),
780: OBJECT_TYPE = Nvl(p_object_type, object_type),

Line 811: x_return_status := FND_API.G_RET_STS_ERROR;

807: AND record_version_number = Nvl(p_record_version_number, record_version_number);
808:
809: if (sql%notfound) then
810: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: end if;
813:
814: EXCEPTION
815: WHEN OTHERS THEN -- catch the exceptins here

Line 817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

813:
814: EXCEPTION
815: WHEN OTHERS THEN -- catch the exceptins here
816: -- Set the current program unit name in the error stack
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
818: RAISE;
819: end UPDATE_OBJECT_PAGE_LAYOUT_ROW;
820:
821:

Line 832: x_return_status := FND_API.G_RET_STS_SUCCESS;

828: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
829: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
830: ) is
831: begin
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833:
834: DELETE FROM PA_OBJECT_PAGE_LAYOUTS
835: where object_ID = p_object_id
836: AND object_type = p_object_type;

Line 842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

838:
839: EXCEPTION
840: WHEN OTHERS THEN -- catch the exceptins here
841: -- Set the current program unit name in the error stack
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
843: RAISE;
844: end DELETE_OBJECT_PAGE_LAYOUTS;
845:
846: END PA_PROGRESS_REPORT_PKG;