93: IF FND_GLOBAL.User_Id IS NULL
94: THEN
95: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
96: THEN
97: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
98: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
99: FND_MSG_PUB.ADD;
100: END IF;
101: RAISE FND_API.G_EXC_ERROR;
94: THEN
95: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
96: THEN
97: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
98: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
99: FND_MSG_PUB.ADD;
100: END IF;
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
424:
425: If ( C_Get_repjobxref%NOTFOUND) Then
426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
427: THEN
428: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
429: FND_MESSAGE.Set_Token ('INFO', 'repjobxref', FALSE);
430: FND_MSG_PUB.Add;
431: END IF;
432: raise FND_API.G_EXC_ERROR;
425: If ( C_Get_repjobxref%NOTFOUND) Then
426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
427: THEN
428: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
429: FND_MESSAGE.Set_Token ('INFO', 'repjobxref', FALSE);
430: FND_MSG_PUB.Add;
431: END IF;
432: raise FND_API.G_EXC_ERROR;
433: END IF;
440: If (l_tar_REPJOBXREF_rec.last_update_date is NULL or
441: l_tar_REPJOBXREF_rec.last_update_date = FND_API.G_MISS_Date ) Then
442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
443: THEN
444: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
445: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
446: FND_MSG_PUB.ADD;
447: END IF;
448: raise FND_API.G_EXC_ERROR;
441: l_tar_REPJOBXREF_rec.last_update_date = FND_API.G_MISS_Date ) Then
442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
443: THEN
444: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
445: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
446: FND_MSG_PUB.ADD;
447: END IF;
448: raise FND_API.G_EXC_ERROR;
449: End if;
450: -- Check Whether record has been changed by someone else
451: If (l_tar_REPJOBXREF_rec.last_update_date <> l_ref_REPJOBXREF_rec.last_update_date) Then
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN
454: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
455: FND_MESSAGE.Set_Token('INFO', 'repjobxref', FALSE);
456: FND_MSG_PUB.ADD;
457: END IF;
458: raise FND_API.G_EXC_ERROR;
451: If (l_tar_REPJOBXREF_rec.last_update_date <> l_ref_REPJOBXREF_rec.last_update_date) Then
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN
454: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
455: FND_MESSAGE.Set_Token('INFO', 'repjobxref', FALSE);
456: FND_MSG_PUB.ADD;
457: END IF;
458: raise FND_API.G_EXC_ERROR;
459: End if;