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

Line 76: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 115: IF FND_API.To_Boolean(l_key_exists) THEN

111: 'F',
112: l_rowid,
113: l_key_exists);
114:
115: IF FND_API.To_Boolean(l_key_exists) THEN
116: x_rowid := l_rowid;
117: ELSE
118: RAISE Row_Missing_Error;
119: END IF;

Line 123: IF FND_API.To_Boolean(p_commit) THEN

119: END IF;
120:
121: /* Check the commit flag and if set, then commit the work. */
122:
123: IF FND_API.To_Boolean(p_commit) THEN
124: COMMIT WORK;
125: END IF;
126:
127: EXCEPTION

Line 138: IF FND_API.To_Boolean(p_called_by_form) THEN

134: 'GR_FOREIGN_KEY_ERROR');
135: FND_MESSAGE.SET_TOKEN('TEXT',
136: l_msg_data,
137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;
140: ELSE
141: x_msg_data := FND_MESSAGE.Get;
142: END IF;

Line 153: IF FND_API.To_Boolean(p_called_by_form) THEN

149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;
155: ELSE
156: x_msg_data := FND_MESSAGE.Get;
157: END IF;

Line 169: IF FND_API.To_Boolean(p_called_by_form) THEN

165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
167: FALSE);
168: x_msg_data := FND_MESSAGE.Get;
169: IF FND_API.To_Boolean(p_called_by_form) THEN
170: APP_EXCEPTION.Raise_Exception;
171: ELSE
172: x_msg_data := FND_MESSAGE.Get;
173: END IF;

Line 185: IF FND_API.To_Boolean(p_called_by_form) THEN

181: 'GR_UNEXPECTED_ERROR');
182: FND_MESSAGE.SET_TOKEN('TEXT',
183: l_msg_data,
184: FALSE);
185: IF FND_API.To_Boolean(p_called_by_form) THEN
186: APP_EXCEPTION.Raise_Exception;
187: ELSE
188: x_msg_data := FND_MESSAGE.Get;
189: END IF;

Line 263: IF FND_API.To_Boolean(p_commit) THEN

259: END IF;
260:
261: /* Check if do the commit */
262:
263: IF FND_API.To_Boolean(p_commit) THEN
264: COMMIT WORK;
265: END IF;
266:
267: EXCEPTION

Line 278: IF FND_API.To_Boolean(p_called_by_form) THEN

274: 'GR_FOREIGN_KEY_ERROR');
275: FND_MESSAGE.SET_TOKEN('TEXT',
276: l_msg_data,
277: FALSE);
278: IF FND_API.To_Boolean(p_called_by_form) THEN
279: APP_EXCEPTION.Raise_Exception;
280: ELSE
281: x_msg_data := FND_MESSAGE.Get;
282: END IF;

Line 293: IF FND_API.To_Boolean(p_called_by_form) THEN

289: 'GR_NO_RECORD_INSERTED');
290: FND_MESSAGE.SET_TOKEN('CODE',
291: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
292: FALSE);
293: IF FND_API.To_Boolean(p_called_by_form) THEN
294: APP_EXCEPTION.Raise_Exception;
295: ELSE
296: x_msg_data := FND_MESSAGE.Get;
297: 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_data,
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 383: IF FND_API.To_Boolean(p_commit) THEN

379: IF LockDHFRcd.last_update_date <> p_last_update_date THEN
380: RAISE RECORD_CHANGED_ERROR;
381: END IF;
382:
383: IF FND_API.To_Boolean(p_commit) THEN
384: COMMIT WORK;
385: END IF;
386:
387: EXCEPTION

Line 397: IF FND_API.To_Boolean(p_called_by_form) THEN

393: 'GR_RECORD_NOT_FOUND');
394: FND_MESSAGE.SET_TOKEN('CODE',
395: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;
399: ELSE
400: x_msg_data := FND_MESSAGE.Get;
401: END IF;

Line 407: IF FND_API.To_Boolean(p_called_by_form) THEN

403: ROLLBACK TO SAVEPOINT Lock_Row;
404: X_return_status := 'E';
405: FND_MESSAGE.SET_NAME('FND',
406: 'FORM_RECORD_CHANGED');
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 416: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

412: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
413: ROLLBACK TO SAVEPOINT Lock_Row;
414: x_return_status := 'L';
415: x_oracle_error := APP_EXCEPTION.Get_Code;
416: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
417: FND_MESSAGE.SET_NAME('GR',
418: 'GR_ROW_IS_LOCKED');
419: x_msg_data := FND_MESSAGE.Get;
420: END IF;

Line 431: IF FND_API.To_Boolean(p_called_by_form) THEN

427: 'GR_UNEXPECTED_ERROR');
428: FND_MESSAGE.SET_TOKEN('TEXT',
429: l_msg_data,
430: FALSE);
431: IF FND_API.To_Boolean(p_called_by_form) THEN
432: APP_EXCEPTION.Raise_Exception;
433: ELSE
434: x_msg_data := FND_MESSAGE.Get;
435: END IF;

Line 498: IF FND_API.TO_Boolean(p_commit) THEN

494: WHERE rowid = p_rowid;
495:
496: /* Check the commit flag and if set, then commit the work. */
497:
498: IF FND_API.TO_Boolean(p_commit) THEN
499: COMMIT WORK;
500: END IF;
501:
502: EXCEPTION

Line 508: IF FND_API.To_Boolean(p_called_by_form) THEN

504: WHEN Check_Integrity_Error THEN
505: ROLLBACK TO SAVEPOINT Delete_Row;
506: x_return_status := l_return_status;
507: x_oracle_error := l_oracle_error;
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 523: IF FND_API.To_Boolean(p_called_by_form) THEN

519: 'GR_RECORD_NOT_FOUND');
520: FND_MESSAGE.SET_TOKEN('CODE',
521: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;
525: ELSE
526: x_msg_data := FND_MESSAGE.Get;
527: END IF;

Line 539: IF FND_API.To_Boolean(p_called_by_form) THEN

535: 'GR_UNEXPECTED_ERROR');
536: FND_MESSAGE.SET_TOKEN('TEXT',
537: l_msg_data,
538: FALSE);
539: IF FND_API.To_Boolean(p_called_by_form) THEN
540: APP_EXCEPTION.Raise_Exception;
541: ELSE
542: x_msg_data := FND_MESSAGE.Get;
543: END IF;

Line 716: IF FND_API.To_Boolean(p_called_by_form) THEN

712: FALSE);
713: FND_MESSAGE.SET_TOKEN('TABLES',
714: l_msg_data,
715: FALSE);
716: IF FND_API.To_Boolean(p_called_by_form) THEN
717: APP_EXCEPTION.Raise_Exception;
718: ELSE
719: x_msg_data := FND_MESSAGE.Get;
720: END IF;

Line 731: IF FND_API.To_Boolean(p_called_by_form) THEN

727: 'GR_UNEXPECTED_ERROR');
728: FND_MESSAGE.SET_TOKEN('TEXT',
729: l_msg_data,
730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;
733: ELSE
734: x_msg_data := FND_MESSAGE.Get;
735: END IF;

Line 784: IF FND_API.To_Boolean(p_called_by_form) THEN

780: 'GR_UNEXPECTED_ERROR');
781: FND_MESSAGE.SET_TOKEN('TEXT',
782: l_msg_data,
783: FALSE);
784: IF FND_API.To_Boolean(p_called_by_form) THEN
785: APP_EXCEPTION.Raise_Exception;
786: END IF;
787:
788: END Check_Primary_Key;