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

Line 257: FND_MSG_PUB.ADD;

253: WHILE l_len_sqlerrm >= i LOOP
254: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
255: FND_MESSAGE.Set_token('MSG_TXT' , substr(x_msg_data,i,240));
256: i := i + 240;
257: FND_MSG_PUB.ADD;
258: END LOOP;
259:
260: END IF; -- bug# 1935468
261:

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

393: OPEN resource_id(P_header_sales_credit_TBL(i).SALESREP_ID);
394: FETCH resource_id INTO x_header_sales_credit_TBL(i).RESOURCE_ID;
395: IF (resource_id%NOTFOUND) THEN
396: CLOSE resource_id;
397: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
398: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
399: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
400: FND_MSG_PUB.ADD;
401: END IF;

Line 400: FND_MSG_PUB.ADD;

396: CLOSE resource_id;
397: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
398: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
399: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
400: FND_MSG_PUB.ADD;
401: END IF;
402: ELSE
403: CLOSE resource_id;
404: END IF;

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

457: OPEN resource_id(P_line_sales_credit_TBL(i).SALESREP_ID);
458: FETCH resource_id into x_line_sales_credit_TBL(i).RESOURCE_ID;
459: IF (resource_id%NOTFOUND) THEN
460: CLOSE resource_id;
461: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
462: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
463: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
464: FND_MSG_PUB.ADD;
465: END IF;

Line 464: FND_MSG_PUB.ADD;

460: CLOSE resource_id;
461: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
462: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
463: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
464: FND_MSG_PUB.ADD;
465: END IF;
466: ELSE
467: CLOSE resource_id;
468: END IF;

Line 635: FND_MSG_PUB.initialize;

631:
632: -- Initialize message list if p_init_msg_list is set to TRUE.
633: IF FND_API.to_Boolean( p_init_msg_list )
634: THEN
635: FND_MSG_PUB.initialize;
636: END IF;
637:
638: -- Debug Message
639: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

Line 639: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

635: FND_MSG_PUB.initialize;
636: END IF;
637:
638: -- Debug Message
639: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
640:
641: -- Initialize API return status to SUCCESS
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:

Line 719: FND_MSG_PUB.Count_And_Get

715:
716:
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: ( p_count => x_msg_count,
721: p_data => x_msg_data
722: );
723:

Line 730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

726: null;
727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
728: P_API_NAME => L_API_NAME
729: ,P_PKG_NAME => G_PKG_NAME
730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
731: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
732: ,X_MSG_COUNT => X_MSG_COUNT
733: ,X_MSG_DATA => X_MSG_DATA
734: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

737: null;
738: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
739: P_API_NAME => L_API_NAME
740: ,P_PKG_NAME => G_PKG_NAME
741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
742: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
743: ,X_MSG_COUNT => X_MSG_COUNT
744: ,X_MSG_DATA => X_MSG_DATA
745: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

747: null;
748: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
749: P_API_NAME => L_API_NAME
750: ,P_PKG_NAME => G_PKG_NAME
751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
752: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
753: ,X_MSG_COUNT => X_MSG_COUNT
754: ,X_MSG_DATA => X_MSG_DATA
755: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 844: FND_MSG_PUB.initialize;

840:
841: -- Initialize message list if p_init_msg_list is set to TRUE.
842: IF FND_API.to_Boolean( p_init_msg_list )
843: THEN
844: FND_MSG_PUB.initialize;
845: END IF;
846:
847: -- Debug Message
848: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

Line 848: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

844: FND_MSG_PUB.initialize;
845: END IF;
846:
847: -- Debug Message
848: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
849:
850: -- Initialize API return status to SUCCESS
851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852:

Line 931: FND_MSG_PUB.Count_And_Get

927:
928:
929:
930: -- Standard call to get message count and if count is 1, get message info.
931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data
934: );
935:

Line 942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

938: null;
939: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME
941: ,P_PKG_NAME => G_PKG_NAME
942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
943: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
944: ,X_MSG_COUNT => X_MSG_COUNT
945: ,X_MSG_DATA => X_MSG_DATA
946: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

949: null;
950: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
951: P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME
953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
954: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
955: ,X_MSG_COUNT => X_MSG_COUNT
956: ,X_MSG_DATA => X_MSG_DATA
957: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 963: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

959: null;
960: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
961: P_API_NAME => L_API_NAME
962: ,P_PKG_NAME => G_PKG_NAME
963: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
964: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
965: ,X_MSG_COUNT => X_MSG_COUNT
966: ,X_MSG_DATA => X_MSG_DATA
967: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1004: FND_MSG_PUB.initialize;

1000:
1001: -- Initialize message list if p_init_msg_list is set to TRUE.
1002: IF FND_API.to_Boolean( p_init_msg_list )
1003: THEN
1004: FND_MSG_PUB.initialize;
1005: END IF;
1006:
1007: -- Debug Message
1008: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

Line 1008: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1004: FND_MSG_PUB.initialize;
1005: END IF;
1006:
1007: -- Debug Message
1008: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1009:
1010: -- Initialize API return status to SUCCESS
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:

Line 1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1018: -- Validate Environment
1019: -- ******************************************************************
1020: IF FND_GLOBAL.User_Id IS NULL
1021: THEN
1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1025: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1026: FND_MSG_PUB.ADD;

Line 1026: FND_MSG_PUB.ADD;

1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1025: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1026: FND_MSG_PUB.ADD;
1027: END IF;
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:

Line 1060: FND_MSG_PUB.Count_And_Get

1056:
1057:
1058:
1059: -- Standard call to get message count and if count is 1, get message info.
1060: FND_MSG_PUB.Count_And_Get
1061: ( p_count => x_msg_count,
1062: p_data => x_msg_data
1063: );
1064:

Line 1071: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1067: null;
1068: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1069: P_API_NAME => L_API_NAME
1070: ,P_PKG_NAME => G_PKG_NAME
1071: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1072: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1073: ,X_MSG_COUNT => X_MSG_COUNT
1074: ,X_MSG_DATA => X_MSG_DATA
1075: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1078: null;
1079: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1080: P_API_NAME => L_API_NAME
1081: ,P_PKG_NAME => G_PKG_NAME
1082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1083: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1084: ,X_MSG_COUNT => X_MSG_COUNT
1085: ,X_MSG_DATA => X_MSG_DATA
1086: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1088: null;
1089: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1090: P_API_NAME => L_API_NAME
1091: ,P_PKG_NAME => G_PKG_NAME
1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1093: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1094: ,X_MSG_COUNT => X_MSG_COUNT
1095: ,X_MSG_DATA => X_MSG_DATA
1096: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1190: FND_MSG_PUB.initialize;

1186:
1187: -- Initialize message list if p_init_msg_list is set to TRUE.
1188: IF FND_API.to_Boolean( p_init_msg_list )
1189: THEN
1190: FND_MSG_PUB.initialize;
1191: END IF;
1192:
1193: -- Debug Message
1194: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

Line 1194: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1190: FND_MSG_PUB.initialize;
1191: END IF;
1192:
1193: -- Debug Message
1194: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1195:
1196: -- Initialize API return status to SUCCESS
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:

Line 1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1204: -- Validate Environment
1205: -- ******************************************************************
1206: IF FND_GLOBAL.User_Id IS NULL
1207: THEN
1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1209: THEN
1210: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1211: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1212: FND_MSG_PUB.ADD;

Line 1212: FND_MSG_PUB.ADD;

1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1209: THEN
1210: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1211: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1212: FND_MSG_PUB.ADD;
1213: END IF;
1214: RAISE FND_API.G_EXC_ERROR;
1215: END IF;
1216: /*

Line 1303: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

1299: END IF;
1300:
1301:
1302: -- Debug Message
1303: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1304:
1305:
1306: -- Standard call to get message count and if count is 1, get message info.
1307: FND_MSG_PUB.Count_And_Get

Line 1307: FND_MSG_PUB.Count_And_Get

1303: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1304:
1305:
1306: -- Standard call to get message count and if count is 1, get message info.
1307: FND_MSG_PUB.Count_And_Get
1308: ( p_count => x_msg_count,
1309: p_data => x_msg_data
1310: );
1311:

Line 1317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1313: WHEN FND_API.G_EXC_ERROR THEN
1314: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1315: P_API_NAME => L_API_NAME
1316: ,P_PKG_NAME => G_PKG_NAME
1317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1318: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1319: ,X_MSG_COUNT => X_MSG_COUNT
1320: ,X_MSG_DATA => X_MSG_DATA
1321: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1324: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME
1326: ,P_PKG_NAME => G_PKG_NAME
1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1328: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1329: ,X_MSG_COUNT => X_MSG_COUNT
1330: ,X_MSG_DATA => X_MSG_DATA
1331: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1442: FND_MSG_PUB.initialize;

1438:
1439: -- Initialize message list if p_init_msg_list is set to TRUE.
1440: IF FND_API.to_Boolean( p_init_msg_list )
1441: THEN
1442: FND_MSG_PUB.initialize;
1443: END IF;
1444:
1445: -- Debug Message
1446: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

Line 1446: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1442: FND_MSG_PUB.initialize;
1443: END IF;
1444:
1445: -- Debug Message
1446: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1447:
1448: -- Initialize API return status to SUCCESS
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450:

Line 1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1456: -- Validate Environment
1457: -- ******************************************************************
1458: IF FND_GLOBAL.User_Id IS NULL
1459: THEN
1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1461: THEN
1462: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1463: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1464: FND_MSG_PUB.ADD;

Line 1464: FND_MSG_PUB.ADD;

1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1461: THEN
1462: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1463: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1464: FND_MSG_PUB.ADD;
1465: END IF;
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468:

Line 1545: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

1541: END IF;
1542:
1543:
1544: -- Debug Message
1545: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1546:
1547:
1548: -- Standard call to get message count and if count is 1, get message info.
1549: FND_MSG_PUB.Count_And_Get

Line 1549: FND_MSG_PUB.Count_And_Get

1545: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1546:
1547:
1548: -- Standard call to get message count and if count is 1, get message info.
1549: FND_MSG_PUB.Count_And_Get
1550: ( p_count => x_msg_count,
1551: p_data => x_msg_data
1552: );
1553:

Line 1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1555: WHEN FND_API.G_EXC_ERROR THEN
1556: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1557: P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1560: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1561: ,X_MSG_COUNT => X_MSG_COUNT
1562: ,X_MSG_DATA => X_MSG_DATA
1563: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1569: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1566: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1567: P_API_NAME => L_API_NAME
1568: ,P_PKG_NAME => G_PKG_NAME
1569: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1570: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1571: ,X_MSG_COUNT => X_MSG_COUNT
1572: ,X_MSG_DATA => X_MSG_DATA
1573: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1805: FND_MSG_PUB.initialize;

1801:
1802: -- Initialize message list if p_init_msg_list is set to TRUE.
1803: IF FND_API.to_Boolean( p_init_msg_list )
1804: THEN
1805: FND_MSG_PUB.initialize;
1806: END IF;
1807:
1808: -- Debug Message
1809: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

Line 1809: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1805: FND_MSG_PUB.initialize;
1806: END IF;
1807:
1808: -- Debug Message
1809: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1810:
1811: -- Initialize API return status to SUCCESS
1812: x_return_status := FND_API.G_RET_STS_SUCCESS;
1813:

Line 1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1819: -- Validate Environment
1820: -- ******************************************************************
1821: IF FND_GLOBAL.User_Id IS NULL
1822: THEN
1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1824: THEN
1825: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1826: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1827: FND_MSG_PUB.ADD;

Line 1827: FND_MSG_PUB.ADD;

1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1824: THEN
1825: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1826: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1845: END IF;
1846:
1847: IF (l_split_pay_prof = 'N') THEN
1848: IF p_header_payment_tbl.count > 1 THEN
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1850: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1851: FND_MSG_PUB.ADD;
1852: END IF;
1853: RAISE FND_API.G_EXC_ERROR;

Line 1851: FND_MSG_PUB.ADD;

1847: IF (l_split_pay_prof = 'N') THEN
1848: IF p_header_payment_tbl.count > 1 THEN
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1850: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1851: FND_MSG_PUB.ADD;
1852: END IF;
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF p_header_payment_tbl.count = 1 THEN
1855: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN

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

1852: END IF;
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF p_header_payment_tbl.count = 1 THEN
1855: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
1856: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1857: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1858: FND_MSG_PUB.ADD;
1859: END IF;
1860: RAISE FND_API.G_EXC_ERROR;

Line 1858: FND_MSG_PUB.ADD;

1854: ELSIF p_header_payment_tbl.count = 1 THEN
1855: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
1856: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1857: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1858: FND_MSG_PUB.ADD;
1859: END IF;
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;
1862:

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

1867: IF (l_split_pay_prof = 'Y') THEN
1868: IF p_header_payment_tbl.count > 1 THEN
1869: FOR i IN 1..p_header_payment_tbl.count LOOP
1870: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
1871: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1872: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
1873: FND_MSG_PUB.ADD;
1874: END IF;
1875: RAISE FND_API.G_EXC_ERROR;

Line 1873: FND_MSG_PUB.ADD;

1869: FOR i IN 1..p_header_payment_tbl.count LOOP
1870: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
1871: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1872: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
1873: FND_MSG_PUB.ADD;
1874: END IF;
1875: RAISE FND_API.G_EXC_ERROR;
1876: END IF;
1877: END LOOP;

Line 2062: FND_MSG_PUB.ADD;

2058:
2059: IF SQL%NOTFOUND THEN
2060: aso_debug_pub.add('Create_OrderSQL%NOTFOUND ASO_API_QUOTE_ORDER_PROGRESS ');
2061: FND_MESSAGE.Set_Name('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: End if;
2065: End If;
2066:

Line 2078: FND_MSG_PUB.ADD;

2074:
2075: WHEN OTHERS THEN
2076: aso_debug_pub.add('In others ASO_API_QUOTE_ORDER_PROGRESS ');
2077: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: END;
2081: End If; */
2082: --End Fix for Bug bug 12775283

Line 2153: If FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) Then

2149: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
2150: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
2151: End If;
2152:
2153: If FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) Then
2154: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2155: FND_MSG_PUB.ADD;
2156: END If;
2157: RAISE FND_API.G_EXC_ERROR;

Line 2155: FND_MSG_PUB.ADD;

2151: End If;
2152:
2153: If FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) Then
2154: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2155: FND_MSG_PUB.ADD;
2156: END If;
2157: RAISE FND_API.G_EXC_ERROR;
2158: END;
2159:

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

2239:
2240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2241: -- retrieve_oe_messages;
2242: IF x_msg_count > 0 THEN
2243: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2244: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2245: FND_MSG_PUB.ADD;
2246: END IF;
2247: END IF;

Line 2245: FND_MSG_PUB.ADD;

2241: -- retrieve_oe_messages;
2242: IF x_msg_count > 0 THEN
2243: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2244: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2245: FND_MSG_PUB.ADD;
2246: END IF;
2247: END IF;
2248:
2249: retrieve_oe_messages;

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

2261: p_control_rec.book_flag = FND_API.G_TRUE AND
2262: l_action_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS)
2263: THEN
2264: if x_msg_count > 0 then
2265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2266: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2267: FND_MSG_PUB.ADD;
2268: END IF;
2269: end if;

Line 2267: FND_MSG_PUB.ADD;

2263: THEN
2264: if x_msg_count > 0 then
2265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2266: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2267: FND_MSG_PUB.ADD;
2268: END IF;
2269: end if;
2270: retrieve_oe_messages;
2271: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2352: FND_MSG_PUB.Count_And_Get

2348:
2349:
2350:
2351: -- Standard call to get message count and if count is 1, get message info.
2352: FND_MSG_PUB.Count_And_Get
2353: ( p_count => x_msg_count,
2354: p_data => x_msg_data
2355: );
2356:

Line 2363: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2359: null;
2360: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2361: P_API_NAME => L_API_NAME
2362: ,P_PKG_NAME => G_PKG_NAME
2363: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2364: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2365: ,X_MSG_COUNT => X_MSG_COUNT
2366: ,X_MSG_DATA => X_MSG_DATA
2367: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2374: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2370: null;
2371: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2372: P_API_NAME => L_API_NAME
2373: ,P_PKG_NAME => G_PKG_NAME
2374: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2375: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2376: ,X_MSG_COUNT => X_MSG_COUNT
2377: ,X_MSG_DATA => X_MSG_DATA
2378: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2384: FND_MSG_PUB.ADD;

2380: null;
2381: /*** Start : Code change done for Bug 14358079 ***/
2382: IF SQLCODE = -54 THEN
2383: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2384: FND_MSG_PUB.ADD;
2385: RAISE FND_API.G_EXC_ERROR;
2386: -- X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2387: END IF;
2388: /*** End : Code change done for Bug 14358079 ***/

Line 2393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2389:
2390: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2391: P_API_NAME => L_API_NAME
2392: ,P_PKG_NAME => G_PKG_NAME
2393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2394: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2395: ,X_MSG_COUNT => X_MSG_COUNT
2396: ,X_MSG_DATA => X_MSG_DATA
2397: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2574: FND_MSG_PUB.initialize;

2570:
2571: -- Initialize message list if p_init_msg_list is set to TRUE.
2572: IF FND_API.to_Boolean( p_init_msg_list )
2573: THEN
2574: FND_MSG_PUB.initialize;
2575: END IF;
2576:
2577: -- Debug Message
2578: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

Line 2578: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

2574: FND_MSG_PUB.initialize;
2575: END IF;
2576:
2577: -- Debug Message
2578: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
2579:
2580: -- Initialize API return status to SUCCESS
2581: x_return_status := FND_API.G_RET_STS_SUCCESS;
2582:

Line 2592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2588: -- Validate Environment
2589: -- ******************************************************************
2590: IF FND_GLOBAL.User_Id IS NULL
2591: THEN
2592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2593: THEN
2594: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2595: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2596: FND_MSG_PUB.ADD;

Line 2596: FND_MSG_PUB.ADD;

2592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2593: THEN
2594: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2595: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2596: FND_MSG_PUB.ADD;
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;
2600:

Line 2614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2610:
2611: IF p_qte_rec.order_id is null OR
2612: p_qte_rec.order_id = FND_API.G_MISS_NUM THEN
2613:
2614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2615: THEN
2616: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2617: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_ID', FALSE);
2618: FND_MSG_PUB.ADD;

Line 2618: FND_MSG_PUB.ADD;

2614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2615: THEN
2616: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2617: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_ID', FALSE);
2618: FND_MSG_PUB.ADD;
2619: END IF;
2620: raise FND_API.G_EXC_ERROR;
2621: END IF;
2622:

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

2625: END IF;
2626:
2627: IF (l_split_pay_prof = 'N') THEN
2628: IF p_header_payment_tbl.count > 1 THEN
2629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2630: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2631: FND_MSG_PUB.ADD;
2632: END IF;
2633: RAISE FND_API.G_EXC_ERROR;

Line 2631: FND_MSG_PUB.ADD;

2627: IF (l_split_pay_prof = 'N') THEN
2628: IF p_header_payment_tbl.count > 1 THEN
2629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2630: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2631: FND_MSG_PUB.ADD;
2632: END IF;
2633: RAISE FND_API.G_EXC_ERROR;
2634: ELSIF p_header_payment_tbl.count = 1 THEN
2635: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN

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

2632: END IF;
2633: RAISE FND_API.G_EXC_ERROR;
2634: ELSIF p_header_payment_tbl.count = 1 THEN
2635: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
2636: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2637: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2638: FND_MSG_PUB.ADD;
2639: END IF;
2640: RAISE FND_API.G_EXC_ERROR;

Line 2638: FND_MSG_PUB.ADD;

2634: ELSIF p_header_payment_tbl.count = 1 THEN
2635: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
2636: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2637: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2638: FND_MSG_PUB.ADD;
2639: END IF;
2640: RAISE FND_API.G_EXC_ERROR;
2641: END IF;
2642:

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

2646: IF (l_split_pay_prof = 'Y') THEN
2647: IF p_header_payment_tbl.count > 1 THEN
2648: FOR i IN 1..p_header_payment_tbl.count LOOP
2649: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
2650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2651: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
2652: FND_MSG_PUB.ADD;
2653: END IF;
2654: RAISE FND_API.G_EXC_ERROR;

Line 2652: FND_MSG_PUB.ADD;

2648: FOR i IN 1..p_header_payment_tbl.count LOOP
2649: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
2650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2651: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
2652: FND_MSG_PUB.ADD;
2653: END IF;
2654: RAISE FND_API.G_EXC_ERROR;
2655: END IF;
2656: END LOOP;

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

2888: END IF;
2889:
2890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2891: IF x_msg_count > 0 THEN
2892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2893: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2894: FND_MSG_PUB.ADD;
2895: END IF;
2896: END IF;

Line 2894: FND_MSG_PUB.ADD;

2890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2891: IF x_msg_count > 0 THEN
2892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2893: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2894: FND_MSG_PUB.ADD;
2895: END IF;
2896: END IF;
2897:
2898: retrieve_oe_messages;

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

2908: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
2909: p_control_rec.book_flag = FND_API.G_TRUE AND
2910: l_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2911: if x_msg_count > 0 then
2912: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2913: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2914: FND_MSG_PUB.ADD;
2915: END IF;
2916: end if;

Line 2914: FND_MSG_PUB.ADD;

2910: l_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2911: if x_msg_count > 0 then
2912: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2913: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2914: FND_MSG_PUB.ADD;
2915: END IF;
2916: end if;
2917: retrieve_oe_messages;
2918: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2951: FND_MSG_PUB.Count_And_Get

2947:
2948:
2949:
2950: -- Standard call to get message count and if count is 1, get message info.
2951: FND_MSG_PUB.Count_And_Get
2952: ( p_count => x_msg_count,
2953: p_data => x_msg_data
2954: );
2955:

Line 2962: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2958: null;
2959: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2960: P_API_NAME => L_API_NAME
2961: ,P_PKG_NAME => G_PKG_NAME
2962: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2963: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2964: ,X_MSG_COUNT => X_MSG_COUNT
2965: ,X_MSG_DATA => X_MSG_DATA
2966: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2973: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2969: null;
2970: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2971: P_API_NAME => L_API_NAME
2972: ,P_PKG_NAME => G_PKG_NAME
2973: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2974: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2975: ,X_MSG_COUNT => X_MSG_COUNT
2976: ,X_MSG_DATA => X_MSG_DATA
2977: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2979: null;
2980: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2981: P_API_NAME => L_API_NAME
2982: ,P_PKG_NAME => G_PKG_NAME
2983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2984: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2985: ,X_MSG_COUNT => X_MSG_COUNT
2986: ,X_MSG_DATA => X_MSG_DATA
2987: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3435: FND_MSG_PUB.ADD;

3431:
3432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3433: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
3434: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3435: FND_MSG_PUB.ADD;
3436: raise FND_API.G_EXC_ERROR;
3437: END IF;
3438:
3439: IF lx_cust_id IS NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN

Line 3452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3448: ,x_acct_id => lx_cust_account_id
3449: );
3450:
3451: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3453: THEN
3454: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3455: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3456: FND_MSG_PUB.ADD;

Line 3456: FND_MSG_PUB.ADD;

3452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3453: THEN
3454: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3455: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3456: FND_MSG_PUB.ADD;
3457: END IF;
3458: raise FND_API.G_EXC_ERROR;
3459: END IF;
3460: