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

Line 144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

140: WHEN FND_API.G_EXC_ERROR THEN
141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_API_NAME => L_API_NAME
143: ,P_PKG_NAME => G_PKG_NAME
144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
146: ,X_MSG_COUNT => X_MSG_COUNT
147: ,X_MSG_DATA => X_MSG_DATA
148: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 154: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
155: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
156: ,X_MSG_COUNT => X_MSG_COUNT
157: ,X_MSG_DATA => X_MSG_DATA
158: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 163: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

159: WHEN OTHERS THEN
160: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
161: P_API_NAME => L_API_NAME
162: ,P_PKG_NAME => G_PKG_NAME
163: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
164: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
165: ,X_MSG_COUNT => X_MSG_COUNT
166: ,X_MSG_DATA => X_MSG_DATA
167: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 314: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

310: WHEN FND_API.G_EXC_ERROR THEN
311: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
312: P_API_NAME => L_API_NAME
313: ,P_PKG_NAME => G_PKG_NAME
314: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
315: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
316: ,X_MSG_COUNT => X_MSG_COUNT
317: ,X_MSG_DATA => X_MSG_DATA
318: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 323: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
321: P_API_NAME => L_API_NAME
322: ,P_PKG_NAME => G_PKG_NAME
323: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
324: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
325: ,X_MSG_COUNT => X_MSG_COUNT
326: ,X_MSG_DATA => X_MSG_DATA
327: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 332: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

328: WHEN OTHERS THEN
329: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
330: P_API_NAME => L_API_NAME
331: ,P_PKG_NAME => G_PKG_NAME
332: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
333: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
334: ,X_MSG_COUNT => X_MSG_COUNT
335: ,X_MSG_DATA => X_MSG_DATA
336: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 586: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

582: WHEN FND_API.G_EXC_ERROR THEN
583: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
587: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
588: ,X_MSG_COUNT => X_MSG_COUNT
589: ,X_MSG_DATA => X_MSG_DATA
590: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 596: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
593: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
594: P_API_NAME => L_API_NAME
595: ,P_PKG_NAME => G_PKG_NAME
596: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
597: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
598: ,X_MSG_COUNT => X_MSG_COUNT
599: ,X_MSG_DATA => X_MSG_DATA
600: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

601: WHEN OTHERS THEN
602: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
603: P_API_NAME => L_API_NAME
604: ,P_PKG_NAME => G_PKG_NAME
605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
606: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
607: ,X_MSG_COUNT => X_MSG_COUNT
608: ,X_MSG_DATA => X_MSG_DATA
609: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 635: FND_MSG_PUB.initialize;

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

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

647: (sysdate NOT BETWEEN NVL(l_activation_date, sysdate) AND
648: NVL(l_termination_date, sysdate))OR
649: l_account_status <> 'A') THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
652: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
653: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
654: FND_MSG_PUB.ADD;
655: END IF;

Line 654: FND_MSG_PUB.ADD;

650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
652: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
653: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
654: FND_MSG_PUB.ADD;
655: END IF;
656: END IF;
657: CLOSE C_Account;
658: END IF;

Line 672: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

668: WHEN FND_API.G_EXC_ERROR THEN
669: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
670: P_API_NAME => L_API_NAME
671: ,P_PKG_NAME => G_PKG_NAME
672: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
673: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
674: ,X_MSG_COUNT => X_MSG_COUNT
675: ,X_MSG_DATA => X_MSG_DATA
676: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
680: P_API_NAME => L_API_NAME
681: ,P_PKG_NAME => G_PKG_NAME
682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
683: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
684: ,X_MSG_COUNT => X_MSG_COUNT
685: ,X_MSG_DATA => X_MSG_DATA
686: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 691: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

687: WHEN OTHERS THEN
688: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME
691: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
692: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
693: ,X_MSG_COUNT => X_MSG_COUNT
694: ,X_MSG_DATA => X_MSG_DATA
695: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 774: FND_MSG_PUB.initialize;

770:
771: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
772:
773: IF FND_API.to_boolean(p_init_msg_list) THEN
774: FND_MSG_PUB.initialize;
775: END IF;
776: IF NOT FND_API.compatible_api_call(
777: l_api_version,
778: p_api_version,

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

818:
819: OPEN C_party_info(p_qte_rec.party_id);
820: FETCH C_party_info INTO l_party_type, l_party_name;
821: IF (C_party_info%NOTFOUND) THEN
822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
823: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
824: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
825: FND_MSG_PUB.ADD;
826: END IF;

Line 825: FND_MSG_PUB.ADD;

821: IF (C_party_info%NOTFOUND) THEN
822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
823: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
824: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
825: FND_MSG_PUB.ADD;
826: END IF;
827: raise FND_API.G_EXC_ERROR;
828: END IF;
829: CLOSE C_party_info;

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

855:
856: OPEN C_source_codes( p_qte_rec.marketing_source_code_id);
857: FETCH C_source_codes INTO account_rec.source_code;
858: IF (C_source_codes%NOTFOUND) THEN
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
860: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_INFO');
861: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE CODES', FALSE);
862: FND_MSG_PUB.ADD;
863: END IF;

Line 862: FND_MSG_PUB.ADD;

858: IF (C_source_codes%NOTFOUND) THEN
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
860: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_INFO');
861: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE CODES', FALSE);
862: FND_MSG_PUB.ADD;
863: END IF;
864: END IF;
865: CLOSE C_source_codes;
866:

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

936: END IF;
937:
938:
939: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
941: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
942: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
943: FND_MSG_PUB.ADD;
944: END IF;

Line 943: FND_MSG_PUB.ADD;

939: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
941: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
942: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
943: FND_MSG_PUB.ADD;
944: END IF;
945: raise FND_API.G_EXC_ERROR;
946: ELSE
947: x_acct_id := l_acct_id;

Line 949: FND_MSG_PUB.Count_And_Get

945: raise FND_API.G_EXC_ERROR;
946: ELSE
947: x_acct_id := l_acct_id;
948: END IF;
949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953:

Line 959: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

955: WHEN FND_API.G_EXC_ERROR THEN
956: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
957: P_API_NAME => L_API_NAME
958: ,P_PKG_NAME => G_PKG_NAME
959: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
960: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
961: ,P_SQLCODE => SQLCODE
962: ,P_SQLERRM => SQLERRM
963: ,X_MSG_COUNT => X_MSG_COUNT

Line 971: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
969: P_API_NAME => L_API_NAME
970: ,P_PKG_NAME => G_PKG_NAME
971: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
972: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
973: ,P_SQLCODE => SQLCODE
974: ,P_SQLERRM => SQLERRM
975: ,X_MSG_COUNT => X_MSG_COUNT

Line 1030: FND_MSG_PUB.initialize;

1026: SAVEPOINT CREATE_ACCT_SITE_PVT;
1027:
1028:
1029: IF FND_API.to_boolean(p_init_msg_list) THEN
1030: FND_MSG_PUB.initialize;
1031: END IF;
1032: IF NOT FND_API.compatible_api_call(
1033: l_api_version,
1034: p_api_version,

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

1078: aso_debug_pub.add('create acct_site:after create_site:l_customer_site_id '||l_customer_site_id, 1, 'N');
1079: aso_debug_pub.add('create acct_site:after create_site:x_return_status '||x_return_status, 1, 'N');
1080: END IF;
1081: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1083: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1084: FND_MESSAGE.Set_Token('COLUMN', 'ACCT SITE', FALSE);
1085: FND_MSG_PUB.ADD;
1086: END IF;

Line 1085: FND_MSG_PUB.ADD;

1081: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1083: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1084: FND_MESSAGE.Set_Token('COLUMN', 'ACCT SITE', FALSE);
1085: FND_MSG_PUB.ADD;
1086: END IF;
1087: raise FND_API.G_EXC_ERROR;
1088: ELSE
1089: x_customer_site_id := l_customer_site_id ;

Line 1093: FND_MSG_PUB.Count_And_Get

1089: x_customer_site_id := l_customer_site_id ;
1090: END IF;
1091:
1092: END IF; -- customer site id not nul
1093: FND_MSG_PUB.Count_And_Get
1094: ( p_count => x_msg_count,
1095: p_data => x_msg_data
1096: );
1097:

Line 1103: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1099: WHEN FND_API.G_EXC_ERROR THEN
1100: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1101: P_API_NAME => L_API_NAME
1102: ,P_PKG_NAME => G_PKG_NAME
1103: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1104: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1105: ,P_SQLCODE => SQLCODE
1106: ,P_SQLERRM => SQLERRM
1107: ,X_MSG_COUNT => X_MSG_COUNT

Line 1115: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1113: P_API_NAME => L_API_NAME
1114: ,P_PKG_NAME => G_PKG_NAME
1115: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1116: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1117: ,P_SQLCODE => SQLCODE
1118: ,P_SQLERRM => SQLERRM
1119: ,X_MSG_COUNT => X_MSG_COUNT

Line 1203: FND_MSG_PUB.initialize;

1199:
1200: SAVEPOINT CREATE_ACCT_SITE_USES_PVT;
1201:
1202: IF FND_API.to_boolean(p_init_msg_list) THEN
1203: FND_MSG_PUB.initialize;
1204: END IF;
1205:
1206: IF NOT FND_API.compatible_api_call(
1207: l_api_version,

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

1310: aso_debug_pub.add('create acct_site_use:create_acct_site_use:l_site_use_id '||l_site_use_id, 1, 'N');
1311: END IF;
1312:
1313: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1315: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1316: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_SITE_USES', FALSE);
1317: FND_MSG_PUB.ADD;
1318: END IF;

Line 1317: FND_MSG_PUB.ADD;

1313: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1315: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1316: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_SITE_USES', FALSE);
1317: FND_MSG_PUB.ADD;
1318: END IF;
1319: raise FND_API.G_EXC_ERROR;
1320: ELSE
1321: x_site_use_id := l_site_use_id;

Line 1351: FND_MSG_PUB.Count_And_Get

1347: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1348: raise FND_API.G_EXC_ERROR;
1349: END IF;
1350: END IF;
1351: FND_MSG_PUB.Count_And_Get
1352: ( p_count => x_msg_count,
1353: p_data => x_msg_data
1354: );
1355:

Line 1361: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1357: WHEN FND_API.G_EXC_ERROR THEN
1358: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1359: P_API_NAME => L_API_NAME
1360: ,P_PKG_NAME => G_PKG_NAME
1361: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1362: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1363: ,P_SQLCODE => SQLCODE
1364: ,P_SQLERRM => SQLERRM
1365: ,X_MSG_COUNT => X_MSG_COUNT

Line 1373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1371: P_API_NAME => L_API_NAME
1372: ,P_PKG_NAME => G_PKG_NAME
1373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1374: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1375: ,P_SQLCODE => SQLCODE
1376: ,P_SQLERRM => SQLERRM
1377: ,X_MSG_COUNT => X_MSG_COUNT

Line 1445: FND_MSG_PUB.initialize;

1441:
1442: SAVEPOINT CREATE_CONTACT_PVT;
1443:
1444: IF FND_API.to_boolean(p_init_msg_list) THEN
1445: FND_MSG_PUB.initialize;
1446: END IF;
1447: IF NOT FND_API.compatible_api_call(
1448: l_api_version,
1449: p_api_version,

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

1472:
1473: OPEN C_party(p_org_contact_id);
1474: FETCH C_party INTO l_party_id;
1475: IF (C_party%NOTFOUND) THEN
1476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1477: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1478: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID FOR GIVEN ORG CONTACT', FALSE);
1479: FND_MSG_PUB.ADD;
1480: END IF;

Line 1479: FND_MSG_PUB.ADD;

1475: IF (C_party%NOTFOUND) THEN
1476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1477: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1478: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID FOR GIVEN ORG CONTACT', FALSE);
1479: FND_MSG_PUB.ADD;
1480: END IF;
1481: raise FND_API.G_EXC_ERROR;
1482: END IF;
1483: Close C_party;

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

1538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1539: aso_debug_pub.add('create con:after create_acct_role:x_cust_account_role_id '||x_cust_account_role_id, 1, 'N');
1540: END IF;
1541: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1543: THEN
1544: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1545: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1546: FND_MSG_PUB.ADD;

Line 1546: FND_MSG_PUB.ADD;

1542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1543: THEN
1544: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1545: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1546: FND_MSG_PUB.ADD;
1547: END IF;
1548: raise FND_API.G_EXC_ERROR;
1549: ELSE
1550: x_cust_account_role_id:= l_cust_account_role_id;

Line 1557: FND_MSG_PUB.Count_And_Get

1553:
1554: END IF; -- party and org are null
1555:
1556:
1557: FND_MSG_PUB.Count_And_Get
1558: ( p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561:

Line 1567: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1563: WHEN FND_API.G_EXC_ERROR THEN
1564: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1565: P_API_NAME => L_API_NAME
1566: ,P_PKG_NAME => G_PKG_NAME
1567: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1568: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1569: ,P_SQLCODE => SQLCODE
1570: ,P_SQLERRM => SQLERRM
1571: ,X_MSG_COUNT => X_MSG_COUNT

Line 1579: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1577: P_API_NAME => L_API_NAME
1578: ,P_PKG_NAME => G_PKG_NAME
1579: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1580: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1581: ,P_SQLCODE => SQLCODE
1582: ,P_SQLERRM => SQLERRM
1583: ,X_MSG_COUNT => X_MSG_COUNT

Line 1647: FND_MSG_PUB.initialize;

1643: BEGIN
1644: SAVEPOINT CREATE_ORG_CONTACT_ORD_PVT;
1645:
1646: IF FND_API.to_boolean(p_init_msg_list) THEN
1647: FND_MSG_PUB.initialize;
1648: END IF;
1649: IF NOT FND_API.compatible_api_call(
1650: l_api_version,
1651: p_api_version,

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

1679: aso_i_parties_v par
1680: WHERE acct.cust_account_id = p_acct_id
1681: AND acct.party_id = par.party_id;
1682: IF (SQL%NOTFOUND) THEN
1683: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1684: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1685: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
1686: FND_MSG_PUB.ADD;
1687: END IF;

Line 1686: FND_MSG_PUB.ADD;

1682: IF (SQL%NOTFOUND) THEN
1683: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1684: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1685: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
1686: FND_MSG_PUB.ADD;
1687: END IF;
1688: raise FND_API.G_EXC_ERROR;
1689: END IF;
1690: END IF;

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

1711:
1712: Open C_org_contact(p_party_id, l_header_party_id);
1713: Fetch C_org_contact into l_org_contact_id;
1714: IF (C_org_contact%NOTFOUND) THEN
1715: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1716: fnd_message.set_name('ASO', 'ORG_CONTACT_ID');
1717: FND_MSG_PUB.Add;
1718: END IF;
1719: -- RAISE FND_API.G_EXC_ERROR;

Line 1717: FND_MSG_PUB.Add;

1713: Fetch C_org_contact into l_org_contact_id;
1714: IF (C_org_contact%NOTFOUND) THEN
1715: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1716: fnd_message.set_name('ASO', 'ORG_CONTACT_ID');
1717: FND_MSG_PUB.Add;
1718: END IF;
1719: -- RAISE FND_API.G_EXC_ERROR;
1720: l_org_contact_id := NULL;
1721: END IF;

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

1756: aso_debug_pub.add('create org_con_ord:after create_org_con:l_org_contact_id '||l_org_contact_id, 1, 'N');
1757: aso_debug_pub.add('create org_con_ord:after create_org_con:x_return_status '||x_return_status, 1, 'N');
1758: END IF;
1759: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1761: THEN
1762: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1763: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT', FALSE);
1764: FND_MSG_PUB.ADD;

Line 1764: FND_MSG_PUB.ADD;

1760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1761: THEN
1762: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1763: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT', FALSE);
1764: FND_MSG_PUB.ADD;
1765: END IF;
1766: raise FND_API.G_EXC_ERROR;
1767: END IF;
1768: END IF; -- org contact is null

Line 1777: FND_MSG_PUB.Count_And_Get

1773:
1774: -- END IF; -- for 'PERSON' type
1775:
1776:
1777: FND_MSG_PUB.Count_And_Get
1778: ( p_count => x_msg_count,
1779: p_data => x_msg_data
1780: );
1781:

Line 1787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1785: P_API_NAME => L_API_NAME
1786: ,P_PKG_NAME => G_PKG_NAME
1787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1788: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1789: ,P_SQLCODE => SQLCODE
1790: ,P_SQLERRM => SQLERRM
1791: ,X_MSG_COUNT => X_MSG_COUNT

Line 1799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1797: P_API_NAME => L_API_NAME
1798: ,P_PKG_NAME => G_PKG_NAME
1799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1800: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1801: ,P_SQLCODE => SQLCODE
1802: ,P_SQLERRM => SQLERRM
1803: ,X_MSG_COUNT => X_MSG_COUNT

Line 1859: FND_MSG_PUB.initialize;

1855: BEGIN
1856: SAVEPOINT CREATE_CONTACT_ROLE_PVT;
1857:
1858: IF FND_API.to_boolean(p_init_msg_list) THEN
1859: FND_MSG_PUB.initialize;
1860: END IF;
1861: IF NOT FND_API.compatible_api_call(
1862: l_api_version,
1863: p_api_version,

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

1914: aso_debug_pub.add('create_contact_role:after create_cust_acct_role: x_return_status: '||x_return_status,1,'N');
1915: END IF;
1916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1917: x_cust_account_role_id := NULL;
1918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1919: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1920: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1921: FND_MSG_PUB.ADD;
1922: END IF;

Line 1921: FND_MSG_PUB.ADD;

1917: x_cust_account_role_id := NULL;
1918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1919: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1920: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1921: FND_MSG_PUB.ADD;
1922: END IF;
1923: raise FND_API.G_EXC_ERROR;
1924: END IF;
1925: ELSE

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

1957: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1958: aso_debug_pub.add('create_contact_role:after create_role_resp: x_return_status: '||x_return_status,1,'N');
1959: END IF;
1960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1961: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1962: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1963: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1964: FND_MSG_PUB.ADD;
1965: END IF;

Line 1964: FND_MSG_PUB.ADD;

1960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1961: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1962: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1963: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1964: FND_MSG_PUB.ADD;
1965: END IF;
1966: raise FND_API.G_EXC_ERROR;
1967: END IF;
1968: END IF;

Line 1973: FND_MSG_PUB.Count_And_Get

1969: END IF;
1970:
1971: CLOSE C_Get_Resp;
1972:
1973: FND_MSG_PUB.Count_And_Get
1974: ( p_count => x_msg_count,
1975: p_data => x_msg_data
1976: );
1977:

Line 1983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1979: WHEN FND_API.G_EXC_ERROR THEN
1980: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1981: P_API_NAME => L_API_NAME
1982: ,P_PKG_NAME => G_PKG_NAME
1983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1984: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1985: ,P_SQLCODE => SQLCODE
1986: ,P_SQLERRM => SQLERRM
1987: ,X_MSG_COUNT => X_MSG_COUNT

Line 1995: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1992: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1993: P_API_NAME => L_API_NAME
1994: ,P_PKG_NAME => G_PKG_NAME
1995: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1996: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1997: ,P_SQLCODE => SQLCODE
1998: ,P_SQLERRM => SQLERRM
1999: ,X_MSG_COUNT => X_MSG_COUNT

Line 2037: FND_MSG_PUB.initialize;

2033: BEGIN
2034: ---- Initialize---------------------
2035:
2036: IF FND_API.to_boolean(p_init_msg_list) THEN
2037: FND_MSG_PUB.initialize;
2038: END IF;
2039:
2040: IF NOT FND_API.compatible_api_call(
2041: l_api_version,

Line 2140: FND_MSG_PUB.initialize;

2136: ---- Initialize---------------------
2137: SAVEPOINT CREATE_CUSTOMER_ACCOUNT_PVT;
2138:
2139: IF FND_API.to_boolean(p_init_msg_list) THEN
2140: FND_MSG_PUB.initialize;
2141: END IF;
2142:
2143: IF NOT FND_API.compatible_api_call(
2144: l_api_version,

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

2180: END IF;
2181: OPEN C_party_info(P_Party_id);
2182: FETCH C_party_info INTO l_party_type, l_party_name;
2183: IF (C_party_info%NOTFOUND) THEN
2184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2186: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2187: FND_MSG_PUB.ADD;
2188: END IF;

Line 2187: FND_MSG_PUB.ADD;

2183: IF (C_party_info%NOTFOUND) THEN
2184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2186: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2187: FND_MSG_PUB.ADD;
2188: END IF;
2189: raise FND_API.G_EXC_ERROR;
2190: END IF;
2191: CLOSE C_party_info;

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

2200:
2201: OPEN C_party_info(customer_party_id);
2202: FETCH C_party_info INTO l_party_type, l_party_name;
2203: IF (C_party_info%NOTFOUND) THEN
2204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2205: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2206: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2207: FND_MSG_PUB.ADD;
2208: END IF;

Line 2207: FND_MSG_PUB.ADD;

2203: IF (C_party_info%NOTFOUND) THEN
2204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2205: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2206: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2207: FND_MSG_PUB.ADD;
2208: END IF;
2209: raise FND_API.G_EXC_ERROR;
2210: END IF;
2211: CLOSE C_party_info;

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

2282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2283: aso_debug_pub.add('create_cust_acct:after create_acct:l_acct_id: '||l_acct_id,1,'N');
2284: END IF;
2285: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2288: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
2289: FND_MSG_PUB.ADD;
2290: END IF;

Line 2289: FND_MSG_PUB.ADD;

2285: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2288: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
2289: FND_MSG_PUB.ADD;
2290: END IF;
2291: raise FND_API.G_EXC_ERROR;
2292: ELSE
2293: x_cust_acct_id := l_acct_id;

Line 2296: FND_MSG_PUB.Count_And_Get(

2292: ELSE
2293: x_cust_acct_id := l_acct_id;
2294: END IF;
2295:
2296: FND_MSG_PUB.Count_And_Get(
2297: p_count => x_msg_count,
2298: p_data => x_msg_data);
2299:
2300: EXCEPTION

Line 2305: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

2301: WHEN FND_API.G_EXC_ERROR THEN
2302: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2303: P_API_NAME => L_API_NAME,
2304: P_PKG_NAME => G_PKG_NAME,
2305: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2306: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2307: P_SQLCODE => SQLCODE,
2308: P_SQLERRM => SQLERRM,
2309: X_MSG_COUNT => X_MSG_COUNT,

Line 2317: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

2313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2314: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2315: P_API_NAME => L_API_NAME,
2316: P_PKG_NAME => G_PKG_NAME,
2317: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2318: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2319: P_SQLCODE => SQLCODE,
2320: P_SQLERRM => SQLERRM,
2321: X_MSG_COUNT => X_MSG_COUNT,

Line 2367: FND_MSG_PUB.initialize;

2363:
2364: SAVEPOINT Create_Cust_Acct_Relationship;
2365:
2366: IF FND_API.to_boolean(p_init_msg_list) THEN
2367: FND_MSG_PUB.initialize;
2368: END IF;
2369:
2370: IF NOT FND_API.compatible_api_call(
2371: l_api_version,

Line 2434: FND_MSG_PUB.Count_And_Get(

2430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2431: RAISE FND_API.G_EXC_ERROR;
2432: END IF;
2433:
2434: FND_MSG_PUB.Count_And_Get(
2435: p_count => x_msg_count,
2436: p_data => x_msg_data);
2437:
2438: EXCEPTION

Line 2443: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

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

Line 2455: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

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

Line 2499: FND_MSG_PUB.initialize;

2495: BEGIN
2496: SAVEPOINT CREATE_PARTY_SITE_USE_PVT;
2497:
2498: IF FND_API.to_boolean(p_init_msg_list) THEN
2499: FND_MSG_PUB.initialize;
2500: END IF;
2501:
2502: IF NOT FND_API.compatible_api_call(
2503: l_api_version,

Line 2556: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2552: WHEN FND_API.G_EXC_ERROR THEN
2553: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2554: P_API_NAME => L_API_NAME
2555: ,P_PKG_NAME => G_PKG_NAME
2556: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2557: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2558: ,X_MSG_COUNT => X_MSG_COUNT
2559: ,X_MSG_DATA => X_MSG_DATA
2560: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2566: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2563: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2564: P_API_NAME => L_API_NAME
2565: ,P_PKG_NAME => G_PKG_NAME
2566: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2567: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2568: ,X_MSG_COUNT => X_MSG_COUNT
2569: ,X_MSG_DATA => X_MSG_DATA
2570: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2571: WHEN OTHERS THEN
2572: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2573: P_API_NAME => L_API_NAME
2574: ,P_PKG_NAME => G_PKG_NAME
2575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2576: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2577: ,X_MSG_COUNT => X_MSG_COUNT
2578: ,X_MSG_DATA => X_MSG_DATA
2579: ,X_RETURN_STATUS => X_RETURN_STATUS);