DBA Data[Home] [Help]

APPS.CN_INVOICE_CHANGES_PVT dependencies on FND_MSG_PUB

Line 701: FND_MSG_PUB.initialize;

697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: END IF;
699: -- Initialize message list if p_init_msg_list is set to TRUE.
700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize;
702: END IF;
703: -- Initialize API return status to success
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705: x_loading_status := 'CN_INSERTED';

Line 746: FND_MSG_PUB.Count_And_Get(

742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO update_invoice_changes;
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 754: FND_MSG_PUB.Count_And_Get(

750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO update_invoice_changes;
752: x_loading_status := 'UNEXPECTED_ERR';
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: FND_MSG_PUB.Count_And_Get(
755: p_count => x_msg_count ,
756: p_data => x_msg_data ,
757: p_encoded => FND_API.G_FALSE);
758: WHEN OTHERS THEN

Line 762: IF FND_MSG_PUB.Check_Msg_Level(

758: WHEN OTHERS THEN
759: ROLLBACK TO update_invoice_changes;
760: x_loading_status := 'UNEXPECTED_ERR';
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.Check_Msg_Level(
763: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
765: END IF;
766: FND_MSG_PUB.Count_And_Get(

Line 763: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

759: ROLLBACK TO update_invoice_changes;
760: x_loading_status := 'UNEXPECTED_ERR';
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.Check_Msg_Level(
763: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
765: END IF;
766: FND_MSG_PUB.Count_And_Get(
767: p_count => x_msg_count ,

Line 764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

760: x_loading_status := 'UNEXPECTED_ERR';
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.Check_Msg_Level(
763: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
765: END IF;
766: FND_MSG_PUB.Count_And_Get(
767: p_count => x_msg_count ,
768: p_data => x_msg_data ,

Line 766: FND_MSG_PUB.Count_And_Get(

762: IF FND_MSG_PUB.Check_Msg_Level(
763: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
765: END IF;
766: FND_MSG_PUB.Count_And_Get(
767: p_count => x_msg_count ,
768: p_data => x_msg_data ,
769: p_encoded => FND_API.G_FALSE);
770: END;

Line 866: FND_MSG_PUB.initialize;

862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864: -- Initialize message list if p_init_msg_list is set to TRUE.
865: IF FND_API.to_Boolean( p_init_msg_list ) THEN
866: FND_MSG_PUB.initialize;
867: END IF;
868: -- Initialize API return status to success
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870: x_loading_status := 'CN_INSERTED';

Line 1362: FND_MSG_PUB.Count_And_Get(

1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: ROLLBACK TO update_credit_memo;
1361: x_return_status := FND_API.G_RET_STS_ERROR ;
1362: FND_MSG_PUB.Count_And_Get(
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,
1365: p_encoded => FND_API.G_FALSE);
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1370: FND_MSG_PUB.Count_And_Get(

1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO update_credit_memo;
1368: x_loading_status := 'UNEXPECTED_ERR';
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count ,
1372: p_data => x_msg_data ,
1373: p_encoded => FND_API.G_FALSE);
1374: WHEN OTHERS THEN

Line 1378: IF FND_MSG_PUB.Check_Msg_Level(

1374: WHEN OTHERS THEN
1375: ROLLBACK TO update_credit_memo;
1376: x_loading_status := 'UNEXPECTED_ERR';
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: IF FND_MSG_PUB.Check_Msg_Level(
1379: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1381: END IF;
1382: FND_MSG_PUB.Count_And_Get(

Line 1379: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1375: ROLLBACK TO update_credit_memo;
1376: x_loading_status := 'UNEXPECTED_ERR';
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: IF FND_MSG_PUB.Check_Msg_Level(
1379: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1381: END IF;
1382: FND_MSG_PUB.Count_And_Get(
1383: p_count => x_msg_count ,

Line 1380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1376: x_loading_status := 'UNEXPECTED_ERR';
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: IF FND_MSG_PUB.Check_Msg_Level(
1379: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1381: END IF;
1382: FND_MSG_PUB.Count_And_Get(
1383: p_count => x_msg_count ,
1384: p_data => x_msg_data ,

Line 1382: FND_MSG_PUB.Count_And_Get(

1378: IF FND_MSG_PUB.Check_Msg_Level(
1379: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1381: END IF;
1382: FND_MSG_PUB.Count_And_Get(
1383: p_count => x_msg_count ,
1384: p_data => x_msg_data ,
1385: p_encoded => FND_API.G_FALSE);
1386: END;

Line 1444: FND_MSG_PUB.initialize;

1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;
1442: -- Initialize message list if p_init_msg_list is set to TRUE.
1443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1444: FND_MSG_PUB.initialize;
1445: END IF;
1446: -- Initialize API return status to success
1447: x_return_status := FND_API.G_RET_STS_SUCCESS;
1448: x_loading_status := 'CN_INSERTED';

Line 1664: FND_MSG_PUB.Add;

1660: x_loading_status => x_loading_status);
1661: END IF;
1662: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1663: FND_MESSAGE.Set_Name('CN', 'CN_UPD_INV_CHANGES');
1664: FND_MSG_PUB.Add;
1665: x_loading_status := 'CN_UPD_INV_CHANGES';
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668: x_existing_data := l_existing_data;

Line 1673: FND_MSG_PUB.Count_And_Get(

1669: EXCEPTION
1670: WHEN FND_API.G_EXC_ERROR THEN
1671: ROLLBACK TO update_mass_invoices;
1672: x_return_status := FND_API.G_RET_STS_ERROR ;
1673: FND_MSG_PUB.Count_And_Get(
1674: p_count => x_msg_count ,
1675: p_data => x_msg_data ,
1676: p_encoded => FND_API.G_FALSE);
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1681: FND_MSG_PUB.Count_And_Get(

1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: ROLLBACK TO update_mass_invoices;
1679: x_loading_status := 'UNEXPECTED_ERR';
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681: FND_MSG_PUB.Count_And_Get(
1682: p_count => x_msg_count ,
1683: p_data => x_msg_data ,
1684: p_encoded => FND_API.G_FALSE);
1685: WHEN OTHERS THEN

Line 1689: IF FND_MSG_PUB.Check_Msg_Level(

1685: WHEN OTHERS THEN
1686: ROLLBACK TO update_mass_invoices;
1687: x_loading_status := 'UNEXPECTED_ERR';
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1689: IF FND_MSG_PUB.Check_Msg_Level(
1690: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(

Line 1690: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1686: ROLLBACK TO update_mass_invoices;
1687: x_loading_status := 'UNEXPECTED_ERR';
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1689: IF FND_MSG_PUB.Check_Msg_Level(
1690: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(
1694: p_count => x_msg_count ,

Line 1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1687: x_loading_status := 'UNEXPECTED_ERR';
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1689: IF FND_MSG_PUB.Check_Msg_Level(
1690: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(
1694: p_count => x_msg_count ,
1695: p_data => x_msg_data ,

Line 1693: FND_MSG_PUB.Count_And_Get(

1689: IF FND_MSG_PUB.Check_Msg_Level(
1690: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(
1694: p_count => x_msg_count ,
1695: p_data => x_msg_data ,
1696: p_encoded => FND_API.G_FALSE);
1697: END;

Line 1763: FND_MSG_PUB.initialize;

1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761: -- Initialize message list if p_init_msg_list is set to TRUE.
1762: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1763: FND_MSG_PUB.initialize;
1764: END IF;
1765: -- Initialize API return status to success
1766: x_return_status := FND_API.G_RET_STS_SUCCESS;
1767: x_loading_status := 'CN_INSERTED';

Line 1797: FND_MSG_PUB.Count_And_Get(

1793: EXCEPTION
1794: WHEN FND_API.G_EXC_ERROR THEN
1795: ROLLBACK TO capture_deal_invoice;
1796: x_return_status := FND_API.G_RET_STS_ERROR ;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_count => x_msg_count ,
1799: p_data => x_msg_data ,
1800: p_encoded => FND_API.G_FALSE);
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1805: FND_MSG_PUB.Count_And_Get(

1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1802: ROLLBACK TO capture_deal_invoice;
1803: x_loading_status := 'UNEXPECTED_ERR';
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1805: FND_MSG_PUB.Count_And_Get(
1806: p_count => x_msg_count ,
1807: p_data => x_msg_data ,
1808: p_encoded => FND_API.G_FALSE);
1809: WHEN OTHERS THEN

Line 1813: IF FND_MSG_PUB.Check_Msg_Level(

1809: WHEN OTHERS THEN
1810: ROLLBACK TO capture_deal_invoice;
1811: x_loading_status := 'UNEXPECTED_ERR';
1812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1813: IF FND_MSG_PUB.Check_Msg_Level(
1814: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1816: END IF;
1817: FND_MSG_PUB.Count_And_Get(

Line 1814: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1810: ROLLBACK TO capture_deal_invoice;
1811: x_loading_status := 'UNEXPECTED_ERR';
1812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1813: IF FND_MSG_PUB.Check_Msg_Level(
1814: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1816: END IF;
1817: FND_MSG_PUB.Count_And_Get(
1818: p_count => x_msg_count ,

Line 1815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1811: x_loading_status := 'UNEXPECTED_ERR';
1812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1813: IF FND_MSG_PUB.Check_Msg_Level(
1814: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1816: END IF;
1817: FND_MSG_PUB.Count_And_Get(
1818: p_count => x_msg_count ,
1819: p_data => x_msg_data ,

Line 1817: FND_MSG_PUB.Count_And_Get(

1813: IF FND_MSG_PUB.Check_Msg_Level(
1814: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1816: END IF;
1817: FND_MSG_PUB.Count_And_Get(
1818: p_count => x_msg_count ,
1819: p_data => x_msg_data ,
1820: p_encoded => FND_API.G_FALSE);
1821: END;