DBA Data[Home] [Help]

APPS.GL_LEDGERS_PKG dependencies on FND_MSG_PUB

Line 293: fnd_msg_pub.initialize;

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

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

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

Line 397: fnd_msg_pub.ADD;

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

Line 413: fnd_msg_pub.ADD;

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

Line 428: fnd_msg_pub.ADD;

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

Line 443: fnd_msg_pub.ADD;

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

Line 556: fnd_msg_pub.ADD;

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

Line 581: fnd_msg_pub.ADD;

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

Line 587: fnd_msg_pub.add;

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

Line 645: x_msg_count := fnd_msg_pub.count_msg;

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

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

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

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

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

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

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

Line 863: fnd_msg_pub.initialize;

859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;
861:
862: IF fnd_api.to_boolean(p_init_msg_list) THEN
863: fnd_msg_pub.initialize;
864: END IF;
865:
866: x_return_status := fnd_api.g_ret_sts_success;
867:

Line 987: fnd_msg_pub.ADD;

983: AND conversion_type = x_period_average_rate_type;
984: EXCEPTION
985: WHEN NO_DATA_FOUND THEN
986: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PAVE_RATETYPE');
987: fnd_msg_pub.ADD;
988: x_return_status := fnd_api.g_ret_sts_unexp_error;
989: END;
990: END IF;
991:

Line 1003: fnd_msg_pub.ADD;

999: AND conversion_type = x_period_end_rate_type;
1000: EXCEPTION
1001: WHEN NO_DATA_FOUND THEN
1002: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PEND_RATETYPE');
1003: fnd_msg_pub.ADD;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: END;
1006: END IF;
1007:

Line 1018: fnd_msg_pub.ADD;

1014: AND language_code = x_sla_description_language;
1015: EXCEPTION
1016: WHEN NO_DATA_FOUND THEN
1017: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_JE_DESC');
1018: fnd_msg_pub.ADD;
1019: x_return_status := fnd_api.g_ret_sts_unexp_error;
1020: END;
1021: END IF;
1022:

Line 1033: fnd_msg_pub.ADD;

1029: EXCEPTION
1030: WHEN NO_DATA_FOUND THEN
1031: fnd_message.set_name('SQLGL',
1032: 'GL_ASF_LGR_JE_REVERSAL_INVALID');
1033: fnd_msg_pub.ADD;
1034: x_return_status := fnd_api.g_ret_sts_unexp_error;
1035: END;
1036: END IF;
1037:

Line 1380: fnd_msg_pub.ADD;

1376:
1377: -- Bug fix 3265048: Move this check before updating ALC ledgers
1378: IF (SQL%NOTFOUND) THEN
1379: --RAISE NO_DATA_FOUND;
1380: fnd_msg_pub.ADD;
1381: x_return_status := fnd_api.g_ret_sts_unexp_error;
1382: END IF;
1383:
1384: IF ( ( (x_current_sla_actg_method_code IS NULL)

Line 1647: x_msg_count := fnd_msg_pub.count_msg;

1643: -- END IF; -- IF (NOT gl_suspense_accounts_pkg.is_ledger_suspense...
1644: END LOOP; -- FOR v_alc IN c_alc_ledgers
1645: -- END IF;
1646:
1647: x_msg_count := fnd_msg_pub.count_msg;
1648:
1649: IF x_msg_count > 0 THEN
1650: x_return_status := fnd_api.g_ret_sts_unexp_error;
1651: RAISE fnd_api.g_exc_error;

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

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

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

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

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

1671: IF p_commit = fnd_api.g_true THEN
1672: ROLLBACK TO complete_workorder;
1673: END IF;
1674:
1675: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1676: p_procedure_name => l_api_name);
1677: x_return_status := fnd_api.g_ret_sts_unexp_error;
1678: END update_row;
1679: