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

Line 74: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 110: IF FND_API.To_Boolean(l_key_exists) THEN

106: 'F',
107: l_rowid,
108: l_key_exists);
109:
110: IF FND_API.To_Boolean(l_key_exists) THEN
111: x_rowid := l_rowid;
112: ELSE
113: RAISE Row_Missing_Error;
114: END IF;

Line 118: IF FND_API.To_Boolean(p_commit) THEN

114: END IF;
115:
116: /* Check the commit flag and if set, then commit the work. */
117:
118: IF FND_API.To_Boolean(p_commit) THEN
119: COMMIT WORK;
120: END IF;
121:
122: EXCEPTION

Line 133: IF FND_API.To_Boolean(p_called_by_form) THEN

129: 'GR_FOREIGN_KEY_ERROR');
130: FND_MESSAGE.SET_TOKEN('TEXT',
131: l_msg_data,
132: FALSE);
133: IF FND_API.To_Boolean(p_called_by_form) THEN
134: APP_EXCEPTION.Raise_Exception;
135: ELSE
136: x_msg_data := FND_MESSAGE.Get;
137: END IF;

Line 149: IF FND_API.To_Boolean(p_called_by_form) THEN

145: 'GR_RECORD_EXISTS');
146: FND_MESSAGE.SET_TOKEN('CODE',
147: l_msg_token,
148: FALSE);
149: IF FND_API.To_Boolean(p_called_by_form) THEN
150: APP_EXCEPTION.Raise_Exception;
151: ELSE
152: x_msg_data := FND_MESSAGE.Get;
153: END IF;

Line 165: IF FND_API.To_Boolean(p_called_by_form) THEN

161: 'GR_NO_RECORD_INSERTED');
162: FND_MESSAGE.SET_TOKEN('CODE',
163: l_msg_token,
164: FALSE);
165: IF FND_API.To_Boolean(p_called_by_form) THEN
166: APP_EXCEPTION.Raise_Exception;
167: ELSE
168: x_msg_data := FND_MESSAGE.Get;
169: END IF;

Line 183: IF FND_API.To_Boolean(p_called_by_form) THEN

179: 'GR_UNEXPECTED_ERROR');
180: FND_MESSAGE.SET_TOKEN('TEXT',
181: l_msg_token||sqlerrm,
182: FALSE);
183: IF FND_API.To_Boolean(p_called_by_form) THEN
184: APP_EXCEPTION.Raise_Exception;
185: ELSE
186: x_msg_data := FND_MESSAGE.Get;
187: END IF;

Line 269: IF FND_API.To_Boolean(p_commit) THEN

265: END IF;
266:
267: /* Check the commit flag and if set, then commit the work. */
268:
269: IF FND_API.To_Boolean(p_commit) THEN
270: COMMIT WORK;
271: END IF;
272:
273: EXCEPTION

Line 284: IF FND_API.To_Boolean(p_called_by_form) THEN

280: 'GR_FOREIGN_KEY_ERROR');
281: FND_MESSAGE.SET_TOKEN('TEXT',
282: l_msg_data,
283: FALSE);
284: IF FND_API.To_Boolean(p_called_by_form) THEN
285: APP_EXCEPTION.Raise_Exception;
286: ELSE
287: x_msg_data := FND_MESSAGE.Get;
288: END IF;

Line 299: IF FND_API.To_Boolean(p_called_by_form) THEN

295: 'GR_NO_RECORD_INSERTED');
296: FND_MESSAGE.SET_TOKEN('CODE',
297: l_msg_token,
298: FALSE);
299: IF FND_API.To_Boolean(p_called_by_form) THEN
300: APP_EXCEPTION.Raise_Exception;
301: ELSE
302: x_msg_data := FND_MESSAGE.Get;
303: END IF;

Line 316: IF FND_API.To_Boolean(p_called_by_form) THEN

312: 'GR_UNEXPECTED_ERROR');
313: FND_MESSAGE.SET_TOKEN('TEXT',
314: l_msg_token||sqlerrm,
315: FALSE);
316: IF FND_API.To_Boolean(p_called_by_form) THEN
317: APP_EXCEPTION.Raise_Exception;
318: ELSE
319: x_msg_data := FND_MESSAGE.Get;
320: END IF;

Line 493: IF FND_API.To_Boolean(p_commit) THEN

489: END LOOP;
490: END IF;
491: CLOSE c_get_installed_languages;
492:
493: IF FND_API.To_Boolean(p_commit) THEN
494: COMMIT WORK;
495: END IF;
496:
497: EXCEPTION

Line 508: IF FND_API.To_Boolean(p_called_by_form) THEN

504: 'GR_RECORD_NOT_FOUND');
505: FND_MESSAGE.SET_TOKEN('CODE',
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 524: IF FND_API.To_Boolean(p_called_by_form) THEN

520: 'GR_UNEXPECTED_ERROR');
521: FND_MESSAGE.SET_TOKEN('TEXT',
522: l_msg_token||sqlerrm,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;
526: ELSE
527: x_msg_data := FND_MESSAGE.Get;
528: END IF;

Line 597: IF FND_API.To_Boolean(p_commit) THEN

593: RAISE No_Data_Found_Error;
594: END IF;
595: CLOSE c_lock_letters_tl;
596:
597: IF FND_API.To_Boolean(p_commit) THEN
598: COMMIT WORK;
599: END IF;
600:
601: EXCEPTION

Line 611: IF FND_API.To_Boolean(p_called_by_form) THEN

607: 'GR_RECORD_NOT_FOUND');
608: FND_MESSAGE.SET_TOKEN('CODE',
609: l_msg_token,
610: FALSE);
611: IF FND_API.To_Boolean(p_called_by_form) THEN
612: APP_EXCEPTION.Raise_Exception;
613: ELSE
614: x_msg_data := FND_MESSAGE.Get;
615: END IF;

Line 623: IF FND_API.To_Boolean(p_called_by_form) THEN

619: x_return_status := 'E';
620: x_oracle_error := APP_EXCEPTION.Get_Code;
621: FND_MESSAGE.SET_NAME('GR',
622: 'GR_ROW_IS_LOCKED');
623: IF FND_API.To_Boolean(p_called_by_form) THEN
624: APP_EXCEPTION.Raise_Exception;
625: ELSE
626: x_msg_data := FND_MESSAGE.Get;
627: END IF;

Line 640: IF FND_API.To_Boolean(p_called_by_form) THEN

636: 'GR_UNEXPECTED_ERROR');
637: FND_MESSAGE.SET_TOKEN('TEXT',
638: l_msg_token||sqlerrm,
639: FALSE);
640: IF FND_API.To_Boolean(p_called_by_form) THEN
641: APP_EXCEPTION.Raise_Exception;
642: ELSE
643: x_msg_data := FND_MESSAGE.Get;
644: END IF;

Line 719: IF FND_API.TO_Boolean(p_commit) THEN

715: WHERE rowid = p_rowid;
716:
717: /* Check the commit flag and if set, then commit the work. */
718:
719: IF FND_API.TO_Boolean(p_commit) THEN
720: COMMIT WORK;
721: END IF;
722:
723: EXCEPTION

Line 729: IF FND_API.To_Boolean(p_called_by_form) THEN

725: WHEN Check_Integrity_Error THEN
726: ROLLBACK TO SAVEPOINT Delete_Row;
727: x_return_status := l_return_status;
728: x_oracle_error := l_oracle_error;
729: IF FND_API.To_Boolean(p_called_by_form) THEN
730: APP_EXCEPTION.Raise_Exception;
731: ELSE
732: x_msg_data := FND_MESSAGE.Get;
733: END IF;

Line 744: IF FND_API.To_Boolean(p_called_by_form) THEN

740: 'GR_RECORD_NOT_FOUND');
741: FND_MESSAGE.SET_TOKEN('CODE',
742: l_msg_token,
743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;
746: ELSE
747: x_msg_data := FND_MESSAGE.Get;
748: END IF;

Line 760: IF FND_API.To_Boolean(p_called_by_form) THEN

756: 'GR_UNEXPECTED_ERROR');
757: FND_MESSAGE.SET_TOKEN('TEXT',
758: l_msg_data,
759: FALSE);
760: IF FND_API.To_Boolean(p_called_by_form) THEN
761: APP_EXCEPTION.Raise_Exception;
762: ELSE
763: x_msg_data := FND_MESSAGE.Get;
764: END IF;

Line 802: IF FND_API.To_Boolean(p_commit) THEN

798:
799: DELETE FROM gr_cover_letters_tl
800: WHERE cover_letter_id = p_cover_letter_id;
801:
802: IF FND_API.To_Boolean(p_commit) THEN
803: COMMIT WORK;
804: END IF;
805:
806: EXCEPTION

Line 819: IF FND_API.To_Boolean(p_called_by_form) THEN

815: 'GR_UNEXPECTED_ERROR');
816: FND_MESSAGE.SET_TOKEN('TEXT',
817: l_msg_token||sqlerrm,
818: FALSE);
819: IF FND_API.To_Boolean(p_called_by_form) THEN
820: APP_EXCEPTION.Raise_Exception;
821: ELSE
822: x_msg_data := FND_MESSAGE.Get;
823: END IF;

Line 989: IF FND_API.To_Boolean(p_called_by_form) THEN

985: 'GR_INSTALLED_LANG');
986: FND_MESSAGE.SET_TOKEN('CODE',
987: p_language,
988: FALSE);
989: IF FND_API.To_Boolean(p_called_by_form) THEN
990: APP_EXCEPTION.Raise_Exception;
991: ELSE
992: x_msg_data := FND_MESSAGE.Get;
993: END IF;

Line 1006: IF FND_API.To_Boolean(p_called_by_form) THEN

1002: 'GR_UNEXPECTED_ERROR');
1003: FND_MESSAGE.SET_TOKEN('TEXT',
1004: l_msg_data,
1005: FALSE);
1006: IF FND_API.To_Boolean(p_called_by_form) THEN
1007: APP_EXCEPTION.Raise_Exception;
1008: ELSE
1009: x_msg_data := FND_MESSAGE.Get;
1010: END IF;

Line 1066: IF FND_API.To_Boolean(p_called_by_form) THEN

1062: 'GR_UNEXPECTED_ERROR');
1063: FND_MESSAGE.SET_TOKEN('TEXT',
1064: l_msg_data,
1065: FALSE);
1066: IF FND_API.To_Boolean(p_called_by_form) THEN
1067: APP_EXCEPTION.Raise_Exception;
1068: END IF;
1069:
1070: END Check_Primary_Key;