DBA Data[Home] [Help]

APPS.OE_PC_RSETS_PKG dependencies on APP_EXCEPTION

Line 209: APP_EXCEPTION.Raise_Exception;

205: Fetch C into Recinfo;
206: if (C%NOTFOUND) then
207: Close C;
208: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
209: APP_EXCEPTION.Raise_Exception;
210: end if;
211: Close C;
212: if (
213: (Recinfo.record_set_id = x_record_set_id)

Line 229: APP_EXCEPTION.Raise_Exception;

225: ) then
226: return;
227: else
228: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
229: APP_EXCEPTION.Raise_Exception;
230: end if;
231:
232: Open C1;
233: Fetch C1 into tlinfo;

Line 237: APP_EXCEPTION.Raise_Exception;

233: Fetch C1 into tlinfo;
234: if (C1%NOTFOUND) then
235: Close C1;
236: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
237: APP_EXCEPTION.Raise_Exception;
238: end if;
239: Close C1;
240:
241: if (

Line 255: APP_EXCEPTION.Raise_Exception;

251: ) then
252: return;
253: else
254: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
255: APP_EXCEPTION.Raise_Exception;
256: end if;
257:
258: End Lock_Row;
259:

Line 464: app_exception.raise_exception;

460: WHERE record_set_id = x_record_set_id);
461: EXCEPTION
462: WHEN NO_DATA_FOUND THEN
463: fnd_message.set_name('ONT', 'OE_PC_RS_REF_EXISTS');
464: app_exception.raise_exception;
465: End Check_References;
466:
467: -----------------------------------------------------------------------
468: PROCEDURE Check_Unique(

Line 505: app_exception.raise_exception;

501: AND ((x_rowid IS null) OR (row_id <> x_rowid));
502:
503: if (dummy >= 1) then
504: fnd_message.set_name('ONT', 'OE_PC_RS_DUP_DISPLAY_NAME');
505: app_exception.raise_exception;
506: end if;
507: end if;
508:
509: if (chk_short_name = TRUE) then

Line 520: app_exception.raise_exception;

516: AND ((x_rowid IS null) OR (rowid <> x_rowid));
517:
518: if (dummy >= 1) then
519: fnd_message.set_name('ONT', 'OE_PC_RS_DUP_SHORT_NAME');
520: app_exception.raise_exception;
521: end if;
522: end if;
523: if (chk_pk_flag = TRUE) then
524: -- there can be only one record set with pk_record_set_flag = Y

Line 535: app_exception.raise_exception;

531: AND ((x_rowid IS null) OR (rowid <> x_rowid));
532:
533: if (dummy >= 1) then
534: fnd_message.set_name('ONT', 'OE_PC_PK_RS_EXISTS');
535: app_exception.raise_exception;
536: end if;
537: end if;
538:
539: End Check_Unique;