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_CATEGORIES_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_categories_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 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||sqlerrm,
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 309: IF FND_API.To_Boolean(p_called_by_form) THEN

305: 'GR_UNEXPECTED_ERROR');
306: FND_MESSAGE.SET_TOKEN('TEXT',
307: l_msg_token ||sqlerrm,
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 476: IF FND_API.To_Boolean(p_commit) THEN

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

Line 491: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 507: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 579: IF FND_API.To_Boolean(p_commit) THEN

575: RAISE No_Data_Found_Error;
576: END IF;
577: CLOSE c_lock_categories_tl;
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 605: IF FND_API.To_Boolean(p_called_by_form) THEN

601: x_return_status := 'E';
602: x_oracle_error := APP_EXCEPTION.Get_Code;
603: FND_MESSAGE.SET_NAME('GR',
604: 'GR_ROW_IS_LOCKED');
605: IF FND_API.To_Boolean(p_called_by_form) THEN
606: APP_EXCEPTION.Raise_Exception;
607: ELSE
608: x_msg_data := FND_MESSAGE.Get;
609: END IF;

Line 621: IF FND_API.To_Boolean(p_called_by_form) THEN

617: 'GR_UNEXPECTED_ERROR');
618: FND_MESSAGE.SET_TOKEN('TEXT',
619: l_msg_token ||sqlerrm,
620: FALSE);
621: IF FND_API.To_Boolean(p_called_by_form) THEN
622: APP_EXCEPTION.Raise_Exception;
623: ELSE
624: x_msg_data := FND_MESSAGE.Get;
625: END IF;

Line 698: IF FND_API.TO_Boolean(p_commit) THEN

694: WHERE rowid = p_rowid;
695:
696: /* Check the commit flag and if set, then commit the work. */
697:
698: IF FND_API.TO_Boolean(p_commit) THEN
699: COMMIT WORK;
700: END IF;
701:
702: EXCEPTION

Line 708: IF FND_API.To_Boolean(p_called_by_form) THEN

704: WHEN Check_Integrity_Error THEN
705: ROLLBACK TO SAVEPOINT Delete_Row;
706: x_return_status := l_return_status;
707: x_oracle_error := l_oracle_error;
708: IF FND_API.To_Boolean(p_called_by_form) THEN
709: APP_EXCEPTION.Raise_Exception;
710: ELSE
711: x_msg_data := FND_MESSAGE.Get;
712: END IF;

Line 723: IF FND_API.To_Boolean(p_called_by_form) THEN

719: 'GR_RECORD_NOT_FOUND');
720: FND_MESSAGE.SET_TOKEN('CODE',
721: l_msg_token,
722: FALSE);
723: IF FND_API.To_Boolean(p_called_by_form) THEN
724: APP_EXCEPTION.Raise_Exception;
725: ELSE
726: x_msg_data := FND_MESSAGE.Get;
727: END IF;

Line 739: IF FND_API.To_Boolean(p_called_by_form) THEN

735: 'GR_UNEXPECTED_ERROR');
736: FND_MESSAGE.SET_TOKEN('TEXT',
737: l_msg_data,
738: FALSE);
739: IF FND_API.To_Boolean(p_called_by_form) THEN
740: APP_EXCEPTION.Raise_Exception;
741: ELSE
742: x_msg_data := FND_MESSAGE.Get;
743: END IF;

Line 781: IF FND_API.To_Boolean(p_commit) THEN

777:
778: DELETE FROM gr_safety_categories_tl
779: WHERE safety_category_code = p_safety_category_code;
780:
781: IF FND_API.To_Boolean(p_commit) THEN
782: COMMIT WORK;
783: END IF;
784:
785: EXCEPTION

Line 797: IF FND_API.To_Boolean(p_called_by_form) THEN

793: 'GR_UNEXPECTED_ERROR');
794: FND_MESSAGE.SET_TOKEN('TEXT',
795: l_msg_token||sqlerrm,
796: FALSE);
797: IF FND_API.To_Boolean(p_called_by_form) THEN
798: APP_EXCEPTION.Raise_Exception;
799: ELSE
800: x_msg_data := FND_MESSAGE.Get;
801: END IF;

Line 964: IF FND_API.To_Boolean(p_called_by_form) THEN

960: 'GR_INSTALLED_LANG');
961: FND_MESSAGE.SET_TOKEN('CODE',
962: p_language,
963: FALSE);
964: IF FND_API.To_Boolean(p_called_by_form) THEN
965: APP_EXCEPTION.Raise_Exception;
966: ELSE
967: x_msg_data := FND_MESSAGE.Get;
968: END IF;

Line 980: IF FND_API.To_Boolean(p_called_by_form) THEN

976: 'GR_UNEXPECTED_ERROR');
977: FND_MESSAGE.SET_TOKEN('TEXT',
978: l_msg_data,
979: FALSE);
980: IF FND_API.To_Boolean(p_called_by_form) THEN
981: APP_EXCEPTION.Raise_Exception;
982: ELSE
983: x_msg_data := FND_MESSAGE.Get;
984: END IF;

Line 1040: IF FND_API.To_Boolean(p_called_by_form) THEN

1036: 'GR_UNEXPECTED_ERROR');
1037: FND_MESSAGE.SET_TOKEN('TEXT',
1038: l_msg_data,
1039: FALSE);
1040: IF FND_API.To_Boolean(p_called_by_form) THEN
1041: APP_EXCEPTION.Raise_Exception;
1042: END IF;
1043:
1044: END Check_Primary_Key;