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.

APPS.IGW_SPONSOR_ACTION_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 65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,

61: ---------------------------------------------------------------------------
62:
63: PROCEDURE Create_Sponsor_Action
64: (
65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
66: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
67: p_commit IN VARCHAR2 := Fnd_Api.G_False,
68: x_rowid OUT NOCOPY VARCHAR2,
69: p_proposal_id IN NUMBER,

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

62:
63: PROCEDURE Create_Sponsor_Action
64: (
65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
66: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
67: p_commit IN VARCHAR2 := Fnd_Api.G_False,
68: x_rowid OUT NOCOPY VARCHAR2,
69: p_proposal_id IN NUMBER,
70: p_proposal_number IN VARCHAR2,

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

63: PROCEDURE Create_Sponsor_Action
64: (
65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
66: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
67: p_commit IN VARCHAR2 := Fnd_Api.G_False,
68: x_rowid OUT NOCOPY VARCHAR2,
69: p_proposal_id IN NUMBER,
70: p_proposal_number IN VARCHAR2,
71: p_comments IN VARCHAR2,

Line 98: x_return_status := Fnd_Api.G_Ret_Sts_Success;

94: /*
95: ** Initialize
96: */
97:
98: x_return_status := Fnd_Api.G_Ret_Sts_Success;
99:
100: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
101:
102: Fnd_Msg_Pub.Initialize;

Line 100: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

96: */
97:
98: x_return_status := Fnd_Api.G_Ret_Sts_Success;
99:
100: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
101:
102: Fnd_Msg_Pub.Initialize;
103:
104: END IF;

Line 135: x_return_status := Fnd_Api.G_Ret_Sts_Error;

131: p_user_id => Fnd_Global.User_Id
132: )
133: = 'N' THEN
134:
135: x_return_status := Fnd_Api.G_Ret_Sts_Error;
136: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
137: Fnd_Msg_Pub.Add;
138: RAISE Fnd_Api.G_Exc_Error;
139:

Line 138: RAISE Fnd_Api.G_Exc_Error;

134:
135: x_return_status := Fnd_Api.G_Ret_Sts_Error;
136: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
137: Fnd_Msg_Pub.Add;
138: RAISE Fnd_Api.G_Exc_Error;
139:
140: END IF;
141: */
142:

Line 148: IF Fnd_Api.To_Boolean(p_validate_only) THEN

144: /*
145: ** Discontinue processing if API invoked in validation mode
146: */
147:
148: IF Fnd_Api.To_Boolean(p_validate_only) THEN
149:
150: RETURN;
151:
152: END IF;

Line 174: IF Fnd_Api.To_Boolean(p_commit) THEN

170: /*
171: ** Commit data if API invoked in commit mode
172: */
173:
174: IF Fnd_Api.To_Boolean(p_commit) THEN
175:
176: COMMIT;
177:
178: END IF;

Line 183: WHEN Fnd_Api.G_Exc_Error THEN

179:
180:
181: EXCEPTION
182:
183: WHEN Fnd_Api.G_Exc_Error THEN
184:
185: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
186:
187: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 187: x_return_status := Fnd_Api.G_Ret_Sts_Error;

183: WHEN Fnd_Api.G_Exc_Error THEN
184:
185: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
186:
187: x_return_status := Fnd_Api.G_Ret_Sts_Error;
188:
189: Fnd_Msg_Pub.Count_And_Get
190: (
191: p_count => x_msg_count,

Line 195: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194:
195: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
196:
197: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
198:
199: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 199: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

195: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
196:
197: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
198:
199: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
200:
201: Fnd_Msg_Pub.Count_And_Get
202: (
203: p_count => x_msg_count,

Line 211: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

207: WHEN others THEN
208:
209: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
210:
211: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
212:
213: Fnd_Msg_Pub.Add_Exc_Msg
214: (
215: p_pkg_name => G_PKG_NAME,

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

227: ---------------------------------------------------------------------------
228:
229: PROCEDURE Update_Sponsor_Action
230: (
231: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
232: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
233: p_commit IN VARCHAR2 := Fnd_Api.G_False,
234: p_rowid IN VARCHAR2,
235: p_proposal_id IN NUMBER,

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

228:
229: PROCEDURE Update_Sponsor_Action
230: (
231: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
232: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
233: p_commit IN VARCHAR2 := Fnd_Api.G_False,
234: p_rowid IN VARCHAR2,
235: p_proposal_id IN NUMBER,
236: p_proposal_number IN VARCHAR2,

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

229: PROCEDURE Update_Sponsor_Action
230: (
231: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
232: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
233: p_commit IN VARCHAR2 := Fnd_Api.G_False,
234: p_rowid IN VARCHAR2,
235: p_proposal_id IN NUMBER,
236: p_proposal_number IN VARCHAR2,
237: p_comment_id IN NUMBER,

Line 266: x_return_status := Fnd_Api.G_Ret_Sts_Success;

262: /*
263: ** Initialize
264: */
265:
266: x_return_status := Fnd_Api.G_Ret_Sts_Success;
267:
268: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
269:
270: Fnd_Msg_Pub.Initialize;

Line 268: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

264: */
265:
266: x_return_status := Fnd_Api.G_Ret_Sts_Success;
267:
268: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
269:
270: Fnd_Msg_Pub.Initialize;
271:
272: END IF;

Line 295: RAISE Fnd_Api.G_Exc_Error;

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

Line 313: x_return_status := Fnd_Api.G_Ret_Sts_Error;

309: p_user_id => Fnd_Global.User_Id
310: )
311: = 'N' THEN
312:
313: x_return_status := Fnd_Api.G_Ret_Sts_Error;
314: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
315: Fnd_Msg_Pub.Add;
316: RAISE Fnd_Api.G_Exc_Error;
317:

Line 316: RAISE Fnd_Api.G_Exc_Error;

312:
313: x_return_status := Fnd_Api.G_Ret_Sts_Error;
314: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
315: Fnd_Msg_Pub.Add;
316: RAISE Fnd_Api.G_Exc_Error;
317:
318: END IF;
319:
320: */

Line 343: RAISE Fnd_Api.G_Exc_Error;

339:
340:
341: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
342:
343: RAISE Fnd_Api.G_Exc_Error;
344:
345: END IF;
346:
347:

Line 355: RAISE Fnd_Api.G_Exc_Error;

351: */
352:
353: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
354:
355: RAISE Fnd_Api.G_Exc_Error;
356:
357: END IF;
358:
359:

Line 364: IF Fnd_Api.To_Boolean(p_validate_only) THEN

360: /*
361: ** Discontinue processing if API invoked in validation mode
362: */
363:
364: IF Fnd_Api.To_Boolean(p_validate_only) THEN
365:
366: RETURN;
367:
368: END IF;

Line 392: IF Fnd_Api.To_Boolean(p_commit) THEN

388: /*
389: ** Commit data if API invoked in commit mode
390: */
391:
392: IF Fnd_Api.To_Boolean(p_commit) THEN
393:
394: COMMIT;
395:
396: END IF;

Line 401: WHEN Fnd_Api.G_Exc_Error THEN

397:
398:
399: EXCEPTION
400:
401: WHEN Fnd_Api.G_Exc_Error THEN
402:
403: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
404:
405: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 405: x_return_status := Fnd_Api.G_Ret_Sts_Error;

401: WHEN Fnd_Api.G_Exc_Error THEN
402:
403: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
404:
405: x_return_status := Fnd_Api.G_Ret_Sts_Error;
406:
407: Fnd_Msg_Pub.Count_And_Get
408: (
409: p_count => x_msg_count,

Line 413: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );
412:
413: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
414:
415: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
416:
417: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 417: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

413: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
414:
415: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
416:
417: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
418:
419: Fnd_Msg_Pub.Count_And_Get
420: (
421: p_count => x_msg_count,

Line 429: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

425: WHEN others THEN
426:
427: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
428:
429: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
430:
431: Fnd_Msg_Pub.Add_Exc_Msg
432: (
433: p_pkg_name => G_PKG_NAME,

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

445: ---------------------------------------------------------------------------
446:
447: PROCEDURE Delete_Sponsor_Action
448: (
449: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
450: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
451: p_commit IN VARCHAR2 := Fnd_Api.G_False,
452: p_rowid IN VARCHAR2,
453: p_proposal_id IN NUMBER,

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

446:
447: PROCEDURE Delete_Sponsor_Action
448: (
449: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
450: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
451: p_commit IN VARCHAR2 := Fnd_Api.G_False,
452: p_rowid IN VARCHAR2,
453: p_proposal_id IN NUMBER,
454: p_record_version_number IN NUMBER,

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

447: PROCEDURE Delete_Sponsor_Action
448: (
449: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
450: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
451: p_commit IN VARCHAR2 := Fnd_Api.G_False,
452: p_rowid IN VARCHAR2,
453: p_proposal_id IN NUMBER,
454: p_record_version_number IN NUMBER,
455: x_return_status OUT NOCOPY VARCHAR2,

Line 477: x_return_status := Fnd_Api.G_Ret_Sts_Success;

473: /*
474: ** Initialize
475: */
476:
477: x_return_status := Fnd_Api.G_Ret_Sts_Success;
478:
479: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
480:
481: Fnd_Msg_Pub.Initialize;

Line 479: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

475: */
476:
477: x_return_status := Fnd_Api.G_Ret_Sts_Success;
478:
479: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
480:
481: Fnd_Msg_Pub.Initialize;
482:
483: END IF;

Line 499: x_return_status := Fnd_Api.G_Ret_Sts_Error;

495: p_user_id => Fnd_Global.User_Id
496: )
497: = 'N' THEN
498:
499: x_return_status := Fnd_Api.G_Ret_Sts_Error;
500: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
501: Fnd_Msg_Pub.Add;
502: RAISE Fnd_Api.G_Exc_Error;
503:

Line 502: RAISE Fnd_Api.G_Exc_Error;

498:
499: x_return_status := Fnd_Api.G_Ret_Sts_Error;
500: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
501: Fnd_Msg_Pub.Add;
502: RAISE Fnd_Api.G_Exc_Error;
503:
504: END IF;
505: */
506:

Line 526: RAISE Fnd_Api.G_Exc_Error;

522: */
523:
524: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
525:
526: RAISE Fnd_Api.G_Exc_Error;
527:
528: END IF;
529:
530:

Line 535: IF Fnd_Api.To_Boolean(p_validate_only) THEN

531: /*
532: ** Discontinue processing if API invoked in validation mode
533: */
534:
535: IF Fnd_Api.To_Boolean(p_validate_only) THEN
536:
537: RETURN;
538:
539: END IF;

Line 558: IF Fnd_Api.To_Boolean(p_commit) THEN

554: /*
555: ** Commit data if API invoked in commit mode
556: */
557:
558: IF Fnd_Api.To_Boolean(p_commit) THEN
559:
560: COMMIT;
561:
562: END IF;

Line 567: WHEN Fnd_Api.G_Exc_Error THEN

563:
564:
565: EXCEPTION
566:
567: WHEN Fnd_Api.G_Exc_Error THEN
568:
569: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
570:
571: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 571: x_return_status := Fnd_Api.G_Ret_Sts_Error;

567: WHEN Fnd_Api.G_Exc_Error THEN
568:
569: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
570:
571: x_return_status := Fnd_Api.G_Ret_Sts_Error;
572:
573: Fnd_Msg_Pub.Count_And_Get
574: (
575: p_count => x_msg_count,

Line 579: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

575: p_count => x_msg_count,
576: p_data => x_msg_data
577: );
578:
579: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
580:
581: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
582:
583: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 583: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

579: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
580:
581: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
582:
583: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
584:
585: Fnd_Msg_Pub.Count_And_Get
586: (
587: p_count => x_msg_count,

Line 595: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

591: WHEN others THEN
592:
593: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
594:
595: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
596:
597: Fnd_Msg_Pub.Add_Exc_Msg
598: (
599: p_pkg_name => G_PKG_NAME,