41: WHEN no_data_found THEN
42:
43: x_return_status := Fnd_Api.G_Ret_Sts_Error;
44: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
45: Fnd_Msg_Pub.Add;
46:
47: WHEN others THEN
48:
49: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
47: WHEN others THEN
48:
49: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
50:
51: Fnd_Msg_Pub.Add_Exc_Msg
52: (
53: p_pkg_name => G_PKG_NAME,
54: p_procedure_name => l_api_name
55: );
99: (p_answer = '2' AND l_explanation_for_no_flag = 'Y') THEN
100:
101: x_return_status:= Fnd_Api.G_Ret_Sts_Error;
102: Fnd_Message.Set_Name('IGW','IGW_EXPLANATION_REQUIRED');
103: Fnd_Msg_Pub.Add;
104:
105: END IF;
106:
107: END IF;
112: (p_answer = '2' AND l_date_for_no_flag = 'Y') THEN
113:
114: x_return_status:= Fnd_Api.G_Ret_Sts_Error;
115: Fnd_Message.Set_Name('IGW','IGW_DATE_REQUIRED');
116: Fnd_Msg_Pub.Add;
117:
118: END IF;
119:
120: END IF;
124: WHEN no_data_found THEN
125:
126: x_return_status := Fnd_Api.G_Ret_Sts_Error;
127: Fnd_Message.Set_Name('IGW','IGW_SS_QUESTION_INVALID');
128: Fnd_Msg_Pub.Add;
129:
130: WHEN others THEN
131:
132: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
130: WHEN others THEN
131:
132: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
133:
134: Fnd_Msg_Pub.Add_Exc_Msg
135: (
136: p_pkg_name => G_PKG_NAME,
137: p_procedure_name => l_api_name
138: );
225: x_return_status := Fnd_Api.G_Ret_Sts_Success;
226:
227: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
228:
229: Fnd_Msg_Pub.Initialize;
230:
231: END IF;
232:
233:
248: );
249:
250: END IF;
251:
252: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
253:
254: RAISE Fnd_Api.G_Exc_Error;
255:
256: END IF;
270: = 'N' THEN
271:
272: x_return_status := Fnd_Api.G_Ret_Sts_Error;
273: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
274: Fnd_Msg_Pub.Add;
275: RAISE Fnd_Api.G_Exc_Error;
276:
277: END IF;
278:
289: x_return_status => l_return_status
290: );
291:
292:
293: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
294:
295: RAISE Fnd_Api.G_Exc_Error;
296:
297: END IF;
304: p_review_date => p_review_date,
305: x_return_status => x_return_status
306: );
307:
308: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
309:
310: RAISE Fnd_Api.G_Exc_Error;
311:
312: END IF;
357: ROLLBACK TO Update_Prop_Question_Pvt;
358:
359: x_return_status := Fnd_Api.G_Ret_Sts_Error;
360:
361: Fnd_Msg_Pub.Count_And_Get
362: (
363: p_count => x_msg_count,
364: p_data => x_msg_data
365: );
369: ROLLBACK TO Update_Prop_Question_Pvt;
370:
371: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
372:
373: Fnd_Msg_Pub.Count_And_Get
374: (
375: p_count => x_msg_count,
376: p_data => x_msg_data
377: );
381: ROLLBACK TO Update_Prop_Question_Pvt;
382:
383: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
384:
385: Fnd_Msg_Pub.Add_Exc_Msg
386: (
387: p_pkg_name => G_PKG_NAME,
388: p_procedure_name => l_api_name
389: );
387: p_pkg_name => G_PKG_NAME,
388: p_procedure_name => l_api_name
389: );
390:
391: Fnd_Msg_Pub.Count_And_Get
392: (
393: p_count => x_msg_count,
394: p_data => x_msg_data
395: );