55: END IF;
56:
57:
58: IF FND_API.to_boolean(p_init_msg_list) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62:
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: END IF;
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243:
244: FND_MSG_PUB.count_and_get(
245: p_encoded => FND_API.g_false,
246: p_count => x_msg_count,
247: p_data => x_msg_data
248: );
251:
252: WHEN FND_API.g_exc_error THEN
253: ROLLBACK TO save_display_context;
254: x_return_status := FND_API.g_ret_sts_error;
255: FND_MSG_PUB.count_and_get(
256: p_encoded => FND_API.g_false,
257: p_count => x_msg_count,
258: p_data => x_msg_data
259: );
260:
261: WHEN FND_API.g_exc_unexpected_error THEN
262: ROLLBACK TO save_display_context;
263: x_return_status := FND_API.g_ret_sts_unexp_error ;
264: FND_MSG_PUB.count_and_get(
265: p_encoded => FND_API.g_false,
266: p_count => x_msg_count,
267: p_data => x_msg_data
268: );
270: WHEN jtf_dspmgrvalidation_grp.context_accname_req_exception THEN
271: ROLLBACK TO save_display_context;
272: x_return_status := FND_API.g_ret_sts_error;
273: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_ACCNAME_REQ');
274: FND_MSG_PUB.ADD;
275: FND_MSG_PUB.count_and_get(
276: p_encoded => FND_API.g_false,
277: p_count => x_msg_count,
278: p_data => x_msg_data
271: ROLLBACK TO save_display_context;
272: x_return_status := FND_API.g_ret_sts_error;
273: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_ACCNAME_REQ');
274: FND_MSG_PUB.ADD;
275: FND_MSG_PUB.count_and_get(
276: p_encoded => FND_API.g_false,
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );
280:
281: WHEN OTHERS THEN
282: ROLLBACK TO save_display_context;
283: x_return_status := FND_API.g_ret_sts_unexp_error ;
284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
285: THEN
286: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
287: END IF;
288: FND_MSG_PUB.count_and_get(
282: ROLLBACK TO save_display_context;
283: x_return_status := FND_API.g_ret_sts_unexp_error ;
284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
285: THEN
286: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
287: END IF;
288: FND_MSG_PUB.count_and_get(
289: p_encoded => FND_API.g_false,
290: p_count => x_msg_count,
284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
285: THEN
286: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
287: END IF;
288: FND_MSG_PUB.count_and_get(
289: p_encoded => FND_API.g_false,
290: p_count => x_msg_count,
291: p_data => x_msg_data
292: );
331: RAISE FND_API.g_exc_unexpected_error;
332: END IF;
333:
334: IF FND_API.to_boolean(p_init_msg_list) THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
375: );
376:
377: else
378: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_ID_REQ');
379: FND_MSG_PUB.ADD;
380: raise FND_API.g_exc_error;
381: END IF;
382:
383:
388: IF FND_API.to_boolean(p_commit) THEN
389: COMMIT;
390: END IF;
391:
392: FND_MSG_PUB.count_and_get(
393: p_encoded => FND_API.g_false,
394: p_count => x_msg_count,
395: p_data => x_msg_data
396: );
400:
401: WHEN FND_API.g_exc_error THEN
402: ROLLBACK TO delete_display_context;
403: x_return_status := FND_API.g_ret_sts_error;
404: FND_MSG_PUB.count_and_get(
405: p_encoded => FND_API.g_false,
406: p_count => x_msg_count,
407: p_data => x_msg_data
408: );
409:
410: WHEN FND_API.g_exc_unexpected_error THEN
411: ROLLBACK TO delete_display_context;
412: x_return_status := FND_API.g_ret_sts_unexp_error ;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false,
415: p_count => x_msg_count,
416: p_data => x_msg_data
417: );
419:
420: WHEN OTHERS THEN
421: ROLLBACK TO delete_display_context;
422: x_return_status := FND_API.g_ret_sts_unexp_error ;
423: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
424: THEN
425: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
426: END IF;
427: FND_MSG_PUB.count_and_get(
421: ROLLBACK TO delete_display_context;
422: x_return_status := FND_API.g_ret_sts_unexp_error ;
423: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
424: THEN
425: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
426: END IF;
427: FND_MSG_PUB.count_and_get(
428: p_encoded => FND_API.g_false,
429: p_count => x_msg_count,
423: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
424: THEN
425: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
426: END IF;
427: FND_MSG_PUB.count_and_get(
428: p_encoded => FND_API.g_false,
429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );
483: RAISE FND_API.g_exc_unexpected_error;
484: END IF;
485:
486: IF FND_API.to_boolean(p_init_msg_list) THEN
487: FND_MSG_PUB.initialize;
488: END IF;
489:
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
531: IF FND_API.to_boolean(p_commit) THEN
532: COMMIT;
533: END IF;
534:
535: FND_MSG_PUB.count_and_get(
536: p_encoded => FND_API.g_false,
537: p_count => x_msg_count,
538: p_data => x_msg_data
539: );
541:
542: WHEN FND_API.g_exc_unexpected_error THEN
543: ROLLBACK TO save_delete_display_context;
544: x_return_status := FND_API.g_ret_sts_unexp_error ;
545: FND_MSG_PUB.count_and_get(
546: p_encoded => FND_API.g_false,
547: p_count => x_msg_count,
548: p_data => x_msg_data
549: );
552: WHEN OTHERS THEN
553: ROLLBACK TO save_delete_display_context;
554: x_return_status := FND_API.g_ret_sts_unexp_error ;
555:
556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
557: THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560: FND_MSG_PUB.count_and_get(
554: x_return_status := FND_API.g_ret_sts_unexp_error ;
555:
556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
557: THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560: FND_MSG_PUB.count_and_get(
561: p_encoded => FND_API.g_false,
562: p_count => x_msg_count,
556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
557: THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560: FND_MSG_PUB.count_and_get(
561: p_encoded => FND_API.g_false,
562: p_count => x_msg_count,
563: p_data => x_msg_data
564: );