DBA Data[Home] [Help]

APPS.ASO_CONFIG_OPERATIONS_PVT dependencies on FND_MSG_PUB

Line 89: FND_MSG_PUB.initialize;

85: END IF;
86:
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:
92:
93: -- Initialize API return status to success

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

222:
223: IF c_configuration_details_csr%NOTFOUND THEN
224: CLOSE c_configuration_details_csr;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
228: FND_MSG_PUB.Add;
229: END IF;
230: raise FND_API.G_EXC_ERROR;

Line 228: FND_MSG_PUB.Add;

224: CLOSE c_configuration_details_csr;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
228: FND_MSG_PUB.Add;
229: END IF;
230: raise FND_API.G_EXC_ERROR;
231: END IF;
232:

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

261:
262: IF c_last_update_date_csr%NOTFOUND THEN
263: CLOSE c_last_update_date_csr;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
266: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
267: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
268: FND_MSG_PUB.ADD;
269: END IF;

Line 268: FND_MSG_PUB.ADD;

264: x_return_status := FND_API.G_RET_STS_ERROR;
265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
266: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
267: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
268: FND_MSG_PUB.ADD;
269: END IF;
270: raise FND_API.G_EXC_ERROR;
271:
272: END IF;

Line 320: FND_Msg_Pub.Count_And_Get(

316: COMMIT WORK;
317: END IF;
318:
319: -- Standard call to get message count and if count is 1, get message info
320: FND_Msg_Pub.Count_And_Get(
321: p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count ,
323: p_data => x_msg_data
324: );

Line 334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

330: x_return_status := FND_API.G_RET_STS_ERROR;
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 345: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
343: P_API_NAME => L_API_NAME
344: ,P_PKG_NAME => G_PKG_NAME
345: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
346: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
347: ,X_MSG_COUNT => X_MSG_COUNT
348: ,X_MSG_DATA => X_MSG_DATA
349: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 487: FND_MSG_PUB.initialize;

483: END IF;
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE.
486: IF FND_API.to_Boolean( p_init_msg_list ) THEN
487: FND_MSG_PUB.initialize;
488: END IF;
489:
490:
491: -- Initialize API return status to success

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

559:
560: IF c_uom_qty_csr%NOTFOUND THEN
561: CLOSE c_uom_qty_csr;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
564: FND_MESSAGE.Set_Name('ASO', 'ASO_UOM_QTY_NOT_FOUND');
565: FND_MSG_PUB.Add;
566: END IF;
567: raise FND_API.G_EXC_ERROR;

Line 565: FND_MSG_PUB.Add;

561: CLOSE c_uom_qty_csr;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
564: FND_MESSAGE.Set_Name('ASO', 'ASO_UOM_QTY_NOT_FOUND');
565: FND_MSG_PUB.Add;
566: END IF;
567: raise FND_API.G_EXC_ERROR;
568: END IF;
569:

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

590:
591: IF c_last_update_date_csr%NOTFOUND THEN
592: CLOSE c_configuration_details_csr;
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
595: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
596: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
597: FND_MSG_PUB.ADD;
598: END IF;

Line 597: FND_MSG_PUB.ADD;

593: x_return_status := FND_API.G_RET_STS_ERROR;
594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
595: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
596: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
597: FND_MSG_PUB.ADD;
598: END IF;
599: raise FND_API.G_EXC_ERROR;
600:
601: END IF;

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

672:
673: IF c_configuration_details_csr%NOTFOUND THEN
674: CLOSE c_configuration_details_csr;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
677: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
678: FND_MSG_PUB.Add;
679: END IF;
680: raise FND_API.G_EXC_ERROR;

Line 678: FND_MSG_PUB.Add;

674: CLOSE c_configuration_details_csr;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
677: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
678: FND_MSG_PUB.Add;
679: END IF;
680: raise FND_API.G_EXC_ERROR;
681:
682: END IF;

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

702:
703: IF c_mdl_item_details_csr%NOTFOUND THEN
704: CLOSE c_mdl_item_details_csr;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.Set_Name('ASO', 'ASO_MDL_DETAILS_NOT_FOUND');
708: FND_MSG_PUB.Add;
709: END IF;
710: raise FND_API.G_EXC_ERROR;

Line 708: FND_MSG_PUB.Add;

704: CLOSE c_mdl_item_details_csr;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.Set_Name('ASO', 'ASO_MDL_DETAILS_NOT_FOUND');
708: FND_MSG_PUB.Add;
709: END IF;
710: raise FND_API.G_EXC_ERROR;
711: END IF;
712:

Line 764: FND_Msg_Pub.Count_And_Get(

760: COMMIT WORK;
761: END IF;
762:
763: -- Standard call to get message count and if count is 1, get message info
764: FND_Msg_Pub.Count_And_Get(
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,
767: p_data => x_msg_data
768: );

Line 777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

773: x_return_status := FND_API.G_RET_STS_ERROR;
774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
775: P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME
777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
778: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
779: ,X_MSG_COUNT => X_MSG_COUNT
780: ,X_MSG_DATA => X_MSG_DATA
781: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 788: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
786: P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME
788: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
789: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
790: ,X_MSG_COUNT => X_MSG_COUNT
791: ,X_MSG_DATA => X_MSG_DATA
792: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 942: FND_MSG_PUB.initialize;

938: END IF;
939:
940: -- Initialize message list if p_init_msg_list is set to TRUE.
941: IF FND_API.to_Boolean( p_init_msg_list ) THEN
942: FND_MSG_PUB.initialize;
943: END IF;
944:
945:
946: -- Initialize API return status to success

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

1007:
1008: For c_de_item_rec IN c_deactivate_item_csr(l_qte_line_tbl(i).quote_line_id) LOOP
1009: if c_de_item_rec.config_delta > 0 then
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1012: FND_MESSAGE.Set_Name('ASO', 'ASO_ITEM_CANT_BE_DEACTIVATED');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015: raise FND_API.G_EXC_ERROR;

Line 1013: FND_MSG_PUB.Add;

1009: if c_de_item_rec.config_delta > 0 then
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1012: FND_MESSAGE.Set_Name('ASO', 'ASO_ITEM_CANT_BE_DEACTIVATED');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015: raise FND_API.G_EXC_ERROR;
1016:
1017: end if;

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

1176:
1177: IF c_last_update_date_csr%NOTFOUND THEN
1178: CLOSE c_last_update_date_csr;
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1181: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1182: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1183: FND_MSG_PUB.ADD;
1184: END IF;

Line 1183: FND_MSG_PUB.ADD;

1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1181: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1182: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1183: FND_MSG_PUB.ADD;
1184: END IF;
1185: raise FND_API.G_EXC_ERROR;
1186:
1187: END IF;

Line 1263: FND_Msg_Pub.Count_And_Get(

1259: COMMIT WORK;
1260: END IF;
1261:
1262: -- Standard call to get message count and if count is 1, get message info
1263: FND_Msg_Pub.Count_And_Get(
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );

Line 1275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1273: P_API_NAME => L_API_NAME
1274: ,P_PKG_NAME => G_PKG_NAME
1275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1276: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1277: ,X_MSG_COUNT => X_MSG_COUNT
1278: ,X_MSG_DATA => X_MSG_DATA
1279: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1287: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1288: ,X_MSG_COUNT => X_MSG_COUNT
1289: ,X_MSG_DATA => X_MSG_DATA
1290: ,X_RETURN_STATUS => X_RETURN_STATUS);