DBA Data[Home] [Help]

APPS.GR_EIN_HAZARDS_PKG dependencies on APP_EXCEPTION

Line 123: APP_EXCEPTION.Raise_Exception;

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

Line 131: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 138: APP_EXCEPTION.Raise_Exception;

134: FND_MESSAGE.SET_TOKEN('CODE',
135: p_european_index_number||' '||p_hazard_classification_code,
136: FALSE);
137: IF FND_API.To_Boolean(p_called_by_form) THEN
138: APP_EXCEPTION.Raise_Exception;
139: ELSE
140: x_msg_data := FND_MESSAGE.Get;
141: END IF;
142:

Line 146: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 154: APP_EXCEPTION.Raise_Exception;

150: p_european_index_number,
151: FALSE);
152: x_msg_data := FND_MESSAGE.Get;
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 170: APP_EXCEPTION.Raise_Exception;

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

Line 261: APP_EXCEPTION.Raise_Exception;

257: FND_MESSAGE.SET_TOKEN('TEXT',
258: l_msg_data,
259: FALSE);
260: IF FND_API.To_Boolean(p_called_by_form) THEN
261: APP_EXCEPTION.Raise_Exception;
262: ELSE
263: x_msg_data := FND_MESSAGE.Get;
264: END IF;
265:

Line 269: x_oracle_error := APP_EXCEPTION.Get_Code;

265:
266: WHEN Row_Missing_Error THEN
267: ROLLBACK TO SAVEPOINT Update_Row;
268: x_return_status := 'E';
269: x_oracle_error := APP_EXCEPTION.Get_Code;
270: FND_MESSAGE.SET_NAME('GR',
271: 'GR_NO_RECORD_INSERTED');
272: FND_MESSAGE.SET_TOKEN('CODE',
273: p_european_index_number||' '||p_hazard_classification_code,

Line 276: APP_EXCEPTION.Raise_Exception;

272: FND_MESSAGE.SET_TOKEN('CODE',
273: p_european_index_number||' '||p_hazard_classification_code,
274: FALSE);
275: IF FND_API.To_Boolean(p_called_by_form) THEN
276: APP_EXCEPTION.Raise_Exception;
277: ELSE
278: x_msg_data := FND_MESSAGE.Get;
279: END IF;
280:

Line 292: APP_EXCEPTION.Raise_Exception;

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

Line 377: APP_EXCEPTION.Raise_Exception;

373: FND_MESSAGE.SET_TOKEN('CODE',
374: p_european_index_number||' '||p_hazard_classification_code,
375: FALSE);
376: IF FND_API.To_Boolean(p_called_by_form) THEN
377: APP_EXCEPTION.Raise_Exception;
378: ELSE
379: x_msg_data := FND_MESSAGE.Get;
380: END IF;
381: WHEN RECORD_CHANGED_ERROR THEN

Line 387: APP_EXCEPTION.Raise_Exception;

383: X_return_status := 'E';
384: FND_MESSAGE.SET_NAME('FND',
385: 'FORM_RECORD_CHANGED');
386: IF FND_API.To_Boolean(p_called_by_form) THEN
387: APP_EXCEPTION.Raise_Exception;
388: ELSE
389: x_msg_data := FND_MESSAGE.Get;
390: END IF;
391: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 391: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

387: APP_EXCEPTION.Raise_Exception;
388: ELSE
389: x_msg_data := FND_MESSAGE.Get;
390: END IF;
391: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
392: ROLLBACK TO SAVEPOINT Lock_Row;
393: x_return_status := 'L';
394: x_oracle_error := APP_EXCEPTION.Get_Code;
395: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 394: x_oracle_error := APP_EXCEPTION.Get_Code;

390: END IF;
391: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
392: ROLLBACK TO SAVEPOINT Lock_Row;
393: x_return_status := 'L';
394: x_oracle_error := APP_EXCEPTION.Get_Code;
395: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
396: FND_MESSAGE.SET_NAME('GR',
397: 'GR_ROW_IS_LOCKED');
398: x_msg_data := FND_MESSAGE.Get;

Line 411: APP_EXCEPTION.Raise_Exception;

407: FND_MESSAGE.SET_TOKEN('TEXT',
408: l_msg_data,
409: FALSE);
410: IF FND_API.To_Boolean(p_called_by_form) THEN
411: APP_EXCEPTION.Raise_Exception;
412: ELSE
413: x_msg_data := FND_MESSAGE.Get;
414: END IF;
415:

Line 482: APP_EXCEPTION.Raise_Exception;

478: ROLLBACK TO SAVEPOINT Delete_Row;
479: x_return_status := l_return_status;
480: x_oracle_error := l_oracle_error;
481: IF FND_API.To_Boolean(p_called_by_form) THEN
482: APP_EXCEPTION.Raise_Exception;
483: ELSE
484: x_msg_data := FND_MESSAGE.Get;
485: END IF;
486:

Line 490: x_oracle_error := APP_EXCEPTION.Get_Code;

486:
487: WHEN Row_Missing_Error THEN
488: ROLLBACK TO SAVEPOINT Delete_Row;
489: x_return_status := 'E';
490: x_oracle_error := APP_EXCEPTION.Get_Code;
491: FND_MESSAGE.SET_NAME('GR',
492: 'GR_RECORD_NOT_FOUND');
493: FND_MESSAGE.SET_TOKEN('CODE',
494: p_european_index_number||' '||p_hazard_classification_code,

Line 497: APP_EXCEPTION.Raise_Exception;

493: FND_MESSAGE.SET_TOKEN('CODE',
494: p_european_index_number||' '||p_hazard_classification_code,
495: FALSE);
496: IF FND_API.To_Boolean(p_called_by_form) THEN
497: APP_EXCEPTION.Raise_Exception;
498: ELSE
499: x_msg_data := FND_MESSAGE.Get;
500: END IF;
501:

Line 513: APP_EXCEPTION.Raise_Exception;

509: FND_MESSAGE.SET_TOKEN('TEXT',
510: l_msg_data,
511: FALSE);
512: IF FND_API.To_Boolean(p_called_by_form) THEN
513: APP_EXCEPTION.Raise_Exception;
514: ELSE
515: x_msg_data := FND_MESSAGE.Get;
516: END IF;
517:

Line 571: APP_EXCEPTION.Raise_Exception;

567: FND_MESSAGE.SET_TOKEN('TEXT',
568: l_msg_token,
569: FALSE);
570: IF FND_API.To_Boolean(p_called_by_form) THEN
571: APP_EXCEPTION.Raise_Exception;
572: ELSE
573: x_msg_data := FND_MESSAGE.Get;
574: END IF;
575:

Line 623: x_oracle_error := APP_EXCEPTION.Get_Code;

619: FETCH c_get_hazards INTO HazClassRecord;
620: IF c_get_hazards%NOTFOUND THEN
621: l_msg_token := p_hazard_classification_code;
622: x_return_status := 'E';
623: x_oracle_error := APP_EXCEPTION.Get_Code;
624: FND_MESSAGE.SET_NAME('GR',
625: 'GR_RECORD_NOT_FOUND');
626: FND_MESSAGE.SET_TOKEN('CODE',
627: l_msg_token,

Line 702: APP_EXCEPTION.Raise_Exception;

698: FND_MESSAGE.SET_TOKEN('TABLES',
699: l_msg_data,
700: FALSE);
701: IF FND_API.To_Boolean(p_called_by_form) THEN
702: APP_EXCEPTION.Raise_Exception;
703: ELSE
704: x_msg_data := FND_MESSAGE.Get;
705: END IF;
706: WHEN OTHERS THEN

Line 717: APP_EXCEPTION.Raise_Exception;

713: FND_MESSAGE.SET_TOKEN('TEXT',
714: l_msg_data,
715: FALSE);
716: IF FND_API.To_Boolean(p_called_by_form) THEN
717: APP_EXCEPTION.Raise_Exception;
718: ELSE
719: x_msg_data := FND_MESSAGE.Get;
720: END IF;
721:

Line 766: APP_EXCEPTION.Raise_Exception;

762: FND_MESSAGE.SET_TOKEN('TEXT',
763: l_msg_data,
764: FALSE);
765: IF FND_API.To_Boolean(p_called_by_form) THEN
766: APP_EXCEPTION.Raise_Exception;
767: END IF;
768:
769: END Check_Primary_Key;
770: