DBA Data[Home] [Help]

APPS.CST_XLA_PVT dependencies on FND_MSG_PUB

Line 337: FND_MSG_PUB.initialize;

333: END IF;
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE
336: IF FND_API.to_Boolean(p_init_msg_list) THEN
337: FND_MSG_PUB.initialize;
338: END IF;
339:
340: -- Initialize API return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 482: FND_MSG_PUB.ADD;

478: debug(' error code:'||l_retcode);
479: IF l_retcode = 2 THEN
480: IF l_retcode = 'XLA_UPG_HIST_RUNNING' THEN
481: FND_MESSAGE.set_name('XLA', 'XLA_UPG_HIST_RUNNING');
482: FND_MSG_PUB.ADD;
483: ELSE
484: FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_WARNING');
485: FND_MSG_PUB.ADD;
486: END IF;

Line 485: FND_MSG_PUB.ADD;

481: FND_MESSAGE.set_name('XLA', 'XLA_UPG_HIST_RUNNING');
482: FND_MSG_PUB.ADD;
483: ELSE
484: FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_WARNING');
485: FND_MSG_PUB.ADD;
486: END IF;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSE
489: --}

Line 495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

491: END IF;
492:
493: END IF;
494:
495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
496: FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_SUCCESS');
497: FND_MSG_PUB.ADD;
498: END IF;
499:

Line 497: FND_MSG_PUB.ADD;

493: END IF;
494:
495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
496: FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_SUCCESS');
497: FND_MSG_PUB.ADD;
498: END IF;
499:
500: END IF;
501:

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

648: EXCEPTION
649: WHEN FND_API.g_exc_error THEN
650: ROLLBACK TO Create_RCVXLAEvent;
651: x_return_status := FND_API.g_ret_sts_error;
652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
653: FND_MSG_PUB.add_exc_msg
654: ( G_PKG_NAME,
655: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message
656: );

Line 653: FND_MSG_PUB.add_exc_msg

649: WHEN FND_API.g_exc_error THEN
650: ROLLBACK TO Create_RCVXLAEvent;
651: x_return_status := FND_API.g_ret_sts_error;
652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
653: FND_MSG_PUB.add_exc_msg
654: ( G_PKG_NAME,
655: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message
656: );
657: end if;

Line 658: FND_MSG_PUB.count_and_get

654: ( G_PKG_NAME,
655: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message
656: );
657: end if;
658: FND_MSG_PUB.count_and_get
659: ( p_count => x_msg_count,
660: p_data => x_msg_data
661: );
662: WHEN FND_API.g_exc_unexpected_error THEN

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

662: WHEN FND_API.g_exc_unexpected_error THEN
663: ROLLBACK TO Create_RCVXLAEvent;
664: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
665: x_return_status := FND_API.g_ret_sts_unexp_error ;
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: FND_MSG_PUB.add_exc_msg
668: ( G_PKG_NAME,
669: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
670: );

Line 667: FND_MSG_PUB.add_exc_msg

663: ROLLBACK TO Create_RCVXLAEvent;
664: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
665: x_return_status := FND_API.g_ret_sts_unexp_error ;
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: FND_MSG_PUB.add_exc_msg
668: ( G_PKG_NAME,
669: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
670: );
671: end if;

Line 672: FND_MSG_PUB.count_and_get

668: ( G_PKG_NAME,
669: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
670: );
671: end if;
672: FND_MSG_PUB.count_and_get
673: ( p_count => x_msg_count,
674: p_data => x_msg_data
675: );
676: WHEN OTHERS THEN

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

681: IF l_unexpLog THEN
682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num
683: ,'Create_RCVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
684: END IF;
685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
686: FND_MSG_PUB.add_exc_msg
687: ( G_PKG_NAME,
688: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
689: );

Line 686: FND_MSG_PUB.add_exc_msg

682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num
683: ,'Create_RCVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
684: END IF;
685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
686: FND_MSG_PUB.add_exc_msg
687: ( G_PKG_NAME,
688: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
689: );
690: END IF;

Line 691: FND_MSG_PUB.count_and_get

687: ( G_PKG_NAME,
688: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data
689: );
690: END IF;
691: FND_MSG_PUB.count_and_get
692: ( p_count => x_msg_count,
693: p_data => x_msg_data
694: );
695:

Line 803: FND_MSG_PUB.initialize;

799:
800: l_stmt_num := 10;
801: -- Initialize message list if p_init_msg_list is set to TRUE
802: IF FND_API.to_Boolean(p_init_msg_list) THEN
803: FND_MSG_PUB.initialize;
804: END IF;
805:
806: -- Initialize API return status to success
807: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1341: FND_MSG_PUB.count_and_get

1337: EXCEPTION
1338: WHEN FND_API.g_exc_error THEN
1339: ROLLBACK TO Create_INVXLAEvent;
1340: x_return_status := FND_API.g_ret_sts_error;
1341: FND_MSG_PUB.count_and_get
1342: ( p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );
1345: WHEN FND_API.g_exc_unexpected_error THEN

Line 1348: FND_MSG_PUB.count_and_get

1344: );
1345: WHEN FND_API.g_exc_unexpected_error THEN
1346: ROLLBACK TO Create_INVXLAEvent;
1347: x_return_status := FND_API.g_ret_sts_unexp_error ;
1348: FND_MSG_PUB.count_and_get
1349: ( p_count => x_msg_count,
1350: p_data => x_msg_data
1351: );
1352: WHEN OTHERS THEN

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

1355: IF l_unexpLog THEN
1356: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1357: END IF;
1358:
1359: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1360: FND_MSG_PUB.add_exc_msg
1361: ( G_PKG_NAME,
1362: l_api_name || 'Statement -'||to_char(l_stmt_num)
1363: );

Line 1360: FND_MSG_PUB.add_exc_msg

1356: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1357: END IF;
1358:
1359: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1360: FND_MSG_PUB.add_exc_msg
1361: ( G_PKG_NAME,
1362: l_api_name || 'Statement -'||to_char(l_stmt_num)
1363: );
1364: END IF;

Line 1365: FND_MSG_PUB.count_and_get

1361: ( G_PKG_NAME,
1362: l_api_name || 'Statement -'||to_char(l_stmt_num)
1363: );
1364: END IF;
1365: FND_MSG_PUB.count_and_get
1366: ( p_count => x_msg_count,
1367: p_data => x_msg_data
1368: );
1369: END Create_INVXLAEvent;

Line 1460: FND_MSG_PUB.initialize;

1456: END IF;
1457:
1458: -- Initialize message list if p_init_msg_list is set to TRUE
1459: IF FND_API.to_Boolean(p_init_msg_list) THEN
1460: FND_MSG_PUB.initialize;
1461: END IF;
1462:
1463: -- Initialize API return status to success
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1569: FND_MSG_PUB.count_and_get

1565: EXCEPTION
1566: WHEN FND_API.g_exc_error THEN
1567: ROLLBACK TO Create_WIPXLAEvent;
1568: x_return_status := FND_API.g_ret_sts_error;
1569: FND_MSG_PUB.count_and_get
1570: ( p_count => x_msg_count,
1571: p_data => x_msg_data
1572: );
1573: WHEN FND_API.g_exc_unexpected_error THEN

Line 1576: FND_MSG_PUB.count_and_get

1572: );
1573: WHEN FND_API.g_exc_unexpected_error THEN
1574: ROLLBACK TO Create_WIPXLAEvent;
1575: x_return_status := FND_API.g_ret_sts_unexp_error ;
1576: FND_MSG_PUB.count_and_get
1577: ( p_count => x_msg_count,
1578: p_data => x_msg_data
1579: );
1580: WHEN OTHERS THEN

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

1584: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
1585: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1586: END IF;
1587:
1588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1589: FND_MSG_PUB.add_exc_msg
1590: ( G_PKG_NAME,
1591: l_api_name || 'Statement -'||to_char(l_stmt_num)
1592: );

Line 1589: FND_MSG_PUB.add_exc_msg

1585: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1586: END IF;
1587:
1588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1589: FND_MSG_PUB.add_exc_msg
1590: ( G_PKG_NAME,
1591: l_api_name || 'Statement -'||to_char(l_stmt_num)
1592: );
1593: END IF;

Line 1594: FND_MSG_PUB.count_and_get

1590: ( G_PKG_NAME,
1591: l_api_name || 'Statement -'||to_char(l_stmt_num)
1592: );
1593: END IF;
1594: FND_MSG_PUB.count_and_get
1595: ( p_count => x_msg_count,
1596: p_data => x_msg_data
1597: );
1598:

Line 1683: FND_MSG_PUB.initialize;

1679: END IF;
1680:
1681: -- Initialize message list if p_init_msg_list is set to TRUE
1682: IF FND_API.to_Boolean(p_init_msg_list) THEN
1683: FND_MSG_PUB.initialize;
1684: END IF;
1685:
1686: -- Initialize API return status to success
1687: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1814: FND_MSG_PUB.count_and_get

1810: EXCEPTION
1811: WHEN FND_API.g_exc_error THEN
1812: ROLLBACK TO CreateBulk_WIPXLAEvent;
1813: x_return_status := FND_API.g_ret_sts_error;
1814: FND_MSG_PUB.count_and_get
1815: ( p_count => x_msg_count,
1816: p_data => x_msg_data
1817: );
1818: WHEN FND_API.g_exc_unexpected_error THEN

Line 1821: FND_MSG_PUB.count_and_get

1817: );
1818: WHEN FND_API.g_exc_unexpected_error THEN
1819: ROLLBACK TO CreateBulk_WIPXLAEvent;
1820: x_return_status := FND_API.g_ret_sts_unexp_error ;
1821: FND_MSG_PUB.count_and_get
1822: ( p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );
1825: WHEN OTHERS THEN

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

1828: IF l_unexpLog THEN
1829: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1830: END IF;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1833: FND_MSG_PUB.add_exc_msg
1834: ( G_PKG_NAME,
1835: l_api_name || 'Statement -'||to_char(l_stmt_num)
1836: );

Line 1833: FND_MSG_PUB.add_exc_msg

1829: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1830: END IF;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1833: FND_MSG_PUB.add_exc_msg
1834: ( G_PKG_NAME,
1835: l_api_name || 'Statement -'||to_char(l_stmt_num)
1836: );
1837: END IF;

Line 1838: FND_MSG_PUB.count_and_get

1834: ( G_PKG_NAME,
1835: l_api_name || 'Statement -'||to_char(l_stmt_num)
1836: );
1837: END IF;
1838: FND_MSG_PUB.count_and_get
1839: ( p_count => x_msg_count,
1840: p_data => x_msg_data
1841: );
1842:

Line 1926: FND_MSG_PUB.initialize;

1922: END IF;
1923:
1924: -- Initialize message list if p_init_msg_list is set to TRUE
1925: IF FND_API.to_Boolean(p_init_msg_list) THEN
1926: FND_MSG_PUB.initialize;
1927: END IF;
1928:
1929: -- Initialize API return status to success
1930: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2039: FND_MSG_PUB.count_and_get

2035: EXCEPTION
2036: WHEN FND_API.g_exc_error THEN
2037: ROLLBACK TO Create_CostUpdateXLAEvent;
2038: x_return_status := FND_API.g_ret_sts_error;
2039: FND_MSG_PUB.count_and_get
2040: ( p_count => x_msg_count,
2041: p_data => x_msg_data
2042: );
2043: WHEN FND_API.g_exc_unexpected_error THEN

Line 2046: FND_MSG_PUB.count_and_get

2042: );
2043: WHEN FND_API.g_exc_unexpected_error THEN
2044: ROLLBACK TO Create_CostUpdateXLAEvent;
2045: x_return_status := FND_API.g_ret_sts_unexp_error ;
2046: FND_MSG_PUB.count_and_get
2047: ( p_count => x_msg_count,
2048: p_data => x_msg_data
2049: );
2050: WHEN OTHERS THEN

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

2053: IF l_unexpLog THEN
2054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2055: END IF;
2056:
2057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2058: FND_MSG_PUB.add_exc_msg
2059: ( G_PKG_NAME,
2060: l_api_name || 'Statement -'||to_char(l_stmt_num)
2061: );

Line 2058: FND_MSG_PUB.add_exc_msg

2054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2055: END IF;
2056:
2057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2058: FND_MSG_PUB.add_exc_msg
2059: ( G_PKG_NAME,
2060: l_api_name || 'Statement -'||to_char(l_stmt_num)
2061: );
2062: END IF;

Line 2063: FND_MSG_PUB.count_and_get

2059: ( G_PKG_NAME,
2060: l_api_name || 'Statement -'||to_char(l_stmt_num)
2061: );
2062: END IF;
2063: FND_MSG_PUB.count_and_get
2064: ( p_count => x_msg_count,
2065: p_data => x_msg_data
2066: );
2067:

Line 2150: FND_MSG_PUB.initialize;

2146: END IF;
2147:
2148: -- Initialize message list if p_init_msg_list is set to TRUE
2149: IF FND_API.to_Boolean(p_init_msg_list) THEN
2150: FND_MSG_PUB.initialize;
2151: END IF;
2152:
2153: -- Initialize API return status to success
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2246: FND_MSG_PUB.count_and_get

2242: EXCEPTION
2243: WHEN FND_API.g_exc_error THEN
2244: ROLLBACK TO Create_WIPUpdateXLAEvent;
2245: x_return_status := FND_API.g_ret_sts_error;
2246: FND_MSG_PUB.count_and_get
2247: ( p_count => x_msg_count,
2248: p_data => x_msg_data
2249: );
2250: WHEN FND_API.g_exc_unexpected_error THEN

Line 2253: FND_MSG_PUB.count_and_get

2249: );
2250: WHEN FND_API.g_exc_unexpected_error THEN
2251: ROLLBACK TO Create_WIPUpdateXLAEvent;
2252: x_return_status := FND_API.g_ret_sts_unexp_error ;
2253: FND_MSG_PUB.count_and_get
2254: ( p_count => x_msg_count,
2255: p_data => x_msg_data
2256: );
2257: WHEN OTHERS THEN

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

2261: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
2262: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2263: END IF;
2264:
2265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2266: FND_MSG_PUB.add_exc_msg
2267: ( G_PKG_NAME,
2268: l_api_name || 'Statement -'||to_char(l_stmt_num)
2269: );

Line 2266: FND_MSG_PUB.add_exc_msg

2262: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2263: END IF;
2264:
2265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2266: FND_MSG_PUB.add_exc_msg
2267: ( G_PKG_NAME,
2268: l_api_name || 'Statement -'||to_char(l_stmt_num)
2269: );
2270: END IF;

Line 2271: FND_MSG_PUB.count_and_get

2267: ( G_PKG_NAME,
2268: l_api_name || 'Statement -'||to_char(l_stmt_num)
2269: );
2270: END IF;
2271: FND_MSG_PUB.count_and_get
2272: ( p_count => x_msg_count,
2273: p_data => x_msg_data
2274: );
2275: