DBA Data[Home] [Help]

APPS.GR_EIN_NUMBERS_B_PKG dependencies on APP_EXCEPTION

Line 126: APP_EXCEPTION.Raise_Exception;

122: FND_MESSAGE.SET_TOKEN('TEXT',
123: l_msg_data,
124: FALSE);
125: IF FND_API.To_Boolean(p_called_by_form) THEN
126: APP_EXCEPTION.Raise_Exception;
127: ELSE
128: x_msg_data := FND_MESSAGE.Get;
129: END IF;
130:

Line 134: x_oracle_error := APP_EXCEPTION.Get_Code;

130:
131: WHEN Item_Exists_Error THEN
132: ROLLBACK TO SAVEPOINT Insert_Row;
133: x_return_status := 'E';
134: x_oracle_error := APP_EXCEPTION.Get_Code;
135: FND_MESSAGE.SET_NAME('GR',
136: 'GR_RECORD_EXISTS');
137: FND_MESSAGE.SET_TOKEN('CODE',
138: p_european_index_number,

Line 141: APP_EXCEPTION.Raise_Exception;

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

Line 149: x_oracle_error := APP_EXCEPTION.Get_Code;

145:
146: WHEN Row_Missing_Error THEN
147: ROLLBACK TO SAVEPOINT Insert_Row;
148: x_return_status := 'E';
149: x_oracle_error := APP_EXCEPTION.Get_Code;
150: FND_MESSAGE.SET_NAME('GR',
151: 'GR_NO_RECORD_INSERTED');
152: FND_MESSAGE.SET_TOKEN('CODE',
153: p_european_index_number,

Line 157: APP_EXCEPTION.Raise_Exception;

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

Line 173: APP_EXCEPTION.Raise_Exception;

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

Line 267: APP_EXCEPTION.Raise_Exception;

263: FND_MESSAGE.SET_TOKEN('TEXT',
264: l_msg_data,
265: FALSE);
266: IF FND_API.To_Boolean(p_called_by_form) THEN
267: APP_EXCEPTION.Raise_Exception;
268: ELSE
269: x_msg_data := FND_MESSAGE.Get;
270: END IF;
271:

Line 275: x_oracle_error := APP_EXCEPTION.Get_Code;

271:
272: WHEN Row_Missing_Error THEN
273: ROLLBACK TO SAVEPOINT Update_Row;
274: x_return_status := 'E';
275: x_oracle_error := APP_EXCEPTION.Get_Code;
276: FND_MESSAGE.SET_NAME('GR',
277: 'GR_NO_RECORD_INSERTED');
278: FND_MESSAGE.SET_TOKEN('CODE',
279: p_european_index_number,

Line 282: APP_EXCEPTION.Raise_Exception;

278: FND_MESSAGE.SET_TOKEN('CODE',
279: p_european_index_number,
280: FALSE);
281: IF FND_API.To_Boolean(p_called_by_form) THEN
282: APP_EXCEPTION.Raise_Exception;
283: ELSE
284: x_msg_data := FND_MESSAGE.Get;
285: END IF;
286:

Line 298: APP_EXCEPTION.Raise_Exception;

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

Line 385: APP_EXCEPTION.Raise_Exception;

381: FND_MESSAGE.SET_TOKEN('CODE',
382: p_european_index_number,
383: FALSE);
384: IF FND_API.To_Boolean(p_called_by_form) THEN
385: APP_EXCEPTION.Raise_Exception;
386: ELSE
387: x_msg_data := FND_MESSAGE.Get;
388: END IF;
389: WHEN RECORD_CHANGED_ERROR THEN

Line 395: APP_EXCEPTION.Raise_Exception;

391: X_return_status := 'E';
392: FND_MESSAGE.SET_NAME('FND',
393: 'FORM_RECORD_CHANGED');
394: IF FND_API.To_Boolean(p_called_by_form) THEN
395: APP_EXCEPTION.Raise_Exception;
396: ELSE
397: x_msg_data := FND_MESSAGE.Get;
398: END IF;
399: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 399: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

395: APP_EXCEPTION.Raise_Exception;
396: ELSE
397: x_msg_data := FND_MESSAGE.Get;
398: END IF;
399: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
400: ROLLBACK TO SAVEPOINT Lock_Row;
401: x_return_status := 'L';
402: x_oracle_error := APP_EXCEPTION.Get_Code;
403: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 402: x_oracle_error := APP_EXCEPTION.Get_Code;

398: END IF;
399: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
400: ROLLBACK TO SAVEPOINT Lock_Row;
401: x_return_status := 'L';
402: x_oracle_error := APP_EXCEPTION.Get_Code;
403: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
404: FND_MESSAGE.SET_NAME('GR',
405: 'GR_ROW_IS_LOCKED');
406: x_msg_data := FND_MESSAGE.Get;

Line 419: APP_EXCEPTION.Raise_Exception;

415: FND_MESSAGE.SET_TOKEN('TEXT',
416: l_msg_data,
417: FALSE);
418: IF FND_API.To_Boolean(p_called_by_form) THEN
419: APP_EXCEPTION.Raise_Exception;
420: ELSE
421: x_msg_data := FND_MESSAGE.Get;
422: END IF;
423:

Line 488: APP_EXCEPTION.Raise_Exception;

484: ROLLBACK TO SAVEPOINT Delete_Row;
485: x_return_status := l_return_status;
486: x_oracle_error := l_oracle_error;
487: IF FND_API.To_Boolean(p_called_by_form) THEN
488: APP_EXCEPTION.Raise_Exception;
489: ELSE
490: x_msg_data := FND_MESSAGE.Get;
491: END IF;
492:

Line 496: x_oracle_error := APP_EXCEPTION.Get_Code;

492:
493: WHEN Row_Missing_Error THEN
494: ROLLBACK TO SAVEPOINT Delete_Row;
495: x_return_status := 'E';
496: x_oracle_error := APP_EXCEPTION.Get_Code;
497: FND_MESSAGE.SET_NAME('GR',
498: 'GR_RECORD_NOT_FOUND');
499: FND_MESSAGE.SET_TOKEN('CODE',
500: p_european_index_number,

Line 503: APP_EXCEPTION.Raise_Exception;

499: FND_MESSAGE.SET_TOKEN('CODE',
500: p_european_index_number,
501: FALSE);
502: IF FND_API.To_Boolean(p_called_by_form) THEN
503: APP_EXCEPTION.Raise_Exception;
504: ELSE
505: x_msg_data := FND_MESSAGE.Get;
506: END IF;
507:

Line 519: APP_EXCEPTION.Raise_Exception;

515: FND_MESSAGE.SET_TOKEN('TEXT',
516: l_msg_data,
517: FALSE);
518: IF FND_API.To_Boolean(p_called_by_form) THEN
519: APP_EXCEPTION.Raise_Exception;
520: ELSE
521: x_msg_data := FND_MESSAGE.Get;
522: END IF;
523:

Line 638: APP_EXCEPTION.Raise_Exception;

634: FND_MESSAGE.SET_TOKEN('TABLES',
635: l_msg_data,
636: FALSE);
637: IF FND_API.To_Boolean(p_called_by_form) THEN
638: APP_EXCEPTION.Raise_Exception;
639: ELSE
640: x_msg_data := FND_MESSAGE.Get;
641: END IF;
642: WHEN OTHERS THEN

Line 653: APP_EXCEPTION.Raise_Exception;

649: FND_MESSAGE.SET_TOKEN('TEXT',
650: l_msg_data,
651: FALSE);
652: IF FND_API.To_Boolean(p_called_by_form) THEN
653: APP_EXCEPTION.Raise_Exception;
654: ELSE
655: x_msg_data := FND_MESSAGE.Get;
656: END IF;
657:

Line 700: APP_EXCEPTION.Raise_Exception;

696: FND_MESSAGE.SET_TOKEN('TEXT',
697: l_msg_data,
698: FALSE);
699: IF FND_API.To_Boolean(p_called_by_form) THEN
700: APP_EXCEPTION.Raise_Exception;
701: END IF;
702:
703: END Check_Primary_Key;
704: