DBA Data[Home] [Help]

APPS.GR_LABELS_B_PKG dependencies on APP_EXCEPTION

Line 308: APP_EXCEPTION.Raise_Exception;

304: FND_MESSAGE.SET_TOKEN('TEXT',
305: l_msg_data,
306: FALSE);
307: IF FND_API.To_Boolean(p_called_by_form) THEN
308: APP_EXCEPTION.Raise_Exception;
309: ELSE
310: x_msg_data := FND_MESSAGE.Get;
311: END IF;
312:

Line 316: x_oracle_error := APP_EXCEPTION.Get_Code;

312:
313: WHEN Label_Exists_Error THEN
314: ROLLBACK TO SAVEPOINT Insert_Row;
315: x_return_status := 'E';
316: x_oracle_error := APP_EXCEPTION.Get_Code;
317: FND_MESSAGE.SET_NAME('GR',
318: 'GR_RECORD_EXISTS');
319: FND_MESSAGE.SET_TOKEN('CODE',
320: p_label_code,

Line 323: APP_EXCEPTION.Raise_Exception;

319: FND_MESSAGE.SET_TOKEN('CODE',
320: p_label_code,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;
327:

Line 331: x_oracle_error := APP_EXCEPTION.Get_Code;

327:
328: WHEN Row_Missing_Error THEN
329: ROLLBACK TO SAVEPOINT Insert_Row;
330: x_return_status := 'P'; -- PAL
331: x_oracle_error := APP_EXCEPTION.Get_Code;
332: FND_MESSAGE.SET_NAME('GR',
333: 'GR_NO_RECORD_INSERTED');
334: FND_MESSAGE.SET_TOKEN('CODE',
335: p_label_code,

Line 338: APP_EXCEPTION.Raise_Exception;

334: FND_MESSAGE.SET_TOKEN('CODE',
335: p_label_code,
336: FALSE);
337: IF FND_API.To_Boolean(p_called_by_form) THEN
338: APP_EXCEPTION.Raise_Exception;
339: ELSE
340: x_msg_data := FND_MESSAGE.Get;
341: END IF;
342:

Line 354: APP_EXCEPTION.Raise_Exception;

350: FND_MESSAGE.SET_TOKEN('TEXT',
351: l_msg_data,
352: FALSE);
353: IF FND_API.To_Boolean(p_called_by_form) THEN
354: APP_EXCEPTION.Raise_Exception;
355: ELSE
356: x_msg_data := FND_MESSAGE.Get;
357: END IF;
358:

Line 581: APP_EXCEPTION.Raise_Exception;

577: FND_MESSAGE.SET_TOKEN('TEXT',
578: l_msg_data,
579: FALSE);
580: IF FND_API.To_Boolean(p_called_by_form) THEN
581: APP_EXCEPTION.Raise_Exception;
582: ELSE
583: x_msg_data := FND_MESSAGE.Get;
584: END IF;
585:

Line 589: x_oracle_error := APP_EXCEPTION.Get_Code;

585:
586: WHEN Row_Missing_Error THEN
587: ROLLBACK TO SAVEPOINT Update_Row;
588: x_return_status := 'E';
589: x_oracle_error := APP_EXCEPTION.Get_Code;
590: FND_MESSAGE.SET_NAME('GR',
591: 'GR_NO_RECORD_INSERTED');
592: FND_MESSAGE.SET_TOKEN('CODE',
593: p_label_code,

Line 596: APP_EXCEPTION.Raise_Exception;

592: FND_MESSAGE.SET_TOKEN('CODE',
593: p_label_code,
594: FALSE);
595: IF FND_API.To_Boolean(p_called_by_form) THEN
596: APP_EXCEPTION.Raise_Exception;
597: ELSE
598: x_msg_data := FND_MESSAGE.Get;
599: END IF;
600:

Line 612: APP_EXCEPTION.Raise_Exception;

608: FND_MESSAGE.SET_TOKEN('TEXT',
609: l_msg_data,
610: FALSE);
611: IF FND_API.To_Boolean(p_called_by_form) THEN
612: APP_EXCEPTION.Raise_Exception;
613: ELSE
614: x_msg_data := FND_MESSAGE.Get;
615: END IF;
616:

Line 739: APP_EXCEPTION.Raise_Exception;

735: FND_MESSAGE.SET_TOKEN('CODE',
736: p_label_code,
737: FALSE);
738: IF FND_API.To_Boolean(p_called_by_form) THEN
739: APP_EXCEPTION.Raise_Exception;
740: ELSE
741: x_msg_data := FND_MESSAGE.Get;
742: END IF;
743:

Line 747: x_oracle_error := APP_EXCEPTION.Get_Code;

743:
744: WHEN Row_Already_Locked_Error THEN
745: ROLLBACK TO SAVEPOINT Lock_Row;
746: x_return_status := 'E';
747: x_oracle_error := APP_EXCEPTION.Get_Code;
748: FND_MESSAGE.SET_NAME('GR',
749: 'GR_ROW_IS_LOCKED');
750: IF FND_API.To_Boolean(p_called_by_form) THEN
751: APP_EXCEPTION.Raise_Exception;

Line 751: APP_EXCEPTION.Raise_Exception;

747: x_oracle_error := APP_EXCEPTION.Get_Code;
748: FND_MESSAGE.SET_NAME('GR',
749: 'GR_ROW_IS_LOCKED');
750: IF FND_API.To_Boolean(p_called_by_form) THEN
751: APP_EXCEPTION.Raise_Exception;
752: ELSE
753: x_msg_data := FND_MESSAGE.Get;
754: END IF;
755:

Line 767: APP_EXCEPTION.Raise_Exception;

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

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_label_code,

Line 952: APP_EXCEPTION.Raise_Exception;

948: FND_MESSAGE.SET_TOKEN('CODE',
949: p_label_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 968: APP_EXCEPTION.Raise_Exception;

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

Line 1462: APP_EXCEPTION.Raise_Exception;

1458: FND_MESSAGE.SET_TOKEN('TABLES',
1459: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
1460: FALSE);
1461: IF FND_API.To_Boolean(p_called_by_form) THEN
1462: APP_EXCEPTION.Raise_Exception;
1463: ELSE
1464: x_msg_data := FND_MESSAGE.Get;
1465: END IF;
1466:

Line 1478: APP_EXCEPTION.Raise_Exception;

1474: FND_MESSAGE.SET_TOKEN('TEXT',
1475: l_msg_data,
1476: FALSE);
1477: IF FND_API.To_Boolean(p_called_by_form) THEN
1478: APP_EXCEPTION.Raise_Exception;
1479: ELSE
1480: x_msg_data := FND_MESSAGE.Get;
1481: END IF;
1482:

Line 1536: APP_EXCEPTION.Raise_Exception;

1532: FND_MESSAGE.SET_TOKEN('TEXT',
1533: l_msg_data,
1534: FALSE);
1535: IF FND_API.To_Boolean(p_called_by_form) THEN
1536: APP_EXCEPTION.Raise_Exception;
1537: END IF;
1538:
1539: END Check_Primary_Key;
1540: