APPS.JTF_TPLCATEGORY_GRP dependencies on JTF_DSPMGRVALIDATION_GRP

Line 63: IF jtf_dspmgrvalidation_grp.check_deliverable_type_exists(p_template_id,l_type ,l_applicable_to)

59:
60: --- Check if the deliverable id exists .
61: IF p_template_id <> FND_API.g_miss_num and p_template_id is not null
62: then
63: IF jtf_dspmgrvalidation_grp.check_deliverable_type_exists(p_template_id,l_type ,l_applicable_to)
64: then
65: ---dbms_output.put_line('passed template check in add_tpl_ctg_rec' || p_template_id );
66:
67: IF p_category_id <> FND_API.g_miss_num and p_category_id is not null

Line 69: if jtf_dspmgrvalidation_grp.check_category_exists(p_category_id)

65: ---dbms_output.put_line('passed template check in add_tpl_ctg_rec' || p_template_id );
66:
67: IF p_category_id <> FND_API.g_miss_num and p_category_id is not null
68: THEN
69: if jtf_dspmgrvalidation_grp.check_category_exists(p_category_id)
70: then
71: ---dbms_output.put_line('passed category check in add_tpl_ctg_rec' || p_category_id );
72:
73: if jtf_dspmgrvalidation_grp.check_ctg_tpl_relation_exists( p_category_id,

Line 73: if jtf_dspmgrvalidation_grp.check_ctg_tpl_relation_exists( p_category_id,

69: if jtf_dspmgrvalidation_grp.check_category_exists(p_category_id)
70: then
71: ---dbms_output.put_line('passed category check in add_tpl_ctg_rec' || p_category_id );
72:
73: if jtf_dspmgrvalidation_grp.check_ctg_tpl_relation_exists( p_category_id,
74: p_template_id) = false then
75:
76: OPEN dsp_tpl_seq;
77: FETCH dsp_tpl_seq INTO l_dsp_tpl_seq_id;

Line 109: raise jtf_dspmgrvalidation_grp.category_req_exception;

105: else
106: raise FND_API.g_exc_error;
107: end if; /* category exists check */
108: else
109: raise jtf_dspmgrvalidation_grp.category_req_exception;
110: end if; /* category id is not null check */
111: else
112: raise FND_API.g_exc_error;
113: END IF;/* deliverable exists check */

Line 115: raise jtf_dspmgrvalidation_grp.template_req_exception;

111: else
112: raise FND_API.g_exc_error;
113: END IF;/* deliverable exists check */
114: else
115: raise jtf_dspmgrvalidation_grp.template_req_exception;
116: end if; /*deliverable id is not null check */
117:
118:
119: --- Check if the caller requested to commit ,

Line 139: WHEN jtf_dspmgrvalidation_grp.category_req_exception THEN

135: WHEN FND_API.g_exc_unexpected_error THEN
136: ROLLBACK TO add_tpl_ctg_rec;
137: x_return_status := FND_API.g_ret_sts_unexp_error ;
138:
139: WHEN jtf_dspmgrvalidation_grp.category_req_exception THEN
140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
141: THEN
142: x_return_status := FND_API.g_ret_sts_error;
143: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');

Line 147: WHEN jtf_dspmgrvalidation_grp.template_req_exception THEN

143: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
144: FND_MSG_PUB.add;
145: END IF;
146:
147: WHEN jtf_dspmgrvalidation_grp.template_req_exception THEN
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
149: THEN
150: x_return_status := FND_API.g_ret_sts_error;
151: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');

Line 219: IF jtf_dspmgrvalidation_grp.check_deliverable_type_exists(p_template_id ,l_type,l_applicable_to) = false then

215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:
217: IF p_template_id is not null and p_template_id <> FND_API.g_miss_num
218: then
219: IF jtf_dspmgrvalidation_grp.check_deliverable_type_exists(p_template_id ,l_type,l_applicable_to) = false then
220: raise FND_API.g_exc_error;
221: END IF;/* deliverable exists check */
222: else
223: raise jtf_dspmgrvalidation_grp.template_req_exception;

Line 223: raise jtf_dspmgrvalidation_grp.template_req_exception;

219: IF jtf_dspmgrvalidation_grp.check_deliverable_type_exists(p_template_id ,l_type,l_applicable_to) = false then
220: raise FND_API.g_exc_error;
221: END IF;/* deliverable exists check */
222: else
223: raise jtf_dspmgrvalidation_grp.template_req_exception;
224: end if; /*deliverable id is not null check */
225:
226:
227: FOR l_index IN 1..p_category_id_tbl.COUNT

Line 273: WHEN jtf_dspmgrvalidation_grp.template_req_exception THEN

269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );
272:
273: WHEN jtf_dspmgrvalidation_grp.template_req_exception THEN
274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
275: THEN
276: x_return_status := FND_API.g_ret_sts_error;
277: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');

Line 487: if jtf_dspmgrvalidation_grp.check_category_exists(p_category_id) = false then

483:
484: IF p_category_id <> FND_API.g_miss_num or
485: p_category_id is not null
486: THEN
487: if jtf_dspmgrvalidation_grp.check_category_exists(p_category_id) = false then
488: ---dbms_output.put_line('passed category check in add_tpl_ctg_rec' || p_category_id );
489: raise FND_API.g_exc_error;
490: end if; /* category exists check */
491: else

Line 492: raise jtf_dspmgrvalidation_grp.category_req_exception;

488: ---dbms_output.put_line('passed category check in add_tpl_ctg_rec' || p_category_id );
489: raise FND_API.g_exc_error;
490: end if; /* category exists check */
491: else
492: raise jtf_dspmgrvalidation_grp.category_req_exception;
493: end if; /* category id is not null check */
494:
495: --- Add all the entries
496: FOR l_index IN 1..p_template_id_tbl.COUNT

Line 541: WHEN jtf_dspmgrvalidation_grp.category_req_exception THEN

537: p_count => x_msg_count,
538: p_data => x_msg_data
539: );
540:
541: WHEN jtf_dspmgrvalidation_grp.category_req_exception THEN
542: ROLLBACK TO add_ctg_tpl;
543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
544: THEN
545: x_return_status := FND_API.g_ret_sts_error;