eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGW_PROP_QUESTIONS_PVT dependencies on FND_API

Line 27: x_return_status := Fnd_Api.G_Ret_Sts_Success;

23: /*
24: ** Initialize
25: */
26:
27: x_return_status := Fnd_Api.G_Ret_Sts_Success;
28:
29: IF p_rowid IS NOT NULL AND p_record_version_number IS NOT NULL THEN
30:
31: SELECT 'N'

Line 43: x_return_status := Fnd_Api.G_Ret_Sts_Error;

39: EXCEPTION
40:
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

Line 49: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

45: Fnd_Msg_Pub.Add;
46:
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,

Line 57: RAISE Fnd_Api.G_Exc_Unexpected_Error;

53: p_pkg_name => G_PKG_NAME,
54: p_procedure_name => l_api_name
55: );
56:
57: RAISE Fnd_Api.G_Exc_Unexpected_Error;
58:
59: END Check_Lock;
60:
61: ---------------------------------------------------------------------------

Line 101: x_return_status:= Fnd_Api.G_Ret_Sts_Error;

97:
98: IF (p_answer = '1' AND l_explanation_for_yes_flag = 'Y') OR
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;

Line 114: x_return_status:= Fnd_Api.G_Ret_Sts_Error;

110:
111: IF (p_answer = '1' AND l_date_for_yes_flag = 'Y') OR
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;

Line 126: x_return_status := Fnd_Api.G_Ret_Sts_Error;

122: EXCEPTION
123:
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

Line 132: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

128: Fnd_Msg_Pub.Add;
129:
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,

Line 140: RAISE Fnd_Api.G_Exc_Unexpected_Error;

136: p_pkg_name => G_PKG_NAME,
137: p_procedure_name => l_api_name
138: );
139:
140: RAISE Fnd_Api.G_Exc_Unexpected_Error;
141:
142: END Explanation_Or_Date_Required;
143:
144: ---------------------------------------------------------------------------

Line 190: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,

186: ---------------------------------------------------------------------------
187:
188: PROCEDURE Update_Prop_Question
189: (
190: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
191: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
192: p_commit IN VARCHAR2 := Fnd_Api.G_False,
193: p_rowid IN VARCHAR2,
194: p_record_version_number IN NUMBER,

Line 191: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,

187:
188: PROCEDURE Update_Prop_Question
189: (
190: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
191: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
192: p_commit IN VARCHAR2 := Fnd_Api.G_False,
193: p_rowid IN VARCHAR2,
194: p_record_version_number IN NUMBER,
195: p_proposal_id IN NUMBER,

Line 192: p_commit IN VARCHAR2 := Fnd_Api.G_False,

188: PROCEDURE Update_Prop_Question
189: (
190: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
191: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
192: p_commit IN VARCHAR2 := Fnd_Api.G_False,
193: p_rowid IN VARCHAR2,
194: p_record_version_number IN NUMBER,
195: p_proposal_id IN NUMBER,
196: p_proposal_number IN VARCHAR2,

Line 225: x_return_status := Fnd_Api.G_Ret_Sts_Success;

221: /*
222: ** Initialize
223: */
224:
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;

Line 227: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

223: */
224:
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;

Line 254: RAISE Fnd_Api.G_Exc_Error;

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;
257:
258:

Line 272: x_return_status := Fnd_Api.G_Ret_Sts_Error;

268: p_user_id => Fnd_Global.User_Id
269: )
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:

Line 275: RAISE Fnd_Api.G_Exc_Error;

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:
279: */

Line 295: RAISE Fnd_Api.G_Exc_Error;

291:
292:
293: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
294:
295: RAISE Fnd_Api.G_Exc_Error;
296:
297: END IF;
298:
299: Explanation_Or_Date_Required

Line 310: RAISE Fnd_Api.G_Exc_Error;

306: );
307:
308: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
309:
310: RAISE Fnd_Api.G_Exc_Error;
311:
312: END IF;
313:
314: /*

Line 318: IF Fnd_Api.To_Boolean(p_validate_only) THEN

314: /*
315: ** Discontinue processing if API invoked in validation mode
316: */
317:
318: IF Fnd_Api.To_Boolean(p_validate_only) THEN
319:
320: RETURN;
321:
322: END IF;

Line 346: IF Fnd_Api.To_Boolean(p_commit) THEN

342: /*
343: ** Commit data if API invoked in commit mode
344: */
345:
346: IF Fnd_Api.To_Boolean(p_commit) THEN
347:
348: COMMIT;
349:
350: END IF;

Line 355: WHEN Fnd_Api.G_Exc_Error THEN

351:
352:
353: EXCEPTION
354:
355: WHEN Fnd_Api.G_Exc_Error THEN
356:
357: ROLLBACK TO Update_Prop_Question_Pvt;
358:
359: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 359: x_return_status := Fnd_Api.G_Ret_Sts_Error;

355: WHEN Fnd_Api.G_Exc_Error THEN
356:
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,

Line 367: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

363: p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366:
367: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
368:
369: ROLLBACK TO Update_Prop_Question_Pvt;
370:
371: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 371: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

367: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
368:
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,

Line 383: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

379: WHEN others THEN
380:
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,