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 APP_EXCEPTION

Line 139: APP_EXCEPTION.Raise_Exception;

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;
143:

Line 147: x_oracle_error := APP_EXCEPTION.Get_Code;

143:
144: WHEN Item_Exists_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;
146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_document_code||' '||p_left_label_code||' '||p_right_label_code,

Line 154: APP_EXCEPTION.Raise_Exception;

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;
158:

Line 162: x_oracle_error := APP_EXCEPTION.Get_Code;

158:
159: WHEN Row_Missing_Error THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_document_code||' '||p_left_label_code||' '||p_right_label_code,

Line 170: APP_EXCEPTION.Raise_Exception;

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;
174:

Line 178: x_oracle_error := APP_EXCEPTION.Get_Code;

174:
175: WHEN OTHERS THEN
176: ROLLBACK TO SAVEPOINT Insert_Row;
177: x_return_status := 'U';
178: x_oracle_error := APP_EXCEPTION.Get_Code;
179: l_msg_data := sqlerrm;
180: FND_MESSAGE.SET_NAME('GR',
181: 'GR_UNEXPECTED_ERROR');
182: FND_MESSAGE.SET_TOKEN('TEXT',

Line 186: APP_EXCEPTION.Raise_Exception;

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;
190:

Line 279: APP_EXCEPTION.Raise_Exception;

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;
283:

Line 287: x_oracle_error := APP_EXCEPTION.Get_Code;

283:
284: WHEN Row_Missing_Error THEN
285: ROLLBACK TO SAVEPOINT Update_Row;
286: x_return_status := 'E';
287: x_oracle_error := APP_EXCEPTION.Get_Code;
288: FND_MESSAGE.SET_NAME('GR',
289: 'GR_NO_RECORD_INSERTED');
290: FND_MESSAGE.SET_TOKEN('CODE',
291: p_document_code||' '||p_left_label_code||' '||p_right_label_code,

Line 294: APP_EXCEPTION.Raise_Exception;

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;
298:

Line 302: x_oracle_error := APP_EXCEPTION.Get_Code;

298:
299: WHEN OTHERS THEN
300: ROLLBACK TO SAVEPOINT Update_Row;
301: x_return_status := 'U';
302: x_oracle_error := APP_EXCEPTION.Get_Code;
303: l_msg_data := sqlerrm;
304: FND_MESSAGE.SET_NAME('GR',
305: 'GR_UNEXPECTED_ERROR');
306: FND_MESSAGE.SET_TOKEN('TEXT',

Line 310: APP_EXCEPTION.Raise_Exception;

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;
314:

Line 398: APP_EXCEPTION.Raise_Exception;

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;
402: WHEN RECORD_CHANGED_ERROR THEN

Line 408: APP_EXCEPTION.Raise_Exception;

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;
412: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 412: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

408: APP_EXCEPTION.Raise_Exception;
409: ELSE
410: x_msg_data := FND_MESSAGE.Get;
411: END IF;
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

Line 415: x_oracle_error := APP_EXCEPTION.Get_Code;

411: END IF;
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;

Line 424: x_oracle_error := APP_EXCEPTION.Get_Code;

420: END IF;
421: WHEN OTHERS THEN
422: ROLLBACK TO SAVEPOINT Lock_Row;
423: x_return_status := 'U';
424: x_oracle_error := APP_EXCEPTION.Get_Code;
425: l_msg_data := sqlerrm;
426: FND_MESSAGE.SET_NAME('GR',
427: 'GR_UNEXPECTED_ERROR');
428: FND_MESSAGE.SET_TOKEN('TEXT',

Line 432: APP_EXCEPTION.Raise_Exception;

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;
436:

Line 509: APP_EXCEPTION.Raise_Exception;

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;
513:

Line 517: x_oracle_error := APP_EXCEPTION.Get_Code;

513:
514: WHEN Row_Missing_Error THEN
515: ROLLBACK TO SAVEPOINT Delete_Row;
516: x_return_status := 'E';
517: x_oracle_error := APP_EXCEPTION.Get_Code;
518: FND_MESSAGE.SET_NAME('GR',
519: 'GR_RECORD_NOT_FOUND');
520: FND_MESSAGE.SET_TOKEN('CODE',
521: p_document_code||' '||p_left_label_code||' '||p_right_label_code,

Line 524: APP_EXCEPTION.Raise_Exception;

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;
528:

Line 532: x_oracle_error := APP_EXCEPTION.Get_Code;

528:
529: WHEN OTHERS THEN
530: ROLLBACK TO SAVEPOINT Delete_Row;
531: x_return_status := 'U';
532: x_oracle_error := APP_EXCEPTION.Get_Code;
533: l_msg_data := sqlerrm;
534: FND_MESSAGE.SET_NAME('GR',
535: 'GR_UNEXPECTED_ERROR');
536: FND_MESSAGE.SET_TOKEN('TEXT',

Line 540: APP_EXCEPTION.Raise_Exception;

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;
544:

Line 600: x_oracle_error := APP_EXCEPTION.Get_Code;

596: FETCH c_get_document INTO DocCdRecord;
597: IF c_get_document%NOTFOUND THEN
598: l_msg_token := p_document_code;
599: x_return_status := 'E';
600: x_oracle_error := APP_EXCEPTION.Get_Code;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_RECORD_NOT_FOUND');
603: FND_MESSAGE.SET_TOKEN('CODE',
604: l_msg_token,

Line 617: x_oracle_error := APP_EXCEPTION.Get_Code;

613: FETCH c_get_label INTO LabelRecord;
614: IF c_get_label%NOTFOUND THEN
615: l_msg_token := p_left_label_code;
616: x_return_status := 'E';
617: x_oracle_error := APP_EXCEPTION.Get_Code;
618: FND_MESSAGE.SET_NAME('GR',
619: 'GR_RECORD_NOT_FOUND');
620: FND_MESSAGE.SET_TOKEN('CODE',
621: l_msg_token,

Line 634: x_oracle_error := APP_EXCEPTION.Get_Code;

630: FETCH c_get_label INTO LabelRecord;
631: IF c_get_label%NOTFOUND THEN
632: l_msg_token := p_right_label_code;
633: x_return_status := 'E';
634: x_oracle_error := APP_EXCEPTION.Get_Code;
635: FND_MESSAGE.SET_NAME('GR',
636: 'GR_RECORD_NOT_FOUND');
637: FND_MESSAGE.SET_TOKEN('CODE',
638: l_msg_token,

Line 654: x_oracle_error := APP_EXCEPTION.Get_Code;

650:
651: WHEN OTHERS THEN
652: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
653: x_return_status := 'U';
654: x_oracle_error := APP_EXCEPTION.Get_Code;
655: l_msg_data := sqlerrm;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_UNEXPECTED_ERROR');
658: FND_MESSAGE.SET_TOKEN('TEXT',

Line 717: APP_EXCEPTION.Raise_Exception;

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;
721: WHEN OTHERS THEN

Line 724: x_oracle_error := APP_EXCEPTION.Get_Code;

720: END IF;
721: WHEN OTHERS THEN
722: ROLLBACK TO SAVEPOINT Check_Integrity;
723: x_return_status := 'U';
724: x_oracle_error := APP_EXCEPTION.Get_Code;
725: l_msg_data := sqlerrm;
726: FND_MESSAGE.SET_NAME('GR',
727: 'GR_UNEXPECTED_ERROR');
728: FND_MESSAGE.SET_TOKEN('TEXT',

Line 732: APP_EXCEPTION.Raise_Exception;

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;
736:

Line 785: APP_EXCEPTION.Raise_Exception;

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;
789: