DBA Data[Home] [Help]

APPS.GR_RISK_COMBINATIONS_PKG dependencies on APP_EXCEPTION

Line 139: APP_EXCEPTION.Raise_Exception;

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

Line 147: x_oracle_error := APP_EXCEPTION.Get_Code;

143:
144: WHEN Item_Exists_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;
146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_risk_phrase_code,

Line 154: APP_EXCEPTION.Raise_Exception;

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

Line 162: x_oracle_error := APP_EXCEPTION.Get_Code;

158:
159: WHEN Row_Missing_Error THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_risk_phrase_code,

Line 169: APP_EXCEPTION.Raise_Exception;

165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_risk_phrase_code,
167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;
170: ELSE
171: x_msg_data := FND_MESSAGE.Get;
172: END IF;
173:

Line 177: x_oracle_error := APP_EXCEPTION.Get_Code;

173:
174: WHEN OTHERS THEN
175: ROLLBACK TO SAVEPOINT Insert_Row;
176: x_return_status := 'U';
177: x_oracle_error := APP_EXCEPTION.Get_Code;
178: l_msg_data := APP_EXCEPTION.Get_Text;
179: FND_MESSAGE.SET_NAME('GR',
180: 'GR_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('TEXT',

Line 178: l_msg_data := APP_EXCEPTION.Get_Text;

174: WHEN OTHERS THEN
175: ROLLBACK TO SAVEPOINT Insert_Row;
176: x_return_status := 'U';
177: x_oracle_error := APP_EXCEPTION.Get_Code;
178: l_msg_data := APP_EXCEPTION.Get_Text;
179: FND_MESSAGE.SET_NAME('GR',
180: 'GR_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('TEXT',
182: l_msg_data,

Line 185: APP_EXCEPTION.Raise_Exception;

181: FND_MESSAGE.SET_TOKEN('TEXT',
182: l_msg_data,
183: FALSE);
184: IF FND_API.To_Boolean(p_called_by_form) THEN
185: APP_EXCEPTION.Raise_Exception;
186: ELSE
187: x_msg_data := FND_MESSAGE.Get;
188: END IF;
189:

Line 283: APP_EXCEPTION.Raise_Exception;

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

Line 291: x_oracle_error := APP_EXCEPTION.Get_Code;

287:
288: WHEN Row_Missing_Error THEN
289: ROLLBACK TO SAVEPOINT Update_Row;
290: x_return_status := 'E';
291: x_oracle_error := APP_EXCEPTION.Get_Code;
292: FND_MESSAGE.SET_NAME('GR',
293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_risk_phrase_code,

Line 298: APP_EXCEPTION.Raise_Exception;

294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_risk_phrase_code,
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 306: x_oracle_error := APP_EXCEPTION.Get_Code;

302:
303: WHEN OTHERS THEN
304: ROLLBACK TO SAVEPOINT Update_Row;
305: x_return_status := 'U';
306: x_oracle_error := APP_EXCEPTION.Get_Code;
307: l_msg_data := APP_EXCEPTION.Get_Text;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',

Line 307: l_msg_data := APP_EXCEPTION.Get_Text;

303: WHEN OTHERS THEN
304: ROLLBACK TO SAVEPOINT Update_Row;
305: x_return_status := 'U';
306: x_oracle_error := APP_EXCEPTION.Get_Code;
307: l_msg_data := APP_EXCEPTION.Get_Text;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,

Line 314: APP_EXCEPTION.Raise_Exception;

310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,
312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;
318:

Line 398: APP_EXCEPTION.Raise_Exception;

394: FND_MESSAGE.SET_TOKEN('CODE',
395: p_risk_phrase_code,
396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;
399: ELSE
400: x_msg_data := FND_MESSAGE.Get;
401: END IF;
402:

Line 406: x_oracle_error := APP_EXCEPTION.Get_Code;

402:
403: WHEN Row_Already_Locked_Error THEN
404: ROLLBACK TO SAVEPOINT Lock_Row;
405: x_return_status := 'E';
406: x_oracle_error := APP_EXCEPTION.Get_Code;
407: FND_MESSAGE.SET_NAME('GR',
408: 'GR_ROW_IS_LOCKED');
409: IF FND_API.To_Boolean(p_called_by_form) THEN
410: APP_EXCEPTION.Raise_Exception;

Line 410: APP_EXCEPTION.Raise_Exception;

406: x_oracle_error := APP_EXCEPTION.Get_Code;
407: FND_MESSAGE.SET_NAME('GR',
408: 'GR_ROW_IS_LOCKED');
409: IF FND_API.To_Boolean(p_called_by_form) THEN
410: APP_EXCEPTION.Raise_Exception;
411: ELSE
412: x_msg_data := FND_MESSAGE.Get;
413: END IF;
414:

Line 418: x_oracle_error := APP_EXCEPTION.Get_Code;

414:
415: WHEN OTHERS THEN
416: ROLLBACK TO SAVEPOINT Lock_Row;
417: x_return_status := 'U';
418: x_oracle_error := APP_EXCEPTION.Get_Code;
419: l_msg_data := APP_EXCEPTION.Get_Text;
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',

Line 419: l_msg_data := APP_EXCEPTION.Get_Text;

415: WHEN OTHERS THEN
416: ROLLBACK TO SAVEPOINT Lock_Row;
417: x_return_status := 'U';
418: x_oracle_error := APP_EXCEPTION.Get_Code;
419: l_msg_data := APP_EXCEPTION.Get_Text;
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,

Line 426: APP_EXCEPTION.Raise_Exception;

422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,
424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;
427: ELSE
428: x_msg_data := FND_MESSAGE.Get;
429: END IF;
430:

Line 512: APP_EXCEPTION.Raise_Exception;

508: x_return_status := l_return_status;
509: x_oracle_error := l_oracle_error;
510: x_msg_data := l_msg_data;
511: IF FND_API.To_Boolean(p_called_by_form) THEN
512: APP_EXCEPTION.Raise_Exception;
513: END IF;
514:
515: WHEN Row_Missing_Error THEN
516: ROLLBACK TO SAVEPOINT Delete_Row;

Line 518: x_oracle_error := APP_EXCEPTION.Get_Code;

514:
515: WHEN Row_Missing_Error THEN
516: ROLLBACK TO SAVEPOINT Delete_Row;
517: x_return_status := 'E';
518: x_oracle_error := APP_EXCEPTION.Get_Code;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_RECORD_NOT_FOUND');
521: FND_MESSAGE.SET_TOKEN('CODE',
522: p_risk_phrase_code,

Line 525: APP_EXCEPTION.Raise_Exception;

521: FND_MESSAGE.SET_TOKEN('CODE',
522: p_risk_phrase_code,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;
526: ELSE
527: x_msg_data := FND_MESSAGE.Get;
528: END IF;
529:

Line 533: x_oracle_error := APP_EXCEPTION.Get_Code;

529:
530: WHEN OTHERS THEN
531: ROLLBACK TO SAVEPOINT Delete_Row;
532: x_return_status := 'U';
533: x_oracle_error := APP_EXCEPTION.Get_Code;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: l_msg_data := APP_EXCEPTION.Get_Text;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_UNEXPECTED_ERROR');

Line 534: l_msg_data := APP_EXCEPTION.Get_Text;

530: WHEN OTHERS THEN
531: ROLLBACK TO SAVEPOINT Delete_Row;
532: x_return_status := 'U';
533: x_oracle_error := APP_EXCEPTION.Get_Code;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: l_msg_data := APP_EXCEPTION.Get_Text;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_UNEXPECTED_ERROR');
538: FND_MESSAGE.SET_TOKEN('TEXT',

Line 535: l_msg_data := APP_EXCEPTION.Get_Text;

531: ROLLBACK TO SAVEPOINT Delete_Row;
532: x_return_status := 'U';
533: x_oracle_error := APP_EXCEPTION.Get_Code;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: l_msg_data := APP_EXCEPTION.Get_Text;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_UNEXPECTED_ERROR');
538: FND_MESSAGE.SET_TOKEN('TEXT',
539: l_msg_data,

Line 542: APP_EXCEPTION.Raise_Exception;

538: FND_MESSAGE.SET_TOKEN('TEXT',
539: l_msg_data,
540: FALSE);
541: IF FND_API.To_Boolean(p_called_by_form) THEN
542: APP_EXCEPTION.Raise_Exception;
543: ELSE
544: x_msg_data := FND_MESSAGE.Get;
545: END IF;
546:

Line 592: x_oracle_error := APP_EXCEPTION.Get_Code;

588:
589: WHEN OTHERS THEN
590: ROLLBACK TO SAVEPOINT Delete_Rows;
591: x_return_status := 'U';
592: x_oracle_error := APP_EXCEPTION.Get_Code;
593: l_msg_data := APP_EXCEPTION.Get_Text;
594: FND_MESSAGE.SET_NAME('GR',
595: 'GR_UNEXPECTED_ERROR');
596: FND_MESSAGE.SET_TOKEN('TEXT',

Line 593: l_msg_data := APP_EXCEPTION.Get_Text;

589: WHEN OTHERS THEN
590: ROLLBACK TO SAVEPOINT Delete_Rows;
591: x_return_status := 'U';
592: x_oracle_error := APP_EXCEPTION.Get_Code;
593: l_msg_data := APP_EXCEPTION.Get_Text;
594: FND_MESSAGE.SET_NAME('GR',
595: 'GR_UNEXPECTED_ERROR');
596: FND_MESSAGE.SET_TOKEN('TEXT',
597: l_msg_token,

Line 686: x_oracle_error := APP_EXCEPTION.Get_Code;

682: WHEN OTHERS THEN
683: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
684:
685: x_return_status := 'U';
686: x_oracle_error := APP_EXCEPTION.Get_Code;
687: l_msg_data := APP_EXCEPTION.Get_Text;
688: FND_MESSAGE.SET_NAME('GR',
689: 'GR_UNEXPECTED_ERROR');
690: FND_MESSAGE.SET_TOKEN('TEXT',

Line 687: l_msg_data := APP_EXCEPTION.Get_Text;

683: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
684:
685: x_return_status := 'U';
686: x_oracle_error := APP_EXCEPTION.Get_Code;
687: l_msg_data := APP_EXCEPTION.Get_Text;
688: FND_MESSAGE.SET_NAME('GR',
689: 'GR_UNEXPECTED_ERROR');
690: FND_MESSAGE.SET_TOKEN('TEXT',
691: l_msg_data,

Line 744: x_oracle_error := APP_EXCEPTION.Get_Code;

740:
741: WHEN OTHERS THEN
742: ROLLBACK TO SAVEPOINT Check_Integrity;
743: x_return_status := 'U';
744: x_oracle_error := APP_EXCEPTION.Get_Code;
745: l_msg_data := APP_EXCEPTION.Get_Text;
746: FND_MESSAGE.SET_NAME('GR',
747: 'GR_UNEXPECTED_ERROR');
748: FND_MESSAGE.SET_TOKEN('TEXT',

Line 745: l_msg_data := APP_EXCEPTION.Get_Text;

741: WHEN OTHERS THEN
742: ROLLBACK TO SAVEPOINT Check_Integrity;
743: x_return_status := 'U';
744: x_oracle_error := APP_EXCEPTION.Get_Code;
745: l_msg_data := APP_EXCEPTION.Get_Text;
746: FND_MESSAGE.SET_NAME('GR',
747: 'GR_UNEXPECTED_ERROR');
748: FND_MESSAGE.SET_TOKEN('TEXT',
749: l_msg_data,

Line 752: APP_EXCEPTION.Raise_Exception;

748: FND_MESSAGE.SET_TOKEN('TEXT',
749: l_msg_data,
750: FALSE);
751: IF FND_API.To_Boolean(p_called_by_form) THEN
752: APP_EXCEPTION.Raise_Exception;
753: ELSE
754: x_msg_data := FND_MESSAGE.Get;
755: END IF;
756:

Line 800: l_msg_data := APP_EXCEPTION.Get_Text;

796:
797: EXCEPTION
798:
799: WHEN Others THEN
800: l_msg_data := APP_EXCEPTION.Get_Text;
801: FND_MESSAGE.SET_NAME('GR',
802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,

Line 807: APP_EXCEPTION.Raise_Exception;

803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);
806: IF FND_API.To_Boolean(p_called_by_form) THEN
807: APP_EXCEPTION.Raise_Exception;
808: END IF;
809:
810: END Check_Primary_Key;
811: