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_QUOTE_PUB dependencies on FND_MSG_PUB

Line 40: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,

36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: IF (p_party_id IS NOT NULL
38: AND p_party_id <> FND_API.G_MISS_NUM) THEN
39: ASO_UTILITY_PVT.Set_Message(
40: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
41: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
42: p_token1 => 'COLUMN',
43: p_token1_value => p_column_name);
44: ELSIF (p_person_first_name <> FND_API.G_MISS_CHAR

Line 94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,

90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: IF (p_party_site_id IS NOT NULL
92: AND p_party_site_id <> FND_API.G_MISS_NUM) THEN
93: ASO_UTILITY_PVT.Set_Message(
94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
95: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
96: p_token1 => 'COLUMN',
97: p_token1_value => p_column_name);
98: ELSIF (p_address1 <> FND_API.G_MISS_CHAR AND

Line 520: FND_MSG_PUB.initialize;

516: END IF;
517:
518: -- Initialize message list if p_init_msg_list is set to TRUE.
519: IF FND_API.to_Boolean( p_init_msg_list ) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:
523: -- Initialize API return status to SUCCESS
524: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

538: X_Msg_Data => x_msg_data );
539:
540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541:
542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
543: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
544: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_PRE', FALSE);
545: FND_MSG_PUB.ADD;
546: END IF;

Line 545: FND_MSG_PUB.ADD;

541:
542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
543: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
544: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_PRE', FALSE);
545: FND_MSG_PUB.ADD;
546: END IF;
547:
548: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

564: x_Msg_Data => x_msg_data );
565:
566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
567:
568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
569: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
570: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_PRE', FALSE);
571: FND_MSG_PUB.ADD;
572: END IF;

Line 571: FND_MSG_PUB.ADD;

567:
568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
569: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
570: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_PRE', FALSE);
571: FND_MSG_PUB.ADD;
572: END IF;
573:
574: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

604: X_Msg_Data => x_msg_data );
605:
606: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
607:
608: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
609: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
610: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_POST', FALSE);
611: FND_MSG_PUB.ADD;
612: END IF;

Line 611: FND_MSG_PUB.ADD;

607:
608: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
609: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
610: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_POST', FALSE);
611: FND_MSG_PUB.ADD;
612: END IF;
613:
614: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

630: X_Msg_Data => x_msg_data );
631:
632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
633:
634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
635: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_POST', FALSE);
637: FND_MSG_PUB.ADD;
638: END IF;

Line 637: FND_MSG_PUB.ADD;

633:
634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
635: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_POST', FALSE);
637: FND_MSG_PUB.ADD;
638: END IF;
639:
640: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 660: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

656: COMMIT WORK;
657: END IF;
658:
659: -- Standard call to get message count and if count is 1, get message info.
660: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
661: p_data => x_msg_data );
662:
663: EXCEPTION
664:

Line 670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

666:
667: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
668: P_API_NAME => L_API_NAME
669: ,P_PKG_NAME => G_PKG_NAME
670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
671: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
672: ,X_MSG_COUNT => X_MSG_COUNT
673: ,X_MSG_DATA => X_MSG_DATA
674: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 681: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

677:
678: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
679: P_API_NAME => L_API_NAME
680: ,P_PKG_NAME => G_PKG_NAME
681: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
682: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
683: ,X_MSG_COUNT => X_MSG_COUNT
684: ,X_MSG_DATA => X_MSG_DATA
685: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 743: FND_MSG_PUB.initialize;

739:
740: -- Initialize message list if p_init_msg_list is set to TRUE.
741: IF FND_API.to_Boolean( p_init_msg_list )
742: THEN
743: FND_MSG_PUB.initialize;
744: END IF;
745:
746:
747:

Line 789: FND_MSG_PUB.Count_And_Get

785:
786:
787:
788: -- Standard call to get message count and if count is 1, get message info.
789: FND_MSG_PUB.Count_And_Get
790: ( p_count => x_msg_count,
791: p_data => x_msg_data
792: );
793:

Line 799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

795: WHEN FND_API.G_EXC_ERROR THEN
796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
797: P_API_NAME => L_API_NAME
798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
800: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
801: ,X_MSG_COUNT => X_MSG_COUNT
802: ,X_MSG_DATA => X_MSG_DATA
803: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
807: P_API_NAME => L_API_NAME
808: ,P_PKG_NAME => G_PKG_NAME
809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
810: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
811: ,X_MSG_COUNT => X_MSG_COUNT
812: ,X_MSG_DATA => X_MSG_DATA
813: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 856: FND_MSG_PUB.initialize;

852:
853: -- Initialize message list if p_init_msg_list is set to TRUE.
854: IF FND_API.to_Boolean( p_init_msg_list )
855: THEN
856: FND_MSG_PUB.initialize;
857: END IF;
858:
859:
860:

Line 892: FND_MSG_PUB.Count_And_Get

888:
889:
890:
891: -- Standard call to get message count and if count is 1, get message info.
892: FND_MSG_PUB.Count_And_Get
893: ( p_count => x_msg_count,
894: p_data => x_msg_data
895: );
896:

Line 902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

898: WHEN FND_API.G_EXC_ERROR THEN
899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 912: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
910: P_API_NAME => L_API_NAME
911: ,P_PKG_NAME => G_PKG_NAME
912: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
913: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
914: ,X_MSG_COUNT => X_MSG_COUNT
915: ,X_MSG_DATA => X_MSG_DATA
916: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 965: FND_MSG_PUB.initialize;

961:
962: -- Initialize message list if p_init_msg_list is set to TRUE.
963: IF FND_API.to_Boolean( p_init_msg_list )
964: THEN
965: FND_MSG_PUB.initialize;
966: END IF;
967:
968:
969:

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

983: X_Return_Status => X_Return_Status,
984: X_Msg_Count => X_Msg_Count,
985: X_Msg_Data => X_Msg_Data );
986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
988: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
989: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
990: FND_MSG_PUB.ADD;
991: END IF;

Line 990: FND_MSG_PUB.ADD;

986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
988: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
989: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
990: FND_MSG_PUB.ADD;
991: END IF;
992: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1004: X_Return_Status => X_Return_Status,
1005: X_Msg_Count => X_Msg_Count,
1006: X_Msg_Data => X_Msg_Data );
1007: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1009: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1010: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
1011: FND_MSG_PUB.ADD;
1012: END IF;

Line 1011: FND_MSG_PUB.ADD;

1007: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1009: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1010: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
1011: FND_MSG_PUB.ADD;
1012: END IF;
1013: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1050: X_Msg_Count => X_Msg_Count,
1051: X_Msg_Data => X_Msg_Data );
1052:
1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1056: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
1057: FND_MSG_PUB.ADD;
1058: END IF;

Line 1057: FND_MSG_PUB.ADD;

1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1056: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
1057: FND_MSG_PUB.ADD;
1058: END IF;
1059: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1072: X_Return_Status => X_Return_Status,
1073: X_Msg_Count => X_Msg_Count,
1074: X_Msg_Data => X_Msg_Data );
1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1077: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1078: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
1079: FND_MSG_PUB.ADD;
1080: END IF;

Line 1079: FND_MSG_PUB.ADD;

1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1077: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1078: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
1079: FND_MSG_PUB.ADD;
1080: END IF;
1081: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1096: FND_MSG_PUB.Count_And_Get

1092:
1093:
1094:
1095: -- Standard call to get message count and if count is 1, get message info.
1096: FND_MSG_PUB.Count_And_Get
1097: ( p_count => x_msg_count,
1098: p_data => x_msg_data
1099: );
1100:

Line 1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1102: WHEN FND_API.G_EXC_ERROR THEN
1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME
1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1108: ,X_MSG_COUNT => X_MSG_COUNT
1109: ,X_MSG_DATA => X_MSG_DATA
1110: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1116: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1114: P_API_NAME => L_API_NAME
1115: ,P_PKG_NAME => G_PKG_NAME
1116: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1117: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1118: ,X_MSG_COUNT => X_MSG_COUNT
1119: ,X_MSG_DATA => X_MSG_DATA
1120: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1179: FND_MSG_PUB.initialize;

1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.
1177: IF FND_API.to_Boolean( p_init_msg_list )
1178: THEN
1179: FND_MSG_PUB.initialize;
1180: END IF;
1181:
1182:
1183:

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

1209: X_Msg_Count => X_Msg_Count,
1210: X_Msg_Data => X_Msg_Data
1211: );
1212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1214: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1215: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_PRE', FALSE);
1216: FND_MSG_PUB.ADD;
1217: END IF;

Line 1216: FND_MSG_PUB.ADD;

1212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1214: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1215: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_PRE', FALSE);
1216: FND_MSG_PUB.ADD;
1217: END IF;
1218: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1235: X_Msg_Count => X_Msg_Count,
1236: X_Msg_Data => X_Msg_Data
1237: );
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1240: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1241: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_PRE', FALSE);
1242: FND_MSG_PUB.ADD;
1243: END IF;

Line 1242: FND_MSG_PUB.ADD;

1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1240: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1241: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_PRE', FALSE);
1242: FND_MSG_PUB.ADD;
1243: END IF;
1244: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1290: X_Msg_Count => X_Msg_Count,
1291: X_Msg_Data => X_Msg_Data
1292: );
1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1296: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_POST', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;

Line 1297: FND_MSG_PUB.ADD;

1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1296: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_POST', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;
1299: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1316: X_Msg_Count => X_Msg_Count,
1317: X_Msg_Data => X_Msg_Data
1318: );
1319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1320: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1321: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1322: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_POST', FALSE);
1323: FND_MSG_PUB.ADD;
1324: END IF;

Line 1323: FND_MSG_PUB.ADD;

1319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1320: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1321: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1322: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_POST', FALSE);
1323: FND_MSG_PUB.ADD;
1324: END IF;
1325: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1346: FND_MSG_PUB.Count_And_Get

1342:
1343:
1344:
1345: -- Standard call to get message count and if count is 1, get message info.
1346: FND_MSG_PUB.Count_And_Get
1347: ( p_count => x_msg_count,
1348: p_data => x_msg_data
1349: );
1350:

Line 1356: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1352: WHEN FND_API.G_EXC_ERROR THEN
1353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1354: P_API_NAME => L_API_NAME
1355: ,P_PKG_NAME => G_PKG_NAME
1356: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1357: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1358: ,X_MSG_COUNT => X_MSG_COUNT
1359: ,X_MSG_DATA => X_MSG_DATA
1360: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1364: P_API_NAME => L_API_NAME
1365: ,P_PKG_NAME => G_PKG_NAME
1366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1367: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1368: ,X_MSG_COUNT => X_MSG_COUNT
1369: ,X_MSG_DATA => X_MSG_DATA
1370: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2153: FND_MSG_PUB.initialize;

2149:
2150: -- Initialize message list if p_init_msg_list is set to TRUE.
2151: IF FND_API.to_Boolean( p_init_msg_list )
2152: THEN
2153: FND_MSG_PUB.initialize;
2154: END IF;
2155:
2156:
2157:

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

2207: X_Msg_Data => x_msg_data
2208: );
2209:
2210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2213: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_PRE', FALSE);
2214: FND_MSG_PUB.ADD;
2215: END IF;

Line 2214: FND_MSG_PUB.ADD;

2210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2213: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_PRE', FALSE);
2214: FND_MSG_PUB.ADD;
2215: END IF;
2216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2244: X_Msg_Data => x_msg_data
2245: );
2246:
2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2249: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2250: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_PRE', FALSE);
2251: FND_MSG_PUB.ADD;
2252: END IF;

Line 2251: FND_MSG_PUB.ADD;

2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2249: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2250: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_PRE', FALSE);
2251: FND_MSG_PUB.ADD;
2252: END IF;
2253: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

2321: raise FND_API.G_EXC_ERROR;
2322: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2326: while (my_message is not null) loop
2327: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2328: end loop;
2329:

Line 2327: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2326: while (my_message is not null) loop
2327: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2328: end loop;
2329:
2330: --
2331: -- End of API body.

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

2357: X_Msg_Data => x_msg_data
2358: );
2359:
2360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2362: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2363: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_POST', FALSE);
2364: FND_MSG_PUB.ADD;
2365: END IF;

Line 2364: FND_MSG_PUB.ADD;

2360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2362: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2363: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_POST', FALSE);
2364: FND_MSG_PUB.ADD;
2365: END IF;
2366: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2405: END IF;
2406:
2407:
2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2409: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2410: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2411: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_POST', FALSE);
2412: FND_MSG_PUB.ADD;
2413: END IF;

Line 2412: FND_MSG_PUB.ADD;

2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2409: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2410: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2411: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_POST', FALSE);
2412: FND_MSG_PUB.ADD;
2413: END IF;
2414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2435: FND_MSG_PUB.Count_And_Get

2431:
2432:
2433:
2434: -- Standard call to get message count and if count is 1, get message info.
2435: FND_MSG_PUB.Count_And_Get
2436: ( p_count => x_msg_count,
2437: p_data => x_msg_data
2438: );
2439:

Line 2445: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2441: WHEN FND_API.G_EXC_ERROR THEN
2442: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2443: P_API_NAME => L_API_NAME
2444: ,P_PKG_NAME => G_PKG_NAME
2445: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2446: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2447: ,P_SQLCODE => SQLCODE
2448: ,P_SQLERRM => SQLERRM
2449: ,X_MSG_COUNT => X_MSG_COUNT

Line 2457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2454: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2455: P_API_NAME => L_API_NAME
2456: ,P_PKG_NAME => G_PKG_NAME
2457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2458: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2459: ,P_SQLCODE => SQLCODE
2460: ,P_SQLERRM => SQLERRM
2461: ,X_MSG_COUNT => X_MSG_COUNT

Line 2573: FND_MSG_PUB.initialize;

2569:
2570: -- Initialize message list if p_init_msg_list is set to TRUE.
2571: IF FND_API.to_Boolean( p_init_msg_list )
2572: THEN
2573: FND_MSG_PUB.initialize;
2574: END IF;
2575:
2576:
2577:

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

2630: X_Msg_Data => x_msg_data
2631: );
2632:
2633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2635: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_PRE', FALSE);
2637: FND_MSG_PUB.ADD;
2638: END IF;

Line 2637: FND_MSG_PUB.ADD;

2633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2635: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_PRE', FALSE);
2637: FND_MSG_PUB.ADD;
2638: END IF;
2639: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2667: X_Msg_Data => x_msg_data
2668: );
2669:
2670: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2671: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2672: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2673: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_PRE', FALSE);
2674: FND_MSG_PUB.ADD;
2675: END IF;

Line 2674: FND_MSG_PUB.ADD;

2670: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2671: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2672: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2673: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_PRE', FALSE);
2674: FND_MSG_PUB.ADD;
2675: END IF;
2676: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2678: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2779: X_Msg_Data => x_msg_data
2780: );
2781:
2782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2783: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2784: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2785: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_POST', FALSE);
2786: FND_MSG_PUB.ADD;
2787: END IF;

Line 2786: FND_MSG_PUB.ADD;

2782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2783: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2784: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2785: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_POST', FALSE);
2786: FND_MSG_PUB.ADD;
2787: END IF;
2788: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2826: aso_debug_pub.add('aso_quote_vuhk: after if update quote line post (1)'||x_return_status,1, 'N');
2827: END IF;
2828:
2829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2830: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2831: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2832: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_POST', FALSE);
2833: FND_MSG_PUB.ADD;
2834: END IF;

Line 2833: FND_MSG_PUB.ADD;

2829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2830: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2831: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2832: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_POST', FALSE);
2833: FND_MSG_PUB.ADD;
2834: END IF;
2835: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2857: FND_MSG_PUB.Count_And_Get

2853:
2854:
2855:
2856: -- Standard call to get message count and if count is 1, get message info.
2857: FND_MSG_PUB.Count_And_Get
2858: ( p_count => x_msg_count,
2859: p_data => x_msg_data
2860: );
2861:

Line 2867: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2863: WHEN FND_API.G_EXC_ERROR THEN
2864: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2865: P_API_NAME => L_API_NAME
2866: ,P_PKG_NAME => G_PKG_NAME
2867: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2868: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2869: ,P_SQLCODE => SQLCODE
2870: ,P_SQLERRM => SQLERRM
2871: ,X_MSG_COUNT => X_MSG_COUNT

Line 2879: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2877: P_API_NAME => L_API_NAME
2878: ,P_PKG_NAME => G_PKG_NAME
2879: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2880: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2881: ,P_SQLCODE => SQLCODE
2882: ,P_SQLERRM => SQLERRM
2883: ,X_MSG_COUNT => X_MSG_COUNT

Line 2938: FND_MSG_PUB.initialize;

2934:
2935: -- Initialize message list if p_init_msg_list is set to TRUE.
2936: IF FND_API.to_Boolean( p_init_msg_list )
2937: THEN
2938: FND_MSG_PUB.initialize;
2939: END IF;
2940:
2941:
2942:

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

2964: X_Msg_Data => x_msg_data
2965: );
2966:
2967: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_PRE', FALSE);
2971: FND_MSG_PUB.ADD;
2972: END IF;

Line 2971: FND_MSG_PUB.ADD;

2967: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_PRE', FALSE);
2971: FND_MSG_PUB.ADD;
2972: END IF;
2973: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2975: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2988: X_Msg_Count => x_msg_count ,
2989: X_Msg_Data => x_msg_data
2990: );
2991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2993: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2994: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_PRE', FALSE);
2995: FND_MSG_PUB.ADD;
2996: END IF;

Line 2995: FND_MSG_PUB.ADD;

2991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2993: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2994: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_PRE', FALSE);
2995: FND_MSG_PUB.ADD;
2996: END IF;
2997: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

3043: X_Msg_Data => x_msg_data
3044: );
3045:
3046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3048: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3049: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_POST', FALSE);
3050: FND_MSG_PUB.ADD;
3051: END IF;

Line 3050: FND_MSG_PUB.ADD;

3046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3048: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3049: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_POST', FALSE);
3050: FND_MSG_PUB.ADD;
3051: END IF;
3052: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

3078: END IF;
3079:
3080:
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3083: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3084: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_POST', FALSE);
3085: FND_MSG_PUB.ADD;
3086: END IF;

Line 3085: FND_MSG_PUB.ADD;

3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3083: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3084: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_POST', FALSE);
3085: FND_MSG_PUB.ADD;
3086: END IF;
3087: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 3110: FND_MSG_PUB.Count_And_Get

3106:
3107:
3108:
3109: -- Standard call to get message count and if count is 1, get message info.
3110: FND_MSG_PUB.Count_And_Get
3111: ( p_count => x_msg_count,
3112: p_data => x_msg_data
3113: );
3114:

Line 3120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3116: WHEN FND_API.G_EXC_ERROR THEN
3117: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3118: P_API_NAME => L_API_NAME
3119: ,P_PKG_NAME => G_PKG_NAME
3120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3121: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3122: ,P_SQLCODE => SQLCODE
3123: ,P_SQLERRM => SQLERRM
3124: ,X_MSG_COUNT => X_MSG_COUNT

Line 3132: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3129: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3130: P_API_NAME => L_API_NAME
3131: ,P_PKG_NAME => G_PKG_NAME
3132: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3133: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3134: ,P_SQLCODE => SQLCODE
3135: ,P_SQLERRM => SQLERRM
3136: ,X_MSG_COUNT => X_MSG_COUNT

Line 3235: FND_MSG_PUB.initialize;

3231:
3232: -- Initialize message list if p_init_msg_list is set to TRUE.
3233: IF FND_API.to_Boolean( p_init_msg_list )
3234: THEN
3235: FND_MSG_PUB.initialize;
3236: END IF;
3237:
3238:
3239: -- Initialize API return status to SUCCESS

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

3253: X_Msg_Count => X_Msg_Count,
3254: X_Msg_Data => X_Msg_Data );
3255:
3256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3258: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3259: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
3260: FND_MSG_PUB.ADD;
3261: END IF;

Line 3260: FND_MSG_PUB.ADD;

3256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3258: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3259: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
3260: FND_MSG_PUB.ADD;
3261: END IF;
3262:
3263: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3278: X_Msg_Count => X_Msg_Count,
3279: X_Msg_Data => X_Msg_Data );
3280:
3281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3283: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3284: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
3285: FND_MSG_PUB.ADD;
3286: END IF;

Line 3285: FND_MSG_PUB.ADD;

3281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3283: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3284: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
3285: FND_MSG_PUB.ADD;
3286: END IF;
3287: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3289: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

3323: X_Msg_Count => X_Msg_Count,
3324: X_Msg_Data => X_Msg_Data );
3325:
3326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3328: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3329: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
3330: FND_MSG_PUB.ADD;
3331: END IF;

Line 3330: FND_MSG_PUB.ADD;

3326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3328: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3329: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
3330: FND_MSG_PUB.ADD;
3331: END IF;
3332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3334: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

3347: X_Msg_Count => X_Msg_Count,
3348: X_Msg_Data => X_Msg_Data );
3349:
3350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3352: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3353: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
3354: FND_MSG_PUB.ADD;
3355: END IF;

Line 3354: FND_MSG_PUB.ADD;

3350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3352: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3353: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
3354: FND_MSG_PUB.ADD;
3355: END IF;
3356: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 3371: FND_MSG_PUB.Count_And_Get

3367:
3368:
3369:
3370: -- Standard call to get message count and if count is 1, get message info.
3371: FND_MSG_PUB.Count_And_Get
3372: ( p_count => x_msg_count,
3373: p_data => x_msg_data
3374: );
3375:

Line 3381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3377: WHEN FND_API.G_EXC_ERROR THEN
3378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3379: P_API_NAME => L_API_NAME
3380: ,P_PKG_NAME => G_PKG_NAME
3381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3382: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3383: ,X_MSG_COUNT => X_MSG_COUNT
3384: ,X_MSG_DATA => X_MSG_DATA
3385: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3389: P_API_NAME => L_API_NAME
3390: ,P_PKG_NAME => G_PKG_NAME
3391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3392: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3393: ,X_MSG_COUNT => X_MSG_COUNT
3394: ,X_MSG_DATA => X_MSG_DATA
3395: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3448: FND_MSG_PUB.initialize;

3444:
3445: -- Initialize message list if p_init_msg_list is set to TRUE.
3446: IF FND_API.to_Boolean( p_init_msg_list )
3447: THEN
3448: FND_MSG_PUB.initialize;
3449: END IF;
3450:
3451: -- Initialize API return status to SUCCESS
3452: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3465: X_Msg_Count => X_Msg_Count,
3466: X_Msg_Data => X_Msg_Data );
3467:
3468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3470: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3471: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_PRE', FALSE);
3472: FND_MSG_PUB.ADD;
3473: END IF;

Line 3472: FND_MSG_PUB.ADD;

3468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3470: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3471: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_PRE', FALSE);
3472: FND_MSG_PUB.ADD;
3473: END IF;
3474:
3475: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3490: X_Msg_Count => X_Msg_Count,
3491: X_Msg_Data => X_Msg_Data );
3492:
3493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3495: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3496: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_PRE', FALSE);
3497: FND_MSG_PUB.ADD;
3498: END IF;

Line 3497: FND_MSG_PUB.ADD;

3493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3495: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3496: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_PRE', FALSE);
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3501: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

3542: X_Msg_Count => X_Msg_Count,
3543: X_Msg_Data => X_Msg_Data );
3544:
3545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3547: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_POST', FALSE);
3549: FND_MSG_PUB.ADD;
3550: END IF;

Line 3549: FND_MSG_PUB.ADD;

3545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3547: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_POST', FALSE);
3549: FND_MSG_PUB.ADD;
3550: END IF;
3551: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

3567: X_Msg_Count => X_Msg_Count,
3568: X_Msg_Data => X_Msg_Data );
3569:
3570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3572: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3573: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_POST', FALSE);
3574: FND_MSG_PUB.ADD;
3575: END IF;

Line 3574: FND_MSG_PUB.ADD;

3570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3572: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3573: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_POST', FALSE);
3574: FND_MSG_PUB.ADD;
3575: END IF;
3576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 3593: FND_MSG_PUB.Count_And_Get

3589: END IF;
3590:
3591:
3592: -- Standard call to get message count and if count is 1, get message info.
3593: FND_MSG_PUB.Count_And_Get
3594: ( p_count => x_msg_count,
3595: p_data => x_msg_data
3596: );
3597:

Line 3604: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

3600: WHEN FND_API.G_EXC_ERROR THEN
3601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3602: P_API_NAME => L_API_NAME,
3603: P_PKG_NAME => G_PKG_NAME,
3604: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
3605: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3606: P_SQLCODE => SQLCODE,
3607: P_SQLERRM => SQLERRM,
3608: X_MSG_COUNT => X_MSG_COUNT,

Line 3617: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

3613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3615: P_API_NAME => L_API_NAME,
3616: P_PKG_NAME => G_PKG_NAME,
3617: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
3618: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3619: P_SQLCODE => SQLCODE,
3620: P_SQLERRM => SQLERRM,
3621: X_MSG_COUNT => X_MSG_COUNT,

Line 3888: FND_MSG_PUB.initialize;

3884: END IF;
3885:
3886: -- Initialize message list if p_init_msg_list is set to TRUE.
3887: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3888: FND_MSG_PUB.initialize;
3889: END IF;
3890:
3891: -- Initialize API return status to SUCCESS
3892: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3968: X_Msg_Data => X_Msg_Data);
3969:
3970: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3971:
3972: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3973: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3974: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_PRE', FALSE);
3975: FND_MSG_PUB.ADD;
3976: END IF;

Line 3975: FND_MSG_PUB.ADD;

3971:
3972: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3973: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3974: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_PRE', FALSE);
3975: FND_MSG_PUB.ADD;
3976: END IF;
3977:
3978: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4024: X_Msg_Data => X_Msg_Data );
4025:
4026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4027:
4028: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4029: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4030: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_PRE', FALSE);
4031: FND_MSG_PUB.ADD;
4032: END IF;

Line 4031: FND_MSG_PUB.ADD;

4027:
4028: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4029: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4030: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_PRE', FALSE);
4031: FND_MSG_PUB.ADD;
4032: END IF;
4033:
4034: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4190: );
4191:
4192: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4193:
4194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4195: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4196: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_POST', FALSE);
4197: FND_MSG_PUB.ADD;
4198: END IF;

Line 4197: FND_MSG_PUB.ADD;

4193:
4194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4195: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4196: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_POST', FALSE);
4197: FND_MSG_PUB.ADD;
4198: END IF;
4199:
4200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4259: END IF;
4260:
4261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4262:
4263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4264: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4265: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_POST', FALSE);
4266: FND_MSG_PUB.ADD;
4267: END IF;

Line 4266: FND_MSG_PUB.ADD;

4262:
4263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4264: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4265: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_POST', FALSE);
4266: FND_MSG_PUB.ADD;
4267: END IF;
4268:
4269: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4285: FND_MSG_PUB.Count_And_Get

4281: COMMIT WORK;
4282: END IF;
4283:
4284: -- Standard call to get message count and if count is 1, get message info.
4285: FND_MSG_PUB.Count_And_Get
4286: ( p_count => x_msg_count,
4287: p_data => x_msg_data
4288: );
4289:

Line 4296: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4292: WHEN FND_API.G_EXC_ERROR THEN
4293: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4294: P_API_NAME => L_API_NAME
4295: ,P_PKG_NAME => G_PKG_NAME
4296: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4297: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4298: ,P_SQLCODE => SQLCODE
4299: ,P_SQLERRM => SQLERRM
4300: ,X_MSG_COUNT => X_MSG_COUNT

Line 4308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4305: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4306: P_API_NAME => L_API_NAME
4307: ,P_PKG_NAME => G_PKG_NAME
4308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4309: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4310: ,P_SQLCODE => SQLCODE
4311: ,P_SQLERRM => SQLERRM
4312: ,X_MSG_COUNT => X_MSG_COUNT

Line 4502: FND_MSG_PUB.initialize;

4498: END IF;
4499:
4500: -- Initialize message list if p_init_msg_list is set to TRUE.
4501: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4502: FND_MSG_PUB.initialize;
4503: END IF;
4504:
4505: -- Initialize API return status to SUCCESS
4506: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4964: END IF;
4965:
4966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_PUB.Create_Quote', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;

Line 4971: FND_MSG_PUB.ADD;

4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_PUB.Create_Quote', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;
4973:
4974: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4989: FND_MSG_PUB.Count_And_Get

4985: COMMIT WORK;
4986: END IF;
4987:
4988: -- Standard call to get message count and if count is 1, get message info.
4989: FND_MSG_PUB.Count_And_Get
4990: ( p_count => x_msg_count,
4991: p_data => x_msg_data
4992: );
4993:

Line 5000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4996: WHEN FND_API.G_EXC_ERROR THEN
4997: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4998: P_API_NAME => L_API_NAME
4999: ,P_PKG_NAME => G_PKG_NAME
5000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5001: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5002: ,P_SQLCODE => SQLCODE
5003: ,P_SQLERRM => SQLERRM
5004: ,X_MSG_COUNT => X_MSG_COUNT

Line 5012: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5009: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5010: P_API_NAME => L_API_NAME
5011: ,P_PKG_NAME => G_PKG_NAME
5012: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5013: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5014: ,P_SQLCODE => SQLCODE
5015: ,P_SQLERRM => SQLERRM
5016: ,X_MSG_COUNT => X_MSG_COUNT

Line 5164: FND_MSG_PUB.initialize;

5160: END IF;
5161:
5162: -- Initialize message list if p_init_msg_list is set to TRUE.
5163: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5164: FND_MSG_PUB.initialize;
5165: END IF;
5166:
5167: -- Initialize API return status to SUCCESS
5168: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5254: );
5255:
5256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5257:
5258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5259: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5260: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);
5261: FND_MSG_PUB.ADD;
5262: END IF;

Line 5261: FND_MSG_PUB.ADD;

5257:
5258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5259: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5260: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);
5261: FND_MSG_PUB.ADD;
5262: END IF;
5263:
5264: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5311: );
5312:
5313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5314:
5315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5316: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5317: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);
5318: FND_MSG_PUB.ADD;
5319: END IF;

Line 5318: FND_MSG_PUB.ADD;

5314:
5315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5316: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5317: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);
5318: FND_MSG_PUB.ADD;
5319: END IF;
5320:
5321: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5474: );
5475:
5476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5477:
5478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5480: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);
5481: FND_MSG_PUB.ADD;
5482: END IF;

Line 5481: FND_MSG_PUB.ADD;

5477:
5478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5480: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);
5481: FND_MSG_PUB.ADD;
5482: END IF;
5483:
5484: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5542: END IF;
5543:
5544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5545:
5546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5547: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);
5549: FND_MSG_PUB.ADD;
5550: END IF;

Line 5549: FND_MSG_PUB.ADD;

5545:
5546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5547: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);
5549: FND_MSG_PUB.ADD;
5550: END IF;
5551:
5552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

5568: COMMIT WORK;
5569: END IF;
5570:
5571: -- Standard call to get message count and if count is 1, get message info.
5572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5573: p_data => x_msg_data );
5574:
5575:
5576: EXCEPTION

Line 5582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5578: WHEN FND_API.G_EXC_ERROR THEN
5579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5580: P_API_NAME => L_API_NAME
5581: ,P_PKG_NAME => G_PKG_NAME
5582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5583: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5584: ,P_SQLCODE => SQLCODE
5585: ,P_SQLERRM => SQLERRM
5586: ,X_MSG_COUNT => X_MSG_COUNT

Line 5594: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5591: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5592: P_API_NAME => L_API_NAME
5593: ,P_PKG_NAME => G_PKG_NAME
5594: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5595: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5596: ,P_SQLCODE => SQLCODE
5597: ,P_SQLERRM => SQLERRM
5598: ,X_MSG_COUNT => X_MSG_COUNT

Line 5699: FND_MSG_PUB.initialize;

5695: l_api_name := 'VALIDATE_MODEL_CFG'; -- Added for Bug 12679929
5696:
5697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5698: aso_debug_pub.add('ASO_QUOTE_PUB: p_init_msg_list true', 1, 'Y');
5699: FND_MSG_PUB.initialize;
5700: END IF;
5701:
5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');

Line 5754: FND_MSG_PUB.ADD;

5750: Catherine will do this check in UI.
5751:
5752: IF nvl(l_model_qte_line_tbl.count,0) = 0 THEN
5753: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_MODEL_LINE_QUOTE');
5754: FND_MSG_PUB.ADD;
5755: RAISE EXCP_USER_DEFINED;
5756: ELSE
5757: */
5758:

Line 5789: /*FND_MSG_PUB.Count_And_Get

5785: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5786: aso_debug_pub.add('ASO_QUOTE_PUB : Before call to ASO_BATCH_VALIDATE_CFG_PVT.Validate_Configuration'|| l_model_qte_line_tbl(i).quote_line_id,1,'N');
5787: END IF;
5788:
5789: /*FND_MSG_PUB.Count_And_Get
5790: ( p_encoded => 'F',
5791: p_count => x_msg_count,
5792: p_data => x_msg_data
5793: );

Line 5794: x_msg_data := fnd_msg_pub.get( p_msg_index => 1, p_encoded => 'F');

5790: ( p_encoded => 'F',
5791: p_count => x_msg_count,
5792: p_data => x_msg_data
5793: );
5794: x_msg_data := fnd_msg_pub.get( p_msg_index => 1, p_encoded => 'F');
5795: */
5796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5798: -- aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_count, 1, 'Y');

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

5887: END IF;
5888:
5889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5890:
5891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5892: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
5893: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
5894: FND_MSG_PUB.ADD;
5895: END IF;

Line 5894: FND_MSG_PUB.ADD;

5890:
5891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5892: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
5893: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
5894: FND_MSG_PUB.ADD;
5895: END IF;
5896:
5897: RAISE FND_API.G_EXC_ERROR;
5898:

Line 5992: FND_MSG_PUB.ADD;

5988: END LOOP;
5989: /*
5990: If l_changed_model_line_num is Null AND l_invalid_model_line_num is Null then
5991: FND_MESSAGE.Set_Name('ASO', 'ASO_MODEL_LINES_VALID_NOCHANGE');
5992: FND_MSG_PUB.ADD;
5993: End if;
5994: */
5995:
5996: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6002: FND_MSG_PUB.ADD;

5998: END IF;
5999:
6000: If l_changed_model_line_num is Not Null OR l_invalid_model_line_num is Not Null then
6001: FND_MESSAGE.Set_Name('ASO', 'ASO_MODEL_LINES_VALID_NOCHANGE');
6002: FND_MSG_PUB.ADD;
6003: End if;
6004:
6005: If l_changed_model_line_num is Not Null and P_UPDATE_QUOTE = 'T' then
6006: FND_MESSAGE.Set_Name('ASO', 'ASO_CHANGED_MODEL_LINES_QUOTE');

Line 6008: FND_MSG_PUB.ADD;

6004:
6005: If l_changed_model_line_num is Not Null and P_UPDATE_QUOTE = 'T' then
6006: FND_MESSAGE.Set_Name('ASO', 'ASO_CHANGED_MODEL_LINES_QUOTE');
6007: FND_MESSAGE.Set_Token('CHANGED_MODEL_LINE_NUM', l_changed_model_line_num, FALSE);
6008: FND_MSG_PUB.ADD;
6009: Elsif l_changed_model_line_num is Not Null and P_UPDATE_QUOTE = 'F' then
6010: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_MODEL_LINES_QUOTE');
6011: FND_MESSAGE.Set_Token('CHANGED_MODEL_LINE_NUM', l_changed_model_line_num, FALSE);
6012: FND_MSG_PUB.ADD;

Line 6012: FND_MSG_PUB.ADD;

6008: FND_MSG_PUB.ADD;
6009: Elsif l_changed_model_line_num is Not Null and P_UPDATE_QUOTE = 'F' then
6010: FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_MODEL_LINES_QUOTE');
6011: FND_MESSAGE.Set_Token('CHANGED_MODEL_LINE_NUM', l_changed_model_line_num, FALSE);
6012: FND_MSG_PUB.ADD;
6013: End if;
6014:
6015: If l_invalid_model_line_num is not null then
6016: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_MODEL_LINES_QUOTE');

Line 6018: FND_MSG_PUB.ADD;

6014:
6015: If l_invalid_model_line_num is not null then
6016: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_MODEL_LINES_QUOTE');
6017: FND_MESSAGE.Set_Token('INVALID_MODEL_LINE_NUM', l_invalid_model_line_num, FALSE);
6018: FND_MSG_PUB.ADD;
6019: End if;
6020:
6021: /*This needs to be done where the BV api is called during Place_Order
6022: If X_Config_tbl.count > 0 and X_Config_tbl(i).IS_CFG_CHANGED_FLAG = 'Y' then

Line 6024: FND_MSG_PUB.ADD;

6020:
6021: /*This needs to be done where the BV api is called during Place_Order
6022: If X_Config_tbl.count > 0 and X_Config_tbl(i).IS_CFG_CHANGED_FLAG = 'Y' then
6023: FND_MESSAGE.Set_Name('ASO', 'ASO_CHANGED_MODEL_LINES_REVIEW');
6024: FND_MSG_PUB.ADD;
6025: End if;
6026: */
6027: End if;
6028:

Line 6049: FND_MSG_PUB.Count_And_Get

6045: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration L_Return_X_Msg_data '||L_Return_X_Msg_data, 1, 'Y');
6046: End if;
6047:
6048: -- Standard call to get message count and if count is 1, get message info.
6049: FND_MSG_PUB.Count_And_Get
6050: ( p_count => x_msg_count,
6051: p_data => x_msg_data
6052: );
6053:

Line 6066: fnd_msg_pub.count_and_get

6062: EXCEPTION
6063: WHEN EXCP_USER_DEFINED THEN
6064: x_return_status := FND_API.G_RET_STS_ERROR;
6065:
6066: fnd_msg_pub.count_and_get
6067: ( p_count => x_msg_count
6068: , p_data => x_msg_data);
6069:
6070: WHEN FND_API.G_EXC_ERROR THEN

Line 6074: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

6070: WHEN FND_API.G_EXC_ERROR THEN
6071: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6072: P_API_NAME => L_API_NAME
6073: ,P_PKG_NAME => G_PKG_NAME
6074: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6075: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
6076: ,X_MSG_COUNT => X_MSG_COUNT
6077: ,X_MSG_DATA => X_MSG_DATA
6078: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 6084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6081: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6082: P_API_NAME => L_API_NAME
6083: ,P_PKG_NAME => G_PKG_NAME
6084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6085: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
6086: ,X_MSG_COUNT => X_MSG_COUNT
6087: ,X_MSG_DATA => X_MSG_DATA
6088: ,X_RETURN_STATUS => X_RETURN_STATUS);