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

Line 124: FND_MESSAGE.SET_NAME('GR',

120: WHEN Foreign_Key_Error THEN
121: ROLLBACK TO SAVEPOINT Insert_Row;
122: x_return_status := l_return_status;
123: x_oracle_error := l_oracle_error;
124: FND_MESSAGE.SET_NAME('GR',
125: 'GR_FOREIGN_KEY_ERROR');
126: FND_MESSAGE.SET_TOKEN('TEXT',
127: l_msg_data,
128: FALSE);

Line 126: FND_MESSAGE.SET_TOKEN('TEXT',

122: x_return_status := l_return_status;
123: x_oracle_error := l_oracle_error;
124: FND_MESSAGE.SET_NAME('GR',
125: 'GR_FOREIGN_KEY_ERROR');
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;

Line 132: x_msg_data := FND_MESSAGE.Get;

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:
135: WHEN Item_Exists_Error THEN
136: ROLLBACK TO SAVEPOINT Insert_Row;

Line 140: FND_MESSAGE.SET_NAME('GR',

136: ROLLBACK TO SAVEPOINT Insert_Row;
137: l_msg_token := p_item_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,
144: FALSE);

Line 142: FND_MESSAGE.SET_TOKEN('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,
144: FALSE);
145: IF FND_API.To_Boolean(p_called_by_form) THEN
146: APP_EXCEPTION.Raise_Exception;

Line 148: x_msg_data := FND_MESSAGE.Get;

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

Line 156: FND_MESSAGE.SET_NAME('GR',

152: ROLLBACK TO SAVEPOINT Insert_Row;
153: l_msg_token := p_item_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,
160: FALSE);

Line 158: FND_MESSAGE.SET_TOKEN('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,
160: FALSE);
161: IF FND_API.To_Boolean(p_called_by_form) THEN
162: APP_EXCEPTION.Raise_Exception;

Line 164: x_msg_data := FND_MESSAGE.Get;

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

Line 173: FND_MESSAGE.SET_NAME('GR',

169: l_msg_token := p_item_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,
177: FALSE);

Line 175: FND_MESSAGE.SET_TOKEN('TEXT',

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,
177: FALSE);
178: IF FND_API.To_Boolean(p_called_by_form) THEN
179: APP_EXCEPTION.Raise_Exception;

Line 181: x_msg_data := FND_MESSAGE.Get;

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:
184: END Insert_Row;
185:

Line 270: FND_MESSAGE.SET_NAME('GR',

266: WHEN Foreign_Key_Error THEN
267: ROLLBACK TO SAVEPOINT Update_Row;
268: x_return_status := l_return_status;
269: x_oracle_error := l_oracle_error;
270: FND_MESSAGE.SET_NAME('GR',
271: 'GR_FOREIGN_KEY_ERROR');
272: FND_MESSAGE.SET_TOKEN('TEXT',
273: l_msg_data,
274: FALSE);

Line 272: FND_MESSAGE.SET_TOKEN('TEXT',

268: x_return_status := l_return_status;
269: x_oracle_error := l_oracle_error;
270: FND_MESSAGE.SET_NAME('GR',
271: 'GR_FOREIGN_KEY_ERROR');
272: FND_MESSAGE.SET_TOKEN('TEXT',
273: l_msg_data,
274: FALSE);
275: IF FND_API.To_Boolean(p_called_by_form) THEN
276: APP_EXCEPTION.Raise_Exception;

Line 278: x_msg_data := FND_MESSAGE.Get;

274: FALSE);
275: IF FND_API.To_Boolean(p_called_by_form) THEN
276: APP_EXCEPTION.Raise_Exception;
277: ELSE
278: x_msg_data := FND_MESSAGE.Get;
279: END IF;
280:
281: WHEN Row_Missing_Error THEN
282: ROLLBACK TO SAVEPOINT Update_Row;

Line 285: FND_MESSAGE.SET_NAME('GR',

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

Line 287: FND_MESSAGE.SET_TOKEN('CODE',

283: x_return_status := 'E';
284: x_oracle_error := APP_EXCEPTION.Get_Code;
285: FND_MESSAGE.SET_NAME('GR',
286: 'GR_NO_RECORD_INSERTED');
287: FND_MESSAGE.SET_TOKEN('CODE',
288: l_msg_token,
289: FALSE);
290: IF FND_API.To_Boolean(p_called_by_form) THEN
291: APP_EXCEPTION.Raise_Exception;

Line 293: x_msg_data := FND_MESSAGE.Get;

289: FALSE);
290: IF FND_API.To_Boolean(p_called_by_form) THEN
291: APP_EXCEPTION.Raise_Exception;
292: ELSE
293: x_msg_data := FND_MESSAGE.Get;
294: END IF;
295:
296: WHEN OTHERS THEN
297: ROLLBACK TO SAVEPOINT Update_Row;

Line 301: FND_MESSAGE.SET_NAME('GR',

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

Line 303: FND_MESSAGE.SET_TOKEN('TEXT',

299: x_oracle_error := APP_EXCEPTION.Get_Code;
300: l_msg_data := APP_EXCEPTION.Get_Text;
301: FND_MESSAGE.SET_NAME('GR',
302: 'GR_UNEXPECTED_ERROR');
303: FND_MESSAGE.SET_TOKEN('TEXT',
304: l_msg_token,
305: FALSE);
306: IF FND_API.To_Boolean(p_called_by_form) THEN
307: APP_EXCEPTION.Raise_Exception;

Line 309: x_msg_data := FND_MESSAGE.Get;

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:
312: END Update_Row;
313:

Line 384: FND_MESSAGE.SET_NAME('GR',

380:
381: WHEN No_Data_Found_Error THEN
382: ROLLBACK TO SAVEPOINT Lock_Row;
383: x_return_status := 'E';
384: FND_MESSAGE.SET_NAME('GR',
385: 'GR_RECORD_NOT_FOUND');
386: FND_MESSAGE.SET_TOKEN('CODE',
387: l_msg_token,
388: FALSE);

Line 386: FND_MESSAGE.SET_TOKEN('CODE',

382: ROLLBACK TO SAVEPOINT Lock_Row;
383: x_return_status := 'E';
384: FND_MESSAGE.SET_NAME('GR',
385: 'GR_RECORD_NOT_FOUND');
386: FND_MESSAGE.SET_TOKEN('CODE',
387: l_msg_token,
388: FALSE);
389: IF FND_API.To_Boolean(p_called_by_form) THEN
390: APP_EXCEPTION.Raise_Exception;

Line 392: x_msg_data := FND_MESSAGE.Get;

388: FALSE);
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 Row_Already_Locked_Error THEN
396: ROLLBACK TO SAVEPOINT Lock_Row;

Line 399: FND_MESSAGE.SET_NAME('GR',

395: WHEN Row_Already_Locked_Error THEN
396: ROLLBACK TO SAVEPOINT Lock_Row;
397: x_return_status := 'E';
398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: FND_MESSAGE.SET_NAME('GR',
400: 'GR_ROW_IS_LOCKED');
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;
403: ELSE

Line 404: x_msg_data := FND_MESSAGE.Get;

400: 'GR_ROW_IS_LOCKED');
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;
403: ELSE
404: x_msg_data := FND_MESSAGE.Get;
405: END IF;
406:
407: WHEN OTHERS THEN
408: ROLLBACK TO SAVEPOINT Lock_Row;

Line 412: FND_MESSAGE.SET_NAME('GR',

408: ROLLBACK TO SAVEPOINT Lock_Row;
409: x_return_status := 'U';
410: x_oracle_error := APP_EXCEPTION.Get_Code;
411: l_msg_data := APP_EXCEPTION.Get_Text;
412: FND_MESSAGE.SET_NAME('GR',
413: 'GR_UNEXPECTED_ERROR');
414: FND_MESSAGE.SET_TOKEN('TEXT',
415: l_msg_token,
416: FALSE);

Line 414: FND_MESSAGE.SET_TOKEN('TEXT',

410: x_oracle_error := APP_EXCEPTION.Get_Code;
411: l_msg_data := APP_EXCEPTION.Get_Text;
412: FND_MESSAGE.SET_NAME('GR',
413: 'GR_UNEXPECTED_ERROR');
414: FND_MESSAGE.SET_TOKEN('TEXT',
415: l_msg_token,
416: FALSE);
417: IF FND_API.To_Boolean(p_called_by_form) THEN
418: APP_EXCEPTION.Raise_Exception;

Line 420: x_msg_data := FND_MESSAGE.Get;

416: FALSE);
417: IF FND_API.To_Boolean(p_called_by_form) THEN
418: APP_EXCEPTION.Raise_Exception;
419: ELSE
420: x_msg_data := FND_MESSAGE.Get;
421: END IF;
422:
423: END Lock_Row;
424:

Line 504: x_msg_data := FND_MESSAGE.Get;

500: x_oracle_error := l_oracle_error;
501: IF FND_API.To_Boolean(p_called_by_form) THEN
502: APP_EXCEPTION.Raise_Exception;
503: ELSE
504: x_msg_data := FND_MESSAGE.Get;
505: END IF;
506:
507: WHEN Row_Missing_Error THEN
508: ROLLBACK TO SAVEPOINT Delete_Row;

Line 511: FND_MESSAGE.SET_NAME('GR',

507: WHEN Row_Missing_Error THEN
508: ROLLBACK TO SAVEPOINT Delete_Row;
509: x_return_status := 'E';
510: x_oracle_error := APP_EXCEPTION.Get_Code;
511: FND_MESSAGE.SET_NAME('GR',
512: 'GR_RECORD_NOT_FOUND');
513: FND_MESSAGE.SET_TOKEN('CODE',
514: l_msg_token,
515: FALSE);

Line 513: FND_MESSAGE.SET_TOKEN('CODE',

509: x_return_status := 'E';
510: x_oracle_error := APP_EXCEPTION.Get_Code;
511: FND_MESSAGE.SET_NAME('GR',
512: 'GR_RECORD_NOT_FOUND');
513: FND_MESSAGE.SET_TOKEN('CODE',
514: l_msg_token,
515: FALSE);
516: IF FND_API.To_Boolean(p_called_by_form) THEN
517: APP_EXCEPTION.Raise_Exception;

Line 519: x_msg_data := FND_MESSAGE.Get;

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

Line 528: FND_MESSAGE.SET_NAME('GR',

524: x_return_status := 'U';
525: x_oracle_error := APP_EXCEPTION.Get_Code;
526: l_msg_data := APP_EXCEPTION.Get_Text;
527: l_msg_data := APP_EXCEPTION.Get_Text;
528: FND_MESSAGE.SET_NAME('GR',
529: 'GR_UNEXPECTED_ERROR');
530: FND_MESSAGE.SET_TOKEN('TEXT',
531: l_msg_token,
532: FALSE);

Line 530: FND_MESSAGE.SET_TOKEN('TEXT',

526: l_msg_data := APP_EXCEPTION.Get_Text;
527: l_msg_data := APP_EXCEPTION.Get_Text;
528: FND_MESSAGE.SET_NAME('GR',
529: 'GR_UNEXPECTED_ERROR');
530: FND_MESSAGE.SET_TOKEN('TEXT',
531: l_msg_token,
532: FALSE);
533: IF FND_API.To_Boolean(p_called_by_form) THEN
534: APP_EXCEPTION.Raise_Exception;

Line 536: x_msg_data := FND_MESSAGE.Get;

532: FALSE);
533: IF FND_API.To_Boolean(p_called_by_form) THEN
534: APP_EXCEPTION.Raise_Exception;
535: ELSE
536: x_msg_data := FND_MESSAGE.Get;
537: END IF;
538:
539: END Delete_Row;
540:

Line 586: FND_MESSAGE.SET_NAME('GR',

582: ROLLBACK TO SAVEPOINT Delete_Rows;
583: x_return_status := 'U';
584: x_oracle_error := APP_EXCEPTION.Get_Code;
585: l_msg_data := APP_EXCEPTION.Get_Text;
586: FND_MESSAGE.SET_NAME('GR',
587: 'GR_UNEXPECTED_ERROR');
588: FND_MESSAGE.SET_TOKEN('TEXT',
589: l_msg_token,
590: FALSE);

Line 588: FND_MESSAGE.SET_TOKEN('TEXT',

584: x_oracle_error := APP_EXCEPTION.Get_Code;
585: l_msg_data := APP_EXCEPTION.Get_Text;
586: FND_MESSAGE.SET_NAME('GR',
587: 'GR_UNEXPECTED_ERROR');
588: FND_MESSAGE.SET_TOKEN('TEXT',
589: l_msg_token,
590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;

Line 594: x_msg_data := FND_MESSAGE.Get;

590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;
593: ELSE
594: x_msg_data := FND_MESSAGE.Get;
595: END IF;
596:
597: END Delete_Rows;
598:

Line 647: FND_MESSAGE.SET_NAME('GR',

643: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
644: x_return_status := 'U';
645: x_oracle_error := APP_EXCEPTION.Get_Code;
646: l_msg_data := APP_EXCEPTION.Get_Text;
647: FND_MESSAGE.SET_NAME('GR',
648: 'GR_UNEXPECTED_ERROR');
649: FND_MESSAGE.SET_TOKEN('TEXT',
650: l_msg_token,
651: FALSE);

Line 649: FND_MESSAGE.SET_TOKEN('TEXT',

645: x_oracle_error := APP_EXCEPTION.Get_Code;
646: l_msg_data := APP_EXCEPTION.Get_Text;
647: FND_MESSAGE.SET_NAME('GR',
648: 'GR_UNEXPECTED_ERROR');
649: FND_MESSAGE.SET_TOKEN('TEXT',
650: l_msg_token,
651: FALSE);
652: x_msg_data := FND_MESSAGE.Get;
653:

Line 652: x_msg_data := FND_MESSAGE.Get;

648: 'GR_UNEXPECTED_ERROR');
649: FND_MESSAGE.SET_TOKEN('TEXT',
650: l_msg_token,
651: FALSE);
652: x_msg_data := FND_MESSAGE.Get;
653:
654: END Check_Foreign_Keys;
655:
656: PROCEDURE Check_Integrity

Line 701: FND_MESSAGE.SET_NAME('GR',

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

Line 703: FND_MESSAGE.SET_TOKEN('TEXT',

699: x_oracle_error := APP_EXCEPTION.Get_Code;
700: l_msg_data := APP_EXCEPTION.Get_Text;
701: FND_MESSAGE.SET_NAME('GR',
702: 'GR_UNEXPECTED_ERROR');
703: FND_MESSAGE.SET_TOKEN('TEXT',
704: l_msg_data,
705: FALSE);
706: IF FND_API.To_Boolean(p_called_by_form) THEN
707: APP_EXCEPTION.Raise_Exception;

Line 709: x_msg_data := FND_MESSAGE.Get;

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

Line 764: FND_MESSAGE.SET_NAME('GR',

760: EXCEPTION
761:
762: WHEN Others THEN
763: l_msg_data := APP_EXCEPTION.Get_Text;
764: FND_MESSAGE.SET_NAME('GR',
765: 'GR_UNEXPECTED_ERROR');
766: FND_MESSAGE.SET_TOKEN('TEXT',
767: l_msg_data,
768: FALSE);

Line 766: FND_MESSAGE.SET_TOKEN('TEXT',

762: WHEN Others THEN
763: l_msg_data := APP_EXCEPTION.Get_Text;
764: FND_MESSAGE.SET_NAME('GR',
765: 'GR_UNEXPECTED_ERROR');
766: FND_MESSAGE.SET_TOKEN('TEXT',
767: l_msg_data,
768: FALSE);
769: IF FND_API.To_Boolean(p_called_by_form) THEN
770: APP_EXCEPTION.Raise_Exception;