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

Line 140: FND_MESSAGE.SET_NAME('GR',

136: WHEN Foreign_Key_Error THEN
137: ROLLBACK TO SAVEPOINT Insert_Row;
138: x_return_status := l_return_status;
139: x_oracle_error := l_oracle_error;
140: FND_MESSAGE.SET_NAME('GR',
141: 'GR_FOREIGN_KEY_ERROR');
142: FND_MESSAGE.SET_TOKEN('TEXT',
143: l_msg_data,
144: FALSE);

Line 142: FND_MESSAGE.SET_TOKEN('TEXT',

138: x_return_status := l_return_status;
139: x_oracle_error := l_oracle_error;
140: FND_MESSAGE.SET_NAME('GR',
141: 'GR_FOREIGN_KEY_ERROR');
142: FND_MESSAGE.SET_TOKEN('TEXT',
143: l_msg_data,
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 Item_Exists_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 || ' ' || p_document_code;
154: x_return_status := 'E';
155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: FND_MESSAGE.SET_NAME('GR',
157: 'GR_RECORD_THERE');
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_RECORD_THERE');
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 Row_Missing_Error THEN
168: ROLLBACK TO SAVEPOINT Insert_Row;

Line 172: FND_MESSAGE.SET_NAME('GR',

168: ROLLBACK TO SAVEPOINT Insert_Row;
169: l_msg_token := p_item_code || ' ' || p_document_code;
170: x_return_status := 'E';
171: x_oracle_error := APP_EXCEPTION.Get_Code;
172: FND_MESSAGE.SET_NAME('GR',
173: 'GR_NO_RECORD_INSERTED');
174: FND_MESSAGE.SET_TOKEN('CODE',
175: l_msg_token,
176: FALSE);

Line 174: FND_MESSAGE.SET_TOKEN('CODE',

170: x_return_status := 'E';
171: x_oracle_error := APP_EXCEPTION.Get_Code;
172: FND_MESSAGE.SET_NAME('GR',
173: 'GR_NO_RECORD_INSERTED');
174: FND_MESSAGE.SET_TOKEN('CODE',
175: l_msg_token,
176: FALSE);
177: IF FND_API.To_Boolean(p_called_by_form) THEN
178: APP_EXCEPTION.Raise_Exception;

Line 180: x_msg_data := FND_MESSAGE.Get;

176: FALSE);
177: IF FND_API.To_Boolean(p_called_by_form) THEN
178: APP_EXCEPTION.Raise_Exception;
179: ELSE
180: x_msg_data := FND_MESSAGE.Get;
181: END IF;
182:
183: WHEN OTHERS THEN
184: ROLLBACK TO SAVEPOINT Insert_Row;

Line 189: FND_MESSAGE.SET_NAME('GR',

185: l_msg_token := p_item_code || ' ' || p_document_code;
186: x_return_status := 'U';
187: x_oracle_error := APP_EXCEPTION.Get_Code;
188: l_msg_data := APP_EXCEPTION.Get_Text;
189: FND_MESSAGE.SET_NAME('GR',
190: 'GR_UNEXPECTED_ERROR');
191: FND_MESSAGE.SET_TOKEN('TEXT',
192: l_msg_token,
193: FALSE);

Line 191: FND_MESSAGE.SET_TOKEN('TEXT',

187: x_oracle_error := APP_EXCEPTION.Get_Code;
188: l_msg_data := APP_EXCEPTION.Get_Text;
189: FND_MESSAGE.SET_NAME('GR',
190: 'GR_UNEXPECTED_ERROR');
191: FND_MESSAGE.SET_TOKEN('TEXT',
192: l_msg_token,
193: FALSE);
194: IF FND_API.To_Boolean(p_called_by_form) THEN
195: APP_EXCEPTION.Raise_Exception;

Line 197: x_msg_data := FND_MESSAGE.Get;

193: FALSE);
194: IF FND_API.To_Boolean(p_called_by_form) THEN
195: APP_EXCEPTION.Raise_Exception;
196: ELSE
197: x_msg_data := FND_MESSAGE.Get;
198: END IF;
199:
200: END Insert_Row;
201:

Line 299: FND_MESSAGE.SET_NAME('GR',

295: WHEN Foreign_Key_Error THEN
296: ROLLBACK TO SAVEPOINT Update_Row;
297: x_return_status := l_return_status;
298: x_oracle_error := l_oracle_error;
299: FND_MESSAGE.SET_NAME('GR',
300: 'GR_FOREIGN_KEY_ERROR');
301: FND_MESSAGE.SET_TOKEN('TEXT',
302: l_msg_data,
303: FALSE);

Line 301: FND_MESSAGE.SET_TOKEN('TEXT',

297: x_return_status := l_return_status;
298: x_oracle_error := l_oracle_error;
299: FND_MESSAGE.SET_NAME('GR',
300: 'GR_FOREIGN_KEY_ERROR');
301: FND_MESSAGE.SET_TOKEN('TEXT',
302: l_msg_data,
303: FALSE);
304: IF FND_API.To_Boolean(p_called_by_form) THEN
305: APP_EXCEPTION.Raise_Exception;

Line 307: x_msg_data := FND_MESSAGE.Get;

303: FALSE);
304: IF FND_API.To_Boolean(p_called_by_form) THEN
305: APP_EXCEPTION.Raise_Exception;
306: ELSE
307: x_msg_data := FND_MESSAGE.Get;
308: END IF;
309:
310: WHEN Row_Missing_Error THEN
311: ROLLBACK TO SAVEPOINT Update_Row;

Line 314: FND_MESSAGE.SET_NAME('GR',

310: WHEN Row_Missing_Error THEN
311: ROLLBACK TO SAVEPOINT Update_Row;
312: x_return_status := 'E';
313: x_oracle_error := APP_EXCEPTION.Get_Code;
314: FND_MESSAGE.SET_NAME('GR',
315: 'GR_NO_RECORD_INSERTED');
316: FND_MESSAGE.SET_TOKEN('CODE',
317: l_msg_token,
318: FALSE);

Line 316: FND_MESSAGE.SET_TOKEN('CODE',

312: x_return_status := 'E';
313: x_oracle_error := APP_EXCEPTION.Get_Code;
314: FND_MESSAGE.SET_NAME('GR',
315: 'GR_NO_RECORD_INSERTED');
316: FND_MESSAGE.SET_TOKEN('CODE',
317: l_msg_token,
318: FALSE);
319: IF FND_API.To_Boolean(p_called_by_form) THEN
320: APP_EXCEPTION.Raise_Exception;

Line 322: x_msg_data := FND_MESSAGE.Get;

318: FALSE);
319: IF FND_API.To_Boolean(p_called_by_form) THEN
320: APP_EXCEPTION.Raise_Exception;
321: ELSE
322: x_msg_data := FND_MESSAGE.Get;
323: END IF;
324:
325: WHEN OTHERS THEN
326: ROLLBACK TO SAVEPOINT Update_Row;

Line 330: FND_MESSAGE.SET_NAME('GR',

326: ROLLBACK TO SAVEPOINT Update_Row;
327: x_return_status := 'U';
328: x_oracle_error := APP_EXCEPTION.Get_Code;
329: l_msg_data := APP_EXCEPTION.Get_Text;
330: FND_MESSAGE.SET_NAME('GR',
331: 'GR_UNEXPECTED_ERROR');
332: FND_MESSAGE.SET_TOKEN('TEXT',
333: l_msg_token,
334: FALSE);

Line 332: FND_MESSAGE.SET_TOKEN('TEXT',

328: x_oracle_error := APP_EXCEPTION.Get_Code;
329: l_msg_data := APP_EXCEPTION.Get_Text;
330: FND_MESSAGE.SET_NAME('GR',
331: 'GR_UNEXPECTED_ERROR');
332: FND_MESSAGE.SET_TOKEN('TEXT',
333: l_msg_token,
334: FALSE);
335: IF FND_API.To_Boolean(p_called_by_form) THEN
336: APP_EXCEPTION.Raise_Exception;

Line 338: x_msg_data := FND_MESSAGE.Get;

334: FALSE);
335: IF FND_API.To_Boolean(p_called_by_form) THEN
336: APP_EXCEPTION.Raise_Exception;
337: ELSE
338: x_msg_data := FND_MESSAGE.Get;
339: END IF;
340:
341: END Update_Row;
342:

Line 420: FND_MESSAGE.SET_NAME('GR',

416:
417: WHEN No_Data_Found_Error THEN
418: ROLLBACK TO SAVEPOINT Lock_Row;
419: x_return_status := 'E';
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_RECORD_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('CODE',
423: l_msg_token,
424: FALSE);

Line 422: FND_MESSAGE.SET_TOKEN('CODE',

418: ROLLBACK TO SAVEPOINT Lock_Row;
419: x_return_status := 'E';
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_RECORD_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('CODE',
423: l_msg_token,
424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;

Line 428: x_msg_data := FND_MESSAGE.Get;

424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;
427: ELSE
428: x_msg_data := FND_MESSAGE.Get;
429: END IF;
430:
431: WHEN Row_Already_Locked_Error THEN
432: ROLLBACK TO SAVEPOINT Lock_Row;

Line 435: FND_MESSAGE.SET_NAME('GR',

431: WHEN Row_Already_Locked_Error THEN
432: ROLLBACK TO SAVEPOINT Lock_Row;
433: x_return_status := 'E';
434: x_oracle_error := APP_EXCEPTION.Get_Code;
435: FND_MESSAGE.SET_NAME('GR',
436: 'GR_ROW_IS_LOCKED');
437: IF FND_API.To_Boolean(p_called_by_form) THEN
438: APP_EXCEPTION.Raise_Exception;
439: ELSE

Line 440: x_msg_data := FND_MESSAGE.Get;

436: 'GR_ROW_IS_LOCKED');
437: IF FND_API.To_Boolean(p_called_by_form) THEN
438: APP_EXCEPTION.Raise_Exception;
439: ELSE
440: x_msg_data := FND_MESSAGE.Get;
441: END IF;
442:
443: WHEN OTHERS THEN
444: ROLLBACK TO SAVEPOINT Lock_Row;

Line 448: FND_MESSAGE.SET_NAME('GR',

444: ROLLBACK TO SAVEPOINT Lock_Row;
445: x_return_status := 'U';
446: x_oracle_error := APP_EXCEPTION.Get_Code;
447: l_msg_data := APP_EXCEPTION.Get_Text;
448: FND_MESSAGE.SET_NAME('GR',
449: 'GR_UNEXPECTED_ERROR');
450: FND_MESSAGE.SET_TOKEN('TEXT',
451: l_msg_token,
452: FALSE);

Line 450: FND_MESSAGE.SET_TOKEN('TEXT',

446: x_oracle_error := APP_EXCEPTION.Get_Code;
447: l_msg_data := APP_EXCEPTION.Get_Text;
448: FND_MESSAGE.SET_NAME('GR',
449: 'GR_UNEXPECTED_ERROR');
450: FND_MESSAGE.SET_TOKEN('TEXT',
451: l_msg_token,
452: FALSE);
453: IF FND_API.To_Boolean(p_called_by_form) THEN
454: APP_EXCEPTION.Raise_Exception;

Line 456: x_msg_data := FND_MESSAGE.Get;

452: FALSE);
453: IF FND_API.To_Boolean(p_called_by_form) THEN
454: APP_EXCEPTION.Raise_Exception;
455: ELSE
456: x_msg_data := FND_MESSAGE.Get;
457: END IF;
458:
459: END Lock_Row;
460:

Line 549: x_msg_data := FND_MESSAGE.Get;

545: x_oracle_error := l_oracle_error;
546: IF FND_API.To_Boolean(p_called_by_form) THEN
547: APP_EXCEPTION.Raise_Exception;
548: ELSE
549: x_msg_data := FND_MESSAGE.Get;
550: END IF;
551:
552: WHEN Row_Missing_Error THEN
553: ROLLBACK TO SAVEPOINT Delete_Row;

Line 556: FND_MESSAGE.SET_NAME('GR',

552: WHEN Row_Missing_Error THEN
553: ROLLBACK TO SAVEPOINT Delete_Row;
554: x_return_status := 'E';
555: x_oracle_error := APP_EXCEPTION.Get_Code;
556: FND_MESSAGE.SET_NAME('GR',
557: 'GR_RECORD_NOT_FOUND');
558: FND_MESSAGE.SET_TOKEN('CODE',
559: l_msg_token,
560: FALSE);

Line 558: FND_MESSAGE.SET_TOKEN('CODE',

554: x_return_status := 'E';
555: x_oracle_error := APP_EXCEPTION.Get_Code;
556: FND_MESSAGE.SET_NAME('GR',
557: 'GR_RECORD_NOT_FOUND');
558: FND_MESSAGE.SET_TOKEN('CODE',
559: l_msg_token,
560: FALSE);
561: IF FND_API.To_Boolean(p_called_by_form) THEN
562: APP_EXCEPTION.Raise_Exception;

Line 564: x_msg_data := FND_MESSAGE.Get;

560: FALSE);
561: IF FND_API.To_Boolean(p_called_by_form) THEN
562: APP_EXCEPTION.Raise_Exception;
563: ELSE
564: x_msg_data := FND_MESSAGE.Get;
565: END IF;
566:
567: WHEN OTHERS THEN
568: ROLLBACK TO SAVEPOINT Delete_Row;

Line 573: FND_MESSAGE.SET_NAME('GR',

569: x_return_status := 'U';
570: x_oracle_error := APP_EXCEPTION.Get_Code;
571: l_msg_data := APP_EXCEPTION.Get_Text;
572: l_msg_data := APP_EXCEPTION.Get_Text;
573: FND_MESSAGE.SET_NAME('GR',
574: 'GR_UNEXPECTED_ERROR');
575: FND_MESSAGE.SET_TOKEN('TEXT',
576: l_msg_token,
577: FALSE);

Line 575: FND_MESSAGE.SET_TOKEN('TEXT',

571: l_msg_data := APP_EXCEPTION.Get_Text;
572: l_msg_data := APP_EXCEPTION.Get_Text;
573: FND_MESSAGE.SET_NAME('GR',
574: 'GR_UNEXPECTED_ERROR');
575: FND_MESSAGE.SET_TOKEN('TEXT',
576: l_msg_token,
577: FALSE);
578: IF FND_API.To_Boolean(p_called_by_form) THEN
579: APP_EXCEPTION.Raise_Exception;

Line 581: x_msg_data := FND_MESSAGE.Get;

577: FALSE);
578: IF FND_API.To_Boolean(p_called_by_form) THEN
579: APP_EXCEPTION.Raise_Exception;
580: ELSE
581: x_msg_data := FND_MESSAGE.Get;
582: END IF;
583:
584: END Delete_Row;
585:

Line 657: FND_MESSAGE.SET_NAME('GR',

653:
654: WHEN Null_Delete_Option_Error THEN
655: x_return_status := 'E';
656: x_oracle_error := APP_EXCEPTION.Get_Code;
657: FND_MESSAGE.SET_NAME('GR',
658: 'GR_NULL_VALUE');
659: FND_MESSAGE.SET_TOKEN('CODE',
660: l_msg_token,
661: FALSE);

Line 659: FND_MESSAGE.SET_TOKEN('CODE',

655: x_return_status := 'E';
656: x_oracle_error := APP_EXCEPTION.Get_Code;
657: FND_MESSAGE.SET_NAME('GR',
658: 'GR_NULL_VALUE');
659: FND_MESSAGE.SET_TOKEN('CODE',
660: l_msg_token,
661: FALSE);
662: IF FND_API.To_Boolean(p_called_by_form) THEN
663: APP_EXCEPTION.Raise_Exception;

Line 665: x_msg_data := FND_MESSAGE.Get;

661: FALSE);
662: IF FND_API.To_Boolean(p_called_by_form) THEN
663: APP_EXCEPTION.Raise_Exception;
664: ELSE
665: x_msg_data := FND_MESSAGE.Get;
666: END IF;
667:
668: WHEN OTHERS THEN
669: ROLLBACK TO SAVEPOINT Delete_Rows;

Line 673: FND_MESSAGE.SET_NAME('GR',

669: ROLLBACK TO SAVEPOINT Delete_Rows;
670: x_return_status := 'U';
671: x_oracle_error := APP_EXCEPTION.Get_Code;
672: l_msg_data := APP_EXCEPTION.Get_Text;
673: FND_MESSAGE.SET_NAME('GR',
674: 'GR_UNEXPECTED_ERROR');
675: FND_MESSAGE.SET_TOKEN('TEXT',
676: l_msg_token,
677: FALSE);

Line 675: FND_MESSAGE.SET_TOKEN('TEXT',

671: x_oracle_error := APP_EXCEPTION.Get_Code;
672: l_msg_data := APP_EXCEPTION.Get_Text;
673: FND_MESSAGE.SET_NAME('GR',
674: 'GR_UNEXPECTED_ERROR');
675: FND_MESSAGE.SET_TOKEN('TEXT',
676: l_msg_token,
677: FALSE);
678: IF FND_API.To_Boolean(p_called_by_form) THEN
679: APP_EXCEPTION.Raise_Exception;

Line 681: x_msg_data := FND_MESSAGE.Get;

677: FALSE);
678: IF FND_API.To_Boolean(p_called_by_form) THEN
679: APP_EXCEPTION.Raise_Exception;
680: ELSE
681: x_msg_data := FND_MESSAGE.Get;
682: END IF;
683:
684: END Delete_Rows;
685:

Line 762: FND_MESSAGE.SET_NAME('GR',

758:
759: WHEN Row_Missing_Error THEN
760: x_return_status := 'E';
761: x_oracle_error := APP_EXCEPTION.Get_Code;
762: FND_MESSAGE.SET_NAME('GR',
763: 'GR_RECORD_NOT_FOUND');
764: FND_MESSAGE.SET_TOKEN('CODE',
765: l_msg_token,
766: FALSE);

Line 764: FND_MESSAGE.SET_TOKEN('CODE',

760: x_return_status := 'E';
761: x_oracle_error := APP_EXCEPTION.Get_Code;
762: FND_MESSAGE.SET_NAME('GR',
763: 'GR_RECORD_NOT_FOUND');
764: FND_MESSAGE.SET_TOKEN('CODE',
765: l_msg_token,
766: FALSE);
767: x_msg_data := FND_MESSAGE.Get;
768:

Line 767: x_msg_data := FND_MESSAGE.Get;

763: 'GR_RECORD_NOT_FOUND');
764: FND_MESSAGE.SET_TOKEN('CODE',
765: l_msg_token,
766: FALSE);
767: x_msg_data := FND_MESSAGE.Get;
768:
769: WHEN OTHERS THEN
770: x_return_status := 'U';
771: x_oracle_error := APP_EXCEPTION.Get_Code;

Line 773: FND_MESSAGE.SET_NAME('GR',

769: WHEN OTHERS THEN
770: x_return_status := 'U';
771: x_oracle_error := APP_EXCEPTION.Get_Code;
772: l_msg_data := APP_EXCEPTION.Get_Text;
773: FND_MESSAGE.SET_NAME('GR',
774: 'GR_UNEXPECTED_ERROR');
775: FND_MESSAGE.SET_TOKEN('TEXT',
776: l_msg_token,
777: FALSE);

Line 775: FND_MESSAGE.SET_TOKEN('TEXT',

771: x_oracle_error := APP_EXCEPTION.Get_Code;
772: l_msg_data := APP_EXCEPTION.Get_Text;
773: FND_MESSAGE.SET_NAME('GR',
774: 'GR_UNEXPECTED_ERROR');
775: FND_MESSAGE.SET_TOKEN('TEXT',
776: l_msg_token,
777: FALSE);
778: x_msg_data := FND_MESSAGE.Get;
779:

Line 778: x_msg_data := FND_MESSAGE.Get;

774: 'GR_UNEXPECTED_ERROR');
775: FND_MESSAGE.SET_TOKEN('TEXT',
776: l_msg_token,
777: FALSE);
778: x_msg_data := FND_MESSAGE.Get;
779:
780: END Check_Foreign_Keys;
781:
782: PROCEDURE Check_Integrity

Line 829: FND_MESSAGE.SET_NAME('GR',

825: ROLLBACK TO SAVEPOINT Check_Integrity;
826: x_return_status := 'U';
827: x_oracle_error := APP_EXCEPTION.Get_Code;
828: l_msg_data := APP_EXCEPTION.Get_Text;
829: FND_MESSAGE.SET_NAME('GR',
830: 'GR_UNEXPECTED_ERROR');
831: FND_MESSAGE.SET_TOKEN('TEXT',
832: l_msg_data,
833: FALSE);

Line 831: FND_MESSAGE.SET_TOKEN('TEXT',

827: x_oracle_error := APP_EXCEPTION.Get_Code;
828: l_msg_data := APP_EXCEPTION.Get_Text;
829: FND_MESSAGE.SET_NAME('GR',
830: 'GR_UNEXPECTED_ERROR');
831: FND_MESSAGE.SET_TOKEN('TEXT',
832: l_msg_data,
833: FALSE);
834: IF FND_API.To_Boolean(p_called_by_form) THEN
835: APP_EXCEPTION.Raise_Exception;

Line 837: x_msg_data := FND_MESSAGE.Get;

833: FALSE);
834: IF FND_API.To_Boolean(p_called_by_form) THEN
835: APP_EXCEPTION.Raise_Exception;
836: ELSE
837: x_msg_data := FND_MESSAGE.Get;
838: END IF;
839:
840: END Check_Integrity;
841:

Line 889: FND_MESSAGE.SET_NAME('GR',

885: EXCEPTION
886:
887: WHEN Others THEN
888: l_msg_data := APP_EXCEPTION.Get_Text;
889: FND_MESSAGE.SET_NAME('GR',
890: 'GR_UNEXPECTED_ERROR');
891: FND_MESSAGE.SET_TOKEN('TEXT',
892: l_msg_data,
893: FALSE);

Line 891: FND_MESSAGE.SET_TOKEN('TEXT',

887: WHEN Others THEN
888: l_msg_data := APP_EXCEPTION.Get_Text;
889: FND_MESSAGE.SET_NAME('GR',
890: 'GR_UNEXPECTED_ERROR');
891: FND_MESSAGE.SET_TOKEN('TEXT',
892: l_msg_data,
893: FALSE);
894: IF FND_API.To_Boolean(p_called_by_form) THEN
895: APP_EXCEPTION.Raise_Exception;