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_SPECIAL_REVIEWS_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:
30: IF p_rowid IS NULL THEN
31:

Line 39: x_return_status:= FND_API.G_RET_STS_ERROR;

35: */
36:
37: IF p_approval_type_code='2' then
38: IF (p_approval_date IS NULL) then
39: x_return_status:= FND_API.G_RET_STS_ERROR;
40: FND_MESSAGE.SET_NAME('IGW','IGW_PROP_REV_APPDATE_REQ');
41: ELSE
42: IF (p_protocol_number IS NULL) then
43: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 43: x_return_status:=FND_API.G_RET_STS_ERROR;

39: x_return_status:= FND_API.G_RET_STS_ERROR;
40: FND_MESSAGE.SET_NAME('IGW','IGW_PROP_REV_APPDATE_REQ');
41: ELSE
42: IF (p_protocol_number IS NULL) then
43: x_return_status:=FND_API.G_RET_STS_ERROR;
44: FND_MESSAGE.SET_NAME('IGW','IGW_PROP_REV_PROTNO_REQ');
45: ELSE
46: return;
47: END IF;

Line 52: x_return_status:= FND_API.G_RET_STS_ERROR;

48: END IF;
49:
50: ELSIF p_approval_type_code='1' then
51: IF (p_application_date IS NULL) then
52: x_return_status:= FND_API.G_RET_STS_ERROR;
53: FND_MESSAGE.SET_NAME('IGW','IGW_PROP_REV_APPLDATE_REQ');
54: ELSE
55: return;
56: END IF;

Line 65: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

61: EXCEPTION
62:
63: WHEN others THEN
64:
65: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
66:
67: Fnd_Msg_Pub.Add_Exc_Msg
68: (
69: p_pkg_name => G_PKG_NAME,

Line 73: RAISE Fnd_Api.G_Exc_Unexpected_Error;

69: p_pkg_name => G_PKG_NAME,
70: p_procedure_name => l_api_name
71: );
72:
73: RAISE Fnd_Api.G_Exc_Unexpected_Error;
74:
75: END Check_Ins_Upd_Dep_Data;
76:
77: ---------------------------------------------------------------------------

Line 97: x_return_status := Fnd_Api.G_Ret_Sts_Success;

93: /*
94: ** Initialize
95: */
96:
97: x_return_status := Fnd_Api.G_Ret_Sts_Success;
98:
99: IF p_rowid IS NOT NULL AND p_record_version_number IS NOT NULL THEN
100:
101: SELECT 'N'

Line 113: x_return_status := Fnd_Api.G_Ret_Sts_Error;

109: EXCEPTION
110:
111: WHEN no_data_found THEN
112:
113: x_return_status := Fnd_Api.G_Ret_Sts_Error;
114: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
115: Fnd_Msg_Pub.Add;
116:
117: WHEN others THEN

Line 119: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

115: Fnd_Msg_Pub.Add;
116:
117: WHEN others THEN
118:
119: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
120:
121: Fnd_Msg_Pub.Add_Exc_Msg
122: (
123: p_pkg_name => G_PKG_NAME,

Line 127: RAISE Fnd_Api.G_Exc_Unexpected_Error;

123: p_pkg_name => G_PKG_NAME,
124: p_procedure_name => l_api_name
125: );
126:
127: RAISE Fnd_Api.G_Exc_Unexpected_Error;
128:
129: END Check_Lock;
130:
131: ---------------------------------------------------------------------------

Line 177: x_return_status := Fnd_Api.G_Ret_Sts_Success;

173: /*
174: ** Initialize
175: */
176:
177: x_return_status := Fnd_Api.G_Ret_Sts_Success;
178:
179: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
180:
181: Fnd_Msg_Pub.Initialize;

Line 179: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

175: */
176:
177: x_return_status := Fnd_Api.G_Ret_Sts_Success;
178:
179: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
180:
181: Fnd_Msg_Pub.Initialize;
182:
183: END IF;

Line 213: x_return_status := Fnd_Api.G_Ret_Sts_Error;

209: p_user_id => Fnd_Global.User_Id
210: )
211: = 'N' THEN
212:
213: x_return_status := Fnd_Api.G_Ret_Sts_Error;
214: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
215: Fnd_Msg_Pub.Add;
216: RAISE Fnd_Api.G_Exc_Error;
217:

Line 216: RAISE Fnd_Api.G_Exc_Error;

212:
213: x_return_status := Fnd_Api.G_Ret_Sts_Error;
214: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
215: Fnd_Msg_Pub.Add;
216: RAISE Fnd_Api.G_Exc_Error;
217:
218: END IF;
219:
220:

Line 272: RAISE Fnd_Api.G_Exc_Error;

268: */
269:
270: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
271:
272: RAISE Fnd_Api.G_Exc_Error;
273:
274: END IF;
275:
276: Check_Ins_Upd_Dep_Data

Line 287: RAISE Fnd_Api.G_Exc_Error;

283: );
284:
285: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
286:
287: RAISE Fnd_Api.G_Exc_Error;
288:
289: END IF;
290:
291:

Line 296: IF Fnd_Api.To_Boolean(p_validate_only) THEN

292: /*
293: ** Discontinue processing if API invoked in validation mode
294: */
295:
296: IF Fnd_Api.To_Boolean(p_validate_only) THEN
297:
298: RETURN;
299:
300: END IF;

Line 327: IF Fnd_Api.To_Boolean(p_commit) THEN

323: /*
324: ** Commit data if API invoked in commit mode
325: */
326:
327: IF Fnd_Api.To_Boolean(p_commit) THEN
328:
329: COMMIT;
330:
331: END IF;

Line 336: WHEN Fnd_Api.G_Exc_Error THEN

332:
333:
334: EXCEPTION
335:
336: WHEN Fnd_Api.G_Exc_Error THEN
337:
338: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
339:
340: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 340: x_return_status := Fnd_Api.G_Ret_Sts_Error;

336: WHEN Fnd_Api.G_Exc_Error THEN
337:
338: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
339:
340: x_return_status := Fnd_Api.G_Ret_Sts_Error;
341:
342: Fnd_Msg_Pub.Count_And_Get
343: (
344: p_count => x_msg_count,

Line 348: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

344: p_count => x_msg_count,
345: p_data => x_msg_data
346: );
347:
348: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
349:
350: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
351:
352: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 352: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

348: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
349:
350: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
351:
352: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
353:
354: Fnd_Msg_Pub.Count_And_Get
355: (
356: p_count => x_msg_count,

Line 364: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

360: WHEN others THEN
361:
362: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
363:
364: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
365:
366: Fnd_Msg_Pub.Add_Exc_Msg
367: (
368: p_pkg_name => G_PKG_NAME,

Line 428: x_return_status := Fnd_Api.G_Ret_Sts_Success;

424: /*
425: ** Initialize
426: */
427:
428: x_return_status := Fnd_Api.G_Ret_Sts_Success;
429:
430: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
431:
432: Fnd_Msg_Pub.Initialize;

Line 430: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

426: */
427:
428: x_return_status := Fnd_Api.G_Ret_Sts_Success;
429:
430: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
431:
432: Fnd_Msg_Pub.Initialize;
433:
434: END IF;

Line 456: RAISE Fnd_Api.G_Exc_Error;

452:
453:
454: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
455:
456: RAISE Fnd_Api.G_Exc_Error;
457:
458: END IF;
459: */
460:

Line 474: x_return_status := Fnd_Api.G_Ret_Sts_Error;

470: p_user_id => Fnd_Global.User_Id
471: )
472: = 'N' THEN
473:
474: x_return_status := Fnd_Api.G_Ret_Sts_Error;
475: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
476: Fnd_Msg_Pub.Add;
477: RAISE Fnd_Api.G_Exc_Error;
478:

Line 477: RAISE Fnd_Api.G_Exc_Error;

473:
474: x_return_status := Fnd_Api.G_Ret_Sts_Error;
475: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
476: Fnd_Msg_Pub.Add;
477: RAISE Fnd_Api.G_Exc_Error;
478:
479: END IF;
480:
481: */

Line 504: RAISE Fnd_Api.G_Exc_Error;

500:
501:
502: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
503:
504: RAISE Fnd_Api.G_Exc_Error;
505:
506: END IF;
507:
508: /*

Line 558: RAISE Fnd_Api.G_Exc_Error;

554: */
555:
556: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
557:
558: RAISE Fnd_Api.G_Exc_Error;
559:
560: END IF;
561:
562: Check_Ins_Upd_Dep_Data

Line 573: RAISE Fnd_Api.G_Exc_Error;

569: );
570:
571: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
572:
573: RAISE Fnd_Api.G_Exc_Error;
574:
575: END IF;
576:
577:

Line 582: IF Fnd_Api.To_Boolean(p_validate_only) THEN

578: /*
579: ** Discontinue processing if API invoked in validation mode
580: */
581:
582: IF Fnd_Api.To_Boolean(p_validate_only) THEN
583:
584: RETURN;
585:
586: END IF;

Line 614: IF Fnd_Api.To_Boolean(p_commit) THEN

610: /*
611: ** Commit data if API invoked in commit mode
612: */
613:
614: IF Fnd_Api.To_Boolean(p_commit) THEN
615:
616: COMMIT;
617:
618: END IF;

Line 623: WHEN Fnd_Api.G_Exc_Error THEN

619:
620:
621: EXCEPTION
622:
623: WHEN Fnd_Api.G_Exc_Error THEN
624:
625: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
626:
627: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 627: x_return_status := Fnd_Api.G_Ret_Sts_Error;

623: WHEN Fnd_Api.G_Exc_Error THEN
624:
625: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
626:
627: x_return_status := Fnd_Api.G_Ret_Sts_Error;
628:
629: Fnd_Msg_Pub.Count_And_Get
630: (
631: p_count => x_msg_count,

Line 635: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634:
635: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
636:
637: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
638:
639: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 639: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

635: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
636:
637: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
638:
639: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
640:
641: Fnd_Msg_Pub.Count_And_Get
642: (
643: p_count => x_msg_count,

Line 651: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

647: WHEN others THEN
648:
649: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
650:
651: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
652:
653: Fnd_Msg_Pub.Add_Exc_Msg
654: (
655: p_pkg_name => G_PKG_NAME,

Line 699: x_return_status := Fnd_Api.G_Ret_Sts_Success;

695: /*
696: ** Initialize
697: */
698:
699: x_return_status := Fnd_Api.G_Ret_Sts_Success;
700:
701: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
702:
703: Fnd_Msg_Pub.Initialize;

Line 701: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

697: */
698:
699: x_return_status := Fnd_Api.G_Ret_Sts_Success;
700:
701: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
702:
703: Fnd_Msg_Pub.Initialize;
704:
705: END IF;

Line 721: x_return_status := Fnd_Api.G_Ret_Sts_Error;

717: p_user_id => Fnd_Global.User_Id
718: )
719: = 'N' THEN
720:
721: x_return_status := Fnd_Api.G_Ret_Sts_Error;
722: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
723: Fnd_Msg_Pub.Add;
724: RAISE Fnd_Api.G_Exc_Error;
725:

Line 724: RAISE Fnd_Api.G_Exc_Error;

720:
721: x_return_status := Fnd_Api.G_Ret_Sts_Error;
722: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
723: Fnd_Msg_Pub.Add;
724: RAISE Fnd_Api.G_Exc_Error;
725:
726: END IF;
727: */
728:

Line 747: RAISE Fnd_Api.G_Exc_Error;

743: */
744:
745: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
746:
747: RAISE Fnd_Api.G_Exc_Error;
748:
749: END IF;
750:
751:

Line 756: IF Fnd_Api.To_Boolean(p_validate_only) THEN

752: /*
753: ** Discontinue processing if API invoked in validation mode
754: */
755:
756: IF Fnd_Api.To_Boolean(p_validate_only) THEN
757:
758: RETURN;
759:
760: END IF;

Line 778: IF Fnd_Api.To_Boolean(p_commit) THEN

774: /*
775: ** Commit data if API invoked in commit mode
776: */
777:
778: IF Fnd_Api.To_Boolean(p_commit) THEN
779:
780: COMMIT;
781:
782: END IF;

Line 787: WHEN Fnd_Api.G_Exc_Error THEN

783:
784:
785: EXCEPTION
786:
787: WHEN Fnd_Api.G_Exc_Error THEN
788:
789: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
790:
791: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 791: x_return_status := Fnd_Api.G_Ret_Sts_Error;

787: WHEN Fnd_Api.G_Exc_Error THEN
788:
789: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
790:
791: x_return_status := Fnd_Api.G_Ret_Sts_Error;
792:
793: Fnd_Msg_Pub.Count_And_Get
794: (
795: p_count => x_msg_count,

Line 799: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798:
799: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
800:
801: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
802:
803: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 803: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

799: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
800:
801: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
802:
803: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
804:
805: Fnd_Msg_Pub.Count_And_Get
806: (
807: p_count => x_msg_count,

Line 815: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

811: WHEN others THEN
812:
813: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
814:
815: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
816:
817: Fnd_Msg_Pub.Add_Exc_Msg
818: (
819: p_pkg_name => G_PKG_NAME,