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_DOCUMENT_HEADINGS_PKG dependencies on APP_EXCEPTION

Line 144: APP_EXCEPTION.Raise_Exception;

140: FND_MESSAGE.SET_TOKEN('TEXT',
141: l_msg_data,
142: FALSE);
143: IF FND_API.To_Boolean(p_called_by_form) THEN
144: APP_EXCEPTION.Raise_Exception;
145: ELSE
146: x_msg_data := FND_MESSAGE.Get;
147: END IF;
148:

Line 152: x_oracle_error := APP_EXCEPTION.Get_Code;

148:
149: WHEN Label_Exists_Error THEN
150: ROLLBACK TO SAVEPOINT Insert_Row;
151: x_return_status := 'E';
152: x_oracle_error := APP_EXCEPTION.Get_Code;
153: FND_MESSAGE.SET_NAME('GR',
154: 'GR_RECORD_EXISTS');
155: FND_MESSAGE.SET_TOKEN('CODE',
156: p_document_code,

Line 159: APP_EXCEPTION.Raise_Exception;

155: FND_MESSAGE.SET_TOKEN('CODE',
156: p_document_code,
157: FALSE);
158: IF FND_API.To_Boolean(p_called_by_form) THEN
159: APP_EXCEPTION.Raise_Exception;
160: ELSE
161: x_msg_data := FND_MESSAGE.Get;
162: END IF;
163:

Line 167: x_oracle_error := APP_EXCEPTION.Get_Code;

163:
164: WHEN Row_Missing_Error THEN
165: ROLLBACK TO SAVEPOINT Insert_Row;
166: x_return_status := 'E';
167: x_oracle_error := APP_EXCEPTION.Get_Code;
168: FND_MESSAGE.SET_NAME('GR',
169: 'GR_NO_RECORD_INSERTED');
170: FND_MESSAGE.SET_TOKEN('CODE',
171: p_document_code,

Line 174: APP_EXCEPTION.Raise_Exception;

170: FND_MESSAGE.SET_TOKEN('CODE',
171: p_document_code,
172: FALSE);
173: IF FND_API.To_Boolean(p_called_by_form) THEN
174: APP_EXCEPTION.Raise_Exception;
175: ELSE
176: x_msg_data := FND_MESSAGE.Get;
177: END IF;
178:

Line 182: x_oracle_error := APP_EXCEPTION.Get_Code;

178:
179: WHEN OTHERS THEN
180: ROLLBACK TO SAVEPOINT Insert_Row;
181: x_return_status := 'U';
182: x_oracle_error := APP_EXCEPTION.Get_Code;
183: l_msg_data := APP_EXCEPTION.Get_Text;
184: FND_MESSAGE.SET_NAME('GR',
185: 'GR_UNEXPECTED_ERROR');
186: FND_MESSAGE.SET_TOKEN('TEXT',

Line 183: l_msg_data := APP_EXCEPTION.Get_Text;

179: WHEN OTHERS THEN
180: ROLLBACK TO SAVEPOINT Insert_Row;
181: x_return_status := 'U';
182: x_oracle_error := APP_EXCEPTION.Get_Code;
183: l_msg_data := APP_EXCEPTION.Get_Text;
184: FND_MESSAGE.SET_NAME('GR',
185: 'GR_UNEXPECTED_ERROR');
186: FND_MESSAGE.SET_TOKEN('TEXT',
187: l_msg_data,

Line 190: APP_EXCEPTION.Raise_Exception;

186: FND_MESSAGE.SET_TOKEN('TEXT',
187: l_msg_data,
188: FALSE);
189: IF FND_API.To_Boolean(p_called_by_form) THEN
190: APP_EXCEPTION.Raise_Exception;
191: ELSE
192: x_msg_data := FND_MESSAGE.Get;
193: END IF;
194:

Line 292: APP_EXCEPTION.Raise_Exception;

288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_data,
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;
296:

Line 300: x_oracle_error := APP_EXCEPTION.Get_Code;

296:
297: WHEN Row_Missing_Error THEN
298: ROLLBACK TO SAVEPOINT Update_Row;
299: x_return_status := 'E';
300: x_oracle_error := APP_EXCEPTION.Get_Code;
301: FND_MESSAGE.SET_NAME('GR',
302: 'GR_NO_RECORD_INSERTED');
303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_document_code,

Line 307: APP_EXCEPTION.Raise_Exception;

303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_document_code,
305: FALSE);
306: IF FND_API.To_Boolean(p_called_by_form) THEN
307: APP_EXCEPTION.Raise_Exception;
308: ELSE
309: x_msg_data := FND_MESSAGE.Get;
310: END IF;
311:

Line 315: x_oracle_error := APP_EXCEPTION.Get_Code;

311:
312: WHEN OTHERS THEN
313: ROLLBACK TO SAVEPOINT Update_Row;
314: x_return_status := 'U';
315: x_oracle_error := APP_EXCEPTION.Get_Code;
316: l_msg_data := APP_EXCEPTION.Get_Text;
317: FND_MESSAGE.SET_NAME('GR',
318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',

Line 316: l_msg_data := APP_EXCEPTION.Get_Text;

312: WHEN OTHERS THEN
313: ROLLBACK TO SAVEPOINT Update_Row;
314: x_return_status := 'U';
315: x_oracle_error := APP_EXCEPTION.Get_Code;
316: l_msg_data := APP_EXCEPTION.Get_Text;
317: FND_MESSAGE.SET_NAME('GR',
318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_data,

Line 323: APP_EXCEPTION.Raise_Exception;

319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_data,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;
327:

Line 393: x_oracle_error := APP_EXCEPTION.Get_Code;

389:
390: WHEN Row_Missing_Error THEN
391: ROLLBACK TO SAVEPOINT Update_Display_Columns;
392: x_return_status := 'E';
393: x_oracle_error := APP_EXCEPTION.Get_Code;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_NO_RECORD_INSERTED');
396: FND_MESSAGE.SET_TOKEN('CODE',
397: p_document_headings_seqno,

Line 400: APP_EXCEPTION.Raise_Exception;

396: FND_MESSAGE.SET_TOKEN('CODE',
397: p_document_headings_seqno,
398: FALSE);
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;
404:

Line 408: x_oracle_error := APP_EXCEPTION.Get_Code;

404:
405: WHEN OTHERS THEN
406: ROLLBACK TO SAVEPOINT Update_Display_Columns;
407: x_return_status := 'U';
408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: l_msg_data := APP_EXCEPTION.Get_Text;
410: FND_MESSAGE.SET_NAME('GR',
411: 'GR_UNEXPECTED_ERROR');
412: FND_MESSAGE.SET_TOKEN('TEXT',

Line 409: l_msg_data := APP_EXCEPTION.Get_Text;

405: WHEN OTHERS THEN
406: ROLLBACK TO SAVEPOINT Update_Display_Columns;
407: x_return_status := 'U';
408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: l_msg_data := APP_EXCEPTION.Get_Text;
410: FND_MESSAGE.SET_NAME('GR',
411: 'GR_UNEXPECTED_ERROR');
412: FND_MESSAGE.SET_TOKEN('TEXT',
413: l_msg_data,

Line 416: APP_EXCEPTION.Raise_Exception;

412: FND_MESSAGE.SET_TOKEN('TEXT',
413: l_msg_data,
414: FALSE);
415: IF FND_API.To_Boolean(p_called_by_form) THEN
416: APP_EXCEPTION.Raise_Exception;
417: ELSE
418: x_msg_data := FND_MESSAGE.Get;
419: END IF;
420:

Line 503: APP_EXCEPTION.Raise_Exception;

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

Line 511: x_oracle_error := APP_EXCEPTION.Get_Code;

507:
508: WHEN Row_Already_Locked_Error THEN
509: ROLLBACK TO SAVEPOINT Lock_Row;
510: x_return_status := 'E';
511: x_oracle_error := APP_EXCEPTION.Get_Code;
512: FND_MESSAGE.SET_NAME('GR',
513: 'GR_ROW_IS_LOCKED');
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;

Line 515: APP_EXCEPTION.Raise_Exception;

511: x_oracle_error := APP_EXCEPTION.Get_Code;
512: FND_MESSAGE.SET_NAME('GR',
513: 'GR_ROW_IS_LOCKED');
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;
516: ELSE
517: x_msg_data := FND_MESSAGE.Get;
518: END IF;
519:

Line 523: x_oracle_error := APP_EXCEPTION.Get_Code;

519:
520: WHEN OTHERS THEN
521: ROLLBACK TO SAVEPOINT Lock_Row;
522: x_return_status := 'U';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: l_msg_data := APP_EXCEPTION.Get_Text;
525: FND_MESSAGE.SET_NAME('GR',
526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',

Line 524: l_msg_data := APP_EXCEPTION.Get_Text;

520: WHEN OTHERS THEN
521: ROLLBACK TO SAVEPOINT Lock_Row;
522: x_return_status := 'U';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: l_msg_data := APP_EXCEPTION.Get_Text;
525: FND_MESSAGE.SET_NAME('GR',
526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,

Line 531: APP_EXCEPTION.Raise_Exception;

527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,
529: FALSE);
530: IF FND_API.To_Boolean(p_called_by_form) THEN
531: APP_EXCEPTION.Raise_Exception;
532: ELSE
533: x_msg_data := FND_MESSAGE.Get;
534: END IF;
535:

Line 619: APP_EXCEPTION.Raise_Exception;

615: ROLLBACK TO SAVEPOINT Delete_Row;
616: x_return_status := l_return_status;
617: x_oracle_error := l_oracle_error;
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;
623:

Line 627: x_oracle_error := APP_EXCEPTION.Get_Code;

623:
624: WHEN Row_Missing_Error THEN
625: ROLLBACK TO SAVEPOINT Delete_Row;
626: x_return_status := 'E';
627: x_oracle_error := APP_EXCEPTION.Get_Code;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_RECORD_NOT_FOUND');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_code,

Line 634: APP_EXCEPTION.Raise_Exception;

630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_code,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;
638:

Line 642: x_oracle_error := APP_EXCEPTION.Get_Code;

638:
639: WHEN OTHERS THEN
640: ROLLBACK TO SAVEPOINT Delete_Row;
641: x_return_status := 'U';
642: x_oracle_error := APP_EXCEPTION.Get_Code;
643: l_msg_data := APP_EXCEPTION.Get_Text;
644: l_msg_data := APP_EXCEPTION.Get_Text;
645: FND_MESSAGE.SET_NAME('GR',
646: 'GR_UNEXPECTED_ERROR');

Line 643: l_msg_data := APP_EXCEPTION.Get_Text;

639: WHEN OTHERS THEN
640: ROLLBACK TO SAVEPOINT Delete_Row;
641: x_return_status := 'U';
642: x_oracle_error := APP_EXCEPTION.Get_Code;
643: l_msg_data := APP_EXCEPTION.Get_Text;
644: l_msg_data := APP_EXCEPTION.Get_Text;
645: FND_MESSAGE.SET_NAME('GR',
646: 'GR_UNEXPECTED_ERROR');
647: FND_MESSAGE.SET_TOKEN('TEXT',

Line 644: l_msg_data := APP_EXCEPTION.Get_Text;

640: ROLLBACK TO SAVEPOINT Delete_Row;
641: x_return_status := 'U';
642: x_oracle_error := APP_EXCEPTION.Get_Code;
643: l_msg_data := APP_EXCEPTION.Get_Text;
644: l_msg_data := APP_EXCEPTION.Get_Text;
645: FND_MESSAGE.SET_NAME('GR',
646: 'GR_UNEXPECTED_ERROR');
647: FND_MESSAGE.SET_TOKEN('TEXT',
648: l_msg_data,

Line 651: APP_EXCEPTION.Raise_Exception;

647: FND_MESSAGE.SET_TOKEN('TEXT',
648: l_msg_data,
649: FALSE);
650: IF FND_API.To_Boolean(p_called_by_form) THEN
651: APP_EXCEPTION.Raise_Exception;
652: ELSE
653: x_msg_data := FND_MESSAGE.Get;
654: END IF;
655:

Line 701: x_oracle_error := APP_EXCEPTION.Get_Code;

697:
698: WHEN OTHERS THEN
699: ROLLBACK TO SAVEPOINT Delete_Rows;
700: x_return_status := 'U';
701: x_oracle_error := APP_EXCEPTION.Get_Code;
702: l_msg_data := APP_EXCEPTION.Get_Text;
703: FND_MESSAGE.SET_NAME('GR',
704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',

Line 702: l_msg_data := APP_EXCEPTION.Get_Text;

698: WHEN OTHERS THEN
699: ROLLBACK TO SAVEPOINT Delete_Rows;
700: x_return_status := 'U';
701: x_oracle_error := APP_EXCEPTION.Get_Code;
702: l_msg_data := APP_EXCEPTION.Get_Text;
703: FND_MESSAGE.SET_NAME('GR',
704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_token,

Line 709: APP_EXCEPTION.Raise_Exception;

705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_token,
707: FALSE);
708: IF FND_API.To_Boolean(p_called_by_form) THEN
709: APP_EXCEPTION.Raise_Exception;
710: ELSE
711: x_msg_data := FND_MESSAGE.Get;
712: END IF;
713:

Line 809: x_oracle_error := APP_EXCEPTION.Get_Code;

805:
806: WHEN OTHERS THEN
807: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
808: x_return_status := 'U';
809: x_oracle_error := APP_EXCEPTION.Get_Code;
810: l_msg_data := APP_EXCEPTION.Get_Text;
811: FND_MESSAGE.SET_NAME('GR',
812: 'GR_UNEXPECTED_ERROR');
813: FND_MESSAGE.SET_TOKEN('TEXT',

Line 810: l_msg_data := APP_EXCEPTION.Get_Text;

806: WHEN OTHERS THEN
807: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
808: x_return_status := 'U';
809: x_oracle_error := APP_EXCEPTION.Get_Code;
810: l_msg_data := APP_EXCEPTION.Get_Text;
811: FND_MESSAGE.SET_NAME('GR',
812: 'GR_UNEXPECTED_ERROR');
813: FND_MESSAGE.SET_TOKEN('TEXT',
814: l_msg_data,

Line 891: x_oracle_error := APP_EXCEPTION.Get_Code;

887:
888: WHEN OTHERS THEN
889: ROLLBACK TO SAVEPOINT Check_Integrity;
890: x_return_status := 'U';
891: x_oracle_error := APP_EXCEPTION.Get_Code;
892: l_msg_data := APP_EXCEPTION.Get_Text;
893: FND_MESSAGE.SET_NAME('GR',
894: 'GR_UNEXPECTED_ERROR');
895: FND_MESSAGE.SET_TOKEN('TEXT',

Line 892: l_msg_data := APP_EXCEPTION.Get_Text;

888: WHEN OTHERS THEN
889: ROLLBACK TO SAVEPOINT Check_Integrity;
890: x_return_status := 'U';
891: x_oracle_error := APP_EXCEPTION.Get_Code;
892: l_msg_data := APP_EXCEPTION.Get_Text;
893: FND_MESSAGE.SET_NAME('GR',
894: 'GR_UNEXPECTED_ERROR');
895: FND_MESSAGE.SET_TOKEN('TEXT',
896: l_msg_data,

Line 899: APP_EXCEPTION.Raise_Exception;

895: FND_MESSAGE.SET_TOKEN('TEXT',
896: l_msg_data,
897: FALSE);
898: IF FND_API.To_Boolean(p_called_by_form) THEN
899: APP_EXCEPTION.Raise_Exception;
900: ELSE
901: x_msg_data := FND_MESSAGE.Get;
902: END IF;
903:

Line 948: l_msg_data := APP_EXCEPTION.Get_Text;

944:
945: EXCEPTION
946:
947: WHEN Others THEN
948: l_msg_data := APP_EXCEPTION.Get_Text;
949: FND_MESSAGE.SET_NAME('GR',
950: 'GR_UNEXPECTED_ERROR');
951: FND_MESSAGE.SET_TOKEN('TEXT',
952: l_msg_data,

Line 955: APP_EXCEPTION.Raise_Exception;

951: FND_MESSAGE.SET_TOKEN('TEXT',
952: l_msg_data,
953: FALSE);
954: IF FND_API.To_Boolean(p_called_by_form) THEN
955: APP_EXCEPTION.Raise_Exception;
956: END IF;
957:
958: END Check_Primary_Key;
959:

Line 1023: APP_EXCEPTION.Raise_Exception;

1019: 'GR_RECORD_NOT_FOUND');
1020: FND_MESSAGE.SET_TOKEN('CODE',
1021: p_document_code,
1022: FALSE);
1023: APP_EXCEPTION.Raise_Exception;
1024: WHEN RECORD_CHANGED_ERROR THEN
1025: X_return_status := 'E';
1026: FND_MESSAGE.SET_NAME('FND',
1027: 'FORM_RECORD_CHANGED');

Line 1028: APP_EXCEPTION.Raise_Exception;

1024: WHEN RECORD_CHANGED_ERROR THEN
1025: X_return_status := 'E';
1026: FND_MESSAGE.SET_NAME('FND',
1027: 'FORM_RECORD_CHANGED');
1028: APP_EXCEPTION.Raise_Exception;
1029: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1030: ROLLBACK TO SAVEPOINT Lock_Rows;
1031: x_return_status := 'L';
1032: WHEN OTHERS THEN

Line 1029: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

1025: X_return_status := 'E';
1026: FND_MESSAGE.SET_NAME('FND',
1027: 'FORM_RECORD_CHANGED');
1028: APP_EXCEPTION.Raise_Exception;
1029: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1030: ROLLBACK TO SAVEPOINT Lock_Rows;
1031: x_return_status := 'L';
1032: WHEN OTHERS THEN
1033: ROLLBACK TO SAVEPOINT Lock_Rows;

Line 1035: x_oracle_error := APP_EXCEPTION.Get_Code;

1031: x_return_status := 'L';
1032: WHEN OTHERS THEN
1033: ROLLBACK TO SAVEPOINT Lock_Rows;
1034: x_return_status := 'U';
1035: x_oracle_error := APP_EXCEPTION.Get_Code;
1036: l_msg_data := APP_EXCEPTION.Get_Text;
1037: FND_MESSAGE.SET_NAME('GR',
1038: 'GR_UNEXPECTED_ERROR');
1039: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1036: l_msg_data := APP_EXCEPTION.Get_Text;

1032: WHEN OTHERS THEN
1033: ROLLBACK TO SAVEPOINT Lock_Rows;
1034: x_return_status := 'U';
1035: x_oracle_error := APP_EXCEPTION.Get_Code;
1036: l_msg_data := APP_EXCEPTION.Get_Text;
1037: FND_MESSAGE.SET_NAME('GR',
1038: 'GR_UNEXPECTED_ERROR');
1039: FND_MESSAGE.SET_TOKEN('TEXT',
1040: l_msg_data,

Line 1042: APP_EXCEPTION.Raise_Exception;

1038: 'GR_UNEXPECTED_ERROR');
1039: FND_MESSAGE.SET_TOKEN('TEXT',
1040: l_msg_data,
1041: FALSE);
1042: APP_EXCEPTION.Raise_Exception;
1043:
1044: END Lock_Rows;
1045:
1046: END GR_DOCUMENT_HEADINGS_PKG;