820: AND BOS.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM);
821: END IF;
822: EXCEPTION
823: WHEN DUP_VAL_ON_INDEX THEN
824: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMP_OP_COMBINATION');
825: APP_EXCEPTION.RAISE_EXCEPTION;
826: WHEN OTHERS THEN
827: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'SET_OP_SEQ',
828: stmt_num => X_stmt_num,
876: IF (DUMMY <> 0)
877: THEN
878: IF (X_unit_assembly = 'Y')
879: THEN
880: FND_MESSAGE.SET_NAME('BOM', 'BOM_UNIT_OVERLAP');
881: ELSE
882: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMP_OP_COMBINATION');
883: END IF;
884: APP_EXCEPTION.RAISE_EXCEPTION;
878: IF (X_unit_assembly = 'Y')
879: THEN
880: FND_MESSAGE.SET_NAME('BOM', 'BOM_UNIT_OVERLAP');
881: ELSE
882: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMP_OP_COMBINATION');
883: END IF;
884: APP_EXCEPTION.RAISE_EXCEPTION;
885: END IF;
886: END LOOP;
971: NVL(BIC.DISABLE_DATE - 1, BIC2.EFFECTIVITY_DATE + 1))));
972:
973: IF (DUMMY <> 0) THEN
974: IF (X_unit_assembly = 'Y') THEN
975: FND_MESSAGE.SET_NAME('BOM', 'BOM_UNIT_OVERLAP');
976: ELSE
977: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMP_OP_COMBINATION');
978: END IF;
979: APP_EXCEPTION.RAISE_EXCEPTION;
973: IF (DUMMY <> 0) THEN
974: IF (X_unit_assembly = 'Y') THEN
975: FND_MESSAGE.SET_NAME('BOM', 'BOM_UNIT_OVERLAP');
976: ELSE
977: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMP_OP_COMBINATION');
978: END IF;
979: APP_EXCEPTION.RAISE_EXCEPTION;
980: END IF;
981: */