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_B_PKG dependencies on FND_MESSAGE

Line 119: FND_MESSAGE.SET_NAME('GR',

115: WHEN Foreign_Key_Error THEN
116: ROLLBACK TO SAVEPOINT Insert_Row;
117: x_return_status := l_return_status;
118: x_oracle_error := l_oracle_error;
119: FND_MESSAGE.SET_NAME('GR',
120: 'GR_FOREIGN_KEY_ERROR');
121: FND_MESSAGE.SET_TOKEN('TEXT',
122: l_msg_data,
123: FALSE);

Line 121: FND_MESSAGE.SET_TOKEN('TEXT',

117: x_return_status := l_return_status;
118: x_oracle_error := l_oracle_error;
119: FND_MESSAGE.SET_NAME('GR',
120: 'GR_FOREIGN_KEY_ERROR');
121: FND_MESSAGE.SET_TOKEN('TEXT',
122: l_msg_data,
123: FALSE);
124: x_msg_data := FND_MESSAGE.Get;
125: IF FND_API.To_Boolean(p_called_by_form) THEN

Line 124: x_msg_data := FND_MESSAGE.Get;

120: 'GR_FOREIGN_KEY_ERROR');
121: FND_MESSAGE.SET_TOKEN('TEXT',
122: l_msg_data,
123: FALSE);
124: x_msg_data := FND_MESSAGE.Get;
125: IF FND_API.To_Boolean(p_called_by_form) THEN
126: APP_EXCEPTION.Raise_Exception;
127: END IF;
128:

Line 133: FND_MESSAGE.SET_NAME('GR',

129: WHEN Item_Exists_Error THEN
130: ROLLBACK TO SAVEPOINT Insert_Row;
131: x_return_status := 'E';
132: x_oracle_error := APP_EXCEPTION.Get_Code;
133: FND_MESSAGE.SET_NAME('GR',
134: 'GR_RECORD_EXISTS');
135: FND_MESSAGE.SET_TOKEN('CODE',
136: p_item_group_code,
137: FALSE);

Line 135: FND_MESSAGE.SET_TOKEN('CODE',

131: x_return_status := 'E';
132: x_oracle_error := APP_EXCEPTION.Get_Code;
133: FND_MESSAGE.SET_NAME('GR',
134: 'GR_RECORD_EXISTS');
135: FND_MESSAGE.SET_TOKEN('CODE',
136: p_item_group_code,
137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;

Line 141: x_msg_data := FND_MESSAGE.Get;

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:
144: WHEN Row_Missing_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;

Line 148: FND_MESSAGE.SET_NAME('GR',

144: WHEN Row_Missing_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_NO_RECORD_INSERTED');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_item_group_code,
152: FALSE);

Line 150: FND_MESSAGE.SET_TOKEN('CODE',

146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_NO_RECORD_INSERTED');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_item_group_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;

Line 156: x_msg_data := FND_MESSAGE.Get;

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:
159: WHEN OTHERS THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;

Line 164: FND_MESSAGE.SET_NAME('GR',

160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'U';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: l_msg_data := APP_EXCEPTION.Get_Text;
164: FND_MESSAGE.SET_NAME('GR',
165: 'GR_UNEXPECTED_ERROR');
166: FND_MESSAGE.SET_TOKEN('TEXT',
167: l_msg_data,
168: FALSE);

Line 166: FND_MESSAGE.SET_TOKEN('TEXT',

162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: l_msg_data := APP_EXCEPTION.Get_Text;
164: FND_MESSAGE.SET_NAME('GR',
165: 'GR_UNEXPECTED_ERROR');
166: FND_MESSAGE.SET_TOKEN('TEXT',
167: l_msg_data,
168: FALSE);
169: IF FND_API.To_Boolean(p_called_by_form) THEN
170: APP_EXCEPTION.Raise_Exception;

Line 172: x_msg_data := FND_MESSAGE.Get;

168: FALSE);
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:
175: END Insert_Row;
176:

Line 258: FND_MESSAGE.SET_NAME('GR',

254: WHEN Foreign_Key_Error THEN
255: ROLLBACK TO SAVEPOINT Update_Row;
256: x_return_status := l_return_status;
257: x_oracle_error := l_oracle_error;
258: FND_MESSAGE.SET_NAME('GR',
259: 'GR_FOREIGN_KEY_ERROR');
260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);

Line 260: FND_MESSAGE.SET_TOKEN('TEXT',

256: x_return_status := l_return_status;
257: x_oracle_error := l_oracle_error;
258: FND_MESSAGE.SET_NAME('GR',
259: 'GR_FOREIGN_KEY_ERROR');
260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;

Line 266: x_msg_data := FND_MESSAGE.Get;

262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;
265: ELSE
266: x_msg_data := FND_MESSAGE.Get;
267: END IF;
268:
269: WHEN Row_Missing_Error THEN
270: ROLLBACK TO SAVEPOINT Update_Row;

Line 273: FND_MESSAGE.SET_NAME('GR',

269: WHEN Row_Missing_Error THEN
270: ROLLBACK TO SAVEPOINT Update_Row;
271: x_return_status := 'E';
272: x_oracle_error := APP_EXCEPTION.Get_Code;
273: FND_MESSAGE.SET_NAME('GR',
274: 'GR_NO_RECORD_INSERTED');
275: FND_MESSAGE.SET_TOKEN('CODE',
276: p_item_group_code,
277: FALSE);

Line 275: FND_MESSAGE.SET_TOKEN('CODE',

271: x_return_status := 'E';
272: x_oracle_error := APP_EXCEPTION.Get_Code;
273: FND_MESSAGE.SET_NAME('GR',
274: 'GR_NO_RECORD_INSERTED');
275: FND_MESSAGE.SET_TOKEN('CODE',
276: p_item_group_code,
277: FALSE);
278: IF FND_API.To_Boolean(p_called_by_form) THEN
279: APP_EXCEPTION.Raise_Exception;

Line 281: x_msg_data := FND_MESSAGE.Get;

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:
284: WHEN OTHERS THEN
285: ROLLBACK TO SAVEPOINT Update_Row;

Line 289: FND_MESSAGE.SET_NAME('GR',

285: ROLLBACK TO SAVEPOINT Update_Row;
286: x_return_status := 'U';
287: x_oracle_error := APP_EXCEPTION.Get_Code;
288: l_msg_data := APP_EXCEPTION.Get_Text;
289: FND_MESSAGE.SET_NAME('GR',
290: 'GR_UNEXPECTED_ERROR');
291: FND_MESSAGE.SET_TOKEN('TEXT',
292: l_msg_data,
293: FALSE);

Line 291: FND_MESSAGE.SET_TOKEN('TEXT',

287: x_oracle_error := APP_EXCEPTION.Get_Code;
288: l_msg_data := APP_EXCEPTION.Get_Text;
289: FND_MESSAGE.SET_NAME('GR',
290: 'GR_UNEXPECTED_ERROR');
291: FND_MESSAGE.SET_TOKEN('TEXT',
292: l_msg_data,
293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;

Line 297: x_msg_data := FND_MESSAGE.Get;

293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;
296: ELSE
297: x_msg_data := FND_MESSAGE.Get;
298: END IF;
299:
300: END Update_Row;
301:

Line 372: FND_MESSAGE.SET_NAME('GR',

368:
369: WHEN No_Data_Found_Error THEN
370: ROLLBACK TO SAVEPOINT Lock_Row;
371: x_return_status := 'E';
372: FND_MESSAGE.SET_NAME('GR',
373: 'GR_RECORD_NOT_FOUND');
374: FND_MESSAGE.SET_TOKEN('CODE',
375: p_item_group_code,
376: FALSE);

Line 374: FND_MESSAGE.SET_TOKEN('CODE',

370: ROLLBACK TO SAVEPOINT Lock_Row;
371: x_return_status := 'E';
372: FND_MESSAGE.SET_NAME('GR',
373: 'GR_RECORD_NOT_FOUND');
374: FND_MESSAGE.SET_TOKEN('CODE',
375: p_item_group_code,
376: FALSE);
377: IF FND_API.To_Boolean(p_called_by_form) THEN
378: APP_EXCEPTION.Raise_Exception;

Line 380: x_msg_data := FND_MESSAGE.Get;

376: FALSE);
377: IF FND_API.To_Boolean(p_called_by_form) THEN
378: APP_EXCEPTION.Raise_Exception;
379: ELSE
380: x_msg_data := FND_MESSAGE.Get;
381: END IF;
382:
383: WHEN Row_Already_Locked_Error THEN
384: ROLLBACK TO SAVEPOINT Lock_Row;

Line 387: FND_MESSAGE.SET_NAME('GR',

383: WHEN Row_Already_Locked_Error THEN
384: ROLLBACK TO SAVEPOINT Lock_Row;
385: x_return_status := 'E';
386: x_oracle_error := APP_EXCEPTION.Get_Code;
387: FND_MESSAGE.SET_NAME('GR',
388: 'GR_ROW_IS_LOCKED');
389: IF FND_API.To_Boolean(p_called_by_form) THEN
390: APP_EXCEPTION.Raise_Exception;
391: ELSE

Line 392: x_msg_data := FND_MESSAGE.Get;

388: 'GR_ROW_IS_LOCKED');
389: IF FND_API.To_Boolean(p_called_by_form) THEN
390: APP_EXCEPTION.Raise_Exception;
391: ELSE
392: x_msg_data := FND_MESSAGE.Get;
393: END IF;
394:
395: WHEN OTHERS THEN
396: ROLLBACK TO SAVEPOINT Lock_Row;

Line 400: FND_MESSAGE.SET_NAME('GR',

396: ROLLBACK TO SAVEPOINT Lock_Row;
397: x_return_status := 'U';
398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: l_msg_data := APP_EXCEPTION.Get_Text;
400: FND_MESSAGE.SET_NAME('GR',
401: 'GR_UNEXPECTED_ERROR');
402: FND_MESSAGE.SET_TOKEN('TEXT',
403: l_msg_data,
404: FALSE);

Line 402: FND_MESSAGE.SET_TOKEN('TEXT',

398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: l_msg_data := APP_EXCEPTION.Get_Text;
400: FND_MESSAGE.SET_NAME('GR',
401: 'GR_UNEXPECTED_ERROR');
402: FND_MESSAGE.SET_TOKEN('TEXT',
403: l_msg_data,
404: FALSE);
405: IF FND_API.To_Boolean(p_called_by_form) THEN
406: APP_EXCEPTION.Raise_Exception;

Line 408: x_msg_data := FND_MESSAGE.Get;

404: FALSE);
405: IF FND_API.To_Boolean(p_called_by_form) THEN
406: APP_EXCEPTION.Raise_Exception;
407: ELSE
408: x_msg_data := FND_MESSAGE.Get;
409: END IF;
410:
411: END Lock_Row;
412:

Line 486: x_msg_data := FND_MESSAGE.Get;

482: x_oracle_error := l_oracle_error;
483: IF FND_API.To_Boolean(p_called_by_form) THEN
484: APP_EXCEPTION.Raise_Exception;
485: ELSE
486: x_msg_data := FND_MESSAGE.Get;
487: END IF;
488:
489: WHEN Row_Missing_Error THEN
490: ROLLBACK TO SAVEPOINT Delete_Row;

Line 493: FND_MESSAGE.SET_NAME('GR',

489: WHEN Row_Missing_Error THEN
490: ROLLBACK TO SAVEPOINT Delete_Row;
491: x_return_status := 'E';
492: x_oracle_error := APP_EXCEPTION.Get_Code;
493: FND_MESSAGE.SET_NAME('GR',
494: 'GR_RECORD_NOT_FOUND');
495: FND_MESSAGE.SET_TOKEN('CODE',
496: p_item_group_code,
497: FALSE);

Line 495: FND_MESSAGE.SET_TOKEN('CODE',

491: x_return_status := 'E';
492: x_oracle_error := APP_EXCEPTION.Get_Code;
493: FND_MESSAGE.SET_NAME('GR',
494: 'GR_RECORD_NOT_FOUND');
495: FND_MESSAGE.SET_TOKEN('CODE',
496: p_item_group_code,
497: FALSE);
498: IF FND_API.To_Boolean(p_called_by_form) THEN
499: APP_EXCEPTION.Raise_Exception;

Line 501: x_msg_data := FND_MESSAGE.Get;

497: FALSE);
498: IF FND_API.To_Boolean(p_called_by_form) THEN
499: APP_EXCEPTION.Raise_Exception;
500: ELSE
501: x_msg_data := FND_MESSAGE.Get;
502: END IF;
503:
504: WHEN OTHERS THEN
505: ROLLBACK TO SAVEPOINT Delete_Row;

Line 510: FND_MESSAGE.SET_NAME('GR',

506: x_return_status := 'U';
507: x_oracle_error := APP_EXCEPTION.Get_Code;
508: l_msg_data := APP_EXCEPTION.Get_Text;
509: l_msg_data := APP_EXCEPTION.Get_Text;
510: FND_MESSAGE.SET_NAME('GR',
511: 'GR_UNEXPECTED_ERROR');
512: FND_MESSAGE.SET_TOKEN('TEXT',
513: l_msg_data,
514: FALSE);

Line 512: FND_MESSAGE.SET_TOKEN('TEXT',

508: l_msg_data := APP_EXCEPTION.Get_Text;
509: l_msg_data := APP_EXCEPTION.Get_Text;
510: FND_MESSAGE.SET_NAME('GR',
511: 'GR_UNEXPECTED_ERROR');
512: FND_MESSAGE.SET_TOKEN('TEXT',
513: l_msg_data,
514: FALSE);
515: IF FND_API.To_Boolean(p_called_by_form) THEN
516: APP_EXCEPTION.Raise_Exception;

Line 518: x_msg_data := FND_MESSAGE.Get;

514: FALSE);
515: IF FND_API.To_Boolean(p_called_by_form) THEN
516: APP_EXCEPTION.Raise_Exception;
517: ELSE
518: x_msg_data := FND_MESSAGE.Get;
519: END IF;
520:
521: END Delete_Row;
522:

Line 562: FND_MESSAGE.SET_NAME('GR',

558: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
559: x_return_status := 'U';
560: x_oracle_error := APP_EXCEPTION.Get_Code;
561: l_msg_data := APP_EXCEPTION.Get_Text;
562: FND_MESSAGE.SET_NAME('GR',
563: 'GR_UNEXPECTED_ERROR');
564: FND_MESSAGE.SET_TOKEN('TEXT',
565: l_msg_data,
566: FALSE);

Line 564: FND_MESSAGE.SET_TOKEN('TEXT',

560: x_oracle_error := APP_EXCEPTION.Get_Code;
561: l_msg_data := APP_EXCEPTION.Get_Text;
562: FND_MESSAGE.SET_NAME('GR',
563: 'GR_UNEXPECTED_ERROR');
564: FND_MESSAGE.SET_TOKEN('TEXT',
565: l_msg_data,
566: FALSE);
567: x_msg_data := FND_MESSAGE.Get;
568:

Line 567: x_msg_data := FND_MESSAGE.Get;

563: 'GR_UNEXPECTED_ERROR');
564: FND_MESSAGE.SET_TOKEN('TEXT',
565: l_msg_data,
566: FALSE);
567: x_msg_data := FND_MESSAGE.Get;
568:
569: END Check_Foreign_Keys;
570:
571: PROCEDURE Check_Integrity

Line 625: FND_MESSAGE.SET_NAME('GR',

621: EXCEPTION
622:
623: WHEN INTEGRITY_ERROR THEN
624: x_return_status := 'E';
625: FND_MESSAGE.SET_NAME('GR',
626: 'GR_INTEGRITY_HEADER');
627: FND_MESSAGE.SET_TOKEN('CODE',
628: p_item_group_code,
629: FALSE);

Line 627: FND_MESSAGE.SET_TOKEN('CODE',

623: WHEN INTEGRITY_ERROR THEN
624: x_return_status := 'E';
625: FND_MESSAGE.SET_NAME('GR',
626: 'GR_INTEGRITY_HEADER');
627: FND_MESSAGE.SET_TOKEN('CODE',
628: p_item_group_code,
629: FALSE);
630: FND_MESSAGE.SET_TOKEN('TABLES',
631: l_msg_data,

Line 630: FND_MESSAGE.SET_TOKEN('TABLES',

626: 'GR_INTEGRITY_HEADER');
627: FND_MESSAGE.SET_TOKEN('CODE',
628: p_item_group_code,
629: FALSE);
630: FND_MESSAGE.SET_TOKEN('TABLES',
631: l_msg_data,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;

Line 636: x_msg_data := FND_MESSAGE.Get;

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: WHEN OTHERS THEN
639: ROLLBACK TO SAVEPOINT Check_Integrity;
640: x_return_status := 'U';

Line 643: FND_MESSAGE.SET_NAME('GR',

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

Line 645: FND_MESSAGE.SET_TOKEN('TEXT',

641: x_oracle_error := APP_EXCEPTION.Get_Code;
642: l_msg_data := APP_EXCEPTION.Get_Text;
643: FND_MESSAGE.SET_NAME('GR',
644: 'GR_UNEXPECTED_ERROR');
645: FND_MESSAGE.SET_TOKEN('TEXT',
646: l_msg_data,
647: FALSE);
648: IF FND_API.To_Boolean(p_called_by_form) THEN
649: APP_EXCEPTION.Raise_Exception;

Line 651: x_msg_data := FND_MESSAGE.Get;

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

Line 690: FND_MESSAGE.SET_NAME('GR',

686: EXCEPTION
687:
688: WHEN Others THEN
689: l_msg_data := APP_EXCEPTION.Get_Text;
690: FND_MESSAGE.SET_NAME('GR',
691: 'GR_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('TEXT',
693: l_msg_data,
694: FALSE);

Line 692: FND_MESSAGE.SET_TOKEN('TEXT',

688: WHEN Others THEN
689: l_msg_data := APP_EXCEPTION.Get_Text;
690: FND_MESSAGE.SET_NAME('GR',
691: 'GR_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('TEXT',
693: l_msg_data,
694: FALSE);
695: IF FND_API.To_Boolean(p_called_by_form) THEN
696: APP_EXCEPTION.Raise_Exception;