DBA Data[Home] [Help]

APPS.GR_TOXIC_SPECIES_TL_PKG dependencies on APP_EXCEPTION

Line 131: APP_EXCEPTION.Raise_Exception;

127: FND_MESSAGE.SET_TOKEN('TEXT',
128: l_msg_data,
129: FALSE);
130: IF FND_API.To_Boolean(p_called_by_form) THEN
131: APP_EXCEPTION.Raise_Exception;
132: ELSE
133: x_msg_data := FND_MESSAGE.Get;
134: END IF;
135:

Line 140: x_oracle_error := APP_EXCEPTION.Get_Code;

136: WHEN Item_Exists_Error THEN
137: ROLLBACK TO SAVEPOINT Insert_Row;
138: l_msg_token := p_toxic_species_code || ' ' || p_language;
139: x_return_status := 'E';
140: x_oracle_error := APP_EXCEPTION.Get_Code;
141: FND_MESSAGE.SET_NAME('GR',
142: 'GR_RECORD_EXISTS');
143: FND_MESSAGE.SET_TOKEN('CODE',
144: l_msg_token,

Line 147: APP_EXCEPTION.Raise_Exception;

143: FND_MESSAGE.SET_TOKEN('CODE',
144: l_msg_token,
145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;
148: ELSE
149: x_msg_data := FND_MESSAGE.Get;
150: END IF;
151:

Line 156: x_oracle_error := APP_EXCEPTION.Get_Code;

152: WHEN Row_Missing_Error THEN
153: ROLLBACK TO SAVEPOINT Insert_Row;
154: l_msg_token := p_toxic_species_code || ' ' || p_language;
155: x_return_status := 'E';
156: x_oracle_error := APP_EXCEPTION.Get_Code;
157: FND_MESSAGE.SET_NAME('GR',
158: 'GR_NO_RECORD_INSERTED');
159: FND_MESSAGE.SET_TOKEN('CODE',
160: l_msg_token,

Line 163: APP_EXCEPTION.Raise_Exception;

159: FND_MESSAGE.SET_TOKEN('CODE',
160: l_msg_token,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;
164: ELSE
165: x_msg_data := FND_MESSAGE.Get;
166: END IF;
167:

Line 180: APP_EXCEPTION.Raise_Exception;

176: FND_MESSAGE.SET_TOKEN('TEXT',
177: l_msg_token,
178: FALSE);
179: IF FND_API.To_Boolean(p_called_by_form) THEN
180: APP_EXCEPTION.Raise_Exception;
181: ELSE
182: x_msg_data := FND_MESSAGE.Get;
183: END IF;
184:

Line 278: APP_EXCEPTION.Raise_Exception;

274: FND_MESSAGE.SET_TOKEN('TEXT',
275: l_msg_data,
276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;
279: ELSE
280: x_msg_data := FND_MESSAGE.Get;
281: END IF;
282:

Line 286: x_oracle_error := APP_EXCEPTION.Get_Code;

282:
283: WHEN Row_Missing_Error THEN
284: ROLLBACK TO SAVEPOINT Update_Row;
285: x_return_status := 'E';
286: x_oracle_error := APP_EXCEPTION.Get_Code;
287: FND_MESSAGE.SET_NAME('GR',
288: 'GR_NO_RECORD_INSERTED');
289: FND_MESSAGE.SET_TOKEN('CODE',
290: l_msg_token,

Line 293: APP_EXCEPTION.Raise_Exception;

289: FND_MESSAGE.SET_TOKEN('CODE',
290: l_msg_token,
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 309: APP_EXCEPTION.Raise_Exception;

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;
310: ELSE
311: x_msg_data := FND_MESSAGE.Get;
312: END IF;
313:

Line 484: x_oracle_error := APP_EXCEPTION.Get_Code;

480:
481: WHEN Language_Missing_Error THEN
482: ROLLBACK TO SAVEPOINT Add_Language;
483: x_return_status := 'E';
484: x_oracle_error := APP_EXCEPTION.Get_Code;
485: FND_MESSAGE.SET_NAME('GR',
486: 'GR_RECORD_NOT_FOUND');
487: FND_MESSAGE.SET_TOKEN('CODE',
488: l_msg_token,

Line 491: APP_EXCEPTION.Raise_Exception;

487: FND_MESSAGE.SET_TOKEN('CODE',
488: l_msg_token,
489: FALSE);
490: IF FND_API.To_Boolean(p_called_by_form) THEN
491: APP_EXCEPTION.Raise_Exception;
492: ELSE
493: x_msg_data := FND_MESSAGE.Get;
494: END IF;
495:

Line 507: APP_EXCEPTION.Raise_Exception;

503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_token,
505: FALSE);
506: IF FND_API.To_Boolean(p_called_by_form) THEN
507: APP_EXCEPTION.Raise_Exception;
508: ELSE
509: x_msg_data := FND_MESSAGE.Get;
510: END IF;
511:

Line 597: APP_EXCEPTION.Raise_Exception;

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

Line 608: APP_EXCEPTION.Raise_Exception;

604: X_return_status := 'E';
605: FND_MESSAGE.SET_NAME('FND',
606: 'FORM_RECORD_CHANGED');
607: IF FND_API.To_Boolean(p_called_by_form) THEN
608: APP_EXCEPTION.Raise_Exception;
609: ELSE
610: x_msg_data := FND_MESSAGE.Get;
611: END IF;
612: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 612: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

608: APP_EXCEPTION.Raise_Exception;
609: ELSE
610: x_msg_data := FND_MESSAGE.Get;
611: END IF;
612: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
613: ROLLBACK TO SAVEPOINT Lock_Row;
614: x_return_status := 'L';
615: x_oracle_error := APP_EXCEPTION.Get_Code;
616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 615: x_oracle_error := APP_EXCEPTION.Get_Code;

611: END IF;
612: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
613: ROLLBACK TO SAVEPOINT Lock_Row;
614: x_return_status := 'L';
615: x_oracle_error := APP_EXCEPTION.Get_Code;
616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
617: FND_MESSAGE.SET_NAME('GR',
618: 'GR_ROW_IS_LOCKED');
619: x_msg_data := FND_MESSAGE.Get;

Line 633: APP_EXCEPTION.Raise_Exception;

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

Line 720: APP_EXCEPTION.Raise_Exception;

716: ROLLBACK TO SAVEPOINT Delete_Row;
717: x_return_status := l_return_status;
718: x_oracle_error := l_oracle_error;
719: IF FND_API.To_Boolean(p_called_by_form) THEN
720: APP_EXCEPTION.Raise_Exception;
721: ELSE
722: x_msg_data := FND_MESSAGE.Get;
723: END IF;
724:

Line 728: x_oracle_error := APP_EXCEPTION.Get_Code;

724:
725: WHEN Row_Missing_Error THEN
726: ROLLBACK TO SAVEPOINT Delete_Row;
727: x_return_status := 'E';
728: x_oracle_error := APP_EXCEPTION.Get_Code;
729: FND_MESSAGE.SET_NAME('GR',
730: 'GR_RECORD_NOT_FOUND');
731: FND_MESSAGE.SET_TOKEN('CODE',
732: l_msg_token,

Line 735: APP_EXCEPTION.Raise_Exception;

731: FND_MESSAGE.SET_TOKEN('CODE',
732: l_msg_token,
733: FALSE);
734: IF FND_API.To_Boolean(p_called_by_form) THEN
735: APP_EXCEPTION.Raise_Exception;
736: ELSE
737: x_msg_data := FND_MESSAGE.Get;
738: END IF;
739:

Line 751: APP_EXCEPTION.Raise_Exception;

747: FND_MESSAGE.SET_TOKEN('TEXT',
748: l_msg_token,
749: FALSE);
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 809: APP_EXCEPTION.Raise_Exception;

805: FND_MESSAGE.SET_TOKEN('TEXT',
806: l_msg_token,
807: FALSE);
808: IF FND_API.To_Boolean(p_called_by_form) THEN
809: APP_EXCEPTION.Raise_Exception;
810: ELSE
811: x_msg_data := FND_MESSAGE.Get;
812: END IF;
813:

Line 864: x_oracle_error := APP_EXCEPTION.Get_Code;

860: FETCH c_get_language INTO LangRecord;
861: IF c_get_language%NOTFOUND THEN
862: l_msg_token := l_language_code;
863: x_return_status := 'E';
864: x_oracle_error := APP_EXCEPTION.Get_Code;
865: FND_MESSAGE.SET_NAME('GR',
866: 'GR_RECORD_NOT_FOUND');
867: FND_MESSAGE.SET_TOKEN('CODE',
868: l_msg_token,

Line 880: x_oracle_error := APP_EXCEPTION.Get_Code;

876: FETCH c_get_language INTO LangRecord;
877: IF c_get_language%NOTFOUND THEN
878: l_msg_token := l_language_code;
879: x_return_status := 'E';
880: x_oracle_error := APP_EXCEPTION.Get_Code;
881: FND_MESSAGE.SET_NAME('GR',
882: 'GR_RECORD_NOT_FOUND');
883: FND_MESSAGE.SET_TOKEN('CODE',
884: l_msg_token,

Line 976: APP_EXCEPTION.Raise_Exception;

972: FND_MESSAGE.SET_TOKEN('CODE',
973: p_language,
974: FALSE);
975: IF FND_API.To_Boolean(p_called_by_form) THEN
976: APP_EXCEPTION.Raise_Exception;
977: ELSE
978: x_msg_data := FND_MESSAGE.Get;
979: END IF;
980:

Line 992: APP_EXCEPTION.Raise_Exception;

988: FND_MESSAGE.SET_TOKEN('TEXT',
989: l_msg_data,
990: FALSE);
991: IF FND_API.To_Boolean(p_called_by_form) THEN
992: APP_EXCEPTION.Raise_Exception;
993: ELSE
994: x_msg_data := FND_MESSAGE.Get;
995: END IF;
996:

Line 1052: APP_EXCEPTION.Raise_Exception;

1048: FND_MESSAGE.SET_TOKEN('TEXT',
1049: l_msg_data,
1050: FALSE);
1051: IF FND_API.To_Boolean(p_called_by_form) THEN
1052: APP_EXCEPTION.Raise_Exception;
1053: END IF;
1054:
1055: END Check_Primary_Key;
1056: