88:
89: if (p_commit = 'Y') then
90: COMMIT;
91: end if;
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
91: end if;
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101:
102: END Create_Customizations;
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101:
102: END Create_Customizations;
103: --
104: --
143: null;
144: END;
145: Create_Customizations(p_api_version, p_commit,p_Customizations_Rec,x_return_status);
146:
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
146:
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156:
157: END Update_Customizations;
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156:
157: END Update_Customizations;
158:
159: PROCEDURE Create_Custom_Regions
185: );
186: if (p_commit = 'Y') then
187: COMMIT;
188: end if;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
187: COMMIT;
188: end if;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
188: end if;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197:
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197:
198: END Create_Custom_Regions;
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197:
198: END Create_Custom_Regions;
199: --
200: --
223: END;
224: */
225: Create_Custom_Regions(p_api_version, p_commit,p_Custom_Regions_Rec,x_return_status);
226:
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
226:
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236:
237:
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236:
237:
238: END Update_Custom_Regions;
239:
269: if (p_commit = 'Y') then
270: COMMIT;
271: end if;
272:
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
272:
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282:
283: END Create_Custom_Region_Items;
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282:
283: END Create_Custom_Region_Items;
284: --
285: --
310: END;
311: */
312: Create_Custom_Region_items(p_api_version, p_commit,p_Custom_Region_Items_Rec,x_return_status);
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:
324:
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:
324:
325: END Update_Custom_Region_items;
326:
345: DELETE FROM ak_custom_region_items WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
346: DELETE FROM ak_custom_region_items_tl WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
347: END IF;
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: EXCEPTION
352: when others then
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: EXCEPTION
352: when others then
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354:
355: END deleteCustomView;
356:
357: -- Delete all customizations for a ak region
390: WHERE region_code = p_region_code
391: AND region_application_id = p_region_application_id;
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
397: , p_count => x_msg_count
398: , p_data => x_msg_data);
391: AND region_application_id = p_region_application_id;
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
397: , p_count => x_msg_count
398: , p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
397: , p_count => x_msg_count
398: , p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
402: , p_count => x_msg_count
403: , p_data => x_msg_data);
396: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
397: , p_count => x_msg_count
398: , p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
402: , p_count => x_msg_count
403: , p_data => x_msg_data);
404: WHEN NO_DATA_FOUND THEN
401: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
402: , p_count => x_msg_count
403: , p_data => x_msg_data);
404: WHEN NO_DATA_FOUND THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
407: , p_count => x_msg_count
408: , p_data => x_msg_data);
409: WHEN OTHERS THEN
406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
407: , p_count => x_msg_count
408: , p_data => x_msg_data);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
412: , p_count => x_msg_count
413: , p_data => x_msg_data);
414: IF (x_msg_data IS NULL) THEN