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

Line 72: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 106: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 114: IF FND_API.To_Boolean(p_commit) THEN

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

Line 129: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 145: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 161: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 178: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 260: IF FND_API.To_Boolean(p_commit) THEN

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

Line 275: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 290: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 306: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 474: IF FND_API.To_Boolean(p_commit) THEN

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

Line 489: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 505: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 579: IF FND_API.To_Boolean(p_commit) THEN

575: IF LockHazardRcd.last_update_date <> p_last_update_date THEN
576: RAISE RECORD_CHANGED_ERROR;
577: END IF;
578:
579: IF FND_API.To_Boolean(p_commit) THEN
580: COMMIT WORK;
581: END IF;
582:
583: EXCEPTION

Line 593: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 604: IF FND_API.To_Boolean(p_called_by_form) THEN

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

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

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

Line 630: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 708: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 718: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 733: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 749: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 791: IF FND_API.To_Boolean(p_commit) THEN

787:
788: DELETE FROM gr_eurohazards_tl
789: WHERE hazard_classification_code = p_hazard_classification_code;
790:
791: IF FND_API.To_Boolean(p_commit) THEN
792: COMMIT WORK;
793: END IF;
794:
795: EXCEPTION

Line 807: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 974: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 990: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1049: IF FND_API.To_Boolean(p_called_by_form) THEN

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