41: RAISE FND_API.g_exc_unexpected_error;
42: END IF;
43:
44: IF FND_API.to_boolean(p_init_msg_list) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
73: END IF;
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: FND_MSG_PUB.count_and_get(
78: p_encoded => FND_API.g_false,
79: p_count => x_msg_count,
80: p_data => x_msg_data
81: );
84:
85: WHEN FND_API.g_exc_error THEN
86: ROLLBACK TO delete_logical_content;
87: x_return_status := FND_API.g_ret_sts_error;
88: FND_MSG_PUB.count_and_get(
89: p_encoded => FND_API.g_false,
90: p_count => x_msg_count,
91: p_data => x_msg_data
92: );
93:
94: WHEN FND_API.g_exc_unexpected_error THEN
95: ROLLBACK TO delete_logical_content;
96: x_return_status := FND_API.g_ret_sts_error ;
97: FND_MSG_PUB.count_and_get(
98: p_encoded => FND_API.g_false,
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );
104: WHEN jtf_dspmgrvalidation_grp.lglctnt_id_req_exception THEN
105: ROLLBACK TO delete_logical_content;
106: x_return_status := FND_API.g_ret_sts_error;
107: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_REQ');
108: FND_MSG_PUB.ADD;
109: FND_MSG_PUB.count_and_get(
110: p_encoded => FND_API.g_false,
111: p_count => x_msg_count,
112: p_data => x_msg_data
105: ROLLBACK TO delete_logical_content;
106: x_return_status := FND_API.g_ret_sts_error;
107: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_REQ');
108: FND_MSG_PUB.ADD;
109: FND_MSG_PUB.count_and_get(
110: p_encoded => FND_API.g_false,
111: p_count => x_msg_count,
112: p_data => x_msg_data
113: );
114:
115: WHEN OTHERS THEN
116: ROLLBACK TO delete_logical_content;
117: x_return_status := FND_API.g_ret_sts_unexp_error ;
118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
119: THEN
120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
121: END IF;
122: FND_MSG_PUB.count_and_get(
116: ROLLBACK TO delete_logical_content;
117: x_return_status := FND_API.g_ret_sts_unexp_error ;
118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
119: THEN
120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
121: END IF;
122: FND_MSG_PUB.count_and_get(
123: p_encoded => FND_API.g_false,
124: p_count => x_msg_count,
118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
119: THEN
120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
121: END IF;
122: FND_MSG_PUB.count_and_get(
123: p_encoded => FND_API.g_false,
124: p_count => x_msg_count,
125: p_data => x_msg_data
126: );
168:
169: --dbms_output.put_line('save_logical_content: checking the object existence');
170:
171: IF FND_API.to_boolean(p_init_msg_list) THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175:
176: --- Initialize API return status to success
192: END IF;
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;
195:
196: FND_MSG_PUB.count_and_get(
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );
234:
235: if l_context_type = 'TEMPLATE' and p_object_type = 'S' then
236:
237: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_SCT_INVLD');
238: FND_MSG_PUB.ADD;
239: end if;
240:
241: if p_lgl_ctnt_rec.deliverable_id is not null
242: then
363: END IF;
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: FND_MSG_PUB.count_and_get(
368: p_encoded => FND_API.g_false,
369: p_count => x_msg_count,
370: p_data => x_msg_data
371: );
374:
375: WHEN FND_API.g_exc_error THEN
376: ROLLBACK TO save_logical_content;
377: x_return_status := FND_API.g_ret_sts_error;
378: FND_MSG_PUB.count_and_get(
379: p_encoded => FND_API.g_false,
380: p_count => x_msg_count,
381: p_data => x_msg_data
382: );
387: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ROW_EXISTS');
388: FND_MESSAGE.set_token('ID', p_lgl_ctnt_rec.object_id);
389: FND_MESSAGE.set_token('TYPE', p_object_type);
390: FND_MESSAGE.set_token('CTX_ID', p_lgl_ctnt_rec.context_id);
391: FND_MSG_PUB.ADD;
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
388: FND_MESSAGE.set_token('ID', p_lgl_ctnt_rec.object_id);
389: FND_MESSAGE.set_token('TYPE', p_object_type);
390: FND_MESSAGE.set_token('CTX_ID', p_lgl_ctnt_rec.context_id);
391: FND_MSG_PUB.ADD;
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: );
396: );
397: WHEN FND_API.g_exc_unexpected_error THEN
398: ROLLBACK TO save_logical_content;
399: x_return_status := FND_API.g_ret_sts_error ;
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );
404: );
405: WHEN jtf_dspmgrvalidation_grp.context_req_exception THEN
406: ROLLBACK TO save_logical_content;
407: x_return_status := FND_API.g_ret_sts_unexp_error ;
408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
409: THEN
410: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_REQ');
411: FND_MSG_PUB.ADD;
412: END IF;
407: x_return_status := FND_API.g_ret_sts_unexp_error ;
408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
409: THEN
410: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_REQ');
411: FND_MSG_PUB.ADD;
412: END IF;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false,
415: p_count => x_msg_count,
409: THEN
410: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_REQ');
411: FND_MSG_PUB.ADD;
412: END IF;
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: );
418:
419: WHEN OTHERS THEN
420: ROLLBACK TO save_logical_content;
421: x_return_status := FND_API.g_ret_sts_unexp_error ;
422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
423: THEN
424: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
425: END IF;
426: FND_MSG_PUB.count_and_get(
420: ROLLBACK TO save_logical_content;
421: x_return_status := FND_API.g_ret_sts_unexp_error ;
422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
423: THEN
424: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
425: END IF;
426: FND_MSG_PUB.count_and_get(
427: p_encoded => FND_API.g_false,
428: p_count => x_msg_count,
422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
423: THEN
424: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
425: END IF;
426: FND_MSG_PUB.count_and_get(
427: p_encoded => FND_API.g_false,
428: p_count => x_msg_count,
429: p_data => x_msg_data
430: );
468: END IF;
469:
470:
471: IF FND_API.to_boolean(p_init_msg_list) THEN
472: FND_MSG_PUB.initialize;
473: END IF;
474:
475:
476: --- Initialize API return status to success
530: --dbms_output.put_line('processing ' || p_lgl_ctnt_tbl(l_index).deliverable_id);
531: END LOOP;
532:
533:
534: FND_MSG_PUB.count_and_get(
535: p_encoded => FND_API.g_false,
536: p_count => x_msg_count,
537: p_data => x_msg_data
538: );
541:
542: WHEN FND_API.g_exc_error THEN
543: ROLLBACK TO save_delete_itm_lgl_ctnt;
544: x_return_status := FND_API.g_ret_sts_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: );
550:
551: WHEN FND_API.g_exc_unexpected_error THEN
552: ROLLBACK TO save_delete_itm_lgl_ctnt;
553: x_return_status := FND_API.g_ret_sts_error ;
554: FND_MSG_PUB.count_and_get(
555: p_encoded => FND_API.g_false,
556: p_count => x_msg_count,
557: p_data => x_msg_data
558: );
560:
561: WHEN OTHERS THEN
562: ROLLBACK TO save_delete_itm_lgl_ctnt;
563: x_return_status := FND_API.g_ret_sts_unexp_error ;
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
565: THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: END IF;
568: FND_MSG_PUB.count_and_get(
562: ROLLBACK TO save_delete_itm_lgl_ctnt;
563: x_return_status := FND_API.g_ret_sts_unexp_error ;
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
565: THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: END IF;
568: FND_MSG_PUB.count_and_get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
565: THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: END IF;
568: FND_MSG_PUB.count_and_get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );