DBA Data[Home] [Help]

APPS.GL_LEDGERS_PKG dependencies on FND_MSG_PUB

Line 290: fnd_msg_pub.initialize;

286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:
289: IF fnd_api.to_boolean(p_init_msg_list) THEN
290: fnd_msg_pub.initialize;
291: END IF;
292:
293: x_return_status := fnd_api.g_ret_sts_success;
294:

Line 391: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,

387: AND conversion_type <> 'EMU FIXED'
388: AND conversion_type = x_period_average_rate_type;
389: EXCEPTION
390: WHEN NO_DATA_FOUND THEN
391: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,
392: -- 'Invalid period_average_rate_type');
393: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PAVE_RATETYPE');
394: fnd_msg_pub.ADD;
395: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 394: fnd_msg_pub.ADD;

390: WHEN NO_DATA_FOUND THEN
391: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,
392: -- 'Invalid period_average_rate_type');
393: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PAVE_RATETYPE');
394: fnd_msg_pub.ADD;
395: x_return_status := fnd_api.g_ret_sts_unexp_error;
396: END;
397: END IF;
398:

Line 410: fnd_msg_pub.ADD;

406: AND conversion_type = x_period_end_rate_type;
407: EXCEPTION
408: WHEN NO_DATA_FOUND THEN
409: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PEND_RATETYPE');
410: fnd_msg_pub.ADD;
411: x_return_status := fnd_api.g_ret_sts_unexp_error;
412: END;
413: END IF;
414:

Line 425: fnd_msg_pub.ADD;

421: AND language_code = x_sla_description_language;
422: EXCEPTION
423: WHEN NO_DATA_FOUND THEN
424: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_JE_DESC');
425: fnd_msg_pub.ADD;
426: x_return_status := fnd_api.g_ret_sts_unexp_error;
427: END;
428: END IF;*/
429:

Line 440: fnd_msg_pub.ADD;

436: EXCEPTION
437: WHEN NO_DATA_FOUND THEN
438: fnd_message.set_name('SQLGL',
439: 'GL_ASF_LGR_JE_REVERSAL_INVALID');
440: fnd_msg_pub.ADD;
441: x_return_status := fnd_api.g_ret_sts_unexp_error;
442: END;
443: END IF;
444:

Line 553: fnd_msg_pub.ADD;

549: CLOSE c;
550:
551: --RAISE NO_DATA_FOUND;
552: --The following new style is used for transferring error message back to OA FWK page
553: fnd_msg_pub.ADD;
554: x_return_status := fnd_api.g_ret_sts_unexp_error;
555: END IF;
556:
557: CLOSE c;

Line 578: fnd_msg_pub.ADD;

574: x_last_update_login,
575: x_creation_date, x_created_by);
576: EXCEPTION
577: WHEN OTHERS THEN
578: fnd_msg_pub.ADD;
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: IF sqlerrm is not null
581: then
582: fnd_message.set_name('SQLGL', 'DB-ERROR');

Line 584: fnd_msg_pub.add;

580: IF sqlerrm is not null
581: then
582: fnd_message.set_name('SQLGL', 'DB-ERROR');
583: fnd_message.set_token ('Message ', sqlerrm);
584: fnd_msg_pub.add;
585: END IF;
586: END;
587:
588: -- Insert rows into gl_autoreverse_options table for the

Line 642: x_msg_count := fnd_msg_pub.count_msg;

638: x_last_update_login,
639: '', '', '', '');
640: END IF;
641:
642: x_msg_count := fnd_msg_pub.count_msg;
643: x_msg_data := fnd_message.get;
644:
645: IF x_msg_count > 0 THEN
646: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 655: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

651: IF p_commit = fnd_api.g_true THEN
652: ROLLBACK TO complete_workorder;
653: END IF;
654:
655: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
656: p_procedure_name => l_api_name);
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: WHEN fnd_api.g_exc_error THEN
659: IF p_commit = fnd_api.g_true THEN

Line 663: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

659: IF p_commit = fnd_api.g_true THEN
660: ROLLBACK TO complete_workorder;
661: END IF;
662:
663: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
664: p_procedure_name => l_api_name);
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: WHEN OTHERS THEN
667: IF p_commit = fnd_api.g_true THEN

Line 671: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

667: IF p_commit = fnd_api.g_true THEN
668: ROLLBACK TO complete_workorder;
669: END IF;
670:
671: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
672: p_procedure_name => l_api_name);
673: x_return_status := fnd_api.g_ret_sts_unexp_error;
674: END insert_row;
675:

Line 858: fnd_msg_pub.initialize;

854: RAISE fnd_api.g_exc_unexpected_error;
855: END IF;
856:
857: IF fnd_api.to_boolean(p_init_msg_list) THEN
858: fnd_msg_pub.initialize;
859: END IF;
860:
861: x_return_status := fnd_api.g_ret_sts_success;
862:

Line 982: fnd_msg_pub.ADD;

978: AND conversion_type = x_period_average_rate_type;
979: EXCEPTION
980: WHEN NO_DATA_FOUND THEN
981: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PAVE_RATETYPE');
982: fnd_msg_pub.ADD;
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: END;
985: END IF;
986:

Line 998: fnd_msg_pub.ADD;

994: AND conversion_type = x_period_end_rate_type;
995: EXCEPTION
996: WHEN NO_DATA_FOUND THEN
997: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PEND_RATETYPE');
998: fnd_msg_pub.ADD;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000: END;
1001: END IF;
1002:

Line 1013: fnd_msg_pub.ADD;

1009: AND language_code = x_sla_description_language;
1010: EXCEPTION
1011: WHEN NO_DATA_FOUND THEN
1012: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_JE_DESC');
1013: fnd_msg_pub.ADD;
1014: x_return_status := fnd_api.g_ret_sts_unexp_error;
1015: END;
1016: END IF;
1017:

Line 1028: fnd_msg_pub.ADD;

1024: EXCEPTION
1025: WHEN NO_DATA_FOUND THEN
1026: fnd_message.set_name('SQLGL',
1027: 'GL_ASF_LGR_JE_REVERSAL_INVALID');
1028: fnd_msg_pub.ADD;
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: END;
1031: END IF;
1032:

Line 1373: fnd_msg_pub.ADD;

1369:
1370: -- Bug fix 3265048: Move this check before updating ALC ledgers
1371: IF (SQL%NOTFOUND) THEN
1372: --RAISE NO_DATA_FOUND;
1373: fnd_msg_pub.ADD;
1374: x_return_status := fnd_api.g_ret_sts_unexp_error;
1375: END IF;
1376:
1377: IF ( ( (x_current_sla_actg_method_code IS NULL)

Line 1640: x_msg_count := fnd_msg_pub.count_msg;

1636: -- END IF; -- IF (NOT gl_suspense_accounts_pkg.is_ledger_suspense...
1637: END LOOP; -- FOR v_alc IN c_alc_ledgers
1638: -- END IF;
1639:
1640: x_msg_count := fnd_msg_pub.count_msg;
1641:
1642: IF x_msg_count > 0 THEN
1643: x_return_status := fnd_api.g_ret_sts_unexp_error;
1644: RAISE fnd_api.g_exc_error;

Line 1652: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

1648: IF p_commit = fnd_api.g_true THEN
1649: ROLLBACK TO complete_workorder;
1650: END IF;
1651:
1652: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1653: p_procedure_name => l_api_name);
1654: x_return_status := fnd_api.g_ret_sts_unexp_error;
1655: WHEN fnd_api.g_exc_error THEN
1656: IF p_commit = fnd_api.g_true THEN

Line 1660: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

1656: IF p_commit = fnd_api.g_true THEN
1657: ROLLBACK TO complete_workorder;
1658: END IF;
1659:
1660: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1661: p_procedure_name => l_api_name);
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: WHEN OTHERS THEN
1664: IF p_commit = fnd_api.g_true THEN

Line 1668: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

1664: IF p_commit = fnd_api.g_true THEN
1665: ROLLBACK TO complete_workorder;
1666: END IF;
1667:
1668: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1669: p_procedure_name => l_api_name);
1670: x_return_status := fnd_api.g_ret_sts_unexp_error;
1671: END update_row;
1672: