DBA Data[Home] [Help]

APPS.GR_PROPERTY_VALUES_TL_PKG dependencies on APP_EXCEPTION

Line 140: APP_EXCEPTION.Raise_Exception;

136: FND_MESSAGE.SET_TOKEN('TEXT',
137: l_msg_data,
138: FALSE);
139: IF FND_API.To_Boolean(p_called_by_form) THEN
140: APP_EXCEPTION.Raise_Exception;
141: ELSE
142: x_msg_data := FND_MESSAGE.Get;
143: END IF;
144:

Line 149: x_oracle_error := APP_EXCEPTION.Get_Code;

145: WHEN Item_Exists_Error THEN
146: ROLLBACK TO SAVEPOINT Insert_Row;
147: l_msg_token := p_property_id || ' ' || p_language;
148: x_return_status := 'E';
149: x_oracle_error := APP_EXCEPTION.Get_Code;
150: FND_MESSAGE.SET_NAME('GR',
151: 'GR_RECORD_EXISTS');
152: FND_MESSAGE.SET_TOKEN('CODE',
153: l_msg_token,

Line 156: APP_EXCEPTION.Raise_Exception;

152: FND_MESSAGE.SET_TOKEN('CODE',
153: l_msg_token,
154: FALSE);
155: IF FND_API.To_Boolean(p_called_by_form) THEN
156: APP_EXCEPTION.Raise_Exception;
157: ELSE
158: x_msg_data := FND_MESSAGE.Get;
159: END IF;
160:

Line 165: x_oracle_error := APP_EXCEPTION.Get_Code;

161: WHEN Row_Missing_Error THEN
162: ROLLBACK TO SAVEPOINT Insert_Row;
163: l_msg_token := p_property_id || ' ' || p_language;
164: x_return_status := 'E';
165: x_oracle_error := APP_EXCEPTION.Get_Code;
166: FND_MESSAGE.SET_NAME('GR',
167: 'GR_NO_RECORD_INSERTED');
168: FND_MESSAGE.SET_TOKEN('CODE',
169: l_msg_token,

Line 172: APP_EXCEPTION.Raise_Exception;

168: FND_MESSAGE.SET_TOKEN('CODE',
169: l_msg_token,
170: FALSE);
171: IF FND_API.To_Boolean(p_called_by_form) THEN
172: APP_EXCEPTION.Raise_Exception;
173: ELSE
174: x_msg_data := FND_MESSAGE.Get;
175: END IF;
176:

Line 189: APP_EXCEPTION.Raise_Exception;

185: FND_MESSAGE.SET_TOKEN('TEXT',
186: l_msg_token,
187: FALSE);
188: IF FND_API.To_Boolean(p_called_by_form) THEN
189: APP_EXCEPTION.Raise_Exception;
190: ELSE
191: x_msg_data := FND_MESSAGE.Get;
192: END IF;
193:

Line 293: APP_EXCEPTION.Raise_Exception;

289: FND_MESSAGE.SET_TOKEN('TEXT',
290: l_msg_data,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;
294: ELSE
295: x_msg_data := FND_MESSAGE.Get;
296: END IF;
297:

Line 301: x_oracle_error := APP_EXCEPTION.Get_Code;

297:
298: WHEN Row_Missing_Error THEN
299: ROLLBACK TO SAVEPOINT Update_Row;
300: x_return_status := 'E';
301: x_oracle_error := APP_EXCEPTION.Get_Code;
302: FND_MESSAGE.SET_NAME('GR',
303: 'GR_NO_RECORD_INSERTED');
304: FND_MESSAGE.SET_TOKEN('CODE',
305: l_msg_token,

Line 308: APP_EXCEPTION.Raise_Exception;

304: FND_MESSAGE.SET_TOKEN('CODE',
305: l_msg_token,
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 324: APP_EXCEPTION.Raise_Exception;

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

Line 525: x_oracle_error := APP_EXCEPTION.Get_Code;

521:
522: WHEN Language_Missing_Error THEN
523: ROLLBACK TO SAVEPOINT Add_Language;
524: x_return_status := 'E';
525: x_oracle_error := APP_EXCEPTION.Get_Code;
526: FND_MESSAGE.SET_NAME('GR',
527: 'GR_RECORD_NOT_FOUND');
528: FND_MESSAGE.SET_TOKEN('CODE',
529: l_msg_token,

Line 532: APP_EXCEPTION.Raise_Exception;

528: FND_MESSAGE.SET_TOKEN('CODE',
529: l_msg_token,
530: FALSE);
531: IF FND_API.To_Boolean(p_called_by_form) THEN
532: APP_EXCEPTION.Raise_Exception;
533: ELSE
534: x_msg_data := FND_MESSAGE.Get;
535: END IF;
536:

Line 548: APP_EXCEPTION.Raise_Exception;

544: FND_MESSAGE.SET_TOKEN('TEXT',
545: l_msg_token,
546: FALSE);
547: IF FND_API.To_Boolean(p_called_by_form) THEN
548: APP_EXCEPTION.Raise_Exception;
549: ELSE
550: x_msg_data := FND_MESSAGE.Get;
551: END IF;
552:

Line 635: APP_EXCEPTION.Raise_Exception;

631: FND_MESSAGE.SET_TOKEN('CODE',
632: l_msg_token,
633: FALSE);
634: IF FND_API.To_Boolean(p_called_by_form) THEN
635: APP_EXCEPTION.Raise_Exception;
636: ELSE
637: x_msg_data := FND_MESSAGE.Get;
638: END IF;
639:

Line 643: x_oracle_error := APP_EXCEPTION.Get_Code;

639:
640: WHEN Row_Already_Locked_Error THEN
641: ROLLBACK TO SAVEPOINT Lock_Row;
642: x_return_status := 'E';
643: x_oracle_error := APP_EXCEPTION.Get_Code;
644: FND_MESSAGE.SET_NAME('GR',
645: 'GR_ROW_IS_LOCKED');
646: IF FND_API.To_Boolean(p_called_by_form) THEN
647: APP_EXCEPTION.Raise_Exception;

Line 647: APP_EXCEPTION.Raise_Exception;

643: x_oracle_error := APP_EXCEPTION.Get_Code;
644: FND_MESSAGE.SET_NAME('GR',
645: 'GR_ROW_IS_LOCKED');
646: IF FND_API.To_Boolean(p_called_by_form) THEN
647: APP_EXCEPTION.Raise_Exception;
648: ELSE
649: x_msg_data := FND_MESSAGE.Get;
650: END IF;
651:

Line 663: APP_EXCEPTION.Raise_Exception;

659: FND_MESSAGE.SET_TOKEN('TEXT',
660: l_msg_token,
661: FALSE);
662: IF FND_API.To_Boolean(p_called_by_form) THEN
663: APP_EXCEPTION.Raise_Exception;
664: ELSE
665: x_msg_data := FND_MESSAGE.Get;
666: END IF;
667:

Line 754: APP_EXCEPTION.Raise_Exception;

750: ROLLBACK TO SAVEPOINT Delete_Row;
751: x_return_status := l_return_status;
752: x_oracle_error := l_oracle_error;
753: IF FND_API.To_Boolean(p_called_by_form) THEN
754: APP_EXCEPTION.Raise_Exception;
755: ELSE
756: x_msg_data := FND_MESSAGE.Get;
757: END IF;
758:

Line 762: x_oracle_error := APP_EXCEPTION.Get_Code;

758:
759: WHEN Row_Missing_Error THEN
760: ROLLBACK TO SAVEPOINT Delete_Row;
761: x_return_status := 'E';
762: x_oracle_error := APP_EXCEPTION.Get_Code;
763: FND_MESSAGE.SET_NAME('GR',
764: 'GR_RECORD_NOT_FOUND');
765: FND_MESSAGE.SET_TOKEN('CODE',
766: l_msg_token,

Line 769: APP_EXCEPTION.Raise_Exception;

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

Line 785: APP_EXCEPTION.Raise_Exception;

781: FND_MESSAGE.SET_TOKEN('TEXT',
782: l_msg_token,
783: FALSE);
784: IF FND_API.To_Boolean(p_called_by_form) THEN
785: APP_EXCEPTION.Raise_Exception;
786: ELSE
787: x_msg_data := FND_MESSAGE.Get;
788: END IF;
789:

Line 843: APP_EXCEPTION.Raise_Exception;

839: FND_MESSAGE.SET_TOKEN('TEXT',
840: l_msg_token,
841: FALSE);
842: IF FND_API.To_Boolean(p_called_by_form) THEN
843: APP_EXCEPTION.Raise_Exception;
844: ELSE
845: x_msg_data := FND_MESSAGE.Get;
846: END IF;
847:

Line 900: x_oracle_error := APP_EXCEPTION.Get_Code;

896: FETCH c_get_language INTO LangRecord;
897: IF c_get_language%NOTFOUND THEN
898: l_msg_token := l_language_code;
899: x_return_status := 'E';
900: x_oracle_error := APP_EXCEPTION.Get_Code;
901: FND_MESSAGE.SET_NAME('GR',
902: 'GR_RECORD_NOT_FOUND');
903: FND_MESSAGE.SET_TOKEN('CODE',
904: l_msg_token,

Line 916: x_oracle_error := APP_EXCEPTION.Get_Code;

912: FETCH c_get_language INTO LangRecord;
913: IF c_get_language%NOTFOUND THEN
914: l_msg_token := l_language_code;
915: x_return_status := 'E';
916: x_oracle_error := APP_EXCEPTION.Get_Code;
917: FND_MESSAGE.SET_NAME('GR',
918: 'GR_RECORD_NOT_FOUND');
919: FND_MESSAGE.SET_TOKEN('CODE',
920: l_msg_token,

Line 1012: APP_EXCEPTION.Raise_Exception;

1008: FND_MESSAGE.SET_TOKEN('CODE',
1009: p_language,
1010: FALSE);
1011: IF FND_API.To_Boolean(p_called_by_form) THEN
1012: APP_EXCEPTION.Raise_Exception;
1013: ELSE
1014: x_msg_data := FND_MESSAGE.Get;
1015: END IF;
1016:

Line 1028: APP_EXCEPTION.Raise_Exception;

1024: FND_MESSAGE.SET_TOKEN('TEXT',
1025: l_msg_data,
1026: FALSE);
1027: IF FND_API.To_Boolean(p_called_by_form) THEN
1028: APP_EXCEPTION.Raise_Exception;
1029: ELSE
1030: x_msg_data := FND_MESSAGE.Get;
1031: END IF;
1032:

Line 1090: APP_EXCEPTION.Raise_Exception;

1086: FND_MESSAGE.SET_TOKEN('TEXT',
1087: l_msg_data,
1088: FALSE);
1089: IF FND_API.To_Boolean(p_called_by_form) THEN
1090: APP_EXCEPTION.Raise_Exception;
1091: END IF;
1092:
1093: END Check_Primary_Key;
1094: