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

Line 130: APP_EXCEPTION.Raise_Exception;

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

Line 139: x_oracle_error := APP_EXCEPTION.Get_Code;

135: WHEN Item_Exists_Error THEN
136: ROLLBACK TO SAVEPOINT Insert_Row;
137: l_msg_token := p_sub_heading_code;
138: x_return_status := 'E';
139: x_oracle_error := APP_EXCEPTION.Get_Code;
140: FND_MESSAGE.SET_NAME('GR',
141: 'GR_RECORD_EXISTS');
142: FND_MESSAGE.SET_TOKEN('CODE',
143: l_msg_token,

Line 146: APP_EXCEPTION.Raise_Exception;

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

Line 155: x_oracle_error := APP_EXCEPTION.Get_Code;

151: WHEN Row_Missing_Error THEN
152: ROLLBACK TO SAVEPOINT Insert_Row;
153: l_msg_token := p_sub_heading_code;
154: x_return_status := 'E';
155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: FND_MESSAGE.SET_NAME('GR',
157: 'GR_NO_RECORD_INSERTED');
158: FND_MESSAGE.SET_TOKEN('CODE',
159: l_msg_token,

Line 162: APP_EXCEPTION.Raise_Exception;

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

Line 171: x_oracle_error := APP_EXCEPTION.Get_Code;

167: WHEN OTHERS THEN
168: ROLLBACK TO SAVEPOINT Insert_Row;
169: l_msg_token := p_sub_heading_code;
170: x_return_status := 'U';
171: x_oracle_error := APP_EXCEPTION.Get_Code;
172: l_msg_data := APP_EXCEPTION.Get_Text;
173: FND_MESSAGE.SET_NAME('GR',
174: 'GR_UNEXPECTED_ERROR');
175: FND_MESSAGE.SET_TOKEN('TEXT',

Line 172: l_msg_data := APP_EXCEPTION.Get_Text;

168: ROLLBACK TO SAVEPOINT Insert_Row;
169: l_msg_token := p_sub_heading_code;
170: x_return_status := 'U';
171: x_oracle_error := APP_EXCEPTION.Get_Code;
172: l_msg_data := APP_EXCEPTION.Get_Text;
173: FND_MESSAGE.SET_NAME('GR',
174: 'GR_UNEXPECTED_ERROR');
175: FND_MESSAGE.SET_TOKEN('TEXT',
176: l_msg_token,

Line 179: APP_EXCEPTION.Raise_Exception;

175: FND_MESSAGE.SET_TOKEN('TEXT',
176: l_msg_token,
177: FALSE);
178: IF FND_API.To_Boolean(p_called_by_form) THEN
179: APP_EXCEPTION.Raise_Exception;
180: ELSE
181: x_msg_data := FND_MESSAGE.Get;
182: END IF;
183:

Line 277: APP_EXCEPTION.Raise_Exception;

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

Line 285: x_oracle_error := APP_EXCEPTION.Get_Code;

281:
282: WHEN Row_Missing_Error THEN
283: ROLLBACK TO SAVEPOINT Update_Row;
284: x_return_status := 'E';
285: x_oracle_error := APP_EXCEPTION.Get_Code;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_NO_RECORD_INSERTED');
288: FND_MESSAGE.SET_TOKEN('CODE',
289: l_msg_token,

Line 292: APP_EXCEPTION.Raise_Exception;

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

Line 300: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 301: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 308: APP_EXCEPTION.Raise_Exception;

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

Line 483: x_oracle_error := APP_EXCEPTION.Get_Code;

479:
480: WHEN Language_Missing_Error THEN
481: ROLLBACK TO SAVEPOINT Add_Language;
482: x_return_status := 'E';
483: x_oracle_error := APP_EXCEPTION.Get_Code;
484: FND_MESSAGE.SET_NAME('GR',
485: 'GR_RECORD_NOT_FOUND');
486: FND_MESSAGE.SET_TOKEN('CODE',
487: l_msg_token,

Line 490: APP_EXCEPTION.Raise_Exception;

486: FND_MESSAGE.SET_TOKEN('CODE',
487: l_msg_token,
488: FALSE);
489: IF FND_API.To_Boolean(p_called_by_form) THEN
490: APP_EXCEPTION.Raise_Exception;
491: ELSE
492: x_msg_data := FND_MESSAGE.Get;
493: END IF;
494:

Line 498: x_oracle_error := APP_EXCEPTION.Get_Code;

494:
495: WHEN OTHERS THEN
496: ROLLBACK TO SAVEPOINT Add_Language;
497: x_return_status := 'U';
498: x_oracle_error := APP_EXCEPTION.Get_Code;
499: FND_MESSAGE.SET_NAME('GR',
500: 'GR_UNEXPECTED_ERROR');
501: FND_MESSAGE.SET_TOKEN('TEXT',
502: l_msg_token,

Line 505: APP_EXCEPTION.Raise_Exception;

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

Line 591: APP_EXCEPTION.Raise_Exception;

587: FND_MESSAGE.SET_TOKEN('CODE',
588: l_msg_token,
589: FALSE);
590: IF FND_API.To_Boolean(p_called_by_form) THEN
591: APP_EXCEPTION.Raise_Exception;
592: ELSE
593: x_msg_data := FND_MESSAGE.Get;
594: END IF;
595:

Line 599: x_oracle_error := APP_EXCEPTION.Get_Code;

595:
596: WHEN Row_Already_Locked_Error THEN
597: ROLLBACK TO SAVEPOINT Lock_Row;
598: x_return_status := 'E';
599: x_oracle_error := APP_EXCEPTION.Get_Code;
600: FND_MESSAGE.SET_NAME('GR',
601: 'GR_ROW_IS_LOCKED');
602: IF FND_API.To_Boolean(p_called_by_form) THEN
603: APP_EXCEPTION.Raise_Exception;

Line 603: APP_EXCEPTION.Raise_Exception;

599: x_oracle_error := APP_EXCEPTION.Get_Code;
600: FND_MESSAGE.SET_NAME('GR',
601: 'GR_ROW_IS_LOCKED');
602: IF FND_API.To_Boolean(p_called_by_form) THEN
603: APP_EXCEPTION.Raise_Exception;
604: ELSE
605: x_msg_data := FND_MESSAGE.Get;
606: END IF;
607:

Line 611: x_oracle_error := APP_EXCEPTION.Get_Code;

607:
608: WHEN OTHERS THEN
609: ROLLBACK TO SAVEPOINT Lock_Row;
610: x_return_status := 'U';
611: x_oracle_error := APP_EXCEPTION.Get_Code;
612: l_msg_data := APP_EXCEPTION.Get_Text;
613: FND_MESSAGE.SET_NAME('GR',
614: 'GR_UNEXPECTED_ERROR');
615: FND_MESSAGE.SET_TOKEN('TEXT',

Line 612: l_msg_data := APP_EXCEPTION.Get_Text;

608: WHEN OTHERS THEN
609: ROLLBACK TO SAVEPOINT Lock_Row;
610: x_return_status := 'U';
611: x_oracle_error := APP_EXCEPTION.Get_Code;
612: l_msg_data := APP_EXCEPTION.Get_Text;
613: FND_MESSAGE.SET_NAME('GR',
614: 'GR_UNEXPECTED_ERROR');
615: FND_MESSAGE.SET_TOKEN('TEXT',
616: l_msg_token,

Line 619: APP_EXCEPTION.Raise_Exception;

615: FND_MESSAGE.SET_TOKEN('TEXT',
616: l_msg_token,
617: FALSE);
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 706: APP_EXCEPTION.Raise_Exception;

702: ROLLBACK TO SAVEPOINT Delete_Row;
703: x_return_status := l_return_status;
704: x_oracle_error := l_oracle_error;
705: IF FND_API.To_Boolean(p_called_by_form) THEN
706: APP_EXCEPTION.Raise_Exception;
707: ELSE
708: x_msg_data := FND_MESSAGE.Get;
709: END IF;
710:

Line 714: x_oracle_error := APP_EXCEPTION.Get_Code;

710:
711: WHEN Row_Missing_Error THEN
712: ROLLBACK TO SAVEPOINT Delete_Row;
713: x_return_status := 'E';
714: x_oracle_error := APP_EXCEPTION.Get_Code;
715: FND_MESSAGE.SET_NAME('GR',
716: 'GR_RECORD_NOT_FOUND');
717: FND_MESSAGE.SET_TOKEN('CODE',
718: l_msg_token,

Line 721: APP_EXCEPTION.Raise_Exception;

717: FND_MESSAGE.SET_TOKEN('CODE',
718: l_msg_token,
719: FALSE);
720: IF FND_API.To_Boolean(p_called_by_form) THEN
721: APP_EXCEPTION.Raise_Exception;
722: ELSE
723: x_msg_data := FND_MESSAGE.Get;
724: END IF;
725:

Line 729: x_oracle_error := APP_EXCEPTION.Get_Code;

725:
726: WHEN OTHERS THEN
727: ROLLBACK TO SAVEPOINT Delete_Row;
728: x_return_status := 'U';
729: x_oracle_error := APP_EXCEPTION.Get_Code;
730: l_msg_data := APP_EXCEPTION.Get_Text;
731: FND_MESSAGE.SET_NAME('GR',
732: 'GR_UNEXPECTED_ERROR');
733: FND_MESSAGE.SET_TOKEN('TEXT',

Line 730: l_msg_data := APP_EXCEPTION.Get_Text;

726: WHEN OTHERS THEN
727: ROLLBACK TO SAVEPOINT Delete_Row;
728: x_return_status := 'U';
729: x_oracle_error := APP_EXCEPTION.Get_Code;
730: l_msg_data := APP_EXCEPTION.Get_Text;
731: FND_MESSAGE.SET_NAME('GR',
732: 'GR_UNEXPECTED_ERROR');
733: FND_MESSAGE.SET_TOKEN('TEXT',
734: l_msg_data,

Line 737: APP_EXCEPTION.Raise_Exception;

733: FND_MESSAGE.SET_TOKEN('TEXT',
734: l_msg_data,
735: FALSE);
736: IF FND_API.To_Boolean(p_called_by_form) THEN
737: APP_EXCEPTION.Raise_Exception;
738: ELSE
739: x_msg_data := FND_MESSAGE.Get;
740: END IF;
741:

Line 787: x_oracle_error := APP_EXCEPTION.Get_Code;

783:
784: WHEN OTHERS THEN
785: ROLLBACK TO SAVEPOINT Delete_Rows;
786: x_return_status := 'U';
787: x_oracle_error := APP_EXCEPTION.Get_Code;
788: l_msg_data := APP_EXCEPTION.Get_Text;
789: FND_MESSAGE.SET_NAME('GR',
790: 'GR_UNEXPECTED_ERROR');
791: FND_MESSAGE.SET_TOKEN('TEXT',

Line 788: l_msg_data := APP_EXCEPTION.Get_Text;

784: WHEN OTHERS THEN
785: ROLLBACK TO SAVEPOINT Delete_Rows;
786: x_return_status := 'U';
787: x_oracle_error := APP_EXCEPTION.Get_Code;
788: l_msg_data := APP_EXCEPTION.Get_Text;
789: FND_MESSAGE.SET_NAME('GR',
790: 'GR_UNEXPECTED_ERROR');
791: FND_MESSAGE.SET_TOKEN('TEXT',
792: l_msg_token,

Line 795: APP_EXCEPTION.Raise_Exception;

791: FND_MESSAGE.SET_TOKEN('TEXT',
792: l_msg_token,
793: FALSE);
794: IF FND_API.To_Boolean(p_called_by_form) THEN
795: APP_EXCEPTION.Raise_Exception;
796: ELSE
797: x_msg_data := FND_MESSAGE.Get;
798: END IF;
799:

Line 873: x_oracle_error := APP_EXCEPTION.Get_Code;

869:
870: WHEN Row_Missing_Error THEN
871: ROLLBACK TO SAVEPOINT Delete_Row;
872: x_return_status := 'E';
873: x_oracle_error := APP_EXCEPTION.Get_Code;
874: FND_MESSAGE.SET_NAME('GR',
875: 'GR_RECORD_NOT_FOUND');
876: FND_MESSAGE.SET_TOKEN('CODE',
877: l_msg_token,

Line 884: x_oracle_error := APP_EXCEPTION.Get_Code;

880:
881: WHEN OTHERS THEN
882: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
883: x_return_status := 'U';
884: x_oracle_error := APP_EXCEPTION.Get_Code;
885: l_msg_data := APP_EXCEPTION.Get_Text;
886: FND_MESSAGE.SET_NAME('GR',
887: 'GR_UNEXPECTED_ERROR');
888: FND_MESSAGE.SET_TOKEN('TEXT',

Line 885: l_msg_data := APP_EXCEPTION.Get_Text;

881: WHEN OTHERS THEN
882: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
883: x_return_status := 'U';
884: x_oracle_error := APP_EXCEPTION.Get_Code;
885: l_msg_data := APP_EXCEPTION.Get_Text;
886: FND_MESSAGE.SET_NAME('GR',
887: 'GR_UNEXPECTED_ERROR');
888: FND_MESSAGE.SET_TOKEN('TEXT',
889: l_msg_token,

Line 962: APP_EXCEPTION.Raise_Exception;

958: FND_MESSAGE.SET_TOKEN('CODE',
959: p_language,
960: FALSE);
961: IF FND_API.To_Boolean(p_called_by_form) THEN
962: APP_EXCEPTION.Raise_Exception;
963: ELSE
964: x_msg_data := FND_MESSAGE.Get;
965: END IF;
966:

Line 970: x_oracle_error := APP_EXCEPTION.Get_Code;

966:
967: WHEN OTHERS THEN
968: ROLLBACK TO SAVEPOINT Check_Integrity;
969: x_return_status := 'U';
970: x_oracle_error := APP_EXCEPTION.Get_Code;
971: l_msg_data := APP_EXCEPTION.Get_Text;
972: FND_MESSAGE.SET_NAME('GR',
973: 'GR_UNEXPECTED_ERROR');
974: FND_MESSAGE.SET_TOKEN('TEXT',

Line 971: l_msg_data := APP_EXCEPTION.Get_Text;

967: WHEN OTHERS THEN
968: ROLLBACK TO SAVEPOINT Check_Integrity;
969: x_return_status := 'U';
970: x_oracle_error := APP_EXCEPTION.Get_Code;
971: l_msg_data := APP_EXCEPTION.Get_Text;
972: FND_MESSAGE.SET_NAME('GR',
973: 'GR_UNEXPECTED_ERROR');
974: FND_MESSAGE.SET_TOKEN('TEXT',
975: l_msg_data,

Line 978: APP_EXCEPTION.Raise_Exception;

974: FND_MESSAGE.SET_TOKEN('TEXT',
975: l_msg_data,
976: FALSE);
977: IF FND_API.To_Boolean(p_called_by_form) THEN
978: APP_EXCEPTION.Raise_Exception;
979: ELSE
980: x_msg_data := FND_MESSAGE.Get;
981: END IF;
982:

Line 1031: l_msg_data := APP_EXCEPTION.Get_Text;

1027:
1028: EXCEPTION
1029:
1030: WHEN Others THEN
1031: l_msg_data := APP_EXCEPTION.Get_Text;
1032: FND_MESSAGE.SET_NAME('GR',
1033: 'GR_UNEXPECTED_ERROR');
1034: FND_MESSAGE.SET_TOKEN('TEXT',
1035: l_msg_data,

Line 1038: APP_EXCEPTION.Raise_Exception;

1034: FND_MESSAGE.SET_TOKEN('TEXT',
1035: l_msg_data,
1036: FALSE);
1037: IF FND_API.To_Boolean(p_called_by_form) THEN
1038: APP_EXCEPTION.Raise_Exception;
1039: END IF;
1040:
1041: END Check_Primary_Key;
1042: