68: IF FND_GLOBAL.User_Id IS NULL
69: THEN
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
73: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;
76: RAISE FND_API.G_EXC_ERROR;
69: THEN
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
73: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
129:
130: if l_x_status = fnd_api.g_true then
131:
132: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) then
133: fnd_message.set_name('ASO', 'ASO_CONC_REQUEST_RUNNING');
134: fnd_msg_pub.add;
135: end if;
136:
137: x_return_status := fnd_api.g_ret_sts_error;
322:
323: If ( C_Get_related_obj%NOTFOUND) Then
324: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
325: THEN
326: FND_MESSAGE.Set_Name('aso', 'API_MISSING_UPDATE_TARGET');
327: FND_MESSAGE.Set_Token ('INFO', 'related_obj', FALSE);
328: FND_MSG_PUB.Add;
329: END IF;
330: raise FND_API.G_EXC_ERROR;
323: If ( C_Get_related_obj%NOTFOUND) Then
324: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
325: THEN
326: FND_MESSAGE.Set_Name('aso', 'API_MISSING_UPDATE_TARGET');
327: FND_MESSAGE.Set_Token ('INFO', 'related_obj', FALSE);
328: FND_MSG_PUB.Add;
329: END IF;
330: raise FND_API.G_EXC_ERROR;
331: END IF;
338: If (l_tar_RELATED_OBJ_rec.last_update_date is NULL or
339: l_tar_RELATED_OBJ_rec.last_update_date = FND_API.G_MISS_Date ) Then
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
341: THEN
342: FND_MESSAGE.Set_Name('aso', 'API_MISSING_ID');
343: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
344: FND_MSG_PUB.ADD;
345: END IF;
346: raise FND_API.G_EXC_ERROR;
339: l_tar_RELATED_OBJ_rec.last_update_date = FND_API.G_MISS_Date ) Then
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
341: THEN
342: FND_MESSAGE.Set_Name('aso', 'API_MISSING_ID');
343: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
344: FND_MSG_PUB.ADD;
345: END IF;
346: raise FND_API.G_EXC_ERROR;
347: End if;
348: -- Check Whether record has been changed by someone else
349: If (l_tar_RELATED_OBJ_rec.last_update_date <> l_ref_RELATED_OBJ_rec.last_update_date) Then
350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
351: THEN
352: FND_MESSAGE.Set_Name('aso', 'API_RECORD_CHANGED');
353: FND_MESSAGE.Set_Token('INFO', 'related_obj', FALSE);
354: FND_MSG_PUB.ADD;
355: END IF;
356: raise FND_API.G_EXC_ERROR;
349: If (l_tar_RELATED_OBJ_rec.last_update_date <> l_ref_RELATED_OBJ_rec.last_update_date) Then
350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
351: THEN
352: FND_MESSAGE.Set_Name('aso', 'API_RECORD_CHANGED');
353: FND_MESSAGE.Set_Token('INFO', 'related_obj', FALSE);
354: FND_MSG_PUB.ADD;
355: END IF;
356: raise FND_API.G_EXC_ERROR;
357: End if;
403:
404: if l_x_status = fnd_api.g_true then
405:
406: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) then
407: fnd_message.set_name('ASO', 'ASO_CONC_REQUEST_RUNNING');
408: fnd_msg_pub.add;
409: end if;
410:
411: x_return_status := fnd_api.g_ret_sts_error;
566:
567: if l_x_status = fnd_api.g_true then
568:
569: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) then
570: fnd_message.set_name('ASO', 'ASO_CONC_REQUEST_RUNNING');
571: fnd_msg_pub.add;
572: end if;
573:
574: x_return_status := fnd_api.g_ret_sts_error;