DBA Data[Home] [Help]

APPS.IBE_TPLCATEGORY_GRP dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

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

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

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

Line 135: FND_MSG_PUB.add;

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

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

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

Line 143: FND_MSG_PUB.add;

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');
143: FND_MSG_PUB.add;
144: END IF;
145:
146: WHEN OTHERS THEN
147: ROLLBACK TO add_tpl_ctg_rec;

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

146: WHEN OTHERS THEN
147: ROLLBACK TO add_tpl_ctg_rec;
148: x_return_status := FND_API.g_ret_sts_unexp_error ;
149:
150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
151: THEN
152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
153: END IF;
154: END add_tpl_ctg_rec;

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

148: x_return_status := FND_API.g_ret_sts_unexp_error ;
149:
150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
151: THEN
152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
153: END IF;
154: END add_tpl_ctg_rec;
155: -----------------------------------------------------------------------+
156: -- NOTES

Line 199: FND_MSG_PUB.initialize;

195: END IF;
196:
197: IF FND_API.to_boolean(p_init_msg_list)
198: THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:

Line 241: FND_MSG_PUB.count_and_get(

237: THEN
238: COMMIT;
239: END IF;
240:
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data );
245: EXCEPTION

Line 249: FND_MSG_PUB.count_and_get(

245: EXCEPTION
246: WHEN FND_API.g_exc_error THEN
247: ROLLBACK TO add_tpl_ctg;
248: x_return_status := FND_API.g_ret_sts_error;
249: FND_MSG_PUB.count_and_get(
250: p_encoded => FND_API.g_false,
251: p_count => x_msg_count,
252: p_data => x_msg_data );
253:

Line 257: FND_MSG_PUB.count_and_get(

253:
254: WHEN FND_API.g_exc_unexpected_error THEN
255: ROLLBACK TO add_tpl_ctg;
256: x_return_status := FND_API.g_ret_sts_unexp_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 263: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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

Line 267: FND_MSG_PUB.add;

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');
267: FND_MSG_PUB.add;
268: END IF;
269: FND_MSG_PUB.count_and_get(
270: p_encoded => FND_API.g_false,
271: p_count => x_msg_count,

Line 269: FND_MSG_PUB.count_and_get(

265: x_return_status := FND_API.g_ret_sts_error;
266: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
267: FND_MSG_PUB.add;
268: END IF;
269: FND_MSG_PUB.count_and_get(
270: p_encoded => FND_API.g_false,
271: p_count => x_msg_count,
272: p_data => x_msg_data );
273:

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

274: WHEN OTHERS THEN
275: ROLLBACK TO add_tpl_ctg;
276: x_return_status := FND_API.g_ret_sts_unexp_error ;
277:
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
279: THEN
280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282:

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

276: x_return_status := FND_API.g_ret_sts_unexp_error ;
277:
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
279: THEN
280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282:
283: FND_MSG_PUB.count_and_get(
284: p_encoded => FND_API.g_false,

Line 283: FND_MSG_PUB.count_and_get(

279: THEN
280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282:
283: FND_MSG_PUB.count_and_get(
284: p_encoded => FND_API.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data );
287: END add_tpl_ctg;

Line 329: FND_MSG_PUB.initialize;

325: END IF;
326:
327: IF FND_API.to_boolean(p_init_msg_list)
328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:

Line 368: FND_MSG_PUB.count_and_get(

364: THEN
365: COMMIT;
366: END IF;
367:
368: FND_MSG_PUB.count_and_get(
369: p_encoded => FND_API.g_false,
370: p_count => x_msg_count,
371: p_data => x_msg_data );
372: EXCEPTION

Line 376: FND_MSG_PUB.count_and_get(

372: EXCEPTION
373: WHEN FND_API.g_exc_error THEN
374: ROLLBACK TO delete_tpl_ctg_relation;
375: x_return_status := FND_API.g_ret_sts_error;
376: FND_MSG_PUB.count_and_get(
377: p_encoded => FND_API.g_false,
378: p_count => x_msg_count,
379: p_data => x_msg_data );
380:

Line 384: FND_MSG_PUB.count_and_get(

380:
381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO delete_tpl_ctg_relation;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,
386: p_count => x_msg_count,
387: p_data => x_msg_data );
388:

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

389: WHEN OTHERS THEN
390: ROLLBACK TO delete_tpl_ctg_relation;
391: x_return_status := FND_API.g_ret_sts_unexp_error ;
392:
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
394: THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: END IF;
397:

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

391: x_return_status := FND_API.g_ret_sts_unexp_error ;
392:
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
394: THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: END IF;
397:
398: FND_MSG_PUB.count_and_get(
399: p_encoded => FND_API.g_false,

Line 398: FND_MSG_PUB.count_and_get(

394: THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: END IF;
397:
398: FND_MSG_PUB.count_and_get(
399: p_encoded => FND_API.g_false,
400: p_count => x_msg_count,
401: p_data => x_msg_data );
402: END delete_tpl_ctg_relation;

Line 445: FND_MSG_PUB.initialize;

441: END IF;
442:
443: IF FND_API.to_boolean(p_init_msg_list)
444: THEN
445: FND_MSG_PUB.initialize;
446: END IF;
447:
448: x_return_status := FND_API.g_ret_sts_success;
449:

Line 486: FND_MSG_PUB.count_and_get(

482: THEN
483: COMMIT;
484: END IF;
485:
486: FND_MSG_PUB.count_and_get(
487: p_encoded => FND_API.g_false,
488: p_count => x_msg_count,
489: p_data => x_msg_data );
490: EXCEPTION

Line 494: FND_MSG_PUB.count_and_get(

490: EXCEPTION
491: WHEN FND_API.g_exc_error THEN
492: ROLLBACK TO add_ctg_tpl;
493: x_return_status := FND_API.g_ret_sts_error;
494: FND_MSG_PUB.count_and_get(
495: p_encoded => FND_API.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data );
498:

Line 502: FND_MSG_PUB.count_and_get(

498:
499: WHEN FND_API.g_exc_unexpected_error THEN
500: ROLLBACK TO add_ctg_tpl;
501: x_return_status := FND_API.g_ret_sts_unexp_error ;
502: FND_MSG_PUB.count_and_get(
503: p_encoded => FND_API.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data );
506:

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

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;
512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;

Line 513: FND_MSG_PUB.add;

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;
512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;
514: END IF;
515: FND_MSG_PUB.count_and_get(
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,

Line 515: FND_MSG_PUB.count_and_get(

511: x_return_status := FND_API.g_ret_sts_error;
512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;
514: END IF;
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 524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

520: WHEN OTHERS THEN
521: ROLLBACK TO add_ctg_tpl;
522: x_return_status := FND_API.g_ret_sts_unexp_error ;
523:
524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
525: THEN
526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
527: END IF;
528:

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

522: x_return_status := FND_API.g_ret_sts_unexp_error ;
523:
524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
525: THEN
526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
527: END IF;
528:
529: FND_MSG_PUB.count_and_get(
530: p_encoded => FND_API.g_false,

Line 529: FND_MSG_PUB.count_and_get(

525: THEN
526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
527: END IF;
528:
529: FND_MSG_PUB.count_and_get(
530: p_encoded => FND_API.g_false,
531: p_count => x_msg_count,
532: p_data => x_msg_data );
533: END ADD_CTG_TPL;