DBA Data[Home] [Help]

APPS.IEU_NONMEDIA_ACTION_PVT dependencies on FND_API

Line 39: x_return_status := fnd_api.g_ret_sts_success;

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 := '';

Line 96: WHEN fnd_api.g_exc_error THEN

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:

Line 99: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 101: WHEN fnd_api.g_exc_unexpected_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;
104: x_return_status := fnd_api.g_ret_sts_unexp_error;
105:

Line 104: x_return_status := fnd_api.g_ret_sts_unexp_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:
106: WHEN OTHERS THEN
107: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
108:

Line 110: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:

Line 139: x_return_status := fnd_api.g_ret_sts_success;

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 := '';

Line 214: WHEN fnd_api.g_exc_error THEN

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:

Line 217: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 219: WHEN fnd_api.g_exc_unexpected_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;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_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:
224: WHEN OTHERS THEN
225: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
226:

Line 228: x_return_status := fnd_api.g_ret_sts_unexp_error;

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,

Line 252: x_return_status := fnd_api.g_ret_sts_success;

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 := '';

Line 272: WHEN fnd_api.g_exc_error THEN

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:

Line 275: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 277: WHEN fnd_api.g_exc_unexpected_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;
280: x_return_status := fnd_api.g_ret_sts_unexp_error;
281:

Line 280: x_return_status := fnd_api.g_ret_sts_unexp_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:
282: WHEN OTHERS THEN
283: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
284:

Line 286: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;