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 3971: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 3974: FND_MSG_PUB.ADD;

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

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

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

Line 4030: FND_MSG_PUB.ADD;

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

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

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

Line 4196: FND_MSG_PUB.ADD;

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

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

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

Line 4265: FND_MSG_PUB.ADD;

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

Line 4284: FND_MSG_PUB.Count_And_Get

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

Line 4295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 4307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 4456: FND_MSG_PUB.initialize;

4452: END IF;
4453:
4454: -- Initialize message list if p_init_msg_list is set to TRUE.
4455: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4456: FND_MSG_PUB.initialize;
4457: END IF;
4458:
4459: -- Initialize API return status to SUCCESS
4460: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4535: );
4536:
4537: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4538:
4539: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4540: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4541: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);
4542: FND_MSG_PUB.ADD;
4543: END IF;

Line 4542: FND_MSG_PUB.ADD;

4538:
4539: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4540: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4541: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);
4542: FND_MSG_PUB.ADD;
4543: END IF;
4544:
4545: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4592: );
4593:
4594: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4595:
4596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4597: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4598: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);
4599: FND_MSG_PUB.ADD;
4600: END IF;

Line 4599: FND_MSG_PUB.ADD;

4595:
4596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4597: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4598: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);
4599: FND_MSG_PUB.ADD;
4600: END IF;
4601:
4602: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4755: );
4756:
4757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4758:
4759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4760: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4761: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);
4762: FND_MSG_PUB.ADD;
4763: END IF;

Line 4762: FND_MSG_PUB.ADD;

4758:
4759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4760: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4761: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);
4762: FND_MSG_PUB.ADD;
4763: END IF;
4764:
4765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4823: END IF;
4824:
4825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4826:
4827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4828: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4829: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);
4830: FND_MSG_PUB.ADD;
4831: END IF;

Line 4830: FND_MSG_PUB.ADD;

4826:
4827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4828: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4829: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);
4830: FND_MSG_PUB.ADD;
4831: END IF;
4832:
4833: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4849: COMMIT WORK;
4850: END IF;
4851:
4852: -- Standard call to get message count and if count is 1, get message info.
4853: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4854: p_data => x_msg_data );
4855:
4856:
4857: EXCEPTION

Line 4863: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4859: WHEN FND_API.G_EXC_ERROR THEN
4860: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4861: P_API_NAME => L_API_NAME
4862: ,P_PKG_NAME => G_PKG_NAME
4863: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4864: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4865: ,P_SQLCODE => SQLCODE
4866: ,P_SQLERRM => SQLERRM
4867: ,X_MSG_COUNT => X_MSG_COUNT

Line 4875: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4872: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4873: P_API_NAME => L_API_NAME
4874: ,P_PKG_NAME => G_PKG_NAME
4875: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4876: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4877: ,P_SQLCODE => SQLCODE
4878: ,P_SQLERRM => SQLERRM
4879: ,X_MSG_COUNT => X_MSG_COUNT