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.4.12010000.2 2009/06/17 07:21:15 jngeorge 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 1425: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PVT.update_report_details'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4065: END PA_PROGRESS_REPORT_PVT;

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