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

Line 67: IF FND_API.To_Boolean(l_key_exists) THEN

63: 'F',
64: l_rowid,
65: l_key_exists);
66:
67: IF FND_API.To_Boolean(l_key_exists) THEN
68: RAISE Item_Exists_Error;
69: END IF;
70:
71: INSERT INTO gr_cover_letters_b

Line 96: IF FND_API.To_Boolean(l_key_exists) THEN

92: 'F',
93: l_rowid,
94: l_key_exists);
95:
96: IF FND_API.To_Boolean(l_key_exists) THEN
97: x_rowid := l_rowid;
98: ELSE
99: RAISE Row_Missing_Error;
100: END IF;

Line 104: IF FND_API.To_Boolean(p_commit) THEN

100: END IF;
101:
102: /* Check the commit flag and if set, then commit the work. */
103:
104: IF FND_API.To_Boolean(p_commit) THEN
105: COMMIT WORK;
106: END IF;
107:
108: EXCEPTION

Line 119: IF FND_API.To_Boolean(p_called_by_form) THEN

115: 'GR_FOREIGN_KEY_ERROR');
116: FND_MESSAGE.SET_TOKEN('TEXT',
117: l_msg_data,
118: FALSE);
119: IF FND_API.To_Boolean(p_called_by_form) THEN
120: APP_EXCEPTION.Raise_Exception;
121: ELSE
122: x_msg_data := FND_MESSAGE.Get;
123: END IF;

Line 135: IF FND_API.To_Boolean(p_called_by_form) THEN

131: 'GR_RECORD_EXISTS');
132: FND_MESSAGE.SET_TOKEN('CODE',
133: l_msg_token,
134: FALSE);
135: IF FND_API.To_Boolean(p_called_by_form) THEN
136: APP_EXCEPTION.Raise_Exception;
137: ELSE
138: x_msg_data := FND_MESSAGE.Get;
139: END IF;

Line 151: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 168: IF FND_API.To_Boolean(p_called_by_form) THEN

164: 'GR_UNEXPECTED_ERROR');
165: FND_MESSAGE.SET_TOKEN('TEXT',
166: l_msg_token,
167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;
170: ELSE
171: x_msg_data := FND_MESSAGE.Get;
172: END IF;

Line 245: IF FND_API.To_Boolean(p_commit) THEN

241: END IF;
242:
243: /* Check the commit flag and if set, then commit the work. */
244:
245: IF FND_API.To_Boolean(p_commit) THEN
246: COMMIT WORK;
247: END IF;
248:
249: EXCEPTION

Line 260: IF FND_API.To_Boolean(p_called_by_form) THEN

256: 'GR_FOREIGN_KEY_ERROR');
257: FND_MESSAGE.SET_TOKEN('TEXT',
258: l_msg_data,
259: FALSE);
260: IF FND_API.To_Boolean(p_called_by_form) THEN
261: APP_EXCEPTION.Raise_Exception;
262: ELSE
263: x_msg_data := FND_MESSAGE.Get;
264: END IF;

Line 275: IF FND_API.To_Boolean(p_called_by_form) THEN

271: 'GR_NO_RECORD_INSERTED');
272: FND_MESSAGE.SET_TOKEN('CODE',
273: l_msg_token,
274: FALSE);
275: IF FND_API.To_Boolean(p_called_by_form) THEN
276: APP_EXCEPTION.Raise_Exception;
277: ELSE
278: x_msg_data := FND_MESSAGE.Get;
279: END IF;

Line 291: IF FND_API.To_Boolean(p_called_by_form) THEN

287: 'GR_UNEXPECTED_ERROR');
288: FND_MESSAGE.SET_TOKEN('TEXT',
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 365: IF FND_API.To_Boolean(p_commit) THEN

361: RAISE No_Data_Found_Error;
362: END IF;
363: CLOSE c_lock_letters_b;
364:
365: IF FND_API.To_Boolean(p_commit) THEN
366: COMMIT WORK;
367: END IF;
368:
369: EXCEPTION

Line 379: IF FND_API.To_Boolean(p_called_by_form) THEN

375: 'GR_RECORD_NOT_FOUND');
376: FND_MESSAGE.SET_TOKEN('CODE',
377: l_msg_token,
378: FALSE);
379: IF FND_API.To_Boolean(p_called_by_form) THEN
380: APP_EXCEPTION.Raise_Exception;
381: ELSE
382: x_msg_data := FND_MESSAGE.Get;
383: END IF;

Line 391: IF FND_API.To_Boolean(p_called_by_form) THEN

387: x_return_status := 'E';
388: x_oracle_error := APP_EXCEPTION.Get_Code;
389: FND_MESSAGE.SET_NAME('GR',
390: 'GR_ROW_IS_LOCKED');
391: IF FND_API.To_Boolean(p_called_by_form) THEN
392: APP_EXCEPTION.Raise_Exception;
393: ELSE
394: x_msg_data := FND_MESSAGE.Get;
395: END IF;

Line 407: IF FND_API.To_Boolean(p_called_by_form) THEN

403: 'GR_UNEXPECTED_ERROR');
404: FND_MESSAGE.SET_TOKEN('TEXT',
405: l_msg_token,
406: FALSE);
407: IF FND_API.To_Boolean(p_called_by_form) THEN
408: APP_EXCEPTION.Raise_Exception;
409: ELSE
410: x_msg_data := FND_MESSAGE.Get;
411: END IF;

Line 480: IF FND_API.TO_Boolean(p_commit) THEN

476: WHERE rowid = p_rowid;
477:
478: /* Check the commit flag and if set, then commit the work. */
479:
480: IF FND_API.TO_Boolean(p_commit) THEN
481: COMMIT WORK;
482: END IF;
483:
484: EXCEPTION

Line 490: IF FND_API.To_Boolean(p_called_by_form) THEN

486: WHEN Check_Integrity_Error THEN
487: ROLLBACK TO SAVEPOINT Delete_Row;
488: x_return_status := l_return_status;
489: x_oracle_error := l_oracle_error;
490: IF FND_API.To_Boolean(p_called_by_form) THEN
491: APP_EXCEPTION.Raise_Exception;
492: ELSE
493: x_msg_data := FND_MESSAGE.Get;
494: END IF;

Line 505: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 521: IF FND_API.To_Boolean(p_called_by_form) THEN

517: 'GR_UNEXPECTED_ERROR');
518: FND_MESSAGE.SET_TOKEN('TEXT',
519: l_msg_data,
520: FALSE);
521: IF FND_API.To_Boolean(p_called_by_form) THEN
522: APP_EXCEPTION.Raise_Exception;
523: ELSE
524: x_msg_data := FND_MESSAGE.Get;
525: END IF;

Line 672: IF FND_API.To_Boolean(p_called_by_form) THEN

668: FALSE);
669: FND_MESSAGE.SET_TOKEN('TABLES',
670: l_msg_data,
671: FALSE);
672: IF FND_API.To_Boolean(p_called_by_form) THEN
673: APP_EXCEPTION.Raise_Exception;
674: ELSE
675: x_msg_data := FND_MESSAGE.Get;
676: END IF;

Line 687: IF FND_API.To_Boolean(p_called_by_form) THEN

683: 'GR_UNEXPECTED_ERROR');
684: FND_MESSAGE.SET_TOKEN('TEXT',
685: l_msg_data,
686: FALSE);
687: IF FND_API.To_Boolean(p_called_by_form) THEN
688: APP_EXCEPTION.Raise_Exception;
689: ELSE
690: x_msg_data := FND_MESSAGE.Get;
691: END IF;

Line 744: IF FND_API.To_Boolean(p_called_by_form) THEN

740: 'GR_UNEXPECTED_ERROR');
741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_data,
743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;
746: END IF;
747:
748: END Check_Primary_Key;