DBA Data[Home] [Help]

APPS.GR_LABELS_B_PKG dependencies on APP_EXCEPTION

Line 301: APP_EXCEPTION.Raise_Exception;

297: FND_MESSAGE.SET_TOKEN('TEXT',
298: l_msg_data,
299: FALSE);
300: IF FND_API.To_Boolean(p_called_by_form) THEN
301: APP_EXCEPTION.Raise_Exception;
302: ELSE
303: x_msg_data := FND_MESSAGE.Get;
304: END IF;
305:

Line 309: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 316: APP_EXCEPTION.Raise_Exception;

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

Line 324: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 331: APP_EXCEPTION.Raise_Exception;

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

Line 347: APP_EXCEPTION.Raise_Exception;

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

Line 574: APP_EXCEPTION.Raise_Exception;

570: FND_MESSAGE.SET_TOKEN('TEXT',
571: l_msg_data,
572: FALSE);
573: IF FND_API.To_Boolean(p_called_by_form) THEN
574: APP_EXCEPTION.Raise_Exception;
575: ELSE
576: x_msg_data := FND_MESSAGE.Get;
577: END IF;
578:

Line 582: x_oracle_error := APP_EXCEPTION.Get_Code;

578:
579: WHEN Row_Missing_Error THEN
580: ROLLBACK TO SAVEPOINT Update_Row;
581: x_return_status := 'E';
582: x_oracle_error := APP_EXCEPTION.Get_Code;
583: FND_MESSAGE.SET_NAME('GR',
584: 'GR_NO_RECORD_INSERTED');
585: FND_MESSAGE.SET_TOKEN('CODE',
586: p_label_code,

Line 589: APP_EXCEPTION.Raise_Exception;

585: FND_MESSAGE.SET_TOKEN('CODE',
586: p_label_code,
587: FALSE);
588: IF FND_API.To_Boolean(p_called_by_form) THEN
589: APP_EXCEPTION.Raise_Exception;
590: ELSE
591: x_msg_data := FND_MESSAGE.Get;
592: END IF;
593:

Line 605: APP_EXCEPTION.Raise_Exception;

601: FND_MESSAGE.SET_TOKEN('TEXT',
602: l_msg_data,
603: FALSE);
604: IF FND_API.To_Boolean(p_called_by_form) THEN
605: APP_EXCEPTION.Raise_Exception;
606: ELSE
607: x_msg_data := FND_MESSAGE.Get;
608: END IF;
609:

Line 732: APP_EXCEPTION.Raise_Exception;

728: FND_MESSAGE.SET_TOKEN('CODE',
729: p_label_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 740: x_oracle_error := APP_EXCEPTION.Get_Code;

736:
737: WHEN Row_Already_Locked_Error THEN
738: ROLLBACK TO SAVEPOINT Lock_Row;
739: x_return_status := 'E';
740: x_oracle_error := APP_EXCEPTION.Get_Code;
741: FND_MESSAGE.SET_NAME('GR',
742: 'GR_ROW_IS_LOCKED');
743: IF FND_API.To_Boolean(p_called_by_form) THEN
744: APP_EXCEPTION.Raise_Exception;

Line 744: APP_EXCEPTION.Raise_Exception;

740: x_oracle_error := APP_EXCEPTION.Get_Code;
741: FND_MESSAGE.SET_NAME('GR',
742: 'GR_ROW_IS_LOCKED');
743: IF FND_API.To_Boolean(p_called_by_form) THEN
744: APP_EXCEPTION.Raise_Exception;
745: ELSE
746: x_msg_data := FND_MESSAGE.Get;
747: END IF;
748:

Line 760: APP_EXCEPTION.Raise_Exception;

756: FND_MESSAGE.SET_TOKEN('TEXT',
757: l_msg_data,
758: FALSE);
759: IF FND_API.To_Boolean(p_called_by_form) THEN
760: APP_EXCEPTION.Raise_Exception;
761: ELSE
762: x_msg_data := FND_MESSAGE.Get;
763: END IF;
764:

Line 930: APP_EXCEPTION.Raise_Exception;

926: ROLLBACK TO SAVEPOINT Delete_Row;
927: x_return_status := l_return_status;
928: x_oracle_error := l_oracle_error;
929: IF FND_API.To_Boolean(p_called_by_form) THEN
930: APP_EXCEPTION.Raise_Exception;
931: ELSE
932: x_msg_data := FND_MESSAGE.Get;
933: END IF;
934:

Line 938: x_oracle_error := APP_EXCEPTION.Get_Code;

934:
935: WHEN Row_Missing_Error THEN
936: ROLLBACK TO SAVEPOINT Delete_Row;
937: x_return_status := 'E';
938: x_oracle_error := APP_EXCEPTION.Get_Code;
939: FND_MESSAGE.SET_NAME('GR',
940: 'GR_RECORD_NOT_FOUND');
941: FND_MESSAGE.SET_TOKEN('CODE',
942: p_label_code,

Line 945: APP_EXCEPTION.Raise_Exception;

941: FND_MESSAGE.SET_TOKEN('CODE',
942: p_label_code,
943: FALSE);
944: IF FND_API.To_Boolean(p_called_by_form) THEN
945: APP_EXCEPTION.Raise_Exception;
946: ELSE
947: x_msg_data := FND_MESSAGE.Get;
948: END IF;
949:

Line 961: APP_EXCEPTION.Raise_Exception;

957: FND_MESSAGE.SET_TOKEN('TEXT',
958: l_msg_data,
959: FALSE);
960: IF FND_API.To_Boolean(p_called_by_form) THEN
961: APP_EXCEPTION.Raise_Exception;
962: ELSE
963: x_msg_data := FND_MESSAGE.Get;
964: END IF;
965:

Line 1455: APP_EXCEPTION.Raise_Exception;

1451: FND_MESSAGE.SET_TOKEN('TABLES',
1452: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
1453: FALSE);
1454: IF FND_API.To_Boolean(p_called_by_form) THEN
1455: APP_EXCEPTION.Raise_Exception;
1456: ELSE
1457: x_msg_data := FND_MESSAGE.Get;
1458: END IF;
1459:

Line 1471: APP_EXCEPTION.Raise_Exception;

1467: FND_MESSAGE.SET_TOKEN('TEXT',
1468: l_msg_data,
1469: FALSE);
1470: IF FND_API.To_Boolean(p_called_by_form) THEN
1471: APP_EXCEPTION.Raise_Exception;
1472: ELSE
1473: x_msg_data := FND_MESSAGE.Get;
1474: END IF;
1475:

Line 1527: APP_EXCEPTION.Raise_Exception;

1523: FND_MESSAGE.SET_TOKEN('TEXT',
1524: l_msg_data,
1525: FALSE);
1526: IF FND_API.To_Boolean(p_called_by_form) THEN
1527: APP_EXCEPTION.Raise_Exception;
1528: END IF;
1529:
1530: END Check_Primary_Key;
1531: