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_TOXIC_SPECIES_TL_PKG dependencies on FND_API

Line 73: IF FND_API.To_Boolean(l_key_exists) THEN

69: 'F',
70: l_rowid,
71: l_key_exists);
72:
73: IF FND_API.To_Boolean(l_key_exists) THEN
74: RAISE Item_Exists_Error;
75: END IF;
76:
77: INSERT INTO gr_toxic_species_tl

Line 107: IF FND_API.To_Boolean(l_key_exists) THEN

103: 'F',
104: l_rowid,
105: l_key_exists);
106:
107: IF FND_API.To_Boolean(l_key_exists) THEN
108: x_rowid := l_rowid;
109: ELSE
110: RAISE Row_Missing_Error;
111: END IF;

Line 115: IF FND_API.To_Boolean(p_commit) THEN

111: END IF;
112:
113: /* Check the commit flag and if set, then commit the work. */
114:
115: IF FND_API.To_Boolean(p_commit) THEN
116: COMMIT WORK;
117: END IF;
118:
119: EXCEPTION

Line 130: IF FND_API.To_Boolean(p_called_by_form) THEN

126: 'GR_FOREIGN_KEY_ERROR');
127: FND_MESSAGE.SET_TOKEN('TEXT',
128: l_msg_data,
129: FALSE);
130: IF FND_API.To_Boolean(p_called_by_form) THEN
131: APP_EXCEPTION.Raise_Exception;
132: ELSE
133: x_msg_data := FND_MESSAGE.Get;
134: END IF;

Line 146: IF FND_API.To_Boolean(p_called_by_form) THEN

142: 'GR_RECORD_EXISTS');
143: FND_MESSAGE.SET_TOKEN('CODE',
144: l_msg_token,
145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;
148: ELSE
149: x_msg_data := FND_MESSAGE.Get;
150: END IF;

Line 162: IF FND_API.To_Boolean(p_called_by_form) THEN

158: 'GR_NO_RECORD_INSERTED');
159: FND_MESSAGE.SET_TOKEN('CODE',
160: l_msg_token,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;
164: ELSE
165: x_msg_data := FND_MESSAGE.Get;
166: END IF;

Line 179: IF FND_API.To_Boolean(p_called_by_form) THEN

175: 'GR_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('TEXT',
177: l_msg_token,
178: FALSE);
179: IF FND_API.To_Boolean(p_called_by_form) THEN
180: APP_EXCEPTION.Raise_Exception;
181: ELSE
182: x_msg_data := FND_MESSAGE.Get;
183: END IF;

Line 262: IF FND_API.To_Boolean(p_commit) THEN

258: END IF;
259:
260: /* Check the commit flag and if set, then commit the work. */
261:
262: IF FND_API.To_Boolean(p_commit) THEN
263: COMMIT WORK;
264: END IF;
265:
266: EXCEPTION

Line 277: IF FND_API.To_Boolean(p_called_by_form) THEN

273: 'GR_FOREIGN_KEY_ERROR');
274: FND_MESSAGE.SET_TOKEN('TEXT',
275: l_msg_data,
276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;
279: ELSE
280: x_msg_data := FND_MESSAGE.Get;
281: END IF;

Line 292: IF FND_API.To_Boolean(p_called_by_form) THEN

288: 'GR_NO_RECORD_INSERTED');
289: FND_MESSAGE.SET_TOKEN('CODE',
290: l_msg_token,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;
294: ELSE
295: x_msg_data := FND_MESSAGE.Get;
296: END IF;

Line 308: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 475: IF FND_API.To_Boolean(p_commit) THEN

471: END LOOP;
472: END IF;
473: CLOSE c_get_installed_languages;
474:
475: IF FND_API.To_Boolean(p_commit) THEN
476: COMMIT WORK;
477: END IF;
478:
479: EXCEPTION

Line 490: IF FND_API.To_Boolean(p_called_by_form) THEN

486: 'GR_RECORD_NOT_FOUND');
487: FND_MESSAGE.SET_TOKEN('CODE',
488: l_msg_token,
489: FALSE);
490: IF FND_API.To_Boolean(p_called_by_form) THEN
491: APP_EXCEPTION.Raise_Exception;
492: ELSE
493: x_msg_data := FND_MESSAGE.Get;
494: END IF;

Line 506: IF FND_API.To_Boolean(p_called_by_form) THEN

502: 'GR_UNEXPECTED_ERROR');
503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_token,
505: FALSE);
506: IF FND_API.To_Boolean(p_called_by_form) THEN
507: APP_EXCEPTION.Raise_Exception;
508: ELSE
509: x_msg_data := FND_MESSAGE.Get;
510: END IF;

Line 582: IF FND_API.To_Boolean(p_commit) THEN

578: IF LockSpeciesRcd.last_update_date <> p_last_update_date THEN
579: RAISE RECORD_CHANGED_ERROR;
580: END IF;
581:
582: IF FND_API.To_Boolean(p_commit) THEN
583: COMMIT WORK;
584: END IF;
585:
586: EXCEPTION

Line 596: IF FND_API.To_Boolean(p_called_by_form) THEN

592: 'GR_RECORD_NOT_FOUND');
593: FND_MESSAGE.SET_TOKEN('CODE',
594: l_msg_token,
595: FALSE);
596: IF FND_API.To_Boolean(p_called_by_form) THEN
597: APP_EXCEPTION.Raise_Exception;
598: ELSE
599: x_msg_data := FND_MESSAGE.Get;
600: END IF;

Line 607: IF FND_API.To_Boolean(p_called_by_form) THEN

603: ROLLBACK TO SAVEPOINT Lock_Row;
604: X_return_status := 'E';
605: FND_MESSAGE.SET_NAME('FND',
606: 'FORM_RECORD_CHANGED');
607: IF FND_API.To_Boolean(p_called_by_form) THEN
608: APP_EXCEPTION.Raise_Exception;
609: ELSE
610: x_msg_data := FND_MESSAGE.Get;
611: END IF;

Line 616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

612: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
613: ROLLBACK TO SAVEPOINT Lock_Row;
614: x_return_status := 'L';
615: x_oracle_error := APP_EXCEPTION.Get_Code;
616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
617: FND_MESSAGE.SET_NAME('GR',
618: 'GR_ROW_IS_LOCKED');
619: x_msg_data := FND_MESSAGE.Get;
620: END IF;

Line 632: IF FND_API.To_Boolean(p_called_by_form) THEN

628: 'GR_UNEXPECTED_ERROR');
629: FND_MESSAGE.SET_TOKEN('TEXT',
630: l_msg_token,
631: FALSE);
632: IF FND_API.To_Boolean(p_called_by_form) THEN
633: APP_EXCEPTION.Raise_Exception;
634: ELSE
635: x_msg_data := FND_MESSAGE.Get;
636: END IF;

Line 709: IF FND_API.TO_Boolean(p_commit) THEN

705: WHERE rowid = p_rowid;
706:
707: /* Check the commit flag and if set, then commit the work. */
708:
709: IF FND_API.TO_Boolean(p_commit) THEN
710: COMMIT WORK;
711: END IF;
712:
713: EXCEPTION

Line 719: IF FND_API.To_Boolean(p_called_by_form) THEN

715: WHEN Check_Integrity_Error THEN
716: ROLLBACK TO SAVEPOINT Delete_Row;
717: x_return_status := l_return_status;
718: x_oracle_error := l_oracle_error;
719: IF FND_API.To_Boolean(p_called_by_form) THEN
720: APP_EXCEPTION.Raise_Exception;
721: ELSE
722: x_msg_data := FND_MESSAGE.Get;
723: END IF;

Line 734: IF FND_API.To_Boolean(p_called_by_form) THEN

730: 'GR_RECORD_NOT_FOUND');
731: FND_MESSAGE.SET_TOKEN('CODE',
732: l_msg_token,
733: FALSE);
734: IF FND_API.To_Boolean(p_called_by_form) THEN
735: APP_EXCEPTION.Raise_Exception;
736: ELSE
737: x_msg_data := FND_MESSAGE.Get;
738: END IF;

Line 750: IF FND_API.To_Boolean(p_called_by_form) THEN

746: 'GR_UNEXPECTED_ERROR');
747: FND_MESSAGE.SET_TOKEN('TEXT',
748: l_msg_token,
749: FALSE);
750: IF FND_API.To_Boolean(p_called_by_form) THEN
751: APP_EXCEPTION.Raise_Exception;
752: ELSE
753: x_msg_data := FND_MESSAGE.Get;
754: END IF;

Line 792: IF FND_API.To_Boolean(p_commit) THEN

788:
789: DELETE FROM gr_toxic_species_tl
790: WHERE toxic_species_code = p_toxic_species_code;
791:
792: IF FND_API.To_Boolean(p_commit) THEN
793: COMMIT WORK;
794: END IF;
795:
796: EXCEPTION

Line 808: IF FND_API.To_Boolean(p_called_by_form) THEN

804: 'GR_UNEXPECTED_ERROR');
805: FND_MESSAGE.SET_TOKEN('TEXT',
806: l_msg_token,
807: FALSE);
808: IF FND_API.To_Boolean(p_called_by_form) THEN
809: APP_EXCEPTION.Raise_Exception;
810: ELSE
811: x_msg_data := FND_MESSAGE.Get;
812: END IF;

Line 975: IF FND_API.To_Boolean(p_called_by_form) THEN

971: 'GR_INSTALLED_LANG');
972: FND_MESSAGE.SET_TOKEN('CODE',
973: p_language,
974: FALSE);
975: IF FND_API.To_Boolean(p_called_by_form) THEN
976: APP_EXCEPTION.Raise_Exception;
977: ELSE
978: x_msg_data := FND_MESSAGE.Get;
979: END IF;

Line 991: IF FND_API.To_Boolean(p_called_by_form) THEN

987: 'GR_UNEXPECTED_ERROR');
988: FND_MESSAGE.SET_TOKEN('TEXT',
989: l_msg_data,
990: FALSE);
991: IF FND_API.To_Boolean(p_called_by_form) THEN
992: APP_EXCEPTION.Raise_Exception;
993: ELSE
994: x_msg_data := FND_MESSAGE.Get;
995: END IF;

Line 1051: IF FND_API.To_Boolean(p_called_by_form) THEN

1047: 'GR_UNEXPECTED_ERROR');
1048: FND_MESSAGE.SET_TOKEN('TEXT',
1049: l_msg_data,
1050: FALSE);
1051: IF FND_API.To_Boolean(p_called_by_form) THEN
1052: APP_EXCEPTION.Raise_Exception;
1053: END IF;
1054:
1055: END Check_Primary_Key;