eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GET_TX_DATA_PUB dependencies on FND_MSG_PUB

Line 475: FND_MSG_PUB.initialize;

471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: END IF;
473: -- Initialize message list if p_init_msg_list is set to TRUE.
474: IF FND_API.to_Boolean( p_init_msg_list ) THEN
475: FND_MSG_PUB.initialize;
476: END IF;
477: -- Initialize API return status to success
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479: x_loading_status := 'CN_INSERTED';

Line 697: FND_MSG_PUB.Count_And_Get(

693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO get_adj;
696: x_return_status := FND_API.G_RET_STS_ERROR ;
697: FND_MSG_PUB.Count_And_Get(
698: p_count => x_msg_count ,
699: p_data => x_msg_data ,
700: p_encoded => FND_API.G_FALSE);
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 705: FND_MSG_PUB.Count_And_Get(

701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: ROLLBACK TO get_adj;
703: x_loading_status := 'UNEXPECTED_ERR';
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
705: FND_MSG_PUB.Count_And_Get(
706: p_count => x_msg_count ,
707: p_data => x_msg_data ,
708: p_encoded => FND_API.G_FALSE);
709: WHEN OTHERS THEN

Line 713: IF FND_MSG_PUB.Check_Msg_Level(

709: WHEN OTHERS THEN
710: ROLLBACK TO get_adj;
711: x_loading_status := 'UNEXPECTED_ERR';
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713: IF FND_MSG_PUB.Check_Msg_Level(
714: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
715: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
716: END IF;
717: FND_MSG_PUB.Count_And_Get(

Line 714: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

710: ROLLBACK TO get_adj;
711: x_loading_status := 'UNEXPECTED_ERR';
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713: IF FND_MSG_PUB.Check_Msg_Level(
714: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
715: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
716: END IF;
717: FND_MSG_PUB.Count_And_Get(
718: p_count => x_msg_count ,

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

711: x_loading_status := 'UNEXPECTED_ERR';
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713: IF FND_MSG_PUB.Check_Msg_Level(
714: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
715: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
716: END IF;
717: FND_MSG_PUB.Count_And_Get(
718: p_count => x_msg_count ,
719: p_data => x_msg_data ,

Line 717: FND_MSG_PUB.Count_And_Get(

713: IF FND_MSG_PUB.Check_Msg_Level(
714: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
715: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
716: END IF;
717: FND_MSG_PUB.Count_And_Get(
718: p_count => x_msg_count ,
719: p_data => x_msg_data ,
720: p_encoded => FND_API.G_FALSE);
721: END;

Line 797: FND_MSG_PUB.initialize;

793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795: -- Initialize message list if p_init_msg_list is set to TRUE.
796: IF FND_API.to_Boolean( p_init_msg_list ) THEN
797: FND_MSG_PUB.initialize;
798: END IF;
799: -- Initialize API return status to success
800: x_return_status := FND_API.G_RET_STS_SUCCESS;
801: x_loading_status := 'CN_INSERTED';

Line 1235: FND_MSG_PUB.Count_And_Get(

1231: EXCEPTION
1232: WHEN FND_API.G_EXC_ERROR THEN
1233: ROLLBACK TO get_split_data;
1234: x_return_status := FND_API.G_RET_STS_ERROR ;
1235: FND_MSG_PUB.Count_And_Get(
1236: p_count => x_msg_count ,
1237: p_data => x_msg_data ,
1238: p_encoded => FND_API.G_FALSE);
1239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1243: FND_MSG_PUB.Count_And_Get(

1239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1240: ROLLBACK TO get_split_data;
1241: x_loading_status := 'UNEXPECTED_ERR';
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1243: FND_MSG_PUB.Count_And_Get(
1244: p_count => x_msg_count ,
1245: p_data => x_msg_data ,
1246: p_encoded => FND_API.G_FALSE);
1247: WHEN OTHERS THEN

Line 1251: IF FND_MSG_PUB.Check_Msg_Level(

1247: WHEN OTHERS THEN
1248: ROLLBACK TO get_split_data;
1249: x_loading_status := 'UNEXPECTED_ERR';
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1251: IF FND_MSG_PUB.Check_Msg_Level(
1252: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1254: END IF;
1255: FND_MSG_PUB.Count_And_Get(

Line 1252: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1248: ROLLBACK TO get_split_data;
1249: x_loading_status := 'UNEXPECTED_ERR';
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1251: IF FND_MSG_PUB.Check_Msg_Level(
1252: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1254: END IF;
1255: FND_MSG_PUB.Count_And_Get(
1256: p_count => x_msg_count ,

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

1249: x_loading_status := 'UNEXPECTED_ERR';
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1251: IF FND_MSG_PUB.Check_Msg_Level(
1252: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1254: END IF;
1255: FND_MSG_PUB.Count_And_Get(
1256: p_count => x_msg_count ,
1257: p_data => x_msg_data ,

Line 1255: FND_MSG_PUB.Count_And_Get(

1251: IF FND_MSG_PUB.Check_Msg_Level(
1252: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1254: END IF;
1255: FND_MSG_PUB.Count_And_Get(
1256: p_count => x_msg_count ,
1257: p_data => x_msg_data ,
1258: p_encoded => FND_API.G_FALSE);
1259: END;

Line 1326: FND_MSG_PUB.initialize;

1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324: -- Initialize message list if p_init_msg_list is set to TRUE.
1325: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1326: FND_MSG_PUB.initialize;
1327: END IF;
1328: -- Initialize API return status to success
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: x_loading_status := 'CN_INSERTED';

Line 1343: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1339: AND period_status IN ('O','F')
1340: AND org_id = p_newtx_rec.org_id;
1341: --
1342: IF (l_period_count = 0) THEN
1343: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1344: FND_MESSAGE.Set_Name('CN', 'NOT_WITHIN_OPEN_PERIODS');
1345: FND_MSG_PUB.Add;
1346: END IF;
1347: x_loading_status := 'NOT_WITHIN_OPEN_PERIODS';

Line 1345: FND_MSG_PUB.Add;

1341: --
1342: IF (l_period_count = 0) THEN
1343: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1344: FND_MESSAGE.Set_Name('CN', 'NOT_WITHIN_OPEN_PERIODS');
1345: FND_MSG_PUB.Add;
1346: END IF;
1347: x_loading_status := 'NOT_WITHIN_OPEN_PERIODS';
1348: RAISE FND_API.G_EXC_ERROR ;
1349: ELSE

Line 1412: FND_MSG_PUB.Add;

1408: x_return_status => l_return_status,
1409: p_conversion_type => CN_SYSTEM_PARAMETERS.VALUE('CN_CONVERSION_TYPE', p_newtx_rec.org_id));
1410: IF (l_return_status = 'NO DATA') THEN
1411: FND_MESSAGE.SET_NAME('CN','CN_ADJ_NO_CONVERSION');
1412: FND_MSG_PUB.Add;
1413: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: ELSIF (l_return_status = 'ERROR') THEN
1416: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');

Line 1417: FND_MSG_PUB.Add;

1413: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: ELSIF (l_return_status = 'ERROR') THEN
1416: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');
1417: FND_MSG_PUB.Add;
1418: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: END IF;
1421: END IF;

Line 1442: FND_MSG_PUB.Add;

1438: x_return_status => l_return_status,
1439: p_conversion_type => CN_SYSTEM_PARAMETERS.VALUE('CN_CONVERSION_TYPE', p_newtx_rec.org_id));
1440: IF (l_return_status = 'NO DATA') THEN
1441: FND_MESSAGE.SET_NAME('CN','CN_ADJ_NO_CONVERSION');
1442: FND_MSG_PUB.Add;
1443: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1445: ELSIF (l_return_status = 'ERROR') THEN
1446: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');

Line 1447: FND_MSG_PUB.Add;

1443: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1445: ELSIF (l_return_status = 'ERROR') THEN
1446: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');
1447: FND_MSG_PUB.Add;
1448: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: END IF;
1451: END IF;

Line 1473: FND_MSG_PUB.Count_And_Get(

1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: ROLLBACK TO insert_api_record;
1472: x_return_status := FND_API.G_RET_STS_ERROR ;
1473: FND_MSG_PUB.Count_And_Get(
1474: p_count => x_msg_count ,
1475: p_data => x_msg_data ,
1476: p_encoded => FND_API.G_FALSE);
1477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1481: FND_MSG_PUB.Count_And_Get(

1477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1478: ROLLBACK TO insert_api_record;
1479: x_loading_status := 'UNEXPECTED_ERR';
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1481: FND_MSG_PUB.Count_And_Get(
1482: p_count => x_msg_count ,
1483: p_data => x_msg_data ,
1484: p_encoded => FND_API.G_FALSE);
1485: WHEN OTHERS THEN

Line 1489: IF FND_MSG_PUB.Check_Msg_Level(

1485: WHEN OTHERS THEN
1486: ROLLBACK TO insert_api_record;
1487: x_loading_status := 'UNEXPECTED_ERR';
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1489: IF FND_MSG_PUB.Check_Msg_Level(
1490: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1492: END IF;
1493: FND_MSG_PUB.Count_And_Get(

Line 1490: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1486: ROLLBACK TO insert_api_record;
1487: x_loading_status := 'UNEXPECTED_ERR';
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1489: IF FND_MSG_PUB.Check_Msg_Level(
1490: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1492: END IF;
1493: FND_MSG_PUB.Count_And_Get(
1494: p_count => x_msg_count ,

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

1487: x_loading_status := 'UNEXPECTED_ERR';
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1489: IF FND_MSG_PUB.Check_Msg_Level(
1490: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1492: END IF;
1493: FND_MSG_PUB.Count_And_Get(
1494: p_count => x_msg_count ,
1495: p_data => x_msg_data ,

Line 1493: FND_MSG_PUB.Count_And_Get(

1489: IF FND_MSG_PUB.Check_Msg_Level(
1490: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1492: END IF;
1493: FND_MSG_PUB.Count_And_Get(
1494: p_count => x_msg_count ,
1495: p_data => x_msg_data ,
1496: p_encoded => FND_API.G_FALSE);
1497: END;

Line 1546: FND_MSG_PUB.initialize;

1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: END IF;
1544: -- Initialize message list if p_init_msg_list is set to TRUE.
1545: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1546: FND_MSG_PUB.initialize;
1547: END IF;
1548: -- Initialize API return status to success
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;
1550: x_loading_status := 'CN_INSERTED';

Line 1639: FND_MSG_PUB.Count_And_Get(

1635: EXCEPTION
1636: WHEN FND_API.G_EXC_ERROR THEN
1637: ROLLBACK TO call_mass_update;
1638: x_return_status := FND_API.G_RET_STS_ERROR ;
1639: FND_MSG_PUB.Count_And_Get(
1640: p_count => x_msg_count ,
1641: p_data => x_msg_data ,
1642: p_encoded => FND_API.G_FALSE);
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1647: FND_MSG_PUB.Count_And_Get(

1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: ROLLBACK TO call_mass_update;
1645: x_loading_status := 'UNEXPECTED_ERR';
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1647: FND_MSG_PUB.Count_And_Get(
1648: p_count => x_msg_count ,
1649: p_data => x_msg_data ,
1650: p_encoded => FND_API.G_FALSE);
1651: WHEN OTHERS THEN

Line 1655: IF FND_MSG_PUB.Check_Msg_Level(

1651: WHEN OTHERS THEN
1652: ROLLBACK TO call_mass_update;
1653: x_loading_status := 'UNEXPECTED_ERR';
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1655: IF FND_MSG_PUB.Check_Msg_Level(
1656: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1658: END IF;
1659: FND_MSG_PUB.Count_And_Get(

Line 1656: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1652: ROLLBACK TO call_mass_update;
1653: x_loading_status := 'UNEXPECTED_ERR';
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1655: IF FND_MSG_PUB.Check_Msg_Level(
1656: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1658: END IF;
1659: FND_MSG_PUB.Count_And_Get(
1660: p_count => x_msg_count ,

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

1653: x_loading_status := 'UNEXPECTED_ERR';
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1655: IF FND_MSG_PUB.Check_Msg_Level(
1656: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1658: END IF;
1659: FND_MSG_PUB.Count_And_Get(
1660: p_count => x_msg_count ,
1661: p_data => x_msg_data ,

Line 1659: FND_MSG_PUB.Count_And_Get(

1655: IF FND_MSG_PUB.Check_Msg_Level(
1656: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1658: END IF;
1659: FND_MSG_PUB.Count_And_Get(
1660: p_count => x_msg_count ,
1661: p_data => x_msg_data ,
1662: p_encoded => FND_API.G_FALSE);
1663: END;

Line 1701: FND_MSG_PUB.initialize;

1697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1698: END IF;
1699: -- Initialize message list if p_init_msg_list is set to TRUE.
1700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1701: FND_MSG_PUB.initialize;
1702: END IF;
1703: -- Initialize API return status to success
1704: x_return_status := FND_API.G_RET_STS_SUCCESS;
1705: x_loading_status := 'CN_INSERTED';

Line 1729: FND_MSG_PUB.Count_And_Get(

1725: EXCEPTION
1726: WHEN FND_API.G_EXC_ERROR THEN
1727: ROLLBACK TO call_deal_assign;
1728: x_return_status := FND_API.G_RET_STS_ERROR ;
1729: FND_MSG_PUB.Count_And_Get(
1730: p_count => x_msg_count ,
1731: p_data => x_msg_data ,
1732: p_encoded => FND_API.G_FALSE);
1733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1737: FND_MSG_PUB.Count_And_Get(

1733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1734: ROLLBACK TO call_deal_assign;
1735: x_loading_status := 'UNEXPECTED_ERR';
1736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_count => x_msg_count ,
1739: p_data => x_msg_data ,
1740: p_encoded => FND_API.G_FALSE);
1741: WHEN OTHERS THEN

Line 1745: IF FND_MSG_PUB.Check_Msg_Level(

1741: WHEN OTHERS THEN
1742: ROLLBACK TO call_deal_assign;
1743: x_loading_status := 'UNEXPECTED_ERR';
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1745: IF FND_MSG_PUB.Check_Msg_Level(
1746: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1748: END IF;
1749: FND_MSG_PUB.Count_And_Get(

Line 1746: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1742: ROLLBACK TO call_deal_assign;
1743: x_loading_status := 'UNEXPECTED_ERR';
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1745: IF FND_MSG_PUB.Check_Msg_Level(
1746: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1748: END IF;
1749: FND_MSG_PUB.Count_And_Get(
1750: p_count => x_msg_count ,

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

1743: x_loading_status := 'UNEXPECTED_ERR';
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1745: IF FND_MSG_PUB.Check_Msg_Level(
1746: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1748: END IF;
1749: FND_MSG_PUB.Count_And_Get(
1750: p_count => x_msg_count ,
1751: p_data => x_msg_data ,

Line 1749: FND_MSG_PUB.Count_And_Get(

1745: IF FND_MSG_PUB.Check_Msg_Level(
1746: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1748: END IF;
1749: FND_MSG_PUB.Count_And_Get(
1750: p_count => x_msg_count ,
1751: p_data => x_msg_data ,
1752: p_encoded => FND_API.G_FALSE);
1753: END;

Line 1834: FND_MSG_PUB.initialize;

1830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1831: END IF;
1832: -- Initialize message list if p_init_msg_list is set to TRUE.
1833: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1834: FND_MSG_PUB.initialize;
1835: END IF;
1836: -- Initialize API return status to success
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: x_loading_status := 'CN_INSERTED';

Line 1851: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1847: l_id_counter := l_id_counter + 1;
1848: END IF;
1849: END LOOP;
1850: IF (l_id_counter = 0) THEN
1851: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1852: FND_MESSAGE.Set_Name('CN', 'CN_NO_SPLIT_RESOURCE');
1853: FND_MSG_PUB.Add;
1854: END IF;
1855: x_loading_status := 'CN_NO_SPLIT_RESOURCE';

Line 1853: FND_MSG_PUB.Add;

1849: END LOOP;
1850: IF (l_id_counter = 0) THEN
1851: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1852: FND_MESSAGE.Set_Name('CN', 'CN_NO_SPLIT_RESOURCE');
1853: FND_MSG_PUB.Add;
1854: END IF;
1855: x_loading_status := 'CN_NO_SPLIT_RESOURCE';
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;

Line 1878: -- IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1874: (l_adj_tbl(1).split_pct <> 0)) THEN -- 2
1875:
1876: -- bug 2118574
1877: -- IF (l_split_amount <> p_transaction_amount) THEN
1878: -- IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1879: -- FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_AMOUNT');
1880: -- FND_MSG_PUB.Add;
1881: -- END IF;
1882: -- x_loading_status := 'CN_ADJ_SPLIT_AMOUNT';

Line 1880: -- FND_MSG_PUB.Add;

1876: -- bug 2118574
1877: -- IF (l_split_amount <> p_transaction_amount) THEN
1878: -- IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1879: -- FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_AMOUNT');
1880: -- FND_MSG_PUB.Add;
1881: -- END IF;
1882: -- x_loading_status := 'CN_ADJ_SPLIT_AMOUNT';
1883: -- RAISE FND_API.G_EXC_ERROR;
1884: -- END IF;

Line 1888: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1884: -- END IF;
1885:
1886:
1887: IF (l_split_percent <> l_adj_tbl(1).split_pct) THEN
1888: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1889: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');
1890: FND_MSG_PUB.Add;
1891: END IF;
1892: x_loading_status := 'CN_ADJ_SPLIT_PERCENT';

Line 1890: FND_MSG_PUB.Add;

1886:
1887: IF (l_split_percent <> l_adj_tbl(1).split_pct) THEN
1888: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1889: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');
1890: FND_MSG_PUB.Add;
1891: END IF;
1892: x_loading_status := 'CN_ADJ_SPLIT_PERCENT';
1893: RAISE FND_API.G_EXC_ERROR;
1894: END IF;

Line 1932: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1928: x_msg_data => x_msg_data,
1929: x_loading_status => x_loading_status);
1930: --
1931: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1932: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1933: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
1934: FND_MSG_PUB.Add;
1935: END IF;
1936: x_loading_status := 'CN_UPDATE_INV_ERROR';

Line 1934: FND_MSG_PUB.Add;

1930: --
1931: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1932: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1933: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
1934: FND_MSG_PUB.Add;
1935: END IF;
1936: x_loading_status := 'CN_UPDATE_INV_ERROR';
1937: RAISE FND_API.G_EXC_ERROR;
1938: END IF;

Line 2048: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2044:
2045: --
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2049: FND_MESSAGE.Set_Name('CN', 'CN_SPLIT_TRX_ERROR');
2050: FND_MSG_PUB.Add;
2051: END IF;
2052: x_loading_status := 'CN_SPLIT_TRX_ERROR';

Line 2050: FND_MSG_PUB.Add;

2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2049: FND_MESSAGE.Set_Name('CN', 'CN_SPLIT_TRX_ERROR');
2050: FND_MSG_PUB.Add;
2051: END IF;
2052: x_loading_status := 'CN_SPLIT_TRX_ERROR';
2053: RAISE FND_API.G_EXC_ERROR;
2054: END;

Line 2075: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2071: x_msg_data => x_msg_data,
2072: x_loading_status => x_loading_status);
2073: --
2074: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2075: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2076: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
2077: FND_MSG_PUB.Add;
2078: END IF;
2079: x_loading_status := 'CN_UPDATE_INV_ERROR';

Line 2077: FND_MSG_PUB.Add;

2073: --
2074: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2075: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2076: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
2077: FND_MSG_PUB.Add;
2078: END IF;
2079: x_loading_status := 'CN_UPDATE_INV_ERROR';
2080: RAISE FND_API.G_EXC_ERROR;
2081: END IF;

Line 2100: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2096: x_loading_status => x_loading_status);
2097: END IF;
2098: --
2099: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2100: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2101: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_CM_ERROR');
2102: FND_MSG_PUB.Add;
2103: END IF;
2104: x_loading_status := 'CN_UPDATE_CM_ERROR';

Line 2102: FND_MSG_PUB.Add;

2098: --
2099: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2100: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2101: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_CM_ERROR');
2102: FND_MSG_PUB.Add;
2103: END IF;
2104: x_loading_status := 'CN_UPDATE_CM_ERROR';
2105: RAISE FND_API.G_EXC_ERROR;
2106: END IF;

Line 2146: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2142: END IF;
2143: END IF;
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2147: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');
2148: FND_MSG_PUB.Add;
2149: END IF;
2150: x_loading_status := 'CN_DEAL_REV_ERROR';

Line 2148: FND_MSG_PUB.Add;

2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2147: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');
2148: FND_MSG_PUB.Add;
2149: END IF;
2150: x_loading_status := 'CN_DEAL_REV_ERROR';
2151: RAISE FND_API.G_EXC_ERROR;
2152: END;

Line 2178: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2174: END IF;
2175: END IF;
2176: EXCEPTION
2177: WHEN OTHERS THEN
2178: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2179: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');
2180: FND_MSG_PUB.Add;
2181: END IF;
2182: x_loading_status := 'CN_DEAL_REV_ERROR';

Line 2180: FND_MSG_PUB.Add;

2176: EXCEPTION
2177: WHEN OTHERS THEN
2178: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2179: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');
2180: FND_MSG_PUB.Add;
2181: END IF;
2182: x_loading_status := 'CN_DEAL_REV_ERROR';
2183: RAISE FND_API.G_EXC_ERROR;
2184: END;

Line 2194: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2190: l_split_percent := l_split_percent + NVL(p_split_data_tbl(i).split_pct,0);
2191: END IF;
2192: END LOOP;
2193: IF ((l_split_percent <> 100) AND (l_deal_type = 'REVENUE')) THEN
2194: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2195: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');
2196: FND_MSG_PUB.Add;
2197: END IF;
2198: x_loading_status := 'CN_ADJ_SPLIT_PERCENT';

Line 2196: FND_MSG_PUB.Add;

2192: END LOOP;
2193: IF ((l_split_percent <> 100) AND (l_deal_type = 'REVENUE')) THEN
2194: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2195: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');
2196: FND_MSG_PUB.Add;
2197: END IF;
2198: x_loading_status := 'CN_ADJ_SPLIT_PERCENT';
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF;

Line 2336: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2332: END LOOP;
2333:
2334: --
2335: IF (l_data_exist = 'N') THEN
2336: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2337: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');
2338: FND_MSG_PUB.Add;
2339: END IF;
2340: x_loading_status := 'CN_NO_REC_DEAL';

Line 2338: FND_MSG_PUB.Add;

2334: --
2335: IF (l_data_exist = 'N') THEN
2336: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2337: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');
2338: FND_MSG_PUB.Add;
2339: END IF;
2340: x_loading_status := 'CN_NO_REC_DEAL';
2341: RAISE FND_API.G_EXC_ERROR;
2342: END IF;

Line 2477: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2473: END IF;
2474: END LOOP;
2475: END LOOP;
2476: ELSE
2477: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2478: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');
2479: FND_MSG_PUB.Add;
2480: END IF;
2481: x_loading_status := 'CN_NO_REC_DEAL';

Line 2479: FND_MSG_PUB.Add;

2475: END LOOP;
2476: ELSE
2477: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2478: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');
2479: FND_MSG_PUB.Add;
2480: END IF;
2481: x_loading_status := 'CN_NO_REC_DEAL';
2482: RAISE FND_API.G_EXC_ERROR;
2483: END IF; -- 11 end

Line 2508: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2504: x_msg_data => x_msg_data,
2505: x_loading_status => x_loading_status);
2506: --
2507: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2508: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2509: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
2510: FND_MSG_PUB.Add;
2511: END IF;
2512: x_loading_status := 'CN_UPDATE_INV_ERROR';

Line 2510: FND_MSG_PUB.Add;

2506: --
2507: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2508: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2509: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
2510: FND_MSG_PUB.Add;
2511: END IF;
2512: x_loading_status := 'CN_UPDATE_INV_ERROR';
2513: RAISE FND_API.G_EXC_ERROR;
2514: END IF;

Line 2668: FND_MSG_PUB.Count_And_Get(

2664: EXCEPTION
2665: WHEN FND_API.G_EXC_ERROR THEN
2666: ROLLBACK TO call_split;
2667: x_return_status := FND_API.G_RET_STS_ERROR ;
2668: FND_MSG_PUB.Count_And_Get(
2669: p_count => x_msg_count ,
2670: p_data => x_msg_data ,
2671: p_encoded => FND_API.G_FALSE);
2672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2676: FND_MSG_PUB.Count_And_Get(

2672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2673: ROLLBACK TO call_split;
2674: x_loading_status := 'UNEXPECTED_ERR';
2675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2676: FND_MSG_PUB.Count_And_Get(
2677: p_count => x_msg_count ,
2678: p_data => x_msg_data ,
2679: p_encoded => FND_API.G_FALSE);
2680: WHEN OTHERS THEN

Line 2684: IF FND_MSG_PUB.Check_Msg_Level(

2680: WHEN OTHERS THEN
2681: ROLLBACK TO call_split;
2682: x_loading_status := 'UNEXPECTED_ERR';
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2684: IF FND_MSG_PUB.Check_Msg_Level(
2685: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2687: END IF;
2688: FND_MSG_PUB.Count_And_Get(

Line 2685: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2681: ROLLBACK TO call_split;
2682: x_loading_status := 'UNEXPECTED_ERR';
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2684: IF FND_MSG_PUB.Check_Msg_Level(
2685: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2687: END IF;
2688: FND_MSG_PUB.Count_And_Get(
2689: p_count => x_msg_count ,

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

2682: x_loading_status := 'UNEXPECTED_ERR';
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2684: IF FND_MSG_PUB.Check_Msg_Level(
2685: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2687: END IF;
2688: FND_MSG_PUB.Count_And_Get(
2689: p_count => x_msg_count ,
2690: p_data => x_msg_data ,

Line 2688: FND_MSG_PUB.Count_And_Get(

2684: IF FND_MSG_PUB.Check_Msg_Level(
2685: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2687: END IF;
2688: FND_MSG_PUB.Count_And_Get(
2689: p_count => x_msg_count ,
2690: p_data => x_msg_data ,
2691: p_encoded => FND_API.G_FALSE);
2692: END;

Line 2726: FND_MSG_PUB.initialize;

2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: END IF;
2724: -- Initialize message list if p_init_msg_list is set to TRUE.
2725: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2726: FND_MSG_PUB.initialize;
2727: END IF;
2728: -- Initialize API return status to success
2729: x_return_status := FND_API.G_RET_STS_SUCCESS;
2730: x_loading_status := 'CN_INSERTED';

Line 2761: FND_MSG_PUB.Count_And_Get(

2757: EXCEPTION
2758: WHEN FND_API.G_EXC_ERROR THEN
2759: ROLLBACK TO get_trx_lines;
2760: x_return_status := FND_API.G_RET_STS_ERROR ;
2761: FND_MSG_PUB.Count_And_Get(
2762: p_count => x_msg_count ,
2763: p_data => x_msg_data ,
2764: p_encoded => FND_API.G_FALSE);
2765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2769: FND_MSG_PUB.Count_And_Get(

2765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2766: ROLLBACK TO get_trx_lines;
2767: x_loading_status := 'UNEXPECTED_ERR';
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2769: FND_MSG_PUB.Count_And_Get(
2770: p_count => x_msg_count ,
2771: p_data => x_msg_data ,
2772: p_encoded => FND_API.G_FALSE);
2773: WHEN OTHERS THEN

Line 2777: IF FND_MSG_PUB.Check_Msg_Level(

2773: WHEN OTHERS THEN
2774: ROLLBACK TO get_trx_lines;
2775: x_loading_status := 'UNEXPECTED_ERR';
2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2777: IF FND_MSG_PUB.Check_Msg_Level(
2778: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2780: END IF;
2781: FND_MSG_PUB.Count_And_Get(

Line 2778: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2774: ROLLBACK TO get_trx_lines;
2775: x_loading_status := 'UNEXPECTED_ERR';
2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2777: IF FND_MSG_PUB.Check_Msg_Level(
2778: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2780: END IF;
2781: FND_MSG_PUB.Count_And_Get(
2782: p_count => x_msg_count ,

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

2775: x_loading_status := 'UNEXPECTED_ERR';
2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2777: IF FND_MSG_PUB.Check_Msg_Level(
2778: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2780: END IF;
2781: FND_MSG_PUB.Count_And_Get(
2782: p_count => x_msg_count ,
2783: p_data => x_msg_data ,

Line 2781: FND_MSG_PUB.Count_And_Get(

2777: IF FND_MSG_PUB.Check_Msg_Level(
2778: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2780: END IF;
2781: FND_MSG_PUB.Count_And_Get(
2782: p_count => x_msg_count ,
2783: p_data => x_msg_data ,
2784: p_encoded => FND_API.G_FALSE);
2785: END;

Line 2853: FND_MSG_PUB.initialize;

2849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2850: END IF;
2851: -- Initialize message list if p_init_msg_list is set to TRUE.
2852: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2853: FND_MSG_PUB.initialize;
2854: END IF;
2855: -- Initialize API return status to success
2856: x_return_status := FND_API.G_RET_STS_SUCCESS;
2857: x_loading_status := 'CN_INSERTED';

Line 2893: FND_MSG_PUB.Count_And_Get(

2889: x_adj_count := x_adj_tbl.COUNT;
2890: EXCEPTION
2891: WHEN FND_API.G_EXC_ERROR THEN
2892: x_return_status := FND_API.G_RET_STS_ERROR ;
2893: FND_MSG_PUB.Count_And_Get(
2894: p_count => x_msg_count ,
2895: p_data => x_msg_data ,
2896: p_encoded => FND_API.G_FALSE);
2897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2900: FND_MSG_PUB.Count_And_Get(

2896: p_encoded => FND_API.G_FALSE);
2897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2898: x_loading_status := 'UNEXPECTED_ERR';
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2900: FND_MSG_PUB.Count_And_Get(
2901: p_count => x_msg_count ,
2902: p_data => x_msg_data ,
2903: p_encoded => FND_API.G_FALSE);
2904: WHEN OTHERS THEN

Line 2907: IF FND_MSG_PUB.Check_Msg_Level(

2903: p_encoded => FND_API.G_FALSE);
2904: WHEN OTHERS THEN
2905: x_loading_status := 'UNEXPECTED_ERR';
2906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2907: IF FND_MSG_PUB.Check_Msg_Level(
2908: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2910: END IF;
2911: FND_MSG_PUB.Count_And_Get(

Line 2908: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2904: WHEN OTHERS THEN
2905: x_loading_status := 'UNEXPECTED_ERR';
2906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2907: IF FND_MSG_PUB.Check_Msg_Level(
2908: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2910: END IF;
2911: FND_MSG_PUB.Count_And_Get(
2912: p_count => x_msg_count ,

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

2905: x_loading_status := 'UNEXPECTED_ERR';
2906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2907: IF FND_MSG_PUB.Check_Msg_Level(
2908: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2910: END IF;
2911: FND_MSG_PUB.Count_And_Get(
2912: p_count => x_msg_count ,
2913: p_data => x_msg_data ,

Line 2911: FND_MSG_PUB.Count_And_Get(

2907: IF FND_MSG_PUB.Check_Msg_Level(
2908: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2910: END IF;
2911: FND_MSG_PUB.Count_And_Get(
2912: p_count => x_msg_count ,
2913: p_data => x_msg_data ,
2914: p_encoded => FND_API.G_FALSE);
2915: END;

Line 2947: FND_MSG_PUB.initialize;

2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: END IF;
2945: -- Initialize message list if p_init_msg_list is set to TRUE.
2946: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2947: FND_MSG_PUB.initialize;
2948: END IF;
2949: -- Initialize API return status to success
2950: x_return_status := FND_API.G_RET_STS_SUCCESS;
2951: x_loading_status := 'CN_INSERTED';

Line 2983: FND_MSG_PUB.Count_And_Get(

2979: x_cust_info_rec.ship_to_contact := l_cust_info_rec.ship_to_contact;
2980: EXCEPTION
2981: WHEN FND_API.G_EXC_ERROR THEN
2982: x_return_status := FND_API.G_RET_STS_ERROR ;
2983: FND_MSG_PUB.Count_And_Get(
2984: p_count => x_msg_count ,
2985: p_data => x_msg_data ,
2986: p_encoded => FND_API.G_FALSE);
2987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2990: FND_MSG_PUB.Count_And_Get(

2986: p_encoded => FND_API.G_FALSE);
2987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2988: x_loading_status := 'UNEXPECTED_ERR';
2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2990: FND_MSG_PUB.Count_And_Get(
2991: p_count => x_msg_count ,
2992: p_data => x_msg_data ,
2993: p_encoded => FND_API.G_FALSE);
2994: WHEN OTHERS THEN

Line 2997: IF FND_MSG_PUB.Check_Msg_Level(

2993: p_encoded => FND_API.G_FALSE);
2994: WHEN OTHERS THEN
2995: x_loading_status := 'UNEXPECTED_ERR';
2996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2997: IF FND_MSG_PUB.Check_Msg_Level(
2998: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3000: END IF;
3001: FND_MSG_PUB.Count_And_Get(

Line 2998: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2994: WHEN OTHERS THEN
2995: x_loading_status := 'UNEXPECTED_ERR';
2996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2997: IF FND_MSG_PUB.Check_Msg_Level(
2998: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3000: END IF;
3001: FND_MSG_PUB.Count_And_Get(
3002: p_count => x_msg_count ,

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

2995: x_loading_status := 'UNEXPECTED_ERR';
2996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2997: IF FND_MSG_PUB.Check_Msg_Level(
2998: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3000: END IF;
3001: FND_MSG_PUB.Count_And_Get(
3002: p_count => x_msg_count ,
3003: p_data => x_msg_data ,

Line 3001: FND_MSG_PUB.Count_And_Get(

2997: IF FND_MSG_PUB.Check_Msg_Level(
2998: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3000: END IF;
3001: FND_MSG_PUB.Count_And_Get(
3002: p_count => x_msg_count ,
3003: p_data => x_msg_data ,
3004: p_encoded => FND_API.G_FALSE);
3005: END;

Line 3044: FND_MSG_PUB.initialize;

3040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3041: END IF;
3042: -- Initialize message list if p_init_msg_list is set to TRUE.
3043: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3044: FND_MSG_PUB.initialize;
3045: END IF;
3046: -- Initialize API return status to success
3047: x_return_status := FND_API.G_RET_STS_SUCCESS;
3048: x_loading_status := 'CN_INSERTED';

Line 3063: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

3059: a.trx_type IN ('ITD', 'GRP', 'THR','BONUS') OR h.trx_type IN ('ITD', 'GRP', 'THR','BONUS') OR
3060: a.terr_id IS NOT NULL);
3061:
3062: IF l_comm_line_count > 0 THEN
3063: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3064: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_ADJUST_OBSOLETE');
3065: FND_MSG_PUB.Add;
3066: END IF;
3067: x_loading_status := 'CN_ADJUST_TX_ERROR';

Line 3065: FND_MSG_PUB.Add;

3061:
3062: IF l_comm_line_count > 0 THEN
3063: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3064: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_ADJUST_OBSOLETE');
3065: FND_MSG_PUB.Add;
3066: END IF;
3067: x_loading_status := 'CN_ADJUST_TX_ERROR';
3068: RAISE FND_API.G_EXC_ERROR;
3069: END IF;

Line 3114: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

3110: x_msg_data => x_msg_data,
3111: x_loading_status => x_loading_status);
3112: --
3113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3114: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3115: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3116: FND_MSG_PUB.Add;
3117: END IF;
3118: x_loading_status := 'CN_UPDATE_INV_ERROR';

Line 3116: FND_MSG_PUB.Add;

3112: --
3113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3114: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3115: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3116: FND_MSG_PUB.Add;
3117: END IF;
3118: x_loading_status := 'CN_UPDATE_INV_ERROR';
3119: RAISE FND_API.G_EXC_ERROR;
3120: END IF;

Line 3201: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

3197: x_msg_data => x_msg_data,
3198: x_loading_status => x_loading_status);
3199: --
3200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3201: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3202: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3203: FND_MSG_PUB.Add;
3204: END IF;
3205: x_loading_status := 'CN_UPDATE_INV_ERROR';

Line 3203: FND_MSG_PUB.Add;

3199: --
3200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3201: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3202: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3203: FND_MSG_PUB.Add;
3204: END IF;
3205: x_loading_status := 'CN_UPDATE_INV_ERROR';
3206: RAISE FND_API.G_EXC_ERROR;
3207: END IF;

Line 3232: FND_MSG_PUB.Count_And_Get(

3228:
3229: EXCEPTION
3230: WHEN FND_API.G_EXC_ERROR THEN
3231: x_return_status := FND_API.G_RET_STS_ERROR ;
3232: FND_MSG_PUB.Count_And_Get(
3233: p_count => x_msg_count ,
3234: p_data => x_msg_data ,
3235: p_encoded => FND_API.G_FALSE);
3236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3239: FND_MSG_PUB.Count_And_Get(

3235: p_encoded => FND_API.G_FALSE);
3236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3237: x_loading_status := 'UNEXPECTED_ERR';
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3239: FND_MSG_PUB.Count_And_Get(
3240: p_count => x_msg_count ,
3241: p_data => x_msg_data ,
3242: p_encoded => FND_API.G_FALSE);
3243: WHEN OTHERS THEN

Line 3246: IF FND_MSG_PUB.Check_Msg_Level(

3242: p_encoded => FND_API.G_FALSE);
3243: WHEN OTHERS THEN
3244: x_loading_status := 'UNEXPECTED_ERR';
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3246: IF FND_MSG_PUB.Check_Msg_Level(
3247: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3248: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3249: END IF;
3250: FND_MSG_PUB.Count_And_Get(

Line 3247: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3243: WHEN OTHERS THEN
3244: x_loading_status := 'UNEXPECTED_ERR';
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3246: IF FND_MSG_PUB.Check_Msg_Level(
3247: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3248: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3249: END IF;
3250: FND_MSG_PUB.Count_And_Get(
3251: p_count => x_msg_count ,

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

3244: x_loading_status := 'UNEXPECTED_ERR';
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3246: IF FND_MSG_PUB.Check_Msg_Level(
3247: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3248: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3249: END IF;
3250: FND_MSG_PUB.Count_And_Get(
3251: p_count => x_msg_count ,
3252: p_data => x_msg_data ,

Line 3250: FND_MSG_PUB.Count_And_Get(

3246: IF FND_MSG_PUB.Check_Msg_Level(
3247: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3248: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3249: END IF;
3250: FND_MSG_PUB.Count_And_Get(
3251: p_count => x_msg_count ,
3252: p_data => x_msg_data ,
3253: p_encoded => FND_API.G_FALSE);
3254: END;

Line 3290: FND_MSG_PUB.initialize;

3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: END IF;
3288: -- Initialize message list if p_init_msg_list is set to TRUE.
3289: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3290: FND_MSG_PUB.initialize;
3291: END IF;
3292: -- Initialize API return status to success
3293: x_return_status := FND_API.G_RET_STS_SUCCESS;
3294: x_loading_status := 'CN_INSERTED';

Line 3333: FND_MSG_PUB.Count_And_Get(

3329: END IF;
3330: EXCEPTION
3331: WHEN FND_API.G_EXC_ERROR THEN
3332: x_return_status := FND_API.G_RET_STS_ERROR ;
3333: FND_MSG_PUB.Count_And_Get(
3334: p_count => x_msg_count ,
3335: p_data => x_msg_data ,
3336: p_encoded => FND_API.G_FALSE);
3337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3340: FND_MSG_PUB.Count_And_Get(

3336: p_encoded => FND_API.G_FALSE);
3337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3338: x_loading_status := 'UNEXPECTED_ERR';
3339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3340: FND_MSG_PUB.Count_And_Get(
3341: p_count => x_msg_count ,
3342: p_data => x_msg_data ,
3343: p_encoded => FND_API.G_FALSE);
3344: WHEN OTHERS THEN

Line 3347: IF FND_MSG_PUB.Check_Msg_Level(

3343: p_encoded => FND_API.G_FALSE);
3344: WHEN OTHERS THEN
3345: x_loading_status := 'UNEXPECTED_ERR';
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3347: IF FND_MSG_PUB.Check_Msg_Level(
3348: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3350: END IF;
3351: FND_MSG_PUB.Count_And_Get(

Line 3348: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3344: WHEN OTHERS THEN
3345: x_loading_status := 'UNEXPECTED_ERR';
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3347: IF FND_MSG_PUB.Check_Msg_Level(
3348: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3350: END IF;
3351: FND_MSG_PUB.Count_And_Get(
3352: p_count => x_msg_count ,

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

3345: x_loading_status := 'UNEXPECTED_ERR';
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3347: IF FND_MSG_PUB.Check_Msg_Level(
3348: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3350: END IF;
3351: FND_MSG_PUB.Count_And_Get(
3352: p_count => x_msg_count ,
3353: p_data => x_msg_data ,

Line 3351: FND_MSG_PUB.Count_And_Get(

3347: IF FND_MSG_PUB.Check_Msg_Level(
3348: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
3350: END IF;
3351: FND_MSG_PUB.Count_And_Get(
3352: p_count => x_msg_count ,
3353: p_data => x_msg_data ,
3354: p_encoded => FND_API.G_FALSE);
3355: END;