DBA Data[Home] [Help]

APPS.GR_RECIPIENT_INFO_PKG dependencies on APP_EXCEPTION

Line 299: APP_EXCEPTION.Raise_Exception;

295: FND_MESSAGE.SET_TOKEN('TEXT',
296: l_msg_data,
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:

Line 307: x_oracle_error := APP_EXCEPTION.Get_Code;

303:
304: WHEN Label_Exists_Error THEN
305: ROLLBACK TO SAVEPOINT Insert_Row;
306: x_return_status := 'E';
307: x_oracle_error := APP_EXCEPTION.Get_Code;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_RECORD_EXISTS');
310: FND_MESSAGE.SET_TOKEN('CODE',
311: p_recipient_code,

Line 314: APP_EXCEPTION.Raise_Exception;

310: FND_MESSAGE.SET_TOKEN('CODE',
311: p_recipient_code,
312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;
318:

Line 322: x_oracle_error := APP_EXCEPTION.Get_Code;

318:
319: WHEN Row_Missing_Error THEN
320: ROLLBACK TO SAVEPOINT Insert_Row;
321: x_return_status := 'E';
322: x_oracle_error := APP_EXCEPTION.Get_Code;
323: FND_MESSAGE.SET_NAME('GR',
324: 'GR_NO_RECORD_INSERTED');
325: FND_MESSAGE.SET_TOKEN('CODE',
326: p_recipient_code,

Line 329: APP_EXCEPTION.Raise_Exception;

325: FND_MESSAGE.SET_TOKEN('CODE',
326: p_recipient_code,
327: FALSE);
328: IF FND_API.To_Boolean(p_called_by_form) THEN
329: APP_EXCEPTION.Raise_Exception;
330: ELSE
331: x_msg_data := FND_MESSAGE.Get;
332: END IF;
333:

Line 337: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 338: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 345: APP_EXCEPTION.Raise_Exception;

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

Line 570: APP_EXCEPTION.Raise_Exception;

566: FND_MESSAGE.SET_TOKEN('TEXT',
567: l_msg_data,
568: FALSE);
569: IF FND_API.To_Boolean(p_called_by_form) THEN
570: APP_EXCEPTION.Raise_Exception;
571: ELSE
572: x_msg_data := FND_MESSAGE.Get;
573: END IF;
574:

Line 578: x_oracle_error := APP_EXCEPTION.Get_Code;

574:
575: WHEN Row_Missing_Error THEN
576: ROLLBACK TO SAVEPOINT Update_Row;
577: x_return_status := 'E';
578: x_oracle_error := APP_EXCEPTION.Get_Code;
579: FND_MESSAGE.SET_NAME('GR',
580: 'GR_NO_RECORD_INSERTED');
581: FND_MESSAGE.SET_TOKEN('CODE',
582: p_recipient_code,

Line 585: APP_EXCEPTION.Raise_Exception;

581: FND_MESSAGE.SET_TOKEN('CODE',
582: p_recipient_code,
583: FALSE);
584: IF FND_API.To_Boolean(p_called_by_form) THEN
585: APP_EXCEPTION.Raise_Exception;
586: ELSE
587: x_msg_data := FND_MESSAGE.Get;
588: END IF;
589:

Line 593: x_oracle_error := APP_EXCEPTION.Get_Code;

589:
590: WHEN OTHERS THEN
591: ROLLBACK TO SAVEPOINT Update_Row;
592: x_return_status := 'U';
593: x_oracle_error := APP_EXCEPTION.Get_Code;
594: l_msg_data := APP_EXCEPTION.Get_Text;
595: FND_MESSAGE.SET_NAME('GR',
596: 'GR_UNEXPECTED_ERROR');
597: FND_MESSAGE.SET_TOKEN('TEXT',

Line 594: l_msg_data := APP_EXCEPTION.Get_Text;

590: WHEN OTHERS THEN
591: ROLLBACK TO SAVEPOINT Update_Row;
592: x_return_status := 'U';
593: x_oracle_error := APP_EXCEPTION.Get_Code;
594: l_msg_data := APP_EXCEPTION.Get_Text;
595: FND_MESSAGE.SET_NAME('GR',
596: 'GR_UNEXPECTED_ERROR');
597: FND_MESSAGE.SET_TOKEN('TEXT',
598: l_msg_data,

Line 601: APP_EXCEPTION.Raise_Exception;

597: FND_MESSAGE.SET_TOKEN('TEXT',
598: l_msg_data,
599: FALSE);
600: IF FND_API.To_Boolean(p_called_by_form) THEN
601: APP_EXCEPTION.Raise_Exception;
602: ELSE
603: x_msg_data := FND_MESSAGE.Get;
604: END IF;
605:

Line 732: APP_EXCEPTION.Raise_Exception;

728: FND_MESSAGE.SET_TOKEN('CODE',
729: p_recipient_code,
730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;
733: ELSE
734: x_msg_data := FND_MESSAGE.Get;
735: END IF;
736:

Line 743: APP_EXCEPTION.Raise_Exception;

739: X_return_status := 'E';
740: FND_MESSAGE.SET_NAME('FND',
741: 'FORM_RECORD_CHANGED');
742: IF FND_API.To_Boolean(p_called_by_form) THEN
743: APP_EXCEPTION.Raise_Exception;
744: ELSE
745: x_msg_data := FND_MESSAGE.Get;
746: END IF;
747: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 747: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

743: APP_EXCEPTION.Raise_Exception;
744: ELSE
745: x_msg_data := FND_MESSAGE.Get;
746: END IF;
747: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
748: ROLLBACK TO SAVEPOINT Lock_Row;
749: x_return_status := 'L';
750: x_oracle_error := APP_EXCEPTION.Get_Code;
751: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 750: x_oracle_error := APP_EXCEPTION.Get_Code;

746: END IF;
747: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
748: ROLLBACK TO SAVEPOINT Lock_Row;
749: x_return_status := 'L';
750: x_oracle_error := APP_EXCEPTION.Get_Code;
751: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
752: FND_MESSAGE.SET_NAME('GR',
753: 'GR_ROW_IS_LOCKED');
754: x_msg_data := FND_MESSAGE.Get;

Line 760: x_oracle_error := APP_EXCEPTION.Get_Code;

756:
757: WHEN OTHERS THEN
758: ROLLBACK TO SAVEPOINT Lock_Row;
759: x_return_status := 'U';
760: x_oracle_error := APP_EXCEPTION.Get_Code;
761: l_msg_data := APP_EXCEPTION.Get_Text;
762: FND_MESSAGE.SET_NAME('GR',
763: 'GR_UNEXPECTED_ERROR');
764: FND_MESSAGE.SET_TOKEN('TEXT',

Line 761: l_msg_data := APP_EXCEPTION.Get_Text;

757: WHEN OTHERS THEN
758: ROLLBACK TO SAVEPOINT Lock_Row;
759: x_return_status := 'U';
760: x_oracle_error := APP_EXCEPTION.Get_Code;
761: l_msg_data := APP_EXCEPTION.Get_Text;
762: FND_MESSAGE.SET_NAME('GR',
763: 'GR_UNEXPECTED_ERROR');
764: FND_MESSAGE.SET_TOKEN('TEXT',
765: l_msg_data,

Line 768: APP_EXCEPTION.Raise_Exception;

764: FND_MESSAGE.SET_TOKEN('TEXT',
765: l_msg_data,
766: FALSE);
767: IF FND_API.To_Boolean(p_called_by_form) THEN
768: APP_EXCEPTION.Raise_Exception;
769: ELSE
770: x_msg_data := FND_MESSAGE.Get;
771: END IF;
772:

Line 937: APP_EXCEPTION.Raise_Exception;

933: ROLLBACK TO SAVEPOINT Delete_Row;
934: x_return_status := l_return_status;
935: x_oracle_error := l_oracle_error;
936: IF FND_API.To_Boolean(p_called_by_form) THEN
937: APP_EXCEPTION.Raise_Exception;
938: ELSE
939: x_msg_data := FND_MESSAGE.Get;
940: END IF;
941:

Line 945: x_oracle_error := APP_EXCEPTION.Get_Code;

941:
942: WHEN Row_Missing_Error THEN
943: ROLLBACK TO SAVEPOINT Delete_Row;
944: x_return_status := 'E';
945: x_oracle_error := APP_EXCEPTION.Get_Code;
946: FND_MESSAGE.SET_NAME('GR',
947: 'GR_RECORD_NOT_FOUND');
948: FND_MESSAGE.SET_TOKEN('CODE',
949: p_recipient_code,

Line 952: APP_EXCEPTION.Raise_Exception;

948: FND_MESSAGE.SET_TOKEN('CODE',
949: p_recipient_code,
950: FALSE);
951: IF FND_API.To_Boolean(p_called_by_form) THEN
952: APP_EXCEPTION.Raise_Exception;
953: ELSE
954: x_msg_data := FND_MESSAGE.Get;
955: END IF;
956:

Line 960: x_oracle_error := APP_EXCEPTION.Get_Code;

956:
957: WHEN OTHERS THEN
958: ROLLBACK TO SAVEPOINT Delete_Row;
959: x_return_status := 'U';
960: x_oracle_error := APP_EXCEPTION.Get_Code;
961: l_msg_data := APP_EXCEPTION.Get_Text;
962: l_msg_data := APP_EXCEPTION.Get_Text;
963: FND_MESSAGE.SET_NAME('GR',
964: 'GR_UNEXPECTED_ERROR');

Line 961: l_msg_data := APP_EXCEPTION.Get_Text;

957: WHEN OTHERS THEN
958: ROLLBACK TO SAVEPOINT Delete_Row;
959: x_return_status := 'U';
960: x_oracle_error := APP_EXCEPTION.Get_Code;
961: l_msg_data := APP_EXCEPTION.Get_Text;
962: l_msg_data := APP_EXCEPTION.Get_Text;
963: FND_MESSAGE.SET_NAME('GR',
964: 'GR_UNEXPECTED_ERROR');
965: FND_MESSAGE.SET_TOKEN('TEXT',

Line 962: l_msg_data := APP_EXCEPTION.Get_Text;

958: ROLLBACK TO SAVEPOINT Delete_Row;
959: x_return_status := 'U';
960: x_oracle_error := APP_EXCEPTION.Get_Code;
961: l_msg_data := APP_EXCEPTION.Get_Text;
962: l_msg_data := APP_EXCEPTION.Get_Text;
963: FND_MESSAGE.SET_NAME('GR',
964: 'GR_UNEXPECTED_ERROR');
965: FND_MESSAGE.SET_TOKEN('TEXT',
966: l_msg_data,

Line 969: APP_EXCEPTION.Raise_Exception;

965: FND_MESSAGE.SET_TOKEN('TEXT',
966: l_msg_data,
967: FALSE);
968: IF FND_API.To_Boolean(p_called_by_form) THEN
969: APP_EXCEPTION.Raise_Exception;
970: ELSE
971: x_msg_data := FND_MESSAGE.Get;
972: END IF;
973:

Line 1146: x_oracle_error := APP_EXCEPTION.Get_Code;

1142:
1143: WHEN OTHERS THEN
1144: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1145: x_return_status := 'U';
1146: x_oracle_error := APP_EXCEPTION.Get_Code;
1147: l_msg_data := APP_EXCEPTION.Get_Text;
1148: FND_MESSAGE.SET_NAME('GR',
1149: 'GR_UNEXPECTED_ERROR');
1150: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1147: l_msg_data := APP_EXCEPTION.Get_Text;

1143: WHEN OTHERS THEN
1144: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1145: x_return_status := 'U';
1146: x_oracle_error := APP_EXCEPTION.Get_Code;
1147: l_msg_data := APP_EXCEPTION.Get_Text;
1148: FND_MESSAGE.SET_NAME('GR',
1149: 'GR_UNEXPECTED_ERROR');
1150: FND_MESSAGE.SET_TOKEN('TEXT',
1151: l_msg_data,

Line 1273: x_oracle_error := APP_EXCEPTION.Get_Code;

1269:
1270: WHEN OTHERS THEN
1271: ROLLBACK TO SAVEPOINT Check_Integrity;
1272: x_return_status := 'U';
1273: x_oracle_error := APP_EXCEPTION.Get_Code;
1274: l_msg_data := APP_EXCEPTION.Get_Text;
1275: FND_MESSAGE.SET_NAME('GR',
1276: 'GR_UNEXPECTED_ERROR');
1277: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1274: l_msg_data := APP_EXCEPTION.Get_Text;

1270: WHEN OTHERS THEN
1271: ROLLBACK TO SAVEPOINT Check_Integrity;
1272: x_return_status := 'U';
1273: x_oracle_error := APP_EXCEPTION.Get_Code;
1274: l_msg_data := APP_EXCEPTION.Get_Text;
1275: FND_MESSAGE.SET_NAME('GR',
1276: 'GR_UNEXPECTED_ERROR');
1277: FND_MESSAGE.SET_TOKEN('TEXT',
1278: l_msg_data,

Line 1281: APP_EXCEPTION.Raise_Exception;

1277: FND_MESSAGE.SET_TOKEN('TEXT',
1278: l_msg_data,
1279: FALSE);
1280: IF FND_API.To_Boolean(p_called_by_form) THEN
1281: APP_EXCEPTION.Raise_Exception;
1282: ELSE
1283: x_msg_data := FND_MESSAGE.Get;
1284: END IF;
1285:

Line 1330: l_msg_data := APP_EXCEPTION.Get_Text;

1326:
1327: EXCEPTION
1328:
1329: WHEN Others THEN
1330: l_msg_data := APP_EXCEPTION.Get_Text;
1331: FND_MESSAGE.SET_NAME('GR',
1332: 'GR_UNEXPECTED_ERROR');
1333: FND_MESSAGE.SET_TOKEN('TEXT',
1334: l_msg_data,

Line 1337: APP_EXCEPTION.Raise_Exception;

1333: FND_MESSAGE.SET_TOKEN('TEXT',
1334: l_msg_data,
1335: FALSE);
1336: IF FND_API.To_Boolean(p_called_by_form) THEN
1337: APP_EXCEPTION.Raise_Exception;
1338: END IF;
1339:
1340: END Check_Primary_Key;
1341: