144: ' tax_category_id = ' || to_char(X_tax_category_id) ||
145: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
146: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
147: END IF;
148: APP_EXCEPTION.RAISE_EXCEPTION;
149:
150: END Insert_Row;
151:
152: PROCEDURE Lock_Row
249: IF (C%NOTFOUND) THEN
250: debug_info := 'Close cursor C - DATA NOTFOUND';
251: CLOSE C;
252: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
253: APP_EXCEPTION.Raise_Exception;
254: END IF;
255: debug_info := 'Close cursor C';
256: CLOSE C;
257:
334: (X_attribute15 IS NULL)))) THEN
335: return;
336: ELSE
337: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
338: APP_EXCEPTION.Raise_Exception;
339: END IF;
340:
341: EXCEPTION
342: WHEN OTHERS THEN
355: 'end_date_active = ' || X_end_date_active );
356: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
357: END IF;
358: END IF;
359: APP_EXCEPTION.RAISE_EXCEPTION;
360: END Lock_Row;
361:
362: PROCEDURE Update_Row
363: (X_rowid VARCHAR2,
487: ' fiscal_classification_code = '||X_fiscal_classification_code||
488: ' tax_category_id = ' || X_tax_category_id ||
489: ' end_date_active = ' || X_end_date_active );
490: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
491: APP_EXCEPTION.RAISE_EXCEPTION;
492: END IF;
493: END Check_Unique;
494:
495: PROCEDURE Check_Overlapped_Dates
538: ' fiscal_classification_code ='||X_fiscal_classification_code||
539: ' tax_category_id = ' || X_tax_category_id ||
540: ' end_date_active = ' || X_end_date_active );
541: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
542: APP_EXCEPTION.RAISE_EXCEPTION;
543: END IF;
544: END Check_Overlapped_Dates;
545:
546: PROCEDURE Check_Gaps
622: ' fiscal_classification_code = '||X_fiscal_classification_code ||
623: ' tax_category_id = ' || X_tax_category_id ||
624: ' end_date_active = ' || X_end_date_active );
625: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
626: APP_EXCEPTION.RAISE_EXCEPTION;
627: END IF;
628: END;
629: END IF;
630: END;