DBA Data[Home] [Help]

APPS.GR_MULTILINGUAL_NAME_TL_PKG dependencies on FND_MESSAGE

Line 254: FND_MESSAGE.SET_NAME('GR',

250: WHEN Foreign_Key_Error THEN
251: ROLLBACK TO SAVEPOINT Insert_Row;
252: x_return_status := l_return_status;
253: x_oracle_error := l_oracle_error;
254: FND_MESSAGE.SET_NAME('GR',
255: 'GR_FOREIGN_KEY_ERROR');
256: FND_MESSAGE.SET_TOKEN('TEXT',
257: l_msg_data,
258: FALSE);

Line 256: FND_MESSAGE.SET_TOKEN('TEXT',

252: x_return_status := l_return_status;
253: x_oracle_error := l_oracle_error;
254: FND_MESSAGE.SET_NAME('GR',
255: 'GR_FOREIGN_KEY_ERROR');
256: FND_MESSAGE.SET_TOKEN('TEXT',
257: l_msg_data,
258: FALSE);
259: IF FND_API.To_Boolean(p_called_by_form) THEN
260: APP_EXCEPTION.Raise_Exception;

Line 262: x_msg_data := FND_MESSAGE.Get;

258: FALSE);
259: IF FND_API.To_Boolean(p_called_by_form) THEN
260: APP_EXCEPTION.Raise_Exception;
261: ELSE
262: x_msg_data := FND_MESSAGE.Get;
263: END IF;
264:
265: WHEN Item_Exists_Error THEN
266: ROLLBACK TO SAVEPOINT Insert_Row;

Line 270: FND_MESSAGE.SET_NAME('GR',

266: ROLLBACK TO SAVEPOINT Insert_Row;
267: l_msg_token := p_item_code || ' ' || p_label_code || ' ' || p_language;
268: x_return_status := 'E';
269: x_oracle_error := APP_EXCEPTION.Get_Code;
270: FND_MESSAGE.SET_NAME('GR',
271: 'GR_RECORD_EXISTS');
272: FND_MESSAGE.SET_TOKEN('CODE',
273: l_msg_token,
274: FALSE);

Line 272: FND_MESSAGE.SET_TOKEN('CODE',

268: x_return_status := 'E';
269: x_oracle_error := APP_EXCEPTION.Get_Code;
270: FND_MESSAGE.SET_NAME('GR',
271: 'GR_RECORD_EXISTS');
272: FND_MESSAGE.SET_TOKEN('CODE',
273: l_msg_token,
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 Insert_Row;

Line 286: FND_MESSAGE.SET_NAME('GR',

282: ROLLBACK TO SAVEPOINT Insert_Row;
283: l_msg_token := p_item_code || ' ' || p_label_code || ' ' || p_language;
284: x_return_status := 'E';
285: x_oracle_error := APP_EXCEPTION.Get_Code;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_NO_RECORD_INSERTED');
288: FND_MESSAGE.SET_TOKEN('CODE',
289: l_msg_token,
290: FALSE);

Line 288: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 294: x_msg_data := FND_MESSAGE.Get;

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

Line 303: FND_MESSAGE.SET_NAME('GR',

299: l_msg_token := p_item_code || ' ' || p_label_code || ' ' || p_language;
300: x_return_status := 'U';
301: x_oracle_error := APP_EXCEPTION.Get_Code;
302: l_msg_data := APP_EXCEPTION.Get_Text;
303: FND_MESSAGE.SET_NAME('GR',
304: 'GR_UNEXPECTED_ERROR');
305: FND_MESSAGE.SET_TOKEN('TEXT',
306: l_msg_token,
307: FALSE);

Line 305: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 311: x_msg_data := FND_MESSAGE.Get;

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

Line 497: FND_MESSAGE.SET_NAME('GR',

493: WHEN Foreign_Key_Error THEN
494: ROLLBACK TO SAVEPOINT Update_Row;
495: x_return_status := l_return_status;
496: x_oracle_error := l_oracle_error;
497: FND_MESSAGE.SET_NAME('GR',
498: 'GR_FOREIGN_KEY_ERROR');
499: FND_MESSAGE.SET_TOKEN('TEXT',
500: l_msg_data,
501: FALSE);

Line 499: FND_MESSAGE.SET_TOKEN('TEXT',

495: x_return_status := l_return_status;
496: x_oracle_error := l_oracle_error;
497: FND_MESSAGE.SET_NAME('GR',
498: 'GR_FOREIGN_KEY_ERROR');
499: FND_MESSAGE.SET_TOKEN('TEXT',
500: l_msg_data,
501: FALSE);
502: IF FND_API.To_Boolean(p_called_by_form) THEN
503: APP_EXCEPTION.Raise_Exception;

Line 505: x_msg_data := FND_MESSAGE.Get;

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

Line 512: FND_MESSAGE.SET_NAME('GR',

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

Line 514: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 520: x_msg_data := FND_MESSAGE.Get;

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

Line 528: FND_MESSAGE.SET_NAME('GR',

524: ROLLBACK TO SAVEPOINT Update_Row;
525: x_return_status := 'U';
526: x_oracle_error := APP_EXCEPTION.Get_Code;
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: x_oracle_error := APP_EXCEPTION.Get_Code;
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 Update_Row;
540:

Line 880: FND_MESSAGE.SET_NAME('GR',

876: WHEN Language_Missing_Error THEN
877: ROLLBACK TO SAVEPOINT Add_Language;
878: x_return_status := 'E';
879: x_oracle_error := APP_EXCEPTION.Get_Code;
880: FND_MESSAGE.SET_NAME('GR',
881: 'GR_RECORD_NOT_FOUND');
882: FND_MESSAGE.SET_TOKEN('CODE',
883: l_msg_token,
884: FALSE);

Line 882: FND_MESSAGE.SET_TOKEN('CODE',

878: x_return_status := 'E';
879: x_oracle_error := APP_EXCEPTION.Get_Code;
880: FND_MESSAGE.SET_NAME('GR',
881: 'GR_RECORD_NOT_FOUND');
882: FND_MESSAGE.SET_TOKEN('CODE',
883: l_msg_token,
884: FALSE);
885: IF FND_API.To_Boolean(p_called_by_form) THEN
886: APP_EXCEPTION.Raise_Exception;

Line 888: x_msg_data := FND_MESSAGE.Get;

884: FALSE);
885: IF FND_API.To_Boolean(p_called_by_form) THEN
886: APP_EXCEPTION.Raise_Exception;
887: ELSE
888: x_msg_data := FND_MESSAGE.Get;
889: END IF;
890:
891: WHEN OTHERS THEN
892: ROLLBACK TO SAVEPOINT Add_Language;

Line 895: FND_MESSAGE.SET_NAME('GR',

891: WHEN OTHERS THEN
892: ROLLBACK TO SAVEPOINT Add_Language;
893: x_return_status := 'U';
894: x_oracle_error := APP_EXCEPTION.Get_Code;
895: FND_MESSAGE.SET_NAME('GR',
896: 'GR_UNEXPECTED_ERROR');
897: FND_MESSAGE.SET_TOKEN('TEXT',
898: l_msg_token,
899: FALSE);

Line 897: FND_MESSAGE.SET_TOKEN('TEXT',

893: x_return_status := 'U';
894: x_oracle_error := APP_EXCEPTION.Get_Code;
895: FND_MESSAGE.SET_NAME('GR',
896: 'GR_UNEXPECTED_ERROR');
897: FND_MESSAGE.SET_TOKEN('TEXT',
898: l_msg_token,
899: FALSE);
900: IF FND_API.To_Boolean(p_called_by_form) THEN
901: APP_EXCEPTION.Raise_Exception;

Line 903: x_msg_data := FND_MESSAGE.Get;

899: FALSE);
900: IF FND_API.To_Boolean(p_called_by_form) THEN
901: APP_EXCEPTION.Raise_Exception;
902: ELSE
903: x_msg_data := FND_MESSAGE.Get;
904: END IF;
905:
906: END Add_Language;
907:

Line 1013: FND_MESSAGE.SET_NAME('GR',

1009:
1010: WHEN No_Data_Found_Error THEN
1011: ROLLBACK TO SAVEPOINT Lock_Row;
1012: x_return_status := 'E';
1013: FND_MESSAGE.SET_NAME('GR',
1014: 'GR_RECORD_NOT_FOUND');
1015: FND_MESSAGE.SET_TOKEN('CODE',
1016: l_msg_token,
1017: FALSE);

Line 1015: FND_MESSAGE.SET_TOKEN('CODE',

1011: ROLLBACK TO SAVEPOINT Lock_Row;
1012: x_return_status := 'E';
1013: FND_MESSAGE.SET_NAME('GR',
1014: 'GR_RECORD_NOT_FOUND');
1015: FND_MESSAGE.SET_TOKEN('CODE',
1016: l_msg_token,
1017: FALSE);
1018: IF FND_API.To_Boolean(p_called_by_form) THEN
1019: APP_EXCEPTION.Raise_Exception;

Line 1021: x_msg_data := FND_MESSAGE.Get;

1017: FALSE);
1018: IF FND_API.To_Boolean(p_called_by_form) THEN
1019: APP_EXCEPTION.Raise_Exception;
1020: ELSE
1021: x_msg_data := FND_MESSAGE.Get;
1022: END IF;
1023:
1024: WHEN Row_Already_Locked_Error THEN
1025: ROLLBACK TO SAVEPOINT Lock_Row;

Line 1028: FND_MESSAGE.SET_NAME('GR',

1024: WHEN Row_Already_Locked_Error THEN
1025: ROLLBACK TO SAVEPOINT Lock_Row;
1026: x_return_status := 'E';
1027: x_oracle_error := APP_EXCEPTION.Get_Code;
1028: FND_MESSAGE.SET_NAME('GR',
1029: 'GR_ROW_IS_LOCKED');
1030: IF FND_API.To_Boolean(p_called_by_form) THEN
1031: APP_EXCEPTION.Raise_Exception;
1032: ELSE

Line 1033: x_msg_data := FND_MESSAGE.Get;

1029: 'GR_ROW_IS_LOCKED');
1030: IF FND_API.To_Boolean(p_called_by_form) THEN
1031: APP_EXCEPTION.Raise_Exception;
1032: ELSE
1033: x_msg_data := FND_MESSAGE.Get;
1034: END IF;
1035:
1036: WHEN OTHERS THEN
1037: ROLLBACK TO SAVEPOINT Lock_Row;

Line 1041: FND_MESSAGE.SET_NAME('GR',

1037: ROLLBACK TO SAVEPOINT Lock_Row;
1038: x_return_status := 'U';
1039: x_oracle_error := APP_EXCEPTION.Get_Code;
1040: l_msg_data := APP_EXCEPTION.Get_Text;
1041: FND_MESSAGE.SET_NAME('GR',
1042: 'GR_UNEXPECTED_ERROR');
1043: FND_MESSAGE.SET_TOKEN('TEXT',
1044: l_msg_token,
1045: FALSE);

Line 1043: FND_MESSAGE.SET_TOKEN('TEXT',

1039: x_oracle_error := APP_EXCEPTION.Get_Code;
1040: l_msg_data := APP_EXCEPTION.Get_Text;
1041: FND_MESSAGE.SET_NAME('GR',
1042: 'GR_UNEXPECTED_ERROR');
1043: FND_MESSAGE.SET_TOKEN('TEXT',
1044: l_msg_token,
1045: FALSE);
1046: IF FND_API.To_Boolean(p_called_by_form) THEN
1047: APP_EXCEPTION.Raise_Exception;

Line 1049: x_msg_data := FND_MESSAGE.Get;

1045: FALSE);
1046: IF FND_API.To_Boolean(p_called_by_form) THEN
1047: APP_EXCEPTION.Raise_Exception;
1048: ELSE
1049: x_msg_data := FND_MESSAGE.Get;
1050: END IF;
1051:
1052: END Lock_Row;
1053:

Line 1200: x_msg_data := FND_MESSAGE.Get;

1196: x_oracle_error := l_oracle_error;
1197: IF FND_API.To_Boolean(p_called_by_form) THEN
1198: APP_EXCEPTION.Raise_Exception;
1199: ELSE
1200: x_msg_data := FND_MESSAGE.Get;
1201: END IF;
1202:
1203: WHEN Row_Missing_Error THEN
1204: ROLLBACK TO SAVEPOINT Delete_Row;

Line 1207: FND_MESSAGE.SET_NAME('GR',

1203: WHEN Row_Missing_Error THEN
1204: ROLLBACK TO SAVEPOINT Delete_Row;
1205: x_return_status := 'E';
1206: x_oracle_error := APP_EXCEPTION.Get_Code;
1207: FND_MESSAGE.SET_NAME('GR',
1208: 'GR_RECORD_NOT_FOUND');
1209: FND_MESSAGE.SET_TOKEN('CODE',
1210: l_msg_token,
1211: FALSE);

Line 1209: FND_MESSAGE.SET_TOKEN('CODE',

1205: x_return_status := 'E';
1206: x_oracle_error := APP_EXCEPTION.Get_Code;
1207: FND_MESSAGE.SET_NAME('GR',
1208: 'GR_RECORD_NOT_FOUND');
1209: FND_MESSAGE.SET_TOKEN('CODE',
1210: l_msg_token,
1211: FALSE);
1212: IF FND_API.To_Boolean(p_called_by_form) THEN
1213: APP_EXCEPTION.Raise_Exception;

Line 1215: x_msg_data := FND_MESSAGE.Get;

1211: FALSE);
1212: IF FND_API.To_Boolean(p_called_by_form) THEN
1213: APP_EXCEPTION.Raise_Exception;
1214: ELSE
1215: x_msg_data := FND_MESSAGE.Get;
1216: END IF;
1217:
1218: WHEN OTHERS THEN
1219: ROLLBACK TO SAVEPOINT Delete_Row;

Line 1224: FND_MESSAGE.SET_NAME('GR',

1220: x_return_status := 'U';
1221: x_oracle_error := APP_EXCEPTION.Get_Code;
1222: l_msg_data := APP_EXCEPTION.Get_Text;
1223: l_msg_data := APP_EXCEPTION.Get_Text;
1224: FND_MESSAGE.SET_NAME('GR',
1225: 'GR_UNEXPECTED_ERROR');
1226: FND_MESSAGE.SET_TOKEN('TEXT',
1227: l_msg_token,
1228: FALSE);

Line 1226: FND_MESSAGE.SET_TOKEN('TEXT',

1222: l_msg_data := APP_EXCEPTION.Get_Text;
1223: l_msg_data := APP_EXCEPTION.Get_Text;
1224: FND_MESSAGE.SET_NAME('GR',
1225: 'GR_UNEXPECTED_ERROR');
1226: FND_MESSAGE.SET_TOKEN('TEXT',
1227: l_msg_token,
1228: FALSE);
1229: IF FND_API.To_Boolean(p_called_by_form) THEN
1230: APP_EXCEPTION.Raise_Exception;

Line 1232: x_msg_data := FND_MESSAGE.Get;

1228: FALSE);
1229: IF FND_API.To_Boolean(p_called_by_form) THEN
1230: APP_EXCEPTION.Raise_Exception;
1231: ELSE
1232: x_msg_data := FND_MESSAGE.Get;
1233: END IF;
1234:
1235: END Delete_Row;
1236:

Line 1323: FND_MESSAGE.SET_NAME('GR',

1319:
1320: WHEN Null_Delete_Option_Error THEN
1321: x_return_status := 'E';
1322: x_oracle_error := APP_EXCEPTION.Get_Code;
1323: FND_MESSAGE.SET_NAME('GR',
1324: 'GR_NULL_VALUE');
1325: FND_MESSAGE.SET_TOKEN('CODE',
1326: l_msg_token,
1327: FALSE);

Line 1325: FND_MESSAGE.SET_TOKEN('CODE',

1321: x_return_status := 'E';
1322: x_oracle_error := APP_EXCEPTION.Get_Code;
1323: FND_MESSAGE.SET_NAME('GR',
1324: 'GR_NULL_VALUE');
1325: FND_MESSAGE.SET_TOKEN('CODE',
1326: l_msg_token,
1327: FALSE);
1328: IF FND_API.To_Boolean(p_called_by_form) THEN
1329: APP_EXCEPTION.Raise_Exception;

Line 1331: x_msg_data := FND_MESSAGE.Get;

1327: FALSE);
1328: IF FND_API.To_Boolean(p_called_by_form) THEN
1329: APP_EXCEPTION.Raise_Exception;
1330: ELSE
1331: x_msg_data := FND_MESSAGE.Get;
1332: END IF;
1333:
1334: WHEN OTHERS THEN
1335: ROLLBACK TO SAVEPOINT Delete_Rows;

Line 1339: FND_MESSAGE.SET_NAME('GR',

1335: ROLLBACK TO SAVEPOINT Delete_Rows;
1336: x_return_status := 'U';
1337: x_oracle_error := APP_EXCEPTION.Get_Code;
1338: l_msg_data := APP_EXCEPTION.Get_Text;
1339: FND_MESSAGE.SET_NAME('GR',
1340: 'GR_UNEXPECTED_ERROR');
1341: FND_MESSAGE.SET_TOKEN('TEXT',
1342: l_msg_token,
1343: FALSE);

Line 1341: FND_MESSAGE.SET_TOKEN('TEXT',

1337: x_oracle_error := APP_EXCEPTION.Get_Code;
1338: l_msg_data := APP_EXCEPTION.Get_Text;
1339: FND_MESSAGE.SET_NAME('GR',
1340: 'GR_UNEXPECTED_ERROR');
1341: FND_MESSAGE.SET_TOKEN('TEXT',
1342: l_msg_token,
1343: FALSE);
1344: IF FND_API.To_Boolean(p_called_by_form) THEN
1345: APP_EXCEPTION.Raise_Exception;

Line 1347: x_msg_data := FND_MESSAGE.Get;

1343: FALSE);
1344: IF FND_API.To_Boolean(p_called_by_form) THEN
1345: APP_EXCEPTION.Raise_Exception;
1346: ELSE
1347: x_msg_data := FND_MESSAGE.Get;
1348: END IF;
1349:
1350: END Delete_Rows;
1351:

Line 1441: FND_MESSAGE.SET_NAME('GR',

1437: l_rowid,
1438: l_key_exists);
1439: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1440: x_return_status := 'E';
1441: FND_MESSAGE.SET_NAME('GR',
1442: 'GR_RECORD_NOT_FOUND');
1443: FND_MESSAGE.SET_TOKEN('CODE',
1444: p_item_code,
1445: FALSE);

Line 1443: FND_MESSAGE.SET_TOKEN('CODE',

1439: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1440: x_return_status := 'E';
1441: FND_MESSAGE.SET_NAME('GR',
1442: 'GR_RECORD_NOT_FOUND');
1443: FND_MESSAGE.SET_TOKEN('CODE',
1444: p_item_code,
1445: FALSE);
1446: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1447: END IF;

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

1442: 'GR_RECORD_NOT_FOUND');
1443: FND_MESSAGE.SET_TOKEN('CODE',
1444: p_item_code,
1445: FALSE);
1446: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1447: END IF;
1448:
1449: /* Check the label code */
1450:

Line 1458: FND_MESSAGE.SET_NAME('GR',

1454: l_rowid,
1455: l_key_exists);
1456: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1457: x_return_status := 'E';
1458: FND_MESSAGE.SET_NAME('GR',
1459: 'GR_RECORD_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('CODE',
1461: p_label_code,
1462: FALSE);

Line 1460: FND_MESSAGE.SET_TOKEN('CODE',

1456: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1457: x_return_status := 'E';
1458: FND_MESSAGE.SET_NAME('GR',
1459: 'GR_RECORD_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('CODE',
1461: p_label_code,
1462: FALSE);
1463: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1464: END IF;

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

1459: 'GR_RECORD_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('CODE',
1461: p_label_code,
1462: FALSE);
1463: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1464: END IF;
1465:
1466: /* Check the language codes */
1467:

Line 1494: FND_MESSAGE.SET_NAME('GR',

1490: WHEN Row_Missing_Error THEN
1491: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1492: x_return_status := 'E';
1493: x_oracle_error := APP_EXCEPTION.Get_Code;
1494: FND_MESSAGE.SET_NAME('GR',
1495: 'GR_RECORD_NOT_FOUND');
1496: FND_MESSAGE.SET_TOKEN('CODE',
1497: l_msg_token,
1498: FALSE);

Line 1496: FND_MESSAGE.SET_TOKEN('CODE',

1492: x_return_status := 'E';
1493: x_oracle_error := APP_EXCEPTION.Get_Code;
1494: FND_MESSAGE.SET_NAME('GR',
1495: 'GR_RECORD_NOT_FOUND');
1496: FND_MESSAGE.SET_TOKEN('CODE',
1497: l_msg_token,
1498: FALSE);
1499: x_msg_data := FND_MESSAGE.Get;
1500:

Line 1499: x_msg_data := FND_MESSAGE.Get;

1495: 'GR_RECORD_NOT_FOUND');
1496: FND_MESSAGE.SET_TOKEN('CODE',
1497: l_msg_token,
1498: FALSE);
1499: x_msg_data := FND_MESSAGE.Get;
1500:
1501: WHEN OTHERS THEN
1502: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1503: x_return_status := 'U';

Line 1506: FND_MESSAGE.SET_NAME('GR',

1502: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1503: x_return_status := 'U';
1504: x_oracle_error := APP_EXCEPTION.Get_Code;
1505: l_msg_data := APP_EXCEPTION.Get_Text;
1506: FND_MESSAGE.SET_NAME('GR',
1507: 'GR_UNEXPECTED_ERROR');
1508: FND_MESSAGE.SET_TOKEN('TEXT',
1509: l_msg_token,
1510: FALSE);

Line 1508: FND_MESSAGE.SET_TOKEN('TEXT',

1504: x_oracle_error := APP_EXCEPTION.Get_Code;
1505: l_msg_data := APP_EXCEPTION.Get_Text;
1506: FND_MESSAGE.SET_NAME('GR',
1507: 'GR_UNEXPECTED_ERROR');
1508: FND_MESSAGE.SET_TOKEN('TEXT',
1509: l_msg_token,
1510: FALSE);
1511: x_msg_data := FND_MESSAGE.Get;
1512:

Line 1511: x_msg_data := FND_MESSAGE.Get;

1507: 'GR_UNEXPECTED_ERROR');
1508: FND_MESSAGE.SET_TOKEN('TEXT',
1509: l_msg_token,
1510: FALSE);
1511: x_msg_data := FND_MESSAGE.Get;
1512:
1513: END Check_Foreign_Keys;
1514:
1515: PROCEDURE Check_Integrity

Line 1608: FND_MESSAGE.SET_NAME('GR',

1604:
1605: WHEN Installed_Language_Error THEN
1606: ROLLBACK TO SAVEPOINT Check_Integrity;
1607: x_return_status := 'E';
1608: FND_MESSAGE.SET_NAME('GR',
1609: 'GR_INSTALLED_LANG');
1610: FND_MESSAGE.SET_TOKEN('CODE',
1611: p_language,
1612: FALSE);

Line 1610: FND_MESSAGE.SET_TOKEN('CODE',

1606: ROLLBACK TO SAVEPOINT Check_Integrity;
1607: x_return_status := 'E';
1608: FND_MESSAGE.SET_NAME('GR',
1609: 'GR_INSTALLED_LANG');
1610: FND_MESSAGE.SET_TOKEN('CODE',
1611: p_language,
1612: FALSE);
1613: IF FND_API.To_Boolean(p_called_by_form) THEN
1614: APP_EXCEPTION.Raise_Exception;

Line 1616: x_msg_data := FND_MESSAGE.Get;

1612: FALSE);
1613: IF FND_API.To_Boolean(p_called_by_form) THEN
1614: APP_EXCEPTION.Raise_Exception;
1615: ELSE
1616: x_msg_data := FND_MESSAGE.Get;
1617: END IF;
1618:
1619: WHEN OTHERS THEN
1620: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 1624: FND_MESSAGE.SET_NAME('GR',

1620: ROLLBACK TO SAVEPOINT Check_Integrity;
1621: x_return_status := 'U';
1622: x_oracle_error := APP_EXCEPTION.Get_Code;
1623: l_msg_data := APP_EXCEPTION.Get_Text;
1624: FND_MESSAGE.SET_NAME('GR',
1625: 'GR_UNEXPECTED_ERROR');
1626: FND_MESSAGE.SET_TOKEN('TEXT',
1627: l_msg_data,
1628: FALSE);

Line 1626: FND_MESSAGE.SET_TOKEN('TEXT',

1622: x_oracle_error := APP_EXCEPTION.Get_Code;
1623: l_msg_data := APP_EXCEPTION.Get_Text;
1624: FND_MESSAGE.SET_NAME('GR',
1625: 'GR_UNEXPECTED_ERROR');
1626: FND_MESSAGE.SET_TOKEN('TEXT',
1627: l_msg_data,
1628: FALSE);
1629: IF FND_API.To_Boolean(p_called_by_form) THEN
1630: APP_EXCEPTION.Raise_Exception;

Line 1632: x_msg_data := FND_MESSAGE.Get;

1628: FALSE);
1629: IF FND_API.To_Boolean(p_called_by_form) THEN
1630: APP_EXCEPTION.Raise_Exception;
1631: ELSE
1632: x_msg_data := FND_MESSAGE.Get;
1633: END IF;
1634:
1635: END Check_Integrity;
1636:

Line 1687: FND_MESSAGE.SET_NAME('GR',

1683: EXCEPTION
1684:
1685: WHEN Others THEN
1686: l_msg_data := APP_EXCEPTION.Get_Text;
1687: FND_MESSAGE.SET_NAME('GR',
1688: 'GR_UNEXPECTED_ERROR');
1689: FND_MESSAGE.SET_TOKEN('TEXT',
1690: l_msg_data,
1691: FALSE);

Line 1689: FND_MESSAGE.SET_TOKEN('TEXT',

1685: WHEN Others THEN
1686: l_msg_data := APP_EXCEPTION.Get_Text;
1687: FND_MESSAGE.SET_NAME('GR',
1688: 'GR_UNEXPECTED_ERROR');
1689: FND_MESSAGE.SET_TOKEN('TEXT',
1690: l_msg_data,
1691: FALSE);
1692: IF FND_API.To_Boolean(p_called_by_form) THEN
1693: APP_EXCEPTION.Raise_Exception;