48: IF ( c_project_exists%ISOPEN ) THEN
49: close c_project_exists;
50: END IF;
51: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_UTILS'
52: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
54: --x_ret_code:= fnd_api.g_false;
55: END VALIDATE_PARAMETERS;
56:
105: l_next_reporting_date Date ; -- Added for Bug 3026572
106: l_rep_start_date Date; -- Added for Bug 3026572
107:
108: BEGIN
109: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_UTILS.copy_project_page_layouts');
110: --x_ret_code:= fnd_api.g_true;
111: x_return_status:=fnd_api.g_ret_sts_success;
112: savepoint copy_object_page_layouts;
113:
215: ROLLBACK TO copy_object_page_layouts;
216: END IF;
217: END IF;
218:
219: PA_DEBUG.Reset_Err_Stack;
220:
221: EXCEPTION
222: WHEN OTHERS THEN
223: ROLLBACK TO copy_object_page_layouts;
221: EXCEPTION
222: WHEN OTHERS THEN
223: ROLLBACK TO copy_object_page_layouts;
224: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_page_layout_utils.copy_object_page_layouts',
225: p_procedure_name => PA_DEBUG.G_Err_Stack );
226:
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228: END COPY_OBJECT_PAGE_LAYOUTS;
229:
631: x_msg_count := 0;
632: x_return_status:=fnd_api.g_ret_sts_success;
633: savepoint populate_pers_functions;
634:
635: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
636:
637: IF l_debug_mode = 'Y' THEN
638: pa_debug.set_curr_function( p_function => 'PERS_FUNCTIONS',
639: p_debug_mode => l_debug_mode );
634:
635: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
636:
637: IF l_debug_mode = 'Y' THEN
638: pa_debug.set_curr_function( p_function => 'PERS_FUNCTIONS',
639: p_debug_mode => l_debug_mode );
640: END IF;
641:
642: DELETE FROM PA_PAGE_LAYOUTS_TMP;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: x_msg_count := 1;
652: x_msg_data := SQLERRM;
653: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_page_layout_utils.populate_pers_functions',
654: p_procedure_name => PA_DEBUG.G_Err_Stack );
655:
656: IF l_debug_mode = 'Y' THEN
657: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
658: pa_debug.write(g_module_name,pa_debug.g_err_stage,
653: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_page_layout_utils.populate_pers_functions',
654: p_procedure_name => PA_DEBUG.G_Err_Stack );
655:
656: IF l_debug_mode = 'Y' THEN
657: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
658: pa_debug.write(g_module_name,pa_debug.g_err_stage,
659: l_debug_level5);
660: pa_debug.reset_curr_function;
661: END IF;
654: p_procedure_name => PA_DEBUG.G_Err_Stack );
655:
656: IF l_debug_mode = 'Y' THEN
657: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
658: pa_debug.write(g_module_name,pa_debug.g_err_stage,
659: l_debug_level5);
660: pa_debug.reset_curr_function;
661: END IF;
662: RAISE;
656: IF l_debug_mode = 'Y' THEN
657: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
658: pa_debug.write(g_module_name,pa_debug.g_err_stage,
659: l_debug_level5);
660: pa_debug.reset_curr_function;
661: END IF;
662: RAISE;
663:
664: END POPULATE_PERS_FUNCTIONS;