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 1776: FND_MSG_PUB.initialize;

1772:
1773: -- Initialize message list if p_init_msg_list is set to TRUE.
1774: IF FND_API.to_Boolean( p_init_msg_list )
1775: THEN
1776: FND_MSG_PUB.initialize;
1777: END IF;
1778:
1779: -- Debug Message
1780: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

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

1776: FND_MSG_PUB.initialize;
1777: END IF;
1778:
1779: -- Debug Message
1780: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1781:
1782: -- Initialize API return status to SUCCESS
1783: x_return_status := FND_API.G_RET_STS_SUCCESS;
1784:

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

1790: -- Validate Environment
1791: -- ******************************************************************
1792: IF FND_GLOBAL.User_Id IS NULL
1793: THEN
1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1795: THEN
1796: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1797: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1798: FND_MSG_PUB.ADD;

Line 1798: FND_MSG_PUB.ADD;

1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1795: THEN
1796: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1797: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1798: FND_MSG_PUB.ADD;
1799: END IF;
1800: RAISE FND_API.G_EXC_ERROR;
1801: END IF;
1802: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1816: END IF;
1817:
1818: IF (l_split_pay_prof = 'N') THEN
1819: IF p_header_payment_tbl.count > 1 THEN
1820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1821: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1822: FND_MSG_PUB.ADD;
1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR;

Line 1822: FND_MSG_PUB.ADD;

1818: IF (l_split_pay_prof = 'N') THEN
1819: IF p_header_payment_tbl.count > 1 THEN
1820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1821: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1822: FND_MSG_PUB.ADD;
1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR;
1825: ELSIF p_header_payment_tbl.count = 1 THEN
1826: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN

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

1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR;
1825: ELSIF p_header_payment_tbl.count = 1 THEN
1826: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
1827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1828: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1829: FND_MSG_PUB.ADD;
1830: END IF;
1831: RAISE FND_API.G_EXC_ERROR;

Line 1829: FND_MSG_PUB.ADD;

1825: ELSIF p_header_payment_tbl.count = 1 THEN
1826: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
1827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1828: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1829: FND_MSG_PUB.ADD;
1830: END IF;
1831: RAISE FND_API.G_EXC_ERROR;
1832: END IF;
1833:

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

1838: IF (l_split_pay_prof = 'Y') THEN
1839: IF p_header_payment_tbl.count > 1 THEN
1840: FOR i IN 1..p_header_payment_tbl.count LOOP
1841: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
1842: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1843: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
1844: FND_MSG_PUB.ADD;
1845: END IF;
1846: RAISE FND_API.G_EXC_ERROR;

Line 1844: FND_MSG_PUB.ADD;

1840: FOR i IN 1..p_header_payment_tbl.count LOOP
1841: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
1842: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1843: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
1844: FND_MSG_PUB.ADD;
1845: END IF;
1846: RAISE FND_API.G_EXC_ERROR;
1847: END IF;
1848: END LOOP;

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

2084:
2085: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2086: -- retrieve_oe_messages;
2087: IF x_msg_count > 0 THEN
2088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2089: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2090: FND_MSG_PUB.ADD;
2091: END IF;
2092: END IF;

Line 2090: FND_MSG_PUB.ADD;

2086: -- retrieve_oe_messages;
2087: IF x_msg_count > 0 THEN
2088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2089: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2090: FND_MSG_PUB.ADD;
2091: END IF;
2092: END IF;
2093:
2094: retrieve_oe_messages;

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

2106: p_control_rec.book_flag = FND_API.G_TRUE AND
2107: l_action_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS)
2108: THEN
2109: if x_msg_count > 0 then
2110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2111: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2112: FND_MSG_PUB.ADD;
2113: END IF;
2114: end if;

Line 2112: FND_MSG_PUB.ADD;

2108: THEN
2109: if x_msg_count > 0 then
2110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2111: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2112: FND_MSG_PUB.ADD;
2113: END IF;
2114: end if;
2115: retrieve_oe_messages;
2116: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2197: FND_MSG_PUB.Count_And_Get

2193:
2194:
2195:
2196: -- Standard call to get message count and if count is 1, get message info.
2197: FND_MSG_PUB.Count_And_Get
2198: ( p_count => x_msg_count,
2199: p_data => x_msg_data
2200: );
2201:

Line 2208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2204: null;
2205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2206: P_API_NAME => L_API_NAME
2207: ,P_PKG_NAME => G_PKG_NAME
2208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2209: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2210: ,X_MSG_COUNT => X_MSG_COUNT
2211: ,X_MSG_DATA => X_MSG_DATA
2212: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2215: null;
2216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2217: P_API_NAME => L_API_NAME
2218: ,P_PKG_NAME => G_PKG_NAME
2219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2221: ,X_MSG_COUNT => X_MSG_COUNT
2222: ,X_MSG_DATA => X_MSG_DATA
2223: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2225: null;
2226: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2227: P_API_NAME => L_API_NAME
2228: ,P_PKG_NAME => G_PKG_NAME
2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2230: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2231: ,X_MSG_COUNT => X_MSG_COUNT
2232: ,X_MSG_DATA => X_MSG_DATA
2233: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2410: FND_MSG_PUB.initialize;

2406:
2407: -- Initialize message list if p_init_msg_list is set to TRUE.
2408: IF FND_API.to_Boolean( p_init_msg_list )
2409: THEN
2410: FND_MSG_PUB.initialize;
2411: END IF;
2412:
2413: -- Debug Message
2414: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

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

2410: FND_MSG_PUB.initialize;
2411: END IF;
2412:
2413: -- Debug Message
2414: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
2415:
2416: -- Initialize API return status to SUCCESS
2417: x_return_status := FND_API.G_RET_STS_SUCCESS;
2418:

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

2424: -- Validate Environment
2425: -- ******************************************************************
2426: IF FND_GLOBAL.User_Id IS NULL
2427: THEN
2428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2429: THEN
2430: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2431: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2432: FND_MSG_PUB.ADD;

Line 2432: FND_MSG_PUB.ADD;

2428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2429: THEN
2430: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2431: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2432: FND_MSG_PUB.ADD;
2433: END IF;
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;
2436:

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

2446:
2447: IF p_qte_rec.order_id is null OR
2448: p_qte_rec.order_id = FND_API.G_MISS_NUM THEN
2449:
2450: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2451: THEN
2452: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2453: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_ID', FALSE);
2454: FND_MSG_PUB.ADD;

Line 2454: FND_MSG_PUB.ADD;

2450: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2451: THEN
2452: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2453: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_ID', FALSE);
2454: FND_MSG_PUB.ADD;
2455: END IF;
2456: raise FND_API.G_EXC_ERROR;
2457: END IF;
2458:

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

2461: END IF;
2462:
2463: IF (l_split_pay_prof = 'N') THEN
2464: IF p_header_payment_tbl.count > 1 THEN
2465: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2466: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2467: FND_MSG_PUB.ADD;
2468: END IF;
2469: RAISE FND_API.G_EXC_ERROR;

Line 2467: FND_MSG_PUB.ADD;

2463: IF (l_split_pay_prof = 'N') THEN
2464: IF p_header_payment_tbl.count > 1 THEN
2465: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2466: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2467: FND_MSG_PUB.ADD;
2468: END IF;
2469: RAISE FND_API.G_EXC_ERROR;
2470: ELSIF p_header_payment_tbl.count = 1 THEN
2471: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN

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

2468: END IF;
2469: RAISE FND_API.G_EXC_ERROR;
2470: ELSIF p_header_payment_tbl.count = 1 THEN
2471: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
2472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2473: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2474: FND_MSG_PUB.ADD;
2475: END IF;
2476: RAISE FND_API.G_EXC_ERROR;

Line 2474: FND_MSG_PUB.ADD;

2470: ELSIF p_header_payment_tbl.count = 1 THEN
2471: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
2472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2473: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2474: FND_MSG_PUB.ADD;
2475: END IF;
2476: RAISE FND_API.G_EXC_ERROR;
2477: END IF;
2478:

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

2482: IF (l_split_pay_prof = 'Y') THEN
2483: IF p_header_payment_tbl.count > 1 THEN
2484: FOR i IN 1..p_header_payment_tbl.count LOOP
2485: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
2486: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2487: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
2488: FND_MSG_PUB.ADD;
2489: END IF;
2490: RAISE FND_API.G_EXC_ERROR;

Line 2488: FND_MSG_PUB.ADD;

2484: FOR i IN 1..p_header_payment_tbl.count LOOP
2485: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
2486: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2487: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
2488: FND_MSG_PUB.ADD;
2489: END IF;
2490: RAISE FND_API.G_EXC_ERROR;
2491: END IF;
2492: END LOOP;

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

2722: END IF;
2723:
2724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2725: IF x_msg_count > 0 THEN
2726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2727: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2728: FND_MSG_PUB.ADD;
2729: END IF;
2730: END IF;

Line 2728: FND_MSG_PUB.ADD;

2724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2725: IF x_msg_count > 0 THEN
2726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2727: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2728: FND_MSG_PUB.ADD;
2729: END IF;
2730: END IF;
2731:
2732: retrieve_oe_messages;

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

2742: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
2743: p_control_rec.book_flag = FND_API.G_TRUE AND
2744: l_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2745: if x_msg_count > 0 then
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2747: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2748: FND_MSG_PUB.ADD;
2749: END IF;
2750: end if;

Line 2748: FND_MSG_PUB.ADD;

2744: l_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2745: if x_msg_count > 0 then
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2747: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2748: FND_MSG_PUB.ADD;
2749: END IF;
2750: end if;
2751: retrieve_oe_messages;
2752: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2785: FND_MSG_PUB.Count_And_Get

2781:
2782:
2783:
2784: -- Standard call to get message count and if count is 1, get message info.
2785: FND_MSG_PUB.Count_And_Get
2786: ( p_count => x_msg_count,
2787: p_data => x_msg_data
2788: );
2789:

Line 2796: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2792: null;
2793: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2794: P_API_NAME => L_API_NAME
2795: ,P_PKG_NAME => G_PKG_NAME
2796: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2797: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2798: ,X_MSG_COUNT => X_MSG_COUNT
2799: ,X_MSG_DATA => X_MSG_DATA
2800: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2807: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2803: null;
2804: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2805: P_API_NAME => L_API_NAME
2806: ,P_PKG_NAME => G_PKG_NAME
2807: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2808: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2809: ,X_MSG_COUNT => X_MSG_COUNT
2810: ,X_MSG_DATA => X_MSG_DATA
2811: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2817: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2813: null;
2814: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2815: P_API_NAME => L_API_NAME
2816: ,P_PKG_NAME => G_PKG_NAME
2817: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2818: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2819: ,X_MSG_COUNT => X_MSG_COUNT
2820: ,X_MSG_DATA => X_MSG_DATA
2821: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3269: FND_MSG_PUB.ADD;

3265:
3266: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3267: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
3268: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3269: FND_MSG_PUB.ADD;
3270: raise FND_API.G_EXC_ERROR;
3271: END IF;
3272:
3273: IF lx_cust_id IS NULL OR lx_cust_id = FND_API.G_MISS_NUM THEN

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

3282: ,x_acct_id => lx_cust_account_id
3283: );
3284:
3285: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3287: THEN
3288: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3289: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3290: FND_MSG_PUB.ADD;

Line 3290: FND_MSG_PUB.ADD;

3286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3287: THEN
3288: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3289: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3290: FND_MSG_PUB.ADD;
3291: END IF;
3292: raise FND_API.G_EXC_ERROR;
3293: END IF;
3294: