APPS.IBE_TPLCATEGORY_GRP dependencies on IBE_DSPMGRVALIDATION_GRP

Line 62: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(

58: --- Check if the deliverable id exists .
59: IF p_template_id <> FND_API.g_miss_num AND
60: p_template_id IS NOT NULL
61: THEN
62: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(
63: p_template_id,l_type ,l_applicable_to)
64: THEN
65: IF p_category_id <> FND_API.g_miss_num AND
66: p_category_id IS NOT NULL

Line 68: IF ibe_dspmgrvalidation_grp.check_category_exists(p_category_id)

64: THEN
65: IF p_category_id <> FND_API.g_miss_num AND
66: p_category_id IS NOT NULL
67: THEN
68: IF ibe_dspmgrvalidation_grp.check_category_exists(p_category_id)
69: THEN
70: IF ibe_dspmgrvalidation_grp.check_ctg_tpl_relation_exists(
71: p_category_id,
72: p_template_id) = false

Line 70: IF ibe_dspmgrvalidation_grp.check_ctg_tpl_relation_exists(

66: p_category_id IS NOT NULL
67: THEN
68: IF ibe_dspmgrvalidation_grp.check_category_exists(p_category_id)
69: THEN
70: IF ibe_dspmgrvalidation_grp.check_ctg_tpl_relation_exists(
71: p_category_id,
72: p_template_id) = false
73: THEN
74: OPEN dsp_tpl_seq;

Line 104: RAISE ibe_dspmgrvalidation_grp.category_req_exception;

100: ELSE
101: RAISE FND_API.g_exc_error;
102: END IF; /* category exists check */
103: ELSE
104: RAISE ibe_dspmgrvalidation_grp.category_req_exception;
105: END IF; /* category id is not null check */
106: ELSE
107: RAISE FND_API.g_exc_error;
108: END IF;/* deliverable exists check */

Line 110: RAISE ibe_dspmgrvalidation_grp.template_req_exception;

106: ELSE
107: RAISE FND_API.g_exc_error;
108: END IF;/* deliverable exists check */
109: ELSE
110: RAISE ibe_dspmgrvalidation_grp.template_req_exception;
111: END IF; /*deliverable id is not null check */
112:
113: --- Check if the caller requested to commit ,
114: --- If p_commit set to true, commit the transaction

Line 130: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN

126: WHEN FND_API.g_exc_unexpected_error THEN
127: ROLLBACK TO add_tpl_ctg_rec;
128: x_return_status := FND_API.g_ret_sts_unexp_error ;
129:
130: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN
131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
132: THEN
133: x_return_status := FND_API.g_ret_sts_error;
134: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');

Line 138: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN

134: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
135: FND_MSG_PUB.add;
136: END IF;
137:
138: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
140: THEN
141: x_return_status := FND_API.g_ret_sts_error;
142: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');

Line 207: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(

203:
204: IF p_template_id IS NOT NULL AND
205: p_template_id <> FND_API.g_miss_num
206: THEN
207: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(
208: p_template_id ,
209: l_type,
210: l_applicable_to) = false
211: THEN

Line 215: RAISE ibe_dspmgrvalidation_grp.template_req_exception;

211: THEN
212: RAISE FND_API.g_exc_error;
213: END IF;/* deliverable exists check */
214: ELSE
215: RAISE ibe_dspmgrvalidation_grp.template_req_exception;
216: END IF; /*deliverable id is not null check */
217:
218: FOR l_index IN 1..p_category_id_tbl.COUNT
219: LOOP

Line 262: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN

258: p_encoded => FND_API.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data );
261:
262: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN
263: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
264: THEN
265: x_return_status := FND_API.g_ret_sts_error;
266: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');

Line 453: IF ibe_dspmgrvalidation_grp.check_category_exists(

449:
450: IF p_category_id <> FND_API.g_miss_num OR
451: p_category_id IS NOT NULL
452: THEN
453: IF ibe_dspmgrvalidation_grp.check_category_exists(
454: p_category_id) = false
455: THEN
456: RAISE FND_API.g_exc_error;
457: END IF; /* category exists check */

Line 459: RAISE ibe_dspmgrvalidation_grp.category_req_exception;

455: THEN
456: RAISE FND_API.g_exc_error;
457: END IF; /* category exists check */
458: ELSE
459: RAISE ibe_dspmgrvalidation_grp.category_req_exception;
460: end if; /* category id is not null check */
461:
462: --- Add all the entries
463: FOR l_index IN 1..p_template_id_tbl.COUNT

Line 507: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN

503: p_encoded => FND_API.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data );
506:
507: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN
508: ROLLBACK TO add_ctg_tpl;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
510: THEN
511: x_return_status := FND_API.g_ret_sts_error;