103: IF FND_GLOBAL.User_Id IS NULL
104: THEN
105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
106: THEN
107: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
108: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
109: FND_MSG_PUB.ADD;
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
104: THEN
105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
106: THEN
107: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
108: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
109: FND_MSG_PUB.ADD;
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
184: END IF;
185:
186: IF (l_update_access_flag <> 'Y') THEN
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
188: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
189: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
190: FND_MSG_PUB.ADD;
191: END IF;
192: RAISE FND_API.G_EXC_ERROR;
185:
186: IF (l_update_access_flag <> 'Y') THEN
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
188: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
189: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
190: FND_MSG_PUB.ADD;
191: END IF;
192: RAISE FND_API.G_EXC_ERROR;
193: ELSE
296:
297: WHEN DUP_VAL_ON_INDEX THEN
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
299: THEN
300: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
301: --FND_MSG_PUB.ADD;
302: AS_UTILITY_PVT.Set_Message(
303: p_module => l_module,
304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
502: END IF;
503:
504: IF (l_update_access_flag <> 'Y') THEN
505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
506: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
507: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
508: FND_MSG_PUB.ADD;
509: END IF;
510: RAISE FND_API.G_EXC_ERROR;
503:
504: IF (l_update_access_flag <> 'Y') THEN
505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
506: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
507: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
508: FND_MSG_PUB.ADD;
509: END IF;
510: RAISE FND_API.G_EXC_ERROR;
511: ELSE
610:
611: WHEN DUP_VAL_ON_INDEX THEN
612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
613: THEN
614: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
615: --FND_MSG_PUB.ADD;
616: AS_UTILITY_PVT.Set_Message(
617: p_module => l_module,
618: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
809: END IF;
810:
811: IF (l_update_access_flag <> 'Y') THEN
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
814: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
815: FND_MSG_PUB.ADD;
816: END IF;
817: RAISE FND_API.G_EXC_ERROR;
810:
811: IF (l_update_access_flag <> 'Y') THEN
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
814: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
815: FND_MSG_PUB.ADD;
816: END IF;
817: RAISE FND_API.G_EXC_ERROR;
818: ELSE