69: --
70: -- ******************************************************************
71: -- Validate Environment
72: -- ******************************************************************
73: IF FND_GLOBAL.User_Id IS NULL
74: THEN
75: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
76: THEN
77: FND_MESSAGE.Set_Name('IEX', 'UT_CANNOT_GET_PROFILE_VALUE');
178: ,p_ATTRIBUTE12 => p_RPS_rec.ATTRIBUTE12
179: ,p_ATTRIBUTE13 => p_RPS_rec.ATTRIBUTE13
180: ,p_ATTRIBUTE14 => p_RPS_rec.ATTRIBUTE14
181: ,p_ATTRIBUTE15 => p_RPS_rec.ATTRIBUTE15
182: ,p_CREATED_BY => FND_GLOBAL.USER_ID
183: ,p_CREATION_DATE => SYSDATE
184: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
185: ,p_LAST_UPDATE_DATE => SYSDATE
186: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
180: ,p_ATTRIBUTE14 => p_RPS_rec.ATTRIBUTE14
181: ,p_ATTRIBUTE15 => p_RPS_rec.ATTRIBUTE15
182: ,p_CREATED_BY => FND_GLOBAL.USER_ID
183: ,p_CREATION_DATE => SYSDATE
184: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
185: ,p_LAST_UPDATE_DATE => SYSDATE
186: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
187: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
188: ,p_CREDIT_HOLD_REQUEST_FLAG => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
182: ,p_CREATED_BY => FND_GLOBAL.USER_ID
183: ,p_CREATION_DATE => SYSDATE
184: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
185: ,p_LAST_UPDATE_DATE => SYSDATE
186: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
187: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
188: ,p_CREDIT_HOLD_REQUEST_FLAG => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
189: ,p_CREDIT_HOLD_APPROVED_FLAG => p_RPS_rec.CREDIT_HOLD_APPROVED_FLAG
190: ,p_SERVICE_HOLD_REQUEST_FLAG => p_RPS_rec.SERVICE_HOLD_REQUEST_FLAG
183: ,p_CREATION_DATE => SYSDATE
184: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
185: ,p_LAST_UPDATE_DATE => SYSDATE
186: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
187: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
188: ,p_CREDIT_HOLD_REQUEST_FLAG => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
189: ,p_CREDIT_HOLD_APPROVED_FLAG => p_RPS_rec.CREDIT_HOLD_APPROVED_FLAG
190: ,p_SERVICE_HOLD_REQUEST_FLAG => p_RPS_rec.SERVICE_HOLD_REQUEST_FLAG
191: ,p_SERVICE_HOLD_APPROVED_FLAG => p_RPS_rec.SERVICE_HOLD_APPROVED_FLAG
540: ,p_ATTRIBUTE14 => p_RPS_rec.ATTRIBUTE14
541: ,p_ATTRIBUTE15 => p_RPS_rec.ATTRIBUTE15
542: ,p_CREATED_BY => FND_API.G_MISS_NUM
543: ,p_CREATION_DATE => FND_API.G_MISS_DATE
544: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
545: ,p_LAST_UPDATE_DATE => SYSDATE
546: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
547: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
548: ,p_CREDIT_HOLD_REQUEST_FLAG => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
542: ,p_CREATED_BY => FND_API.G_MISS_NUM
543: ,p_CREATION_DATE => FND_API.G_MISS_DATE
544: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
545: ,p_LAST_UPDATE_DATE => SYSDATE
546: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
547: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
548: ,p_CREDIT_HOLD_REQUEST_FLAG => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
549: ,p_CREDIT_HOLD_APPROVED_FLAG => p_RPS_rec.CREDIT_HOLD_APPROVED_FLAG
550: ,p_SERVICE_HOLD_REQUEST_FLAG => p_RPS_rec.SERVICE_HOLD_REQUEST_FLAG
543: ,p_CREATION_DATE => FND_API.G_MISS_DATE
544: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
545: ,p_LAST_UPDATE_DATE => SYSDATE
546: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
547: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
548: ,p_CREDIT_HOLD_REQUEST_FLAG => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
549: ,p_CREDIT_HOLD_APPROVED_FLAG => p_RPS_rec.CREDIT_HOLD_APPROVED_FLAG
550: ,p_SERVICE_HOLD_REQUEST_FLAG => p_RPS_rec.SERVICE_HOLD_REQUEST_FLAG
551: ,p_SERVICE_HOLD_APPROVED_FLAG => p_RPS_rec.SERVICE_HOLD_APPROVED_FLAG