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_SAFETY_PHRASES_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_safety_phrases_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 261: IF FND_API.To_Boolean(p_commit) THEN

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

Line 276: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 291: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 307: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 477: IF FND_API.To_Boolean(p_commit) THEN

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

Line 492: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 508: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 582: IF FND_API.To_Boolean(p_commit) THEN

578: IF LockSafetyRcd.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 633: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 710: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 721: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 736: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 752: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 794: IF FND_API.To_Boolean(p_commit) THEN

790:
791: DELETE FROM gr_safety_phrases_tl
792: WHERE safety_phrase_code = p_safety_phrase_code;
793:
794: IF FND_API.To_Boolean(p_commit) THEN
795: COMMIT WORK;
796: END IF;
797:
798: EXCEPTION

Line 810: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 976: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 992: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1052: IF FND_API.To_Boolean(p_called_by_form) THEN

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