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_PROP_SCIENCE_CODES_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 79: x_return_status := Fnd_Api.G_Ret_Sts_Success;

75: /*
76: ** Initialize
77: */
78:
79: x_return_status := Fnd_Api.G_Ret_Sts_Success;
80:
81: IF p_science_code IS NOT NULL THEN
82:
83: SELECT 'Y'

Line 94: x_return_status := Fnd_Api.G_Ret_Sts_Error;

90: EXCEPTION
91:
92: WHEN no_data_found THEN
93:
94: x_return_status := Fnd_Api.G_Ret_Sts_Error;
95: Fnd_Message.Set_Name('IGW','IGW_SS_KEYWORD_INVALID');
96: Fnd_Msg_Pub.Add;
97:
98: WHEN others THEN

Line 100: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

96: Fnd_Msg_Pub.Add;
97:
98: WHEN others THEN
99:
100: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
101:
102: Fnd_Msg_Pub.Add_Exc_Msg
103: (
104: p_pkg_name => G_PKG_NAME,

Line 108: RAISE Fnd_Api.G_Exc_Unexpected_Error;

104: p_pkg_name => G_PKG_NAME,
105: p_procedure_name => l_api_name
106: );
107:
108: RAISE Fnd_Api.G_Exc_Unexpected_Error;
109:
110: END Validate_Science_Code;
111:
112: ---------------------------------------------------------------------------

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

112: ---------------------------------------------------------------------------
113:
114: PROCEDURE Create_Prop_Science_Code
115: (
116: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
117: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
118: p_commit IN VARCHAR2 := Fnd_Api.G_False,
119: x_rowid OUT NOCOPY VARCHAR2,
120: p_proposal_id IN NUMBER,

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

113:
114: PROCEDURE Create_Prop_Science_Code
115: (
116: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
117: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
118: p_commit IN VARCHAR2 := Fnd_Api.G_False,
119: x_rowid OUT NOCOPY VARCHAR2,
120: p_proposal_id IN NUMBER,
121: p_proposal_number IN VARCHAR2,

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

114: PROCEDURE Create_Prop_Science_Code
115: (
116: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
117: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
118: p_commit IN VARCHAR2 := Fnd_Api.G_False,
119: x_rowid OUT NOCOPY VARCHAR2,
120: p_proposal_id IN NUMBER,
121: p_proposal_number IN VARCHAR2,
122: p_science_code IN VARCHAR2,

Line 150: x_return_status := Fnd_Api.G_Ret_Sts_Success;

146: /*
147: ** Initialize
148: */
149:
150: x_return_status := Fnd_Api.G_Ret_Sts_Success;
151:
152: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
153:
154: Fnd_Msg_Pub.Initialize;

Line 152: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

148: */
149:
150: x_return_status := Fnd_Api.G_Ret_Sts_Success;
151:
152: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
153:
154: Fnd_Msg_Pub.Initialize;
155:
156: END IF;

Line 187: x_return_status := Fnd_Api.G_Ret_Sts_Error;

183: p_user_id => Fnd_Global.User_Id
184: )
185: = 'N' THEN
186:
187: x_return_status := Fnd_Api.G_Ret_Sts_Error;
188: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
189: Fnd_Msg_Pub.Add;
190: RAISE Fnd_Api.G_Exc_Error;
191:

Line 190: RAISE Fnd_Api.G_Exc_Error;

186:
187: x_return_status := Fnd_Api.G_Ret_Sts_Error;
188: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
189: Fnd_Msg_Pub.Add;
190: RAISE Fnd_Api.G_Exc_Error;
191:
192: END IF;
193: */
194:

Line 219: RAISE Fnd_Api.G_Exc_Error;

215: */
216:
217: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
218:
219: RAISE Fnd_Api.G_Exc_Error;
220:
221: END IF;
222:
223:

Line 232: x_return_status := Fnd_Api.G_Ret_Sts_Error;

228: AND science_code = l_science_code;
229:
230: IF l_count > 0 THEN
231:
232: x_return_status := Fnd_Api.G_Ret_Sts_Error;
233: Fnd_Message.Set_Name('IGW','IGW_SS_KEYWORD_ALREADY_EXISTS');
234: Fnd_Msg_Pub.Add;
235: RAISE Fnd_Api.G_Exc_Error;
236:

Line 235: RAISE Fnd_Api.G_Exc_Error;

231:
232: x_return_status := Fnd_Api.G_Ret_Sts_Error;
233: Fnd_Message.Set_Name('IGW','IGW_SS_KEYWORD_ALREADY_EXISTS');
234: Fnd_Msg_Pub.Add;
235: RAISE Fnd_Api.G_Exc_Error;
236:
237: END IF;
238:
239:

Line 245: IF Fnd_Api.To_Boolean(p_validate_only) THEN

241: /*
242: ** Discontinue processing if API invoked in validation mode
243: */
244:
245: IF Fnd_Api.To_Boolean(p_validate_only) THEN
246:
247: RETURN;
248:
249: END IF;

Line 269: IF Fnd_Api.To_Boolean(p_commit) THEN

265: /*
266: ** Commit data if API invoked in commit mode
267: */
268:
269: IF Fnd_Api.To_Boolean(p_commit) THEN
270:
271: COMMIT;
272:
273: END IF;

Line 278: WHEN Fnd_Api.G_Exc_Error THEN

274:
275:
276: EXCEPTION
277:
278: WHEN Fnd_Api.G_Exc_Error THEN
279:
280: ROLLBACK TO Create_Prop_Science_Code_Pvt;
281:
282: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 282: x_return_status := Fnd_Api.G_Ret_Sts_Error;

278: WHEN Fnd_Api.G_Exc_Error THEN
279:
280: ROLLBACK TO Create_Prop_Science_Code_Pvt;
281:
282: x_return_status := Fnd_Api.G_Ret_Sts_Error;
283:
284: Fnd_Msg_Pub.Count_And_Get
285: (
286: p_count => x_msg_count,

Line 290: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

286: p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289:
290: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
291:
292: ROLLBACK TO Create_Prop_Science_Code_Pvt;
293:
294: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 294: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

290: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
291:
292: ROLLBACK TO Create_Prop_Science_Code_Pvt;
293:
294: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
295:
296: Fnd_Msg_Pub.Count_And_Get
297: (
298: p_count => x_msg_count,

Line 306: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

302: WHEN others THEN
303:
304: ROLLBACK TO Create_Prop_Science_Code_Pvt;
305:
306: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
307:
308: Fnd_Msg_Pub.Add_Exc_Msg
309: (
310: p_pkg_name => G_PKG_NAME,

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

322: ---------------------------------------------------------------------------
323:
324: PROCEDURE Update_Prop_Science_Code
325: (
326: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
327: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
328: p_commit IN VARCHAR2 := Fnd_Api.G_False,
329: p_rowid IN VARCHAR2,
330: p_proposal_id IN NUMBER,

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

323:
324: PROCEDURE Update_Prop_Science_Code
325: (
326: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
327: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
328: p_commit IN VARCHAR2 := Fnd_Api.G_False,
329: p_rowid IN VARCHAR2,
330: p_proposal_id IN NUMBER,
331: p_proposal_number IN VARCHAR2,

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

324: PROCEDURE Update_Prop_Science_Code
325: (
326: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
327: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
328: p_commit IN VARCHAR2 := Fnd_Api.G_False,
329: p_rowid IN VARCHAR2,
330: p_proposal_id IN NUMBER,
331: p_proposal_number IN VARCHAR2,
332: p_science_code IN VARCHAR2,

Line 361: x_return_status := Fnd_Api.G_Ret_Sts_Success;

357: /*
358: ** Initialize
359: */
360:
361: x_return_status := Fnd_Api.G_Ret_Sts_Success;
362:
363: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
364:
365: Fnd_Msg_Pub.Initialize;

Line 363: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

359: */
360:
361: x_return_status := Fnd_Api.G_Ret_Sts_Success;
362:
363: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
364:
365: Fnd_Msg_Pub.Initialize;
366:
367: END IF;

Line 390: RAISE Fnd_Api.G_Exc_Error;

386: END IF;
387:
388: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
389:
390: RAISE Fnd_Api.G_Exc_Error;
391:
392: END IF;
393:
394:

Line 408: x_return_status := Fnd_Api.G_Ret_Sts_Error;

404: p_user_id => Fnd_Global.User_Id
405: )
406: = 'N' THEN
407:
408: x_return_status := Fnd_Api.G_Ret_Sts_Error;
409: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
410: Fnd_Msg_Pub.Add;
411: RAISE Fnd_Api.G_Exc_Error;
412:

Line 411: RAISE Fnd_Api.G_Exc_Error;

407:
408: x_return_status := Fnd_Api.G_Ret_Sts_Error;
409: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
410: Fnd_Msg_Pub.Add;
411: RAISE Fnd_Api.G_Exc_Error;
412:
413: END IF;
414:
415: */

Line 438: RAISE Fnd_Api.G_Exc_Error;

434:
435:
436: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
437:
438: RAISE Fnd_Api.G_Exc_Error;
439:
440: END IF;
441:
442:

Line 468: RAISE Fnd_Api.G_Exc_Error;

464: */
465:
466: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
467:
468: RAISE Fnd_Api.G_Exc_Error;
469:
470: END IF;
471:
472: SELECT count(1)

Line 481: x_return_status := Fnd_Api.G_Ret_Sts_Error;

477: AND science_code = l_science_code;
478:
479: IF l_count > 0 THEN
480:
481: x_return_status := Fnd_Api.G_Ret_Sts_Error;
482: Fnd_Message.Set_Name('IGW','IGW_SS_KEYWORD_ALREADY_EXISTS');
483: Fnd_Msg_Pub.Add;
484: RAISE Fnd_Api.G_Exc_Error;
485:

Line 484: RAISE Fnd_Api.G_Exc_Error;

480:
481: x_return_status := Fnd_Api.G_Ret_Sts_Error;
482: Fnd_Message.Set_Name('IGW','IGW_SS_KEYWORD_ALREADY_EXISTS');
483: Fnd_Msg_Pub.Add;
484: RAISE Fnd_Api.G_Exc_Error;
485:
486: END IF;
487:
488: /*

Line 492: IF Fnd_Api.To_Boolean(p_validate_only) THEN

488: /*
489: ** Discontinue processing if API invoked in validation mode
490: */
491:
492: IF Fnd_Api.To_Boolean(p_validate_only) THEN
493:
494: RETURN;
495:
496: END IF;

Line 517: IF Fnd_Api.To_Boolean(p_commit) THEN

513: /*
514: ** Commit data if API invoked in commit mode
515: */
516:
517: IF Fnd_Api.To_Boolean(p_commit) THEN
518:
519: COMMIT;
520:
521: END IF;

Line 526: WHEN Fnd_Api.G_Exc_Error THEN

522:
523:
524: EXCEPTION
525:
526: WHEN Fnd_Api.G_Exc_Error THEN
527:
528: ROLLBACK TO Update_Prop_Science_Code_Pvt;
529:
530: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 530: x_return_status := Fnd_Api.G_Ret_Sts_Error;

526: WHEN Fnd_Api.G_Exc_Error THEN
527:
528: ROLLBACK TO Update_Prop_Science_Code_Pvt;
529:
530: x_return_status := Fnd_Api.G_Ret_Sts_Error;
531:
532: Fnd_Msg_Pub.Count_And_Get
533: (
534: p_count => x_msg_count,

Line 538: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

534: p_count => x_msg_count,
535: p_data => x_msg_data
536: );
537:
538: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
539:
540: ROLLBACK TO Update_Prop_Science_Code_Pvt;
541:
542: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 542: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

538: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
539:
540: ROLLBACK TO Update_Prop_Science_Code_Pvt;
541:
542: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
543:
544: Fnd_Msg_Pub.Count_And_Get
545: (
546: p_count => x_msg_count,

Line 554: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

550: WHEN others THEN
551:
552: ROLLBACK TO Update_Prop_Science_Code_Pvt;
553:
554: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
555:
556: Fnd_Msg_Pub.Add_Exc_Msg
557: (
558: p_pkg_name => G_PKG_NAME,

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

570: ---------------------------------------------------------------------------
571:
572: PROCEDURE Delete_Prop_Science_Code
573: (
574: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
575: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
576: p_commit IN VARCHAR2 := Fnd_Api.G_False,
577: p_rowid IN VARCHAR2,
578: p_proposal_id IN NUMBER,

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

571:
572: PROCEDURE Delete_Prop_Science_Code
573: (
574: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
575: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
576: p_commit IN VARCHAR2 := Fnd_Api.G_False,
577: p_rowid IN VARCHAR2,
578: p_proposal_id IN NUMBER,
579: p_record_version_number IN NUMBER,

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

572: PROCEDURE Delete_Prop_Science_Code
573: (
574: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
575: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
576: p_commit IN VARCHAR2 := Fnd_Api.G_False,
577: p_rowid IN VARCHAR2,
578: p_proposal_id IN NUMBER,
579: p_record_version_number IN NUMBER,
580: x_return_status OUT NOCOPY VARCHAR2,

Line 602: x_return_status := Fnd_Api.G_Ret_Sts_Success;

598: /*
599: ** Initialize
600: */
601:
602: x_return_status := Fnd_Api.G_Ret_Sts_Success;
603:
604: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
605:
606: Fnd_Msg_Pub.Initialize;

Line 604: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

600: */
601:
602: x_return_status := Fnd_Api.G_Ret_Sts_Success;
603:
604: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
605:
606: Fnd_Msg_Pub.Initialize;
607:
608: END IF;

Line 624: x_return_status := Fnd_Api.G_Ret_Sts_Error;

620: p_user_id => Fnd_Global.User_Id
621: )
622: = 'N' THEN
623:
624: x_return_status := Fnd_Api.G_Ret_Sts_Error;
625: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
626: Fnd_Msg_Pub.Add;
627: RAISE Fnd_Api.G_Exc_Error;
628:

Line 627: RAISE Fnd_Api.G_Exc_Error;

623:
624: x_return_status := Fnd_Api.G_Ret_Sts_Error;
625: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
626: Fnd_Msg_Pub.Add;
627: RAISE Fnd_Api.G_Exc_Error;
628:
629: END IF;
630: */
631:

Line 650: RAISE Fnd_Api.G_Exc_Error;

646: */
647:
648: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
649:
650: RAISE Fnd_Api.G_Exc_Error;
651:
652: END IF;
653:
654:

Line 659: IF Fnd_Api.To_Boolean(p_validate_only) THEN

655: /*
656: ** Discontinue processing if API invoked in validation mode
657: */
658:
659: IF Fnd_Api.To_Boolean(p_validate_only) THEN
660:
661: RETURN;
662:
663: END IF;

Line 681: IF Fnd_Api.To_Boolean(p_commit) THEN

677: /*
678: ** Commit data if API invoked in commit mode
679: */
680:
681: IF Fnd_Api.To_Boolean(p_commit) THEN
682:
683: COMMIT;
684:
685: END IF;

Line 690: WHEN Fnd_Api.G_Exc_Error THEN

686:
687:
688: EXCEPTION
689:
690: WHEN Fnd_Api.G_Exc_Error THEN
691:
692: ROLLBACK TO Delete_Prop_Science_Code_Pvt;
693:
694: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 694: x_return_status := Fnd_Api.G_Ret_Sts_Error;

690: WHEN Fnd_Api.G_Exc_Error THEN
691:
692: ROLLBACK TO Delete_Prop_Science_Code_Pvt;
693:
694: x_return_status := Fnd_Api.G_Ret_Sts_Error;
695:
696: Fnd_Msg_Pub.Count_And_Get
697: (
698: p_count => x_msg_count,

Line 702: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

698: p_count => x_msg_count,
699: p_data => x_msg_data
700: );
701:
702: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
703:
704: ROLLBACK TO Delete_Prop_Science_Code_Pvt;
705:
706: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 706: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

702: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
703:
704: ROLLBACK TO Delete_Prop_Science_Code_Pvt;
705:
706: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
707:
708: Fnd_Msg_Pub.Count_And_Get
709: (
710: p_count => x_msg_count,

Line 718: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

714: WHEN others THEN
715:
716: ROLLBACK TO Delete_Prop_Science_Code_Pvt;
717:
718: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
719:
720: Fnd_Msg_Pub.Add_Exc_Msg
721: (
722: p_pkg_name => G_PKG_NAME,