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_EIN_NUMBERS_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_ein_numbers_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 144: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 160: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 176: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 257: IF FND_API.To_Boolean(p_commit) THEN

253: END IF;
254:
255: /* Check if do the commit */
256:
257: IF FND_API.To_Boolean(p_commit) THEN
258: COMMIT WORK;
259: END IF;
260:
261: EXCEPTION

Line 272: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 287: IF FND_API.To_Boolean(p_called_by_form) THEN

283: 'GR_NO_RECORD_INSERTED');
284: FND_MESSAGE.SET_TOKEN('CODE',
285: p_european_index_number,
286: FALSE);
287: IF FND_API.To_Boolean(p_called_by_form) THEN
288: APP_EXCEPTION.Raise_Exception;
289: ELSE
290: x_msg_data := FND_MESSAGE.Get;
291: END IF;

Line 303: IF FND_API.To_Boolean(p_called_by_form) THEN

299: 'GR_UNEXPECTED_ERROR');
300: FND_MESSAGE.SET_TOKEN('TEXT',
301: l_msg_data,
302: FALSE);
303: IF FND_API.To_Boolean(p_called_by_form) THEN
304: APP_EXCEPTION.Raise_Exception;
305: ELSE
306: x_msg_data := FND_MESSAGE.Get;
307: END IF;

Line 469: IF FND_API.To_Boolean(p_commit) THEN

465: END LOOP;
466: END IF;
467: CLOSE c_get_installed_languages;
468:
469: IF FND_API.To_Boolean(p_commit) THEN
470: COMMIT WORK;
471: END IF;
472:
473: EXCEPTION

Line 484: IF FND_API.To_Boolean(p_called_by_form) THEN

480: 'GR_RECORD_NOT_FOUND');
481: FND_MESSAGE.SET_TOKEN('CODE',
482: l_msg_token,
483: FALSE);
484: IF FND_API.To_Boolean(p_called_by_form) THEN
485: APP_EXCEPTION.Raise_Exception;
486: ELSE
487: x_msg_data := FND_MESSAGE.Get;
488: END IF;

Line 500: IF FND_API.To_Boolean(p_called_by_form) THEN

496: 'GR_UNEXPECTED_ERROR');
497: FND_MESSAGE.SET_TOKEN('TEXT',
498: l_msg_token,
499: FALSE);
500: IF FND_API.To_Boolean(p_called_by_form) THEN
501: APP_EXCEPTION.Raise_Exception;
502: ELSE
503: x_msg_data := FND_MESSAGE.Get;
504: END IF;

Line 574: IF FND_API.To_Boolean(p_commit) THEN

570: IF LockEinRcd.last_update_date <> p_last_update_date THEN
571: RAISE RECORD_CHANGED_ERROR;
572: END IF;
573:
574: IF FND_API.To_Boolean(p_commit) THEN
575: COMMIT WORK;
576: END IF;
577:
578: EXCEPTION

Line 588: IF FND_API.To_Boolean(p_called_by_form) THEN

584: 'GR_RECORD_NOT_FOUND');
585: FND_MESSAGE.SET_TOKEN('CODE',
586: p_european_index_number,
587: FALSE);
588: IF FND_API.To_Boolean(p_called_by_form) THEN
589: APP_EXCEPTION.Raise_Exception;
590: ELSE
591: x_msg_data := FND_MESSAGE.Get;
592: END IF;

Line 598: IF FND_API.To_Boolean(p_called_by_form) THEN

594: ROLLBACK TO SAVEPOINT Lock_Row;
595: X_return_status := 'E';
596: FND_MESSAGE.SET_NAME('FND',
597: 'FORM_RECORD_CHANGED');
598: IF FND_API.To_Boolean(p_called_by_form) THEN
599: APP_EXCEPTION.Raise_Exception;
600: ELSE
601: x_msg_data := FND_MESSAGE.Get;
602: END IF;

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

603: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
604: ROLLBACK TO SAVEPOINT Lock_Row;
605: x_return_status := 'L';
606: x_oracle_error := APP_EXCEPTION.Get_Code;
607: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
608: FND_MESSAGE.SET_NAME('GR',
609: 'GR_ROW_IS_LOCKED');
610: x_msg_data := FND_MESSAGE.Get;
611: END IF;

Line 622: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 683: IF FND_API.TO_Boolean(p_commit) THEN

679: WHERE rowid = p_rowid;
680:
681: /* Check the commit flag and if set, then commit the work. */
682:
683: IF FND_API.TO_Boolean(p_commit) THEN
684: COMMIT WORK;
685: END IF;
686:
687: EXCEPTION

Line 693: IF FND_API.To_Boolean(p_called_by_form) THEN

689: WHEN Check_Integrity_Error THEN
690: ROLLBACK TO SAVEPOINT Delete_Row;
691: x_return_status := l_return_status;
692: x_oracle_error := l_oracle_error;
693: IF FND_API.To_Boolean(p_called_by_form) THEN
694: APP_EXCEPTION.Raise_Exception;
695: ELSE
696: x_msg_data := FND_MESSAGE.Get;
697: END IF;

Line 708: IF FND_API.To_Boolean(p_called_by_form) THEN

704: 'GR_RECORD_NOT_FOUND');
705: FND_MESSAGE.SET_TOKEN('CODE',
706: p_european_index_number,
707: FALSE);
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 724: IF FND_API.To_Boolean(p_called_by_form) THEN

720: 'GR_UNEXPECTED_ERROR');
721: FND_MESSAGE.SET_TOKEN('TEXT',
722: l_msg_data,
723: FALSE);
724: IF FND_API.To_Boolean(p_called_by_form) THEN
725: APP_EXCEPTION.Raise_Exception;
726: ELSE
727: x_msg_data := FND_MESSAGE.Get;
728: END IF;

Line 766: IF FND_API.To_Boolean(p_commit) THEN

762:
763: DELETE FROM gr_ein_numbers_tl
764: WHERE european_index_number = p_european_index_number;
765:
766: IF FND_API.To_Boolean(p_commit) THEN
767: COMMIT WORK;
768: END IF;
769:
770: EXCEPTION

Line 782: IF FND_API.To_Boolean(p_called_by_form) THEN

778: 'GR_UNEXPECTED_ERROR');
779: FND_MESSAGE.SET_TOKEN('TEXT',
780: l_msg_token,
781: FALSE);
782: IF FND_API.To_Boolean(p_called_by_form) THEN
783: APP_EXCEPTION.Raise_Exception;
784: ELSE
785: x_msg_data := FND_MESSAGE.Get;
786: END IF;

Line 946: IF FND_API.To_Boolean(p_called_by_form) THEN

942: 'GR_INSTALLED_LANG');
943: FND_MESSAGE.SET_TOKEN('CODE',
944: p_language,
945: FALSE);
946: IF FND_API.To_Boolean(p_called_by_form) THEN
947: APP_EXCEPTION.Raise_Exception;
948: ELSE
949: x_msg_data := FND_MESSAGE.Get;
950: END IF;

Line 962: IF FND_API.To_Boolean(p_called_by_form) THEN

958: 'GR_UNEXPECTED_ERROR');
959: FND_MESSAGE.SET_TOKEN('TEXT',
960: l_msg_data,
961: FALSE);
962: IF FND_API.To_Boolean(p_called_by_form) THEN
963: APP_EXCEPTION.Raise_Exception;
964: ELSE
965: x_msg_data := FND_MESSAGE.Get;
966: END IF;

Line 1011: IF FND_API.To_Boolean(p_called_by_form) THEN

1007: 'GR_UNEXPECTED_ERROR');
1008: FND_MESSAGE.SET_TOKEN('TEXT',
1009: l_msg_data,
1010: FALSE);
1011: IF FND_API.To_Boolean(p_called_by_form) THEN
1012: APP_EXCEPTION.Raise_Exception;
1013: END IF;
1014:
1015: END Check_Primary_Key;