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_SUB_HEADINGS_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_sub_headings_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 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 504: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 576: IF FND_API.To_Boolean(p_commit) THEN

572: RAISE No_Data_Found_Error;
573: END IF;
574: CLOSE c_lock_sub_hdgs_tl;
575:
576: IF FND_API.To_Boolean(p_commit) THEN
577: COMMIT WORK;
578: END IF;
579:
580: EXCEPTION

Line 590: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 602: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 618: IF FND_API.To_Boolean(p_called_by_form) THEN

614: 'GR_UNEXPECTED_ERROR');
615: FND_MESSAGE.SET_TOKEN('TEXT',
616: l_msg_token,
617: FALSE);
618: IF FND_API.To_Boolean(p_called_by_form) THEN
619: APP_EXCEPTION.Raise_Exception;
620: ELSE
621: x_msg_data := FND_MESSAGE.Get;
622: END IF;

Line 695: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 705: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 720: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 736: IF FND_API.To_Boolean(p_called_by_form) THEN

732: 'GR_UNEXPECTED_ERROR');
733: FND_MESSAGE.SET_TOKEN('TEXT',
734: l_msg_data,
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 778: IF FND_API.To_Boolean(p_commit) THEN

774:
775: DELETE FROM gr_sub_headings_tl
776: WHERE sub_heading_code = p_sub_heading_code;
777:
778: IF FND_API.To_Boolean(p_commit) THEN
779: COMMIT WORK;
780: END IF;
781:
782: EXCEPTION

Line 794: IF FND_API.To_Boolean(p_called_by_form) THEN

790: 'GR_UNEXPECTED_ERROR');
791: FND_MESSAGE.SET_TOKEN('TEXT',
792: l_msg_token,
793: FALSE);
794: IF FND_API.To_Boolean(p_called_by_form) THEN
795: APP_EXCEPTION.Raise_Exception;
796: ELSE
797: x_msg_data := FND_MESSAGE.Get;
798: END IF;

Line 961: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 977: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1037: IF FND_API.To_Boolean(p_called_by_form) THEN

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