82: -- Perform validation
83:
84: IF (P_One_Question.mQuestionName is NULL OR P_One_Question.mQuestionName= FND_API.G_MISS_CHAR) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_NAME_INVALID');
87: FND_MSG_PUB.Add;
88: RAISE FND_API.G_EXC_ERROR;
89: END IF;
90:
89: END IF;
90:
91: IF (P_One_Question.mAnswerType is NULL OR P_One_Question.mAnswerType= FND_API.G_MISS_CHAR OR length(P_One_Question.mAnswerType)<=0)THEN
92: X_Return_Status := FND_API.G_RET_STS_ERROR;
93: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_Answer_INVALID');
94: FND_MSG_PUB.Add;
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:
235: -- Perform validation
236:
237: IF (P_One_Question.mQuestionName is NULL OR P_One_Question.mQuestionName= FND_API.G_MISS_CHAR) THEN
238: X_Return_Status := FND_API.G_RET_STS_ERROR;
239: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_NAME_INVALID');
240: FND_MSG_PUB.Add;
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
242: END IF;
243:
244: IF (P_One_Question.mAnswerType is NULL OR P_One_Question.mAnswerType= FND_API.G_MISS_CHAR OR length(P_One_Question.mAnswerType)<=0)THEN
245: X_Return_Status := FND_API.G_RET_STS_ERROR;
246: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_Answer_INVALID');
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
259: close c;
260: -- is the last updated date from db later than the date from client
261: if (l_last_updated_date > TO_DATE (P_One_Question.mLast_Updated_Date, l_default_last_up_date_format )) then
262: X_Return_Status := FND_API.G_RET_STS_ERROR;
263: FND_MESSAGE.SET_NAME('CS','CS_TP_QUESTION_UPDATED');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: end if;
267:
486: end if;
487: close last_updateC;
488: if (to_date( P_Questions(i).mLast_Updated_date, l_default_last_up_date_format) < l_last_update_date) then
489: X_Return_Status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.SET_NAME('CS','CS_TP_QUESTION_UPDATED');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: end if;
494: