DBA Data[Home] [Help]

APPS.ASO_SECURITY_INT dependencies on FND_MSG_PUB

Line 189: FND_Msg_Pub.initialize;

185: END IF;
186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.
188: IF FND_API.To_Boolean(p_init_msg_list) THEN
189: FND_Msg_Pub.initialize;
190: END IF;
191:
192: -- API body
193: X_Qte_Access_Tbl := l_qte_access_tbl;

Line 213: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

209: FOR l_lock_rec IN Lock_check(l_qte_access_tbl(i).quote_number) LOOP
210:
211: IF l_lock_rec.price_request_id IS NOT NULL THEN
212:
213: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
214: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
215: FND_MSG_PUB.ADD;
216: end if;
217:

Line 215: FND_MSG_PUB.ADD;

211: IF l_lock_rec.price_request_id IS NOT NULL THEN
212:
213: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
214: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
215: FND_MSG_PUB.ADD;
216: end if;
217:
218: raise fnd_api.g_exc_error;
219:

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

240: close c_access_id_exist;
241:
242: x_return_status := fnd_api.g_ret_sts_error;
243:
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
245: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
246: FND_MESSAGE.Set_token('COLUMN', 'access_id');
247: FND_MESSAGE.Set_token('VALUE', l_qte_access_tbl(i).access_id);
248: FND_MSG_PUB.Add;

Line 248: FND_MSG_PUB.Add;

244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
245: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
246: FND_MESSAGE.Set_token('COLUMN', 'access_id');
247: FND_MESSAGE.Set_token('VALUE', l_qte_access_tbl(i).access_id);
248: FND_MSG_PUB.Add;
249: END IF;
250:
251: RAISE FND_API.G_EXC_ERROR;
252:

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

305:
306: IF aso_debug_pub.g_debug_flag = 'Y' THEN
307: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: duplicate resource: ' || l_exist_access_id, 1, 'Y');
308: END IF;
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
310: FND_MESSAGE.Set_Name('ASO', 'ASO_DUPLICATE_RESOURCE_ID');
311: FND_MSG_PUB.Add;
312: END IF;
313:

Line 311: FND_MSG_PUB.Add;

307: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: duplicate resource: ' || l_exist_access_id, 1, 'Y');
308: END IF;
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
310: FND_MESSAGE.Set_Name('ASO', 'ASO_DUPLICATE_RESOURCE_ID');
311: FND_MSG_PUB.Add;
312: END IF;
313:
314: CLOSE C_existing_resource;
315:

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

464:
465: IF aso_debug_pub.g_debug_flag = 'Y' THEN
466: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: trying to set primary resource update_access_flag other than Y', 1, 'Y');
467: END IF;
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
469: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_ADD_INVALID_ACCESS');
470: FND_MSG_PUB.Add;
471: END IF;
472: RAISE FND_API.G_EXC_ERROR;

Line 470: FND_MSG_PUB.Add;

466: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: trying to set primary resource update_access_flag other than Y', 1, 'Y');
467: END IF;
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
469: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_ADD_INVALID_ACCESS');
470: FND_MSG_PUB.Add;
471: END IF;
472: RAISE FND_API.G_EXC_ERROR;
473: ELSE
474: IF l_resource_grp_id IS NOT NULL AND l_resource_grp_id <> FND_API.G_MISS_NUM THEN

Line 558: FND_Msg_Pub.Count_And_Get(

554: COMMIT WORK;
555: END IF;
556:
557: -- Standard call to get message count and if count is 1, get message info.
558: FND_Msg_Pub.Count_And_Get(
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data
562: );

Line 569: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

565: WHEN FND_API.G_EXC_ERROR THEN
566: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
567: P_API_NAME => L_API_NAME,
568: P_PKG_NAME => G_PKG_NAME,
569: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
570: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
571: P_SQLCODE => SQLCODE,
572: P_SQLERRM => SQLERRM,
573: X_MSG_COUNT => X_MSG_COUNT,

Line 582: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME,
581: P_PKG_NAME => G_PKG_NAME,
582: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
583: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
584: P_SQLCODE => SQLCODE,
585: P_SQLERRM => SQLERRM,
586: X_MSG_COUNT => X_MSG_COUNT,

Line 705: FND_Msg_Pub.initialize;

701: SAVEPOINT Delete_Resource_INT;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.To_Boolean(p_init_msg_list) THEN
705: FND_Msg_Pub.initialize;
706: END IF;
707:
708: -- Initialize API return status to success
709: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

732: FOR l_lock_rec IN C_lock_check(l_quote_num_rec.quote_number) LOOP
733:
734: IF l_lock_rec.price_request_id IS NOT NULL THEN
735:
736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
737: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
738: FND_MSG_PUB.ADD;
739: END IF;
740:

Line 738: FND_MSG_PUB.ADD;

734: IF l_lock_rec.price_request_id IS NOT NULL THEN
735:
736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
737: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
738: FND_MSG_PUB.ADD;
739: END IF;
740:
741: raise FND_API.G_EXC_ERROR;
742: END IF;

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

758: FOR l_lock_rec IN C_lock_check(P_Qte_Access_Tbl(i).quote_number) LOOP
759:
760: IF l_lock_rec.price_request_id IS NOT NULL THEN
761:
762: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
763: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
764: FND_MSG_PUB.ADD;
765: END IF;
766:

Line 764: FND_MSG_PUB.ADD;

760: IF l_lock_rec.price_request_id IS NOT NULL THEN
761:
762: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
763: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
764: FND_MSG_PUB.ADD;
765: END IF;
766:
767: raise FND_API.G_EXC_ERROR;
768:

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

819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
820: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete primary salesrep', 1, 'Y');
821: END IF;
822:
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_PRIMARY_RES');
825: FND_MSG_PUB.Add;
826: END IF;
827: RAISE FND_API.G_EXC_ERROR;

Line 825: FND_MSG_PUB.Add;

821: END IF;
822:
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_PRIMARY_RES');
825: FND_MSG_PUB.Add;
826: END IF;
827: RAISE FND_API.G_EXC_ERROR;
828: ELSE
829:

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

848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
849: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete a non-existent entry', 1, 'Y');
850:
851: END IF;
852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
853: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_INVALID_ID');
854: FND_MSG_PUB.Add;
855: END IF;
856: RAISE FND_API.G_EXC_ERROR;

Line 854: FND_MSG_PUB.Add;

850:
851: END IF;
852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
853: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_INVALID_ID');
854: FND_MSG_PUB.Add;
855: END IF;
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:

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

862: IF aso_debug_pub.g_debug_flag = 'Y' THEN
863: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete without passing enough info', 1, 'Y');
864: END IF;
865:
866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
867: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_INSUFFICIENT');
868: FND_MSG_PUB.Add;
869: END IF;
870: RAISE FND_API.G_EXC_ERROR;

Line 868: FND_MSG_PUB.Add;

864: END IF;
865:
866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
867: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_INSUFFICIENT');
868: FND_MSG_PUB.Add;
869: END IF;
870: RAISE FND_API.G_EXC_ERROR;
871: END IF;
872:

Line 918: FND_Msg_Pub.Count_And_Get(

914: COMMIT WORK;
915: END IF;
916:
917: -- Standard call to get message count and if count is 1, get message info.
918: FND_Msg_Pub.Count_And_Get(
919: p_encoded => FND_API.G_FALSE,
920: p_count => x_msg_count ,
921: p_data => x_msg_data
922: );

Line 929: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

925: WHEN FND_API.G_EXC_ERROR THEN
926: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
927: P_API_NAME => L_API_NAME,
928: P_PKG_NAME => G_PKG_NAME,
929: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
930: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
931: P_SQLCODE => SQLCODE,
932: P_SQLERRM => SQLERRM,
933: X_MSG_COUNT => X_MSG_COUNT,

Line 942: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME,
941: P_PKG_NAME => G_PKG_NAME,
942: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
943: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
944: P_SQLCODE => SQLCODE,
945: P_SQLERRM => SQLERRM,
946: X_MSG_COUNT => X_MSG_COUNT,

Line 1017: FND_Msg_Pub.initialize;

1013: SAVEPOINT Add_SalesRep_QuoteCreator_INT;
1014:
1015: -- Initialize message list if p_init_msg_list is set to TRUE.
1016: IF FND_API.To_Boolean(p_init_msg_list) THEN
1017: FND_Msg_Pub.initialize;
1018: END IF;
1019:
1020: -- Initialize API return status to success
1021: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1201: FND_Msg_Pub.Count_And_Get(

1197: COMMIT WORK;
1198: END IF;
1199:
1200: -- Standard call to get message count and if count is 1, get message info.
1201: FND_Msg_Pub.Count_And_Get(
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count ,
1204: p_data => x_msg_data
1205: );

Line 1212: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1210: P_API_NAME => L_API_NAME,
1211: P_PKG_NAME => G_PKG_NAME,
1212: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1213: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1214: P_SQLCODE => SQLCODE,
1215: P_SQLERRM => SQLERRM,
1216: X_MSG_COUNT => X_MSG_COUNT,

Line 1225: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1223: P_API_NAME => L_API_NAME,
1224: P_PKG_NAME => G_PKG_NAME,
1225: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1226: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1227: P_SQLCODE => SQLCODE,
1228: P_SQLERRM => SQLERRM,
1229: X_MSG_COUNT => X_MSG_COUNT,