35: BEGIN
36:
37:
38: fnd_msg_pub.delete_msg();
39: x_return_status := fnd_api.g_ret_sts_success;
40: FND_MSG_PUB.initialize;
41: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
42: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
43: x_msg_data := '';
92:
93: COMMIT;
94:
95: EXCEPTION
96: WHEN fnd_api.g_exc_error THEN
97: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
98: ROLLBACK;
99: x_return_status := fnd_api.g_ret_sts_error;
100:
95: EXCEPTION
96: WHEN fnd_api.g_exc_error THEN
97: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
98: ROLLBACK;
99: x_return_status := fnd_api.g_ret_sts_error;
100:
101: WHEN fnd_api.g_exc_unexpected_error THEN
102: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
103: ROLLBACK;
97: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
98: ROLLBACK;
99: x_return_status := fnd_api.g_ret_sts_error;
100:
101: WHEN fnd_api.g_exc_unexpected_error THEN
102: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
103: ROLLBACK;
104: x_return_status := fnd_api.g_ret_sts_unexp_error;
105:
100:
101: WHEN fnd_api.g_exc_unexpected_error THEN
102: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
103: ROLLBACK;
104: x_return_status := fnd_api.g_ret_sts_unexp_error;
105:
106: WHEN OTHERS THEN
107: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
108:
106: WHEN OTHERS THEN
107: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
108:
109: ROLLBACK;
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111:
112: END Create_NMediaAction;
113:
114:
135: BEGIN
136:
137:
138: fnd_msg_pub.delete_msg();
139: x_return_status := fnd_api.g_ret_sts_success;
140: FND_MSG_PUB.initialize;
141: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
142: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
143: x_msg_data := '';
210:
211: COMMIT;
212:
213: EXCEPTION
214: WHEN fnd_api.g_exc_error THEN
215: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
216: ROLLBACK;
217: x_return_status := fnd_api.g_ret_sts_error;
218:
213: EXCEPTION
214: WHEN fnd_api.g_exc_error THEN
215: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
216: ROLLBACK;
217: x_return_status := fnd_api.g_ret_sts_error;
218:
219: WHEN fnd_api.g_exc_unexpected_error THEN
220: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
221: ROLLBACK;
215: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
216: ROLLBACK;
217: x_return_status := fnd_api.g_ret_sts_error;
218:
219: WHEN fnd_api.g_exc_unexpected_error THEN
220: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
221: ROLLBACK;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:
218:
219: WHEN fnd_api.g_exc_unexpected_error THEN
220: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
221: ROLLBACK;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:
224: WHEN OTHERS THEN
225: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
226:
224: WHEN OTHERS THEN
225: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
226:
227: ROLLBACK;
228: x_return_status := fnd_api.g_ret_sts_unexp_error;
229:
230: END Update_NMediaAction;
231:
232: PROCEDURE Delete_NMediaAction( x_return_status OUT NOCOPY VARCHAR2,
248: BEGIN
249:
250:
251: fnd_msg_pub.delete_msg();
252: x_return_status := fnd_api.g_ret_sts_success;
253: FND_MSG_PUB.initialize;
254: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
255: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
256: x_msg_data := '';
268:
269: COMMIT;
270:
271: EXCEPTION
272: WHEN fnd_api.g_exc_error THEN
273: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
274: ROLLBACK;
275: x_return_status := fnd_api.g_ret_sts_error;
276:
271: EXCEPTION
272: WHEN fnd_api.g_exc_error THEN
273: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
274: ROLLBACK;
275: x_return_status := fnd_api.g_ret_sts_error;
276:
277: WHEN fnd_api.g_exc_unexpected_error THEN
278: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
279: ROLLBACK;
273: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
274: ROLLBACK;
275: x_return_status := fnd_api.g_ret_sts_error;
276:
277: WHEN fnd_api.g_exc_unexpected_error THEN
278: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
279: ROLLBACK;
280: x_return_status := fnd_api.g_ret_sts_unexp_error;
281:
276:
277: WHEN fnd_api.g_exc_unexpected_error THEN
278: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
279: ROLLBACK;
280: x_return_status := fnd_api.g_ret_sts_unexp_error;
281:
282: WHEN OTHERS THEN
283: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
284:
282: WHEN OTHERS THEN
283: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
284:
285: ROLLBACK;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287:
288: END Delete_NMediaAction;
289:
290: END IEU_NonMedia_Action_PVT;