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

Line 148: FND_MESSAGE.SET_NAME('GR',

144: WHEN Foreign_Key_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;
146: x_return_status := l_return_status;
147: x_oracle_error := l_oracle_error;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_FOREIGN_KEY_ERROR');
150: FND_MESSAGE.SET_TOKEN('TEXT',
151: l_msg_data,
152: FALSE);

Line 150: FND_MESSAGE.SET_TOKEN('TEXT',

146: x_return_status := l_return_status;
147: x_oracle_error := l_oracle_error;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_FOREIGN_KEY_ERROR');
150: FND_MESSAGE.SET_TOKEN('TEXT',
151: l_msg_data,
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 Label_Exists_Error THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;

Line 163: FND_MESSAGE.SET_NAME('GR',

159: WHEN Label_Exists_Error THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_RECORD_EXISTS');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_item_code || ' ' || p_document_code,
167: FALSE);

Line 165: FND_MESSAGE.SET_TOKEN('CODE',

161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_RECORD_EXISTS');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_item_code || ' ' || p_document_code,
167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;

Line 171: x_msg_data := FND_MESSAGE.Get;

167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;
170: ELSE
171: x_msg_data := FND_MESSAGE.Get;
172: END IF;
173:
174: WHEN Row_Missing_Error THEN
175: ROLLBACK TO SAVEPOINT Insert_Row;

Line 179: FND_MESSAGE.SET_NAME('GR',

175: ROLLBACK TO SAVEPOINT Insert_Row;
176: l_msg_data := p_item_code || ' ' || p_document_code;
177: x_return_status := 'E';
178: x_oracle_error := APP_EXCEPTION.Get_Code;
179: FND_MESSAGE.SET_NAME('GR',
180: 'GR_NO_RECORD_INSERTED');
181: FND_MESSAGE.SET_TOKEN('CODE',
182: l_msg_data,
183: FALSE);

Line 181: FND_MESSAGE.SET_TOKEN('CODE',

177: x_return_status := 'E';
178: x_oracle_error := APP_EXCEPTION.Get_Code;
179: FND_MESSAGE.SET_NAME('GR',
180: 'GR_NO_RECORD_INSERTED');
181: FND_MESSAGE.SET_TOKEN('CODE',
182: l_msg_data,
183: FALSE);
184: IF FND_API.To_Boolean(p_called_by_form) THEN
185: APP_EXCEPTION.Raise_Exception;

Line 187: x_msg_data := FND_MESSAGE.Get;

183: FALSE);
184: IF FND_API.To_Boolean(p_called_by_form) THEN
185: APP_EXCEPTION.Raise_Exception;
186: ELSE
187: x_msg_data := FND_MESSAGE.Get;
188: END IF;
189:
190: WHEN OTHERS THEN
191: ROLLBACK TO SAVEPOINT Insert_Row;

Line 195: FND_MESSAGE.SET_NAME('GR',

191: ROLLBACK TO SAVEPOINT Insert_Row;
192: x_return_status := 'U';
193: x_oracle_error := APP_EXCEPTION.Get_Code;
194: l_msg_data := APP_EXCEPTION.Get_Text;
195: FND_MESSAGE.SET_NAME('GR',
196: 'GR_UNEXPECTED_ERROR');
197: FND_MESSAGE.SET_TOKEN('TEXT',
198: l_msg_data,
199: FALSE);

Line 197: FND_MESSAGE.SET_TOKEN('TEXT',

193: x_oracle_error := APP_EXCEPTION.Get_Code;
194: l_msg_data := APP_EXCEPTION.Get_Text;
195: FND_MESSAGE.SET_NAME('GR',
196: 'GR_UNEXPECTED_ERROR');
197: FND_MESSAGE.SET_TOKEN('TEXT',
198: l_msg_data,
199: FALSE);
200: IF FND_API.To_Boolean(p_called_by_form) THEN
201: APP_EXCEPTION.Raise_Exception;

Line 203: x_msg_data := FND_MESSAGE.Get;

199: FALSE);
200: IF FND_API.To_Boolean(p_called_by_form) THEN
201: APP_EXCEPTION.Raise_Exception;
202: ELSE
203: x_msg_data := FND_MESSAGE.Get;
204: END IF;
205:
206: END Insert_Row;
207:

Line 306: FND_MESSAGE.SET_NAME('GR',

302: WHEN Foreign_Key_Error THEN
303: ROLLBACK TO SAVEPOINT Update_Row;
304: x_return_status := l_return_status;
305: x_oracle_error := l_oracle_error;
306: FND_MESSAGE.SET_NAME('GR',
307: 'GR_FOREIGN_KEY_ERROR');
308: FND_MESSAGE.SET_TOKEN('TEXT',
309: l_msg_data,
310: FALSE);

Line 308: FND_MESSAGE.SET_TOKEN('TEXT',

304: x_return_status := l_return_status;
305: x_oracle_error := l_oracle_error;
306: FND_MESSAGE.SET_NAME('GR',
307: 'GR_FOREIGN_KEY_ERROR');
308: FND_MESSAGE.SET_TOKEN('TEXT',
309: l_msg_data,
310: FALSE);
311: IF FND_API.To_Boolean(p_called_by_form) THEN
312: APP_EXCEPTION.Raise_Exception;

Line 314: x_msg_data := FND_MESSAGE.Get;

310: FALSE);
311: IF FND_API.To_Boolean(p_called_by_form) THEN
312: APP_EXCEPTION.Raise_Exception;
313: ELSE
314: x_msg_data := FND_MESSAGE.Get;
315: END IF;
316:
317: WHEN Row_Missing_Error THEN
318: ROLLBACK TO SAVEPOINT Update_Row;

Line 322: FND_MESSAGE.SET_NAME('GR',

318: ROLLBACK TO SAVEPOINT Update_Row;
319: l_msg_data := p_item_code || ' ' || p_document_code;
320: x_return_status := 'E';
321: x_oracle_error := APP_EXCEPTION.Get_Code;
322: FND_MESSAGE.SET_NAME('GR',
323: 'GR_NO_RECORD_INSERTED');
324: FND_MESSAGE.SET_TOKEN('CODE',
325: l_msg_data,
326: FALSE);

Line 324: FND_MESSAGE.SET_TOKEN('CODE',

320: x_return_status := 'E';
321: x_oracle_error := APP_EXCEPTION.Get_Code;
322: FND_MESSAGE.SET_NAME('GR',
323: 'GR_NO_RECORD_INSERTED');
324: FND_MESSAGE.SET_TOKEN('CODE',
325: l_msg_data,
326: FALSE);
327: IF FND_API.To_Boolean(p_called_by_form) THEN
328: APP_EXCEPTION.Raise_Exception;

Line 330: x_msg_data := FND_MESSAGE.Get;

326: FALSE);
327: IF FND_API.To_Boolean(p_called_by_form) THEN
328: APP_EXCEPTION.Raise_Exception;
329: ELSE
330: x_msg_data := FND_MESSAGE.Get;
331: END IF;
332:
333: WHEN OTHERS THEN
334: ROLLBACK TO SAVEPOINT Update_Row;

Line 338: FND_MESSAGE.SET_NAME('GR',

334: ROLLBACK TO SAVEPOINT Update_Row;
335: x_return_status := 'U';
336: x_oracle_error := APP_EXCEPTION.Get_Code;
337: l_msg_data := APP_EXCEPTION.Get_Text;
338: FND_MESSAGE.SET_NAME('GR',
339: 'GR_UNEXPECTED_ERROR');
340: FND_MESSAGE.SET_TOKEN('TEXT',
341: l_msg_data,
342: FALSE);

Line 340: FND_MESSAGE.SET_TOKEN('TEXT',

336: x_oracle_error := APP_EXCEPTION.Get_Code;
337: l_msg_data := APP_EXCEPTION.Get_Text;
338: FND_MESSAGE.SET_NAME('GR',
339: 'GR_UNEXPECTED_ERROR');
340: FND_MESSAGE.SET_TOKEN('TEXT',
341: l_msg_data,
342: FALSE);
343: IF FND_API.To_Boolean(p_called_by_form) THEN
344: APP_EXCEPTION.Raise_Exception;

Line 346: x_msg_data := FND_MESSAGE.Get;

342: FALSE);
343: IF FND_API.To_Boolean(p_called_by_form) THEN
344: APP_EXCEPTION.Raise_Exception;
345: ELSE
346: x_msg_data := FND_MESSAGE.Get;
347: END IF;
348:
349: END Update_Row;
350:

Line 428: FND_MESSAGE.SET_NAME('GR',

424: WHEN No_Data_Found_Error THEN
425: ROLLBACK TO SAVEPOINT Lock_Row;
426: l_msg_data := p_item_code || ' ' || p_document_code;
427: x_return_status := 'E';
428: FND_MESSAGE.SET_NAME('GR',
429: 'GR_RECORD_NOT_FOUND');
430: FND_MESSAGE.SET_TOKEN('CODE',
431: l_msg_data,
432: FALSE);

Line 430: FND_MESSAGE.SET_TOKEN('CODE',

426: l_msg_data := p_item_code || ' ' || p_document_code;
427: x_return_status := 'E';
428: FND_MESSAGE.SET_NAME('GR',
429: 'GR_RECORD_NOT_FOUND');
430: FND_MESSAGE.SET_TOKEN('CODE',
431: l_msg_data,
432: FALSE);
433: IF FND_API.To_Boolean(p_called_by_form) THEN
434: APP_EXCEPTION.Raise_Exception;

Line 436: x_msg_data := FND_MESSAGE.Get;

432: FALSE);
433: IF FND_API.To_Boolean(p_called_by_form) THEN
434: APP_EXCEPTION.Raise_Exception;
435: ELSE
436: x_msg_data := FND_MESSAGE.Get;
437: END IF;
438:
439: WHEN Row_Already_Locked_Error THEN
440: ROLLBACK TO SAVEPOINT Lock_Row;

Line 443: FND_MESSAGE.SET_NAME('GR',

439: WHEN Row_Already_Locked_Error THEN
440: ROLLBACK TO SAVEPOINT Lock_Row;
441: x_return_status := 'E';
442: x_oracle_error := APP_EXCEPTION.Get_Code;
443: FND_MESSAGE.SET_NAME('GR',
444: 'GR_ROW_IS_LOCKED');
445: IF FND_API.To_Boolean(p_called_by_form) THEN
446: APP_EXCEPTION.Raise_Exception;
447: ELSE

Line 448: x_msg_data := FND_MESSAGE.Get;

444: 'GR_ROW_IS_LOCKED');
445: IF FND_API.To_Boolean(p_called_by_form) THEN
446: APP_EXCEPTION.Raise_Exception;
447: ELSE
448: x_msg_data := FND_MESSAGE.Get;
449: END IF;
450:
451: WHEN OTHERS THEN
452: ROLLBACK TO SAVEPOINT Lock_Row;

Line 456: FND_MESSAGE.SET_NAME('GR',

452: ROLLBACK TO SAVEPOINT Lock_Row;
453: x_return_status := 'U';
454: x_oracle_error := APP_EXCEPTION.Get_Code;
455: l_msg_data := APP_EXCEPTION.Get_Text;
456: FND_MESSAGE.SET_NAME('GR',
457: 'GR_UNEXPECTED_ERROR');
458: FND_MESSAGE.SET_TOKEN('TEXT',
459: l_msg_data,
460: FALSE);

Line 458: FND_MESSAGE.SET_TOKEN('TEXT',

454: x_oracle_error := APP_EXCEPTION.Get_Code;
455: l_msg_data := APP_EXCEPTION.Get_Text;
456: FND_MESSAGE.SET_NAME('GR',
457: 'GR_UNEXPECTED_ERROR');
458: FND_MESSAGE.SET_TOKEN('TEXT',
459: l_msg_data,
460: FALSE);
461: IF FND_API.To_Boolean(p_called_by_form) THEN
462: APP_EXCEPTION.Raise_Exception;

Line 464: x_msg_data := FND_MESSAGE.Get;

460: FALSE);
461: IF FND_API.To_Boolean(p_called_by_form) THEN
462: APP_EXCEPTION.Raise_Exception;
463: ELSE
464: x_msg_data := FND_MESSAGE.Get;
465: END IF;
466:
467: END Lock_Row;
468:

Line 557: x_msg_data := FND_MESSAGE.Get;

553: x_oracle_error := l_oracle_error;
554: IF FND_API.To_Boolean(p_called_by_form) THEN
555: APP_EXCEPTION.Raise_Exception;
556: ELSE
557: x_msg_data := FND_MESSAGE.Get;
558: END IF;
559:
560: WHEN Row_Missing_Error THEN
561: ROLLBACK TO SAVEPOINT Delete_Row;

Line 565: FND_MESSAGE.SET_NAME('GR',

561: ROLLBACK TO SAVEPOINT Delete_Row;
562: l_msg_data := p_item_code || ' ' || p_document_code;
563: x_return_status := 'E';
564: x_oracle_error := APP_EXCEPTION.Get_Code;
565: FND_MESSAGE.SET_NAME('GR',
566: 'GR_RECORD_NOT_FOUND');
567: FND_MESSAGE.SET_TOKEN('CODE',
568: l_msg_data,
569: FALSE);

Line 567: FND_MESSAGE.SET_TOKEN('CODE',

563: x_return_status := 'E';
564: x_oracle_error := APP_EXCEPTION.Get_Code;
565: FND_MESSAGE.SET_NAME('GR',
566: 'GR_RECORD_NOT_FOUND');
567: FND_MESSAGE.SET_TOKEN('CODE',
568: l_msg_data,
569: FALSE);
570: IF FND_API.To_Boolean(p_called_by_form) THEN
571: APP_EXCEPTION.Raise_Exception;

Line 573: x_msg_data := FND_MESSAGE.Get;

569: FALSE);
570: IF FND_API.To_Boolean(p_called_by_form) THEN
571: APP_EXCEPTION.Raise_Exception;
572: ELSE
573: x_msg_data := FND_MESSAGE.Get;
574: END IF;
575:
576: WHEN OTHERS THEN
577: ROLLBACK TO SAVEPOINT Delete_Row;

Line 582: FND_MESSAGE.SET_NAME('GR',

578: x_return_status := 'U';
579: x_oracle_error := APP_EXCEPTION.Get_Code;
580: l_msg_data := APP_EXCEPTION.Get_Text;
581: l_msg_data := APP_EXCEPTION.Get_Text;
582: FND_MESSAGE.SET_NAME('GR',
583: 'GR_UNEXPECTED_ERROR');
584: FND_MESSAGE.SET_TOKEN('TEXT',
585: l_msg_data,
586: FALSE);

Line 584: FND_MESSAGE.SET_TOKEN('TEXT',

580: l_msg_data := APP_EXCEPTION.Get_Text;
581: l_msg_data := APP_EXCEPTION.Get_Text;
582: FND_MESSAGE.SET_NAME('GR',
583: 'GR_UNEXPECTED_ERROR');
584: FND_MESSAGE.SET_TOKEN('TEXT',
585: l_msg_data,
586: FALSE);
587: IF FND_API.To_Boolean(p_called_by_form) THEN
588: APP_EXCEPTION.Raise_Exception;

Line 590: x_msg_data := FND_MESSAGE.Get;

586: FALSE);
587: IF FND_API.To_Boolean(p_called_by_form) THEN
588: APP_EXCEPTION.Raise_Exception;
589: ELSE
590: x_msg_data := FND_MESSAGE.Get;
591: END IF;
592:
593: END Delete_Row;
594:

Line 678: FND_MESSAGE.SET_NAME('GR',

674:
675: WHEN Null_Delete_Option_Error THEN
676: x_return_status := 'E';
677: x_oracle_error := APP_EXCEPTION.Get_Code;
678: FND_MESSAGE.SET_NAME('GR',
679: 'GR_NULL_VALUE');
680: FND_MESSAGE.SET_TOKEN('CODE',
681: l_msg_token,
682: FALSE);

Line 680: FND_MESSAGE.SET_TOKEN('CODE',

676: x_return_status := 'E';
677: x_oracle_error := APP_EXCEPTION.Get_Code;
678: FND_MESSAGE.SET_NAME('GR',
679: 'GR_NULL_VALUE');
680: FND_MESSAGE.SET_TOKEN('CODE',
681: l_msg_token,
682: FALSE);
683: IF FND_API.To_Boolean(p_called_by_form) THEN
684: APP_EXCEPTION.Raise_Exception;

Line 686: x_msg_data := FND_MESSAGE.Get;

682: FALSE);
683: IF FND_API.To_Boolean(p_called_by_form) THEN
684: APP_EXCEPTION.Raise_Exception;
685: ELSE
686: x_msg_data := FND_MESSAGE.Get;
687: END IF;
688:
689: WHEN OTHERS THEN
690: ROLLBACK TO SAVEPOINT Delete_Rows;

Line 694: FND_MESSAGE.SET_NAME('GR',

690: ROLLBACK TO SAVEPOINT Delete_Rows;
691: x_return_status := 'U';
692: x_oracle_error := APP_EXCEPTION.Get_Code;
693: l_msg_data := APP_EXCEPTION.Get_Text;
694: FND_MESSAGE.SET_NAME('GR',
695: 'GR_UNEXPECTED_ERROR');
696: FND_MESSAGE.SET_TOKEN('TEXT',
697: l_msg_token,
698: FALSE);

Line 696: FND_MESSAGE.SET_TOKEN('TEXT',

692: x_oracle_error := APP_EXCEPTION.Get_Code;
693: l_msg_data := APP_EXCEPTION.Get_Text;
694: FND_MESSAGE.SET_NAME('GR',
695: 'GR_UNEXPECTED_ERROR');
696: FND_MESSAGE.SET_TOKEN('TEXT',
697: l_msg_token,
698: FALSE);
699: IF FND_API.To_Boolean(p_called_by_form) THEN
700: APP_EXCEPTION.Raise_Exception;

Line 702: x_msg_data := FND_MESSAGE.Get;

698: FALSE);
699: IF FND_API.To_Boolean(p_called_by_form) THEN
700: APP_EXCEPTION.Raise_Exception;
701: ELSE
702: x_msg_data := FND_MESSAGE.Get;
703: END IF;
704:
705: END Delete_Rows;
706:

Line 772: FND_MESSAGE.SET_NAME('GR',

768: l_key_exists);
769:
770: IF NOT FND_API.To_Boolean(l_key_exists) THEN
771: x_return_status := 'E';
772: FND_MESSAGE.SET_NAME('GR',
773: 'GR_RECORD_NOT_FOUND');
774: FND_MESSAGE.SET_TOKEN('CODE',
775: p_item_code,
776: FALSE);

Line 774: FND_MESSAGE.SET_TOKEN('CODE',

770: IF NOT FND_API.To_Boolean(l_key_exists) THEN
771: x_return_status := 'E';
772: FND_MESSAGE.SET_NAME('GR',
773: 'GR_RECORD_NOT_FOUND');
774: FND_MESSAGE.SET_TOKEN('CODE',
775: p_item_code,
776: FALSE);
777: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
778: END IF;

Line 777: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

773: 'GR_RECORD_NOT_FOUND');
774: FND_MESSAGE.SET_TOKEN('CODE',
775: p_item_code,
776: FALSE);
777: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
778: END IF;
779:
780: /* Check the document code */
781:

Line 791: FND_MESSAGE.SET_NAME('GR',

787: l_key_exists);
788:
789: IF NOT FND_API.To_Boolean(l_key_exists) THEN
790: x_return_status := 'E';
791: FND_MESSAGE.SET_NAME('GR',
792: 'GR_RECORD_NOT_FOUND');
793: FND_MESSAGE.SET_TOKEN('CODE',
794: p_document_code,
795: FALSE);

Line 793: FND_MESSAGE.SET_TOKEN('CODE',

789: IF NOT FND_API.To_Boolean(l_key_exists) THEN
790: x_return_status := 'E';
791: FND_MESSAGE.SET_NAME('GR',
792: 'GR_RECORD_NOT_FOUND');
793: FND_MESSAGE.SET_TOKEN('CODE',
794: p_document_code,
795: FALSE);
796: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
797: END IF;

Line 796: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

792: 'GR_RECORD_NOT_FOUND');
793: FND_MESSAGE.SET_TOKEN('CODE',
794: p_document_code,
795: FALSE);
796: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
797: END IF;
798:
799: /* Check the phrase code */
800:

Line 811: FND_MESSAGE.SET_NAME('GR',

807: l_key_exists);
808:
809: IF NOT FND_API.To_Boolean(l_key_exists) THEN
810: x_return_status := 'E';
811: FND_MESSAGE.SET_NAME('GR',
812: 'GR_RECORD_NOT_FOUND');
813: FND_MESSAGE.SET_TOKEN('CODE',
814: p_phrase_code,
815: FALSE);

Line 813: FND_MESSAGE.SET_TOKEN('CODE',

809: IF NOT FND_API.To_Boolean(l_key_exists) THEN
810: x_return_status := 'E';
811: FND_MESSAGE.SET_NAME('GR',
812: 'GR_RECORD_NOT_FOUND');
813: FND_MESSAGE.SET_TOKEN('CODE',
814: p_phrase_code,
815: FALSE);
816: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
817: END IF;

Line 816: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

812: 'GR_RECORD_NOT_FOUND');
813: FND_MESSAGE.SET_TOKEN('CODE',
814: p_phrase_code,
815: FALSE);
816: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
817: END IF;
818: END IF;
819:
820: /* Check the main heading code */

Line 826: FND_MESSAGE.SET_NAME('GR',

822: OPEN c_get_main_heading;
823: FETCH c_get_main_heading INTO MainHdgRcd;
824: IF c_get_main_heading%NOTFOUND THEN
825: x_return_status := 'E';
826: FND_MESSAGE.SET_NAME('GR',
827: 'GR_RECORD_NOT_FOUND');
828: FND_MESSAGE.SET_TOKEN('CODE',
829: p_main_heading_code,
830: FALSE);

Line 828: FND_MESSAGE.SET_TOKEN('CODE',

824: IF c_get_main_heading%NOTFOUND THEN
825: x_return_status := 'E';
826: FND_MESSAGE.SET_NAME('GR',
827: 'GR_RECORD_NOT_FOUND');
828: FND_MESSAGE.SET_TOKEN('CODE',
829: p_main_heading_code,
830: FALSE);
831: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
832: END IF;

Line 831: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

827: 'GR_RECORD_NOT_FOUND');
828: FND_MESSAGE.SET_TOKEN('CODE',
829: p_main_heading_code,
830: FALSE);
831: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
832: END IF;
833: CLOSE c_get_main_heading;
834:
835: /* Check the sub heading code */

Line 842: FND_MESSAGE.SET_NAME('GR',

838: OPEN c_get_sub_heading;
839: FETCH c_get_sub_heading INTO SubHdgRcd;
840: IF c_get_sub_heading%NOTFOUND THEN
841: x_return_status := 'E';
842: FND_MESSAGE.SET_NAME('GR',
843: 'GR_RECORD_NOT_FOUND');
844: FND_MESSAGE.SET_TOKEN('CODE',
845: p_sub_heading_code,
846: FALSE);

Line 844: FND_MESSAGE.SET_TOKEN('CODE',

840: IF c_get_sub_heading%NOTFOUND THEN
841: x_return_status := 'E';
842: FND_MESSAGE.SET_NAME('GR',
843: 'GR_RECORD_NOT_FOUND');
844: FND_MESSAGE.SET_TOKEN('CODE',
845: p_sub_heading_code,
846: FALSE);
847: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
848: END IF;

Line 847: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

843: 'GR_RECORD_NOT_FOUND');
844: FND_MESSAGE.SET_TOKEN('CODE',
845: p_sub_heading_code,
846: FALSE);
847: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
848: END IF;
849: CLOSE c_get_sub_heading;
850: END IF;
851:

Line 864: FND_MESSAGE.SET_NAME('GR',

860: l_key_exists);
861:
862: IF NOT FND_API.To_Boolean(l_key_exists) THEN
863: x_return_status := 'E';
864: FND_MESSAGE.SET_NAME('GR',
865: 'GR_RECORD_NOT_FOUND');
866: FND_MESSAGE.SET_TOKEN('CODE',
867: p_phrase_group_code,
868: FALSE);

Line 866: FND_MESSAGE.SET_TOKEN('CODE',

862: IF NOT FND_API.To_Boolean(l_key_exists) THEN
863: x_return_status := 'E';
864: FND_MESSAGE.SET_NAME('GR',
865: 'GR_RECORD_NOT_FOUND');
866: FND_MESSAGE.SET_TOKEN('CODE',
867: p_phrase_group_code,
868: FALSE);
869: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
870: END IF;

Line 869: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

865: 'GR_RECORD_NOT_FOUND');
866: FND_MESSAGE.SET_TOKEN('CODE',
867: p_phrase_group_code,
868: FALSE);
869: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
870: END IF;
871: END IF;
872:
873: IF x_return_status <> 'S' THEN

Line 884: FND_MESSAGE.SET_NAME('GR',

880: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
881: x_return_status := 'U';
882: x_oracle_error := APP_EXCEPTION.Get_Code;
883: l_msg_data := APP_EXCEPTION.Get_Text;
884: FND_MESSAGE.SET_NAME('GR',
885: 'GR_UNEXPECTED_ERROR');
886: FND_MESSAGE.SET_TOKEN('TEXT',
887: l_msg_data,
888: FALSE);

Line 886: FND_MESSAGE.SET_TOKEN('TEXT',

882: x_oracle_error := APP_EXCEPTION.Get_Code;
883: l_msg_data := APP_EXCEPTION.Get_Text;
884: FND_MESSAGE.SET_NAME('GR',
885: 'GR_UNEXPECTED_ERROR');
886: FND_MESSAGE.SET_TOKEN('TEXT',
887: l_msg_data,
888: FALSE);
889: x_msg_data := FND_MESSAGE.Get;
890:

Line 889: x_msg_data := FND_MESSAGE.Get;

885: 'GR_UNEXPECTED_ERROR');
886: FND_MESSAGE.SET_TOKEN('TEXT',
887: l_msg_data,
888: FALSE);
889: x_msg_data := FND_MESSAGE.Get;
890:
891: END Check_Foreign_Keys;
892:
893: PROCEDURE Check_Integrity

Line 948: FND_MESSAGE.SET_NAME('GR',

944: ROLLBACK TO SAVEPOINT Check_Integrity;
945: x_return_status := 'U';
946: x_oracle_error := APP_EXCEPTION.Get_Code;
947: l_msg_data := APP_EXCEPTION.Get_Text;
948: FND_MESSAGE.SET_NAME('GR',
949: 'GR_UNEXPECTED_ERROR');
950: FND_MESSAGE.SET_TOKEN('TEXT',
951: l_msg_data,
952: FALSE);

Line 950: FND_MESSAGE.SET_TOKEN('TEXT',

946: x_oracle_error := APP_EXCEPTION.Get_Code;
947: l_msg_data := APP_EXCEPTION.Get_Text;
948: FND_MESSAGE.SET_NAME('GR',
949: 'GR_UNEXPECTED_ERROR');
950: FND_MESSAGE.SET_TOKEN('TEXT',
951: l_msg_data,
952: FALSE);
953: IF FND_API.To_Boolean(p_called_by_form) THEN
954: APP_EXCEPTION.Raise_Exception;

Line 956: x_msg_data := FND_MESSAGE.Get;

952: FALSE);
953: IF FND_API.To_Boolean(p_called_by_form) THEN
954: APP_EXCEPTION.Raise_Exception;
955: ELSE
956: x_msg_data := FND_MESSAGE.Get;
957: END IF;
958:
959: END Check_Integrity;
960:

Line 1013: FND_MESSAGE.SET_NAME('GR',

1009: EXCEPTION
1010:
1011: WHEN Others THEN
1012: l_msg_data := APP_EXCEPTION.Get_Text;
1013: FND_MESSAGE.SET_NAME('GR',
1014: 'GR_UNEXPECTED_ERROR');
1015: FND_MESSAGE.SET_TOKEN('TEXT',
1016: l_msg_data,
1017: FALSE);

Line 1015: FND_MESSAGE.SET_TOKEN('TEXT',

1011: WHEN Others THEN
1012: l_msg_data := APP_EXCEPTION.Get_Text;
1013: FND_MESSAGE.SET_NAME('GR',
1014: 'GR_UNEXPECTED_ERROR');
1015: FND_MESSAGE.SET_TOKEN('TEXT',
1016: l_msg_data,
1017: FALSE);
1018: IF FND_API.To_Boolean(p_called_by_form) THEN
1019: APP_EXCEPTION.Raise_Exception;