211: open c;
212: fetch c into recinfo;
213: if (c%notfound) then
214: close c;
215: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
216: app_exception.raise_exception;
217: end if;
218: close c;
219: if ( (recinfo.LABEL_TYPE = X_LABEL_TYPE)
219: if ( (recinfo.LABEL_TYPE = X_LABEL_TYPE)
220: ) then
221: null;
222: else
223: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
224: app_exception.raise_exception;
225: end if;
226:
227: for tlinfo in c1 loop
239: AND (tlinfo.URL= X_URL)
240: ) then
241: null;
242: else
243: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
244: app_exception.raise_exception;
245: end if;
246: end if;
247: end loop;
492: AND LABEL_ID = X_LABEL_ID
493: AND LABEL_TYPE = 2;
494: -- AND LAST_UPDATE_DATE <= X_LAST_UPDATE_DATE;
495: ELSE
496: FND_MESSAGE.SET_NAME('BSC', 'NO DATA FOUND');
497: FND_MESSAGE.SET_TOKEN('PACKAGE', 'BSC_TAB_VIEW_LABELS_PKG');
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
493: AND LABEL_TYPE = 2;
494: -- AND LAST_UPDATE_DATE <= X_LAST_UPDATE_DATE;
495: ELSE
496: FND_MESSAGE.SET_NAME('BSC', 'NO DATA FOUND');
497: FND_MESSAGE.SET_TOKEN('PACKAGE', 'BSC_TAB_VIEW_LABELS_PKG');
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
494: -- AND LAST_UPDATE_DATE <= X_LAST_UPDATE_DATE;
495: ELSE
496: FND_MESSAGE.SET_NAME('BSC', 'NO DATA FOUND');
497: FND_MESSAGE.SET_TOKEN('PACKAGE', 'BSC_TAB_VIEW_LABELS_PKG');
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);
495: ELSE
496: FND_MESSAGE.SET_NAME('BSC', 'NO DATA FOUND');
497: FND_MESSAGE.SET_TOKEN('PACKAGE', 'BSC_TAB_VIEW_LABELS_PKG');
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);
503: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_LABEL_ID');
496: FND_MESSAGE.SET_NAME('BSC', 'NO DATA FOUND');
497: FND_MESSAGE.SET_TOKEN('PACKAGE', 'BSC_TAB_VIEW_LABELS_PKG');
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);
503: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_LABEL_ID');
504: FND_MESSAGE.SET_TOKEN('VALUE', X_LABEL_ID);
497: FND_MESSAGE.SET_TOKEN('PACKAGE', 'BSC_TAB_VIEW_LABELS_PKG');
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);
503: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_LABEL_ID');
504: FND_MESSAGE.SET_TOKEN('VALUE', X_LABEL_ID);
505: APP_EXCEPTION.RAISE_EXCEPTION;
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);
503: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_LABEL_ID');
504: FND_MESSAGE.SET_TOKEN('VALUE', X_LABEL_ID);
505: APP_EXCEPTION.RAISE_EXCEPTION;
506: END IF;
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);
503: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_LABEL_ID');
504: FND_MESSAGE.SET_TOKEN('VALUE', X_LABEL_ID);
505: APP_EXCEPTION.RAISE_EXCEPTION;
506: END IF;
507: END UPDATE_LINK;
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);
503: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_LABEL_ID');
504: FND_MESSAGE.SET_TOKEN('VALUE', X_LABEL_ID);
505: APP_EXCEPTION.RAISE_EXCEPTION;
506: END IF;
507: END UPDATE_LINK;
508: