DBA Data[Home] [Help]

APPS.EDW_SOURCE_INSTANCES_PKG dependencies on APP_EXCEPTION

Line 36: app_exception.raise_exception; */

32: if (dummy > 0) then /* throw error message */
33: /*fnd_message.set_name('BIS', 'EDW_SOURCE_ALREADY_PRESENT');
34: fnd_message.set_token('NAME',
35: X_WAREHOUSE_TO_INSTANCE_LINK, FALSE);
36: app_exception.raise_exception; */
37: l_bool := false;
38: else
39: l_bool := true;
40: end if;

Line 165: app_exception.raise_exception;

161: fetch c into recinfo;
162: if (c%notfound) then
163: close c;
164: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
165: app_exception.raise_exception;
166: end if;
167: close c;
168: if ( /*((recinfo.ENABLED_FLAG = X_ENABLED_FLAG)
169: OR ((recinfo.ENABLED_FLAG is null)

Line 181: app_exception.raise_exception;

177: ) then
178: null;
179: else
180: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
181: app_exception.raise_exception;
182: end if;
183:
184: for tlinfo in c1 loop
185: if (tlinfo.BASELANG = 'Y') then

Line 194: app_exception.raise_exception;

190: ) then
191: null;
192: else
193: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
194: app_exception.raise_exception;
195: end if;
196: end if;
197: end loop;
198: return;

Line 415: app_exception.raise_exception;

411: IF (dummy >= 1) THEN
412: fnd_message.set_name('BIS', 'EDW_DUPLICATE_INSTANCE');
413: fnd_message.set_token('INSTANCE_CODE',
414: x_instance_code, FALSE);
415: app_exception.raise_exception;
416: END IF;
417:
418: END CHECK_UNIQUE;
419:

Line 432: app_exception.raise_exception;

428:
429: EXCEPTION
430: WHEN NO_DATA_FOUND THEN
431: fnd_message.set_name('BIS', 'EDW_INSTANCE_IN_USE');
432: app_exception.raise_exception;
433: END CHECK_REFERENCES;
434:
435:
436: procedure CHECK_UNIQUE_NAME (

Line 454: app_exception.raise_exception;

450: IF (dummy >= 1) THEN
451: fnd_message.set_name('BIS', 'EDW_DUPLICATE_INSTANCE_NAME');
452: fnd_message.set_token('INSTANCE_CODE', X_ROWID, FALSE);
453: --x_instance_name, FALSE);
454: app_exception.raise_exception;
455: END IF;
456: END CHECK_UNIQUE_NAME;
457:
458: procedure CHECK_UNIQUE_DBLINK (

Line 473: app_exception.raise_exception;

469: IF (dummy >= 1) THEN
470: fnd_message.set_name('BIS', 'EDW_DBLINK_ALREADY_USED');
471: fnd_message.set_token('DBLINK',
472: x_dblink, FALSE);
473: app_exception.raise_exception;
474: END IF;
475: END CHECK_UNIQUE_DBLINK;
476:
477:

Line 562: app_exception.raise_exception;

558:
559: EXCEPTION
560: WHEN e_too_many_local_instances THEN
561: fnd_message.set_name('BIS', 'EDW_TOO_MANY_LOCAL_INSTANCES');
562: app_exception.raise_exception;
563: WHEN others THEN
564: IF (X_ENABLED_FLAG = 'N') THEN
565: null;
566: ELSE

Line 567: app_exception.raise_exception;

563: WHEN others THEN
564: IF (X_ENABLED_FLAG = 'N') THEN
565: null;
566: ELSE
567: app_exception.raise_exception;
568: END IF;
569: END INSERT_ROW_REMOTE;
570:
571: procedure DELETE_ROW_REMOTE (