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.IBE_SHOP_LIST_PVT dependencies on FND_MSG_PUB

Line 634: FND_MSG_PUB.initialize;

630: END IF;
631:
632: -- Initialize message list IF p_init_msg_list is set to TRUE.
633: IF FND_API.to_Boolean( p_init_msg_list ) THEN
634: FND_MSG_PUB.initialize;
635: END IF;
636:
637: -- Initialize API return status to success
638: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 691: FND_MSG_PUB.add;

687: p_OBJECT_VERSION_NUMBER => p_obj_ver_numbers(i));
688: EXCEPTION
689: WHEN NO_DATA_FOUND THEN
690: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
691: FND_MSG_PUB.add;
692: RAISE FND_API.G_EXC_ERROR;
693: END;
694: END LOOP;
695:

Line 707: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

703: COMMIT WORK;
704: END IF;
705:
706: -- Standard call to get message count and IF count is 1, get message info.
707: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count ,
709: p_data => x_msg_data );
710: EXCEPTION
711: WHEN FND_API.G_EXC_ERROR THEN

Line 714: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

710: EXCEPTION
711: WHEN FND_API.G_EXC_ERROR THEN
712: ROLLBACK TO Delete_PVT;
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: ROLLBACK TO Delete_PVT;

Line 720: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

716: p_data => x_msg_data);
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: ROLLBACK TO Delete_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
721: p_count => x_msg_count,
722: p_data => x_msg_data);
723: WHEN OTHERS THEN
724: ROLLBACK TO Delete_PVT;

Line 727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

723: WHEN OTHERS THEN
724: ROLLBACK TO Delete_PVT;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
728: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
729: l_api_name);
730: END IF;
731:

Line 728: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

724: ROLLBACK TO Delete_PVT;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
728: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
729: l_api_name);
730: END IF;
731:
732: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 732: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

728: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
729: l_api_name);
730: END IF;
731:
732: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
733: p_count => x_msg_count,
734: p_data => x_msg_data);
735: END Delete;
736:

Line 785: FND_MSG_PUB.initialize;

781: END IF;
782:
783: -- Initialize message list IF p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean( p_init_msg_list ) THEN
785: FND_MSG_PUB.initialize;
786: END IF;
787:
788: -- Initialize API return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 842: FND_MSG_PUB.add;

838: AND OBJECT_VERSION_NUMBER = p_obj_ver_numbers(i);
839:
840: IF (SQL%NOTFOUND) THEN
841: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
842: FND_MSG_PUB.add;
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845: END LOOP;
846:

Line 858: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

854: COMMIT WORK;
855: END IF;
856:
857: -- Standard call to get message count and IF count is 1, get message info.
858: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count ,
860: p_data => x_msg_data );
861:
862: EXCEPTION

Line 866: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

862: EXCEPTION
863: WHEN FND_API.G_EXC_ERROR THEN
864: ROLLBACK TO Delete_All_Lines_PVT;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
867: p_count => x_msg_count,
868: p_data => x_msg_data);
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: ROLLBACK TO Delete_All_Lines_PVT;

Line 872: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

868: p_data => x_msg_data);
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: ROLLBACK TO Delete_All_Lines_PVT;
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
872: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
873: p_count => x_msg_count,
874: p_data => x_msg_data);
875: WHEN OTHERS THEN
876: ROLLBACK TO Delete_All_Lines_PVT;

Line 879: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

875: WHEN OTHERS THEN
876: ROLLBACK TO Delete_All_Lines_PVT;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878:
879: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
880: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
881: l_api_name);
882: END IF;
883:

Line 880: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

876: ROLLBACK TO Delete_All_Lines_PVT;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878:
879: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
880: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
881: l_api_name);
882: END IF;
883:
884: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 884: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

880: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
881: l_api_name);
882: END IF;
883:
884: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
885: p_count => x_msg_count,
886: p_data => x_msg_data);
887: END Delete_All_Lines;
888:

Line 1007: FND_MSG_PUB.initialize;

1003: END IF;
1004:
1005: -- Initialize message list IF p_init_msg_list is set to TRUE.
1006: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1007: FND_MSG_PUB.initialize;
1008: END IF;
1009:
1010: -- Initialize API return status to success
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1049: FND_MSG_PUB.add;

1045: where SHP_LIST_ITEM_ID = p_shop_list_line_ids(1);
1046: EXCEPTION
1047: WHEN NO_DATA_FOUND THEN
1048: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
1049: FND_MSG_PUB.add;
1050: RAISE FND_API.G_EXC_ERROR;
1051: END;
1052: END IF;
1053:

Line 1067: FND_MSG_PUB.add;

1063: p_Shp_List_Item_Id => p_shop_list_line_ids(i));
1064: EXCEPTION
1065: WHEN NO_DATA_FOUND THEN
1066: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
1067: FND_MSG_PUB.add;
1068: RAISE FND_API.G_EXC_ERROR;
1069: END;
1070: END LOOP;
1071:

Line 1080: FND_MSG_PUB.add;

1076: WHERE SHP_LIST_ID = l_shop_list_id;
1077:
1078: IF (SQL%NOTFOUND) THEN
1079: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
1080: FND_MSG_PUB.add;
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: -- End of API body.

Line 1095: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1091: COMMIT WORK;
1092: END IF;
1093:
1094: -- Standard call to get message count and IF count is 1, get message info.
1095: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1096: p_count => x_msg_count ,
1097: p_data => x_msg_data );
1098:
1099: EXCEPTION

Line 1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1099: EXCEPTION
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO Delete_Lines_PVT;
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => x_msg_data);
1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: ROLLBACK TO Delete_Lines_PVT;

Line 1109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1105: p_data => x_msg_data);
1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: ROLLBACK TO Delete_Lines_PVT;
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1110: p_count => x_msg_count,
1111: p_data => x_msg_data);
1112: WHEN OTHERS THEN
1113: ROLLBACK TO Delete_Lines_PVT;

Line 1116: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1112: WHEN OTHERS THEN
1113: ROLLBACK TO Delete_Lines_PVT;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1118: l_api_name);
1119: END IF;
1120:

Line 1117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1113: ROLLBACK TO Delete_Lines_PVT;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1118: l_api_name);
1119: END IF;
1120:
1121: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1121: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1118: l_api_name);
1119: END IF;
1120:
1121: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1122: p_count => x_msg_count,
1123: p_data => x_msg_data);
1124: END Delete_Lines;
1125:

Line 1167: FND_MSG_PUB.initialize;

1163: END IF;
1164:
1165: -- Initialize message list IF p_init_msg_list is set to TRUE.
1166: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1167: FND_MSG_PUB.initialize;
1168: END IF;
1169:
1170: -- Initialize API return status to success
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1238: FND_MSG_PUB.add;

1234: --dbms_output.put_line('New line created for header, shp_list_id = ' || x_sl_header_id);
1235: EXCEPTION
1236: WHEN DUP_VAL_ON_INDEX THEN
1237: FND_MESSAGE.set_name('IBE', 'IBE_SL_DUPLICATE_LISTNAME');
1238: FND_MSG_PUB.add;
1239: RAISE FND_API.G_EXC_ERROR;
1240:
1241: WHEN NO_DATA_FOUND THEN
1242: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');

Line 1243: FND_MSG_PUB.add;

1239: RAISE FND_API.G_EXC_ERROR;
1240:
1241: WHEN NO_DATA_FOUND THEN
1242: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
1243: FND_MSG_PUB.add;
1244: RAISE FND_API.G_EXC_ERROR;
1245: END;
1246: ELSE
1247: -- Existing shopping list. Update the shopping list.

Line 1289: FND_MSG_PUB.add;

1285: --dbms_output.put_line('header updated, shp_list_id = ' || x_sl_header_id);
1286: EXCEPTION
1287: WHEN DUP_VAL_ON_INDEX THEN
1288: FND_MESSAGE.set_name('IBE', 'IBE_SL_DUPLICATE_LISTNAME');
1289: FND_MSG_PUB.add;
1290: RAISE FND_API.G_EXC_ERROR;
1291:
1292: WHEN NO_DATA_FOUND THEN
1293: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');

Line 1294: FND_MSG_PUB.add;

1290: RAISE FND_API.G_EXC_ERROR;
1291:
1292: WHEN NO_DATA_FOUND THEN
1293: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
1294: FND_MSG_PUB.add;
1295: RAISE FND_API.G_EXC_ERROR;
1296: END;
1297: END IF;
1298:

Line 1468: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1464: COMMIT WORK;
1465: END IF;
1466:
1467: -- Standard call to get message count and IF count is 1, get message info.
1468: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1469: p_count => x_msg_count ,
1470: p_data => x_msg_data );
1471:
1472: EXCEPTION

Line 1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 1482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 1489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 1490: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1486: ROLLBACK TO Save_PVT;
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488:
1489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1490: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1491: l_api_name);
1492: END IF;
1493:
1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 1585: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1581: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(-)');
1582: END IF;
1583:
1584: -- Standard call to get message count and IF count is 1, get message info.
1585: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1586: p_count => x_msg_count ,
1587: p_data => x_msg_data );
1588:
1589: EXCEPTION

Line 1592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1588:
1589: EXCEPTION
1590: WHEN FND_API.G_EXC_ERROR THEN
1591: x_return_status := FND_API.G_RET_STS_ERROR;
1592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1593: p_count => x_msg_count,
1594: p_data => x_msg_data);
1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1597: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1593: p_count => x_msg_count,
1594: p_data => x_msg_data);
1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1597: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1598: p_count => x_msg_count,
1599: p_data => x_msg_data);
1600: WHEN OTHERS THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1599: p_data => x_msg_data);
1600: WHEN OTHERS THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602:
1603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1604: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1605: l_api_name);
1606: END IF;
1607:

Line 1604: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1600: WHEN OTHERS THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602:
1603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1604: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1605: l_api_name);
1606: END IF;
1607:
1608: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1608: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1604: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1605: l_api_name);
1606: END IF;
1607:
1608: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data);
1611: END Update_Config_Item_Lines;
1612:

Line 1657: FND_MSG_PUB.initialize;

1653: END IF;
1654:
1655: -- Initialize message list IF p_init_msg_list is set to TRUE.
1656: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1657: FND_MSG_PUB.initialize;
1658: END IF;
1659:
1660: -- Initialize API return status to success
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1796: FND_MSG_PUB.add;

1792: END IF;
1793: EXCEPTION
1794: WHEN NO_DATA_FOUND THEN
1795: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
1796: FND_MSG_PUB.add;
1797: RAISE FND_API.G_EXC_ERROR;
1798: END;
1799:
1800: --dbms_output.put_line('After Save...');

Line 1814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1810: COMMIT WORK;
1811: END IF;
1812:
1813: -- Standard call to get message count and IF count is 1, get message info.
1814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count ,
1816: p_data => x_msg_data );
1817: EXCEPTION
1818: WHEN FND_API.G_EXC_ERROR THEN

Line 1821: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1817: EXCEPTION
1818: WHEN FND_API.G_EXC_ERROR THEN
1819: ROLLBACK TO Save_List_From_Items_PVT;
1820: x_return_status := FND_API.G_RET_STS_ERROR;
1821: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1822: p_count => x_msg_count,
1823: p_data => x_msg_data);
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825: ROLLBACK TO Save_List_From_Items_PVT;

Line 1827: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1823: p_data => x_msg_data);
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825: ROLLBACK TO Save_List_From_Items_PVT;
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1828: p_count => x_msg_count,
1829: p_data => x_msg_data);
1830: WHEN OTHERS THEN
1831: ROLLBACK TO Save_List_From_Items_PVT;

Line 1834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1830: WHEN OTHERS THEN
1831: ROLLBACK TO Save_List_From_Items_PVT;
1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833:
1834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1836: l_api_name);
1837: END IF;
1838:

Line 1835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1831: ROLLBACK TO Save_List_From_Items_PVT;
1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833:
1834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1836: l_api_name);
1837: END IF;
1838:
1839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1836: l_api_name);
1837: END IF;
1838:
1839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data);
1842: END Save_List_From_Items;
1843:

Line 1936: FND_MSG_PUB.initialize;

1932: END IF;
1933:
1934: -- Initialize message list IF p_init_msg_list is set to TRUE.
1935: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1936: FND_MSG_PUB.initialize;
1937: END IF;
1938:
1939: -- Initialize API return status to success
1940: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2292: FND_MSG_PUB.add;

2288: EXCEPTION
2289: WHEN NO_DATA_FOUND THEN
2290:
2291: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');
2292: FND_MSG_PUB.add;
2293: RAISE FND_API.G_EXC_ERROR;
2294: END;
2295:
2296: --dbms_output.put_line('After Save...');

Line 2309: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2305: COMMIT WORK;
2306: END IF;
2307:
2308: -- Standard call to get message count and IF count is 1, get message info.
2309: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2310: p_count => x_msg_count ,
2311: p_data => x_msg_data );
2312:
2313: EXCEPTION

Line 2317: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2313: EXCEPTION
2314: WHEN FND_API.G_EXC_ERROR THEN
2315: ROLLBACK TO Save_List_From_Quote_PVT;
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2318: p_count => x_msg_count,
2319: p_data => x_msg_data);
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2321: ROLLBACK TO Save_List_From_Quote_PVT;

Line 2323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2319: p_data => x_msg_data);
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2321: ROLLBACK TO Save_List_From_Quote_PVT;
2322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2324: p_count => x_msg_count,
2325: p_data => x_msg_data);
2326: WHEN OTHERS THEN
2327: ROLLBACK TO Save_List_From_Quote_PVT;

Line 2330: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2326: WHEN OTHERS THEN
2327: ROLLBACK TO Save_List_From_Quote_PVT;
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2329:
2330: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2332: l_api_name);
2333: END IF;
2334:

Line 2331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

2327: ROLLBACK TO Save_List_From_Quote_PVT;
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2329:
2330: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2332: l_api_name);
2333: END IF;
2334:
2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2332: l_api_name);
2333: END IF;
2334:
2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2336: p_count => x_msg_count,
2337: p_data => x_msg_data);
2338: END Save_List_From_Quote;
2339:

Line 2752: FND_MSG_PUB.initialize;

2748: END IF;
2749:
2750: -- Initialize message list IF p_init_msg_list is set to TRUE.
2751: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2752: FND_MSG_PUB.initialize;
2753: END IF;
2754:
2755: -- Initialize API return status to success
2756: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2790: --dbms_OUTPUT.Put_Line(FND_MSG_PUB.Get(p_encoded => FND_API.g_false));

2786: --dbms_output.put_line('x_msg_count = ' || x_msg_count);
2787: --dbms_output.put_line('x_msg_data = ' || x_msg_data);
2788: /*
2789: FOR I IN 1..x_msg_count LOOP
2790: --dbms_OUTPUT.Put_Line(FND_MSG_PUB.Get(p_encoded => FND_API.g_false));
2791: END LOOP;
2792: */
2793: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2794: RAISE FND_API.G_EXC_ERROR;

Line 3040: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3036: COMMIT WORK;
3037: END IF;
3038:
3039: -- Standard call to get message count and IF count is 1, get message info.
3040: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3041: p_count => x_msg_count ,
3042: p_data => x_msg_data );
3043:
3044: EXCEPTION

Line 3048: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3044: EXCEPTION
3045: WHEN FND_API.G_EXC_ERROR THEN
3046: ROLLBACK TO Save_Quote_From_List_Items_PVT;
3047: x_return_status := FND_API.G_RET_STS_ERROR;
3048: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3049: p_count => x_msg_count,
3050: p_data => x_msg_data);
3051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3052: ROLLBACK TO Save_Quote_From_List_Items_PVT;

Line 3054: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3050: p_data => x_msg_data);
3051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3052: ROLLBACK TO Save_Quote_From_List_Items_PVT;
3053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3054: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3055: p_count => x_msg_count,
3056: p_data => x_msg_data);
3057: WHEN OTHERS THEN
3058: ROLLBACK TO Save_Quote_From_List_Items_PVT;

Line 3061: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3057: WHEN OTHERS THEN
3058: ROLLBACK TO Save_Quote_From_List_Items_PVT;
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060:
3061: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3062: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3063: l_api_name);
3064: END IF;
3065:

Line 3062: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3058: ROLLBACK TO Save_Quote_From_List_Items_PVT;
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060:
3061: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3062: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3063: l_api_name);
3064: END IF;
3065:
3066: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3066: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3062: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3063: l_api_name);
3064: END IF;
3065:
3066: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3067: p_count => x_msg_count,
3068: p_data => x_msg_data);
3069: END Save_Quote_From_List_Items;
3070: