46:
47:
48: BEGIN
49: -- Initialize the Error Stack
50: PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Save_Page_Contents');
51:
52: -- Initialize the return status to success
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
115: );
116: END IF;
117:
118: -- Reset the error stack when returning to the calling program
119: PA_DEBUG.Reset_Err_Stack;
120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: -- Set the excetption Message and the stack
121: EXCEPTION
122: WHEN OTHERS THEN
123: -- Set the excetption Message and the stack
124: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.SAVE_PAGE_CONTENTS'
125: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
126:
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: RAISE;
129:
165: AND NVL(PK5_VALUE,0) = NVL(P_PK5_VALUE,0);
166:
167: begin
168: -- Initialize the Error Stack
169: PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Delete_Page_Contents');
170:
171: -- Initialize the return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
216: );
217: END IF;
218:
219: -- Reset the error stack when returning to the calling program
220: PA_DEBUG.Reset_Err_Stack;
221:
222:
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: rollback;
227: -- Set the excetption Message and the stack
228: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.DELETE_PAGE_CONTENTS'
229: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
230:
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
232: RAISE;
233: end DELETE_PAGE_CONTENTS;