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

Line 288: FND_MESSAGE.SET_NAME('GR',

284: WHEN Foreign_Key_Error THEN
285: ROLLBACK TO SAVEPOINT Insert_Row;
286: x_return_status := l_return_status;
287: x_oracle_error := l_oracle_error;
288: FND_MESSAGE.SET_NAME('GR',
289: 'GR_FOREIGN_KEY_ERROR');
290: FND_MESSAGE.SET_TOKEN('TEXT',
291: l_msg_data,
292: FALSE);

Line 290: FND_MESSAGE.SET_TOKEN('TEXT',

286: x_return_status := l_return_status;
287: x_oracle_error := l_oracle_error;
288: FND_MESSAGE.SET_NAME('GR',
289: 'GR_FOREIGN_KEY_ERROR');
290: FND_MESSAGE.SET_TOKEN('TEXT',
291: l_msg_data,
292: FALSE);
293: IF FND_API.To_Boolean(p_called_by_form) THEN
294: APP_EXCEPTION.Raise_Exception;

Line 296: x_msg_data := FND_MESSAGE.Get;

292: FALSE);
293: IF FND_API.To_Boolean(p_called_by_form) THEN
294: APP_EXCEPTION.Raise_Exception;
295: ELSE
296: x_msg_data := FND_MESSAGE.Get;
297: END IF;
298:
299: WHEN Item_Exists_Error THEN
300: ROLLBACK TO SAVEPOINT Insert_Row;

Line 304: FND_MESSAGE.SET_NAME('GR',

300: ROLLBACK TO SAVEPOINT Insert_Row;
301: l_msg_token := p_phrase_code || ' ' || p_language;
302: x_return_status := 'E';
303: x_oracle_error := APP_EXCEPTION.Get_Code;
304: FND_MESSAGE.SET_NAME('GR',
305: 'GR_RECORD_EXISTS');
306: FND_MESSAGE.SET_TOKEN('CODE',
307: l_msg_token,
308: FALSE);

Line 306: FND_MESSAGE.SET_TOKEN('CODE',

302: x_return_status := 'E';
303: x_oracle_error := APP_EXCEPTION.Get_Code;
304: FND_MESSAGE.SET_NAME('GR',
305: 'GR_RECORD_EXISTS');
306: FND_MESSAGE.SET_TOKEN('CODE',
307: l_msg_token,
308: FALSE);
309: IF FND_API.To_Boolean(p_called_by_form) THEN
310: APP_EXCEPTION.Raise_Exception;

Line 312: x_msg_data := FND_MESSAGE.Get;

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

Line 320: FND_MESSAGE.SET_NAME('GR',

316: ROLLBACK TO SAVEPOINT Insert_Row;
317: l_msg_token := p_phrase_code || ' ' || p_language;
318: x_return_status := 'E';
319: x_oracle_error := APP_EXCEPTION.Get_Code;
320: FND_MESSAGE.SET_NAME('GR',
321: 'GR_NO_RECORD_INSERTED');
322: FND_MESSAGE.SET_TOKEN('CODE',
323: l_msg_token,
324: FALSE);

Line 322: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 328: x_msg_data := FND_MESSAGE.Get;

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

Line 337: FND_MESSAGE.SET_NAME('GR',

333: l_msg_token := p_phrase_code || ' ' || p_language;
334: x_return_status := 'U';
335: x_oracle_error := SQLCODE;
336: l_msg_data := SUBSTR(SQLERRM, 1, 200);
337: FND_MESSAGE.SET_NAME('GR',
338: 'GR_UNEXPECTED_ERROR');
339: FND_MESSAGE.SET_TOKEN('TEXT',
340: l_msg_token,
341: FALSE);

Line 339: FND_MESSAGE.SET_TOKEN('TEXT',

335: x_oracle_error := SQLCODE;
336: l_msg_data := SUBSTR(SQLERRM, 1, 200);
337: FND_MESSAGE.SET_NAME('GR',
338: 'GR_UNEXPECTED_ERROR');
339: FND_MESSAGE.SET_TOKEN('TEXT',
340: l_msg_token,
341: FALSE);
342: IF FND_API.To_Boolean(p_called_by_form) THEN
343: APP_EXCEPTION.Raise_Exception;

Line 345: x_msg_data := FND_MESSAGE.Get;

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

Line 558: FND_MESSAGE.SET_NAME('GR',

554: WHEN Foreign_Key_Error THEN
555: ROLLBACK TO SAVEPOINT Update_Row;
556: x_return_status := l_return_status;
557: x_oracle_error := l_oracle_error;
558: FND_MESSAGE.SET_NAME('GR',
559: 'GR_FOREIGN_KEY_ERROR');
560: FND_MESSAGE.SET_TOKEN('TEXT',
561: l_msg_data,
562: FALSE);

Line 560: FND_MESSAGE.SET_TOKEN('TEXT',

556: x_return_status := l_return_status;
557: x_oracle_error := l_oracle_error;
558: FND_MESSAGE.SET_NAME('GR',
559: 'GR_FOREIGN_KEY_ERROR');
560: FND_MESSAGE.SET_TOKEN('TEXT',
561: l_msg_data,
562: FALSE);
563: IF FND_API.To_Boolean(p_called_by_form) THEN
564: APP_EXCEPTION.Raise_Exception;

Line 566: x_msg_data := FND_MESSAGE.Get;

562: FALSE);
563: IF FND_API.To_Boolean(p_called_by_form) THEN
564: APP_EXCEPTION.Raise_Exception;
565: ELSE
566: x_msg_data := FND_MESSAGE.Get;
567: END IF;
568:
569: WHEN Row_Missing_Error THEN
570: ROLLBACK TO SAVEPOINT Update_Row;

Line 573: FND_MESSAGE.SET_NAME('GR',

569: WHEN Row_Missing_Error THEN
570: ROLLBACK TO SAVEPOINT Update_Row;
571: x_return_status := 'E';
572: x_oracle_error := APP_EXCEPTION.Get_Code;
573: FND_MESSAGE.SET_NAME('GR',
574: 'GR_NO_RECORD_INSERTED');
575: FND_MESSAGE.SET_TOKEN('CODE',
576: l_msg_token,
577: FALSE);

Line 575: FND_MESSAGE.SET_TOKEN('CODE',

571: x_return_status := 'E';
572: x_oracle_error := APP_EXCEPTION.Get_Code;
573: FND_MESSAGE.SET_NAME('GR',
574: 'GR_NO_RECORD_INSERTED');
575: FND_MESSAGE.SET_TOKEN('CODE',
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: WHEN OTHERS THEN
585: ROLLBACK TO SAVEPOINT Update_Row;

Line 589: FND_MESSAGE.SET_NAME('GR',

585: ROLLBACK TO SAVEPOINT Update_Row;
586: x_return_status := 'U';
587: x_oracle_error := SQLCODE;
588: l_msg_data := SUBSTR(SQLERRM, 1, 200);
589: FND_MESSAGE.SET_NAME('GR',
590: 'GR_UNEXPECTED_ERROR');
591: FND_MESSAGE.SET_TOKEN('TEXT',
592: l_msg_token,
593: FALSE);

Line 591: FND_MESSAGE.SET_TOKEN('TEXT',

587: x_oracle_error := SQLCODE;
588: l_msg_data := SUBSTR(SQLERRM, 1, 200);
589: FND_MESSAGE.SET_NAME('GR',
590: 'GR_UNEXPECTED_ERROR');
591: FND_MESSAGE.SET_TOKEN('TEXT',
592: l_msg_token,
593: FALSE);
594: IF FND_API.To_Boolean(p_called_by_form) THEN
595: APP_EXCEPTION.Raise_Exception;

Line 597: x_msg_data := FND_MESSAGE.Get;

593: FALSE);
594: IF FND_API.To_Boolean(p_called_by_form) THEN
595: APP_EXCEPTION.Raise_Exception;
596: ELSE
597: x_msg_data := FND_MESSAGE.Get;
598: END IF;
599:
600: END Update_Row;
601:

Line 977: FND_MESSAGE.SET_NAME('GR',

973: WHEN Language_Missing_Error THEN
974: ROLLBACK TO SAVEPOINT Add_Language;
975: x_return_status := 'E';
976: x_oracle_error := APP_EXCEPTION.Get_Code;
977: FND_MESSAGE.SET_NAME('GR',
978: 'GR_RECORD_NOT_FOUND');
979: FND_MESSAGE.SET_TOKEN('CODE',
980: l_msg_token,
981: FALSE);

Line 979: FND_MESSAGE.SET_TOKEN('CODE',

975: x_return_status := 'E';
976: x_oracle_error := APP_EXCEPTION.Get_Code;
977: FND_MESSAGE.SET_NAME('GR',
978: 'GR_RECORD_NOT_FOUND');
979: FND_MESSAGE.SET_TOKEN('CODE',
980: l_msg_token,
981: FALSE);
982: IF FND_API.To_Boolean(p_called_by_form) THEN
983: APP_EXCEPTION.Raise_Exception;

Line 985: x_msg_data := FND_MESSAGE.Get;

981: FALSE);
982: IF FND_API.To_Boolean(p_called_by_form) THEN
983: APP_EXCEPTION.Raise_Exception;
984: ELSE
985: x_msg_data := FND_MESSAGE.Get;
986: END IF;
987:
988: WHEN OTHERS THEN
989: ROLLBACK TO SAVEPOINT Add_Language;

Line 993: FND_MESSAGE.SET_NAME('GR',

989: ROLLBACK TO SAVEPOINT Add_Language;
990: x_return_status := 'U';
991: x_oracle_error := SQLCODE;
992: l_msg_data := SUBSTR(SQLERRM, 1, 200);
993: FND_MESSAGE.SET_NAME('GR',
994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',
996: l_msg_token,
997: FALSE);

Line 995: FND_MESSAGE.SET_TOKEN('TEXT',

991: x_oracle_error := SQLCODE;
992: l_msg_data := SUBSTR(SQLERRM, 1, 200);
993: FND_MESSAGE.SET_NAME('GR',
994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',
996: l_msg_token,
997: FALSE);
998: IF FND_API.To_Boolean(p_called_by_form) THEN
999: APP_EXCEPTION.Raise_Exception;

Line 1001: x_msg_data := FND_MESSAGE.Get;

997: FALSE);
998: IF FND_API.To_Boolean(p_called_by_form) THEN
999: APP_EXCEPTION.Raise_Exception;
1000: ELSE
1001: x_msg_data := FND_MESSAGE.Get;
1002: END IF;
1003:
1004: END Add_Language;
1005:

Line 1123: FND_MESSAGE.SET_NAME('GR',

1119:
1120: WHEN No_Data_Found_Error THEN
1121: ROLLBACK TO SAVEPOINT Lock_Row;
1122: x_return_status := 'E';
1123: FND_MESSAGE.SET_NAME('GR',
1124: 'GR_RECORD_NOT_FOUND');
1125: FND_MESSAGE.SET_TOKEN('CODE',
1126: l_msg_token,
1127: FALSE);

Line 1125: FND_MESSAGE.SET_TOKEN('CODE',

1121: ROLLBACK TO SAVEPOINT Lock_Row;
1122: x_return_status := 'E';
1123: FND_MESSAGE.SET_NAME('GR',
1124: 'GR_RECORD_NOT_FOUND');
1125: FND_MESSAGE.SET_TOKEN('CODE',
1126: l_msg_token,
1127: FALSE);
1128: IF FND_API.To_Boolean(p_called_by_form) THEN
1129: APP_EXCEPTION.Raise_Exception;

Line 1131: x_msg_data := FND_MESSAGE.Get;

1127: FALSE);
1128: IF FND_API.To_Boolean(p_called_by_form) THEN
1129: APP_EXCEPTION.Raise_Exception;
1130: ELSE
1131: x_msg_data := FND_MESSAGE.Get;
1132: END IF;
1133:
1134: WHEN RECORD_CHANGED_ERROR THEN
1135: ROLLBACK TO SAVEPOINT Lock_Row;

Line 1137: FND_MESSAGE.SET_NAME('FND',

1133:
1134: WHEN RECORD_CHANGED_ERROR THEN
1135: ROLLBACK TO SAVEPOINT Lock_Row;
1136: X_return_status := 'E';
1137: FND_MESSAGE.SET_NAME('FND',
1138: 'FORM_RECORD_CHANGED');
1139: IF FND_API.To_Boolean(p_called_by_form) THEN
1140: APP_EXCEPTION.Raise_Exception;
1141: ELSE

Line 1142: x_msg_data := FND_MESSAGE.Get;

1138: 'FORM_RECORD_CHANGED');
1139: IF FND_API.To_Boolean(p_called_by_form) THEN
1140: APP_EXCEPTION.Raise_Exception;
1141: ELSE
1142: x_msg_data := FND_MESSAGE.Get;
1143: END IF;
1144: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1145: ROLLBACK TO SAVEPOINT Lock_Row;
1146: x_return_status := 'L';

Line 1149: FND_MESSAGE.SET_NAME('GR',

1145: ROLLBACK TO SAVEPOINT Lock_Row;
1146: x_return_status := 'L';
1147: x_oracle_error := APP_EXCEPTION.Get_Code;
1148: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
1149: FND_MESSAGE.SET_NAME('GR',
1150: 'GR_ROW_IS_LOCKED');
1151: x_msg_data := FND_MESSAGE.Get;
1152: END IF;
1153: WHEN OTHERS THEN

Line 1151: x_msg_data := FND_MESSAGE.Get;

1147: x_oracle_error := APP_EXCEPTION.Get_Code;
1148: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
1149: FND_MESSAGE.SET_NAME('GR',
1150: 'GR_ROW_IS_LOCKED');
1151: x_msg_data := FND_MESSAGE.Get;
1152: END IF;
1153: WHEN OTHERS THEN
1154: ROLLBACK TO SAVEPOINT Lock_Row;
1155: x_return_status := 'U';

Line 1158: FND_MESSAGE.SET_NAME('GR',

1154: ROLLBACK TO SAVEPOINT Lock_Row;
1155: x_return_status := 'U';
1156: x_oracle_error := SQLCODE;
1157: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1158: FND_MESSAGE.SET_NAME('GR',
1159: 'GR_UNEXPECTED_ERROR');
1160: FND_MESSAGE.SET_TOKEN('TEXT',
1161: l_msg_token,
1162: FALSE);

Line 1160: FND_MESSAGE.SET_TOKEN('TEXT',

1156: x_oracle_error := SQLCODE;
1157: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1158: FND_MESSAGE.SET_NAME('GR',
1159: 'GR_UNEXPECTED_ERROR');
1160: FND_MESSAGE.SET_TOKEN('TEXT',
1161: l_msg_token,
1162: FALSE);
1163: IF FND_API.To_Boolean(p_called_by_form) THEN
1164: APP_EXCEPTION.Raise_Exception;

Line 1166: x_msg_data := FND_MESSAGE.Get;

1162: FALSE);
1163: IF FND_API.To_Boolean(p_called_by_form) THEN
1164: APP_EXCEPTION.Raise_Exception;
1165: ELSE
1166: x_msg_data := FND_MESSAGE.Get;
1167: END IF;
1168:
1169: END Lock_Row;
1170:

Line 1335: x_msg_data := FND_MESSAGE.Get;

1331: x_oracle_error := l_oracle_error;
1332: IF FND_API.To_Boolean(p_called_by_form) THEN
1333: APP_EXCEPTION.Raise_Exception;
1334: ELSE
1335: x_msg_data := FND_MESSAGE.Get;
1336: END IF;
1337:
1338: WHEN Row_Missing_Error THEN
1339: ROLLBACK TO SAVEPOINT Delete_Row;

Line 1342: FND_MESSAGE.SET_NAME('GR',

1338: WHEN Row_Missing_Error THEN
1339: ROLLBACK TO SAVEPOINT Delete_Row;
1340: x_return_status := 'E';
1341: x_oracle_error := APP_EXCEPTION.Get_Code;
1342: FND_MESSAGE.SET_NAME('GR',
1343: 'GR_RECORD_NOT_FOUND');
1344: FND_MESSAGE.SET_TOKEN('CODE',
1345: l_msg_token,
1346: FALSE);

Line 1344: FND_MESSAGE.SET_TOKEN('CODE',

1340: x_return_status := 'E';
1341: x_oracle_error := APP_EXCEPTION.Get_Code;
1342: FND_MESSAGE.SET_NAME('GR',
1343: 'GR_RECORD_NOT_FOUND');
1344: FND_MESSAGE.SET_TOKEN('CODE',
1345: l_msg_token,
1346: FALSE);
1347: IF FND_API.To_Boolean(p_called_by_form) THEN
1348: APP_EXCEPTION.Raise_Exception;

Line 1350: x_msg_data := FND_MESSAGE.Get;

1346: FALSE);
1347: IF FND_API.To_Boolean(p_called_by_form) THEN
1348: APP_EXCEPTION.Raise_Exception;
1349: ELSE
1350: x_msg_data := FND_MESSAGE.Get;
1351: END IF;
1352:
1353: WHEN OTHERS THEN
1354: ROLLBACK TO SAVEPOINT Delete_Row;

Line 1358: FND_MESSAGE.SET_NAME('GR',

1354: ROLLBACK TO SAVEPOINT Delete_Row;
1355: x_return_status := 'U';
1356: x_oracle_error := SQLCODE;
1357: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1358: FND_MESSAGE.SET_NAME('GR',
1359: 'GR_UNEXPECTED_ERROR');
1360: FND_MESSAGE.SET_TOKEN('TEXT',
1361: l_msg_token,
1362: FALSE);

Line 1360: FND_MESSAGE.SET_TOKEN('TEXT',

1356: x_oracle_error := SQLCODE;
1357: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1358: FND_MESSAGE.SET_NAME('GR',
1359: 'GR_UNEXPECTED_ERROR');
1360: FND_MESSAGE.SET_TOKEN('TEXT',
1361: l_msg_token,
1362: FALSE);
1363: IF FND_API.To_Boolean(p_called_by_form) THEN
1364: APP_EXCEPTION.Raise_Exception;

Line 1366: x_msg_data := FND_MESSAGE.Get;

1362: FALSE);
1363: IF FND_API.To_Boolean(p_called_by_form) THEN
1364: APP_EXCEPTION.Raise_Exception;
1365: ELSE
1366: x_msg_data := FND_MESSAGE.Get;
1367: END IF;
1368:
1369: END Delete_Row;
1370:

Line 1416: FND_MESSAGE.SET_NAME('GR',

1412: ROLLBACK TO SAVEPOINT Delete_Rows;
1413: x_return_status := 'U';
1414: x_oracle_error := SQLCODE;
1415: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1416: FND_MESSAGE.SET_NAME('GR',
1417: 'GR_UNEXPECTED_ERROR');
1418: FND_MESSAGE.SET_TOKEN('TEXT',
1419: l_msg_token,
1420: FALSE);

Line 1418: FND_MESSAGE.SET_TOKEN('TEXT',

1414: x_oracle_error := SQLCODE;
1415: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1416: FND_MESSAGE.SET_NAME('GR',
1417: 'GR_UNEXPECTED_ERROR');
1418: FND_MESSAGE.SET_TOKEN('TEXT',
1419: l_msg_token,
1420: FALSE);
1421: IF FND_API.To_Boolean(p_called_by_form) THEN
1422: APP_EXCEPTION.Raise_Exception;

Line 1424: x_msg_data := FND_MESSAGE.Get;

1420: FALSE);
1421: IF FND_API.To_Boolean(p_called_by_form) THEN
1422: APP_EXCEPTION.Raise_Exception;
1423: ELSE
1424: x_msg_data := FND_MESSAGE.Get;
1425: END IF;
1426:
1427: END Delete_Rows;
1428:

Line 1542: FND_MESSAGE.SET_NAME('GR',

1538: WHEN Row_Missing_Error THEN
1539: ROLLBACK TO SAVEPOINT Delete_Row;
1540: x_return_status := 'E';
1541: x_oracle_error := APP_EXCEPTION.Get_Code;
1542: FND_MESSAGE.SET_NAME('GR',
1543: 'GR_RECORD_NOT_FOUND');
1544: FND_MESSAGE.SET_TOKEN('CODE',
1545: l_msg_token,
1546: FALSE);

Line 1544: FND_MESSAGE.SET_TOKEN('CODE',

1540: x_return_status := 'E';
1541: x_oracle_error := APP_EXCEPTION.Get_Code;
1542: FND_MESSAGE.SET_NAME('GR',
1543: 'GR_RECORD_NOT_FOUND');
1544: FND_MESSAGE.SET_TOKEN('CODE',
1545: l_msg_token,
1546: FALSE);
1547: x_msg_data := FND_MESSAGE.Get;
1548:

Line 1547: x_msg_data := FND_MESSAGE.Get;

1543: 'GR_RECORD_NOT_FOUND');
1544: FND_MESSAGE.SET_TOKEN('CODE',
1545: l_msg_token,
1546: FALSE);
1547: x_msg_data := FND_MESSAGE.Get;
1548:
1549: WHEN OTHERS THEN
1550: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1551: x_return_status := 'U';

Line 1554: FND_MESSAGE.SET_NAME('GR',

1550: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1551: x_return_status := 'U';
1552: x_oracle_error := SQLCODE;
1553: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1554: FND_MESSAGE.SET_NAME('GR',
1555: 'GR_UNEXPECTED_ERROR');
1556: FND_MESSAGE.SET_TOKEN('TEXT',
1557: l_msg_token,
1558: FALSE);

Line 1556: FND_MESSAGE.SET_TOKEN('TEXT',

1552: x_oracle_error := SQLCODE;
1553: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1554: FND_MESSAGE.SET_NAME('GR',
1555: 'GR_UNEXPECTED_ERROR');
1556: FND_MESSAGE.SET_TOKEN('TEXT',
1557: l_msg_token,
1558: FALSE);
1559: x_msg_data := FND_MESSAGE.Get;
1560:

Line 1559: x_msg_data := FND_MESSAGE.Get;

1555: 'GR_UNEXPECTED_ERROR');
1556: FND_MESSAGE.SET_TOKEN('TEXT',
1557: l_msg_token,
1558: FALSE);
1559: x_msg_data := FND_MESSAGE.Get;
1560:
1561: END Check_Foreign_Keys;
1562:
1563: PROCEDURE Check_Integrity

Line 1665: FND_MESSAGE.SET_NAME('GR',

1661:
1662: WHEN Installed_Language_Error THEN
1663: ROLLBACK TO SAVEPOINT Check_Integrity;
1664: x_return_status := 'E';
1665: FND_MESSAGE.SET_NAME('GR',
1666: 'GR_INSTALLED_LANG');
1667: FND_MESSAGE.SET_TOKEN('CODE',
1668: p_language,
1669: FALSE);

Line 1667: FND_MESSAGE.SET_TOKEN('CODE',

1663: ROLLBACK TO SAVEPOINT Check_Integrity;
1664: x_return_status := 'E';
1665: FND_MESSAGE.SET_NAME('GR',
1666: 'GR_INSTALLED_LANG');
1667: FND_MESSAGE.SET_TOKEN('CODE',
1668: p_language,
1669: FALSE);
1670: IF FND_API.To_Boolean(p_called_by_form) THEN
1671: APP_EXCEPTION.Raise_Exception;

Line 1673: x_msg_data := FND_MESSAGE.Get;

1669: FALSE);
1670: IF FND_API.To_Boolean(p_called_by_form) THEN
1671: APP_EXCEPTION.Raise_Exception;
1672: ELSE
1673: x_msg_data := FND_MESSAGE.Get;
1674: END IF;
1675:
1676: WHEN OTHERS THEN
1677: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 1681: FND_MESSAGE.SET_NAME('GR',

1677: ROLLBACK TO SAVEPOINT Check_Integrity;
1678: x_return_status := 'U';
1679: x_oracle_error := SQLCODE;
1680: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1681: FND_MESSAGE.SET_NAME('GR',
1682: 'GR_UNEXPECTED_ERROR');
1683: FND_MESSAGE.SET_TOKEN('TEXT',
1684: l_msg_data,
1685: FALSE);

Line 1683: FND_MESSAGE.SET_TOKEN('TEXT',

1679: x_oracle_error := SQLCODE;
1680: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1681: FND_MESSAGE.SET_NAME('GR',
1682: 'GR_UNEXPECTED_ERROR');
1683: FND_MESSAGE.SET_TOKEN('TEXT',
1684: l_msg_data,
1685: FALSE);
1686: IF FND_API.To_Boolean(p_called_by_form) THEN
1687: APP_EXCEPTION.Raise_Exception;

Line 1689: x_msg_data := FND_MESSAGE.Get;

1685: FALSE);
1686: IF FND_API.To_Boolean(p_called_by_form) THEN
1687: APP_EXCEPTION.Raise_Exception;
1688: ELSE
1689: x_msg_data := FND_MESSAGE.Get;
1690: END IF;
1691:
1692: END Check_Integrity;
1693:

Line 1741: FND_MESSAGE.SET_NAME('GR',

1737: EXCEPTION
1738:
1739: WHEN Others THEN
1740: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1741: FND_MESSAGE.SET_NAME('GR',
1742: 'GR_UNEXPECTED_ERROR');
1743: FND_MESSAGE.SET_TOKEN('TEXT',
1744: l_msg_data,
1745: FALSE);

Line 1743: FND_MESSAGE.SET_TOKEN('TEXT',

1739: WHEN Others THEN
1740: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1741: FND_MESSAGE.SET_NAME('GR',
1742: 'GR_UNEXPECTED_ERROR');
1743: FND_MESSAGE.SET_TOKEN('TEXT',
1744: l_msg_data,
1745: FALSE);
1746: IF FND_API.To_Boolean(p_called_by_form) THEN
1747: APP_EXCEPTION.Raise_Exception;