DBA Data[Home] [Help]

APPS.JTF_TPLCATEGORY_GRP dependencies on FND_MSG_PUB

Line 52: FND_MSG_PUB.initialize;

48: RAISE FND_API.g_exc_unexpected_error;
49: END IF;
50:
51: IF FND_API.to_boolean(p_init_msg_list) THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55: x_return_status := FND_API.g_ret_sts_success;
56:

Line 140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
144: FND_MSG_PUB.add;

Line 144: FND_MSG_PUB.add;

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');
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)

Line 148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
152: FND_MSG_PUB.add;

Line 152: FND_MSG_PUB.add;

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');
152: FND_MSG_PUB.add;
153: END IF;
154:
155: WHEN OTHERS THEN
156: ROLLBACK TO add_tpl_ctg_rec;

Line 159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

155: WHEN OTHERS THEN
156: ROLLBACK TO add_tpl_ctg_rec;
157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158:
159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
160: THEN
161: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
162: END IF;
163: END add_tpl_ctg_rec;

Line 161: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158:
159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
160: THEN
161: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
162: END IF;
163: END add_tpl_ctg_rec;
164: -----------------------------------------------------------------------
165: -- NOTES

Line 212: FND_MSG_PUB.initialize;

208: END IF;
209:
210:
211: IF FND_API.to_boolean(p_init_msg_list) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:

Line 246: FND_MSG_PUB.count_and_get(

242: IF FND_API.to_boolean(p_commit) THEN
243: COMMIT;
244: END IF;
245:
246: FND_MSG_PUB.count_and_get(
247: p_encoded => FND_API.g_false,
248: p_count => x_msg_count,
249: p_data => x_msg_data
250: );

Line 257: FND_MSG_PUB.count_and_get(

253:
254: WHEN FND_API.g_exc_error THEN
255: ROLLBACK TO add_tpl_ctg;
256: x_return_status := FND_API.g_ret_sts_error;
257: FND_MSG_PUB.count_and_get(
258: p_encoded => FND_API.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data
261: );

Line 267: FND_MSG_PUB.count_and_get(

263:
264: WHEN FND_API.g_exc_unexpected_error THEN
265: ROLLBACK TO add_tpl_ctg;
266: x_return_status := FND_API.g_ret_sts_unexp_error ;
267: FND_MSG_PUB.count_and_get(
268: p_encoded => FND_API.g_false,
269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );

Line 274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
278: FND_MSG_PUB.add;

Line 278: FND_MSG_PUB.add;

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');
278: FND_MSG_PUB.add;
279: END IF;
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.g_false,
282: p_count => x_msg_count,

Line 280: FND_MSG_PUB.count_and_get(

276: x_return_status := FND_API.g_ret_sts_error;
277: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');
278: FND_MSG_PUB.add;
279: END IF;
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );

Line 290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

286: WHEN OTHERS THEN
287: ROLLBACK TO add_tpl_ctg;
288: x_return_status := FND_API.g_ret_sts_unexp_error ;
289:
290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
291: THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294:

Line 292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

288: x_return_status := FND_API.g_ret_sts_unexp_error ;
289:
290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
291: THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294:
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,

Line 295: FND_MSG_PUB.count_and_get(

291: THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294:
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );

Line 346: FND_MSG_PUB.initialize;

342: END IF;
343:
344:
345: IF FND_API.to_boolean(p_init_msg_list) THEN
346: FND_MSG_PUB.initialize;
347: END IF;
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:

Line 389: FND_MSG_PUB.count_and_get(

385: IF FND_API.to_boolean(p_commit) THEN
386: COMMIT;
387: END IF;
388:
389: FND_MSG_PUB.count_and_get(
390: p_encoded => FND_API.g_false,
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );

Line 400: FND_MSG_PUB.count_and_get(

396:
397: WHEN FND_API.g_exc_error THEN
398: ROLLBACK TO delete_tpl_ctg_relation;
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: );

Line 409: FND_MSG_PUB.count_and_get(

405:
406: WHEN FND_API.g_exc_unexpected_error THEN
407: ROLLBACK TO delete_tpl_ctg_relation;
408: x_return_status := FND_API.g_ret_sts_unexp_error ;
409: FND_MSG_PUB.count_and_get(
410: p_encoded => FND_API.g_false,
411: p_count => x_msg_count,
412: p_data => x_msg_data
413: );

Line 420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

416: WHEN OTHERS THEN
417: ROLLBACK TO delete_tpl_ctg_relation;
418: x_return_status := FND_API.g_ret_sts_unexp_error ;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
421: THEN
422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
423: END IF;
424:

Line 422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

418: x_return_status := FND_API.g_ret_sts_unexp_error ;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
421: THEN
422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
423: END IF;
424:
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,

Line 425: FND_MSG_PUB.count_and_get(

421: THEN
422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
423: END IF;
424:
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data
429: );

Line 478: FND_MSG_PUB.initialize;

474: END IF;
475:
476:
477: IF FND_API.to_boolean(p_init_msg_list) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480:
481:
482: x_return_status := FND_API.g_ret_sts_success;

Line 515: FND_MSG_PUB.count_and_get(

511: IF FND_API.to_boolean(p_commit) THEN
512: COMMIT;
513: END IF;
514:
515: FND_MSG_PUB.count_and_get(
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,
518: p_data => x_msg_data
519: );

Line 526: FND_MSG_PUB.count_and_get(

522:
523: WHEN FND_API.g_exc_error THEN
524: ROLLBACK TO add_ctg_tpl;
525: x_return_status := FND_API.g_ret_sts_error;
526: FND_MSG_PUB.count_and_get(
527: p_encoded => FND_API.g_false,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );

Line 535: FND_MSG_PUB.count_and_get(

531:
532: WHEN FND_API.g_exc_unexpected_error THEN
533: ROLLBACK TO add_ctg_tpl;
534: x_return_status := FND_API.g_ret_sts_unexp_error ;
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: );

Line 543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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;
546: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
547: FND_MSG_PUB.add;

Line 547: FND_MSG_PUB.add;

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;
546: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
547: FND_MSG_PUB.add;
548: END IF;
549: FND_MSG_PUB.count_and_get(
550: p_encoded => FND_API.g_false,
551: p_count => x_msg_count,

Line 549: FND_MSG_PUB.count_and_get(

545: x_return_status := FND_API.g_ret_sts_error;
546: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
547: FND_MSG_PUB.add;
548: END IF;
549: FND_MSG_PUB.count_and_get(
550: p_encoded => FND_API.g_false,
551: p_count => x_msg_count,
552: p_data => x_msg_data
553: );

Line 559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

555: WHEN OTHERS THEN
556: ROLLBACK TO add_ctg_tpl;
557: x_return_status := FND_API.g_ret_sts_unexp_error ;
558:
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
560: THEN
561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
562: END IF;
563:

Line 561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

557: x_return_status := FND_API.g_ret_sts_unexp_error ;
558:
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
560: THEN
561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
562: END IF;
563:
564: FND_MSG_PUB.count_and_get(
565: p_encoded => FND_API.g_false,

Line 564: FND_MSG_PUB.count_and_get(

560: THEN
561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
562: END IF;
563:
564: FND_MSG_PUB.count_and_get(
565: p_encoded => FND_API.g_false,
566: p_count => x_msg_count,
567: p_data => x_msg_data
568: );