APPS.EDW_SOURCE_INSTANCES_PKG dependencies on FND_MESSAGE

Line 33: /*fnd_message.set_name('BIS', 'EDW_SOURCE_ALREADY_PRESENT');

29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);
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;

Line 34: fnd_message.set_token('NAME',

30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);
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

Line 164: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

160: open c;
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)

Line 180: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

176: AND (X_INSTANCE_CODE is null)))
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

Line 193: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

189: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
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;

Line 412: fnd_message.set_name('BIS', 'EDW_DUPLICATE_INSTANCE');

408: WHERE INSTANCE_CODE = X_INSTANCE_CODE
409: AND ((X_ROWID IS NULL) OR (ROW_ID <> X_ROWID));
410:
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;

Line 413: fnd_message.set_token('INSTANCE_CODE',

409: AND ((X_ROWID IS NULL) OR (ROW_ID <> X_ROWID));
410:
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:

Line 431: fnd_message.set_name('BIS', 'EDW_INSTANCE_IN_USE');

427: WHERE INSTANCE_CODE = X_INSTANCE_CODE);
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:

Line 451: fnd_message.set_name('BIS', 'EDW_DUPLICATE_INSTANCE_NAME');

447:
448:
449:
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;

Line 452: fnd_message.set_token('INSTANCE_CODE', X_ROWID, FALSE);

448:
449:
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;

Line 470: fnd_message.set_name('BIS', 'EDW_DBLINK_ALREADY_USED');

466: WHERE WAREHOUSE_TO_INSTANCE_LINK = X_DBLINK
467: AND ((X_ROWID IS NULL) OR (ROW_ID <> X_ROWID));
468:
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;

Line 471: fnd_message.set_token('DBLINK',

467: AND ((X_ROWID IS NULL) OR (ROW_ID <> X_ROWID));
468:
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;

Line 561: fnd_message.set_name('BIS', 'EDW_TOO_MANY_LOCAL_INSTANCES');

557: dbms_sql.close_cursor(v_cursor_id);
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;