114: IF FND_GLOBAL.User_Id IS NULL
115: THEN
116: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
117: THEN
118: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
119: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
120: FND_MSG_PUB.ADD;
121: END IF;
122: RAISE FND_API.G_EXC_ERROR;
115: THEN
116: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
117: THEN
118: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
119: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
120: FND_MSG_PUB.ADD;
121: END IF;
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
149: IF C_qln%NOTFOUND THEN
150: CLOSE C_qln;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
153: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
154: FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
155: FND_MSG_PUB.Add;
156: END IF;
157: raise FND_API.G_EXC_ERROR;
150: CLOSE C_qln;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
153: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
154: FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
155: FND_MSG_PUB.Add;
156: END IF;
157: raise FND_API.G_EXC_ERROR;
158: ELSE
167: IF C_item1%NOTFOUND OR l_serviceable_flag <> 'Y' THEN
168: CLOSE C_item1;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
171: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO1');
172: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
173: FND_MSG_PUB.Add;
174: END IF;
175: raise FND_API.G_EXC_ERROR;
168: CLOSE C_item1;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
171: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO1');
172: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
173: FND_MSG_PUB.Add;
174: END IF;
175: raise FND_API.G_EXC_ERROR;
176:
209:
210: IF l_Available_YN = 'N' THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
213: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
214: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
215: FND_MSG_PUB.Add;
216: END IF;
217: raise FND_API.G_EXC_ERROR;
210: IF l_Available_YN = 'N' THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
213: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
214: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
215: FND_MSG_PUB.Add;
216: END IF;
217: raise FND_API.G_EXC_ERROR;
218: END IF;
235: IF C_cs_item%NOTFOUND THEN
236: CLOSE C_cs_item;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
240: --FND_MESSAGE.Set_Token('COLUMN','INSTALLBASE', FALSE);
241: FND_MSG_PUB.Add;
242: END IF;
243: raise FND_API.G_EXC_ERROR;
236: CLOSE C_cs_item;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
240: --FND_MESSAGE.Set_Token('COLUMN','INSTALLBASE', FALSE);
241: FND_MSG_PUB.Add;
242: END IF;
243: raise FND_API.G_EXC_ERROR;
244: END IF;
257: );
258: IF l_Available_YN = 'N' THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
261: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
262: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
263: FND_MSG_PUB.Add;
264: END IF;
265: raise FND_API.G_EXC_ERROR;
258: IF l_Available_YN = 'N' THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
261: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
262: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
263: FND_MSG_PUB.Add;
264: END IF;
265: raise FND_API.G_EXC_ERROR;
266: END IF;
282: IF C_ord_item%NOTFOUND THEN
283: CLOSE C_ord_item;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
286: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
287: --FND_MESSAGE.Set_Token('COLUMN','ORDER_LINE_ID', FALSE);
288: FND_MSG_PUB.Add;
289: END IF;
290: raise FND_API.G_EXC_ERROR;
283: CLOSE C_ord_item;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
286: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
287: --FND_MESSAGE.Set_Token('COLUMN','ORDER_LINE_ID', FALSE);
288: FND_MSG_PUB.Add;
289: END IF;
290: raise FND_API.G_EXC_ERROR;
291: END IF;
304: );
305: IF l_Available_YN = 'N' THEN
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
308: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
309: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
310: FND_MSG_PUB.Add;
311: END IF;
312: raise FND_API.G_EXC_ERROR;
305: IF l_Available_YN = 'N' THEN
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
308: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
309: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
310: FND_MSG_PUB.Add;
311: END IF;
312: raise FND_API.G_EXC_ERROR;
313: END IF;
447: IF FND_GLOBAL.User_Id IS NULL
448: THEN
449: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
450: THEN
451: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
452: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
453: FND_MSG_PUB.ADD;
454: END IF;
455: RAISE FND_API.G_EXC_ERROR;
448: THEN
449: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
450: THEN
451: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
452: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
453: FND_MSG_PUB.ADD;
454: END IF;
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
611: IF FND_GLOBAL.User_Id IS NULL
612: THEN
613: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
614: THEN
615: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
616: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
617: FND_MSG_PUB.ADD;
618: END IF;
619: RAISE FND_API.G_EXC_ERROR;
612: THEN
613: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
614: THEN
615: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
616: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
617: FND_MSG_PUB.ADD;
618: END IF;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
797: IF FND_GLOBAL.User_Id IS NULL
798: THEN
799: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
802: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
803: FND_MSG_PUB.ADD;
804: END IF;
805: RAISE FND_API.G_EXC_ERROR;
798: THEN
799: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
802: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
803: FND_MSG_PUB.ADD;
804: END IF;
805: RAISE FND_API.G_EXC_ERROR;
806: END IF;
995: IF FND_GLOBAL.User_Id IS NULL
996: THEN
997: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1000: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1001: FND_MSG_PUB.ADD;
1002: END IF;
1003: RAISE FND_API.G_EXC_ERROR;
996: THEN
997: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1000: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1001: FND_MSG_PUB.ADD;
1002: END IF;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;