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_ITEM_GROUPS_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_item_group_code || ' ' || p_language;
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_item_group_code || ' ' || p_language;
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_item_group_code || ' ' || p_language;
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_item_group_code || ' ' || p_language;
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 485: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 492: APP_EXCEPTION.Raise_Exception;

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

Line 500: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 507: APP_EXCEPTION.Raise_Exception;

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

Line 593: APP_EXCEPTION.Raise_Exception;

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

Line 601: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 605: APP_EXCEPTION.Raise_Exception;

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

Line 613: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 614: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 621: APP_EXCEPTION.Raise_Exception;

617: FND_MESSAGE.SET_TOKEN('TEXT',
618: l_msg_token,
619: FALSE);
620: IF FND_API.To_Boolean(p_called_by_form) THEN
621: APP_EXCEPTION.Raise_Exception;
622: ELSE
623: x_msg_data := FND_MESSAGE.Get;
624: END IF;
625:

Line 716: APP_EXCEPTION.Raise_Exception;

712: ROLLBACK TO SAVEPOINT Delete_Row;
713: x_return_status := l_return_status;
714: x_oracle_error := l_oracle_error;
715: IF FND_API.To_Boolean(p_called_by_form) THEN
716: APP_EXCEPTION.Raise_Exception;
717: ELSE
718: x_msg_data := FND_MESSAGE.Get;
719: END IF;
720:

Line 724: x_oracle_error := APP_EXCEPTION.Get_Code;

720:
721: WHEN Row_Missing_Error THEN
722: ROLLBACK TO SAVEPOINT Delete_Row;
723: x_return_status := 'E';
724: x_oracle_error := APP_EXCEPTION.Get_Code;
725: FND_MESSAGE.SET_NAME('GR',
726: 'GR_RECORD_NOT_FOUND');
727: FND_MESSAGE.SET_TOKEN('CODE',
728: l_msg_token,

Line 731: APP_EXCEPTION.Raise_Exception;

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

Line 739: x_oracle_error := APP_EXCEPTION.Get_Code;

735:
736: WHEN OTHERS THEN
737: ROLLBACK TO SAVEPOINT Delete_Row;
738: x_return_status := 'U';
739: x_oracle_error := APP_EXCEPTION.Get_Code;
740: l_msg_data := APP_EXCEPTION.Get_Text;
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');

Line 740: l_msg_data := APP_EXCEPTION.Get_Text;

736: WHEN OTHERS THEN
737: ROLLBACK TO SAVEPOINT Delete_Row;
738: x_return_status := 'U';
739: x_oracle_error := APP_EXCEPTION.Get_Code;
740: l_msg_data := APP_EXCEPTION.Get_Text;
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',

Line 741: l_msg_data := APP_EXCEPTION.Get_Text;

737: ROLLBACK TO SAVEPOINT Delete_Row;
738: x_return_status := 'U';
739: x_oracle_error := APP_EXCEPTION.Get_Code;
740: l_msg_data := APP_EXCEPTION.Get_Text;
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_token,

Line 748: APP_EXCEPTION.Raise_Exception;

744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_token,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;
749: ELSE
750: x_msg_data := FND_MESSAGE.Get;
751: END IF;
752:

Line 798: x_oracle_error := APP_EXCEPTION.Get_Code;

794:
795: WHEN OTHERS THEN
796: ROLLBACK TO SAVEPOINT Delete_Rows;
797: x_return_status := 'U';
798: x_oracle_error := APP_EXCEPTION.Get_Code;
799: l_msg_data := APP_EXCEPTION.Get_Text;
800: FND_MESSAGE.SET_NAME('GR',
801: 'GR_UNEXPECTED_ERROR');
802: FND_MESSAGE.SET_TOKEN('TEXT',

Line 799: l_msg_data := APP_EXCEPTION.Get_Text;

795: WHEN OTHERS THEN
796: ROLLBACK TO SAVEPOINT Delete_Rows;
797: x_return_status := 'U';
798: x_oracle_error := APP_EXCEPTION.Get_Code;
799: l_msg_data := APP_EXCEPTION.Get_Text;
800: FND_MESSAGE.SET_NAME('GR',
801: 'GR_UNEXPECTED_ERROR');
802: FND_MESSAGE.SET_TOKEN('TEXT',
803: l_msg_token,

Line 806: APP_EXCEPTION.Raise_Exception;

802: FND_MESSAGE.SET_TOKEN('TEXT',
803: l_msg_token,
804: FALSE);
805: IF FND_API.To_Boolean(p_called_by_form) THEN
806: APP_EXCEPTION.Raise_Exception;
807: ELSE
808: x_msg_data := FND_MESSAGE.Get;
809: END IF;
810:

Line 861: x_oracle_error := APP_EXCEPTION.Get_Code;

857: FETCH c_get_language INTO LangRecord;
858: IF c_get_language%NOTFOUND THEN
859: l_msg_token := l_language_code;
860: x_return_status := 'E';
861: x_oracle_error := APP_EXCEPTION.Get_Code;
862: FND_MESSAGE.SET_NAME('GR',
863: 'GR_RECORD_NOT_FOUND');
864: FND_MESSAGE.SET_TOKEN('CODE',
865: l_msg_token,

Line 877: x_oracle_error := APP_EXCEPTION.Get_Code;

873: FETCH c_get_language INTO LangRecord;
874: IF c_get_language%NOTFOUND THEN
875: l_msg_token := l_language_code;
876: x_return_status := 'E';
877: x_oracle_error := APP_EXCEPTION.Get_Code;
878: FND_MESSAGE.SET_NAME('GR',
879: 'GR_RECORD_NOT_FOUND');
880: FND_MESSAGE.SET_TOKEN('CODE',
881: l_msg_token,

Line 896: x_oracle_error := APP_EXCEPTION.Get_Code;

892:
893: WHEN OTHERS THEN
894: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
895: x_return_status := 'U';
896: x_oracle_error := APP_EXCEPTION.Get_Code;
897: l_msg_data := APP_EXCEPTION.Get_Text;
898: FND_MESSAGE.SET_NAME('GR',
899: 'GR_UNEXPECTED_ERROR');
900: FND_MESSAGE.SET_TOKEN('TEXT',

Line 897: l_msg_data := APP_EXCEPTION.Get_Text;

893: WHEN OTHERS THEN
894: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
895: x_return_status := 'U';
896: x_oracle_error := APP_EXCEPTION.Get_Code;
897: l_msg_data := APP_EXCEPTION.Get_Text;
898: FND_MESSAGE.SET_NAME('GR',
899: 'GR_UNEXPECTED_ERROR');
900: FND_MESSAGE.SET_TOKEN('TEXT',
901: l_msg_token,

Line 973: APP_EXCEPTION.Raise_Exception;

969: FND_MESSAGE.SET_TOKEN('CODE',
970: p_language,
971: FALSE);
972: IF FND_API.To_Boolean(p_called_by_form) THEN
973: APP_EXCEPTION.Raise_Exception;
974: ELSE
975: x_msg_data := FND_MESSAGE.Get;
976: END IF;
977:

Line 981: x_oracle_error := APP_EXCEPTION.Get_Code;

977:
978: WHEN OTHERS THEN
979: ROLLBACK TO SAVEPOINT Check_Integrity;
980: x_return_status := 'U';
981: x_oracle_error := APP_EXCEPTION.Get_Code;
982: l_msg_data := APP_EXCEPTION.Get_Text;
983: FND_MESSAGE.SET_NAME('GR',
984: 'GR_UNEXPECTED_ERROR');
985: FND_MESSAGE.SET_TOKEN('TEXT',

Line 982: l_msg_data := APP_EXCEPTION.Get_Text;

978: WHEN OTHERS THEN
979: ROLLBACK TO SAVEPOINT Check_Integrity;
980: x_return_status := 'U';
981: x_oracle_error := APP_EXCEPTION.Get_Code;
982: l_msg_data := APP_EXCEPTION.Get_Text;
983: FND_MESSAGE.SET_NAME('GR',
984: 'GR_UNEXPECTED_ERROR');
985: FND_MESSAGE.SET_TOKEN('TEXT',
986: l_msg_data,

Line 989: APP_EXCEPTION.Raise_Exception;

985: FND_MESSAGE.SET_TOKEN('TEXT',
986: l_msg_data,
987: FALSE);
988: IF FND_API.To_Boolean(p_called_by_form) THEN
989: APP_EXCEPTION.Raise_Exception;
990: ELSE
991: x_msg_data := FND_MESSAGE.Get;
992: END IF;
993:

Line 1042: l_msg_data := APP_EXCEPTION.Get_Text;

1038:
1039: EXCEPTION
1040:
1041: WHEN Others THEN
1042: l_msg_data := APP_EXCEPTION.Get_Text;
1043: FND_MESSAGE.SET_NAME('GR',
1044: 'GR_UNEXPECTED_ERROR');
1045: FND_MESSAGE.SET_TOKEN('TEXT',
1046: l_msg_data,

Line 1049: APP_EXCEPTION.Raise_Exception;

1045: FND_MESSAGE.SET_TOKEN('TEXT',
1046: l_msg_data,
1047: FALSE);
1048: IF FND_API.To_Boolean(p_called_by_form) THEN
1049: APP_EXCEPTION.Raise_Exception;
1050: END IF;
1051:
1052: END Check_Primary_Key;
1053: