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_DEBUG

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 119: PA_DEBUG.Reset_Err_Stack;

115:
116: END IF;
117:
118: IF x_return_status <> FND_API.g_ret_sts_success THEN
119: PA_DEBUG.Reset_Err_Stack;
120: RETURN;
121: END IF;
122:
123: OPEN get_template_type;

Line 224: PA_DEBUG.Reset_Err_Stack;

220: COMMIT;
221: END IF;
222:
223: -- Reset the error stack when returning to the calling program
224: PA_DEBUG.Reset_Err_Stack;
225:
226:
227: EXCEPTION
228: WHEN OTHERS THEN

Line 235: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
239:

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 528: PA_DEBUG.Reset_Err_Stack;

524: COMMIT;
525: END IF;
526:
527: -- Reset the error stack when returning to the calling program
528: PA_DEBUG.Reset_Err_Stack;
529:
530: COMMIT;
531:
532: --debug_msg ('update percent complete: end ');

Line 544: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
548:

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 701: PA_DEBUG.Reset_Err_Stack;

697: COMMIT;
698: END IF;
699:
700: -- Reset the error stack when returning to the calling program
701: PA_DEBUG.Reset_Err_Stack;
702:
703:
704: EXCEPTION
705: WHEN OTHERS THEN

Line 712: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
716:

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 932: PA_DEBUG.Reset_Err_Stack;

928: COMMIT;
929: END IF;
930:
931: -- Reset the error stack when returning to the calling program
932: PA_DEBUG.Reset_Err_Stack;
933:
934:
935: EXCEPTION
936: WHEN OTHERS THEN

Line 943: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
947:

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 1081: PA_DEBUG.Reset_Err_Stack;

1077: COMMIT;
1078: END IF;
1079:
1080: -- Reset the error stack when returning to the calling program
1081: PA_DEBUG.Reset_Err_Stack;
1082:
1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN

Line 1092: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
1096:

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 1232: PA_DEBUG.Reset_Err_Stack;

1228: COMMIT;
1229: END IF;
1230:
1231: -- Reset the error stack when returning to the calling program
1232: PA_DEBUG.Reset_Err_Stack;
1233:
1234:
1235: EXCEPTION
1236: WHEN OTHERS THEN

Line 1243: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
1247:

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 1413: PA_DEBUG.Reset_Err_Stack;

1409: COMMIT;
1410: END IF;
1411:
1412: -- Reset the error stack when returning to the calling program
1413: PA_DEBUG.Reset_Err_Stack;
1414:
1415: --debug_msg ('after update in PVT ');
1416:
1417: EXCEPTION

Line 1426: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
1430:

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 1923: PA_DEBUG.Reset_Err_Stack;

1919: x_return_status := FND_API.g_ret_sts_Error;
1920: end if;
1921:
1922: -- Reset the error stack when returning to the calling program
1923: PA_DEBUG.Reset_Err_Stack;
1924:
1925:
1926: EXCEPTION
1927: WHEN OTHERS THEN

Line 1934: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
1938:

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 2140: PA_DEBUG.Reset_Err_Stack;

2136: COMMIT;
2137: END IF;
2138:
2139: -- Reset the error stack when returning to the calling program
2140: PA_DEBUG.Reset_Err_Stack;
2141:
2142:
2143: EXCEPTION
2144: WHEN OTHERS THEN

Line 2151: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
2155:

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 2393: PA_DEBUG.Reset_Err_Stack;

2389: ROLLBACK TO rework_report;
2390: END IF;
2391:
2392: -- Reset the error stack when returning to the calling program
2393: PA_DEBUG.Reset_Err_Stack;
2394:
2395:
2396: EXCEPTION
2397: WHEN OTHERS THEN

Line 2404: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
2408:

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 2677: PA_DEBUG.Reset_Err_Stack;

2673: IF (x_return_status <> FND_API.g_ret_sts_success )THEN
2674: ROLLBACK TO publish_report;
2675: END IF;
2676: -- Reset the error stack when returning to the calling program
2677: PA_DEBUG.Reset_Err_Stack;
2678:
2679:
2680: EXCEPTION
2681: WHEN OTHERS THEN

Line 2687: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
2691:

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 2909: PA_DEBUG.Reset_Err_Stack;

2905: ROLLBACK TO submit_report;
2906: END IF;
2907:
2908: -- Reset the error stack when returning to the calling program
2909: PA_DEBUG.Reset_Err_Stack;
2910:
2911:
2912: EXCEPTION
2913: WHEN OTHERS THEN

Line 2920: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
2924:

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 3165: PA_DEBUG.Reset_Err_Stack;

3161: COMMIT;
3162: END IF;
3163:
3164: -- Reset the error stack when returning to the calling program
3165: PA_DEBUG.Reset_Err_Stack;
3166:
3167: EXCEPTION
3168: WHEN OTHERS THEN
3169:

Line 3173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
3177: END change_report_status;

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 3697: PA_DEBUG.Reset_Err_Stack;

3693: END IF;
3694:
3695:
3696: -- Reset the error stack when returning to the calling program
3697: PA_DEBUG.Reset_Err_Stack;
3698:
3699:
3700: EXCEPTION
3701: WHEN OTHERS THEN

Line 3708: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
3712:

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 3857: PA_DEBUG.Reset_Err_Stack;

3853: ,p_msg_name => 'PA_PR_DATES_INV');
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855:
3856: ROLLBACK TO update_project_perccomplete;
3857: PA_DEBUG.Reset_Err_Stack;
3858: RETURN;
3859: END IF;
3860: CLOSE get_dates;
3861:

Line 3891: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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
3895: END update_project_perccomplete;

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 3959: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

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);
3963:

Line 3962: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

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);
3963:
3964: if nvl(l_debug_mode,'N') = 'N' then
3965: --if debug is not enabled, set the level to a higher level
3966: l_debug_level := 10;

Line 3975: pa_debug.g_err_stage := 'number of records fetched :'||l_region_source_type_tbl.count;

3971: bulk collect into l_region_source_type_tbl, l_view_region_code_tbl, l_region_source_code_tbl;
3972: close c_page_layout_regions;
3973:
3974: if (l_debug_level <= 3) then
3975: pa_debug.g_err_stage := 'number of records fetched :'||l_region_source_type_tbl.count;
3976: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3977: end if;
3978: --If no records exist for the page layout do nothing and return.
3979: if(nvl(l_region_source_type_tbl.count,0) = 0) then

Line 3976: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

3972: close c_page_layout_regions;
3973:
3974: if (l_debug_level <= 3) then
3975: pa_debug.g_err_stage := 'number of records fetched :'||l_region_source_type_tbl.count;
3976: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3977: end if;
3978: --If no records exist for the page layout do nothing and return.
3979: if(nvl(l_region_source_type_tbl.count,0) = 0) then
3980: return;

Line 3989: pa_debug.g_err_stage := 'fetched source type:'||l_region_source_type_tbl(i);

3985: for i in 1..l_region_source_type_tbl.count loop
3986: l_found := false;
3987: j := 1;
3988: if (l_debug_level <= 3) then
3989: pa_debug.g_err_stage := 'fetched source type:'||l_region_source_type_tbl(i);
3990: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3991: pa_debug.g_err_stage := 'fetched region code:'||l_view_region_code_tbl(i);
3992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3993: pa_debug.g_err_stage := 'fetched region source code:'||l_region_source_code_tbl(i);

Line 3990: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

3986: l_found := false;
3987: j := 1;
3988: if (l_debug_level <= 3) then
3989: pa_debug.g_err_stage := 'fetched source type:'||l_region_source_type_tbl(i);
3990: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3991: pa_debug.g_err_stage := 'fetched region code:'||l_view_region_code_tbl(i);
3992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3993: pa_debug.g_err_stage := 'fetched region source code:'||l_region_source_code_tbl(i);
3994: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 3991: pa_debug.g_err_stage := 'fetched region code:'||l_view_region_code_tbl(i);

3987: j := 1;
3988: if (l_debug_level <= 3) then
3989: pa_debug.g_err_stage := 'fetched source type:'||l_region_source_type_tbl(i);
3990: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3991: pa_debug.g_err_stage := 'fetched region code:'||l_view_region_code_tbl(i);
3992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3993: pa_debug.g_err_stage := 'fetched region source code:'||l_region_source_code_tbl(i);
3994: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3995: end if;

Line 3992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

3988: if (l_debug_level <= 3) then
3989: pa_debug.g_err_stage := 'fetched source type:'||l_region_source_type_tbl(i);
3990: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3991: pa_debug.g_err_stage := 'fetched region code:'||l_view_region_code_tbl(i);
3992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3993: pa_debug.g_err_stage := 'fetched region source code:'||l_region_source_code_tbl(i);
3994: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3995: end if;
3996: while l_found = false and j <= p_region_source_type_tbl.count loop

Line 3993: pa_debug.g_err_stage := 'fetched region source code:'||l_region_source_code_tbl(i);

3989: pa_debug.g_err_stage := 'fetched source type:'||l_region_source_type_tbl(i);
3990: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3991: pa_debug.g_err_stage := 'fetched region code:'||l_view_region_code_tbl(i);
3992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3993: pa_debug.g_err_stage := 'fetched region source code:'||l_region_source_code_tbl(i);
3994: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3995: end if;
3996: while l_found = false and j <= p_region_source_type_tbl.count loop
3997: if (l_debug_level <= 3) then

Line 3994: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

3990: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3991: pa_debug.g_err_stage := 'fetched region code:'||l_view_region_code_tbl(i);
3992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3993: pa_debug.g_err_stage := 'fetched region source code:'||l_region_source_code_tbl(i);
3994: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3995: end if;
3996: while l_found = false and j <= p_region_source_type_tbl.count loop
3997: if (l_debug_level <= 3) then
3998: pa_debug.g_err_stage := 'passed source type:'||p_region_source_type_tbl(j);

Line 3998: pa_debug.g_err_stage := 'passed source type:'||p_region_source_type_tbl(j);

3994: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
3995: end if;
3996: while l_found = false and j <= p_region_source_type_tbl.count loop
3997: if (l_debug_level <= 3) then
3998: pa_debug.g_err_stage := 'passed source type:'||p_region_source_type_tbl(j);
3999: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4000: pa_debug.g_err_stage := 'passed region code:'||p_region_code_tbl(j);
4001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4002: pa_debug.g_err_stage := 'passed region source code:'||p_region_source_code_tbl(j);

Line 3999: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

3995: end if;
3996: while l_found = false and j <= p_region_source_type_tbl.count loop
3997: if (l_debug_level <= 3) then
3998: pa_debug.g_err_stage := 'passed source type:'||p_region_source_type_tbl(j);
3999: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4000: pa_debug.g_err_stage := 'passed region code:'||p_region_code_tbl(j);
4001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4002: pa_debug.g_err_stage := 'passed region source code:'||p_region_source_code_tbl(j);
4003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 4000: pa_debug.g_err_stage := 'passed region code:'||p_region_code_tbl(j);

3996: while l_found = false and j <= p_region_source_type_tbl.count loop
3997: if (l_debug_level <= 3) then
3998: pa_debug.g_err_stage := 'passed source type:'||p_region_source_type_tbl(j);
3999: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4000: pa_debug.g_err_stage := 'passed region code:'||p_region_code_tbl(j);
4001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4002: pa_debug.g_err_stage := 'passed region source code:'||p_region_source_code_tbl(j);
4003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4004: end if;

Line 4001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

3997: if (l_debug_level <= 3) then
3998: pa_debug.g_err_stage := 'passed source type:'||p_region_source_type_tbl(j);
3999: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4000: pa_debug.g_err_stage := 'passed region code:'||p_region_code_tbl(j);
4001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4002: pa_debug.g_err_stage := 'passed region source code:'||p_region_source_code_tbl(j);
4003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4004: end if;
4005: if p_region_source_type_tbl(j) = 'STD_CUST' then

Line 4002: pa_debug.g_err_stage := 'passed region source code:'||p_region_source_code_tbl(j);

3998: pa_debug.g_err_stage := 'passed source type:'||p_region_source_type_tbl(j);
3999: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4000: pa_debug.g_err_stage := 'passed region code:'||p_region_code_tbl(j);
4001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4002: pa_debug.g_err_stage := 'passed region source code:'||p_region_source_code_tbl(j);
4003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4004: end if;
4005: if p_region_source_type_tbl(j) = 'STD_CUST' then
4006: l_temp_region_src_code := p_region_code_tbl(j) || ':' || p_region_source_code_tbl(j);

Line 4003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

3999: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4000: pa_debug.g_err_stage := 'passed region code:'||p_region_code_tbl(j);
4001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4002: pa_debug.g_err_stage := 'passed region source code:'||p_region_source_code_tbl(j);
4003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4004: end if;
4005: if p_region_source_type_tbl(j) = 'STD_CUST' then
4006: l_temp_region_src_code := p_region_code_tbl(j) || ':' || p_region_source_code_tbl(j);
4007: else

Line 4016: pa_debug.g_err_stage := 'found the above region';

4012: l_view_region_code_tbl(i) = p_region_code_tbl(j) and
4013: l_region_source_code_tbl(i) = l_temp_region_src_code
4014: ) then
4015: if (l_debug_level <= 3) then
4016: pa_debug.g_err_stage := 'found the above region';
4017: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4018: end if;
4019: l_found := true;
4020: end if;

Line 4017: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

4013: l_region_source_code_tbl(i) = l_temp_region_src_code
4014: ) then
4015: if (l_debug_level <= 3) then
4016: pa_debug.g_err_stage := 'found the above region';
4017: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4018: end if;
4019: l_found := true;
4020: end if;
4021: j := j + 1;

Line 4036: pa_debug.g_err_stage := 'l_temp_region_src_code :'||l_temp_region_src_code;

4032: l_temp_region_src_code := l_region_source_code_tbl(i);
4033: end if;
4034:
4035: if (l_debug_level <= 3) then
4036: pa_debug.g_err_stage := 'l_temp_region_src_code :'||l_temp_region_src_code;
4037: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4038: end if;
4039:
4040: delete from pa_progress_report_vals

Line 4037: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

4033: end if;
4034:
4035: if (l_debug_level <= 3) then
4036: pa_debug.g_err_stage := 'l_temp_region_src_code :'||l_temp_region_src_code;
4037: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4038: end if;
4039:
4040: delete from pa_progress_report_vals
4041: where region_code = l_temp_region_src_code

Line 4051: pa_debug.reset_err_stack;

4047: and report_status_code in ('PROGRESS_REPORT_WORKING','PROGRESS_REPORT_REJECTED'));
4048: end if;
4049: end loop;
4050:
4051: pa_debug.reset_err_stack;
4052: EXCEPTION
4053: WHEN others THEN
4054:
4055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4060: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;

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;
4063: END delete_version_data;
4064:

Line 4061: pa_debug.reset_err_stack;

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;
4063: END delete_version_data;
4064:
4065: END PA_PROGRESS_REPORT_PVT;