APPS.IBE_LOGICALCONTENT_GRP dependencies on IBE_DSPMGRVALIDATION_GRP

Line 53: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(

49:
50: IF p_lgl_ctnt_rec.obj_lgl_ctnt_id IS NOT NULL
51: THEN
52: --- Check if the object logical content exists
53: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(
54: p_lgl_ctnt_rec.obj_lgl_ctnt_id,
55: p_lgl_ctnt_rec.object_version_number) = false
56: THEN
57: RAISE FND_API.g_exc_error;

Line 64: RAISE ibe_dspmgrvalidation_grp.lglctnt_id_req_exception;

60: DELETE FROM ibe_dsp_obj_lgl_ctnt
61: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id
62: AND object_version_number = p_lgl_ctnt_rec.object_version_number;
63: ELSE
64: RAISE ibe_dspmgrvalidation_grp.lglctnt_id_req_exception;
65: END IF;
66:
67: --- Check if the caller requested to commit ,
68: --- If p_commit set to true, commit the transaction

Line 98: WHEN ibe_dspmgrvalidation_grp.lglctnt_id_req_exception THEN

94: p_encoded => FND_API.g_false,
95: p_count => x_msg_count,
96: p_data => x_msg_data );
97:
98: WHEN ibe_dspmgrvalidation_grp.lglctnt_id_req_exception THEN
99: ROLLBACK TO delete_logical_content;
100: x_return_status := FND_API.g_ret_sts_error;
101: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_REQ');
102: FND_MSG_PUB.ADD;

Line 186: IF ibe_dspmgrvalidation_grp.check_lgl_object_exists(

182:
183: RETURN;
184: END IF;
185:
186: IF ibe_dspmgrvalidation_grp.check_lgl_object_exists(
187: p_object_type,p_lgl_ctnt_rec.object_id) = false
188: THEN
189: RAISE FND_API.g_exc_error;
190: END IF;

Line 196: l_context_type := ibe_dspmgrvalidation_grp.check_context_type_code(

192: --- check if the context exists
193: IF p_lgl_ctnt_rec.context_id IS NOT NULL OR
194: p_lgl_ctnt_rec.context_id <> FND_API.g_miss_num
195: THEN
196: l_context_type := ibe_dspmgrvalidation_grp.check_context_type_code(
197: p_lgl_ctnt_rec.context_id);
198:
199: IF l_context_type IS NULL
200: THEN

Line 204: RAISE ibe_dspmgrvalidation_grp.context_req_exception;

200: THEN
201: RAISE FND_API.g_exc_error;
202: END IF;
203: ELSE
204: RAISE ibe_dspmgrvalidation_grp.context_req_exception;
205: END IF;
206:
207: --- check if the deliverable exists
208: --- if the deliverable is passed, make sure the type is the same as

Line 232: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(

228: THEN
229: l_applicable_to := 'SECTION';
230: END IF;
231:
232: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(
233: p_lgl_ctnt_rec.deliverable_id,
234: l_context_type,
235: l_applicable_to) = false
236: THEN

Line 247: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(

243: p_lgl_ctnt_rec.obj_lgl_ctnt_id IS NOT NULL AND
244: p_lgl_ctnt_rec.deliverable_id = null
245: THEN
246: --- Check if the object logical content id exists
247: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(
248: p_lgl_ctnt_rec.obj_lgl_ctnt_id,
249: p_lgl_ctnt_rec.object_version_number) = false
250: THEN
251: RAISE FND_API.g_exc_error;

Line 291: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(

287: p_lgl_ctnt_rec.context_id,
288: p_lgl_ctnt_rec.deliverable_id);
289: ELSE
290: --- Check if the object logical content id exists
291: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(
292: p_lgl_ctnt_rec.obj_lgl_ctnt_id,
293: p_lgl_ctnt_rec.object_version_number) = false
294: THEN
295: RAISE FND_API.g_exc_error;

Line 355: WHEN ibe_dspmgrvalidation_grp.context_req_exception THEN

351: p_encoded => FND_API.g_false,
352: p_count => x_msg_count,
353: p_data => x_msg_data );
354:
355: WHEN ibe_dspmgrvalidation_grp.context_req_exception THEN
356: ROLLBACK TO save_logical_content;
357: x_return_status := FND_API.g_ret_sts_unexp_error ;
358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
359: THEN

Line 421: IF ibe_dspmgrvalidation_grp.check_valid_object_type(

417:
418: --- Initialize API return status to success
419: x_return_status := FND_API.g_ret_sts_success;
420:
421: IF ibe_dspmgrvalidation_grp.check_valid_object_type(
422: p_object_type_code) = false
423: THEN
424: RAISE FND_API.g_exc_error;
425: END IF;

Line 500: IF ibe_dspmgrvalidation_grp.check_section_exists(

496: l_api_name CONSTANT VARCHAR2(30) := 'delete_section';
497: BEGIN
498: SAVEPOINT delete_section;
499:
500: IF ibe_dspmgrvalidation_grp.check_section_exists(
501: p_section_id) = false
502: THEN
503: RAISE FND_API.g_exc_error;
504: END IF;