33: l_dummy varchar2(1);
34:
35: BEGIN
36: -- Initialize the Error Stack
37: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Create_Page_Layout');
38:
39: -- Initialize the return status to success
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
87: COMMIT;
88: END IF;
89:
90: -- Reset the error stack when returning to the calling program
91: PA_DEBUG.Reset_Err_Stack;
92:
93: EXCEPTION
94: WHEN OTHERS THEN
95: IF p_commit = FND_API.G_TRUE THEN
97: END IF;
98: -- Set the excetption Message and the stack
99: FND_MSG_PUB.add_exc_msg
100: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.create_object_page_region'
101: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
102: --
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104: RAISE; -- This is optional depending on the needs
105: END create_object_page_region;
138: l_dummy varchar2(1);
139:
140: BEGIN
141: -- Initialize the Error Stack
142: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Create_Page_Layout');
143:
144: -- Initialize the return status to success
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
191: COMMIT;
192: END IF;
193:
194: -- Reset the error stack when returning to the calling program
195: PA_DEBUG.Reset_Err_Stack;
196:
197: EXCEPTION
198: WHEN NO_DATA_FOUND then
199: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
209: END IF;
210: -- Set the excetption Message and the stack
211: FND_MSG_PUB.add_exc_msg
212: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.update_object_page_region'
213: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
214: --
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: RAISE; -- This is optional depending on the needs
217: End update_object_page_region;
231: )
232: IS
233: Begin
234: -- Initialize the Error Stack
235: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Create_Page_Layout');
236:
237: -- Initialize the return status to success
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
257: COMMIT;
258: END IF;
259:
260: -- Reset the error stack when returning to the calling program
261: PA_DEBUG.Reset_Err_Stack;
262:
263: EXCEPTION
264: WHEN OTHERS THEN
265: IF p_commit = FND_API.G_TRUE THEN
267: END IF;
268: -- Set the excetption Message and the stack
269: FND_MSG_PUB.add_exc_msg
270: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.delete_object_page_region'
271: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
272: --
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
274: RAISE; -- This is optional depending on the needs
275: