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_PVT dependencies on PA_PROGRESS_REPORT_PVT

Line 1: package body PA_PROGRESS_REPORT_PVT as

1: package body PA_PROGRESS_REPORT_PVT as
2: /* $Header: PAPRRPVB.pls 120.3.12000000.2 2007/04/07 11:40:37 rthumma ship $ */
3:
4: PROCEDURE Create_REPORT_REGION
5: (

Line 84: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Create_Report_Region');

80:
81: BEGIN
82:
83: -- Initialize the Error Stack
84: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Create_Report_Region');
85:
86: -- Initialize the return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:

Line 234: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_Progress_Report_PVT.Create_Progress_Report'

230: ROLLBACK TO Create_Progress_Report;
231: END IF;
232: --
233: -- Set the excetption Message and the stack
234: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_Progress_Report_PVT.Create_Progress_Report'
235: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
236: --
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: RAISE; -- This is optional depending on the needs

Line 334: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Update_Report_Region');

330:
331: BEGIN
332:
333: -- Initialize the Error Stack
334: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Update_Report_Region');
335:
336: -- Initialize the return status to success
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338:

Line 543: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Update_Progress_Report'

539: ROLLBACK TO update_report_region;
540: END IF;
541: --
542: -- Set the excetption Message and the stack
543: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Update_Progress_Report'
544: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
545: --
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547: RAISE; -- This is optional depending on the needs

Line 601: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Update_Report_Region');

597:
598: BEGIN
599:
600: -- Initialize the Error Stack
601: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Update_Report_Region');
602:
603: -- Initialize the return status to success
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605:

Line 711: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROGRESS_Report_PVT.Delete_Progress_Report'

707: ROLLBACK TO Delete_Progress_Report;
708: END IF;
709:
710: -- Set the excetption Message and the stack
711: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROGRESS_Report_PVT.Delete_Progress_Report'
712: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
713: --
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
715: RAISE; -- This is optional depending on the needs

Line 796: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Cancel_Report');

792: where version_id = p_version_id;
793:
794: BEGIN
795: -- Initialize the Error Stack
796: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Cancel_Report');
797:
798: -- Initialize the return status to success
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800:

Line 942: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Cancel_Report'

938: ROLLBACK TO cancel_report;
939: END IF;
940: --
941: -- Set the excetption Message and the stack
942: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Cancel_Report'
943: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
944: --
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: RAISE; -- This is optional depending on the needs

Line 986: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Approve_Report');

982:
983:
984: BEGIN
985: -- Initialize the Error Stack
986: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Approve_Report');
987:
988: -- Initialize the return status to success
989: x_return_status := FND_API.G_RET_STS_SUCCESS;
990:

Line 1091: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Approve_Report'

1087: ROLLBACK TO approve_report;
1088: END IF;
1089: --
1090: -- Set the excetption Message and the stack
1091: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Approve_Report'
1092: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1093: --
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1095: RAISE; -- This is optional depending on the needs

Line 1136: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Approve_Report');

1132:
1133:
1134: BEGIN
1135: -- Initialize the Error Stack
1136: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Approve_Report');
1137:
1138: -- Initialize the return status to success
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;
1140:

Line 1242: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Reject_Report'

1238: ROLLBACK TO reject_report;
1239: END IF;
1240: --
1241: -- Set the excetption Message and the stack
1242: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Reject_Report'
1243: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1244: --
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1246: RAISE; -- This is optional depending on the needs

Line 1303: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.update_report_details');

1299:
1300:
1301: BEGIN
1302: -- Initialize the Error Stack
1303: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.update_report_details');
1304:
1305: -- Initialize the return status to success
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;
1307:

Line 1424: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.update_report_details'

1420: ROLLBACK TO update_report_details;
1421: END IF;
1422: --
1423: -- Set the excetption Message and the stack
1424: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.update_report_details'
1425: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1426: --
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1428: RAISE; -- This is optional depending on the needs

Line 1514: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.define_progress_report_setup');

1510:
1511: BEGIN
1512:
1513: -- Initialize the Error Stack
1514: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.define_progress_report_setup');
1515: -- Initialize the return status to success
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: l_object_page_layout_id := p_object_page_layout_id;

Line 1932: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.define_progress_report_setup'

1928: ROLLBACK TO define_progress_report_setup;
1929: END IF;
1930: --
1931: -- Set the excetption Message and the stack
1932: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.define_progress_report_setup'
1933: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1934: --
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1936: RAISE; -- This is optional depending on the needs

Line 2020: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Delete_Report');

2016:
2017:
2018: BEGIN
2019: -- Initialize the Error Stack
2020: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Delete_Report');
2021:
2022: -- Initialize the return status to success
2023: x_return_status := FND_API.G_RET_STS_SUCCESS;
2024:

Line 2149: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Delete_Report'

2145: ROLLBACK TO delete_report;
2146: END IF;
2147: --
2148: -- Set the excetption Message and the stack
2149: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Delete_Report'
2150: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2151: --
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2153: RAISE; -- This is optional depending on the needs

Line 2239: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Rework_Report');

2235: l_type VARCHAR2(80); /* bug 2447763 */
2236:
2237: BEGIN
2238: -- Initialize the Error Stack
2239: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Rework_Report');
2240:
2241: -- Initialize the return status to success
2242: x_return_status := FND_API.G_RET_STS_SUCCESS;
2243:

Line 2402: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Rework_Report'

2398: ROLLBACK TO rework_report;
2399: END IF;
2400: --
2401: -- Set the excetption Message and the stack
2402: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Rework_Report'
2403: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2404: --
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2406: RAISE; -- This is optional depending on the needs

Line 2491: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Publish_Report');

2487: l_object_page_layout_id NUMBER;
2488:
2489: BEGIN
2490: -- Initialize the Error Stack
2491: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Publish_Report');
2492:
2493: -- Initialize the return status to success
2494: x_return_status := FND_API.G_RET_STS_SUCCESS;
2495:

Line 2685: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Publish_Report'

2681: ROLLBACK TO publish_report;
2682:
2683: --
2684: -- Set the excetption Message and the stack
2685: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Publish_Report'
2686: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2687: --
2688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2689: RAISE; -- This is optional depending on the needs

Line 2752: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Submit_Report');

2748: AND project_status_code = 'PROGRESS_REPORT_SUBMITTED';
2749:
2750: BEGIN
2751: -- Initialize the Error Stack
2752: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Submit_Report');
2753:
2754: -- Initialize the return status to success
2755: x_return_status := FND_API.G_RET_STS_SUCCESS;
2756:

Line 2918: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Submit_Report'

2914: ROLLBACK TO submit_report;
2915:
2916: --
2917: -- Set the excetption Message and the stack
2918: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Submit_Report'
2919: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2920: --
2921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2922: RAISE; -- This is optional depending on the needs

Line 2983: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Change_Report_Status');

2979: --like 'PROGRESS_REPORT%'
2980:
2981: BEGIN
2982: -- Initialize the Error Stack
2983: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.Change_Report_Status');
2984:
2985: -- Initialize the return status to success
2986: x_return_status := FND_API.G_RET_STS_SUCCESS;
2987:

Line 3171: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Change_Report_Status'

3167: WHEN OTHERS THEN
3168:
3169: --
3170: -- Set the excetption Message and the stack
3171: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.Change_Report_Status'
3172: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3173: --
3174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3175: RAISE; -- This is optional depending on the needs

Line 3322: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.create_next_progress_report');

3318: l_call_setup VARCHAR2(1);
3319:
3320: BEGIN
3321: -- Initialize the Error Stack
3322: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.create_next_progress_report');
3323:
3324: -- Initialize the return status to success
3325: x_return_status := FND_API.G_RET_STS_SUCCESS;
3326:

Line 3706: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.create_next_progress_report'

3702: ROLLBACK TO create_next_progress_report;
3703: END IF;
3704: --
3705: -- Set the exception Message and the stack
3706: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.create_next_progress_report'
3707: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3708: --
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3710: RAISE; -- This is optional depending on the needs

Line 3765: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.update_project_perccomplete');

3761:
3762: BEGIN
3763:
3764: -- Initialize the Error Stack
3765: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PVT.update_project_perccomplete');
3766:
3767: -- Initialize the return status to success
3768: x_return_status := FND_API.G_RET_STS_SUCCESS;
3769:

Line 3889: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_Progress_Report_PVT.update_project_perccomplete'

3885: ROLLBACK TO update_project_perccomplete;
3886:
3887: --
3888: -- Set the excetption Message and the stack
3889: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_Progress_Report_PVT.update_project_perccomplete'
3890: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3891: --
3892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3893: RAISE; -- This is optional depending on the needs

Line 3952: l_module_name varchar2(100) := 'PA_PROGRESS_REPORT_PVT';

3948:
3949: l_found boolean;
3950: j number;
3951: l_temp_region_src_code pa_page_layout_regions.region_source_code%TYPE;
3952: l_module_name varchar2(100) := 'PA_PROGRESS_REPORT_PVT';
3953:
3954: BEGIN
3955: x_msg_count := 0;
3956: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3957: pa_debug.set_err_stack('PA_PROGRESS_REPORT_PVT.delete_version_data');

3953:
3954: BEGIN
3955: x_msg_count := 0;
3956: x_return_status := FND_API.G_RET_STS_SUCCESS;
3957: pa_debug.set_err_stack('PA_PROGRESS_REPORT_PVT.delete_version_data');
3958: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3959: fnd_profile.get('AFLOG_LEVEL',l_debug_level);
3960: l_debug_mode := NVL(l_debug_mode, 'Y');
3961: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 4057: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROGRESS_REPORT_PVT'

4053:
4054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4055: x_msg_count := 1;
4056: x_msg_data := SQLERRM;
4057: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROGRESS_REPORT_PVT'
4058: ,p_procedure_name => 'delete_version_data');
4059: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4060: pa_debug.reset_err_stack;
4061: RAISE;

Line 4064: END PA_PROGRESS_REPORT_PVT;

4060: pa_debug.reset_err_stack;
4061: RAISE;
4062: END delete_version_data;
4063:
4064: END PA_PROGRESS_REPORT_PVT;
4065: