250:
251: IF (C%NOTFOUND) THEN
252: CLOSE C;
253: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
254: APP_EXCEPTION.Raise_Exception;
255: END IF;
256:
257: CLOSE C;
258:
321: RETURN;
322: ELSE
323: cep_standard.debug('form_record_changed');
324: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
325: APP_EXCEPTION.Raise_Exception;
326: END IF;
327: cep_standard.debug('<
329:
535: IF chk_duplicates%FOUND THEN
536: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE');
537: CLOSE chk_duplicates;
538: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE' );
539: app_exception.raise_exception;
540: END IF;
541:
542: CLOSE chk_duplicates;
543:
547: IF chk_duplicates2%FOUND THEN
548: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE_COMB2');
549: CLOSE chk_duplicates2;
550: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB2' );
551: app_exception.raise_exception;
552: END IF;
553:
554: CLOSE chk_duplicates2;
555:
559: IF chk_duplicates3%FOUND THEN
560: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE_COMB1');
561: CLOSE chk_duplicates3;
562: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB1' );
563: app_exception.raise_exception;
564: END IF;
565:
566: CLOSE chk_duplicates3;
567:
566: CLOSE chk_duplicates3;
567:
568: cep_standard.debug('<
570: WHEN app_exceptions.application_exception THEN
571: IF ( chk_duplicates%ISOPEN ) THEN
572: CLOSE chk_duplicates;
573: END IF;
574: IF ( chk_duplicates2%ISOPEN ) THEN
647: RETURN FALSE;
648:
649: cep_standard.debug('<
651: WHEN app_exceptions.application_exception THEN
652: cep_standard.debug('EXCEPTION: Application_exception CE_TRANSACTION_CODES_pkg.Is_In_Use');
653: IF ( chk_stmt_line%ISOPEN ) THEN
654: CLOSE chk_stmt_line;
655: END IF;