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

Line 118: FND_MESSAGE.SET_NAME('GR',

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

Line 120: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 126: x_msg_data := FND_MESSAGE.Get;

122: FALSE);
123: IF FND_API.To_Boolean(p_called_by_form) THEN
124: APP_EXCEPTION.Raise_Exception;
125: ELSE
126: x_msg_data := FND_MESSAGE.Get;
127: END IF;
128:
129: WHEN Item_Exists_Error THEN
130: ROLLBACK TO SAVEPOINT Insert_Row;

Line 134: FND_MESSAGE.SET_NAME('GR',

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

Line 136: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 142: x_msg_data := FND_MESSAGE.Get;

138: FALSE);
139: IF FND_API.To_Boolean(p_called_by_form) THEN
140: APP_EXCEPTION.Raise_Exception;
141: ELSE
142: x_msg_data := FND_MESSAGE.Get;
143: END IF;
144:
145: WHEN Row_Missing_Error THEN
146: ROLLBACK TO SAVEPOINT Insert_Row;

Line 150: FND_MESSAGE.SET_NAME('GR',

146: ROLLBACK TO SAVEPOINT Insert_Row;
147: l_msg_token := p_main_heading_code;
148: x_return_status := 'E';
149: x_oracle_error := APP_EXCEPTION.Get_Code;
150: FND_MESSAGE.SET_NAME('GR',
151: 'GR_NO_RECORD_INSERTED');
152: FND_MESSAGE.SET_TOKEN('CODE',
153: l_msg_token,
154: FALSE);

Line 152: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 158: x_msg_data := FND_MESSAGE.Get;

154: FALSE);
155: IF FND_API.To_Boolean(p_called_by_form) THEN
156: APP_EXCEPTION.Raise_Exception;
157: ELSE
158: x_msg_data := FND_MESSAGE.Get;
159: END IF;
160:
161: WHEN OTHERS THEN
162: ROLLBACK TO SAVEPOINT Insert_Row;

Line 167: FND_MESSAGE.SET_NAME('GR',

163: l_msg_token := p_main_heading_code;
164: x_return_status := 'U';
165: x_oracle_error := APP_EXCEPTION.Get_Code;
166: l_msg_data := APP_EXCEPTION.Get_Text;
167: FND_MESSAGE.SET_NAME('GR',
168: 'GR_UNEXPECTED_ERROR');
169: FND_MESSAGE.SET_TOKEN('TEXT',
170: l_msg_token,
171: FALSE);

Line 169: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 175: x_msg_data := FND_MESSAGE.Get;

171: FALSE);
172: IF FND_API.To_Boolean(p_called_by_form) THEN
173: APP_EXCEPTION.Raise_Exception;
174: ELSE
175: x_msg_data := FND_MESSAGE.Get;
176: END IF;
177:
178: END Insert_Row;
179:

Line 262: FND_MESSAGE.SET_NAME('GR',

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

Line 264: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 270: x_msg_data := FND_MESSAGE.Get;

266: FALSE);
267: IF FND_API.To_Boolean(p_called_by_form) THEN
268: APP_EXCEPTION.Raise_Exception;
269: ELSE
270: x_msg_data := FND_MESSAGE.Get;
271: END IF;
272:
273: WHEN Row_Missing_Error THEN
274: ROLLBACK TO SAVEPOINT Update_Row;

Line 277: FND_MESSAGE.SET_NAME('GR',

273: WHEN Row_Missing_Error THEN
274: ROLLBACK TO SAVEPOINT Update_Row;
275: x_return_status := 'E';
276: x_oracle_error := APP_EXCEPTION.Get_Code;
277: FND_MESSAGE.SET_NAME('GR',
278: 'GR_NO_RECORD_INSERTED');
279: FND_MESSAGE.SET_TOKEN('CODE',
280: l_msg_token,
281: FALSE);

Line 279: FND_MESSAGE.SET_TOKEN('CODE',

275: x_return_status := 'E';
276: x_oracle_error := APP_EXCEPTION.Get_Code;
277: FND_MESSAGE.SET_NAME('GR',
278: 'GR_NO_RECORD_INSERTED');
279: FND_MESSAGE.SET_TOKEN('CODE',
280: l_msg_token,
281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;

Line 285: x_msg_data := FND_MESSAGE.Get;

281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;
284: ELSE
285: x_msg_data := FND_MESSAGE.Get;
286: END IF;
287:
288: WHEN OTHERS THEN
289: ROLLBACK TO SAVEPOINT Update_Row;

Line 293: FND_MESSAGE.SET_NAME('GR',

289: ROLLBACK TO SAVEPOINT Update_Row;
290: x_return_status := 'U';
291: x_oracle_error := APP_EXCEPTION.Get_Code;
292: l_msg_data := APP_EXCEPTION.Get_Text;
293: FND_MESSAGE.SET_NAME('GR',
294: 'GR_UNEXPECTED_ERROR');
295: FND_MESSAGE.SET_TOKEN('TEXT',
296: l_msg_token,
297: FALSE);

Line 295: FND_MESSAGE.SET_TOKEN('TEXT',

291: x_oracle_error := APP_EXCEPTION.Get_Code;
292: l_msg_data := APP_EXCEPTION.Get_Text;
293: FND_MESSAGE.SET_NAME('GR',
294: 'GR_UNEXPECTED_ERROR');
295: FND_MESSAGE.SET_TOKEN('TEXT',
296: l_msg_token,
297: FALSE);
298: IF FND_API.To_Boolean(p_called_by_form) THEN
299: APP_EXCEPTION.Raise_Exception;

Line 301: x_msg_data := FND_MESSAGE.Get;

297: FALSE);
298: IF FND_API.To_Boolean(p_called_by_form) THEN
299: APP_EXCEPTION.Raise_Exception;
300: ELSE
301: x_msg_data := FND_MESSAGE.Get;
302: END IF;
303:
304: END Update_Row;
305: /*

Line 382: FND_MESSAGE.SET_NAME('GR',

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

Line 384: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 390: x_msg_data := FND_MESSAGE.Get;

386: FALSE);
387: IF FND_API.To_Boolean(p_called_by_form) THEN
388: APP_EXCEPTION.Raise_Exception;
389: ELSE
390: x_msg_data := FND_MESSAGE.Get;
391: END IF;
392:
393: WHEN Row_Already_Locked_Error THEN
394: ROLLBACK TO SAVEPOINT Lock_Row;

Line 397: FND_MESSAGE.SET_NAME('GR',

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

Line 402: x_msg_data := FND_MESSAGE.Get;

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

Line 410: FND_MESSAGE.SET_NAME('GR',

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

Line 412: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 418: x_msg_data := FND_MESSAGE.Get;

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

Line 503: x_msg_data := FND_MESSAGE.Get;

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

Line 510: FND_MESSAGE.SET_NAME('GR',

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

Line 512: FND_MESSAGE.SET_TOKEN('CODE',

508: x_return_status := 'E';
509: x_oracle_error := APP_EXCEPTION.Get_Code;
510: FND_MESSAGE.SET_NAME('GR',
511: 'GR_RECORD_NOT_FOUND');
512: FND_MESSAGE.SET_TOKEN('CODE',
513: l_msg_token,
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: WHEN OTHERS THEN
522: ROLLBACK TO SAVEPOINT Delete_Row;

Line 526: FND_MESSAGE.SET_NAME('GR',

522: ROLLBACK TO SAVEPOINT Delete_Row;
523: x_return_status := 'U';
524: x_oracle_error := APP_EXCEPTION.Get_Code;
525: l_msg_data := APP_EXCEPTION.Get_Text;
526: FND_MESSAGE.SET_NAME('GR',
527: 'GR_UNEXPECTED_ERROR');
528: FND_MESSAGE.SET_TOKEN('TEXT',
529: l_msg_data,
530: FALSE);

Line 528: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 534: x_msg_data := FND_MESSAGE.Get;

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

Line 585: FND_MESSAGE.SET_NAME('GR',

581: WHEN Row_Missing_Error THEN
582: ROLLBACK TO SAVEPOINT Delete_Row;
583: x_return_status := 'E';
584: x_oracle_error := APP_EXCEPTION.Get_Code;
585: FND_MESSAGE.SET_NAME('GR',
586: 'GR_RECORD_NOT_FOUND');
587: FND_MESSAGE.SET_TOKEN('CODE',
588: p_main_heading_code,
589: FALSE);

Line 587: FND_MESSAGE.SET_TOKEN('CODE',

583: x_return_status := 'E';
584: x_oracle_error := APP_EXCEPTION.Get_Code;
585: FND_MESSAGE.SET_NAME('GR',
586: 'GR_RECORD_NOT_FOUND');
587: FND_MESSAGE.SET_TOKEN('CODE',
588: p_main_heading_code,
589: FALSE);
590: x_msg_data := FND_MESSAGE.Get;
591:

Line 590: x_msg_data := FND_MESSAGE.Get;

586: 'GR_RECORD_NOT_FOUND');
587: FND_MESSAGE.SET_TOKEN('CODE',
588: p_main_heading_code,
589: FALSE);
590: x_msg_data := FND_MESSAGE.Get;
591:
592: WHEN OTHERS THEN
593: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
594: x_return_status := 'U';

Line 597: FND_MESSAGE.SET_NAME('GR',

593: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
594: x_return_status := 'U';
595: x_oracle_error := APP_EXCEPTION.Get_Code;
596: l_msg_data := APP_EXCEPTION.Get_Text;
597: FND_MESSAGE.SET_NAME('GR',
598: 'GR_UNEXPECTED_ERROR');
599: FND_MESSAGE.SET_TOKEN('TEXT',
600: l_msg_token,
601: FALSE);

Line 599: FND_MESSAGE.SET_TOKEN('TEXT',

595: x_oracle_error := APP_EXCEPTION.Get_Code;
596: l_msg_data := APP_EXCEPTION.Get_Text;
597: FND_MESSAGE.SET_NAME('GR',
598: 'GR_UNEXPECTED_ERROR');
599: FND_MESSAGE.SET_TOKEN('TEXT',
600: l_msg_token,
601: FALSE);
602: x_msg_data := FND_MESSAGE.Get;
603:

Line 602: x_msg_data := FND_MESSAGE.Get;

598: 'GR_UNEXPECTED_ERROR');
599: FND_MESSAGE.SET_TOKEN('TEXT',
600: l_msg_token,
601: FALSE);
602: x_msg_data := FND_MESSAGE.Get;
603:
604: END Check_Foreign_Keys;
605:
606: PROCEDURE Check_Integrity

Line 690: FND_MESSAGE.SET_NAME('GR',

686: EXCEPTION
687:
688: WHEN INTEGRITY_ERROR THEN
689: x_return_status := 'E';
690: FND_MESSAGE.SET_NAME('GR',
691: 'GR_INTEGRITY_HEADER');
692: FND_MESSAGE.SET_TOKEN('CODE',
693: p_main_heading_code,
694: FALSE);

Line 692: FND_MESSAGE.SET_TOKEN('CODE',

688: WHEN INTEGRITY_ERROR THEN
689: x_return_status := 'E';
690: FND_MESSAGE.SET_NAME('GR',
691: 'GR_INTEGRITY_HEADER');
692: FND_MESSAGE.SET_TOKEN('CODE',
693: p_main_heading_code,
694: FALSE);
695: FND_MESSAGE.SET_TOKEN('TABLES',
696: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),

Line 695: FND_MESSAGE.SET_TOKEN('TABLES',

691: 'GR_INTEGRITY_HEADER');
692: FND_MESSAGE.SET_TOKEN('CODE',
693: p_main_heading_code,
694: FALSE);
695: FND_MESSAGE.SET_TOKEN('TABLES',
696: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
697: FALSE);
698: IF FND_API.To_Boolean(p_called_by_form) THEN
699: APP_EXCEPTION.Raise_Exception;

Line 701: x_msg_data := FND_MESSAGE.Get;

697: FALSE);
698: IF FND_API.To_Boolean(p_called_by_form) THEN
699: APP_EXCEPTION.Raise_Exception;
700: ELSE
701: x_msg_data := FND_MESSAGE.Get;
702: END IF;
703: WHEN OTHERS THEN
704:
705: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 709: FND_MESSAGE.SET_NAME('GR',

705: ROLLBACK TO SAVEPOINT Check_Integrity;
706: x_return_status := 'U';
707: x_oracle_error := APP_EXCEPTION.Get_Code;
708: l_msg_data := APP_EXCEPTION.Get_Text;
709: FND_MESSAGE.SET_NAME('GR',
710: 'GR_UNEXPECTED_ERROR');
711: FND_MESSAGE.SET_TOKEN('TEXT',
712: l_msg_data,
713: FALSE);

Line 711: FND_MESSAGE.SET_TOKEN('TEXT',

707: x_oracle_error := APP_EXCEPTION.Get_Code;
708: l_msg_data := APP_EXCEPTION.Get_Text;
709: FND_MESSAGE.SET_NAME('GR',
710: 'GR_UNEXPECTED_ERROR');
711: FND_MESSAGE.SET_TOKEN('TEXT',
712: l_msg_data,
713: FALSE);
714: IF FND_API.To_Boolean(p_called_by_form) THEN
715: APP_EXCEPTION.Raise_Exception;

Line 717: x_msg_data := FND_MESSAGE.Get;

713: FALSE);
714: IF FND_API.To_Boolean(p_called_by_form) THEN
715: APP_EXCEPTION.Raise_Exception;
716: ELSE
717: x_msg_data := FND_MESSAGE.Get;
718: END IF;
719:
720: END Check_Integrity;
721:

Line 766: FND_MESSAGE.SET_NAME('GR',

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

Line 768: FND_MESSAGE.SET_TOKEN('TEXT',

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