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.GR_OTHER_NAMES_TL_PKG dependencies on FND_API

Line 78: IF FND_API.To_Boolean(l_key_exists) THEN

74: 'F',
75: l_rowid,
76: l_key_exists);
77:
78: IF FND_API.To_Boolean(l_key_exists) THEN
79: RAISE Item_Exists_Error;
80: END IF;
81:
82: INSERT INTO gr_other_names_tl

Line 118: IF FND_API.To_Boolean(l_key_exists) THEN

114: 'F',
115: l_rowid,
116: l_key_exists);
117:
118: IF FND_API.To_Boolean(l_key_exists) THEN
119: x_rowid := l_rowid;
120: ELSE
121: RAISE Row_Missing_Error;
122: END IF;

Line 126: IF FND_API.To_Boolean(p_commit) THEN

122: END IF;
123:
124: /* Check the commit flag and if set, then commit the work. */
125:
126: IF FND_API.To_Boolean(p_commit) THEN
127: COMMIT WORK;
128: END IF;
129:
130: EXCEPTION

Line 141: IF FND_API.To_Boolean(p_called_by_form) THEN

137: 'GR_FOREIGN_KEY_ERROR');
138: FND_MESSAGE.SET_TOKEN('TEXT',
139: l_msg_data,
140: FALSE);
141: IF FND_API.To_Boolean(p_called_by_form) THEN
142: APP_EXCEPTION.Raise_Exception;
143: ELSE
144: x_msg_data := FND_MESSAGE.Get;
145: END IF;

Line 157: IF FND_API.To_Boolean(p_called_by_form) THEN

153: 'GR_RECORD_EXISTS');
154: FND_MESSAGE.SET_TOKEN('CODE',
155: l_msg_token,
156: FALSE);
157: IF FND_API.To_Boolean(p_called_by_form) THEN
158: APP_EXCEPTION.Raise_Exception;
159: ELSE
160: x_msg_data := FND_MESSAGE.Get;
161: END IF;

Line 173: IF FND_API.To_Boolean(p_called_by_form) THEN

169: 'GR_NO_RECORD_INSERTED');
170: FND_MESSAGE.SET_TOKEN('CODE',
171: l_msg_token,
172: FALSE);
173: IF FND_API.To_Boolean(p_called_by_form) THEN
174: APP_EXCEPTION.Raise_Exception;
175: ELSE
176: x_msg_data := FND_MESSAGE.Get;
177: END IF;

Line 190: IF FND_API.To_Boolean(p_called_by_form) THEN

186: 'GR_UNEXPECTED_ERROR');
187: FND_MESSAGE.SET_TOKEN('TEXT',
188: l_msg_token,
189: FALSE);
190: IF FND_API.To_Boolean(p_called_by_form) THEN
191: APP_EXCEPTION.Raise_Exception;
192: ELSE
193: x_msg_data := FND_MESSAGE.Get;
194: END IF;

Line 279: IF FND_API.To_Boolean(p_commit) THEN

275: END IF;
276:
277: /* Check the commit flag and if set, then commit the work. */
278:
279: IF FND_API.To_Boolean(p_commit) THEN
280: COMMIT WORK;
281: END IF;
282:
283: EXCEPTION

Line 294: IF FND_API.To_Boolean(p_called_by_form) THEN

290: 'GR_FOREIGN_KEY_ERROR');
291: FND_MESSAGE.SET_TOKEN('TEXT',
292: l_msg_data,
293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;
296: ELSE
297: x_msg_data := FND_MESSAGE.Get;
298: END IF;

Line 309: IF FND_API.To_Boolean(p_called_by_form) THEN

305: 'GR_NO_RECORD_INSERTED');
306: FND_MESSAGE.SET_TOKEN('CODE',
307: l_msg_token,
308: FALSE);
309: IF FND_API.To_Boolean(p_called_by_form) THEN
310: APP_EXCEPTION.Raise_Exception;
311: ELSE
312: x_msg_data := FND_MESSAGE.Get;
313: END IF;

Line 325: IF FND_API.To_Boolean(p_called_by_form) THEN

321: 'GR_UNEXPECTED_ERROR');
322: FND_MESSAGE.SET_TOKEN('TEXT',
323: l_msg_token,
324: FALSE);
325: IF FND_API.To_Boolean(p_called_by_form) THEN
326: APP_EXCEPTION.Raise_Exception;
327: ELSE
328: x_msg_data := FND_MESSAGE.Get;
329: END IF;

Line 534: IF FND_API.To_Boolean(p_commit) THEN

530: END LOOP;
531: CLOSE c_get_descs;
532: END IF;
533:
534: IF FND_API.To_Boolean(p_commit) THEN
535: COMMIT WORK;
536: END IF;
537:
538: EXCEPTION

Line 549: IF FND_API.To_Boolean(p_called_by_form) THEN

545: 'GR_RECORD_NOT_FOUND');
546: FND_MESSAGE.SET_TOKEN('CODE',
547: l_msg_token,
548: FALSE);
549: IF FND_API.To_Boolean(p_called_by_form) THEN
550: APP_EXCEPTION.Raise_Exception;
551: ELSE
552: x_msg_data := FND_MESSAGE.Get;
553: END IF;

Line 564: IF FND_API.To_Boolean(p_called_by_form) THEN

560: 'GR_UNEXPECTED_ERROR');
561: FND_MESSAGE.SET_TOKEN('TEXT',
562: l_msg_token,
563: FALSE);
564: IF FND_API.To_Boolean(p_called_by_form) THEN
565: APP_EXCEPTION.Raise_Exception;
566: ELSE
567: x_msg_data := FND_MESSAGE.Get;
568: END IF;

Line 638: IF FND_API.To_Boolean(p_commit) THEN

634: RAISE No_Data_Found_Error;
635: END IF;
636: CLOSE c_lock_other_name_tl;
637:
638: IF FND_API.To_Boolean(p_commit) THEN
639: COMMIT WORK;
640: END IF;
641:
642: EXCEPTION

Line 652: IF FND_API.To_Boolean(p_called_by_form) THEN

648: 'GR_RECORD_NOT_FOUND');
649: FND_MESSAGE.SET_TOKEN('CODE',
650: l_msg_token,
651: FALSE);
652: IF FND_API.To_Boolean(p_called_by_form) THEN
653: APP_EXCEPTION.Raise_Exception;
654: ELSE
655: x_msg_data := FND_MESSAGE.Get;
656: END IF;

Line 664: IF FND_API.To_Boolean(p_called_by_form) THEN

660: x_return_status := 'E';
661: x_oracle_error := APP_EXCEPTION.Get_Code;
662: FND_MESSAGE.SET_NAME('GR',
663: 'GR_ROW_IS_LOCKED');
664: IF FND_API.To_Boolean(p_called_by_form) THEN
665: APP_EXCEPTION.Raise_Exception;
666: ELSE
667: x_msg_data := FND_MESSAGE.Get;
668: END IF;

Line 680: IF FND_API.To_Boolean(p_called_by_form) THEN

676: 'GR_UNEXPECTED_ERROR');
677: FND_MESSAGE.SET_TOKEN('TEXT',
678: l_msg_token,
679: FALSE);
680: IF FND_API.To_Boolean(p_called_by_form) THEN
681: APP_EXCEPTION.Raise_Exception;
682: ELSE
683: x_msg_data := FND_MESSAGE.Get;
684: END IF;

Line 761: IF FND_API.TO_Boolean(p_commit) THEN

757: WHERE rowid = p_rowid;
758:
759: /* Check the commit flag and if set, then commit the work. */
760:
761: IF FND_API.TO_Boolean(p_commit) THEN
762: COMMIT WORK;
763: END IF;
764:
765: EXCEPTION

Line 771: IF FND_API.To_Boolean(p_called_by_form) THEN

767: WHEN Check_Integrity_Error THEN
768: ROLLBACK TO SAVEPOINT Delete_Row;
769: x_return_status := l_return_status;
770: x_oracle_error := l_oracle_error;
771: IF FND_API.To_Boolean(p_called_by_form) THEN
772: APP_EXCEPTION.Raise_Exception;
773: ELSE
774: x_msg_data := FND_MESSAGE.Get;
775: END IF;

Line 786: IF FND_API.To_Boolean(p_called_by_form) THEN

782: 'GR_RECORD_NOT_FOUND');
783: FND_MESSAGE.SET_TOKEN('CODE',
784: l_msg_token,
785: FALSE);
786: IF FND_API.To_Boolean(p_called_by_form) THEN
787: APP_EXCEPTION.Raise_Exception;
788: ELSE
789: x_msg_data := FND_MESSAGE.Get;
790: END IF;

Line 803: IF FND_API.To_Boolean(p_called_by_form) THEN

799: 'GR_UNEXPECTED_ERROR');
800: FND_MESSAGE.SET_TOKEN('TEXT',
801: l_msg_token,
802: FALSE);
803: IF FND_API.To_Boolean(p_called_by_form) THEN
804: APP_EXCEPTION.Raise_Exception;
805: ELSE
806: x_msg_data := FND_MESSAGE.Get;
807: END IF;

Line 888: IF FND_API.To_Boolean(p_commit) THEN

884: AND orgn_code = p_orgn_code;
885: END IF;
886: END IF;
887:
888: IF FND_API.To_Boolean(p_commit) THEN
889: COMMIT WORK;
890: END IF;
891:
892: EXCEPTION

Line 902: IF FND_API.To_Boolean(p_called_by_form) THEN

898: 'GR_NULL_VALUE');
899: FND_MESSAGE.SET_TOKEN('CODE',
900: l_msg_token,
901: FALSE);
902: IF FND_API.To_Boolean(p_called_by_form) THEN
903: APP_EXCEPTION.Raise_Exception;
904: ELSE
905: x_msg_data := FND_MESSAGE.Get;
906: END IF;

Line 918: IF FND_API.To_Boolean(p_called_by_form) THEN

914: 'GR_UNEXPECTED_ERROR');
915: FND_MESSAGE.SET_TOKEN('TEXT',
916: l_msg_token,
917: FALSE);
918: IF FND_API.To_Boolean(p_called_by_form) THEN
919: APP_EXCEPTION.Raise_Exception;
920: ELSE
921: x_msg_data := FND_MESSAGE.Get;
922: END IF;

Line 992: IF NOT FND_API.To_Boolean(l_key_exists) THEN

988: (p_item_code,
989: 'F',
990: l_rowid,
991: l_key_exists);
992: IF NOT FND_API.To_Boolean(l_key_exists) THEN
993: x_return_status := 'E';
994: FND_MESSAGE.SET_NAME('GR',
995: 'GR_RECORD_NOT_FOUND');
996: FND_MESSAGE.SET_TOKEN('CODE',

Line 1130: IF FND_API.To_Boolean(p_called_by_form) THEN

1126: 'GR_INSTALLED_LANG');
1127: FND_MESSAGE.SET_TOKEN('CODE',
1128: p_language,
1129: FALSE);
1130: IF FND_API.To_Boolean(p_called_by_form) THEN
1131: APP_EXCEPTION.Raise_Exception;
1132: ELSE
1133: x_msg_data := FND_MESSAGE.Get;
1134: END IF;

Line 1146: IF FND_API.To_Boolean(p_called_by_form) THEN

1142: 'GR_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('TEXT',
1144: l_msg_data,
1145: FALSE);
1146: IF FND_API.To_Boolean(p_called_by_form) THEN
1147: APP_EXCEPTION.Raise_Exception;
1148: ELSE
1149: x_msg_data := FND_MESSAGE.Get;
1150: END IF;

Line 1212: IF FND_API.To_Boolean(p_called_by_form) THEN

1208: 'GR_UNEXPECTED_ERROR');
1209: FND_MESSAGE.SET_TOKEN('TEXT',
1210: l_msg_data,
1211: FALSE);
1212: IF FND_API.To_Boolean(p_called_by_form) THEN
1213: APP_EXCEPTION.Raise_Exception;
1214: END IF;
1215:
1216: END Check_Primary_Key;