DBA Data[Home] [Help]

APPS.CST_XLA_PVT dependencies on FND_MSG_PUB

Line 428: FND_MSG_PUB.initialize;

424: END IF;
425:
426: -- Initialize message list if p_init_msg_list is set to TRUE
427: IF FND_API.to_Boolean(p_init_msg_list) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Initialize API return status to success
432: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 594: -- FND_MSG_PUB.ADD;

590: -- debug(' error code:'||l_retcode);
591: -- IF l_retcode = 2 THEN
592: -- IF l_retcode = 'XLA_UPG_HIST_RUNNING' THEN
593: -- FND_MESSAGE.set_name('XLA', 'XLA_UPG_HIST_RUNNING');
594: -- FND_MSG_PUB.ADD;
595: -- ELSE
596: -- FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_WARNING');
597: -- FND_MSG_PUB.ADD;
598: -- END IF;

Line 597: -- FND_MSG_PUB.ADD;

593: -- FND_MESSAGE.set_name('XLA', 'XLA_UPG_HIST_RUNNING');
594: -- FND_MSG_PUB.ADD;
595: -- ELSE
596: -- FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_WARNING');
597: -- FND_MSG_PUB.ADD;
598: -- END IF;
599: -- RAISE FND_API.G_EXC_ERROR;
600: -- ELSE
601: --}

Line 607: -- IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

603: -- END IF; /*End l_retcode = 2*/
604:
605: -- END IF; /*End l_retcode <> 0*/
606:
607: -- IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
608: -- FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_SUCCESS');
609: -- FND_MSG_PUB.ADD;
610: -- END IF;
611:

Line 609: -- FND_MSG_PUB.ADD;

605: -- END IF; /*End l_retcode <> 0*/
606:
607: -- IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
608: -- FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_SUCCESS');
609: -- FND_MSG_PUB.ADD;
610: -- END IF;
611:
612: -- END IF; /* End l_accounting_option = 1*/
613:

Line 782: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

778: EXCEPTION
779: WHEN FND_API.g_exc_error THEN
780: ROLLBACK TO Create_RCVXLAEvent;
781: x_return_status := FND_API.g_ret_sts_error;
782: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
783: FND_MSG_PUB.add_exc_msg
784: ( G_PKG_NAME,
785: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message
786: );

Line 783: FND_MSG_PUB.add_exc_msg

779: WHEN FND_API.g_exc_error THEN
780: ROLLBACK TO Create_RCVXLAEvent;
781: x_return_status := FND_API.g_ret_sts_error;
782: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
783: FND_MSG_PUB.add_exc_msg
784: ( G_PKG_NAME,
785: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message
786: );
787: end if;

Line 788: FND_MSG_PUB.count_and_get

784: ( G_PKG_NAME,
785: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message
786: );
787: end if;
788: FND_MSG_PUB.count_and_get
789: ( p_count => x_msg_count,
790: p_data => x_msg_data
791: );
792: WHEN FND_API.g_exc_unexpected_error THEN

Line 796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

792: WHEN FND_API.g_exc_unexpected_error THEN
793: ROLLBACK TO Create_RCVXLAEvent;
794: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
795: x_return_status := FND_API.g_ret_sts_unexp_error ;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: FND_MSG_PUB.add_exc_msg
798: ( G_PKG_NAME,
799: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
800: );

Line 797: FND_MSG_PUB.add_exc_msg

793: ROLLBACK TO Create_RCVXLAEvent;
794: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
795: x_return_status := FND_API.g_ret_sts_unexp_error ;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: FND_MSG_PUB.add_exc_msg
798: ( G_PKG_NAME,
799: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
800: );
801: end if;

Line 802: FND_MSG_PUB.count_and_get

798: ( G_PKG_NAME,
799: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
800: );
801: end if;
802: FND_MSG_PUB.count_and_get
803: ( p_count => x_msg_count,
804: p_data => x_msg_data
805: );
806: WHEN OTHERS THEN

Line 815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

811: IF l_unexpLog THEN
812: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num
813: ,'Create_RCVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
814: END IF;
815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
816: FND_MSG_PUB.add_exc_msg
817: ( G_PKG_NAME,
818: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
819: );

Line 816: FND_MSG_PUB.add_exc_msg

812: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num
813: ,'Create_RCVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
814: END IF;
815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
816: FND_MSG_PUB.add_exc_msg
817: ( G_PKG_NAME,
818: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
819: );
820: END IF;

Line 821: FND_MSG_PUB.count_and_get

817: ( G_PKG_NAME,
818: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
819: );
820: END IF;
821: FND_MSG_PUB.count_and_get
822: ( p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825:

Line 935: FND_MSG_PUB.initialize;

931:
932: l_stmt_num := 10;
933: -- Initialize message list if p_init_msg_list is set to TRUE
934: IF FND_API.to_Boolean(p_init_msg_list) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: -- Initialize API return status to success
939: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1529: FND_MSG_PUB.count_and_get

1525: EXCEPTION
1526: WHEN FND_API.g_exc_error THEN
1527: ROLLBACK TO Create_INVXLAEvent;
1528: x_return_status := FND_API.g_ret_sts_error;
1529: FND_MSG_PUB.count_and_get
1530: ( p_count => x_msg_count,
1531: p_data => x_msg_data
1532: );
1533: WHEN FND_API.g_exc_unexpected_error THEN

Line 1536: FND_MSG_PUB.count_and_get

1532: );
1533: WHEN FND_API.g_exc_unexpected_error THEN
1534: ROLLBACK TO Create_INVXLAEvent;
1535: x_return_status := FND_API.g_ret_sts_unexp_error ;
1536: FND_MSG_PUB.count_and_get
1537: ( p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );
1540: WHEN OTHERS THEN

Line 1547: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1543: IF l_unexpLog THEN
1544: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1545: END IF;
1546:
1547: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1548: FND_MSG_PUB.add_exc_msg
1549: ( G_PKG_NAME,
1550: l_api_name || 'Statement -'||to_char(l_stmt_num)
1551: );

Line 1548: FND_MSG_PUB.add_exc_msg

1544: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1545: END IF;
1546:
1547: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1548: FND_MSG_PUB.add_exc_msg
1549: ( G_PKG_NAME,
1550: l_api_name || 'Statement -'||to_char(l_stmt_num)
1551: );
1552: END IF;

Line 1553: FND_MSG_PUB.count_and_get

1549: ( G_PKG_NAME,
1550: l_api_name || 'Statement -'||to_char(l_stmt_num)
1551: );
1552: END IF;
1553: FND_MSG_PUB.count_and_get
1554: ( p_count => x_msg_count,
1555: p_data => x_msg_data
1556: );
1557: END Create_INVXLAEvent;

Line 1651: FND_MSG_PUB.initialize;

1647: END IF;
1648:
1649: -- Initialize message list if p_init_msg_list is set to TRUE
1650: IF FND_API.to_Boolean(p_init_msg_list) THEN
1651: FND_MSG_PUB.initialize;
1652: END IF;
1653:
1654: -- Initialize API return status to success
1655: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1796: FND_MSG_PUB.count_and_get

1792: EXCEPTION
1793: WHEN FND_API.g_exc_error THEN
1794: ROLLBACK TO Create_WIPXLAEvent;
1795: x_return_status := FND_API.g_ret_sts_error;
1796: FND_MSG_PUB.count_and_get
1797: ( p_count => x_msg_count,
1798: p_data => x_msg_data
1799: );
1800: WHEN FND_API.g_exc_unexpected_error THEN

Line 1803: FND_MSG_PUB.count_and_get

1799: );
1800: WHEN FND_API.g_exc_unexpected_error THEN
1801: ROLLBACK TO Create_WIPXLAEvent;
1802: x_return_status := FND_API.g_ret_sts_unexp_error ;
1803: FND_MSG_PUB.count_and_get
1804: ( p_count => x_msg_count,
1805: p_data => x_msg_data
1806: );
1807: WHEN OTHERS THEN

Line 1815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1811: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
1812: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1813: END IF;
1814:
1815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1816: FND_MSG_PUB.add_exc_msg
1817: ( G_PKG_NAME,
1818: l_api_name || 'Statement -'||to_char(l_stmt_num)
1819: );

Line 1816: FND_MSG_PUB.add_exc_msg

1812: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1813: END IF;
1814:
1815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1816: FND_MSG_PUB.add_exc_msg
1817: ( G_PKG_NAME,
1818: l_api_name || 'Statement -'||to_char(l_stmt_num)
1819: );
1820: END IF;

Line 1821: FND_MSG_PUB.count_and_get

1817: ( G_PKG_NAME,
1818: l_api_name || 'Statement -'||to_char(l_stmt_num)
1819: );
1820: END IF;
1821: FND_MSG_PUB.count_and_get
1822: ( p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );
1825:

Line 1910: FND_MSG_PUB.initialize;

1906: END IF;
1907:
1908: -- Initialize message list if p_init_msg_list is set to TRUE
1909: IF FND_API.to_Boolean(p_init_msg_list) THEN
1910: FND_MSG_PUB.initialize;
1911: END IF;
1912:
1913: -- Initialize API return status to success
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2062: FND_MSG_PUB.count_and_get

2058: EXCEPTION
2059: WHEN FND_API.g_exc_error THEN
2060: ROLLBACK TO CreateBulk_WIPXLAEvent;
2061: x_return_status := FND_API.g_ret_sts_error;
2062: FND_MSG_PUB.count_and_get
2063: ( p_count => x_msg_count,
2064: p_data => x_msg_data
2065: );
2066: WHEN FND_API.g_exc_unexpected_error THEN

Line 2069: FND_MSG_PUB.count_and_get

2065: );
2066: WHEN FND_API.g_exc_unexpected_error THEN
2067: ROLLBACK TO CreateBulk_WIPXLAEvent;
2068: x_return_status := FND_API.g_ret_sts_unexp_error ;
2069: FND_MSG_PUB.count_and_get
2070: ( p_count => x_msg_count,
2071: p_data => x_msg_data
2072: );
2073: WHEN OTHERS THEN

Line 2080: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2076: IF l_unexpLog THEN
2077: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2078: END IF;
2079:
2080: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2081: FND_MSG_PUB.add_exc_msg
2082: ( G_PKG_NAME,
2083: l_api_name || 'Statement -'||to_char(l_stmt_num)
2084: );

Line 2081: FND_MSG_PUB.add_exc_msg

2077: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2078: END IF;
2079:
2080: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2081: FND_MSG_PUB.add_exc_msg
2082: ( G_PKG_NAME,
2083: l_api_name || 'Statement -'||to_char(l_stmt_num)
2084: );
2085: END IF;

Line 2086: FND_MSG_PUB.count_and_get

2082: ( G_PKG_NAME,
2083: l_api_name || 'Statement -'||to_char(l_stmt_num)
2084: );
2085: END IF;
2086: FND_MSG_PUB.count_and_get
2087: ( p_count => x_msg_count,
2088: p_data => x_msg_data
2089: );
2090:

Line 2174: FND_MSG_PUB.initialize;

2170: END IF;
2171:
2172: -- Initialize message list if p_init_msg_list is set to TRUE
2173: IF FND_API.to_Boolean(p_init_msg_list) THEN
2174: FND_MSG_PUB.initialize;
2175: END IF;
2176:
2177: -- Initialize API return status to success
2178: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2294: FND_MSG_PUB.count_and_get

2290: EXCEPTION
2291: WHEN FND_API.g_exc_error THEN
2292: ROLLBACK TO Create_CostUpdateXLAEvent;
2293: x_return_status := FND_API.g_ret_sts_error;
2294: FND_MSG_PUB.count_and_get
2295: ( p_count => x_msg_count,
2296: p_data => x_msg_data
2297: );
2298: WHEN FND_API.g_exc_unexpected_error THEN

Line 2301: FND_MSG_PUB.count_and_get

2297: );
2298: WHEN FND_API.g_exc_unexpected_error THEN
2299: ROLLBACK TO Create_CostUpdateXLAEvent;
2300: x_return_status := FND_API.g_ret_sts_unexp_error ;
2301: FND_MSG_PUB.count_and_get
2302: ( p_count => x_msg_count,
2303: p_data => x_msg_data
2304: );
2305: WHEN OTHERS THEN

Line 2312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2308: IF l_unexpLog THEN
2309: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2310: END IF;
2311:
2312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: FND_MSG_PUB.add_exc_msg
2314: ( G_PKG_NAME,
2315: l_api_name || 'Statement -'||to_char(l_stmt_num)
2316: );

Line 2313: FND_MSG_PUB.add_exc_msg

2309: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2310: END IF;
2311:
2312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: FND_MSG_PUB.add_exc_msg
2314: ( G_PKG_NAME,
2315: l_api_name || 'Statement -'||to_char(l_stmt_num)
2316: );
2317: END IF;

Line 2318: FND_MSG_PUB.count_and_get

2314: ( G_PKG_NAME,
2315: l_api_name || 'Statement -'||to_char(l_stmt_num)
2316: );
2317: END IF;
2318: FND_MSG_PUB.count_and_get
2319: ( p_count => x_msg_count,
2320: p_data => x_msg_data
2321: );
2322:

Line 2405: FND_MSG_PUB.initialize;

2401: END IF;
2402:
2403: -- Initialize message list if p_init_msg_list is set to TRUE
2404: IF FND_API.to_Boolean(p_init_msg_list) THEN
2405: FND_MSG_PUB.initialize;
2406: END IF;
2407:
2408: -- Initialize API return status to success
2409: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2510: FND_MSG_PUB.count_and_get

2506: EXCEPTION
2507: WHEN FND_API.g_exc_error THEN
2508: ROLLBACK TO Create_WIPUpdateXLAEvent;
2509: x_return_status := FND_API.g_ret_sts_error;
2510: FND_MSG_PUB.count_and_get
2511: ( p_count => x_msg_count,
2512: p_data => x_msg_data
2513: );
2514: WHEN FND_API.g_exc_unexpected_error THEN

Line 2517: FND_MSG_PUB.count_and_get

2513: );
2514: WHEN FND_API.g_exc_unexpected_error THEN
2515: ROLLBACK TO Create_WIPUpdateXLAEvent;
2516: x_return_status := FND_API.g_ret_sts_unexp_error ;
2517: FND_MSG_PUB.count_and_get
2518: ( p_count => x_msg_count,
2519: p_data => x_msg_data
2520: );
2521: WHEN OTHERS THEN

Line 2529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2525: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
2526: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2527: END IF;
2528:
2529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2530: FND_MSG_PUB.add_exc_msg
2531: ( G_PKG_NAME,
2532: l_api_name || 'Statement -'||to_char(l_stmt_num)
2533: );

Line 2530: FND_MSG_PUB.add_exc_msg

2526: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2527: END IF;
2528:
2529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2530: FND_MSG_PUB.add_exc_msg
2531: ( G_PKG_NAME,
2532: l_api_name || 'Statement -'||to_char(l_stmt_num)
2533: );
2534: END IF;

Line 2535: FND_MSG_PUB.count_and_get

2531: ( G_PKG_NAME,
2532: l_api_name || 'Statement -'||to_char(l_stmt_num)
2533: );
2534: END IF;
2535: FND_MSG_PUB.count_and_get
2536: ( p_count => x_msg_count,
2537: p_data => x_msg_data
2538: );
2539: